Write, Bureaucrats, Administrators
4,332
edits
CaseStudy:Designing Memento databases:Photographic equipment: Difference between revisions
CaseStudy:Designing Memento databases:Photographic equipment (view source)
Revision as of 07:28, 30 April 2021
, 30 April 2021no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 3: | Line 3: | ||
== Nomenclature == | == Nomenclature == | ||
Before we begin, let's ensure we have an agreed understanding of the terminology we'll use in this study. In Memento, our terminology | Before we begin, let's ensure we have an agreed understanding of the terminology we'll use in this study. In Memento, our terminology varies from other [[Glossary#DBMS|DBMS]] disciplines, notably ''relational'' DBMSes (or [[Glossary#RDBMS|RDBMSes]]). The following table shows the equivalencies between them:<big> | ||
{| class="wikitable" | {| class="wikitable" | ||
! Memento !! Relational !! Definition | ! Memento !! Relational !! Definition | ||
| Line 13: | Line 13: | ||
| Entries & fields or rows & columns of data | | Entries & fields or rows & columns of data | ||
|- | |- | ||
| [[Glossary#Field|Field]] || [[Glossary#Column|Column]] | | [[Glossary#Field|Field]] || Field (or [[Glossary#Column|Column]]) | ||
| A typed data item occupying a position within a library or table | | A typed data item occupying a position within a library or table | ||
|- | |- | ||
| [[Glossary#Entry|Entry]] || [[Glossary#Record|Record]]<br/>(or row) | | [[Glossary#Entry|Entry]] || [[Glossary#Record|Record]]<br/>(or [[Glossary#Row|row)]] | ||
| An instance or occurrence of data across fields or columns | | An instance or occurrence of data across fields or columns | ||
|- | |- | ||
| Line 25: | Line 25: | ||
| The means by which libraries or tables are related to each other | | The means by which libraries or tables are related to each other | ||
|} | |} | ||
</big> | |||
;Requirements (the need): | ;Requirements (the need): | ||
:;Intro: | :;Intro: | ||