MetaMatrix, a leader in data service management systems, announced a new product, MetaMatrix Query, built for Java application developers. MetaMatrix Query is an embeddable Java distributed query component that streamlines development and maintenance of Java applications that use data from two or more relational databases. When embedded in an application, the MetaMatrix Query data service operates as a single JDBC driver that facilitates access to data from multiple, distributed relational databases, federating data from these sources and optimizing distributed queries. By using MetaMatrix Query, Java developers can reduce development and maintenance time and improve the performance of their applications.MetaMatrix Query provides a very productive way for Java developers to access data from diverse relational sources and to federate that data for integration. Compared with traditional methods of custom coding data access and integration logic within the application, MetaMatrix Query simplifies development and maintenance by configuring data access and integration in a single, isolated component. With MetaMatrix Query, rather than having to write custom code to 1) connect to several individual databases, 2) extract the data, and then 3) integrate the data within the application, Java developers can embed in their applications a single data service component that handles interactions with all relevant relational databases, including responding to a SQL query that spans multiple sources. Developers import metadata for relevant tables from the various databases, assembling a single data service. This MetaMatrix Query data service is a single JDBC driver through which applications can submit SQL, either retrieving data from individual tables or performing join or union operations to integrate the data.

MetaMatrix Query incorporates a rule-based and cost-based query optimization engine to optimize the performance of data retrievals. Leveraging proven, award-winning optimization technology from MetaMatrix' flagship products, MetaMatrix Query transforms a single SQL query into multiple queries distributed among the various relational data sources, making rule-based and cost-based decisions about where and how to perform processing.

Register or login for access to this item and much more

All Information Management content is archived after seven days.

Community members receive:
  • All recent and archived articles
  • Conference offers and updates
  • A full menu of enewsletter options
  • Web seminars, white papers, ebooks

Don't have an account? Register for Free Unlimited Access