Direct loading of semistructured data

Details Direct loading of semistructured data Direct loading of semistructured data

2003-08-25

2010-10-12

Jalil, Neveen Abel (Department: 2165)

Data processing: database and file management or data structures

Data warehouse, data mart, online analytical processing ,...

Data extraction, transformation, and loading

Reexamination Certificate

active

07814047

ABSTRACT:
Techniques and systems are disclosed for directly storing semistructured data in a database. According to one aspect, a client application reads data that comprises instances of a parent type. The client application invokes routines associated with the parent type. An array is created for storing instances of the parent type. These routines invoke routines associated with a child type of the parent type. An array is created for storing instances of the child type. The arrays are populated with values specified in the data. According to one aspect, some columns of the arrays may be populated with other values to be stored in hidden columns of database tables. The client application converts the arrays into a data stream that conforms to the format of the database's data blocks. The client application then streams the data to a database server, which writes the data blocks directly into one or more data blocks in the database.

REFERENCES:
patent: 5295261 (1994-03-01), Simonetti
patent: 5467471 (1995-11-01), Bader
patent: 5649200 (1997-07-01), Leblang et al.
patent: 5680614 (1997-10-01), Bakuya et al.
patent: 5724577 (1998-03-01), Exley et al.
patent: 5734887 (1998-03-01), Kingberg et al.
patent: 5964407 (1999-10-01), Sandkleiva
patent: 5974407 (1999-10-01), Sacks
patent: 6047322 (2000-04-01), Vaid et al.
patent: 6085198 (2000-07-01), Skinner et al.
patent: 6115705 (2000-09-01), Larson
patent: 6360302 (2002-03-01), Baylor
patent: 6470494 (2002-10-01), Chan et al.
patent: 6542911 (2003-04-01), Chakraborty et al.
patent: 6571231 (2003-05-01), Sedlar
patent: 6643633 (2003-11-01), Chau et al.
patent: 6654761 (2003-11-01), Tenev et al.
patent: 6662342 (2003-12-01), Marcy
patent: 6675230 (2004-01-01), Lewallen
patent: 6718322 (2004-04-01), Brye
patent: 6721723 (2004-04-01), Gibson et al.
patent: 6754661 (2004-06-01), Hallin et al.
patent: 6772180 (2004-08-01), Li et al.
patent: 6804677 (2004-10-01), Shadmon et al.
patent: 6826568 (2004-11-01), Bernstein et al.
patent: 6915304 (2005-07-01), Krupa
patent: 6915307 (2005-07-01), Mattis et al.
patent: 6941511 (2005-09-01), Hind et al.
patent: 6957237 (2005-10-01), Traversat et al.
patent: 6964025 (2005-11-01), Angiulo et al.
patent: 7024425 (2006-04-01), Krishnaprasad et al.
patent: 7031956 (2006-04-01), Lee et al.
patent: 7036072 (2006-04-01), Sulisito et al.
patent: 7062507 (2006-06-01), Wang et al.
patent: 7107282 (2006-09-01), Yalamanchi
patent: 7113942 (2006-09-01), Levanoni et al.
patent: 7134072 (2006-11-01), Lovett et al.
patent: 7139746 (2006-11-01), Shin et al.
patent: 7287033 (2007-10-01), Shadmon et al.
patent: 7353222 (2008-04-01), Dodds et al.
patent: 7405522 (2008-07-01), Riddle
patent: 7451128 (2008-11-01), Song et al.
patent: 7457910 (2008-11-01), Chang et al.
patent: 7519903 (2009-04-01), Yahagi
patent: 2001/0049675 (2001-12-01), Mandler et al.
patent: 2001/0049818 (2001-12-01), Banerjia et al.
patent: 2002/0029229 (2002-03-01), Jakopac et al.
patent: 2002/0056025 (2002-05-01), Qiu et al.
patent: 2002/0078068 (2002-06-01), Krishnaprasad et al.
patent: 2002/0087510 (2002-07-01), Weinberg et al.
patent: 2002/0087596 (2002-07-01), Lewontin
patent: 2002/0116371 (2002-08-01), Dodds et al.
patent: 2002/0147763 (2002-10-01), Lee et al.
patent: 2002/0184188 (2002-12-01), Mandyam et al.
patent: 2003/0004937 (2003-01-01), Salmenkaita et al.
patent: 2003/0033285 (2003-02-01), Jalali et al.
patent: 2003/0115421 (2003-06-01), McHenry et al.
patent: 2003/0120665 (2003-06-01), Fox et al.
patent: 2003/0140308 (2003-07-01), Murthy et al.
patent: 2003/0154204 (2003-08-01), Chen-Wright et al.
patent: 2003/0204787 (2003-10-01), Bartucca et al.
patent: 2003/0236903 (2003-12-01), Piotrowski
patent: 2004/0015936 (2004-01-01), Susarla et al.
patent: 2004/0043758 (2004-03-01), Sorvari et al.
patent: 2004/0044959 (2004-03-01), Shanmugasundaram et al.
patent: 2004/0066529 (2004-04-01), Wu et al.
patent: 2004/0088320 (2004-05-01), Perry
patent: 2004/0088415 (2004-05-01), Chandrasekar et al.
patent: 2004/0117359 (2004-06-01), Snodgrass et al.
patent: 2004/0167864 (2004-08-01), Wang et al.
patent: 2004/0176958 (2004-09-01), Salmenkaita et al.
patent: 2004/0225680 (2004-11-01), Cameron et al.
patent: 2005/0050092 (2005-03-01), Jain et al.
patent: 2005/0050105 (2005-03-01), Idicula et al.
patent: 2005/0102256 (2005-05-01), Bordawekar et al.
patent: 2005/0228818 (2005-10-01), Murthy et al.
patent: 2006/0036935 (2006-02-01), Warner et al.
patent: 2006/0047717 (2006-03-01), Pereira
patent: 2006/0200439 (2006-09-01), Bhatia et al.
patent: 2007/0005624 (2007-01-01), Wu et al.
patent: 2007/0043751 (2007-02-01), Chen et al.
patent: 2007/0168327 (2007-07-01), Lindblad et al.
patent: 0 856 803 (1998-08-01), None
patent: 1 241 589 (2002-09-01), None
patent: WO 01/42881 (2001-06-01), None
patent: WO 03/030031 (2003-04-01), None
“SerialJavaObject (Java 2 Platform SE 5.0)”, Available online at: http://java.sun.com/j2se/1.5.0/docs/api/javax/sql/rowset/serial/SerialJavaObject.html. Accessed Apr. 10, 2006. Copyright 2004 Sun Microsystems.
“Conventional and Direct Path Loads” from Oracle9i Database Utilities Release 2. Copyright 2002 Oracle Corporation. Avilable online at http://www.utexas.edu/its/unix/reference/oracledocs/v92/B10501—01/server.920/a96652/ch09.htm.
Shelley Higgins, Oracle Corporation, “Oracle9i, XML Database Developer's Guide—Oracle XML DB,” Release 2 (9.2), Oct. 2002, Part No. A96620-02, pp. 1-1,044 (text provided on CD-ROM).
Ipedo, Inc., “Ipedo XML Database 3.1: Developer's Guide,” 2001, XP-002306148, 12 pages.
Chris Parkerson, “Ipedo XML Database 3.1 Now Available,” Jul. 22, 2002, XP-002306149, pp. 1-2.
Can Türker, “Schema Evolution in SQL-99 and Commercial (Object-) Relational DBMS,” 9thInternational Workshop on Foundations of Models and Languages for Data and Obejcts Fomlado/Demm 2000, Sep. 18, 2000, XP-002306150, pp. 1-32.
Hong Su et al., “XEM: XML Evolution Management,” Jan. 2002, XP-002306151, pp. 1-32.
Yuan Wang et al., “X-Diff: An Effective Change Detection Algorithm for XML Documents,” Proceedings of the 19thInternational Conference on Data Engineering (ICDE'03), 2003, IEEE, pp. 519-530.
Awais Rashid, “A Framework for Customisable Schema Evolution in Object-Oriented Databases,” Proceedings of the Seventh International Database Engineering and Applications Symposium (IDEAS'03), 2003, IEEE, 5 pages.
Xue Li, “A Survey of Schema Evolution in Object-Oriented Databases,” 1999, IEEE, pp. 362-371.
International Search Authority, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Search Authority, or the Declaration,” Dec. 8, 2004, International Application No. PCT/US2004/027464, 14 pages.
“Current Claims of PCT/US2004/027464,” pp. 1-7.
Chen, Ruey-Shun et al., “Developing an XML framework for metadata system”, Trinity College Dublin, Proc. of the 1stInter. Sympo. on Information and Communication, pp. 267-272.
Manolescu, Dragos, Review of “Metadata solutions: using metamodels, repositories, XML, and enterprise portals to generate information on demand by Adrienne Tannebaum”, Mar. 2003, ACM Press, vol. 28, Issue 2, p. 38.
MacKenzie, David et al., “Finding Files”, GNU Findutils Version 4.1.2, Nov. 1994, 38 pages.
Claims, International application No. PCT/US2006/045700, 2 pages.
European Patent Office, “Notification of Transmittal of the International Search Report and the Written Opinion of the International Searching Authority, or the Declaration”, International application No. PCT/US2006/045700, dated Jul. 20, 2007, 12 pages.
Chakraborty, Krishnendu, et al., “The XML Garbage Collector”, XP-002297849, The Source for Developers & Sun Developer Network Site, Technical Articles & Tips, dated Mar. 2002, 5 pages.
Oracle, “Oracle IFS (Internet Filing System)”, Technical Data Sheet, Mar. 1999, 4 pages.
Lo et al., XAS: A System f

Affiliated with

Also associated with

Rating

Direct loading of semistructured data does not yet have a rating. At this time, there are no reviews or comments for this patent.

If you have personal experience with Direct loading of semistructured data, we encourage you to share that experience with our LandOfFree.com community. Your opinion is very important and Direct loading of semistructured data will most certainly appreciate the feedback.

Rate now

Comments { 0 }

Profile ID: LFUS-PAI-O-4241846