bea.com | products | dev2dev | support | askBEA

Download Docs | Site Map | Glossary
Search

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.