One of the principles within relational theory is that each entity’s row or tuple be uniquely identifiable. This means the defined structure includes some combination of attributes whose populated ...

Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with content, and download exclusive resources. Dany Lepage discusses the architectural ...

10 tips for choosing between a surrogate and natural primary key Your email has been sent The superiority of surrogate versus natural keys is a hotly debated topic among database developers. Susan ...

NoSQL entered the scene nearly six years ago as an alternative to traditional relational databases. The offerings from the major relational vendors couldn’t cut it in terms of the cost, scalability, ...

The development of database technology is one of the defining achievements of the information technology era. It not only has been the key to dramatically improved record-keeping and business process ...