A database is an organized collection of data , generally stored and accessed electronically from a computer system. The database is usually controlled by a database management system (DBMS)
Today most common database types using in operations often use modeling rows and columns in a series of tables to make processing and querying data efficient. In this way, data can be easily accessed, managed, modified, updated, controlled and organized. Most databases use structured query language (SQL) for data writing and querying.
What is Structured Query Language (SQL)?
SQL is a programming language used in almost all relational databases to query, manipulate and define data and also provide access control. SQL was first developed in IBM in the 1970s with the great contributions of Oracle, and then the SQL ANSI standard was applied . Companies such as IBM, Oracle and Microsoft created and used many SQl extensions.
Evolution of the Database
Databases have undergone a radical evolution since they appeared in the early 1960s. Navigational databases such as a hierarchical database (based on a tree-like model and allowing only one source to multiple recipients) and network database (a more flexible model that allows multiple relationships) were the original systems used to store and manipulate data. These early systems were simple and flexible. Relational databases became popular in the 1980s, and then object oriented databases appeared in the 1990s. More recently, NoSQL databases began to be used in response to the need for the growth of the internet and the faster processing of unstructured data. Today, cloud databases and self-managing databases are groundbreaking in collecting, storing, managing and using data.
What are the Differences Between Database and Spreadsheet?
Both databases and spreadsheets (eg Microsoft Excel) are convenient for storing information. The main differences between them can be listed as follows:
Method of collecting and manipulating data
People who can access data
Amount of data that can be stored
Spreadsheets are originally designed for a single user, and their features reflect this goal. It is a great option for single or few users who do not need enormously complex data manipulation. On the other hand, databases are designed to accommodate a higher amount, sometimes huge amounts of information collections. Databases allow multiple users to access and query data quickly and securely at the same time, with very complex logic and language usage.
There are many different types of databases. The ideal database for a particular organization varies depending on how the organization intends to use the data.
Relational databases. Relational databases dominated the market in the late 1980s. The items in the relational database are organized as a set of tables consisting of columns and rows. Relational database technology provides the most efficient and flexible access to structured information.
Object oriented databases. Information in an object-oriented database is represented in the form of objects, just as in object-oriented programming.
Distributed databases. The distributed database consists of two or more files located in different places. The database can be stored on multiple computers spanning different networks or located in the same physical location.
Data warehouses. The data warehouse is a database type specially designed for quick query and analysis purposes.
NoSQL databases. A NoSQL or non-relational database allows the storage and manipulation of unstructured and semi-structured data (opposite of the relational database that defines how all the data added to the database should be created). NoSQL databases gained popularity as web application software became more common and more complex.
Graph databases.Graph database (GDB) is a database that uses graph structures for semantic queries with nodes, edges, and properties to represent and store data.
OLTP databases. The OLTP database is a fast and analytical database designed for multiple operations to be performed by multiple users.
Today, tens of database types are used. Other less common databases are designed specifically for scientific, financial or other functions. Some of the newest databases can be listed as follows:
Open source databases. The open source database system is a system with source code is open source. Such databases can be SQL or NoSQL databases.
Cloud databases. The cloud database is a collection of structured or unstructured data and takes place on a private, public or hybrid cloud computing platform. There are two types of cloud database models: Traditional and Database as a service (DBaaS). Management tasks and maintenance are performed by the service provider in DBaaS.
Multi-model database. Multi-model databases combine different database types in one integrated backend. They may contain various types of data accordingly.
Document / JSON database. Document databases designed for storing, retrieving and managing document-oriented information offer a modern method of storing data in JSON format rather than rows and columns.
Autonomous Database.Autonomous Database is a family of self-driving, self-securing, and self-repairing cloud services. It’s the world’s first autonomous database, and it redefines database management by using machine learning and automation to eliminate human labor, human error, and manual tuning, reducing cost and complexity and ensuring higher reliability, security, and more operational efficiency. Autonomous Database supports a complex mix of high-performance transactions, including reporting, batch, Internet of Things (IoT), and machine learning in a single database. This simplifies application development and deployment and enables real-time analytics, personalization, and fraud detection.