alexa Matbase relational import subsystem


Journal of Information Technology & Software Engineering

Author(s): Christian Mancas, Simona Mancas

Abstract Share this page

MatBase is a Knowledge and Database Management System based on the Elementary Mathematical Data Model (EMDM). Its relational import subsystem provides users with the ability to incorporate databases from IBM DB/2, Oracle, or MS SQL Server and Access RDBMS. During import, besides copying table schemes and data, corresponding EMDM scheme and entity-relationship diagram (E-RD) are generated too and a design checking is also performed, including keys, references integrity, and existence constraints, as well as optional E-RD closed loops signalization. Checking is done according to MatBase higher relational standards: for example, every table should have an autonumber primary key, at least another (semantic) key and a not-null column, all keys should be minimally one-to-one, whereas all foreign keys should reference primary keys. Whenever this is possible, design flaws are automatically corrected; when not, they are only logged into MatBase system tables. The paper focuses on the two linear translation algorithms from the relational data model (RDM) to EMDM and ERDM that are reverse conceptual engineering tools reconstructing object-oriented mathematical semantics and visual structuring respectively from relational syntax. As an example, these algorithms are applied to a RDM domain-key normal form meta-catalog database.

This article was published in DBA'06 Proceedings of the 24th IASTED international conference on Database and applications and referenced in Journal of Information Technology & Software Engineering

Relevant Expert PPTs

Relevant Speaker PPTs

Recommended Conferences

Peer Reviewed Journals
Make the best use of Scientific Research and information from our 700 + peer reviewed, Open Access Journals
International Conferences 2017-18
Meet Inspiring Speakers and Experts at our 3000+ Global Annual Meetings

Contact Us

© 2008-2017 OMICS International - Open Access Publisher. Best viewed in Mozilla Firefox | Google Chrome | Above IE 7.0 version