NDLI: Heterogeneous query processing through SQL table functions

Content Provider	IEEE Xplore Digital Library
Author	Reinwald, B. Pirahesh, H. Krishnamoorthy, G. Lapis, G. Tran, B. Vora, S.
Copyright Year	1999
Description	Author affiliation: IBM Almaden Res. Center, San Jose, CA, USA (Reinwald, B.)
Abstract	In today's IT infrastructures, data is stored in SQL databases, non-SQL, databases, and host databases like ISAM/VSAM files. Non-SQL databases are specialized data stores controlled by applications like spreadsheets, mail, directory and index services. Developing applications accessing a variety of different data sources is challenging for application developers due to different environments, APIs, bindings, etc. 20 years ago, SQL was created to ease the life of database application developers and provide a uniform way for accessing data which is stored in SQL databases. The paper describes an implementation of table functions and its usage for accessing data stored outside SQL databases in diverse external data stores. Table functions are compliant with the relational data model, and therefore fit into the well established SQL language. The table-function architecture is open, and allows the deployment of generic data access infrastructures such as Microsoft's OLE DB or Java's JDBC (G. Hamilton et al., 1997). The paper describes a prototype implementation of OLE DB table functions with advanced query optimization techniques. The prototype is based on IBM DB2 UDB relational database system.
Starting Page	366
Ending Page	373
File Size	90018
Page Count	8
File Format	PDF
ISBN	0769500714
ISSN	10636382
DOI	10.1109/ICDE.1999.754952
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	1999-03-23
Publisher Place	Australia
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Query processing Databases Postal services Prototypes Laboratories Page description languages Java Spine Banking Insurance
Content Type	Text
Resource Type	Article

Sl.	Authority	Responsibilities	Communication Details
1	Ministry of Education (GoI), Department of Higher Education	Sanctioning Authority	https://www.education.gov.in/ict-initiatives
2	Indian Institute of Technology Kharagpur	Host Institute of the Project: The host institute of the project is responsible for providing infrastructure support and hosting the project	https://www.iitkgp.ac.in
3	National Digital Library of India Office, Indian Institute of Technology Kharagpur	The administrative and infrastructural headquarters of the project	Dr. B. Sutradhar bsutra@ndl.gov.in
4	Project PI / Joint PI	Principal Investigator and Joint Principal Investigators of the project	Dr. B. Sutradhar bsutra@ndl.gov.in Prof. Saswat Chakrabarti will be added soon
5	Website/Portal (Helpdesk)	Queries regarding NDLI and its services	support@ndl.gov.in
6	Contents and Copyright Issues	Queries related to content curation and copyright issues	content@ndl.gov.in
7	National Digital Library of India Club (NDLI Club)	Queries related to NDLI Club formation, support, user awareness program, seminar/symposium, collaboration, social media, promotion, and outreach	clubsupport@ndl.gov.in
8	Digital Preservation Centre (DPC)	Assistance with digitizing and archiving copyright-free printed books	dpc@ndl.gov.in
9	IDR Setup or Support	Queries related to establishment and support of Institutional Digital Repository (IDR) and IDR workshops	idr@ndl.gov.in

Direct Voice Control Speech Data Entry and Database Query Models

Do semantically equivalent SQL queries perform differently?

Distributed/heterogeneous query processing in Microsoft SQL server

DHT-Based Range Query Processing for Web Service Discovery

Category of Fuzzy Operators in SQL

Query Rewrites with Views for XML in DB2

Querying sensor networks with extended SQL

Stream query processing for healthcare bio-sensor applications

On Pushing Multilingual Query Operators into Relational Engines

Heterogeneous query processing through SQL table functions

Similar Documents

Direct Voice Control Speech Data Entry and Database Query Models

Do semantically equivalent SQL queries perform differently?

Distributed/heterogeneous query processing in Microsoft SQL server

DHT-Based Range Query Processing for Web Service Discovery

Category of Fuzzy Operators in SQL

Query Rewrites with Views for XML in DB2

Querying sensor networks with extended SQL

Stream query processing for healthcare bio-sensor applications

On Pushing Multilingual Query Operators into Relational Engines

Heterogeneous query processing through SQL table functions