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

The present invention is a method and system that allows users to create, customize, and execute reports on data stored in databases using a web browser. This is done by selecting various report elements like data sources, fields, filters, labels,charts, and dashboards. The invention does not require any special software or knowledge of data access languages, making it easier for users to create reports through an Internet connection. It can directly connect to multiple database types without needing additional configuration items. The technical effect of the invention is to provide a more convenient and user-friendly way for users to create reports on data stored in databases.

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