CNM Cloud Databases

From CNM Wiki
Revision as of 09:07, 21 October 2020 by MariamKhalid (talk | contribs) (Closing)
Jump to: navigation, search

CNM Cloud Databases (hereinafter, the Lectio) is the lesson part of the CNM Farm Essentials lesson that introduces its participants to CNM Cloud. This lesson belongs to the Introduction to CNM Cloud session of the CNM Cyber Orientation.


Content

The predecessor lectio is What CNM Farms Are.

Script

In information technology, any database is the collection of data that is stored and can be accessed digitally by an authorized software system. If special applications can handle their data, software repositories may serve as databases. However, the overwhelming majority of databases represent database management systems (or DBMSes). Usually, a DBMS not only stores and returns, but also capture and analyze the data.
The CNM Farms feature two types of database management systems.
One type utilizes relational model. Relational database management systems (RDBMSes) strictly organize their data. It is stored in tables and the tables are inter-connected in specified ways. Structured query languages {SQLs) are used to retrieve the data from relational databases of CNM Cloud.
Distributed Database Management System (DDBMS) is another type. This type relies on NoSQL model. NoSQL refers to not-only-SQL. Its data is loosely organized, so makes its management quicker, but less reliable than data management in relational models.
To compare these two type, imagine that you need to organize your documents.
Using the relational model, you may create separate folders for various categories and sort your documents according those categories. Then, you can organize different folders, let say, alphabetically. This approach would wonderfully work if your documents are standardized. Now, how would you organize one document that belongs of different categories? Or a journal that contains various documents? They wouldn't fit the model.
If you use the opposite approach, you would just put stickers on the documents and bookmarks in the folders. In that way, you have no trouble with various types of documents, but, when you look for them, you may miss something.
When it comes to data management, the relational model is generally more effective, but NoSQL is more efficient. If the data is well-structured, the relational model is preferable. If the data is loosely organized or not organized at all, the NoSQL is the best. CNM Cloud uses DDBMS as its federated database.

Key terms

Database, database management system (DBMS), relational model, relational database management system (RDBMS), structured query language (SQL), Distributed Database Management System (DDBMS), NoSQL, data management, federated database

Closing

Data at CNM Farms is the successor lectio.

Questions

Placement entrance exam