Business views are at the core of any data virtualization implementation.
Data virtualization’s business views provide the information your business users require, in a rationalized form they can easily understand and use. These views simplify information access and shield your business users from IT’s complexity.
Your IT staff builds these business views using data virtualization’s rich data analysis, design and development tools. Then when your business users run a report or refresh a dashboard, data virtualization’s high-performance query engine accesses the data sources and delivers the exact information requested.
Federated Business Views vs. Traditional Database Views
Traditional database views are a useful tool within a single relational database environment.
- They provide an easy-to-create, semantically-independent way to model data using standard SQL methods.
- They simplify underlying data structures by abstracting from the source column names and data types to names and types more appropriate for the consuming application.
- And they can join data sets from multiple tables to provide a more complete and useful data set.
- Finally, when queried, they leverage the optimizers in the database to maximize performance.
Unfortunately, when you need to perform these functions across multiple databases or other source types such as files, services, applications, the cloud, and more, traditional single database views do not work.
Federated Business Views Rationalize Terminology while Federating Multiple Sources
Data virtualization lets you easily build and run federated business views to deliver information in a rationalized form that business users can easily understand and use. These views use data abstraction to shield your business users from IT’s complexity.
With the Composite Data Virtualization Platform you create reusable business view to model, access, combine, federate, and deliver data from multiple relational and non-relational sources. The Composite Studio, with its easy-to-learn, point-and-click development environment and automated code generation tools, greatly simplifies view building.
With Composite’s PerformancePlus Adapters, you can include data from multiple relational databases, a wide variety of files including Excel and other formats, application data such as from SAP, and even XML sources without worrying about difficult connections, transforms, or other barriers.
The Composite Data Virtualization Platform stores and manages these views, making them available at runtime to multiple consuming applications such as BI or portals via popular standards including JDBC, ODBC, and ADO.NET. When run, Composite optimizes the query across all the sources required, leveraging source system resources and myriad other optimization techniques, to achieve performance levels unmatched by our competitors.