G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 17/30 (2006.01)
Patent
CA 2427226
The invention introduces a methodology to automatically derive the relationships between tables and columns within tables so that problems such as those that result in double counting of information are avoided. It comprises a method for creating a report by first defining a model based on an existing database comprising two or more querySubjects, each querySubject comprising at least one fact column and one primary key column, then generating a hierarchy within the model. Next a further fact is introduced into one of the querySubjects. The expression is decomposed into sub-queries so that double-counting of data in ambiguously defined situations is prevented using the further 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
Dynamic generation of dimensional metadata does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Dynamic generation of dimensional metadata, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Dynamic generation of dimensional metadata will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1557307