Building Queries and Data Views
|
Enterprise and the Data View
In Liquid Data, data views are central to solving the data integration problem one time (as opposed to once per query) and providing a basis for simpler application development work on top of that integrated view. In this model:
- A data architect with an intimate knowledge of the relationship of the available diverse data sources develops a set of data views based on the needs of various parts of the enterprise.
For example, a view of an employee developed for an enterprise might include employee salary and address information from one data source; information about their health insurance from another data source; information from their company assets (computer, phone, etc.) might be included from a third data source.
- Liquid Data is then used to create, refine, and validate each of the data views through queries built up through the Data View Builder.
- Once validated, a reusable representation of each data view is developed through the Data View Builder and Administration Console as a new data view.
- Then the Liquid Data data view can be used throughout the enterprise as a virtual data source for queries. For example, a query for a new payroll division application might select salary information from this view.
In this model a data view provides an appropriate architectural view of corporate data that is available for specialized queries and sharable throughout the enterprise.