首页    期刊浏览 2024年11月28日 星期四
登录注册

文章基本信息

  • 标题:A generator of SQL schema specifications
  • 本地全文:下载
  • 作者:Aleksić Slavica ; Luković Ivan ; Mogin Pavle
  • 期刊名称:Computer Science and Information Systems
  • 印刷版ISSN:1820-0214
  • 电子版ISSN:2406-1018
  • 出版年度:2007
  • 卷号:4
  • 期号:2
  • 页码:81-100
  • DOI:10.2298/CSIS0702081A
  • 出版社:ComSIS Consortium
  • 摘要:

    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 according 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 database constraint using procedural mechanisms of a particular relational DBMS. SQL Generator is implemented in Java and Oracle JDeveloper environment.

国家哲学社会科学文献中心版权所有