Web Development Jargons Explained in 5 Different Ways
TLDR: A relational database is a type of database structure that organizes data in tables of columns and rows. Each table represents one entity type. Relationships then can be linked between data of each table. Such as books and their authors.
A relational database is a type of database structure that organizes data in tables of columns and rows. Each table represents one entity type. Relationships then can be linked between data of each table. Such as books and their authors.
Relational databases are popular for building mission critical applications because of its strictness in structural change. Many financial institutions and large internet companies choose to use relational database to reduce risk of data corruption or loss.
Relational database was created to overcome the pitfalls of an earlier database structure called navigational database. Navigational database lacked the ability for "search" which became a much needed feature as computers got more powerful and applications grew more complex.
A table in a relational database is used to organize data of the same nature. Such as books or authors. Each row in a table contains one data entry, such as one book "Moby-dick". A column will represent an attribute belonging to data in a table, such as "year of publish" which will be "1851" for "Moby-dick".
An attribute can be used to store an identifier belonging to data of other tables. We can store the Author's name "Herman Melville" as an attribute of "Moby-dick" to add the relationship between a book and its author.
|ISBN||title||author||Year of Publish|
|1400079985||War and Peace||Leo Tolstoy||1867|
|Herman Melville||United States|
Towards the end of 1970s, a standardised language called SQL (Structured Query Language) for managing relation databases was created. Nowadays, almost all relational database systems use SQL for managing the database. The most well known relational database management system include PostgreSQL, mySQL.
A database is a collection of data organized for fast access and easy query. An example would be a database of the rental records of all the books in all public libraries so you can find the libraries that have your book available.
PostgreSQL is a relational database management system for storing and managing data. It is known for its reliability, and is popular for building mission critical applications used by financial services and large internet companies.
SQL stands for Structured Query Language. It is a specific programming language for managing relational database management systems. With SQL, you can easily write programs to create, read, update, and delete data.
A non-relational database is a type of database structure that organizes data in collections ("Books") of data entries ("Moby-dick", "War and peace"). Entries are not restricted to the attributes they can have. One book can have "year of publish" and "genre", whereas another book can have "year of publish" and "ISBN".
Cohort 82 begins on October 2nd, 2023
Learn back-end development with Ruby and Rails. Computer science fundamentals with practical programming skills.
Students and instructors from world-class organizations