System and method of formulating queries in relational...

Details System and method of formulating queries in relational... System and method of formulating queries in relational...

2007-11-13

2007-11-13

Lee, Wilson (Department: 2163)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000

Reexamination Certificate

active

10835522

ABSTRACT:
The invention introduces a method and system to automatically derive the relationships between query subjects and query items within query subjects so that problems such as those that result in double courting of information are avoided. It provides for creating a report by first defining a model based on an existing database comprising two or more query subjects, each query subject comprising at least one fact query item and one primary key, then generating a hierarchy of sets and subsets of key query items within the model. Next a further fact is introduced into one of the query subjects. The expression is decomposed into sub-queries to prevent double counting of data in ambiguously defined situations. This is achieved using the introduced fact to determine that such decomposition is required. Finally, the data is accessed using the sub-queries, and a report is produced.

REFERENCES:
patent: 4454576 (1984-06-01), McInroy et al.
patent: 5903859 (1999-05-01), Stone et al.
patent: 6003036 (1999-12-01), Martin
patent: 6411961 (2002-06-01), Chen
patent: 6581068 (2003-06-01), Bensoussan et al.
patent: 6658627 (2003-12-01), Gallup et al.
patent: 6738762 (2004-05-01), Chen et al.
patent: 6847962 (2005-01-01), Cochrane et al.
patent: 6996566 (2006-02-01), George et al.
patent: 6999977 (2006-02-01), Norcott et al.
patent: 2003/0088558 (2003-05-01), Zaharioudakis et al.
patent: 2003/0154277 (2003-08-01), Haddad et al.
patent: 2004/0039729 (2004-02-01), Boger et al.
patent: 2004/0249810 (2004-12-01), Das et al.
patent: 2004/0268306 (2004-12-01), Cheng et al.
patent: 0 413 486 (1991-02-01), None

Affiliated with

Also associated with

Rating

System and method of formulating queries in relational... 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 of formulating queries in relational..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and System and method of formulating queries in relational... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3869824