Databases: Difference between revisions
expanding, arranging, linking |
Expanding on == Subject-predicate-object database == |
||
| Line 14: | Line 14: | ||
== Subject-predicate-object database == | == Subject-predicate-object database == | ||
Subject-predicate-object databases basically construct [[w:semantic]] networks from interlinked atomic units called a [[w:triplet]]. | |||
These networks may be queried with a suitable query language such as [[w:SPARQL]] which in practice allows you to compose semantic queries. | |||
=== Relevant subject-predicate-object database powered systems to interoperate with === | |||
* [[Semantic MediaWiki]] | |||
* [[DBpedia]] | |||
* [[Wikidata]] | |||
=== Things to consider in selection of triplestore === | |||
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. | 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. | ||
=== Lists and comparisons of subject-predicate-object databases === | |||
* [[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]] | ||
Revision as of 14:13, 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
Subject-predicate-object databases basically construct w:semantic networks from interlinked atomic units called a w:triplet.
These networks may be queried with a suitable query language such as w:SPARQL which in practice allows you to compose semantic queries.
Relevant subject-predicate-object database powered systems to interoperate with
Things to consider in selection of triplestore
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.