search-magician / search_magician

0 stars 0 forks source link

Check Postgress, Mongodb #5

Open welo10 opened 3 years ago

Donga911 commented 3 years ago

MongoDB

MongoDB is a schema-free document database offering both free and paid plans. As a document database, MongoDB has a different structure and syntax than the traditional RDMS. It is also a NoSQL (Not Only SQL) database. NoSQL databases (Schema-free) are generally simpler by nature, so MongoDB is relatively easy to learn for those with any prior programming experience. Document databases process data as JSON-type documents.

{ 
        name : “Joe”, age : 30, interests : ‘football’
 }
    { 
        name : “Kate”, age : 25 
        }

And it also has another advantage, that data is semi-structured rather than fully structured. This means that it can process large volumes of data faster than many other solutions.

It also means that users can search and process data in all different stages of processing and in various formats and structures, that means users can access the data and make changes and updates to the schema if needed.

MongoDB uses BSON (Binary JSON). BSON allows for certain data types that are not used with regular JSON, such as long, floating-point, and date. MongoDB also offers an alternative query language to SQL called MQL. MQL has the same functions as SQL along with bringing additional support for a variety of programming languages.

For security , MongoDB offers client-side, field-level encryption through TLS and SSL (Transport Layer Security and Secure Sockets Layer), and those are protocols that convert HTTP to HTTPS that is more secure.

The database featured as a distributed architecture, meaning that components function across multiple platforms in collaboration with one another.

PostgreSQL

PostgreSQL is a 100% free and open-source ORD (object-relational database). Instead of storing data like documents like in MongoDB, the database stores it as structured objects.

It follows a traditional syntax and schema for SQL databases. Schema is effectively a template or structure that you can apply to databases using a set vocabulary. The schema contains various schema objects, including any tables, columns, keys, etc. You must structure data before loading it into such a database, and that takes more time not like in MongoDB. it can also put the data into a more manageable and readable format.

For security, Postgres includes basic file protection, the ability to restrict client connections by IP address, and compatibility with various other external packages intended to make it even more secure.

PostgreSQL has a monolithic architecture, meaning that the components are completely united. This also means that the database can only scale as much as the machine running it.

After I read about those two Database Systems, I think that MongoDB is good for our project, because it uses (BSON) is like JSON, and we work by it and the data stored as document and it will be easy to us to classify it or analysis it and also MongoDB is better for data analysis and it’s also so fast because it’s semi-structured and it can be scaled across more than one platform as needed not like PostgreSQL.