Volume 9, Number 11, August 2019
Matbase – A Tool for Transparent Programming While Modelling Data at Conceptual Levels
Authors
Christian Mancas, Ovidius University, Romania
Abstract
MatBase is a prototype intelligent data and knowledge base management system based on the Relational, Entity-Relationship, and (Elementary) Mathematical Data Models, having two current versions (MS SQL Server and C#, MS Access and VBA). Users may work with it only at one or any combination of these conceptual levels, without any programming knowledge (be it SQL, C#, VBA, etc.), to create, populate, update, and delete databases and corresponding management software applications. The paper introduces the MatBase architecture and the principles used to transparently program while modelling data at these three conceptual levels with this tool. A real-life example illustrates them.
Keywords
Conceptual Data Modelling, Automatic Code Generation, Relational Constraints, Non-relational Constraints, DBMS Engine Architectures, The (Elementary) Mathematic Data Model, MatBase