Write, Bureaucrats, Administrators
4,332
edits
Memento Database: Difference between revisions
Jump to navigation
Jump to search
m
no edit summary
mNo edit summary |
mNo edit summary |
||
| Line 7: | Line 7: | ||
== Memento Database == | == Memento Database == | ||
Memento Database is a database management software tool for mobile devices (Android) and personal computers (Microsoft Windows, Linux, Apple Macintosh). Elements of a user's database — [[Library|libraries]] and associated files — may be synchronized across these [[Platforms|platforms]] via an available cloud service. Libraries also may be [[Sync with Google Sheets|synchronized with Google Sheets spreadsheets stored on the user's Google Drive]] to enable the user's data to be manipulated or analyzed by either tool, as needed. [[Importing and exporting CSV files|Import/export from/to comma-delimited (CSV) files]] enables coordinated use with external applications, like Microsoft Excel. | Memento Database is a database management software tool for mobile devices (Android) and personal computers (Microsoft Windows, Linux, Apple Macintosh). Elements of a user's database — [[Library|'''''libraries''''']] and associated files — may be synchronized across these [[Platforms|'''''platforms''''']] via an available cloud service. Libraries also may be [[Sync with Google Sheets|'''''synchronized with Google Sheets spreadsheets stored on the user's Google Drive''''']] to enable the user's data to be manipulated or analyzed by either tool, as needed. [[Importing and exporting CSV files|'''''Import/export from/to comma-delimited (CSV) files''''']] enables coordinated use with external applications, like Microsoft Excel. | ||
Data libraries may be linked, allowing any number of libraries to work together to form a database and provide a solution. | Data libraries may be linked, allowing any number of libraries to work together to form a database and provide a solution. | ||
All data can be stored in the [[Cloud storage and Teamwork|Memento Cloud]]. All such libraries, photos, and files are synchronized automatically between the cloud and local copies on Android devices. Users can provide access to their data to other users, enabling [[Cloud storage and Teamwork|teamwork use]]. | All data can be stored in the [[Cloud storage and Teamwork|'''''Memento Cloud''''']]. All such libraries, photos, and files are synchronized automatically between the cloud and local copies on Android devices. Users can provide access to their data to other users, enabling [[Cloud storage and Teamwork|'''''teamwork use''''']]. | ||
=== Targeted use cases === | === Targeted use cases === | ||
| Line 22: | Line 22: | ||
Memento's online catalog of user templates contains thousands of predefined, ready-to-use libraries to use directly or serve as a starting place. It also gives users the opportunity to familiarize themselves with a large number of ways to use Memento to provide solutions. | Memento's online catalog of user templates contains thousands of predefined, ready-to-use libraries to use directly or serve as a starting place. It also gives users the opportunity to familiarize themselves with a large number of ways to use Memento to provide solutions. | ||
=== [[Platforms]] === | === '''''[[Platforms]]''''' === | ||
Memento was first implemented on the Android platform for smartphones and tablets, and Android continues to be a prime platform for Memento. The Mobile Edition operates off locally stored data that may or may not be synchronized to the Memento Cloud. | Memento was first implemented on the Android platform for smartphones and tablets, and Android continues to be a prime platform for Memento. The Mobile Edition operates off locally stored data that may or may not be synchronized to the Memento Cloud. | ||
| Line 28: | Line 28: | ||
=== Primary data structures === | === Primary data structures === | ||
User data is stored in Memento in Fields within a Library. See [[Terminology]] to see how this relates to other database technologies and tools. A collection of libraries is called a Group. A collection of fields within a Library structure is called a Page. When data is entered into fields, an Entry is created, so while a library's structure is made up of fields, the library itself is made up of entries. | User data is stored in Memento in Fields within a Library. See '''''[[Terminology]]''''' to see how this relates to other database technologies and tools. A collection of libraries is called a Group. A collection of fields within a Library structure is called a Page. When data is entered into fields, an Entry is created, so while a library's structure is made up of fields, the library itself is made up of entries. | ||
=== Essential features === | === Essential features === | ||
* Storing entries with custom [[Field|fields]] | * Storing entries with custom [[Field|'''''fields''''']] | ||
* Sorting, grouping, and filtering entries by any fields | * Sorting, grouping, and filtering entries by any fields | ||
* Displaying data in the form of a list, table, on a map, or in a calendar | * Displaying data in the form of a list, table, on a map, or in a calendar | ||
* [[Sync with Google Sheets|Synchronization with Google Sheets]] | * [[Sync with Google Sheets|'''''Synchronization with Google Sheets''''']] | ||
* [[Cloud storage and Teamwork|Teamwork]], by providing access to libraries to other users | * [[Cloud storage and Teamwork|'''''Teamwork''''']], by providing access to libraries to other users | ||
* Access to data from several Android devices and from laptop and desktop computers; users can work with the same libraries on their phones, tablets, and PCs. | * Access to data from several Android devices and from laptop and desktop computers; users can work with the same libraries on their phones, tablets, and PCs. | ||
* Dozens of types of [[Field|fields]], including text, integer, real, boolean, date/time, rating, checkboxes, radio buttons, currency, image, signature, file, audio, contact, [[calculation field|calculation]], [[JavaScript]], Google Maps coordinates, and others | * Dozens of types of [[Field|'''''fields''''']], including text, integer, real, boolean, date/time, rating, checkboxes, radio buttons, currency, image, signature, file, audio, contact, [[calculation field|'''''calculation''''']], '''''[[JavaScript]]''''', Google Maps coordinates, and others | ||
* One-to-many, one-to-one, and many-to-many relationships between libraries | * One-to-many, one-to-one, and many-to-many relationships between libraries | ||
* [[Importing and exporting CSV files]], permitting interoperation with popular programs like Microsoft Excel | * '''''[[Importing and exporting CSV files]]''''', permitting interoperation with popular programs like Microsoft Excel | ||
* [[Library | * '''''[[Library protection]]''''' (encrypt entries using AES-128) | ||
* [[Charts]]: Pie, Line, Bar, Columns, Area, Scatter, Stepped Area | * '''''[[Charts]]''''': Pie, Line, Bar, Columns, Area, Scatter, Stepped Area | ||
* Mass calculations (aggregation): sum, maximum, minimum, average | * Mass calculations (aggregation): sum, maximum, minimum, average | ||
* Reminders | * Reminders | ||