Leveraging XML capabilities of a database to enhance handling of document data

• US 8,423,512 B2
• Filed: 09/08/2009
• Issued: 04/16/2013
• Est. Priority Date: 09/08/2009
• Status: Active Grant

• Current Assignee: Oracle International Corporation (Oracle Corporation)
• Original Assignee: Oracle International Corporation (Oracle Corporation)
• Inventors: Agarwal, Nipun, Sozgen, Cem Emre, Idicula, Sam
• Primary Examiner(s): Le, Debbie
• Assistant Examiner(s): TRAN, ANHTAI V
• Application Number:
  US12/555,252
• Publication Number:
  US 20110060767A1
• Time in Patent Office: 1,316 Days
• Field of Search: None
• US Class Current: 707/661
• CPC Class Codes: G06F 16/86 Mapping to a database
• CPC Class Codes: G06F 16/93 Document management systems
• CPC Class Codes: G06F 40/143 Markup, e.g. Standard Generalized Markup Language [SGML] or Document Type Definition [DTD]
• CPC Class Codes: G06F 40/226 Validation

Abstract

When an XML-annotated document is saved, a process automatically stores the document'"'"'s data in the tables of a database. The database server validates the document'"'"'s data against a user-specified XML schema. Queries can be executed against a set of documents in order to find documents in which a specified XML element contains specified content. Query results can be customized to return only the contents of specified XML elements. The document data can be linked with other data in the database such that the document data is updated based on the other data every time that the document is opened, thereby producing a “live” and dynamic document. Different file formats can be generated based on the document data, thus separating the presentation of the document data from the data itself. Contents of different elements may be obscured based on users'"'"' privileges, thereby maintaining the privacy of the document'"'"'s information.

Claims

1. A computer-implemented method comprising steps of:

detecting that a document editor application, external to a database server, is attempting to save a multi-file archive document, wherein said multi-file archive document contains a plurality of extensible markup language (XML) files, wherein said plurality of XML files contains a particular XML file that contains user-inputted document content and another XML file that describes said particular XML file;

in response to detecting that the document editor application is attempting to save the multi-file archive document;

extracting from said multi-file archive document the particular XML file that contains user-inputted document content;

said database server storing said particular XML file that contains user-inputted document content in one or more tables of a database that said database server defines as storing XML files; and

extracting from said multi-file archive document said another XML file that describes said particular XML file;

said database server storing said another XML file that describes said particular XML file in one or more tables of said database; and

wherein said steps are performed by one or more computing devices.

2. The method as recited in claim 1,

wherein said extracting comprises unzipping the multi-file archive document;

and

wherein said database server storing said particular XML file comprises the database server executing at least one of (a) Java code, (b) Structured Query Language (SQL) instructions, (c) PL/SQL code, (d) XQuery.

3. The method as recited in claim 1, further comprising:

determining that a particular XML element in XML data of the particular XML file that contains user-inputted document content corresponds to a particular column of a particular table in the database;

determining that the particular column does not contain contents that are enclosed between opening and closing tags of the particular XML element in the XML data of the particular XML file that contains user-inputted document content; and

in response to determining that the particular column does not contain the contents that are enclosed between the opening and closing tags of the particular XML element, generating an indication that the XML data is not valid.

4. The method as recited in claim 1, further comprising:

detecting that a change has been made to particular data that is contained in a particular text node or attribute of a node in an XMLType table that contains at least part of XML data of the particular XML file that contains user-inputted document content;

in response to detecting that the change has been made to the particular data, determining whether a rule is associated with the particular text node or attribute; and

in response to determining that the rule is associated with the particular text node or attribute, automatically performing an operation that is specified by the rule in response to the change being made to the particular data.

5. The method as recited in claim 1, further comprising:

receiving specified criteria that identify (a) at least one first XML element and (b) specified contents;

in response to receiving the specified criteria, the database server selecting, for inclusion in a set of multi-file archive documents, database-stored XML files that (a) contain an instance of the first XML element and (b) in which contents of the instance of the first XML element in those particular XML files that contain user-inputted document content match the specified contents; and

the database server returning, as query results, at least a portion of each multi-file archive document in the set of multi-file archive documents.

6. The method as recited in claim 5, further comprising:

receiving an indication of one or more second XML elements;

wherein the step of returning the query results comprises returning, as query results, only contents of each instance of the one or more second XML elements in the set of multi-file archive document, without returning, as query results, any other portion of any multi-file archive document in the set of multi-file archive documents.

7. The method as recited in claim 1, further comprising:

after the database server has stored the particular XML file that contains user-inputted document content, within one or more tables of a database, updating contents of one or more columns of the one or more tables independently of the document editor application;

after updating the contents of the one or more columns, receiving a request, from the document editor application, to open a multi-file archive document;

in response to the request, generating an updated version of the multi-file archive document that reflects the contents of the one or more columns as part of said updating; and

the database server sending the updated version of the multi-file archive document to the document editor application in response to the request, from the document editor application, to open the multi-file archive document.

8. The method as recited in claim 7, wherein the step of generating the updated version of the multi-file archive document comprises:

generating an enhanced version of the multi-file archive document in which information from other columns in one or more tables in the database have been added to the particular XML file that contains user-inputted document content;

wherein the information from the other columns was not specified in the particular XML file that contains user-inputted document content at a time that the document editor application attempted to store the particular XML file that contains user-inputted document content;

wherein the document editor application is a spreadsheet application; and

wherein the information from the other columns already existed in one or more tables in the database prior to a time that the document editor application attempted to store the particular XML file that contains user-inputted document content.

9. The method as recited in claim 1, further comprising:

receiving an indication of a particular format in which a version of a multi-file archive document is to be generated; and

