Talk:SQL
From APIDesign
(Difference between revisions)
(Comment provided by . - via ArticleComments extension) |
|||
| Line 1: | Line 1: | ||
I'd go with the idea that [[wikipedia:Multidimensional_Expressions|MDX]] are far superior for actual data mining and data-model construction. [[SQL]] does not natively represent complex data structures well. That said, [[SQL]] will probably remain around for quite some time -- it is easy, known, and fast. | I'd go with the idea that [[wikipedia:Multidimensional_Expressions|MDX]] are far superior for actual data mining and data-model construction. [[SQL]] does not natively represent complex data structures well. That said, [[SQL]] will probably remain around for quite some time -- it is easy, known, and fast. | ||
| + | == . said ... == | ||
| + | |||
| + | <div class='commentBlock'> | ||
| + | my friend - sql is an abomination so is html the standards are formulated so it's easy to learn and train mass mart engineers that are clueless most of the times anyway; only a hand full of people realize these problems: you're one of them. | ||
| + | |||
| + | Spatial databases has been around for ages in fact much longer than relational but harder to grasp hence the majority of sheep flock the other way. | ||
| + | |||
| + | Here it sounds like bugzilla simply made a poor or short sighted architectural/design decision - you cannot blame them for this they used what they know is best at the time. Lots of relational database today have wrappers for MDX allowing you to query a relational database in that form. Some even have special tools that cache index information on spatial form. | ||
| + | |||
| + | A mature or long running system normally indicates these problems you speak of. | ||
| + | |||
| + | No use crapping about it; hence the oppertunity presents itself to introduce similar wrappers for whatever database bugzilla runs on, maybe MySQL. | ||
| + | |||
| + | I'd think hibernate to be a worthy candidate if they don't have it already.... !!! | ||
| + | |||
| + | --. 07:24, 1 September 2010 (CEST) | ||
| + | </div> | ||
Revision as of 05:24, 1 September 2010
I'd go with the idea that MDX are far superior for actual data mining and data-model construction. SQL does not natively represent complex data structures well. That said, SQL will probably remain around for quite some time -- it is easy, known, and fast.
Follow
my friend - sql is an abomination so is html the standards are formulated so it's easy to learn and train mass mart engineers that are clueless most of the times anyway; only a hand full of people realize these problems: you're one of them.
Spatial databases has been around for ages in fact much longer than relational but harder to grasp hence the majority of sheep flock the other way.
Here it sounds like bugzilla simply made a poor or short sighted architectural/design decision - you cannot blame them for this they used what they know is best at the time. Lots of relational database today have wrappers for MDX allowing you to query a relational database in that form. Some even have special tools that cache index information on spatial form.
A mature or long running system normally indicates these problems you speak of.
No use crapping about it; hence the oppertunity presents itself to introduce similar wrappers for whatever database bugzilla runs on, maybe MySQL.
I'd think hibernate to be a worthy candidate if they don't have it already.... !!!
--. 07:24, 1 September 2010 (CEST)