It’s tempting just to replicate all databases in the cloud, but it’s a much better approach to get your data house in order as part of the move. Last week I discussed database normalization as a best ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Jinsong Yu shares deep architectural insights ...

I have an order table that is an order for a customer. I need to reference as a foreign key an unknown number of products that could make up the order (product_id) how do I do this? What am I missing.

Normalization: How far is far enough? Your email has been sent Normalization is one of the commandments of IT database pros, whether you are a data modeler, DBA, or SQL developer. Arthur Fuller ...

Many people seem to become filled with anxiety over the word “normalization.” Mentioning the word causes folks to slowly back away toward the exits. Why? What might have caused this data modeling ...

Good software habits apply to databases too. Trust in these little design tips to build a useful, rot-resistant database schema. It is a universal truth that everything in software eventually rots.

Graph databases are the fastest growing category in all of data management, according to DB-Engines.com, a database consultancy. Since seeing early adoption by companies including Twitter, Facebook ...