Generate in-memory views from universe schema

摘要

In one aspect, a Universe designed and built in a database is used for modeling data in an in-memory database. The Universe is loaded in a front-end development application to display a universe schema contained in the Universe. The logic built in the front-end development application enables parsing the universe schema, to determine patterns matching in-memory views such as attribute views and analytic views. The determined patterns are generated as attribute views and analytic views, and displayed for user selection. Selected attribute views and analytic views are stored in the in-memory database.

主权项

1. An article of manufacture including a non-transitory computer readable storage medium to tangibly store instructions, which when executed by a computer, cause the computer to:
determine a first pattern comprising a first table with one join and a one-to-many join relationship with a second table; based on the determined first pattern, generate a first attribute view with the first table and the second table; determine a second pattern comprising a fact table with more than two joins, more than one numeric field and a many-to-one join relationship with one or more adjoining tables in a star schema; based on the determined second pattern, generate an analytic view with the fact table and the one or more adjoining tables of the fact table; determine a fourth pattern comprising a fourth table with more than two joins and a many-to-one join relationship with a fifth table, wherein the fourth table is not the fact table; and based on the determined fourth pattern, generate a second attribute view with the fourth table and the fifth table.