This post is an introduction to databases. Database Properties Database properties featured on this post: ACID Database Transaction Properties ACID (atomicity, consistency, isolation, durability) is a set of desired properties regarding database transactions. ACID at Wikipedia CRUD Persistent Storage Operations…
This post explains some aspects of IT security on databases. It is part of the main post about introduction to IT security. Database Controls Database controls featured on this post: Server-side input validation Please remind that client-side input validation is…
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 an introduction to free and open data licenses. List of Open Data Licenses Open data licenses: Open content licenses like Creative Commons also apply. PPDL Open Data Commons Public Domain Dedication and Licence (PPDL). It is published…
This post provides links to check the Support Lifecycle, End of Life (EoL), End of Support (EoS), versioning or road map dates for popular databases. List of Databases Support Lifecycle Dates List of databases lifecycles featured on this post: Oracle…
This post summarizes some aspects on web development. Web Development Basic Learning Path If you want to learn web development, the increasing knowledge you need to get could be summarized as below: 1. Web Markup Languages (HTML) HTML is a…
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…
NoSQL databases refer to any database types that are not only relational. “NoSQL” stands for “not only SQL”. Relational database is the most popular database type nowadays. Structure Query Language (SQL) is a language to manage data in a relational…