Browse Prior Art Database

Closed Loop Database Modeling and Construction

IP.com Disclosure Number: IPCOM000129239D
Publication Date: 2005-Oct-03
Document File: 2 page(s) / 50K

Publishing Venue

The IP.com Prior Art Database

Abstract

The development process for databases necessitates the construction of several different versions of a database of varying sizes. For example a development version would be very small, a test version would be sized to fit on test system hardware and a production version sized to handle production requirements. In the past these would need to be manually built either using a vendor tool or by editing database build scripts. The closed loop database modeling and construction process uses a combination of third-party vendor tools and internally developed software to model and build variable sized databases.

This text was extracted from a Microsoft Word document.
At least one non-text object (such as an image or picture) has been suppressed.
This is the abbreviated version, containing approximately 63% of the total text.

Closed

Loop

Database Modeling and Construction

The development process for databases necessitates the construction of several different versions of a database of varying sizes.  For example a development version would be very small, a test version would be sized to fit on test system hardware and a production version sized to handle production requirements.  In the past these would need to be manually built either using a vendor tool or by editing database build scripts.

The closed loop database modeling and construction process uses a combination of third-party vendor tools and internally developed software to model and build variable sized databases.  A spreadsheet is used to dynamically compute table and index sizes for a particular database instance.  A configuration file is generated by the spreadsheet and used by scripts to generate storage clauses during an automated database build.  The loop is closed through the use of Microsoft Visio’s reverse engineering and SQL code generation capabilities.  In addition, scripts are used to analyze the SQL code and populate the spreadsheet with table characteristics used for sizing computations.

A typical use of this process would involve the following steps:

1.  Design the database model using Microsoft Visio’s Database Model Diagram facilities.

2.  Generate the SQL Data Definition Language (DDL) using Visio for Enterprise Architects.

3.  Standardize the format of the DDL to allow for analysis and storage clause gen...