Apparatus and method for mapping relational data and...

Details Apparatus and method for mapping relational data and... Apparatus and method for mapping relational data and...

2007-08-21

2007-08-21

Wu, Yicun (Department: 2165)

Data processing: database and file management or data structures

Database design

Data structure types

C707S793000, C707S793000, C715S252000, C715S252000

Reexamination Certificate

active

10897578

ABSTRACT:
Techniques are provided for mapping XML data and metadata from data in relational databases. According to certain embodiments of the invention, a mechanism is provided to allow the user to use a database query to retrieve data form a relational database in the form of XML documents by canonically mapping object relational data to XML data and canonically mapping object relational schemas to XML-Schemas. The mechanism causes the generation of XML-schema information for the XML documents.

REFERENCES:
patent: 5404513 (1995-04-01), Powers et al.
patent: 5974407 (1999-10-01), Sacks
patent: 5999941 (1999-12-01), Andersen
patent: 6012067 (2000-01-01), Sarkar
patent: 6055544 (2000-04-01), DeRose et al.
patent: 6128610 (2000-10-01), Srinivasan et al.
patent: 6141655 (2000-10-01), Johnson et al.
patent: 6208993 (2001-03-01), Shadmon
patent: 6240407 (2001-05-01), Chang et al.
patent: 6269380 (2001-07-01), Terry et al.
patent: 6279006 (2001-08-01), Shigemi et al.
patent: 6366934 (2002-04-01), Cheng et al.
patent: 6418448 (2002-07-01), Sarkar
patent: 6438540 (2002-08-01), Nasr et al.
patent: 6449620 (2002-09-01), Draper et al.
patent: 6470344 (2002-10-01), Kothuri et al.
patent: 6487546 (2002-11-01), Witkowski
patent: 6496842 (2002-12-01), Lyness
patent: 6510434 (2003-01-01), Anderson et al.
patent: 6574655 (2003-06-01), Libert et al.
patent: 6584459 (2003-06-01), Chang et al.
patent: 6604100 (2003-08-01), Fernandez et al.
patent: 6636845 (2003-10-01), Chau et al.
patent: 6643633 (2003-11-01), Chau et al.
patent: 6684204 (2004-01-01), Lal
patent: 6721727 (2004-04-01), Chau et al.
patent: 6772412 (2004-08-01), Kuznetsov
patent: 6785673 (2004-08-01), Fernandez et al.
patent: 6871204 (2005-03-01), Krishnaprasad et al.
patent: 6918082 (2005-07-01), Gross et al.
patent: 7043488 (2006-05-01), Bauer et al.
patent: 2002/0015042 (2002-02-01), Robotham et al.
patent: 2002/0035606 (2002-03-01), Kenton
patent: 2002/0038358 (2002-03-01), Sweatt et al.
patent: 2002/0120685 (2002-08-01), Srivastava et al.
patent: 2002/0123993 (2002-09-01), Chau et al.
patent: 2002/0124100 (2002-09-01), Adams
patent: 2002/0156772 (2002-10-01), Chau et al.
patent: 2002/0169788 (2002-11-01), Lee et al.
patent: 2002/0198874 (2002-12-01), Nasr et al.
patent: 2003/0009361 (2003-01-01), Hancock et al.
patent: 2003/0014397 (2003-01-01), Chau et al.
patent: 2003/0172135 (2003-09-01), Bobick et al.
“A Performance Evaluation of Storing XML Data in Relational Database Management Systems,”—Latifur Khan and Yan Rao -ACM-2001 (pp. 31-38).
“From XML Schema to Relations: A Cost-Based Approach to XML Storage”—Bell Laboratories: Philip Bohannon, Juliana Freire, Prasan Roy and Jerome Simeon—IEEE —2002— Proceedings of the 18th International Conference on Data Engineering (ICDE'02), 12 pages.
“SRQL: Sorted Relational Query Language”—Raghu Ramakrishnan, Donko Donjerkovic, Arvind Ranganathan, Kevin S. Beyer and Muralidar Krishnaprasad—Jul. 1-3, 1998 IEEE pp.: 84-95.
“Oracle8i—The XML Enabled Data Management System”—Oracle Corporation: Sandeepan Banerjee, Vishu Krishnamurthy, Muralidar Krishnaprasad and Ravi Murthy—Mar. 2000 IEEE pp.: 561-568.
Daniela Florescu et al., “A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data in a Relational Database,” May 1999, XP-002168318, pp. 1-31.
Schmidt et al.—“Efficient Relational Storage and Retrieval of XML Documents”—CWI, The Netherlands (pp. 1-6).
Oracle 9i “Project XDB”—The XML Database—ORACLE—2001 (pp. 1-18).
Banerjee et al. “Oracle 8i—The XML Enabled Data Management System”—Data Engineering, IEEE/Mar. 2000 (pp. 561-568.
Lawrence et al. “Integrating Relational Database Schemas Using a Standardized Dictionary”—2001—ACM (pp. 225-230).
R. Bourret et al.: A generic Load/Extract Utility for Data Transfer Between XML Documents and Relational Databases, Jun. 8-9, 2000, IEEE Computing SOC., pp. 134-143.
Chen, Cindy Xinmin, et al., “XML Queries SQL,” Proceedings of the First International Conference on Web-Age Information Management, ISBN: 3-540-67627-9, 8 pages.
Cheng, Josephine, et al., “XML and DB2,” 16thInternational Conference on Data Engineering, May 2000, 5 pages.
European Patent Office,“Communication Pursuant to Article 96(2) EPC,” App. No. 01 970 715.7 (50277-2177), sated Jul. 19, 2006, 8 pages.
Amended Claims (50277-2177), App. No. 01 970 715.7, 13 pages.
Florescu, Daniela et al., “A Performance Evaluation of Alternative Mapping Schemes for Storing XML Data In A Relational Database,” Inria Rocquencourt P Project Rodin-Rapport De Recherche, May 1999, pp. 1-31.

Affiliated with

Also associated with

Rating

Apparatus and method for mapping relational data and... does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Apparatus and method for mapping relational data and..., we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Apparatus and method for mapping relational data and... will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-3892425