Terminology: Difference between revisions

From Memento Database Wiki
Jump to navigation Jump to search
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 (or Sheet)
| 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

« Page as of 2016-09-09, editions Mobile 3.9.7, Desktop 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.

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.

See Also

Glossary