Databases
From Just Solve the File Format Problem
(Difference between revisions)
Crusbridge (Talk | contribs) (→CODASYL databases: added some examples of this obsolete type ofa database) |
(→Relational databases) |
||
| (73 intermediate revisions by 11 users not shown) | |||
| Line 1: | Line 1: | ||
| − | { | + | {{FormatInfo |
| − | | | + | |formattype=electronic |
| − | | | + | |thiscat=Databases |
| − | | | + | |image=File manager.png |
| − | + | }} | |
| − | + | ||
| − | + | ||
| + | See also [[Serialization]] for methods of storing, exporting, importing, and transferring structured data. | ||
Classes of databases: | Classes of databases: | ||
| Line 19: | Line 18: | ||
== General databases == | == General databases == | ||
| − | + | * [[BigTable]] (Google internal database) | |
| − | + | * [[DBF]] | |
| − | * [[ | + | ** [[dBase II]] |
| − | * [[ | + | ** [[dBase III]] |
| − | * [[dBase II]] | + | * [[LevelDB]] |
| − | * [[dBase III]] | + | * [[Mork]] |
| − | * [[ | + | * [[PC-FILE]] |
| − | * [[ | + | * [[QDB (Robert R. Marsh)]] |
== Hierarchical databases == | == Hierarchical databases == | ||
* [[IMS]] | * [[IMS]] | ||
| + | |||
| + | == ISAM (Indexed Sequential Access Method) == | ||
| + | |||
| + | * [[Ability Database]] (.adb) | ||
| + | * [[Access]] (was also known as Jet) | ||
| + | * [[Extensible Storage Engine]] (ESE, EDB) | ||
| + | * [[Paradox (database)]] | ||
| + | |||
| + | == Multiformat platforms/programs/libraries/utilities == | ||
| + | |||
| + | * [[Dat (data sharing)|Dat]] | ||
== NoSQL databases == | == NoSQL databases == | ||
| + | |||
| + | * [[CouchDB]] | ||
| + | * [[DynamoDB]] (AWS cloud database) | ||
| + | * [[Elliptics]] | ||
| + | * [[MongoDB]] | ||
| + | * [[Clusterpoint]] | ||
== Object-oriented databases == | == Object-oriented databases == | ||
| Line 45: | Line 61: | ||
== Relational databases == | == Relational databases == | ||
| + | * [[Athena]] (AWS) | ||
| + | * [[Cornerstone]] (Infocom) | ||
* [[Derby]] | * [[Derby]] | ||
| + | * [[FileMaker Pro]] | ||
| + | * [[h2database]] | ||
* [[HSQLDB]] | * [[HSQLDB]] | ||
* [[IBM DB2]] | * [[IBM DB2]] | ||
* [[Ingres]] | * [[Ingres]] | ||
| + | * [[MariaDB]] | ||
| + | ** [[MariaDB error codes]] | ||
| + | * [[MemSQL]] | ||
* [[MySQL]] | * [[MySQL]] | ||
| + | ** [[MySQL error codes]] | ||
* [[Oracle]] | * [[Oracle]] | ||
** [[ARC (database backup format)]] | ** [[ARC (database backup format)]] | ||
| + | ** [[Oracle database error messages]] | ||
| + | * [[Provue Panorama]] (.pan, .pandb) | ||
* [[PostGRESQL]] | * [[PostGRESQL]] | ||
| − | * [[DB | + | * [[SIARD]] |
| + | * [[DB SQL Anywhere|SQL Anywhere]] | ||
| + | * [[SQLite]] | ||
| + | ** [[SQLite result codes]] | ||
| + | * [[Virtuoso]] | ||
| + | * [[DB (Watcom-SQL)|Watcom SQL]] | ||
== Triplestores == | == Triplestores == | ||
| − | [[ | + | * [[3store]] |
| + | * [[Apache Jena]] | ||
| + | * [[Mulgara]] | ||
| + | |||
| + | == XML databases == | ||
| + | * [[BaseX]] | ||
| + | * [[Documentum xDB]] | ||
| + | * [[eXist-db]] | ||
| + | * [[MarkLogic]] | ||
| + | * [[Oracle XML DB]] | ||
| + | * [[Qizx]] | ||
| + | * [[Sedna]] | ||
| + | * [[Tamino]] | ||
| + | * [[TEXTML]] | ||
| + | * [[TigerLogic XDMS]] | ||
| + | * [[Xpriori XMS]] | ||
| + | * [[XQuantum]] | ||
| + | |||
| + | == Database programming/query languages == | ||
| + | * [[Clipper (programming language)]] | ||
| + | * [[dBase programming language]] | ||
| + | * [[Fauna Query Language]] (FQL) | ||
| + | * [[FoxPro programming language]] | ||
| + | * [[PRQL]] | ||
| + | * [[SPARQL]] | ||
| + | * [[SQL]] | ||
| + | |||
| + | == Encrypted databases == | ||
| + | * [[KBDX]] | ||
| + | |||
| + | == Timeseries == | ||
| + | * [[RRD]], round-robin database | ||
| + | * [[Whisper]], used by graphite | ||
| + | |||
| + | == Cloud/network/API databases == | ||
| + | * [[FaunaDB]] | ||
| + | * [[Wikibase]] (back end of Wikidata project from Wikimedia) | ||
| + | |||
| + | == Uncategorized == | ||
| + | * [[Apache Parquet]] | ||
| + | * [[AskSam]] (.ask) | ||
| + | * [[DeskMate Filer]] (.fil) | ||
| + | * [[Folio Infobase]] (.nfo) | ||
| + | * Info File [[FLR]] (.flr) | ||
| + | * [[GNU Recutils]] [https://www.gnu.org/software/recutils/] | ||
| + | * [[Microsoft Works Database]] | ||
| + | * [[TDB (Samba)]] | ||
| + | * [[Tabular Data Package]] | ||
| + | |||
| + | == Conversion software == | ||
| + | * [[Embulk]] | ||
| + | |||
| + | == Links == | ||
| + | |||
| + | * [http://blog.okfn.org/2013/04/24/frictionless-data-making-it-radically-easier-to-get-stuff-done-with-data/ Frictionless data] | ||
| + | * [http://oddc.opendataresearch.org/ Open Data Research Network] | ||
| + | * [http://www.chrisstucchio.com/blog/2013/hadoop_hatred.html Don't use Hadoop - your data isn't that big] | ||
| + | * [http://readwrite.com/2013/10/28/why-proprietary-big-data-technologies-have-no-hope-of-competing-with-hadoop Why Proprietary Big Data Technologies Have No Hope Of Competing With Hadoop] | ||
| + | * [http://www.itnews.com.au/News/357842,social-networks-stick-with-mysql.aspx Social networks stick with MySQL] | ||
| + | * [http://scholarworks.umass.edu/cpo/vol1/iss1/4/ From Punched Cards to "Big Data": A Social History of Database Populism] | ||
| + | * [http://support.microsoft.com/kb/168702 If you move your mouse continually the query may not fail. Do not stop moving] (that's Microsoft for you) | ||
| + | * [http://boingboing.net/2014/01/31/whos-to-blame-for-daughter.html Who's to blame for 'Daughter Killed in Car Crash' mailing sent to parents? Big Data.] | ||
| + | * [http://www.ft.com/cms/s/2/21a6e7d8-b479-11e3-a09a-00144feabdc0.html Big data: are we making a big mistake?] | ||
| + | * [http://magazine.columbia.edu/features/winter-2013-14/ghost-files Big data analysis to see what's missing from the national archives] | ||
| + | * [http://sbdevel.wordpress.com/2014/06/17/terabyte-index-search-and-faceting-with-solr/ Terabyte index, search and faceting with Solr] | ||
| + | * [http://www.loc.gov/preservation/resources/rfs/data.html Library of Congress Recommended Format Specifications: Datasets] | ||
| + | * [http://dataset.readthedocs.org/en/latest/ dataset: databases for lazy people (Python module)] | ||
| + | * [http://www-01.ibm.com/software/data/infosphere/biginsights/resources.html IBM Hadoop info] | ||
| + | * [http://www.database-preservation.com/ Database Preservation Toolkit] | ||
| + | * [http://qntm.org/gay Gay marriage: the database engineering perspective] | ||
Latest revision as of 23:45, 15 March 2024
See also Serialization for methods of storing, exporting, importing, and transferring structured data.
Classes of databases:
[edit] CODASYL databases
[edit] General databases
[edit] Hierarchical databases
[edit] ISAM (Indexed Sequential Access Method)
- Ability Database (.adb)
- Access (was also known as Jet)
- Extensible Storage Engine (ESE, EDB)
- Paradox (database)
[edit] Multiformat platforms/programs/libraries/utilities
[edit] NoSQL databases
- CouchDB
- DynamoDB (AWS cloud database)
- Elliptics
- MongoDB
- Clusterpoint
[edit] Object-oriented databases
[edit] Relational databases
- Athena (AWS)
- Cornerstone (Infocom)
- Derby
- FileMaker Pro
- h2database
- HSQLDB
- IBM DB2
- Ingres
- MariaDB
- MemSQL
- MySQL
- Oracle
- Provue Panorama (.pan, .pandb)
- PostGRESQL
- SIARD
- SQL Anywhere
- SQLite
- Virtuoso
- Watcom SQL
[edit] Triplestores
[edit] XML databases
- BaseX
- Documentum xDB
- eXist-db
- MarkLogic
- Oracle XML DB
- Qizx
- Sedna
- Tamino
- TEXTML
- TigerLogic XDMS
- Xpriori XMS
- XQuantum
[edit] Database programming/query languages
- Clipper (programming language)
- dBase programming language
- Fauna Query Language (FQL)
- FoxPro programming language
- PRQL
- SPARQL
- SQL
[edit] Encrypted databases
[edit] Timeseries
[edit] Cloud/network/API databases
[edit] Uncategorized
- Apache Parquet
- AskSam (.ask)
- DeskMate Filer (.fil)
- Folio Infobase (.nfo)
- Info File FLR (.flr)
- GNU Recutils [1]
- Microsoft Works Database
- TDB (Samba)
- Tabular Data Package
[edit] Conversion software
[edit] Links
- Frictionless data
- Open Data Research Network
- Don't use Hadoop - your data isn't that big
- Why Proprietary Big Data Technologies Have No Hope Of Competing With Hadoop
- Social networks stick with MySQL
- From Punched Cards to "Big Data": A Social History of Database Populism
- If you move your mouse continually the query may not fail. Do not stop moving (that's Microsoft for you)
- Who's to blame for 'Daughter Killed in Car Crash' mailing sent to parents? Big Data.
- Big data: are we making a big mistake?
- Big data analysis to see what's missing from the national archives
- Terabyte index, search and faceting with Solr
- Library of Congress Recommended Format Specifications: Datasets
- dataset: databases for lazy people (Python module)
- IBM Hadoop info
- Database Preservation Toolkit
- Gay marriage: the database engineering perspective
