System and method for applying user supplied relation definition

Boots – shoes – and leggings

Patent

Rate now

  [ 0.00 ] – not rated yet Voters 0   Comments 0

Details

364DIG1, 3642821, 3642834, G06F 1730

Patent

active

055048862

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.

REFERENCES:
patent: 4506326 (1985-03-01), Shaw et al.
patent: 4688195 (1987-08-01), Thompson et al.
patent: 4791561 (1988-12-01), Huber
patent: 4905138 (1990-02-01), Bourne
patent: 4930071 (1990-05-01), Tou et al.
patent: 4931928 (1990-06-01), Greenfield
patent: 5117349 (1992-05-01), Tirfing et al.
patent: 5129086 (1992-07-01), Coyle, Jr. et al.
patent: 5297279 (1994-03-01), Bannon et al.
patent: 5367675 (1994-11-01), Cheng et al.
patent: 5379419 (1995-01-01), Heffernan et al.
patent: 5394546 (1995-02-01), Hanatsuka
"Power Tools", IBM Technical Disclosure Bulletin, New York, U.S., Sep., 1989, pp. 262-265.
"A Logical Table For User Defined Columns In Relational Databases", IBM Technical Disclosure Bulletin, New York, U.S. (Apr. 1992).
"User-Defined Logical Relationship In Visual Query", IBM Technical Disclosure Bulletin, New York, U.S., Nov., 1990, pp. 221-222.
"Next-Generation Database Systems," Communications Of The ACM, Oct., 1991, vol. 34, No. 10, pp. 95-109.
L. M. Haas et al., "Starburst Mid-Flight: As The Dust Clears," Research Report, New York, U.S., Jan. 22, 1990, pp. 1-29.

LandOfFree

Say what you really think

Search LandOfFree.com for the USA inventors and patents. Rate them and share your experience with other people.

Rating

System and method for applying user supplied relation definition does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with System and method for applying user supplied relation definition, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method for applying user supplied relation definition will most certainly appreciate the feedback.

Rate now

     

Profile ID: LFUS-PAI-O-2023905

  Search
All data on this website is collected from public sources. Our data reflects the most accurate information available at the time of publication.