The challenges of big data demand a clear theoretical and algebraic framework, extending the standard relational database (RDB) with more powerful features in order to manage the complex schema mappings.

This unique textbook/reference presents a novel approach to database concepts, describing a categorical logic for database schema mapping based on views, within a very general framework for database integration/exchange and peer-to-peer. Issues of database mappings, database programming languages (algebras), and denotational and operational semantics are discussed in depth. An analysis method is also developed that combines techniques from second order logic, data modeling, co-algebras, and functorial categorial semantics.

Topics and features:

• Provides a concise, formal introduction to logics, (co-)algebras, databases, schema mappings and category theory
• Describes the core concepts of big data integration theory, supported by a number of practical examples
• Examines the computational properties of the DB category, compared to the extensions of Codd's SPRJU relational algebra and structured query language (SQL)
• Defines the abstract computational machine, the categorial RDB machine, able to support all DB computations by SQL embedding
• Presents full operational semantics for database mappings (programs)
• Discusses matching and merging operators (tensors) for databases, universal algebra considerations, and algebraic lattices of the databases
• Explores the relationship of the database weak monoidal topos with respect to intuitionistic logic

This self-contained textbook is ideal for graduate courses on database engineering methods, and can also be used as a supplementary text for courses on co-algebras and category theory. Researchers and software engineers interested in databases and logics will also find the book to be a useful reference.

Autorentext

Dr. Zoran Majkic is Chief Technology Advisor at Jumper Consulting Investment Ltd., Dublin, Ireland. He is also affiliated with the International Society for Research in Science and Technology, Tallahassee, FL, USA.

Klappentext

This book presents a novel approach to database concepts, describing a categorical logic for database schema mapping based on views, within a framework for database integration/exchange and peer-to-peer. Database mappings, database programming languages, and denotational and operational semantics are discussed in depth. An analysis method is also developed that combines techniques from second order logic, data modeling, co-algebras and functorial categorial semantics. Features: provides an introduction to logics, co-algebras, databases, schema mappings and category theory; describes the core concepts of big data integration theory, with examples; examines the properties of the DB category; defines the categorial RDB machine; presents full operational semantics for database mappings; discusses matching and merging operators for databases, universal algebra considerations and algebraic lattices of the databases; explores the relationship of the database weak monoidal topos w.r.t. intuitionistic logic.

Inhalt

Introduction and Technical Preliminaries

Composition of Schema Mappings: Syntax and Semantics

Definition of DB Category

Functorial Semantics for Database Schema Mappings

Extensions of Relational Codd's Algebra and DB Category

Categorial RDB Machines

Operational Semantics for Database Mappings

The Properties of DB Category

Weak Monoidal DB Topos