Nuhad Shaabani·Jul 24Solving a System of Linear Equations using SQLThe model in the SQL MODEL clause [1] is a data matrix with a variable number of dimensions and consists of a subset of columns from the…
Nuhad Shaabani·Feb 19SQL-Implementation of Monte-Carlo IntegrationThe purpose of this article is to demonstrate the feature of defining functions in the WITH clause by implementing the Monte-Carlo method…
Nuhad Shaabani·Apr 20, 2025Analyzing Soccer Data Using Row Pattern MatchingThe MATCH_RECOGNIZE clause in the SQL SELECT statement supports SQL functionality for finding patterns in sequences of rows [1, 2]…
Nuhad Shaabani·Aug 15, 2024Practical Introduction to Applying Data Profiling in Data NormalizationData profiling is the activity of systematically extracting knowledge of the structure and properties of a dataset. The gained knowledge is…
Nuhad Shaabani·Feb 8, 2024SQL’s Object-Oriented FeaturesObject-relational database systems (ORDBMS) extend relational database systems (RDBMS) by object-oriented features, such as user-defined…
Nuhad Shaabani·Sep 11, 2023Practical Introduction to Dimensional Data DesignDimensional modeling is an alternative to entity-relationship (ER) modeling. A dimensional model contains the same information as an ER…A response icon1A response icon1
Nuhad Shaabani·Jul 15, 2023Practical 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…A response icon5A response icon5
Nuhad Shaabani·May 17, 2023Referential 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…