公开(公告)号：BR9101195A

公开(公告)日：1991-11-05

申请号：BR9101195

申请日：1991-03-26

Applicant: IBM

Inventor： ADAIR JOHN GARY ,  DEMERS RICHARD AIME ,  ECIMOVIC DUSAN ,  JACKSON ROBERT DEAN ,  LINDSAY BRUCE GILBERT ,  MURPHY MICHAEL EDWARD ,  REINSCH ROGER ALAN ,  RESCH ROBERT PETER ,  SANDERS RICHARD ROLAND ,  SELINGER PATRICIA GRIFFITHS ,  SUNDAY ROBERT LEO ,  ZIMOWSKI MELVIN RICHARD

IPC: G06F12/00 ,  G06F17/30 ,  G06F13/16 ,  G06F15/40

Abstract: The present invention relates to a data base system comprising a first computer (10) which is used to execute an application program (14), a data base (56) containing selected data for use in connection with the application program, a second computer (12) which is used to control the part of the data base system which contains the data base, the first and second computers being different types, means 17) for extracting from the application program data base commands which can be executed on the second computer but cannot be executed on the first computer, and means for replacing the extracted data base commands with call commands and for using the call commands to initiate the execution of the data base commands when required. According to the invention the data base system is characterised in that it also comprises means (46, 50) for transmitting the data base commands to the second computer, and means (52) for utilising the call commands in the application program to initiate the execution of the data base commands by the second computer on the selected data in the data base.

公开(公告)号：BR8901647A

公开(公告)日：1989-11-21

申请号：BR8901647

申请日：1989-04-07

Applicant: IBM

Inventor： CHANG PHILIP YEN-TANG ,  COYLE DANIEL JEROME JR ,  HOWIE LAUREN DENISE ,  LINDSAY BRUCE GILBERT

IPC: G06F17/30 ,  G06F15/40

Abstract: A plurality of packed descriptions is provided as a column in a table each entry containing data defining attributes associated with a different object (such as a table or view defined to the database) and all its component objects (such as related columns and indexes). Accessing the row corresponding to a particular object returns a description of all of the attributes of the object's component objects, as well as information describing the object itself. The packed description information is redundantly stored conventionally in other system catalogs for use IN at IN querying physical definitions of objects in a manner consistent with other database products. The database state information comprising the packed descriptions is retained in internal format whereas the correlative redundant information is in a user-readable external format. By denormalising the schema for schema data whereby identifying relationships between objects is simplified, time required for compilation of statements referencing objects is substantially reduced. All information concerning attributes of an object specified in statement and its component objects necessary to compile the statement may thereby be fetched from the packed description field corresponding to the object in one I/O operation. Objects' descriptions must otherwise be retrieved from numerous I/Os to separate system catalogs and rows collectively containing the descriptions.