Home

Jump to bottom

François-Xavier Babin edited this page Apr 6, 2022 · 1 revision

Welcome to the DBMS wiki!

Client DBMS:

SELECT
WHERE (AND OR '(' parsing ) -> AST (arbre binaire)
FROM
CREATE/DELETE DATABASE
CREATE/DELETE TABLE

Serveur DBMS:

systeme de fichier (oriente ligne)
sockets/interpretation (cf -> doc)
gestion de contraintes (required/null, types, PK)

Topics Avancés Serveur:

Indexation
Propriétés ACID -> transactions (norme RFC ?)

Topics Avancés Client:

JOIN
WINDOW FUNCTIONS
AGGREGATIONS/ GROUP BY/ ORDER BY
TRANSACTIONS / ROLLBACK
SUBQUERY
IN BETWEEN LIKE IS
VIEW

idee 1

Clone this wiki locally