Talk:SQL
From APIDesign
(→SMJ said ...) |
|||
| Line 1: | Line 1: | ||
| + | === [[wikipedia:Multidimensional_Expressions|MDX]] === | ||
| + | |||
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 ... == | + | |
| + | === . said ... === | ||
<div class='commentBlock'> | <div class='commentBlock'> | ||
| Line 17: | Line 20: | ||
--. 07:24, 1 September 2010 (CEST) | --. 07:24, 1 September 2010 (CEST) | ||
</div> | </div> | ||
| - | == SMJ said ... == | + | |
| + | === SMJ said ... === | ||
<div class='commentBlock'> | <div class='commentBlock'> | ||
Revision as of 07:08, 1 September 2010
MDX
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.
. said ...
SMJ said ...
No valid point was made! This article is complete nonsense and grammatically deficient at that. Try some number agreement on your statements! The author shows how little he or she knows about the subject by creating new terms at will. SQL is neither modeling nor a database: it is a query language. It is right in the name Q is for query! Just like in OQL (object query language) Should your query performance be poor, ask for assistance from an expert: you are doing plenty wrong. 30 years of industry experience getting it right says this author is bogus, or at least too inexperienced to speak on this topic.
--SMJ 07:51, 1 September 2010 (CEST)
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)