TechTarget

Aggregation tool is the Lazy way to link disparate databases

Lazy Software has released a data aggregation tool for linking disparate relational databases, writes Eric Doyle.

Lazy Software has released a data aggregation tool for linking disparate relational databases, writes Eric Doyle.

Lazyview allows users to integrate information drawn from multiple databases, including Oracle, IBM DB2 and Microsoft SQL Server, to give a single view of data without the need to move the data and, the company claims, without the need for costly datawarehousing and migration tools. The ability to read XML also means that data from non-relational sources, such as Web-based information can be drawn into the mix.

Typical applications of Lazyview would include giving marketing and sales departments a total view of their customers; comparing raw material prices and availability across a range of potential suppliers; and the aggregation of customer databases when two companies or departments merge.

The product is built around Lazy's flagship Sentences database, an implementation of the associative model for databases which Lazy has been promoting as a successor to the relational database.

The associative model is based on units known as chapters, which provide connectivity with relational sources. Lazy devised the "pseudo-chapter" which converts data requests into SQL requests that are run against the target database in JDBC (Java Database Connectivity). This query process happens in real time without large sections of data having to be moved into Sentences.

Lazyview is set up so that it only has read access to the data. If write access is required it can be achieved by creating a trigger in Sentences, by adding a Java applet, or by generating an update form in XML.

CW+

Features

Enjoy the benefits of CW+ membership, learn more and join.

Read more

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

-ADS BY GOOGLE

SearchCIO

SearchSecurity

SearchNetworking

SearchDataCenter

SearchDataManagement

Close