fbpx
Wikipedia

Lotus DataLens

Lotus Development's DataLens, originally known as Blueprint, was a standardized system for database queries used in a number of Lotus products, notably 1-2-3. It provided drivers for a number of common data sources, including a variety of mainframe SQL servers, microcomputer database files of various sorts, and even flat-file systems. Drivers from 3rd parties were also available.

Unlike the better-known ODBC, DataLens did not use SQL in the query interface. The API was based on a variety of data structures that were interpreted by the database drivers into their own internal query format - including SQL in some cases. In contrast, ODBC used SQL as its basic interface, and interpreted and translated it in the driver for those data sources that did not use SQL.

Lotus also released two user-oriented query builders, the DOS-based Query Builder which could interact with DataLens sources but was not built on it, and the Windows-based Data Query Assistant (DQA) which was built directly on DataLens.[1]

References edit

  1. ^ Scott Mace, "Lotus beefs up database query capabilities", InfoWorld, 5 August 1991, p. 13

lotus, datalens, lotus, development, datalens, originally, known, blueprint, standardized, system, database, queries, used, number, lotus, products, notably, provided, drivers, number, common, data, sources, including, variety, mainframe, servers, microcompute. Lotus Development s DataLens originally known as Blueprint was a standardized system for database queries used in a number of Lotus products notably 1 2 3 It provided drivers for a number of common data sources including a variety of mainframe SQL servers microcomputer database files of various sorts and even flat file systems Drivers from 3rd parties were also available Unlike the better known ODBC DataLens did not use SQL in the query interface The API was based on a variety of data structures that were interpreted by the database drivers into their own internal query format including SQL in some cases In contrast ODBC used SQL as its basic interface and interpreted and translated it in the driver for those data sources that did not use SQL Lotus also released two user oriented query builders the DOS based Query Builder which could interact with DataLens sources but was not built on it and the Windows based Data Query Assistant DQA which was built directly on DataLens 1 References edit Scott Mace Lotus beefs up database query capabilities InfoWorld 5 August 1991 p 13 nbsp This database software related article is a stub You can help Wikipedia by expanding it vte Retrieved from https en wikipedia org w index php title Lotus DataLens amp oldid 906999998, wikipedia, wiki, book, books, library,

article

, read, download, free, free download, mp3, video, mp4, 3gp, jpg, jpeg, gif, png, picture, music, song, movie, book, game, games.