Relational database model

Other Databases - related issues
Post Reply
Posts: 2
Joined: Thu May 24, 2018 2:17 pm
Location: Boston

Re: Relational database model

Post by ernest99 » Mon May 28, 2018 12:38 pm

Relational databases like MySQL, PostgreSQL and SQLite3 represent and store data in tables and rows. They're based on a branch of algebraic set theory known as relational algebra. Meanwhile, non-relational databases like MongoDB represent data in collections of JSON documents. The Mongo import utility can import JSON, CSV and TSV file formats. Mongo query targets of data are technically represented as BSON (binary JASON).
Relational databases use Structured Querying Language (SQL), making them a good choice for applications that involve the management of several transactions. The structure of a relational database allows you to link information from different tables through the use of foreign keys (or indexes), which are used to uniquely identify any atomic piece of data within that table. Other tables may refer to that foreign key, so as to create a link between their data pieces and the piece pointed to by the foreign key. This comes in handy for applications that are heavy into data analysis.

Posts: 1
Joined: Sun Aug 12, 2018 10:46 pm

Re: Relational database model

Post by scott834porter » Mon Aug 13, 2018 2:48 am

Thanks for sharing these stuff. I am just learning database and I think these stuff that you shared are very useful.

thanks a lot.

Scott Porter

Post Reply