Difference between revisions of "Main:Database index"

From Memento Database Wiki
Jump to navigation Jump to search
m
m
 
(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]]

Latest revision as of 17:07, 12 December 2021

« Page as of 2021-12-12, editions Mobile 4.10.3, Desktop 1.10.1 »

Wiki
Home
About
Wiki | Memento
Getting started
Wiki | Memento
Indices (Indexes)
Mobile, Desktop | Scripting | Database
Support
Wiki | Memento

Memento & Industry database terminology (Read about libraries, fields, & entries here)

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. Jump to the Desktop index

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 ... Is this an about page?, like entry name, links to linking, template, cloud, editions, platforms

Term Memento terms Common industry terms Relational terms Generic terms
Field 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. A field the name of a column in a table or library field 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.
Record
or
Row
or
Entry
A generic term referring to an ordered set of fields of data within a library A generic term referring to an ordered set of fields of data within a table or library A generic term referring to an ordered set of fields of data within a table 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.
Library
or
Table
(or
sometimes Database)
A collection of entries containing data.

An entry may be identified by a possibly unique entry name.

An entry may be identified in other libraries by use of a Link to Entry field.

A collection of records containing data.

As record is a generic term, it may be identified by a possibly unique (unspecified) means.

A record may be identified in other tables by inclusion there of this (same) key, called a secondary key.

A collection of rows containing data.

A row may be identified by a possibly unique primary key.

A row may be identified in other tables by inclusion there of this (same) key.

Use table outside Memento. Some people outside Memento unfortunately still use database, where we would use library.
Database One or more related libraries One or more related tables or libraries One or more related tables 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.

Databases and Libraries

Likewise, within the database industry overall, "database" is used to mean the entire set of data used by a hopefully identified user or group of users to accomplish the users' personal or professional objectives, comprising libraries, entries, and fields. So, a person might use one database at home and another at work, and though many libraries will be different between libraries (like Customers at work and Groceries at home), some libraries might be used both at home and at work, often the most common and generic libraries, like People or Organizations.

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 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).

The Database index, allowing quick access to Memento Database information

Yada (1-3 lines)

Introduction

Yada (1-3 lines)

Overviews About
Memento Database

Memento Wiki
Glossary
Useful links
Releases

How:Getting Started

About:Bill's mementos
About:Bill's tutorials
About:Bill's examples
Tutorial:Simple To Do List
Tutorial:Simple To Do List Enhancements
About:Color codes
CaseStudy:Designing Memento databases:Photographic equipment

Libraries & templates (both editions, except maybe with templates)

Yada (1-3 lines)

Topics Overviews Specs Guidance
Library

Library Template

Libraries List screen

Library Edit screen
Library Groups
Library Protection

How:Add a Library

Fields, pages, & subheaders (both editions)

Yada (1-3 lines)

Topics Overviews Specs Guidance
Field

Field Edit card
Field Role
Field Type
Page

Text fields
Text
Rich text (HTML)
Phone number
Email address
Hyperlink
Password
Barcode

Numeric fields

Integer
Integer values
Currency
Real number
Reading

Choice fields

Boolean
Single-choice list
Radio buttons
Multiple-choice list
Checkboxes
Dynamic List

Calculated expression fields

JavaScript
Calculation

Date fields

Date
DateTime

Time fields

Time
DateTime

Linking fields

Link to entry
Link to file

Media fields

Audio
Image
Signature

Miscellaneous fields

Contact
Location
Tags

Special content fields
Audio field
Barcode field
Contact field
Location field
Rich Text field
Signature field
Field Dependencies

Using JavaScript in Memento

Entries & entry lists (both editions)

Topics Overviews Specs Guidance
Entry

Data analysis

Entry View card

Entry Edit card
Libraries List screen
Entries List screen

How:Access a Previous Entry

How:Slice & Dice Library Data

Linking

Topics Overviews Specs Guidance
Calculation field

Link To Entry field
Link To File field

Data Analysis (Slicing & dicing)
(Sorting, grouping, filtering, aggregation, & charting)

Yada

Topics Overviews Specs Guidance
Slicing & Dicing

Aggregation

Entries List screen

Charting data

How:Slice & Dice Library Data

Scripting, Calculation, & App Integration

Topics Overviews Specs Guidance
Scripting Calculation field

JavaScript field
Memento JavaScript Library
Actions
Data Sources
Triggers

Tasker Integration

Trigger Examples
How:Write scripts in JavaScript for Memento
Tips:Using JavaScript in Memento

Installation & settings

Topics Overviews Specs Guidance
Memento Settings

Import, export, synchronization, backup, & restore

Topics Overviews Specs Guidance
Backup & Restore Importing and exporting data

Formatting Templates screen

Tips:File Attachments

Cloud, platforms, & collaboration

Topics Overviews Specs Guidance
Platforms

Cloud storage and Teamwork

Cloud Library Status card

Security

Topics Overviews Specs Guidance
Privacy Policy

Library Protection

Products

Topics Overviews Specs Guidance
Memento Clients

Private Server
Team for Business

Tips:Team for Business

Jump to the index

Jump to the top