G - Physics – 06 – F
Patent
G - Physics
06
F
G06F 19/00 (2006.01) G06F 17/30 (2006.01) G06F 17/60 (2000.01)
Patent
CA 2427159
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.
Potter Charles Mike
Seeds Glen Michael
Cognos Incorporated
Gowling Lafleur Henderson Llp
LandOfFree
Simplified metadata modelling for reporting does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Simplified metadata modelling for reporting, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Simplified metadata modelling for reporting will most certainly appreciate the feedback.
Profile ID: LFCA-PAI-O-1426658