Databases: Difference between revisions

    From Consumerium development wiki R&D Wiki
    (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

    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.

    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.

    Lists and comparisons of subject-predicate-object databases

    Graph database

    Object database