Main:Database index: Difference between revisions

Jump to navigation Jump to search

Main:Database index (view source)

Revision as of 17:07, 12 December 2021

6,380 bytes added ,  12 December 2021
m
no edit summary
mNo edit summary
mNo edit summary
 
(17 intermediate revisions by the same user not shown)
Line 1: Line 1:
{{stamp|2021-11-04|4.10.2|1.10.2}}
{{stamp|2021-12-12|4.10.3|1.10.1}}
{{banner-menu}}
{{BannerMenu}}


==Preamble on database terminology ==
==Memento & Industry database terminology <small>(Read about ''libraries, fields, & entries'' here)</small>==
This is to get us on the same page regarding terms Memento users have used previously versus the terms chosen by Memento for its products. [[#The Database index, allowing quick access to Memento Database information|Jump to the database index]]
This is to get us on the same page regarding terms Memento users have used previously versus the terms chosen by Memento for its products. [[Main:Desktop index|Jump to the Desktop index]]


=== Memento terms and database industry terms ===
Sometimes some of us tend to use one set of terms for things, and some might use another set of terms for the same things, like "record" or (less often) "row" for a Memento entry and ...
Sometimes some of us tend to use one set of terms for things, and some might use another set of terms for the same things, like "record" or (less often) "row" for a Memento entry and ...
'''''Yada'''''
'''''<big>Is this an about page?</big>''''', like entry name, links to linking, template, cloud, editions, platforms


The Memento Database application comprises ''libraries'' (often known outside Memento as tables), ''entries'' (often known outside Memento as rows), and ''fields'' (often known outside Memento as columns). A common generic term, recognized everwhere for either entries or rows is ''records''.
{| class="wikitable" width="100%"
! Term !! Memento terms !! Common industry terms !! Relational terms !! Generic terms
|-
| style="width: 10%; text-align:center" | '''''Field'''''
| style="width: 20%" | A type of field instead of ''field type''. A '''''field''''' is also used to refer to the data (datum, in actuality) that may have been entered into a ''field''.
| style="width: 20%" | A '''''field''''' the name of a column in a table or library
| style="width: 20%" | '''''field'''''
| style="width: 30%" | ''domain'' when discussing the ''data structure'' and the name of a datum, or the data as displayed in a ''library entry'', a ''table row'', or a ''database record''. The term ''field'' is universal. It is sometimes used to refer to the ''domain'' or ''type'' of field, or ''field type''.
|-
| style="width: 10%; text-align:center" | '''''Record'''''<br/>or<br/>'''''Row'''''<br/>or<br/>'''''Entry'''''
| style="width: 20%" | A generic term referring to an ordered set of ''fields'' of data within a library
| style="width: 20%" | A generic term referring to an ordered set of ''fields'' of data within a table or library
| style="width: 20%" | A generic term referring to an ordered set of ''fields'' of data within a table
| style="width: 20%" | ''Records, rows, or entries'' may have unique identifiers (entry names in Memento), allowing them to be identified & accessed with linkage by some means (Link to Entry ''fields'' & Find or Search functions. These identifiers are often indexed to optimize performance.
|-
| style="width: 10%; text-align:center" | '''''Library'''''<br/>or<br/>'''''Table'''''<br/><small>(or<br/>''sometimes Database)''</small>
| style="width: 20%" | A collection of ''entries'' containing data.
An ''entry'' may be identified by a possibly unique entry name.
<br/><br/>An ''entry'' may be identified '''''in other libraries''''' by use of a Link to Entry ''field''.
| style="width: 20%" | A collection of ''records'' containing data.
As ''record'' is a generic term, it may be identified by a possibly unique (unspecified) means.
<br/><br/>A ''record'' may be identified '''''in other tables''''' by inclusion there of this (same) key, called a secondary key.
| style="width: 20%" | A collection of ''rows'' containing data.
A ''row'' may be identified by a possibly unique primary key.
<br/><br/>A row may be identified '''''in other tables''''' by inclusion there of this (same) key.
| style="width: 30%" | Use '''''table''''' outside Memento. Some people outside Memento unfortunately still use ''database'', where we would use ''library''.
|-
| style="width: 10%; text-align:center" | '''''Database'''''
| style="width: 20%" | One or more related libraries
| style="width: 20%" | One or more related tables or libraries
| style="width: 20%" | One or more related tables
| style="width: 30%" | Use '''''table''''' outside Memento, '''''library''''' within. Some people outside Memento unfortunately still use ''database'', where we would use ''library''.
|}
 
The data used by a user base for a given scope
 
In Memento, use library. In the relational world, use table. Table is the most gernerally recognized term. (Some people outside Memento unfortunately still use database.
Database One or more related tables or libraries One or more related tables One or more related libraries Use table outside Memento. Some people outside Memento unfortunately still use database, where we would use library.
 
The Memento Database application comprises ''libraries'' (often known outside Memento as tables), ''entries'' (often known outside Memento as rows), and ''fields'' (often known outside Memento as columns). A common generic term, recognized everywhere for either entries or rows is ''records''.


In the Memento forum, "field" and "record" are often used and "column" and "row" is seldom used. So, it's best to stick with either Memento's "entry" (since it's their forum, after all), but when others use or seem to prefer the database industry's "record", we'll all know what is meant by that, and we can accommodate them when interacting with them, message by message in the forum.
In the Memento forum, "field" and "record" are often used and "column" and "row" is seldom used. So, it's best to stick with either Memento's "entry" (since it's their forum, after all), but when others use or seem to prefer the database industry's "record", we'll all know what is meant by that, and we can accommodate them when interacting with them, message by message in the forum.
Line 18: Line 56:
When a user's objectives are so small that a single library is enough, then in that case the database is the library. However, when a user's objectives require that libraries be linked together to accomplish the objectives, now the entire set of linked libraries constitute the database. That's why, whenever we go into Edit Library > Export to create a .template file, there's an option to include linked libraries. This makes the template a database export rather than merely a library export. For more on database exports, see [[How:Export a database|Export a database]].
When a user's objectives are so small that a single library is enough, then in that case the database is the library. However, when a user's objectives require that libraries be linked together to accomplish the objectives, now the entire set of linked libraries constitute the database. That's why, whenever we go into Edit Library > Export to create a .template file, there's an option to include linked libraries. This makes the template a database export rather than merely a library export. For more on database exports, see [[How:Export a database|Export a database]].


Libraries can be linked so they can work together as a database. So, each library has a structure of fields & other things (see below for what things make up its structure), and each database has a structure of libraries & links between them (see About:Database structure#Examples for an example).  
Libraries can be linked so they can work together as a database. So, each library has a structure of fields & other things (see below for what things make up its structure), and each database has a structure of libraries & links between them (see About:Database structure#Examples for an example).


== The ''Database index'', allowing quick access to Memento Database information ==
== The ''Database index'', allowing quick access to Memento Database information ==
Yada
Yada (1-3 lines)


=== Introduction ===
=== Introduction ===
Yada (1-3 lines)
{| class="wikitable" font-size="100%"
{| class="wikitable" font-size="100%"
! Topics !! Overviews !! About
! Overviews !! About
|-
|-
| style="width:25%;" | <big>'''Memento Database'''</big>
| style="width:50%" | [[Memento Database]]
| style="width:25%;" | [[Memento Database]]
[[Memento Wiki]]
[[Memento Wiki]]
<br/>[[Glossary]]
<br/>[[Glossary]]
<br/>[[Useful links]]
<br/>[[Useful links]]
<br/>[[Releases]]
<br/>[[Releases]]
| style="width:25%;" | [[How:Getting Started]]
| style="width:50%" | [[How:Getting Started]]
<br/>[[About:Bill's mementos]]
[[About:Bill's mementos]]
<br/>[[About:Bill's tutorials]]
<br/>[[About:Bill's tutorials]]
<br/>[[About:Bill's examples]]
<br/>[[About:Bill's examples]]
Line 43: Line 82:
|}
|}


=== Displays in the Memento mobile edition ===
=== Libraries & templates '''''(both editions, except maybe with templates)''''' ===
{| class="wikitable"
Yada (1-3 lines)
 
{| class="wikitable" style="width: 100%; font-size: 100%"
! Topics !! Overviews !! Specs !! Guidance
|-
| style="width:25%" | [[Library]]
[[Library Template]]
| style="width:25%" | [[Libraries List screen]]
[[Library Edit screen]]
<br/>[[Library Groups]]
<br/>[[Library Protection]]
| style="width:25%" |
| style="width:25%" | [[How:Add a Library]]
|}
 
=== Fields, pages, & subheaders '''''(both editions)''''' ===
Yada (1-3 lines)
 
{| class="wikitable" font-size="100%"
! Topics !! Overviews !! Specs !! Guidance
! Topics !! Overviews !! Specs !! Guidance
|-
|-
| style="width:25%;" | [[Field]]
[[Field Edit card]]
<br/>[[Field Role]]
<br/>[[Field Type]]
<br/>[[Page]]
| style="width:25%;" |
| style="width:25%;" |
| style="width:25%;" | [[Screens & cards]]
| style="width:25%;" | <big>'''''Text fields'''''</big>
| style="width:25%;" | [[Libraries List screen]]
:[[Text field|Text]]
[[Library Edit screen]]
:[[Rich Text field|Rich text (HTML)]]
:[[Phone Number field|Phone number]]
:[[Email Address field|Email address]]
:[[Hyperlink field|Hyperlink]]
:[[Password field|Password]]
:[[Barcode field|Barcode]]
 
<big>'''''Numeric'' fields'''</big>
:[[Integer field|Integer]]
:[[Integer values field|Integer values]]
:[[Currency field|Currency]]
:[[Real number field|Real number]]
:[[Rating field|Reading]]
 
<big>'''''Choice'' fields'''</big>
:[[Boolean field|Boolean]]
:[[Single-choice List field|Single-choice list]]
:[[Radio Buttons field|Radio buttons]]
:[[Multiple-choice List field|Multiple-choice list]]
:[[Checkboxes field|Checkboxes]]
:[[List field|Dynamic List]]
 
<big>'''''Calculated expression'' fields'''</big>
:[[JavaScript field|JavaScript]]
:[[Calculation field|Calculation]]
 
<big>'''''Date'' fields'''</big>
:[[Date field|Date]]
:[[DateTime field|DateTime]]
 
<big>'''''Time'' fields'''</big>
:[[Time field|Time]]
:[[DateTime field|DateTime]]
 
<big>'''''Linking'' fields'''</big>
:[[Link To Entry field|Link to entry]]
:[[Link To File field|Link to file]]
 
<big>'''''Media'' fields'''</big>
:[[Audio field|Audio]]
:[[Image field|Image]]
:[[Signature field|Signature]]
 
<big>'''''Miscellaneous'' fields'''</big>
:[[Contact field|Contact]]
:[[Location field|Location]]
:[[Tags field|Tags]]
 
<hr><big>'''''Special content'' fields'''</big>
:[[Audio field]]
:[[Barcode field]]
:[[Contact field]]
:[[Location field]]
:[[Rich Text field]]
:[[Signature field]]
 
| style="width:25%;" | [[How:Field Dependencies|Field Dependencies]]
[[Tips:Using JavaScript in Memento|Using JavaScript in Memento]]
|}
 
=== Entries & entry lists '''''(both editions)'''''  ===
{| class="wikitable" font-size="100%"
! Topics !! Overviews !! Specs !! Guidance
|-
| style="width:25%;" | [[Entry]]
[[Data analysis]]
| style="width:25%;" | [[Entry View card]]
[[Entry Edit card]]
<br/>[[Libraries List screen]]
<br/>[[Library Entries List screen|Entries List screen]]
<br/>[[Library Entries List screen|Entries List screen]]
<br/>[[Entry Edit card]]
| style="width:25%;" | [[How:Access a Previous Entry]]
<br/>[[Entry View card]]
[[How:Slice & Dice Library Data]]
<br/>[[File Manager card]]
<br/>[[Attached Files card]]
<br/>[[Charting data]]
| style="width:25%;" |
| style="width:25%;" |
|}
|}


=== Displays in the Memento desktop edition ===
=== Linking ===
{| class="wikitable"
{| class="wikitable" style="width: 100%"
! Topics !! Overviews !! Specs !! Guidance
! Topics !! Overviews !! Specs !! Guidance
|-
|-
| style="width:25%;" |
| style="width:25%" | [[Calculation field]]
| style="width:25%;" | [[Windows & panes]]
[[Link To Entry field]]
| style="width:25%;" |
<br/>[[Link To File field]]
| style="width:25%;" |
| style="width:25%" |
| style="width:25%" |
| style="width:25%" |
|}
|}


=== Data Analysis (Slicing & dicing)<br/>(Sorting, grouping, filtering, aggregation, & charting) ===
Yada
{| class="wikitable" style="width: 100%"
! Topics !! Overviews !! Specs !! Guidance
|-
| style="width:25%" | [[Slicing & Dicing]]
[[Aggregation]]
| style="width:25%" | [[Library Entries List screen|Entries List screen]]
[[Charting data]]
| style="width:25%" | [[How:Slice & Dice Library Data]]
| style="width:25%" |
|}


=== Scripting, Calculation, & App Integration ===
=== Scripting, Calculation, & App Integration ===
Line 148: Line 290:




[[Category:en]] [[Category:Using]]
[[Category:en]] [[Category:Database]] [[Category:Index]]
Retrieved from "https://wiki.mementodatabase.com/index.php?title=Special:MobileDiff/3875...3977"

Navigation menu