Transforming query results into hierarchical information

Details Transforming query results into hierarchical information Transforming query results into hierarchical information

2004-01-27

2008-10-28

Wu, Yicun (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000

Reexamination Certificate

active

07444321

ABSTRACT:
A computerized system and method for transforming the results of a query into a hierarchical information stream, such as an eXtensible Markup Language (XML) data stream is disclosed. A database server receives a query and generates a rowset. A rowset processor, using the mode specified in the query, processes the rowset and query to generate the XML data stream. For the “auto1” mode, the rowset processor transforms a rowset into an XML data stream using primary-foreign key information specified in the query to determine nesting. For the “auto2” mode, the rowset processor transforms a rowset into an XML data stream using table ordering information included in the query to determine nesting. For the “explicit” mode, the rowset processor transforms a rowset into an XML data stream using the explicit organizational information specified in the query.

REFERENCES:
patent: 6356920 (2002-03-01), Vandersluis
patent: 6366934 (2002-04-01), Cheng et al.
patent: 6480860 (2002-11-01), Monday
patent: 6484160 (2002-11-01), Richard et al.
patent: 6591260 (2003-07-01), Schwarzhoff et al.
patent: 6604100 (2003-08-01), Fernandez et al.
De Sousa, A., et al. “Mapping Rules to Convert from ODL to XML-SCHEMA”, Proceedings 22nd International Conference of the Chilean Computer Science Society, 2002, 133-141.
Deutsch, A., “A Query Language for XML”, Computer Networks, 1999, 31(11-16), 1155-1169.
Du, W., “XML Structures for Relational Data”, Proceedings of the Second International Conference on Web Information Systems Engineering, 2002, 1, 151-160.
Feng, D., “Research and Implementation of Mapping Relational Database to Extensible Markup Language Document”, Journal of Xi'an Jiaotong University, Oct. 2002, 36(10), 1066-1069, 1074.
Jacinto, M. H., et al., “BiDirectional Conversion between XML Documents and Relational Databases”, 7th International Conference on Computer Supported Cooperative Work in Design, 2002, 437-443.
Lee, D., et al., “Constraints-Preserving Inlining Algorithm for Mapping XML DTD to Relational Schema”, Data & Knowledge Engineering, 2001, 39(1), 3-25.
Rys, M., “Bringing the Internet to you Database: Using SQL server 2000 and XML to Build Loosely-Coupled Systems”, Conference Proceedings, Vision for a New Millennium, 2000, 109-122.
Wenwu, L., et al., “Lossless Mapping from Semi-Structured Data to Structured Data”, Journal of Southeast university (English Edition), Mar. 2002, 18(1), 46-53.
“XML-QL: A Query Language for XML”, http://www.w3.org/TR/1998/NOTE-xml-ql-19980819, Submission to the World Wide Web Consortium, Aug. 19, 1998, 1-19.
Wadler, P., “XML”, http://www.cs.bell-labs.com/who/wadler/topics/xml.html, Data Model and Algebra for XML Query, Nov. 1999, 1-3.
Oracle8™ Concepts, Release 8.0, Dec. 1997.
Abiteboul, S. et al., “The Lorel Query Language for Semistructured Data”,International Journal of Digital Libraries, 1997, 1(1), 68-88.
Deutsch, A. et al., “Storing Semistructured Data with STORED”,SIGMOD, 1999, 431-442.
Shanmugasundaram, J. et al., “Relational Databases for Querying XML Documents: Limitations and Opportunities”,VLDB, 1999, 302-314.
Shanmugasundaram, J. et al., “A General Technique for Querying XML Documents using a Relational Database System”,VLDB, 13 pages.

Affiliated with

Also associated with

Rating

Transforming query results into hierarchical information does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Transforming query results into hierarchical information, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Transforming query results into hierarchical information will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4009583