Databases

    From Consumerium development wiki R&D Wiki
    Revision as of 14:37, 26 August 2016 by Jukeboksi (talk | contribs) (reworking content, adding links, clarifying info)

    This article is about choice of database models and implementations.

    Known types of databases

    Relational database

    Together Consumerium and Consumium run all the 3 major free full fledged RDBMS there are: w:MariaDB, w:MySQL and w:Postgresql.

    Relevant relational database powered software

    • 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