Fabian Pascal

The PRACTICAL DATABASE FOUNDATIONS series are a set of originally written papers, available exclusively from this site, the objective of which is to explain to IT practitioners the scientific foundation of data management and its practical implications that are not addressed by, or are distorted in the industry, have not been sufficiently or properly clarified, and/or are widely misunderstood.

They will be as definitive statements as possible on the current state of database science, or… Show more

The PRACTICAL DATABASE FOUNDATIONS series are a set of originally written papers, available exclusively from this site, the objective of which is to explain to IT practitioners the scientific foundation of data management and its practical implications that are not addressed by, or are distorted in the industry, have not been sufficiently or properly clarified, and/or are widely misunderstood.

They will be as definitive statements as possible on the current state of database science, or advances thereof. We will strive, on the one hand, to be as close to, and a accurate as possible to the formal foundations of the field, while at the same time use a language as accessible to the IT practitioner as possible, using examples from real practice whenever possible. Show less

Contains discussions on widely misunderstood, but vitally important, database issues. Considers how things should be according to relational theory, what goes wrong in practice due to failing to understand these fundamental concepts, and provides practical recommendations/workarounds where possible. A bridge between theory and practice.

Examines the fundamentals of relational concepts and then demonstrates the applications of these concepts. Provides numerous practical examples using Structured Query Language (SQL), the popular database language for the PC. Users learn how to evaluate, design and implement relational databases and applications by examining relational concepts, their structural, integrity and manipulation features as well as types of tables and relational fidelity. By studying SQL basics, evaluation and… Show more

Examines the fundamentals of relational concepts and then demonstrates the applications of these concepts. Provides numerous practical examples using Structured Query Language (SQL), the popular database language for the PC. Users learn how to evaluate, design and implement relational databases and applications by examining relational concepts, their structural, integrity and manipulation features as well as types of tables and relational fidelity. By studying SQL basics, evaluation and misconceptions, users learn how SQL succeeds--and fails--as a realization of the relational model. Other topics include client/server issues, distributed databases and the emergence of object-oriented database management systems. Show less