Difference between revisions of "CNM Cloud Databases"

From CNM Wiki
Jump to: navigation, search
(Script)
 
(26 intermediate revisions by 2 users not shown)
Line 1: Line 1:
[[File:Cnm-digital.png|400px|thumb|right|[[CNM Cyber]]]][[Databases of CNM Cloud]] (hereinafter, the ''Lectio'') is the [[lectio|lesson part]] of the '''[[Cloud Foundation Essentials]]''' [[lesson]] that introduces its participants to [[CNM Cloud]]. This ''lesson'' belongs to the [[Introduction to CNM Cloud]] session of the [[CNM Cyber Orientation]].
+
[[File:Cnm-digital.png|400px|thumb|right|[[CNMCyber suite]]s]][[CNM Cloud Databases]] (hereinafter, the ''Lectio'') is the [[lectio|lesson part]] of the '''[[CNM Farm Essentials]]''' [[lesson]] that introduces its participants to [[Opplet]]. This ''lesson'' belongs to the [[Introduction to CNM Cloud]] session of [[EmployableU Concepts]].
  
  
 
==Content==
 
==Content==
The predecessor [[lectio]] is [[What the Foundation Is]].
+
The predecessor [[lectio]] is [[What CNM Farms Are]].
 
 
===Key terms===
 
  
 
===Script===
 
===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 repository|software repositories]] may serve as [[database]]s. However, the overwhelming majority of ''databases'' represent [[database management system]]s (or [[DBMS]]es). Usually, a ''DBMS'' not only stores and returns, but also capture and analyze the data.  
 
: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 repository|software repositories]] may serve as [[database]]s. However, the overwhelming majority of ''databases'' represent [[database management system]]s (or [[DBMS]]es). Usually, a ''DBMS'' not only stores and returns, but also capture and analyze the data.  
  
:The [[CNM Cloud Foundation]] features two types of ''database management systems''.
+
:The [[CNM Farms]] feature two types of ''database management systems''.
  
:One type utilizes [[relational model]]. [[Relational database management system]]s ([[relational database management system|RDBMS]]es) strictly organize their data. It is stored in tables and the tables are inter-connected in specified ways. [[SQL|Structured query language]]s {[[SQL]]s) are used to retrieve the data from ''relational databases'' of [[CNM Cloud]].
+
:One type utilizes [[relational model]]. [[Relational database management system]]s ([[relational database management system|RDBMS]]es) strictly organize their data. It is stored in tables and the tables are inter-connected in specified ways. [[SQL|Structured query language]]s {[[SQL]]s) are used to retrieve the data from ''relational databases'' of [[Opplet]].
  
 
:[[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 model]]s.
 
:[[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 model]]s.
Line 20: Line 18:
 
: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.
 
: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.
  
:Using
+
: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.
  
  [[WorldOpp Middleware]] collects most important data from various ''systems'' throughout the [[CNM Cloud Foundation]], transforms the collected data in a unified format, and stores the data in its [[NoSQL]] database. The [[CNM Cyber Team]] decides on what data shall be collected, transformed, and stored.
+
: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. [[Opplet]] uses [[DDBMS]] as its [[federated database]].
  
:To secure data from disasters such as computer failures and other [[data loss event]]s, all the data is backed up at the same time every day. At [[CNM Cloud]], that means that the database data is copied and stored separately from the [[computing server]] on which the database is installed. In that way, the [[data backup]] wouldn't be destroyed if one ''server'' collapses.
+
===Key terms===
 +
:[[Database]], [[database management system]] ([[DBMS]]), [[relational model]], [[relational database management system]] ([[relational database management system|RDBMS]]), [[structured query language]] ([[SQL]]), [[Distributed Database Management System]] ([[DDBMS]]), [[NoSQL]], [[data management]], [[federated database]]
  
:For different ''systems'', the backup policies may vary, but the backup system always contains several copies of all data that the [[CNM Cyber Team]] considers worth saving. For instance, the system may contain backups that were made yesterday, a day before yesterday, last week, and last month. Commonly, one "old" backup is deleted when one new backup is made.
+
===Closing===
 +
:Is the concept of [[database]] explained well ?--- Yes/No/I'm not sure
  
:As a disaster recovery, any data copy can substitute the original data in the database. However, no data backup cannot restore the data that have been created after the backup was made.
+
'''[[Data at CNM Farms]]''' is the successor [[lectio]].
 
 
'''[[Data in the Foundation]]''' is the successor [[lectio]].
 
  
 
==Questions==
 
==Questions==
 
===Lectio quiz===
 
:The answer is recorded for the lectio completion purpose:
 
:*[[CNM Cabin]] is hosted by:<ol type="a"><li>[[CNM Cloud Next]]</li><li>[[WorldOpp Federated Servers]]</li><li>[[CNM Fellow Servers]]</li><li>[[CNM HandsOn Servers]]</li><li>None of the other answers is correct.</li></ol>
 
:*Which statement below is correct:<ol type="a"><li>[[CNM Cyber]] may include three identical [[CNM app]]s.</li><li>While taking this course, you work on the [[CNM Fellow Servers]].</li><li>Future administrators of [[CNM app]]s get [[hands-on training]] at the [[CNM Cloud Next]].</li><li>All of the other substantive answers are correct.</li><li>None of the other answers is correct.</li></ol>
 
  
 
===Placement entrance exam===
 
===Placement entrance exam===

Latest revision as of 09:26, 15 November 2023

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


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 Opplet.
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. Opplet 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

Is the concept of database explained well ?--- Yes/No/I'm not sure

Data at CNM Farms is the successor lectio.

Questions

Placement entrance exam