SADL query view—a model-driven approach to speed-up read-only use cases

US8874601B2 · kind B2 · utility

Assignee

• SAP AG · DE

Inventors

• Marcel Hermanns · Heidelberg, DE
• Jens Weiler · Weingarten, DE
• Michael Brombach · Leimen, DE
• Monika Kaiser · Bad Schönborn, DE
• Jan Teichmann · Hamburg, DE
• Thomas Gauweiler · Speyer, DE
• Daniel Hutzel · Karlsruhe, DE

Key dates

• Filing date: Dec 17, 2010
• Grant date: Oct 28, 2014
• Expiry date: Mar 26, 2032

Classification

• Technology area (CPC G): Physics
• CPC primary: G06F16/2448
• WIPO field: Computer technology
• WIPO sector: Electrical engineering

Abstract

Embodiments of the invention relate to computing, and in particular, to a systems and methods for a querying a database. Certain embodiments implement a model-driven database query (“the SADL query”) facilitating a design-time tool that allows a developer to create the query based upon existing Business Objects (BOs) and their associations. This SADL query leverages mapping between business-layer entities and database-layer entities, such mapping being derived from association metadata already extant in the business model used to create the Business Objects. In certain embodiments, query views may be based upon associations present within the business layer, rather than upon database-level entities (such as joins or restriction rules) that are typically relied upon in conventional query creation. Embodiments of the present invention may thus align query creation more closely with the structure of the business layer, and may also render query design agnostic relative to the identity of the underlying database.