Database

The term database is defined as a database that allows to store raw data. It is therefore a set of information that is organized in such a way as to be easily accessible, managed and updated. Computer databases generally contain aggregates of records or data files containing information on business transactions or interactions with specific customers.

Relational database

In a relational database, numerical information about a specific client is organized into rows, columns and tables that are indexed to facilitate the search for relevant information via SQL or NoSQL queries.

Graphical database

In contrast, a graphical database uses nodes and edges to define the relationships between data entries and queries, which requires a special semantic search syntax. At the time of writing, SPARQL is the only semantic query language approved by the World Wide Web Consortium (W3C).

Database manager

Typically, the database manager allows users to control read/write access, specify report generation and analyze usage. Some databases offer ACID compliance (atomicity, consistency, isolation and durability) to ensure data consistency and completeness of transactions.

Types of databases

Databases have evolved since their creation in the 1960s, starting with hierarchical and networked databases, then in the 1980s with object-oriented databases, and now with SQL and NoSQL databases and cloud databases.

• Hierarchical database: organized according to a tree structure.
• Network database: this database creates "multiple links between sets".
• Text-oriented database: these are text files in.txt or.ini or each line to include a record.
• Distributed database: in this type of database "some portions are stored in different places". The data can be homogeneous, i.e. all portions will work with the same hardware and operating system
• Cloud database: where storage capacity and/or bandwidth are optimized by creating virtualized environments

Example of a Database

Firebase

It is an application development platform (Web and mobile). We'll find there:

• Firebase Realtime database which is a NoSQL database hosted in the cloud
• Firebase Cloud messaging allows a service to send and receive messages with low battery consumption.

To create a social network a little similar to Facebook. It will be necessary to set up different data blocks with in particular:

• The profile page with stocks of profile photos, contacts,...
• The conversation page
• Registration and unsubscription

All conversations will then be stored in a database cloud.

Bibliography

https://lesveilleursdenuit.fr/introduction-a-firebase/

https://www.guru99.com/introduction-to-database-sql.html

https://www.slideshare.net/koushik0810/facebookthe-nuts-and-bolts-technology

https://cdn-images-1.medium.com/max/720/1*wwQ44b7hKQPC3qJeST-e_g.gif

You too Create a database with Create MySQL Database!