UDC 004.43

A Generator of SQL Schema Specifications

Slavica Aleksić1, Ivan Luković1, Pavle Mogin2 and Miro Govedarica1

  1. University of Novi Sad, Faculty of Technical Sciences
    21000 Novi Sad, Trg Dositeja Obradovića 6, Serbia
    {slavica, ivan, miro}@uns.ns.ac.yu
  2. Victoria University of Wellington
    Wellington, P.O. Box 600, New Zealand
    pmogin@mcs.vuw.ac.nz

Abstract

IIS*Case is an integrated CASE tool that supports the automation and intelligent support of complex and highly formalized design and programming tasks in the development of an information system. IIS*Case, as a tool from the class of domain oriented design environments, generates relational database schemas in 3rd normal form with all relevant data constraints. SQL Generator is an IIS*Case tool that generates the implementation specification of a database schema ac­cording to ANSI SQL:2003 standard. The generator may also produce a database schema specification for Microsoft SQL Server or Oracle DBMSs. The paper describes SQL Generator's traits, considers aspects of its application, and shows its use in the implementation of a complex da­tabase constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper envi­ronment.

Publication information

Volume 4, Issue 2 (December 2007)
Advances in Programming Languages
Year of Publication: 2007
ISSN: 2406-1018 (Online)
Publisher: ComSIS Consortium

Full text

DownloadAvailable in PDF
Portable Document Format

How to cite

Aleksić, S., Luković, I., Mogin, P., Govedarica, M.: A Generator of SQL Schema Specifications. Computer Science and Information Systems, Vol. 4, No. 2, 79-98. (2007)