Self-service database reporting systems and methods

Abstract

Users interactively create, customize, and execute reports on data stored in databases using only a web browser. The user can create, customize, and execute reports by selecting various report elements including, for example, data sources, fields, filters, labels, charts, dashboards, and the like. Advantageously, the present disclosure enables users to create the reports through an Internet connection, without any special software, such as web browser plug-ins, database applications, and the like, without knowledge of data access languages, such as SQL, and without direct access to a database server. The present disclosure can directly connect to a plurality of different database types through a virtual or physical network connection. It fully functions without requiring the creation of additional configuration items like catalogs, models or secondary schemas by a programmer or database administrator (DBA).

Description

CROSS-REFERENCE TO RELATED APPLICATION(S)[0001]The present non-provisional patent application is a continuation of U.S. patent application Ser. No. 12 / 907,184, filed Oct. 19, 2010, and entitled “SELF-SERVICE DATABASE REPORTING SYSTEMS AND METHODS,” which is a continuation-in-part of U.S. patent application Ser. No. 11 / 967,159, filed Dec. 29, 2007, and entitled “SYSTEMS AND METHODS FOR INTERACTIVELY CREATING, CUSTOMIZING, AND EXECUTING REPORTS OVER THE INTERNET,” (now U.S. Pat. No. 7,840,600 issued on Nov. 23, 2010), which claims priority to U.S. Provisional Patent Application Ser. No. 60 / 882,822, filed Dec. 29, 2006, and entitled “A METHOD AND SYSTEM THAT ENABLES THE CREATION, CUSTOMIZATION AND EXECUTION OF REPORTS VIA THE INTERNET,” the disclosures of each are incorporated in full by reference herein.FIELD OF THE INVENTION[0002]The present invention relates generally to database system and methods. More specifically, the present invention provides systems and methods for self-servi...

AI Technical Summary

Benefits of technology

[0007]In various exemplary embodiments, the present invention provides methods and systems for enabling users to interactively create, customize, and execute reports on data stored in databases using only a web browser. The user can create, customize, and execute reports by selecting various report elements including, for example, data sources, fields, filters, labels, charts, dashboards, and the like. These can be selected though a web browser that includes an instance of a system connected to an appropriate data source. Advantageously, the present invention enables users to create the reports through an Internet connection, without any special software, such as web browser plug-ins, database applications, and the like, without knowledge of data access languages, such as SQL, and without direct access to a database server. The present invention can directly connect to a plurality of different database types through a virtual or physical network connection. It fully functions without requiring the creation of additional configuration items like catalogs, models or secondary schemas by a programmer or database administrator (DBA).

Problems solved by technology

Custom designed reporting modules for applications require significant effort in terms of programming, deployment, and testing when a change needs to be made.

The cost of maintaining such systems is high and there is significant risk of introducing bugs when software is updated.

Additionally, these do not operate over HTTP alone.

Furthermore, these tools can only be used by experts with knowledge of database administration and software programming.

Images