This post is an introduction to databases. Database Paradigms Types of databases: You can find an introduction to relational databases on this post. NoSQL are all those databases that are not relational. You can find a list of NoSQL databases…
This post explains some aspects of IT security on databases. It is part of the main post about introduction to IT security. Database Concurrency Issues Lost updates occur when one transaction writes a value to the database that overwrites a…
Document store database are NoSQL databases. List of Document Store Databases Document stores are specifically designed to handle JSON-like documents. Document store solutions: Apache CouchDB Apache CouchDB is a document store database. It is FOSS, under an Apache 2.0 license.…
Entity relationship (ER) Model is a software engineering model that was developed to represent databases. They were first developed by Peter Chen and published in the paper “The Entity Relationship Model – Toward a Unified View of Data” in 1976.…
Tabular or relational databases are those that can be organized in tables. In opposition to tabular or relational databases there is NoSQL databases. Relational Database Design Aspects related to relational database design: Relational Database Modeling Relational databases can be designed…
This post is about how to normalize a relational database. You can read a post as an introduction to relational databases. In the context of relational databases, normalization goal is a procedure to reduce redundancy and avoid issues while updating…