Arrangement enabling thin client to access and present data in custom defined reports

• US 20060136436A1
• Filed: 02/10/2005
• Published: 06/22/2006
• Est. Priority Date: 12/22/2004
• Status: Abandoned Application

• Current Assignee: AT&T Corporation (AT&T, Inc.)
• Original Assignee: AT&T Corporation (AT&T, Inc.)
• Inventors: Parker, Sam, Puthenpura, Sarat, Belanger, David, Aftab, Syed Anwar, Pishmanov, Stanislav
• Application Number:
  US11/054,877
• Publication Number:
  US 20060136436A1
• Time in Patent Office: Days
• US Class Current: 1/1
• CPC Class Codes: G06F 16/80 of semi-structured data, e.g. markup language structured data such as SGML, XML or HTML content-based retrieval of web data G06F16/95

Abstract

A report definition file (FIG. 7) that is in XML format governs access to and presentation of data from a domain database 364. The report definition file may be created by inputting from a thin client 200 (such as a web browser) a set of report specifications, and converting the set of report specifications into the XML-format report definition file. The thin client 200 may input the report specifications through a definition wizard 314 (step 502), or by direct entry of SQL commands that are interpreted by an SQL builder 332 (step 512). The report definition file is converted to SQL (step 606) to allow retrieval of the data for output to thin client 200.

Claims

1. A method of forming a report definition file for governing access to or presentation of data from a database, the method comprising:

inputting from a thin client, a set of report specifications; and

converting the set of report specifications into the report definition file, the report definition file being in a format defined by a markup language having user definable tags and that describes a relationship between a document'"'"'s content and structure.

2. The method of claim 1, wherein:

the thin client consists essentially of a world wide web browser.

3. The method of claim 1, wherein:

the markup language is extensible markup language (XML).

4. The method of claim 1, further comprising:

storing the report definition file for use in a subsequent report output method.

5. The method of claim 1, wherein the inputting step includes:

inputting the report specifications using an report definition wizard that guides a user with report definition options.

6. The method of claim 5, further comprising:

transforming the report specifications into a runtime data structure; and

marshaling the runtime data structure into the report definition file that is in extensible markup language (XML).

7. The method of claim 1, wherein the inputting step includes:

inputting the report specification in the form of standard query language (SQL) commands entered through the thin client.

8. The method of claim 7, further comprising:

parsing and validating the SQL commands; and

marshaling the SQL commands into the report definition file that is in extensible markup language (XML).

9. A method of outputting data from a database in a report governed by a report definition file, including the report definition file forming method of claim 1, and further comprising:

converting the report definition file to a report file expressed in commands of a database query language (SQL);

retrieving the data from the database in accordance with the report file; and

outputting the retrieved data in a format governed at least in part by the report file.

15. A computer program product including computer executable code or computer executable instructions that, when executed, causes a computer to perform the method of claim 1.

16. A computer program product including computer executable code or computer executable instructions that, when executed, causes a computer to perform the method of claim 9.

18. A system configured to perform the method of claim 1.

10. A method of outputting data from a database in a report governed by a report definition file, the method comprising:

retrieving the report definition file, the report definition file being in a format defined by a markup language (XML) having user definable tags and that describes a relationship between a document'"'"'s content and structure;

converting the report definition file to a report file expressed in commands of a database query language (SQL);

retrieving the data from the database in accordance with the report file; and

outputting the retrieved data in a format governed at least in part by the report file.

17. A computer program product including computer executable code or computer executable instructions that, when executed, causes a computer to perform the method of claim 10.

19. A system configured to perform the method of claim 10.

12. The method of claim 11, wherein:

the database query language is standard query language (SQL).

13. The method of claim 11, wherein:

the markup language is extensible markup language (XML).

14. The method of claim 11, further comprising:

presenting the (SQL) report file to the user; and

obtaining an input indicating the user'"'"'s approval of the report file.

20. An arrangement for outputting data from a domain database in a report governed by a report definition file that is in XML format, the arrangement comprising:

a definition wizard configured to provide report definition options to a thin client, and to input user selections through the thin client that govern creation of the report definition file;

an SQL builder configured to construct Standard Query Language (SQL) based on definition attributes generated from user inputs;

an XML engine configured to store, retrieve, transform, and process the XML-format report definition file based on either the definition wizard or the SQL builder; and

a data retriever configured to assemble and generate the data from the domain database in accordance with the report definition file.