Functionally-dependent analysis objects
View Patent ↗A system may include a database of physical data tables, a logical database schema of logical entities associated with the physical data tables, and an abstraction layer comprising a plurality of dimension objects mapped to the logical entities, at least one of the plurality of dimension objects comprising one or more properties associating the at least one of the plurality of dimension objects to one or more others of the plurality of dimension objects.
1. A non-transitory computer-readable medium having program code stored thereon, the program code executable by a computer to provide:
an abstraction layer comprising:
a first analysis object comprising an association to a first dimension object;
a second analysis object comprising an association to a second dimension object;
a third analysis object comprising an association to a third dimension object,
wherein the first dimension object comprises one or more properties associating the first dimension object with the second dimension object, and
wherein the second dimension object comprises one or more properties associating the second dimension object with the third dimension object,
wherein the first dimension object and the second dimension object are mapped to logical entities of a logical database schema,
wherein the logical entities of the logical database schema are mapped to tables of a database,
wherein the logical database schema associates a first logical entity of the logical entities to a second logical entity of the logical entities, and associates a third logical entity of the logical entities to the second logical entity of the logical entities, and
wherein the first dimension object is mapped to the first logical entity, the second dimension object is mapped to the second logical entity, and the third dimension object is mapped to the third logical entity.
2. A medium according to claim 1 ,
wherein the first analysis object comprises a key to the first dimension object, and
wherein the second analysis object comprises a key to the second dimension object.
3. A medium according to claim 1 , wherein the second dimension object comprises a property associating the second dimension object with a fourth dimension object.
4. A system comprising:
a database storing data tables; and
a hardware device implementing:
a logical database schema of logical entities associated with the data tables; and
an abstraction layer comprising:
a first analysis object comprising an association to a first dimension object;
a second analysis object comprising an association to a second dimension object; and
a third analysis object comprising an association to a third dimension object,
wherein the first dimension object comprises one or more properties associating the first dimension object with the second dimension object,
wherein the second dimension object comprises one or more properties associating the second dimension object with the third dimension object,
wherein the first dimension object and the second dimension object are mapped to the logical entities,
wherein the logical database schema associates a first logical entity of the logical entities to a second logical entity of the logical entities, and associates a third logical entity of the logical entities to the second logical entity of the logical entities, and
wherein the first dimension object is mapped to the first logical entity, the second dimension object is mapped to the second logical entity, and the third dimension object is mapped to the third logical entity.
5. A system according to claim 4 ,
wherein the first analysis object comprises a key to the first dimension object; and
wherein the second analysis object comprises a key to the second dimension object.
6. A system according to claim 4 , wherein the second dimension object comprises a property associating the second dimension object with a fourth dimension object.