Bureaucrats, developer, Administrators
9,854
edits
Databases: Difference between revisions
tweaks
(moved content from SPARQL and fixed the headings once again) |
(tweaks) |
||
| Line 6: | Line 6: | ||
* [[w:Relational database|Relational database]] provided by a [[w:RDBMS|RDBMS]] and queried with [[w:SQL|SQL]]. Track-proven technology. | * [[w:Relational database|Relational database]] provided by a [[w:RDBMS|RDBMS]] and queried with [[w:SQL|SQL]]. Track-proven technology. | ||
* [[w:NoSQL]] variates: | * [[w:NoSQL]] variates: | ||
** Subject-predicate-object | ** [[w:Subject-predicate-object databases]] are implemented by [[w:graph databases|graph databases]], specialized native [[w:Triplestore|triplestore]]s and piggy-packing solutions that use an RDBMS to store and query the triplets and the networks they compose. | ||
** [[w:Graph databases|Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks but are not much different on the outside. Both jump through the same hoops but with different efficiency and grace. | ** [[w:Graph databases|Graph databases]] would intuitively appear more advanced than using RDF-triplet composed semantic networks but are not much different on the outside. Both jump through the same hoops but with different efficiency and grace. | ||
** [[w:Object database|Object database]]s are old but on the rise with NoSQL-based thinking and the modern needs, like leanness, real-time need and scaleability for which the other solutions might be too limiting. | ** [[w:Object database|Object database]]s are old but on the rise with NoSQL-based thinking and the modern needs, like leanness, real-time need and scaleability for which the other solutions might be too limiting. | ||
---- | |||
== Relational database == | == Relational database == | ||
Together Consumerium and Consumium run all the 3 major free full fledged RDBMS | |||
Relational databases work by translating [[w:SQL|SQL]] into [[w:relational algebra|relational algebra]] and optimizing and the relational algebra query actually returns the rows. | |||
Together Consumerium and Consumium run all the 3 major free full fledged RDBMS: | |||
* [[w:MariaDB]], a binary compatible drop-in replacement for MySQL that provides some technical advantages and the warm feeling that this is a fork of MySQL by the original MySQL AB founders. | * [[w:MariaDB]], a binary compatible drop-in replacement for MySQL that provides some technical advantages and the warm feeling that this is a fork of MySQL by the original MySQL AB founders. | ||
* [[w:MySQL]], the most widely known of free databases powering this [[Development Wiki]] | * [[w:MySQL]], the most widely known of free databases powering this [[Development Wiki]] | ||
* [[w:PostgreSQL]] powering the https://media.consumium.org [[w:GNU MediaGoblin]] | * [[w:PostgreSQL]] powering the https://media.consumium.org [[w:GNU MediaGoblin]] | ||
---- | |||
== NoSQL databases == | == NoSQL databases == | ||
| Line 21: | Line 28: | ||
All the following database types can be considered variations of NoSQL. | All the following database types can be considered variations of NoSQL. | ||
---- | |||
=== Subject-predicate-object database === | === Subject-predicate-object database === | ||
| Line 45: | Line 54: | ||
* [[w:List of subject-predicate-object databases|Wikipedia's list of subject-predicate-object databases]] | * [[w:List of subject-predicate-object databases|Wikipedia's list of subject-predicate-object databases]] | ||
* [[w:List of SPARQL implementations|Wikipedia's list of SPARQL implementations]] | * [[w:List of SPARQL implementations|Wikipedia's list of SPARQL implementations]] | ||
---- | |||
=== Graph database === | === Graph database === | ||
| Line 50: | Line 61: | ||
* [[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 === | === Object database === | ||
* [[w:Object_database#Timeline|Wikipedia's chronological list of object databases]] | * [[w:Object_database#Timeline|Wikipedia's chronological list of object databases]] | ||