Databases
From Just Solve the File Format Problem
(Difference between revisions)
Dan Tobias (Talk | contribs) (Ability appears to use a similar database engine to Access.) |
(→Relational databases) |
||
(31 intermediate revisions by 5 users not shown) | |||
Line 4: | Line 4: | ||
|image=File manager.png | |image=File manager.png | ||
}} | }} | ||
+ | |||
+ | See also [[Serialization]] for methods of storing, exporting, importing, and transferring structured data. | ||
Classes of databases: | Classes of databases: | ||
Line 16: | Line 18: | ||
== General databases == | == General databases == | ||
− | * [[dBase II]] | + | * [[BigTable]] (Google internal database) |
− | * [[dBase III]] | + | * [[DBF]] |
− | * [[ | + | ** [[dBase II]] |
+ | ** [[dBase III]] | ||
+ | * [[LevelDB]] | ||
* [[Mork]] | * [[Mork]] | ||
Line 31: | Line 35: | ||
* [[Extensible Storage Engine]] (ESE, EDB) | * [[Extensible Storage Engine]] (ESE, EDB) | ||
* [[Paradox]] | * [[Paradox]] | ||
+ | |||
+ | == Multiformat platforms/programs/libraries/utilities == | ||
+ | |||
+ | * [[Dat (data sharing)|Dat]] | ||
== NoSQL databases == | == NoSQL databases == | ||
Line 36: | Line 44: | ||
* [[CouchDB]] | * [[CouchDB]] | ||
* [[MongoDB]] | * [[MongoDB]] | ||
+ | * [[Clusterpoint]] | ||
== Object-oriented databases == | == Object-oriented databases == | ||
Line 48: | Line 57: | ||
== Relational databases == | == Relational databases == | ||
+ | * [[Cornerstone]] (Infocom) | ||
* [[Derby]] | * [[Derby]] | ||
+ | * [[FileMaker Pro]] | ||
* [[HSQLDB]] | * [[HSQLDB]] | ||
* [[IBM DB2]] | * [[IBM DB2]] | ||
* [[Ingres]] | * [[Ingres]] | ||
+ | * [[MariaDB]] | ||
+ | ** [[MariaDB error codes]] | ||
* [[MemSQL]] | * [[MemSQL]] | ||
* [[MySQL]] | * [[MySQL]] | ||
+ | ** [[MySQL error codes]] | ||
* [[Oracle]] | * [[Oracle]] | ||
** [[ARC (database backup format)]] | ** [[ARC (database backup format)]] | ||
+ | ** [[Oracle database error messages]] | ||
* [[PostGRESQL]] | * [[PostGRESQL]] | ||
+ | * [[SIARD]] | ||
* [[DB SQL Anywhere|SQL Anywhere]] | * [[DB SQL Anywhere|SQL Anywhere]] | ||
− | * [[ | + | * [[SQLite]] |
+ | ** [[SQLite result codes]] | ||
+ | * [[Virtuoso]] | ||
* [[DB (Watcom-SQL)|Watcom SQL]] | * [[DB (Watcom-SQL)|Watcom SQL]] | ||
Line 66: | Line 84: | ||
* [[Apache Jena]] | * [[Apache Jena]] | ||
* [[Mulgara]] | * [[Mulgara]] | ||
+ | |||
+ | == XML databases == | ||
+ | * [[BaseX]] | ||
+ | * [[Documentum xDB]] | ||
+ | * [[eXist-db]] | ||
+ | * [[MarkLogic]] | ||
+ | * [[Oracle XML DB]] | ||
+ | * [[Qizx]] | ||
+ | * [[Sedna]] | ||
+ | * [[Tamino]] | ||
+ | * [[TEXTML]] | ||
+ | * [[TigerLogic XDMS]] | ||
+ | * [[Xpriori XMS]] | ||
+ | * [[XQuantum]] | ||
+ | |||
+ | == Database programming languages == | ||
+ | * [[Clipper (programming language)]] | ||
+ | * [[dBase programming language]] | ||
+ | * [[FoxPro programming language]] | ||
+ | * [[SQL]] | ||
+ | |||
+ | == Timeseries == | ||
+ | * [[RRD]], round-robin database | ||
+ | * [[Whisper]], used by graphite | ||
+ | |||
+ | == Uncategorized == | ||
+ | * [[DeskMate Filer]] (.fil) | ||
+ | * [[GNU Recutils]] [https://www.gnu.org/software/recutils/] | ||
+ | * [[Microsoft Works Database]] | ||
+ | * [[Tabular Data Package]] | ||
+ | * [[Wikibase]] (back end of Wikidata project from Wikimedia) | ||
+ | |||
+ | == Conversion software == | ||
+ | * [[Embulk]] | ||
== Links == | == Links == | ||
Line 72: | Line 124: | ||
* [http://oddc.opendataresearch.org/ Open Data Research Network] | * [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://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://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://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://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] |
Revision as of 21:59, 12 April 2019
See also Serialization for methods of storing, exporting, importing, and transferring structured data.
Classes of databases:
CODASYL databases
General databases
Hierarchical databases
ISAM (Indexed Sequential Access Method)
- Ability Database (.adb)
- Access (was also known as Jet)
- Extensible Storage Engine (ESE, EDB)
- Paradox
Multiformat platforms/programs/libraries/utilities
NoSQL databases
Object-oriented databases
Relational databases
- Cornerstone (Infocom)
- Derby
- FileMaker Pro
- HSQLDB
- IBM DB2
- Ingres
- MariaDB
- MemSQL
- MySQL
- Oracle
- PostGRESQL
- SIARD
- SQL Anywhere
- SQLite
- Virtuoso
- Watcom SQL
Triplestores
XML databases
- BaseX
- Documentum xDB
- eXist-db
- MarkLogic
- Oracle XML DB
- Qizx
- Sedna
- Tamino
- TEXTML
- TigerLogic XDMS
- Xpriori XMS
- XQuantum
Database programming languages
Timeseries
Uncategorized
- DeskMate Filer (.fil)
- GNU Recutils [1]
- Microsoft Works Database
- Tabular Data Package
- Wikibase (back end of Wikidata project from Wikimedia)
Conversion software
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