Method and system for business intelligence over network using XML

• US 7,194,457 B1
• Filed: 10/03/2003
• Issued: 03/20/2007
• Est. Priority Date: 06/20/2001
• Status: Expired due to Term

• Current Assignee: Microstrategy Incorporated
• Original Assignee: Microstrategy Incorporated
• Inventors: Warikoo, Abhimanyu, Li, Benjamin Z., Alavi, Ali, Ding, Yuan
• Primary Examiner(s): Gaffin; Jeffrey
• Assistant Examiner(s): Veillard; Jacques
• Application Number:
  US10/677,245
• Time in Patent Office: 1,264 Days
• Field of Search: 707 1- 10, 707100-102, 707/104.1, 707/203, 709/202, 709/246, 715/501.1, 715/511, 715/513, 715/523
• US Class Current: 1/1
• CPC Class Codes: G06F 16/986 Document structures and storage, e.g. HTML extensions
• CPC Class Codes: Y10S 707/99933 Query processing, i.e. searching
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A method and system is provided for exchanging information over a computer network. A network server computer system receives a query request from at least one client computer system over a computer network. The query request is formatted into an extensible markup language query document according to an extensible markup language document application program interface. The extensible markup language query document is transmitted to at least one business intelligence server computer system. The at least one business intelligence server computer system retrieves the information requested in the extensible markup language query document from at least one data storage device.

Claims

1. A method for exchanging information over a computer network comprising the steps of:

receiving, into at least one network server computer system, a query request from at least one client computer system over a computer network;

formatting the query request into an extensible markup language query document according to an extensible markup language document application program interface;

transmitting the extensible markup language query document to at least one business intelligence server computer system;

receiving, into the at least one business intelligence server computer system, the extensible markup language query document; and

retrieving information requested in the extensible markup language query document from at least one data storage device.

2. The method of claim 1, wherein the at least one network server computer system comprises a cluster of network server computer systems configured to operate jointly.

3. The method of claim 1, wherein the at least one business intelligence server system comprises a cluster of business intelligence server computer systems configured to operate jointly.

4. The method of claim 1, wherein the computer network is the Internet.

5. The method of claim 1, further comprising the steps of:

formatting the retrieved information into an extensible markup language results document;

transmitting the extensible markup language results document to the at least one network server computer system;

formatting the extensible markup language results document into a browser-executable results document; and

transmitting the browser-executable results document to the at least one client computer system over the computer network.

6. The method of claim 5, further comprising the step of:

formatting the extensible markup language query document to reference a document type declaration, wherein the document type declaration is a set of rules defining the guidelines for the extensible markup language query document; and

formatting the extensible markup language results document to reference the document type declaration.

7. The method of claim 6, further comprising the steps of:

storing on the at least one business intelligence server computer system a copy of a document type declaration file including the referenced document type declaration; and

storing on the at least one network server computer system a copy of a document type declaration file including the referenced document type declaration.

8. The method of claim 1, wherein the step of formatting the query request into an extensible markup language query document according to an extensible markup language document application program interface further comprises the step of:

formatting the query request into a document having a plurality of nested elements, wherein the plurality of nested elements define relationships for information contained within the query.

9. The method of claim 7, further comprising the steps of:

formatting the query request to include a root level element; and

formatting the query request to include at least one item level element nested within the root level element, wherein the at least one item level element relates to data requested within the query request.

10. The method of claim 9, further comprising the steps of:

formatting the query request to include at least one information level element nested within at least one of the at least one item level element, wherein the at least one information level elements relates to objects requested within the query request.

11. A system for exchanging information over a computer network comprising:

at least one network server computer system for receiving a query request from at least one client computer system over a computer network, the at least one network server computer system formatting the query request into an extensible markup language query document according to an extensible markup language document application program interface;

at least one business intelligence server computer system for receiving the extensible markup language query document from the at least one network server

computer system; and

at least one data storage device for storing information requested in the extensible markup language query document,

wherein the at least one business intelligence server computer system retrieves the information requested in the extensible markup language query document from the at least one data storage device.

12. The system of claim 11, wherein the at least one network server computer system comprises a cluster of network server computer systems configured to operate jointly.

13. The system of claim 11, wherein the at least one business intelligence server system comprises a cluster of business intelligence server computer systems configured to operate jointly.

14. The system of claim 11, wherein the computer network is the Internet.

15. The system of claim 11, wherein:

the at least one business intelligence server computer system formats the information into an extensible markup language results document;

the at least one business intelligence server computer system transmits the extensible markup language results document to the at least one network server computer system;

the at least one network server computer system formats the extensible markup language results document into a browser-executable results document; and

the at least one network server computer system transmits the browser-executable results document to the at least one client computer system over the computer network.

16. The system of claim 15, wherein:

the at least one network server computer system formats the extensible markup language query document so as to reference a document type declaration, wherein the document type declaration is a set of rules defining the guidelines for the extensible markup language query document; and

the at least one business intelligence server computer system formats the extensible markup language results document to reference the document type declaration.

17. The system of claim 16, wherein:

the at least one business intelligence server computer system stores a copy of a document type declaration file including the referenced document type declaration; and

the at least one network server computer system stores a copy of a document type declaration file including the referenced document type declaration.

18. The system of claim 11, wherein:

the at least one network server computer system formats the query request into a document having a plurality of nested elements, wherein the plurality of nested elements define relationships for information contained within the query.

19. The system of claim 17, wherein:

the at least one network server computer system formats the query request to include a root level element; and

the at least one network server computer system formats the query request to include at least one item level element nested within the root level element, wherein the item level element relates to data requested within the query request.

20. The system of claim 19, wherein:

the at least one network server computer system formats formatting the query request to include at least one information level element nested within at least one of the at least one item level element, wherein the at least one information level elements relates to objects requested within the query request.