Databases: Difference between revisions

    (tweaks)
    (→‎Relational database: expanding on basics)
    Line 14: Line 14:
    == Relational database ==
    == Relational database ==


    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.
    Relational databases work by storing data in [[w:Table (database)|tabular form]] where [[w:column (database)|columns]] represent data items of predetermined type and [[w:row (database)|rows]] represent the values each "item" has. Relational databases are accessed mainly with [[w:SQL|SQL]] ( Structured Query Language ). However the RDBMS converts that into [[w:relational algebra|relational algebra]] and optimizes that and the relational algebra query actually returns the result table that has those columns and rows you requested.


    Together Consumerium and Consumium run all the 3 major free full fledged RDBMS:  
    Together Consumerium and Consumium run all the 3 major free full fledged RDBMS: