IP Library Granted Patent US 8,996,552
Granted Patent B2
US 8,996,552 · App. 13/684,400 · Granted Mar 31, 2015

System and method for graphically creating queries on model data

Inventors: Ralf Werner Munkes (Woelfling-lès-Sarreguemines, FR); Stefan Ruschel (Schmelz, DE); Markus Werner (Zweibrücken, DE)
Assignee: Software AG
G06F17/30967G06F17/30398G06F17/30545
View Patent ↗
Loading inventors, assignments & file history…
Monitor This Case
Get email alerts when status or documents change.
Order Certified Copies
Most orders are placed with the USPTO same day — all within 24 business hours.
Order via The Patent Place →
Pre-filled with this patent's details
Quick Facts
Patent No.
US 8,996,552
App. No.
13/684,400
Granted
Mar 31, 2015
Kind
B2
Abstract

Certain example embodiments relate to techniques for creating queries on model data of at least one data source (DS 1 , . . . , DS 3 ) in accordance with at least one data source specific format. A graphical query builder (QB) is configured to enable a user to graphically define a query including multiple building blocks in accordance with a data source independent format (MM). At least one adapter (A 1 , . . . , A 3 ) for the at least one data source (DS 1 , . . . , DS 3 ) is configured to translate the query in the data source independent format (MM) into at least one corresponding query in the data source specific format.

Claims (33)

1. A system for creating queries on model data of at least one data source in accordance with at least one data source specific format, wherein the system comprises:

processing resources including at least one processor and a memory;

a graphical query builder configured to enable a user to graphically define a query comprising a plurality of building blocks in accordance with a data source independent format; and

a plurality of adapters configured to translate the graphically defined query in the data source independent format into at least one corresponding query in the data source specific format, the plurality of adapters including a first adapter for a first data source configured to translate a portion of the graphically defined query in the data source independent format into a corresponding partial query in the first data source specific format, and a second adapter for a second data source configured to translate another portion of the graphically defined query in the data source independent format into a corresponding partial query in the second data source specific format, wherein

the first and second data sources are heterogeneous and at least one of the first and second adapters defines a mapping between objects in the first data source and the second data source.

2. The system of claim 1 , wherein the graphical query builder is further configured to enable the user to select one or more building blocks for defining the query in the data source independent format, wherein each building block represents a query object or a query relation.

3. The system of claim 2 , wherein the query relation is a relation between two query objects, a filter relation, and / or a user-defined relation.

4. The system of claim 1 , wherein model data of the first data source represents graphical model data and model data of the second data source represents non-graphical model data.

5. The system of claim 1 , wherein the system is configured for combining results of the partial queries.

6. The system of claim 1 , wherein the graphical query builder is configured to enable the user to graphically define queries in an iterative manner.

7. The system of claim 1 , wherein at least one of the adapters is a web service.

8. The system of claim 7 , wherein the web service is a RESTful web service.

9. The system of claim 8 , wherein the RESTful web service is configured for communicating with the graphical query builder using HTTP.

10. The system of claim 7 , wherein the web service is configured for communicating with the graphical query builder using HTTP.

11. The system of claim 1 , wherein the query in the data source independent format is a directed graph.

12. The system of claim 1 , wherein each adapter is configured to implement a common API for providing access to the model data in the respective data source.

13. The system of claim 1 , wherein the system is configured to store the query in the data source independent format on a storage medium; and

wherein the system is configured to use stored queries for graphically defining a further query.

14. The system of claim 1 , wherein at least one of the adapters is configured to access the at least one data source in accordance with an authorization and / or authentication mechanism.

15. The system of claim 1 , wherein the data source independent format is built from a plurality of meta models of the data source(s).

16. The system of claim 1 , wherein the data source independent format is a meta model that is common to a plurality of different data sources.

17. The system of claim 1 , further comprising:

wherein the data source independent format is built from a meta model of the first data source and a meta model of the second data source, and the query in the data source independent format includes objects from the first data source and the second data source.

18. A method for creating queries on model data of at least one data source in accordance with at least one data source specific format, the method comprising:

a. graphically defining a query with a graphical query builder running on a computer, the query comprising a plurality of building blocks in accordance with a data source independent format; and

b. translating, in connection with a plurality of adapters, the graphically defined query in the data source independent format into at least one corresponding query in the data source specific format, the translating comprising translating, in connection with a first adapter for a first data source, at least a portion of the graphically defined query into a corresponding partial query in the first data source specific format, and translating, in connection with a second adapter for a second data source, another portion of the graphically defined query into a corresponding partial query in the second data source specific format, wherein

the first and second data sources are heterogeneous and at least one of the first and second adapters defines a mapping between objects in the first data source and the second data source.

19. The method of claim 18 , wherein the query is graphically defined in an iterative manner.

20. The method of claim 18 , wherein model data of the first data source represents graphical model data and model data of the second data source represents non-graphical model data.

21. A non-transitory computer readable storage medium tangibly storing a computer program comprising instructions for at least:

graphically defining a query with a graphical query builder running on a computer, the query comprising a plurality of building blocks in accordance with a data source independent format; and

translating, in connection with a plurality of adapters the graphically defined query in the data source independent format into at least one corresponding query in the data source specific format, the translating comprising translating, in connection with a first adapter for a first data source, at least a portion of the graphically defined query into a corresponding partial query in the first data source specific format, and translating, in connection with a second adapter for a second data source, another portion of the graphically defined query into a corresponding partial query in the second data source specific format, wherein

the first and second data sources are heterogeneous and at least one of the first and second adapters defines a mapping between objects in the first data source and the second data source.

Assignments (5)
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Sep 9, 2025
From: SOFTWARE GMBH
To: SAG ARIS GMBH
Reel/Frame 072867/0138 →
MERGER Recorded Dec 17, 2024
From: SOFTWARE AG
To: MOSEL BIDCO AG
Reel/Frame 069715/0235 →
CHANGE OF NAME Recorded Dec 17, 2024
From: MOSEL BIDCO AG
To: SOFTWARE GMBH
Reel/Frame 069715/0411 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Dec 6, 2012
From: MUNKES, RALF WERNER; RUSCHEL, STEFAN; WERNER, MARKUS
To: SOFTWARE AG
Reel/Frame 029415/0421 →
ASSIGNMENT OF ASSIGNOR'S INTEREST Recorded Nov 23, 2012
From: MUNKES, RALF WERNER; RUSCHEL, STEFAN; WERNER, MARKUS
To: SOFTWARE AG
Reel/Frame 029343/0590 →
Priority Claims (1)
EP 12191218 · Nov 5, 2012 · regional
Continuity (1)
Related Publication 20140129583A1 · May 8, 2014