NDLI: On querying spreadsheets

Content Provider	IEEE Xplore Digital Library
Author	Lakshmanan, L.V.S. Subramanian, S.N. Goyal, N. Krishnamurthy, R.
Copyright Year	1998
Description	Author affiliation: Dept. of Comput. Sci., Concordia Univ., Montreal, Que., Canada (Lakshmanan, L.V.S.)
Abstract	Considers the problem of querying the data in applications such as spreadsheets and word processors. This problem has several motivations from the perspective of data integration, interoperability and OLAP. We provide an architecture for realizing interoperability among such diverse applications and address the challenges that arise specifically in the context of querying data stored in spreadsheet applications. A fundamental challenge is the lack of a well-defined schema. We propose a framework in which the user can specify the layout of data in a spreadsheet, based on his perception of the important concepts underlying that data. Layout specifications can be viewed as the "physical schema" of a spreadsheet. We motivate the concept of an abstract database machine (ADM) that uses the layout specifications to provide a relational view of the data in spreadsheet applications and, similar to a DBMS, supports efficient querying of the spreadsheet data. We develop a methodology for building ADMs for spreadsheets and describe our implementation of an ADM for Microsoft Excel applications, based on the above methodology. Our implementation platform is IBM PCs running Windows NT, Microsoft Office and OLE 2.0. We demonstrate the generality and practicality of our approach by developing a formal characterization of the class of spreadsheets that can be handled in our framework. Our results show that the approach is capable of handling a broad class of naturally occurring spreadsheet applications. This work is part of an office tool integration project.
Starting Page	134
Ending Page	141
File Size	216036
Page Count	8
File Format	PDF
ISBN	0818682892
ISSN	10636382
DOI	10.1109/ICDE.1998.655769
Language	English
Publisher	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Publisher Date	1998-02-23
Publisher Place	USA
Access Restriction	Subscribed
Rights Holder	Institute of Electrical and Electronics Engineers, Inc. (IEEE)
Subject Keyword	Marketing and sales Postal services Computer science Application software Database machines Add-drop multiplexers Spreadsheet programs Personal communication networks Data engineering Councils
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

Multi-Carrier Distributed WDM Ring Network Based on Reconfigurable Optical Drop-Add-Drop Multiplexers and Carrier Wavelength Reuse

Optical add/drop multiplexers and optical cross-connects for wavelength routed networks

Optical packet add/drop multiplexers for packet ring networks

Optical crossconnect/ADM based networks

Wavelength-Selective Reconfiguration in Transparent Agile Optical Networks

Design and Control System for Regional CWDM Optical IP Networks with Reconfigurable Optical Add/Drop Multiplexers

Optical add-drop multiplexers based on autocloned photonic crystals

A Case Study on Semantic Unit Composition

Optical add/drop multiplexers for WDM communication systems

On querying spreadsheets

Similar Documents

Multi-Carrier Distributed WDM Ring Network Based on Reconfigurable Optical Drop-Add-Drop Multiplexers and Carrier Wavelength Reuse

Optical add/drop multiplexers and optical cross-connects for wavelength routed networks

Optical packet add/drop multiplexers for packet ring networks

Optical crossconnect/ADM based networks

Wavelength-Selective Reconfiguration in Transparent Agile Optical Networks

Design and Control System for Regional CWDM Optical IP Networks with Reconfigurable Optical Add/Drop Multiplexers

Optical add-drop multiplexers based on autocloned photonic crystals

A Case Study on Semantic Unit Composition

Optical add/drop multiplexers for WDM communication systems

On querying spreadsheets