Terminology: Difference between revisions
mNo edit summary |
mNo edit summary |
||
(8 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{Stamp|2016-09-09|3.9.7|1.0.3}} | |||
Over the years and continuing today, various database technologies and tools have employed/employ distinct nomenclature. In the table below, that of Memento is shown with other leading terminology. | Over the years and continuing today, various database technologies and tools have employed/employ distinct nomenclature. In the table below, that of Memento is shown with other leading terminology. | ||
{| class="wikitable" | {| class="wikitable" | ||
! Memento !! Relational DBMS !! Spreadsheet | ! Memento !! Relational DBMS !! Spreadsheet | ||
|- | |- | ||
| Library || Table || Table | | Database || Database || Directory | ||
|- | |||
| Library || Table || Sheet or Table | |||
|- | |- | ||
| Field || Column (or Domain) || Column | | Field || Column (or Domain or Field) || Column | ||
|- | |- | ||
| Entry || Row (or Record) || Row | | Entry || Row (or Record) || Row | ||
Line 12: | Line 17: | ||
|} | |} | ||
The initial set of fields for a library is on a tab called MAIN; this is the name of a Page. The user can add more pages; each will have a name and a tab; and each will have its own set of fields. Each entry in a library contains all fields across all pages. | === Databases === | ||
Memento is a database product, and a user's Memento libraries, together with associated files — including photos, barcodes, and so on — constitute the user's overall Memento database. However, this is NOT a carefully defined term. One could consider the set of libraries within a Group to be a database; or perhaps each set of libraries that are linked together to formulate a solution, aggregated or otherwise. So, ''database'' remains a general term. | |||
=== Groups === | |||
The set of all libraries in a database can be subdivided into ''Groups''. Groups simplify lists of libraries. They are merely containers; there is no Group functionality. | |||
=== Pages === | |||
The initial set of fields for a library is on a tab called MAIN; this is the name of a ''Page''. The user can add more pages; each will have a name and a tab; and each will have its own set of fields. Each entry in a library contains all fields across all pages. | |||
== See Also == | |||
'''[[Glossary]]''' | |||
[[Category:en]] [[Category:Article]] |
Latest revision as of 14:15, 17 August 2021
Over the years and continuing today, various database technologies and tools have employed/employ distinct nomenclature. In the table below, that of Memento is shown with other leading terminology.
Memento | Relational DBMS | Spreadsheet |
---|---|---|
Database | Database | Directory |
Library | Table | Sheet or Table |
Field | Column (or Domain or Field) | Column |
Entry | Row (or Record) | Row |
Link To Entry | Foreign key | Hyperlink |
Databases
Memento is a database product, and a user's Memento libraries, together with associated files — including photos, barcodes, and so on — constitute the user's overall Memento database. However, this is NOT a carefully defined term. One could consider the set of libraries within a Group to be a database; or perhaps each set of libraries that are linked together to formulate a solution, aggregated or otherwise. So, database remains a general term.
Groups
The set of all libraries in a database can be subdivided into Groups. Groups simplify lists of libraries. They are merely containers; there is no Group functionality.
Pages
The initial set of fields for a library is on a tab called MAIN; this is the name of a Page. The user can add more pages; each will have a name and a tab; and each will have its own set of fields. Each entry in a library contains all fields across all pages.