Dynamic generation of dimensional metadata

Details Dynamic generation of dimensional metadata Dynamic generation of dimensional metadata

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.

Affiliated with

Also associated with

Rating

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.

Rate now

Comments { 0 }

Profile ID: LFCA-PAI-O-1557307