US5504886A
Expired / Lapsed
US
⏱️ 0.0 years remaining
System and method for applying user supplied relation definitions to application files for a relational database
Assignee: International Business Machines Corp
•
Filing: 1993-07-02
•
Granted: 1996-04-02
•
Expires: 2013-07-02
Abstract
Abstract Disclosed is a system and method for applying structured query language on user application files not conforming to the definition of a base relation of a relational database management system. A relational database management system has a runtime supervisor and a data manager. For the use of the data manager a plurality of library procedures generalized for manipulation of user application files are provided installed with the database management system. Responsive to user selection, a class for user application files is defined by naming members of a set of the library procedures for use with member application files of the class and by naming the class. Further responsive to user selection, column definitions on an application file within the class are made to create a user defined table. The user defined table corresponds to a specified user application file and to the definition. To create a class of user application files, a class control block is created in which the members of the set of library procedures are named for the class. For the user defined table, a user defined table control block is created in which the column definitions are stored. Both control blocks are accessible to the runtime supervisor for use with an access plan generated from SQL statements. Special structured query language statements are provided for user invocation to define a class of user application files and for providing column definitions, as well as for deleting a class control block and a user defined table control block.
Inventors
- 👤 David Y. Chang
- 👤 Timothy R. Malkemus
Bibliographic Details
Application Number
—
Jurisdiction
US
Data Source
google_patents
Last Synchronized
2026-10-30 18:53
CPC Classifications
G; G06; G06F; G06F16/00; G06F16/20; G06F16/28; G06F16/284; Y; Y10; Y10S; Y10S707/00; Y10S707/99931; Y10S707/99932
Claims Analysis
Total Claims: 8
Claim 1
Independent Claim
147 words
A method of manipulating application files through a relational database management system on a computer, the application file consisting of tuples of atomic data, the method comprising the steps of: providing a set of data management functions for manipulating application files; responsive to user selection, defining a table type including an application file on the data management functions; responsive to user description of columns of an application file and specification of the table type for the application file, creating a relational table control block for the application file; processing a source file for user generated structured query language statements; and responsive to processing of a structured query language statement directed to the application file, applying the user definitions of the data management functions for the table type of the application file and user descriptions of columns for the application file in executing the structured query language statement.
Claim 2
Independent Claim
147 words
A method of manipulating application files through a relational database management system on a computer, the application file consisting of tuples of atomic data, the method comprising the steps of: providing a set of data management functions for manipulating application files; responsive to user selection, defining a table type including an application file on the data management functions; responsive to user description of columns of an application file and specification of the table type for the application file, creating a relational table control block for the application file; processing a source file for user generated structured query language statements; and responsive to processing of a structured query language statement directed to the application file, applying the user definitions of the data management functions for the table type of the application file and user descriptions of columns for the application file in executing the structured query language statement.
Claim 3
Dependent Claim
41 words
A method as set forth in claim 1, wherein the step of providing the data management functions for a table type including the application file further includes prompting user: naming of the table type; and naming of each data management function.
Claim 4
Dependent Claim
39 words
A method as set forth in claim 2, wherein the step of creating relational table control block for the application file includes: installing the column description's user defined table name and table type name in the table control block.
Claim 5
Dependent Claim
135 words
A relational database management system comprising: a structured query language processor for compiling source files containing structured query language statements and generating an access plan from the structured query language statements; a set of generalized procedures for manipulation of application files and records within application files; a data manager for executing the generalized procedures to manipulate application files; means for generating user defined table type control blocks defining a set of functions on the set of generalized procedures for a table type; means for generating user defined table control blocks for describing domains over data in an application file; and a runtime supervisor for executing the access plan with the user defined table type control blocks and the user defined table control blocks and for thereby directing the data manager to execute particular generalized procedures.
Claim 6
Dependent Claim
135 words
A relational database management system comprising: a structured query language processor for compiling source files containing structured query language statements and generating an access plan from the structured query language statements; a set of generalized procedures for manipulation of application files and records within application files; a data manager for executing the generalized procedures to manipulate application files; means for generating user defined table type control blocks defining a set of functions on the set of generalized procedures for a table type; means for generating user defined table control blocks for describing domains over data in an application file; and a runtime supervisor for executing the access plan with the user defined table type control blocks and the user defined table control blocks and for thereby directing the data manager to execute particular generalized procedures.
Claim 7
Dependent Claim
50 words
A relational database management system as set forth in claim 4, wherein the structured query language processor includes syntax for compiling statements for establishing the user defined table type control blocks and the user defined table control blocks and for destroying the user defined table type and table control blocks.
Claim 8
Dependent Claim
29 words
A relational database management system as set forth in claim 5, wherein the application file is a data stream received by a data processing system on an input/output port.
References Cited (Backward Citations)
US4688195A
Cited
US4506326A
Cited
US4905138A
Cited
US4791561A
Cited
US4930071A
Cited
US4931928A
Cited
US5129086A
Cited
US5117349A
Cited
US5297279A
Cited
US5394546A
Cited
US5379419A
Cited
US5367675A
Cited
USPTO Annuity & Maintenance Windows
| Annuity Stage | Window Opens | Payment Deadline | Surcharge Period Until | Estimated Fee | Status |
|---|---|---|---|---|---|
| 3.5 Years (Year 4) | 1999-04-02 | 1999-10-02 | 2000-04-02 | $2000.00 | Window Closed / Lapsed |
| 7.5 Years (Year 8) | 2003-04-02 | 2003-10-02 | 2004-04-02 | $3760.00 | Window Closed / Lapsed |
| 11.5 Years (Year 12) | 2007-04-02 | 2007-10-02 | 2008-04-02 | $7700.00 | Window Closed / Lapsed |