GENERATING SQL SPECIFICATIONS OF A DATABASE SCHEMA FOR DIFFERENT DBMSS
Slavica Aleksić
Fakultet tehničkih nauka, Novi Sad
Ivan Luković
Fakultet tehničkih nauka, Novi Sad
Keywords:
Database Schema Design and Implementation; Database Constraints; SQL Generator; IIS Case
Abstract
In the paper we present an SQL generator, which is integrated into IIS*Case -- a software tool for automated design and generating of database schemas. The SQL generator can generate implementation specifications of a database schema according to ANSI SQL:2003 standard, as well as for current database management systems (DBMSs) MS SQL Server and Oracle Server. We discuss some specific features of the SQL generator that concern implementation of relation schemes and database constraints for the selected DBMSs, under the server programming languages T-SQL and PL/SQL. Based on a selected example, we compare the features of T-SQL and PL/SQL in the course of implementation of database constraints, and also analyze the conformance of MS SQL Server and Oracle SQL to ANSI SQL:2003.
