2 ms·
I do work with denormalized data structures and schemas as well, but that data is usually derived from a normalized source and it's read-only. All the issues re
by fauigerzigerk 17y ago
I do work with denormalized data structures and schemas as well, but that data is usually derived from a normalized source and it's read-only. All the issues related to redundancy don't exist in a DW/BI scenario.
One area where SQL is clearly limiting is text processing and I'm doing a lot of that. There's just no way you could do text analytics in a regular SQL database. I'm sure there are other areas like that, so I agree with you that innovation in the database space is welcome, even if it has acquired that slightly unfortunate name "NoSQL".