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

摘要

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.