Volume 11, Number 5

Matbase auto Function Non-relational Constraints Enforcement Algorithms

  Authors

Christian Mancas, Ovidius University, Romania

  Abstract

MatBase is an intelligent prototype data and knowledge base management system based on the Relational (RDM), Entity-Relationship, and (Elementary) Mathematical ((E)MDM) Data Models, built upon Relational Database Management Systems (RDBMS). ((E)MDM) has 61 constraint types, out of which21 apply to autofunctions as well. All five relational (RDM) constraint types are passed by MatBase for enforcement to the corresponding RDBMS host. All non-relational ones are enforced by MatBase through automatically generated code. This paper presents and discusses both the strategy and the implementation of MatBase autofunction non-relational constraints enforcement algorithms. These algorithms are taught to our M.Sc. students within the Advanced Databases lectures and labs, both at the Ovidius University and at the Department of Engineering in Foreign Languages, Computer Science Taught in English Stream of the Bucharest Polytechnic University, as well as successfully used by two Romanian software companies.

  Keywords

intelligent systems, data modeling, database constraints theory, relational constraints, non-relational constraints, integrity checking, data structures and algorithms for data management, triggers and rules, business rules, (Elementary) Mathematical Data Model, MatBase, automatic code generation