Nuhad ShaabaniSQL’s Object-Oriented FeaturesObject-relational database systems (ORDBMS) extend relational database systems (RDBMS) by object-oriented features, such as user-defined…Feb 8Feb 8
Nuhad ShaabaniPractical Introduction to Dimensional Data DesignDimensional modeling is an alternative to entity-relationship (ER) modeling. A dimensional model contains the same information as an ER…Sep 11, 20231Sep 11, 20231
Nuhad ShaabaniPractical Introduction to Data Vault ModelingThe Data Vault modeling is used to model the enterprise Data Warehouse Core layer. The model is suitable for multi-source environments…Jul 15, 20231Jul 15, 20231
Nuhad ShaabaniReferential Integrity Beyond Primary Key-Foreign Key RelationshipIntegrity constraints ensure that changes made to the database by authorized users do not result in a loss of data consistency. Thus…May 17, 2023May 17, 2023