Database track history

• US 7,774,295 B2
• Filed: 11/17/2004
• Issued: 08/10/2010
• Est. Priority Date: 11/17/2004
• Status: Active Grant

• Current Assignee: TARGIT A/S
• Original Assignee: TARGIT A/S
• Inventors: Jensen, Tommy, Middelfart, Morten
• Primary Examiner(s): Fleurantin; Jean B
• Application Number:
  US10/991,302
• Publication Number:
  US 20060106843A1
• Time in Patent Office: 2,092 Days
• Field of Search: 707 1- 10, 707100-1041, 707200-206, 704/1, 704/9, 704/10, 715/237
• US Class Current: 1/1
• CPC Class Codes: G06F 16/283 Multi-dimensional databases or data warehouses, e.g. MOLAP or ROLAP

Abstract

A computer-implemented method of providing a track history of information previously requested from a database. The method includes: providing a track history of user-selectable records that have corresponding metadata items applicable to identify a data set from a data superset stored in the database; providing a bank of transformers with different user-selectable transformers; wherein a selected transformer takes a selected record and transforms the metadata items of the record to application specific metadata according to a syntax determined by the transformer; and activating an application, which accepts the determined syntax, comprising posting the application specific metadata.

Claims

1. A computer-implemented method of providing a track history of information previously requested from a database, the method comprising:

providing, in a computer-readable storage memory, a track history of user-selectable records, said records having corresponding metadata items applicable to identify a data set from a data superset stored in the database;

providing a bank of user-selectable transformers, wherein a selected transformer takes a selected record and transforms the metadata items corresponding to the selected record to application-specific metadata according to a syntax determined by the selected transformer; and

providing activation of an application which accepts the determined syntax, said activation making the application-specific metadata available for use in rendering a presentation of the identified data set by the application.

2. The method according to claim 1, wherein:

a first of the transformers is configured to provide the application-specific metadata using a first syntax which is determined by a transformation embedding the metadata items of the record in an information body text; and

a first application, which accepts the specified syntax, provides a presentation that combines the information body text and the application-specific metadata.

3. The method according to claim 1, wherein the information body text is provided in a natural language.

4. The method according to claim 1, wherein the information text is supplemented by a user'"'"'s description.

5. The method according to claim 1, wherein the records further comprise presentation properties which define properties of the presentation of the data set by means of a graphical object specified by the properties.

6. The method according to claim 1, wherein:

the records further comprise presentation properties which define properties of a presentation of a data set by means of a graphical object specified by the properties; and

the method further comprises providing the presentation of the data set by means of the specified graphical object in accordance with the presentation properties.

7. The method according to claim 6, wherein:

a second of the transformers is configured to provide the application-specific metadata from the metadata items and the presentation properties of a selected record; and

a second application provides a presentation of the data set, identified by the metadata items of the selected record, by means of a graphical object in accordance with the presentation properties of the record.

8. The method according to claim 1, wherein:

the records further comprise presentation properties which define properties of a presentation; and

the method further comprises merging metadata and presentation properties from a record representing a current view and a selected record representing a former view.

9. The method according to claim 1, comprising:

retrieving metadata items of a selected record;

retrieving presentation properties of a record that represents a current view; and

providing the presentation of the data set identified by the retrieved metadata items according to presentation properties retrieved from the record that represents the current view.

10. The method according to claim 9, wherein the metadata items of a selected record are items of a type-setting criteria in identifying a user correlated data subset of the data set.

11. The method according to claim 10, further comprising:

retrieving metadata items of a dimensions type and a measures type from a record representing a current view,

wherein the data set identified by the metadata items of the selected record is further identified by the metadata items of the dimensions type and the measures type from the record representing a current view.

12. The method according to claim 10, wherein:

a record comprises criteria, and

a current presentation comprises a view structure of multiple graphical presentation objects each providing a presentation of a data subset which is partially identified by an individual criterion,

the method comprising;

applying criteria of the record to each of the data subsets to change the identification of the data subsets; and

updating the current presentation to provide a presentation of the data subsets as identified by the changed identification.

13. The method according to claim 10, wherein:

a selected record comprises subsets of metadata items with respective criteria, and

a current presentation comprises a view structure of multiple graphical objects each providing a presentation of a data subset which is partially identified by an individual criterion;

the method comprising;

changing an identification of the data subset of the presentation by application of a respective subset of metadata items of the criteria type in the selected record;

updating the presentation of the current presentation to provide a presentation of the data subsets as identified by the changed identifications.

14. The method according to claim 9, wherein:

a third transformer is configured to provide the application-specific metadata from a selected record and a representation of current presentation properties which are provided by a current presentation; and

a third application provides a presentation of the data set identified by the selected record in accordance with the representation of current presentation properties.

15. The method according to claim 1, wherein:

a fourth transformer is configured to provide the application-specific metadata, and

a fourth application provides changed values of the data set according to a specification of the changes provided in the application-specific metadata.

16. The method according to claim 1, wherein:

a fifth transformer is configured to provide the application-specific metadata, and

a fifth application provides search results in response to search criteria provided in the application-specific metadata.

17. The method according to claim 1, wherein:

a current presentation comprises a view structure of multiple graphical objects each providing a presentation of a respective data subset; and

a graphical object comprises multiple graphical elements, which are associated with metadata items that define criteria for the data of the data subset, represented by means of the elements;

the method comprising;

in response to a user'"'"'s directed action to a graphical element of a graphical object, determining those metadata that applies to the graphical element, and retrieving further data defined by the determined metadata; and

making a presentation of the further data by means of a graphical object of the view structure.

18. The method according to claim 17, wherein, in response to a user'"'"'s directed action to the graphical element of the graphical object, the graphical element is enhanced visually relative to other elements of the graphical object to reflect that the element represents a criterion for the data presented by means of the further graphical object.

19. A computer system with a computer-readable memory device loaded with a program that is configured to perform the computer-implemented method according to claim 1 when run by the computer system.

20. A computer-readable storage medium encoded with a program that is configured to perform the computer-implemented method according to claim 1 when run by a computer.

21. A system comprising:

a display device;

a processor; and

a computer-readable storage medium storing program instructions that, when executed by the processor, configure the system to perform a method for providing a graphical presentation based on a track history of previously requested information, the method comprising;

receiving a user-selection of one of a plurality of stored track history records having corresponding metadata items and presentation properties, wherein;

said metadata items identify a stored data set categorized by one or more measures representing amounts, and by one or more dimensions along which the measures are arrayed, and

said presentation properties define graphical properties of the data set;

receiving a user-selection of one of a plurality of stored transformations;

transforming, using the selected transformation, the metadata items corresponding to the selected record to application-specific metadata according to a syntax determined by the selected transformation; and

activating an application configured to accept the determined syntax, said activation providing a graphical presentation of the data set identified by the metadata items on the display device based on the application-specific metadata and the presentation properties.