What is a database?
A database is an organized collection of data electronically stored and managed from a computer system. This system is used to hold large sets of data in a structured manner and make them easily accessible to authorized users.
Databases allow users to keep an archive of past and present data records from specific systems. They are used across a wide variety of industries, from banks tracking customer balances and deposits, to retail stores saving purchase histories and consumer interests. Adding a database to your site will allow you to create a membership site that collects member data, as well as store user information and preferences.
Evolution of Databases
Computerized databases were first developed in the 1960s. Since then, the simplicity of the original types of databases evolved into the complex systems used nowadays. Three main forms of databases powered the development of the technologies we know today:
Flat databases recorded plain text or binary files with no structural indexing between different sets of data. As a result, they offered very limited functionality.
Hierarchical databases appeared shortly after, introducing a tree structure that mapped the “parent-child” relationship between data records.
Network databases took the hierarchical structure and improved it by allowing datasets to be associated with multiple parent records, thus creating a more complex network. These databases became widely popular throughout the 1970s, before being replaced by relational databases during the 1980s.
You may also be interested in:
Types of databases
There is a wide variety of database types depending on usage requirements. These are the most common among them:
Relational databases organize data file relationships in the form of tables, assigning a connection between every single piece of information and the rest of the database. This type of database became the dominant choice in the 1980s, and is still considered one of the most mature systems to this day.
Object-oriented databases store all types of data in the form of objects, following the object-oriented programming paradigm. These objects can be easily referenced and called using a series of attributes and methods, thus significantly reducing the workload on the database.
Distributed databases record information across diverse sites of an organization connected to each other via communication links. Data can be collected from the common database as well as local computers, and is easily accessible from any site.
NoSQL databases, also known as non-relational databases, provide non-tabular mechanisms for the storage and manipulation of unstructured and semistructured data. There are several types of NoSQL databases based on their data model, with the most common ones being document, key-value stores, wide-column, and graph.
Cloud databases are those optimized for deployment on virtualized environments, including both public and private cloud platforms, as well as hybrid cloud systems. Also known as database as service (DBaaS), this type of database is rapidly becoming a cross-industry standard.