4 ms·

relational folks can denormalize when they want to

• sqrt17 16y ago
  They get strangled by their DBA before they're finished with it. And: the point of document stores is that you can denormalize (i.e. put lots of stuff into one data item) and _still_ use indices into the lots of stuff. Most commercial RDBMSes have means and ways to do that (e.g. storage of XML content), but afaik it's not standardized and would tie you closely to a single ($$$$$$) database vendor who will not hesitate to make you bleed whenever they can.
  • fedd 16y ago
    the things like olap and intentional denormalization is not that dba are against of. by denormalization i didnt mean keeping xml in a clob, but keeping the values in a row as if several tables are already joined into one wide table, thus eliminating the need in joins.