Terminology: Difference between revisions
mNo edit summary |
mNo edit summary |
||
(5 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 | ||
|- | |- | ||
| | | Database || Database || Directory | ||
|- | |- | ||
| Field || Column (or Domain) || Column | | Library || Table || Sheet or Table | ||
|- | |||
| Field || Column (or Domain or Field) || Column | |||
|- | |- | ||
| Entry || Row (or Record) || Row | | Entry || Row (or Record) || Row | ||
Line 22: | Line 25: | ||
=== Pages === | === 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. | 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.