Difference between revisions of "CNM Cloud Databases"
(→Key terms) |
|||
| (12 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | [[File:Cnm-digital.png|400px|thumb|right|[[ | + | [[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]]. |
| Line 10: | Line 10: | ||
:The [[CNM Farms]] feature 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 [[ | + | :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 20: | ||
: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. | :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. | + | :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=== | ===Key terms=== | ||
| − | :[[Database]], [[database management system]] ([[DBMS]]), [[relational model]], [[relational database management system]] ([[relational database management system|RDBMS]]), [[structured query language]] | + | :[[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]] |
===Closing=== | ===Closing=== | ||
| − | : | + | :Is the concept of [[database]] explained well ?--- Yes/No/I'm not sure |
| − | |||
'''[[Data at CNM Farms]]''' is the successor [[lectio]]. | '''[[Data at CNM Farms]]''' is the successor [[lectio]]. | ||
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.
