Database schema transformation and optimization

1995 ◽  
pp. 191-203 ◽  
Author(s):  
T. A. Halpin ◽  
H. A. Proper
Keyword(s):  
Database Schema ◽  
Schema Transformation

THE GEMS DATABASE SCHEMA FOR GEOLOGIC MAPS – ENSURING COMPLIANCE WITH THE STANDARD

2020 ◽  
Author(s):  
David R. Soller ◽  
◽  
Ralph A. Haugerud ◽  
Evan E. Thoms ◽  
Nancy R. Stamm ◽  
...  
Keyword(s):  
Database Schema ◽  
Geologic Maps

Database schema evolution using EVER diagrams

1994 ◽  
Author(s):  
Chien-Tsai Liu ◽  
Shi-Kuo Chang ◽  
Panos K. Chrysanthis
Keyword(s):  
Database Schema ◽  
Schema Evolution

Defining Rules for Schema Transformation

OOIS’98 ◽  
1998 ◽  
pp. 313-330
Author(s):  
Yangjun Chen ◽  
Wolfgang Benn
Keyword(s):  
Schema Transformation

scholarly journals A generator of SQL schema specifications

2007 ◽  
Vol 4 (2) ◽  
pp. 81-100 ◽  
Author(s):  
Slavica Aleksic ◽  
Ivan Lukovic ◽  
Pavle Mogin ◽  
Miro Govedarica
Keyword(s):  
Information System ◽  
Normal Form ◽  
Relational Database ◽  
Sql Server ◽  
Database Schema ◽  
Intelligent Support ◽  
Case Tool ◽  
Design Environments ◽  
Data Constraints

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.

Sign in / Sign up

Export Citation Format

Share Document