The BizQuery suite provides facilities for vertical integration of semantically interrelated data from different sources. Some data sources can be XML-based, while others can be relational. Data integration is accomplished on the fly at run-time according to the stated mapping rules, which make definition of integrated data sources relations and dependencies. Global data schema can be modeled either with UML or with XML DTD. UML could be the preferable technique for data modeling in the case of complicated heterogeneous data, and could be applied for modeling a wide-range of systems. BizQuery provides an automated method for querying across multiple heterogeneous databases in a uniform way. In essence, a global schema is created to represent a particular application domain and data sources are mapped as views over the global schema. The user asks a query over the global schema and the data integration system reformulates this into a query over the data sources and executes it.
Based on the UML model three kinds of GUI are automatically generated:
- forms & graphic map for declarative searching
- catalogs for navigational searching
Results of all queries are represented in XML and are displayed to the user with XSL-based visualizer.
BizQuery has very limited requirements for local data source management systems. In the case of XML-based sources, a support for Xquery is required. For relational data sources, SQL query language should be supported. For example, such data management systems as Tamino, Excelon and Oracle may be used without any changes to the BizQuery software.
BizQuery Features and Advantages
- Global data schema support ensure hiding all the peculiarities of underlying data sources in order to provide a unified view of all data.
- Flexible mechanism of mapping rules allows the user to make changes into the model and data dependencies definitions in a smooth and effective way
- Accessibility via a two level interface offers two ways to query data: in terms of XML as well as in terms of the UML model.
- XQuery support according to W3C Xquery specification.
- Search by metadata. For non-XML sources, description of non-XML data can be presented in XML in correspondence to the BizModel for further searching on these data.
- Automatic yet customized generation of 3 kinds of GUI for searching (i.e. forms, graphic map, catalogs).
- Native techniques to manage XML data.
- Support for open standards ensures easy integration with the existing applications based on XML, XSLT, XQuery, OMG XMI, OMG UML, SOAP, etc.
- Product extensibility. The layered system architecture allows replacing the existing modules with your favorite ones and/or adding new ones (i.e. support for third party products). BizQuery comes with all the necessary modules and tools but you have the ability to replace them when/if needed.
- Ease of use of GUI-based administration and deployment tools (step-by-step wizards, drag-n-drop interfaces for mapping).
- Easy interaction with any language and environments using SOAP. This open web service interface enables easy integration for your applications written in any language (Java, VB, Perl, C/C++, C#, Python).
- Fine grain access control provides model-level access control definition for users and groups of users.
The following additional materials on the project are available: