Extended SQL change definition language for a computer database

Details Extended SQL change definition language for a computer database Extended SQL change definition language for a computer database

1994-05-09

2000-09-05

Fetting, Anton W.

Data processing: database and file management or data structures

Database design

Data structure types

G06F 1500

Patent

active

06115704&

ABSTRACT:
A change definition language (CDL) serves as an extension of (and in the general format of) the structured query language known as SQL. The change definition language allows all important alterations to be described, as changes to an existing definition, for example, and may be used by all phases of the development cycle. The CDL statements do not make the changes directly in the catalog, but instead work through SQL and another intermediate mechanism such as DB2 ALTER tailored to make changes using SQL. The changes expressed in CDL may be migrated to downstream phases and fed back to earlier phases by use of a batch of change statements expressed in CDL.

REFERENCES:
patent: 4558413 (1985-12-01), Schmidt et al.
patent: 4939689 (1990-07-01), Davis et al.
patent: 5197005 (1993-03-01), Shwartz et al.
Danette Chimenti et al, The LDL System Prototype, Mar. 1990 pp. 76-90, IEEE.
James P. Davis and Ronald D. Bonnell (USC east), Edict--An Enhanced Relational Data Dictionary: Architecture and Example, pp. 184-191, IEEE.
Bryan Pfaffenberger, Ph. D., Que's Computer User's Dictionary, 1992, pp. 568-571.
"Clipper developers convene" by John L. Hawkins, Data Based Advisory Aug. 1989 v7 n8 p. 136(3).
"Data Base Management System For Electrical Engineering Department Administrative Operations" by Bell et al, IEEE Proceedings-1990 Southeastern Session 1B1.
Performances of a Distributed Data Base in Token Ring Network for the Interdepartmental Sharing of the Medical Record, 1988, IEEE Engineering in Medicine & Biology Society.
"An Approach to The Distributed Database Construction" by Zayula et al, IEEE 1991.
"First CL/1 modules give Mac boast up corporate ladder" by John Battello, MacWEEK Dec. 12, 1989 v3 n44 p. 1(2).
"Can CL/1 deliver on Apple's promise of remote access?" by John Battelle, MacWEEK Nov. 14, 1989 v3, n42 p. 39(3).
B. Shneiderman et al, "An Architecture for Automatic Relational Database System Conversion", ACM Transactions on Database Systems, vol. 7, No. 2 (Jun. 1982).
J. Kador, "Utility Helps Automate Schema Change Process", System Development, vol. 9, No.1 (Jan. 1989).
Thomas et al, "Automatic Database System Conversion: A Transformation Language Approach to Sub-Schema Implementation", Compsac 80 4th International Computer Software & Application Conference 27 (Oct. 1980) (Chicago).
D. Haderle et al, "IBM Database 2 Overview", IBM Systems Journal, vol. 23, No. 2, (1984).
Elmasri et al, "Fundamentals of Database Systems", Part VI, Commercial Database Systems, Ch. 23, Sec. 23.1, A Relational Database System-DB2, pp. 663-683, 727, 757, 1989.
IBM, "IBM Database 2 Version 2, SQL Reference, Release 2", Second Edition, Sep. 1989, pp. 100-121, (order No. 5C26-4380-1).

Affiliated with

Also associated with

Rating

Extended SQL change definition language for a computer database does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Extended SQL change definition language for a computer database , we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Extended SQL change definition language for a computer database will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-2222798