NDLI: ANSI SQL hierarchical processing can fully integrate native XML

Content Provider	ACM Digital Library
Author	David, Michael M.
Abstract	Most SQL-based XML vendor support is through interoperation and not integration. One reason for this is that XML is inherently hierarchical and SQL is supposedly not. This paper demonstrates how ANSI SQL along with its relational Cartesian product model can naturally perform complete and flexible hierarchical query processing. With this ANSI SQL inherent hierarchical processing capability, native XML data can be fully and seamlessly integrated into SQL processing and operated on at a full hierarchical level. This paper will describe the basic stages involved in this hierarchical SQL processing: hierarchical data modeling, hierarchical working set creation, and hierarchical Cartesian product processing. These processes enable a complete relational, XML, and legacy data integration which maintains ANSI SQL compatibility even while performing the most complex multi-leg hierarchical processing, and includes the dynamic, direct, and controlled hierarchical joining of hierarchical structures. Also covered are ANSI SQL hierarchical support features: hierarchical SQL views, hierarchical data filtering, and hierarchical optimization. These make standard SQL a well rounded and complete hierarchical processor. With this full hierarchical level of processing established, it will be shown how the relational Cartesian product engine can be seamlessly replaced with a hierarchical engine, greatly increasing processing and memory utilization, and enabling advanced XML hierarchical data capabilities.
Starting Page	41
Ending Page	46
Page Count	6
File Format	PDF
ISSN	01635808
DOI	10.1145/640990.640996
Journal	ACM SIGMOD Record (SGMD)
Volume Number	32
Issue Number	1
Language	English
Publisher	Association for Computing Machinery (ACM)
Publisher Date	1999-06-01
Publisher Place	New York
Access Restriction	One Nation One Subscription (ONOS)
Content Type	Text
Resource Type	Article
Subject	Information Systems Software

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

ANSI SQL Hierarchical Processing Can Fully Integrate Native XML

A critique of ANSI SQL isolation levels

Advancements in SQL/XML

SQL/XML is making good progress

Join minimization in XML-to-SQL translation:an algebraic approach

A distributed scientific data archive using the Web, XML and SQL/MED

Analytical processing of XML documents:opportunities and challenges

SQL multimedia and application packages (SQL/MM)

Static analysis of XML processing with data values

ANSI SQL hierarchical processing can fully integrate native XML

Similar Documents

ANSI SQL Hierarchical Processing Can Fully Integrate Native XML

A critique of ANSI SQL isolation levels

Advancements in SQL/XML

SQL/XML is making good progress

Join minimization in XML-to-SQL translation:an algebraic approach

A distributed scientific data archive using the Web, XML and SQL/MED

Analytical processing of XML documents:opportunities and challenges

SQL multimedia and application packages (SQL/MM)

Static analysis of XML processing with data values

ANSI SQL hierarchical processing can fully integrate native XML