G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01) G06Q 10/00 (2012.01)
Patent
CA 2465584
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 counting 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.
Cazemier Hendrik
He Xiaowen
Cognos Incorporated
Gowling Lafleur Henderson Llp
LandOfFree
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.
Profile ID: LFCA-PAI-O-1729202