in response to receiving the indication of the particular format, reading the user-inputted document content from the database and generating a version of the multi-file archive document in the particular format;

wherein the particular format differs from a multi-file archive format in which the document editor application attempted to store the multi-file archive document;

wherein said generating of said version of said multi-file archive document in said particular format comprises applying one or more XML stylesheets to the particular XML file that contains user-inputted document content.

10. The method as recited in claim 1, further comprising:

in response to a request, from the document editor application, to open a multi-file archive document that contains the particular XML file that contains user-inputted document content, the database server determining an access level of an entity that made the request;

determining one or more private XML elements that are mapped to the access level;

generating, based on access control information stored in the database, a redacted version of the multi-file archive document in which contents of the one or more private XML elements have been replaced in the multi-file archive document with information that identifies one or more names of the one or more private XML elements; and

providing the redacted version of the multi-file archive document to the document editor application in response to the request to open the multi-file archive document.

11. A non-transitory computer-readable medium on which are encoded instructions which, when executed by one or more processors, cause the one or more processors to perform steps comprising:

detecting that a document editor application, external to a database server, is attempting to save a multi-file archive document, wherein said multi-file archive document contains a plurality of extensible markup language (XML) files, wherein said plurality of XML files contains a particular XML file that contains user-inputted document content and another XML file that describes said particular XML file; and

in response to detecting that the document editor application is attempting to save the multi-file archive document;

extracting from said multi-file archive document the particular XML file that contains user-inputted document content;

said database server storing said particular XML file that contains user-inputted document content in one or more tables of a database that said database server defines as storing XML files;

extracting from said multi-file archive document said another XML file that describes said particular XML file; and

said database server storing said another XML file that describes said particular XML file in one or more tables of said database.

12. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

wherein said extracting comprises unzipping the multi-file archive document; and

wherein said database server storing said particular XML file comprises the database server executing at least one of (a) Java code, (b) Structured Query Language (SQL) instructions, (c) PL/SQL code, (d) XQuery.

13. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

determining that a particular XML element in XML data of the particular XML file that contains user-inputted document content corresponds to a particular column of a particular table in the database;

determining that the particular column does not contain contents that are enclosed between opening and closing tags of the particular XML element in the XML data of the particular XML file that contains user-inputted document content; and

in response to determining that the particular column does not contain the contents that are enclosed between the opening and closing tags of the particular XML element, generating an indication that the XML data is not valid.

14. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

detecting that a change has been made to particular data that is contained in a particular text node or attribute of a node in an XMLType table that contains at least part of XML data of the particular XML file that contains user-inputted document content;

in response to detecting that the change has been made to the particular data, determining whether a rule is associated with the particular text node or attribute; and

in response to determining that the rule is associated with the particular text node or attribute, automatically performing an operation that is specified by the rule in response to the change being made to the particular data.

15. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

receiving specified criteria that identify (a) at least one first XML element and (b) specified contents;

in response to receiving the specified criteria, the database server selecting, for inclusion in a set of multi-file archive documents, database-stored XML files that (a) contain an instance of the first XML element and (b) in which contents of the instance of the first XML element in those particular XML files that contain user-inputted document content match the specified contents; and

the database server returning, as query results, at least a portion of each multi-file archive document in the set of multi-file archive documents.

16. The non-transitory computer-readable medium as recited in claim 15, wherein the steps further comprise:

receiving an indication of one or more second XML elements;

wherein the step of returning the query results comprises returning, as query results, only contents of each instance of the one or more second XML elements in the set of multi-file archive document, without returning, as query results, any other portion of any multi-file archive document in the set of multi-file archive documents.

17. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

after the database server has stored the particular XML file that contains user-inputted document content, within one or more tables of a database, updating contents of one or more columns of the one or more tables independently of the document editor application;

after updating the contents of the one or more columns, receiving a request, from the document editor application, to open a multi-file archive document;

in response to the request, generating an updated version of the multi-file archive document that reflects the contents of the one or more columns as part of said updating; and

the database server sending the updated version of the multi-file archive document to the document editor application in response to the request, from the document editor application, to open the multi-file archive document.

18. The non-transitory computer-readable medium as recited in claim 17, wherein the step of generating the updated version of the multi-file archive document comprises:

generating an enhanced version of the multi-file archive document in which information from other columns in one or more tables in the database have been added to the particular XML file that contains user-inputted document content;

wherein the information from the other columns was not specified in the particular XML file that contains user-inputted document content at a time that the document editor application attempted to store the particular XML file that contains user-inputted document content;

wherein the document editor application is a spreadsheet application; and

wherein the information from the other columns already existed in one or more tables in the database prior to a time that the document editor application attempted to store the particular XML file that contains user-inputted document content.

19. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

receiving an indication of a particular format in which a version of a multi-file archive document is to be generated; and

in response to receiving the indication of the particular format, reading the user-inputted document content from the database and generating a version of the multi-file archive document in the particular format;

wherein the particular format differs from a multi-file archive format in which the document editor application attempted to store the multi-file archive document;

wherein said generating of said version of said multi-file archive document in said particular format comprises applying one or more XML stylesheets to the particular XML file that contains user-inputted document content.

20. The non-transitory computer-readable medium as recited in claim 11, wherein the steps further comprise:

in response to a request, from the document editor application, to open a multi-file archive document that contains the particular XML file that contains user-inputted document content, the database server determining an access level of an entity that made the request;

determining one or more private XML elements that are mapped to the access level;

generating, based on access control information stored in the database, a redacted version of the multi-file archive document in which contents of the one or more private XML elements have been replaced in the multi-file archive document with information that identifies one or more names of the one or more private XML elements; and

providing the redacted version of the multi-file archive document to the document editor application in response to the request to open the multi-file archive document.