News

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.

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.

Email Alerts

Register now to receive ComputerWeekly.com IT-related news, guides and more, delivered to your inbox.
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
 

COMMENTS powered by Disqus  //  Commenting policy