Introduction to Database
This article literally includes over a brief introduction of database almost everything about database we are going to uncover in this article just like what is it, its usage and types? almost whatever there can be about it.What is a database?
Database basically stores data that can be any kind of information ie_ information about people, their ages, sometimes we manage their salaries, and other many kinds of data there can be whether it's information about people, products, orders or any particular thing to be saved on databases. Information is always written in table form on databases as usual it is written in our daily life, database can contain more than one table in case storing the information because there can be different kinds of information.
Websites and applications use databases to save the information so that the information is accessible to their specific users.
There are many types of database we are going to be talking about but the following ones are popular and most used
1. Relational database
2. Object oriented database
3. Distributes database
4. Graph database
5. Cloud database
2. Object oriented database
3. Distributes database
4. Graph database
5. Cloud database
Relational database:
The data is organized into a set of tables that has columns and rows is relational database. It follows the relational model of data management, which is based on set theory and relational algebra. Relational databases always use Structured Query Language (SQL) to interact with data. MySQL, Oracle Database, Microsoft SQL Server, PostgreSQL, and SQLite are the Popular examples of relational database. These databases are most used in various applications and industries for their data consistency, flexibility, transactional support, and robust querying capabilities. Applications in which relational database are used commonly are enterprise systems, content management systems, e-commerce platforms, financial applications, and many other domains.
Object-oriented database:
Th data base where data is stored using OOP(Object-oriented-programming) concepts is a Object oriented database and it's kind of database management system (DBMS) that always stores and send data using objects, which are instances of classes or prototypes. this is not little bit similar to the Relational database which use tables comprised in rows and coloumns instead Object-oriented databases directly model entities as objects and support inheritance, encapsulation, and polymorphism which are the major concepts of Object Oriented programming. MongoDB (which combines object-oriented concepts with a document-oriented approach), db4o, Versant, and ObjectDB. are the popular examples of Object Oriented Databases. Object-oriented databases are mostly used for the data that heavily rely on object-oriented programming paradigms, have complex data structures, and require close alignment between the application's object model and the underlying database representation.