Data processing: database and file management or data structures – Database and file access
Reexamination Certificate
2006-09-28
2010-06-01
Wu, Yicun (Department: 2158)
Data processing: database and file management or data structures
Database and file access
C715S210000
Reexamination Certificate
active
07730048
ABSTRACT:
A computerized system and method for transforming (formatting or aggregating) 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. In one embodiment, it is easier for a developer to compose expressions to generate nested hierarchical structures than previous formulations and simpler semantics are provided without implicit hierarchy inference. The syntax of an embodiment of the hierarchical formatting function includes optional arguments including a name option, a root option, map option, namespace options and a null option.
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.
W3C (“Namespaces in XML” World Wide Web Consortium Jan. 14, 1999).
“XML-QL: A Query Language for XML”, http://www.w3.org/TR/1998/NOTE-xml-gl-19980819/, Submission to the World Wide Web Consortium, 1-19, (Aug. 19, 1998).
P. Wadler, “XML”, http://www.cs.bell-labs.com/who/wadler/topics/xml.html. A Data Model and Algebra for XML Query, 1-3, (Nov. 1999).
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.
DeSousa, 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 SQI server 2000 and XML to Build Lossely-Coupled Systems”, Conference Proceedings, Vision for a New Millenium, 2000, 109-122.
Shanmugasundaram, J., et al., “A General Technique for Querying XML Documents Using a Relational Database System”, SIGMOD Record, 2001, 30(3), 20-26.
Wenwu, L. et al., “Lossless Mappingfrom Semi-Structured Data to Structured Data”, Journal of Southeast university (English Edition), Mar. 2002, 18(1), 46-53.
Kogan Yevgeniy L.
Rys Michael
Microsoft Corporation
Workman Nydegger
Wu Yicun
LandOfFree
Systems and methods for transforming query results into... does not yet have a rating. At this time, there are no reviews or comments for this patent.
If you have personal experience with Systems and methods for transforming query results into..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Systems and methods for transforming query results into... will most certainly appreciate the feedback.
Profile ID: LFUS-PAI-O-4245005