Databases: Difference between revisions
expanding on === Triplestore === + w:object database |
expanding, arranging, linking |
||
| Line 3: | Line 3: | ||
== Known types of databases == | == Known types of databases == | ||
* [[w:Relational database]] or [[w:RDBMS]] | * [[w:Relational database]] or [[w:RDBMS]] | ||
* [[w:Triplestore]] | * [[w:Triplestore]]s handle information stored as [[w:RDF]]-[[w:triplet|triplet]]s almost always in the subject-predicate-object form | ||
* [[w:Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks. | * [[w:Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks. | ||
* [[w:Object database]]s were a supposed fad in the late 80's and early 90's as [[w:relational algebra]] based systems are quite old. | * [[w:Object database]]s were a supposed fad in the late 80's and early 90's as [[w:relational algebra]] based systems are quite old. | ||
== | == Relational database == | ||
* On default [[MediaWiki]]s run on [[w:MySQL]] or the better and more ethical binary compatible drop-in replacement [[w:MariaDB]]. A recent fork by the original MySQL founders from MySQL. The Netherlands server serving the [[Consumium]] free social media run on MariaDB 10. | * On default [[MediaWiki]]s run on [[w:MySQL]] or the better and more ethical binary compatible drop-in replacement [[w:MariaDB]]. A recent fork by the original MySQL founders from MySQL. The Netherlands server serving the [[Consumium]] free social media run on MariaDB 10. | ||
| Line 13: | Line 13: | ||
* Postgresql is also in use working as data storage for [[w:GNU MediaGoblin]] at https://media.consumium.org | * Postgresql is also in use working as data storage for [[w:GNU MediaGoblin]] at https://media.consumium.org | ||
=== | == Subject-predicate-object database == | ||
A [[w:triplestore]] maybe a native implementation from ground up or be standing on the shoulders of a standard RDBMS system where actual [[w:SQL]] is formulated by the interpreter and then queried from SQL. This probably has upsides and downsides. | |||
* [[w:List of subject-predicate-object databases|Wikipedia's list of subject-predicate-object databases]] | |||
== Graph database == | |||
* [[w:Graph_database#List_of_graph_databases|Wikipedia's list of graph databases]] | * [[w:Graph_database#List_of_graph_databases|Wikipedia's list of graph databases]] | ||
== Object database == | |||
* [[w:Object_database#Timeline|Wikipedia's chronological list of object databases]] | |||
Revision as of 14:06, 26 August 2016
This article is about choice of database models and implementations.
Known types of databases
- w:Relational database or w:RDBMS
- w:Triplestores handle information stored as w:RDF-triplets almost always in the subject-predicate-object form
- w:Graph databases would intuitively appear more advanced than using RDF-triplet composed semantic networks.
- w:Object databases were a supposed fad in the late 80's and early 90's as w:relational algebra based systems are quite old.
Relational database
- On default MediaWikis run on w:MySQL or the better and more ethical binary compatible drop-in replacement w:MariaDB. A recent fork by the original MySQL founders from MySQL. The Netherlands server serving the Consumium free social media run on MariaDB 10.
- Postgresql is also in use working as data storage for w:GNU MediaGoblin at https://media.consumium.org
Subject-predicate-object database
A w:triplestore maybe a native implementation from ground up or be standing on the shoulders of a standard RDBMS system where actual w:SQL is formulated by the interpreter and then queried from SQL. This probably has upsides and downsides.