EP0534466A3 - Change definition language for computer database system - Google Patents

Change definition language for computer database system Download PDF

Info

Publication number
EP0534466A3
EP0534466A3 EP19920116474 EP92116474A EP0534466A3 EP 0534466 A3 EP0534466 A3 EP 0534466A3 EP 19920116474 EP19920116474 EP 19920116474 EP 92116474 A EP92116474 A EP 92116474A EP 0534466 A3 EP0534466 A3 EP 0534466A3
Authority
EP
European Patent Office
Prior art keywords
catalog
phases
changes
definition
cdl
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
EP19920116474
Other versions
EP0534466B1 (en
EP0534466A2 (en
Inventor
Jack E. Olson
Linda C. Elliott
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
BMC Software Inc
Original Assignee
BMC Software Inc
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by BMC Software Inc filed Critical BMC Software Inc
Publication of EP0534466A2 publication Critical patent/EP0534466A2/en
Publication of EP0534466A3 publication Critical patent/EP0534466A3/en
Application granted granted Critical
Publication of EP0534466B1 publication Critical patent/EP0534466B1/en
Anticipated expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases
    • Y—GENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10—TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10S—TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00—Data processing: database and file management or data structures
    • Y10S707/99931—Database or file accessing
    • Y10S707/99933—Query processing, i.e. searching

Abstract

A database application implemented on a computer includes a generic database management product (software) such as IBM DB2 along with a catalog defining the way the data itself is stored. The catalog is a definition of the tables, indexes, views, user authorizations, etc., that specify a user's particular application of the database management system. Access to the database via the catalog uses a structured query language or (SQL) which provides a way of expressing statements in a high-level language so the user will not be burdened with writing code to access the data itself. The structured query language provides statements for defining tables, indexes, views, etc., to be incorporated into the catalog. A database application (to fit a user's business) is generated and updated in a number of phases, such as design, development, test and production, and in each one of these phases a facility exists for making alterations in the database definition (catalog), all of which make use of SQL to implement the changes. According to a feature of the invention, a change definition language (CDL) is provided which is an extension of (and in the general format of) the structured query language. 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. <IMAGE>
EP92116474A 1991-09-27 1992-09-25 Change definition language for computer database system Expired - Lifetime EP0534466B1 (en)

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
US76723091A 1991-09-27 1991-09-27
US767230 1991-09-27

Publications (3)

Publication Number Publication Date
EP0534466A2 EP0534466A2 (en) 1993-03-31
EP0534466A3 true EP0534466A3 (en) 1993-10-13
EP0534466B1 EP0534466B1 (en) 2002-04-10

Family

ID=25078879

Family Applications (1)

Application Number Title Priority Date Filing Date
EP92116474A Expired - Lifetime EP0534466B1 (en) 1991-09-27 1992-09-25 Change definition language for computer database system

Country Status (5)

Country Link
US (1) US6115704A (en)
EP (1) EP0534466B1 (en)
AT (1) ATE216104T1 (en)
CA (1) CA2079131C (en)
DE (1) DE69232542T2 (en)

Families Citing this family (55)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5410693A (en) * 1994-01-26 1995-04-25 Wall Data Incorporated Method and apparatus for accessing a database
US5826076A (en) * 1994-05-13 1998-10-20 Liant Software Corporation Computer-based information access method and apparatus to permit SQL-based manipulation of programming language-specific data files
US5675785A (en) * 1994-10-04 1997-10-07 Hewlett-Packard Company Data warehouse which is accessed by a user using a schema of virtual tables
US5717924A (en) * 1995-07-07 1998-02-10 Wall Data Incorporated Method and apparatus for modifying existing relational database schemas to reflect changes made in a corresponding object model
JP3836928B2 (en) * 1997-02-26 2006-10-25 株式会社日立製作所 Database processing method
US6243703B1 (en) * 1997-10-14 2001-06-05 International Business Machines Corporation Method of accessing and displaying subsystem parameters including graphical plan table data
GB2334601B (en) * 1998-02-20 2002-12-11 Ibm Database data model extension
US6529904B1 (en) * 1998-05-28 2003-03-04 Oracle Corp. Deployment of snapshots with parameterized data description language strings
GB2341250A (en) * 1998-09-04 2000-03-08 Balaena Limited Database structure avoids duplication of stored data
US6687695B1 (en) * 1998-10-02 2004-02-03 Ncr Corporation SQL-based analytic algorithms
JP2000250791A (en) * 1999-03-03 2000-09-14 Nec Corp Method and device for displaying message in dml object reproduction mode and recording medium with this method programmed and recorded therein
US6480848B1 (en) * 1999-07-19 2002-11-12 International Business Machines Corporation Extension of data definition language (DDL) capabilities for relational databases for applications issuing DML and DDL statements
CA2279028C (en) * 1999-07-29 2002-09-10 Ibm Canada Limited-Ibm Canada Limitee Dropped database table recovery
US7010531B1 (en) * 1999-11-24 2006-03-07 Unisys Corporation Method and apparatus for a web application server to create an empty data set in a repository with a specified dataset ID
WO2002042934A1 (en) * 2000-11-27 2002-05-30 Randal Walker Method and system for managing data modelled in the form of objects, and method and system for constructing and managing pages using said method
US6959301B2 (en) * 2001-01-04 2005-10-25 Reuters Limited Maintaining and reconstructing the history of database content modified by a series of events
US7089258B1 (en) * 2002-01-25 2006-08-08 Ncr Corporation System and method for structure subset generation for multiple databases
US20030177146A1 (en) * 2002-03-18 2003-09-18 International Business Machines Corporation Method, system, and program product for migrating data from one data base management system to another data base management system
US7133875B1 (en) * 2002-04-12 2006-11-07 Oracle International Corporation Method and apparatus for redefining a group of related objects in a relational database system
US7080081B2 (en) * 2002-04-15 2006-07-18 International Business Machines Corporation Multidimensional data clustering scheme for query processing and maintenance in relational databases
US7634460B2 (en) * 2002-06-28 2009-12-15 Sas Institute Inc. Computer-implemented data replacement graphical user interface system and method
CA2391692C (en) 2002-07-15 2006-07-04 Allan Williams Computer database with adaptive storage space architecture
US20040172307A1 (en) * 2003-02-06 2004-09-02 Gruber Martin A. Electronic medical record method
US8166101B2 (en) 2003-08-21 2012-04-24 Microsoft Corporation Systems and methods for the implementation of a synchronization schemas for units of information manageable by a hardware/software interface system
US8238696B2 (en) 2003-08-21 2012-08-07 Microsoft Corporation Systems and methods for the implementation of a digital images schema for organizing units of information manageable by a hardware/software interface system
US7908562B2 (en) * 2003-10-23 2011-03-15 Microsoft Corporation System and a method for presenting items to a user with a contextual presentation
US20050091181A1 (en) * 2003-10-23 2005-04-28 Mckee Timothy P. System and method for the presentation of items stored on a computer
US7730073B2 (en) * 2003-10-23 2010-06-01 Microsoft Corporation System and a method for presenting related items to a user
US7376665B2 (en) * 2003-11-06 2008-05-20 At&T Delaware Intellectual Property, Inc. Systems, methods and computer program products for automating retrieval of data from a DB2 database
DE102004025440A1 (en) * 2004-05-24 2005-12-22 Sap Ag Interface-controlled display of a matrix document in areas
DE102004025439A1 (en) * 2004-05-24 2005-12-22 Sap Ag Computer-implemented output of table rows to output device
JP4143611B2 (en) * 2005-02-04 2008-09-03 インターナショナル・ビジネス・マシーンズ・コーポレーション Backup generation device, recovery processing device, backup generation method, recovery processing method, and program
US20060190476A1 (en) * 2005-02-18 2006-08-24 Mettovaara Risto K Database storage system and associated method
US20060195436A1 (en) * 2005-02-28 2006-08-31 Fujitsu Network Communications, Inc. Phased migration of database software application
US7580958B2 (en) 2005-06-17 2009-08-25 International Business Machines Corporation Supporting multiple versions of a routine
US7647527B2 (en) * 2006-01-11 2010-01-12 International Business Machines Corporation Apparatus and method for collecting and displaying data for remote diagnostics
US8112396B2 (en) * 2006-06-07 2012-02-07 Emc Corporation Backup and recovery of integrated linked databases
US7672934B1 (en) * 2006-10-19 2010-03-02 Symantec Operting Corporation Method for restoring documents from a database file
US7822729B2 (en) * 2007-08-15 2010-10-26 International Business Machines Corporation Swapping multiple object aliases in a database system
US7908299B2 (en) * 2008-01-31 2011-03-15 Computer Associates Think, Inc. Method and apparatus for pseudo-conversion of table objects
US8108431B1 (en) * 2008-03-24 2012-01-31 Autotelika, Incorporated Two-dimensional data storage system
US8010578B2 (en) * 2008-06-27 2011-08-30 Microsoft Corporation Method of refactoring a running database system
US8122066B2 (en) * 2008-10-14 2012-02-21 Hewlett-Packard Development Company, L.P. Database query profiler
US10169599B2 (en) * 2009-08-26 2019-01-01 International Business Machines Corporation Data access control with flexible data disclosure
US9224007B2 (en) 2009-09-15 2015-12-29 International Business Machines Corporation Search engine with privacy protection
US20110106853A1 (en) * 2009-10-30 2011-05-05 Microsoft Corporation Declarative model security pattern
US9600134B2 (en) 2009-12-29 2017-03-21 International Business Machines Corporation Selecting portions of computer-accessible documents for post-selection processing
US8694560B2 (en) 2011-07-26 2014-04-08 General Electric Company Systems and methods for table definition language generation
JP5838732B2 (en) * 2011-10-31 2016-01-06 富士通株式会社 Program, information processing apparatus and information processing method
US8738569B1 (en) * 2012-02-10 2014-05-27 Emc Corporation Systematic verification of database metadata upgrade
US9892278B2 (en) 2012-11-14 2018-02-13 International Business Machines Corporation Focused personal identifying information redaction
US9946781B2 (en) * 2015-06-02 2018-04-17 Sap Se System and method of implementing table aliases
KR101905771B1 (en) * 2016-01-29 2018-10-11 주식회사 엔오디비즈웨어 Self defense security server with behavior and environment analysis and operating method thereof
CN108399196B (en) * 2018-01-30 2022-07-29 福建星瑞格软件有限公司 Automatic sql execution method and system of database sql statement automatic generation tool
US11531652B2 (en) * 2019-08-30 2022-12-20 Oracle International Corporation Database modularization of pluggable guest languages

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4558413A (en) * 1983-11-21 1985-12-10 Xerox Corporation Software version management system
US4939689A (en) * 1987-04-09 1990-07-03 Crowninshield Software, Inc. Outline-driven database editing and retrieval system
US5197005A (en) * 1989-05-01 1993-03-23 Intelligent Business Systems Database retrieval system having a natural language interface

Non-Patent Citations (4)

* Cited by examiner, † Cited by third party
Title
ACM TRANSACTIONS ON DATABASE SYSTEMS vol. 7, no. 2, June 1982, BALTIMORE, US pages 235 - 257 B. SHNEIDERMAN ET AL : 'An Architecture for Automatic Relational Database System Conversion' *
COMPSAC 80 4TH INTERNATIONAL COMPUTER SOFTWARE & APPLICATION CONFERENCE 27 October 1980, CHICAGO, US pages 80 - 88 THOMAS ET AL : 'Automatic Database System Conversion : A Transformation Language Approach to Sub-Schema Implementation' *
IBM SYSTEMS JOURNAL vol. 23, no. 2, 1984, ARMONK, NEW YORK US pages 112 - 125 D. HADERLE ET AL : 'IBM Database 2 Overview' *
SYSTEM DEVELOPMENT vol. 9, no. 1, January 1989, pages 4 - 5 J. KADOR : 'Utility Helps Automate Schema Change Process' *

Also Published As

Publication number Publication date
DE69232542T2 (en) 2002-11-21
DE69232542D1 (en) 2002-05-16
EP0534466B1 (en) 2002-04-10
CA2079131A1 (en) 1993-03-28
EP0534466A2 (en) 1993-03-31
ATE216104T1 (en) 2002-04-15
US6115704A (en) 2000-09-05
CA2079131C (en) 2003-04-08

Similar Documents

Publication Publication Date Title
EP0534466A3 (en) Change definition language for computer database system
Date A critique of the SQL database language
Kim et al. Classifying schematic and data heterogeneity in multidatabase systems
US20050234889A1 (en) Method and system for federated querying of data sources
JPH0527149B2 (en)
Petkovic Temporal data in relational database systems: A comparison
US6983291B1 (en) Incremental maintenance of aggregated and join summary tables
Klug ABE-a query language for constructing aggregates-by-example
de Paula Braganholo et al. Updating relational databases through XML views
Kline et al. SQL in a nutshell: a desktop quick reference guide
Kreines Oracle SQL: the essential reference
Taylor SQL for Dummies
Milstead Indexing for subject cataloguers
Lynch Understanding SQL
Ramirez et al. Extension of relational views to derived relations with exceptions
Yannakoudakis et al. A domain-oriented approach to improve the user-friendliness of SQL
Earp et al. Practical guide to using SQL in Oracle
SÎRBESCU 3. ACADEMY APPLICATION 3.1 Purpose of this work
McCoy Interfacing Ada and relational databases
Streeter Some relational query language design issues and the language MQL
Hoffer et al. The database environment
AU2004202616B2 (en) Method for Maintaining Exception Tables for a Check Utility
Kaur An Illustrative Approach to Use SQL Functions: A Review
Templeton InterViso: a data integration server
USER OMBRETRIEVE USER

Legal Events

Date Code Title Description
PUAI Public reference made under article 153(3) epc to a published international application that has entered the european phase

Free format text: ORIGINAL CODE: 0009012

AK Designated contracting states

Kind code of ref document: A2

Designated state(s): AT BE CH DE DK ES FR GB GR IE IT LI LU MC NL PT SE

PUAL Search report despatched

Free format text: ORIGINAL CODE: 0009013

AK Designated contracting states

Kind code of ref document: A3

Designated state(s): AT BE CH DE DK ES FR GB GR IE IT LI LU MC NL PT SE

17P Request for examination filed

Effective date: 19940221

17Q First examination report despatched

Effective date: 19980730

GRAG Despatch of communication of intention to grant

Free format text: ORIGINAL CODE: EPIDOS AGRA

RIC1 Information provided on ipc code assigned before grant

Free format text: 7G 06F 17/30 A

GRAG Despatch of communication of intention to grant

Free format text: ORIGINAL CODE: EPIDOS AGRA

GRAH Despatch of communication of intention to grant a patent

Free format text: ORIGINAL CODE: EPIDOS IGRA

REG Reference to a national code

Ref country code: GB

Ref legal event code: IF02

GRAH Despatch of communication of intention to grant a patent

Free format text: ORIGINAL CODE: EPIDOS IGRA

GRAA (expected) grant

Free format text: ORIGINAL CODE: 0009210

AK Designated contracting states

Kind code of ref document: B1

Designated state(s): AT BE CH DE DK ES FR GB GR IE IT LI LU MC NL PT SE

PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: IT

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT;WARNING: LAPSES OF ITALIAN PATENTS WITH EFFECTIVE DATE BEFORE 2007 MAY HAVE OCCURRED AT ANY TIME BEFORE 2007. THE CORRECT EFFECTIVE DATE MAY BE DIFFERENT FROM THE ONE RECORDED.

Effective date: 20020410

Ref country code: FR

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: NL

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: AT

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: BE

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: LI

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: CH

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

Ref country code: GR

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020410

REF Corresponds to:

Ref document number: 216104

Country of ref document: AT

Date of ref document: 20020415

Kind code of ref document: T

REG Reference to a national code

Ref country code: CH

Ref legal event code: EP

REG Reference to a national code

Ref country code: IE

Ref legal event code: FG4D

REF Corresponds to:

Ref document number: 69232542

Country of ref document: DE

Date of ref document: 20020516

PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: DK

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020710

Ref country code: SE

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020710

Ref country code: PT

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20020710

NLV1 Nl: lapsed or annulled due to failure to fulfill the requirements of art. 29p and 29m of the patents act
PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: IE

Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES

Effective date: 20020925

Ref country code: LU

Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES

Effective date: 20020925

REG Reference to a national code

Ref country code: CH

Ref legal event code: PL

PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: ES

Free format text: LAPSE BECAUSE OF FAILURE TO SUBMIT A TRANSLATION OF THE DESCRIPTION OR TO PAY THE FEE WITHIN THE PRESCRIBED TIME-LIMIT

Effective date: 20021030

EN Fr: translation not filed
PLBE No opposition filed within time limit

Free format text: ORIGINAL CODE: 0009261

STAA Information on the status of an ep patent application or granted ep patent

Free format text: STATUS: NO OPPOSITION FILED WITHIN TIME LIMIT

PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: MC

Free format text: LAPSE BECAUSE OF NON-PAYMENT OF DUE FEES

Effective date: 20030401

26N No opposition filed

Effective date: 20030113

REG Reference to a national code

Ref country code: IE

Ref legal event code: MM4A

PGFP Annual fee paid to national office [announced via postgrant information from national office to epo]

Ref country code: DE

Payment date: 20100922

Year of fee payment: 19

PGFP Annual fee paid to national office [announced via postgrant information from national office to epo]

Ref country code: GB

Payment date: 20110921

Year of fee payment: 20

REG Reference to a national code

Ref country code: DE

Ref legal event code: R071

Ref document number: 69232542

Country of ref document: DE

REG Reference to a national code

Ref country code: DE

Ref legal event code: R071

Ref document number: 69232542

Country of ref document: DE

REG Reference to a national code

Ref country code: GB

Ref legal event code: PE20

Expiry date: 20120924

PG25 Lapsed in a contracting state [announced via postgrant information from national office to epo]

Ref country code: DE

Free format text: LAPSE BECAUSE OF EXPIRATION OF PROTECTION

Effective date: 20120926

Ref country code: GB

Free format text: LAPSE BECAUSE OF EXPIRATION OF PROTECTION

Effective date: 20120924