US7185002B1 - Systems and methods for data retrieval, manipulation, and delivery - Google Patents

Systems and methods for data retrieval, manipulation, and delivery Download PDF

Info

Publication number
US7185002B1
US7185002B1 US10/279,563 US27956302A US7185002B1 US 7185002 B1 US7185002 B1 US 7185002B1 US 27956302 A US27956302 A US 27956302A US 7185002 B1 US7185002 B1 US 7185002B1
Authority
US
United States
Prior art keywords
report
server
electronic mail
mail delivery
delivery address
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Expired - Lifetime, expires
Application number
US10/279,563
Inventor
Rick A. Allen
Robert H. Wright
Willard Weitlauf
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Rakuten Group Inc
Original Assignee
BellSouth Intellectual Property Corp
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by BellSouth Intellectual Property Corp filed Critical BellSouth Intellectual Property Corp
Priority to US10/279,563 priority Critical patent/US7185002B1/en
Assigned to BELLSOUTH INTELLECTUAL PROPERTY CORPORATION reassignment BELLSOUTH INTELLECTUAL PROPERTY CORPORATION ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: WEITLAUF, WILLARD, ALLEN, RICK A., WRIGHT, ROBERT H.
Priority to US11/621,598 priority patent/US7437369B2/en
Application granted granted Critical
Publication of US7185002B1 publication Critical patent/US7185002B1/en
Priority to US12/250,741 priority patent/US20090037392A1/en
Assigned to AT&T BLS INTELLECTUAL PROPERTY, INC. reassignment AT&T BLS INTELLECTUAL PROPERTY, INC. CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: AT&T INTELLECTUAL PROPERTY, INC.
Assigned to AT&T DELAWARE INTELLECTUAL PROPERTY, INC. reassignment AT&T DELAWARE INTELLECTUAL PROPERTY, INC. CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: AT&T BLS INTELLECTUAL PROPERTY, INC.
Assigned to AT&T INTELLECTUAL PROPERTY, INC. reassignment AT&T INTELLECTUAL PROPERTY, INC. CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: BELLSOUTH INTELLECTUAL PROPERTY CORPORATION
Assigned to AT&T INTELLECTUAL PROPERTY I, L.P. reassignment AT&T INTELLECTUAL PROPERTY I, L.P. ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: AT&T DELAWARE INTELLECTUAL PROPERTY, INC.
Assigned to RAKUTEN, INC. reassignment RAKUTEN, INC. ASSIGNMENT OF ASSIGNORS INTEREST (SEE DOCUMENT FOR DETAILS). Assignors: AT&T INTELLECTUAL PROPERTY I, L.P.
Assigned to RAKUTEN GROUP, INC. reassignment RAKUTEN GROUP, INC. CHANGE OF NAME (SEE DOCUMENT FOR DETAILS). Assignors: RAKUTEN, INC.
Adjusted expiration legal-status Critical
Expired - Lifetime legal-status Critical Current

Links

Images

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/24Querying
    • G06F16/248Presentation of query results
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99932Access augmentation or optimizing
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99931Database or file accessing
    • Y10S707/99933Query processing, i.e. searching
    • Y10S707/99935Query augmenting and refining, e.g. inexact access
    • YGENERAL TAGGING OF NEW TECHNOLOGICAL DEVELOPMENTS; GENERAL TAGGING OF CROSS-SECTIONAL TECHNOLOGIES SPANNING OVER SEVERAL SECTIONS OF THE IPC; TECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10TECHNICAL SUBJECTS COVERED BY FORMER USPC
    • Y10STECHNICAL SUBJECTS COVERED BY FORMER USPC CROSS-REFERENCE ART COLLECTIONS [XRACs] AND DIGESTS
    • Y10S707/00Data processing: database and file management or data structures
    • Y10S707/99941Database schema or data structure
    • Y10S707/99944Object-oriented database structure
    • Y10S707/99945Object-oriented database structure processing

Definitions

  • the present invention relates to database systems. More specifically, the invention relates to systems and methods for user-friendly retrieval, manipulation, delivery, and formatting of data.
  • a data report includes an organized collection of data. Such a report may be compiled by querying a database for data, which may be imported into a spreadsheet.
  • the spreadsheet may be used to assemble the data into visual aides such as tables, charts, and graphs.
  • the data may be limited to a desired time period such as a week, a month, or a year.
  • the report may be updated at desired intervals by resubmitting the query to the database and importing the newly retrieved data into the spreadsheet.
  • a set of queries necessary to compile a report may be saved. Saving queries enables a report to be updated at desired intervals without having to rewrite the queries.
  • the retrieved data still must be repetitively manipulated upon its receipt. For example, if a report is generated using a spreadsheet, then the data must be manually imported into the spreadsheet every time the report is updated. The manual importation of the retrieved data into the spreadsheet is time-consuming and expensive. Specifically, columns of the spreadsheet must be adjusted to fit the retrieved data.
  • a user interface enables a user to request a report.
  • the requested report may be selected from a group of available reports.
  • the request may include an interval at which the report is to be updated.
  • the request may also include an electronic mail address at which to deliver the report.
  • Sets of one or more pre-defined queries may be stored at a server.
  • Each set of pre-defined queries may be associated with a respective report in the group of available reports.
  • the respective set of pre-defined queries associated with the requested report is submitted to a database.
  • the query results may be formatted using an electronic spreadsheet.
  • the validity of the electronic mail delivery address may be verified. If the address is valid, the formatted report may be delivered to the address. If the address is invalid, the request may be ignored.
  • the report may be updated at the requested interval by resubmitting the stored set of pre-defined queries.
  • the validity of the delivery address may be verified at each update interval. If the address remains valid, the updated report may be delivered to the delivery address.
  • FIG. 1 is an exemplary prior art user interface for defining a query to be run on a database
  • FIG. 2 is an exemplary prior art spreadsheet file including imported query results
  • FIG. 3 is an exemplary prior art spreadsheet file including an edited report
  • FIG. 4 is a block diagram of a system for data retrieval, manipulation, and delivery in accordance with the present invention.
  • FIG. 5 is a block diagram of a method for data retrieval, manipulation, and delivery in accordance with the present invention.
  • FIG. 6 is an exemplary user interface in accordance with the present invention.
  • FIG. 7 is a high level diagram of an exemplary computer network for communicating electronic data that can be used in accordance with the present invention.
  • a system includes a user interface that enables a user to request a pre-defined report.
  • the user may specify an electronic mail delivery address for the report.
  • the user may also specify an interval at which the report is to be updated.
  • the invention enables a particular report to be produced and formatted only once, and then submitted to multiple users, thereby eliminating the production and formatting of redundant reports.
  • the report is reproduced and reformatted every time it is prepared.
  • the production of the report includes defining a set of one or more queries directed to the report data.
  • the queries are run on a database, and the query results are received from the database.
  • the received results may be saved in a text file.
  • the results are then formatted into a report.
  • the results may be formatted into a report by opening the text file with an electronic spreadsheet.
  • the spreadsheet may be used to manipulate the query results into a table or chart.
  • FIG. 1 An exemplary prior art user interface for defining a query to be run on a database is shown in FIG. 1 .
  • the user interface 100 is displayed on a device such as, for example, a monitor connected to a personal computer.
  • a user may access the user interface 100 by accessing a database management system (DBMS) running on the personal computer.
  • DBMS database management system
  • the user may be required to login.
  • User interface 100 includes an exemplary query.
  • the query is written in Structured Query Language (SQL), and it includes three statements: a “select” statement, a “from” statement, and a “where” statement.
  • SQL Structured Query Language
  • the user To write a query such as the query shown in FIG. 1 , the user must have a proficiency in a query language such as SQL.
  • User interface 100 also includes a command prompt at which a user may enter a command to run the query. For example, the user may press the “F2” key on a keyboard to run the query.
  • the query results are received from the database.
  • the received results may be saved in a text file.
  • the results are then formatted into a report.
  • the results may be formatted into a report by opening the text file with an electronic spreadsheet.
  • An exemplary prior art spreadsheet file including imported query results is shown in FIG. 2 .
  • spreadsheet 200 includes multiple rows and columns. The user may make the rows and columns an appropriate size to fit the data by selecting an “Auto Fit” option in a menu (not shown).
  • the exemplary report 200 a is shown in FIG. 2 at the bottom right portion of spreadsheet 200 .
  • Exemplary report 200 a includes sales information for various months in the year 2000.
  • Spreadsheet 200 may display the data in the report in an undesired format.
  • spreadsheet 200 may format numerical data in scientific notation rather than in regular decimal form.
  • the user must set default settings of spreadsheet 200 to the desired formats. Such setting of default format settings may be time consuming and may require a proficiency in using spreadsheet 200 .
  • the imported file may also include extraneous data 200 b related to the processing of the query.
  • extraneous data 200 b is shown in FIG. 2 in the top left portion of spreadsheet 200 .
  • the user may delete any or all of extraneous data 200 b by highlighting the unwanted data and striking a “delete” key on an attached keyboard. If the imported file includes a large amount of data, the deletion of extraneous data 200 b may be a time consuming process.
  • An exemplary prior art spreadsheet 200 including an edited report 200 a is shown in FIG. 3 . As shown, extraneous data 200 b included in the original imported spreadsheet file 200 has been deleted.
  • the systems and methods of the present invention enable a report such as the report shown in FIG. 3 to be compiled and delivered to multiple users without redundant production and formatting. As set forth above with reference to prior art FIGS. 1–3 , such production and formatting may be time consuming and may require a proficiency in query language and formatting applications. Furthermore, the systems and methods of the present invention enable a report to be automatically updated at requested intervals and delivered to a requested electronic mail delivery address.
  • FIG. 4 A block diagram of a system for data retrieval, manipulation, and delivery in accordance with the invention is shown in FIG. 4 .
  • a user at workstation 410 may request a report using a user interface according to the invention.
  • a user interface according to the invention may be an application that may run on workstation 410 .
  • Workstation 410 may be a desktop personal computer or a portable personal computing device such as a laptop computer.
  • the user may request a report selected from a group of available reports.
  • the user may also request an electronic mail address to which to deliver the report.
  • the request is submitted to server 430 over network 420 .
  • Network 420 is preferably a local area network (LAN), but it may also be a wide area network (WAN) such as the Internet.
  • Server 430 may process the request by retrieving a set of one or more pre-defined queries directed to the requested report.
  • the pre-defined set of queries may be stored at Server 430 .
  • Server 430 submits over Network 420 the retrieved set of queries to database 440 .
  • the query is run at database 440 , and the query results are submitted to Server 430 over Network 420 .
  • Server 430 receives and formats the query results into a report.
  • the report may be formatted using an electronic spreadsheet running at Server 430 .
  • the formatted report may be delivered to the electronic mail address specified by the user.
  • the user may access his or her electronic mail account through an application running on workstation 410 .
  • the application may download the electronic mail directly from Server 430 over Network 420 .
  • Sever 430 may also deliver the electronic mail to another electronic mail server (not shown).
  • the application running at workstation 410 may download the electronic mail from the electronic mail server.
  • server 430 receives sets of one or more pre-defined queries.
  • Each set of queries is associated with a report in a group of available reports.
  • the queries may be defined at a remote personal computer such as, for example, workstation 410 , and submitted to server 430 over Network 420 .
  • the queries may be written in a query language such as, for example structured query language (SQL).
  • SQL structured query language
  • the sets of queries are stored at database 440 .
  • the reports in the group of available reports may be periodically added or removed, and the sets of queries associated with those reports may also periodically be respectively added or removed.
  • the queries may be periodically edited or redefined.
  • server 430 provides a user interface that enables a user to request a report.
  • the user interface may be downloaded by a remote personal computer such as, for example, workstation 410 over network 420 .
  • the user interface may be updated periodically.
  • the user interface may enable a user to request a report selected from the group of available reports.
  • the request may include an interval at which the report is to be updated and an electronic mail delivery address for the report.
  • the user interface may also enable a user to contact a system administrator to request a “new” report that is not included in the group of available reports.
  • the system administrator may define a “new” set of queries associated with the new report.
  • the new report may be added to the group of available reports, and the new set of queries may be submitted to server 430 and stored at database 440 , thereby enabling the new report to be subsequently requested by later users.
  • server 430 queries database 440 with the set of queries and parameters associated with a requested report.
  • the set of queries and parameters is submitted to database 440 over network 420 .
  • the query results are received at server 430 .
  • server 430 formats the query results.
  • Server 430 may format the query results using an electronic spreadsheet. The formatting is performed automatically using a predefined routine. That is, the report may be formatted without user intervention.
  • server 430 verifies the validity of the electronic mail delivery address.
  • the address may be verified by contacting the mail server associated with the delivery address. If the deliver address is invalid, the request may be ignored. If the deliver address is valid, the report is delivered to the address at step 522 .
  • the report may be updated at the interval requested at step 514 .
  • the report may be updated by repeating step 516 , in which database 440 is queried with the set of queries associated with the requested report. The results of the resubmitted set of queries are used to compile an updated report with updated data.
  • the updated report may be formatted and delivered to the requested address at the requested interval. The validity of the requested address may be verified again.
  • user interface 600 may include a reports drop down menu 610 , an update drop down menu 612 , a deliver address prompt 614 , and a link to the system administrator 616 .
  • User interface 600 may be provided by server 430 , and downloaded over network 420 by a remote personal computer such as, for example, workstation 410 .
  • Server 430 may periodically change or update user interface 600 .
  • User interface 600 may include drop down menu 610 for displaying the reports in the group of available reports. Reports may be periodically added or removed from drop down menu 610 . A pre-defined set of queries associated with each report in drop down menu 610 may be stored at database 440 . User interface 600 may also include drop down menu 620 for displaying the available update intervals for the requested report. The report requested at drop down menu 610 may be updated at the interval selected at drop down menu 612 by repeating step 516 of FIG. 5 , in which database 440 is queried with the set of queries associated with the requested report.
  • User interface 600 may also include delivery address prompt 614 .
  • the report requested at drop down menu 610 may be delivered to the address entered at prompt 614 .
  • Updated reports compiled at the interval selected at drop down menu 612 may also be delivered to the address entered at prompt 614 .
  • the address entered at prompt 614 may be verified before the report is delivered. If the address is invalid, the request may be ignored.
  • User interface 600 may also include system administrator link 616 .
  • Link 616 enables a user to contact a system administrator to request a “new” report that is not included in the group of available reports displayed at drop down menu 610 .
  • the system administrator may define a “new” set of queries associated with the new report.
  • the new report may be added to the group of available reports displayed at drop down menu 610 , and the new set of queries may be submitted to server 430 and stored at database 440 , thereby enabling the new report to be subsequently requested by later users.
  • FIG. 7 is a block diagram of a generic computing system suitable for use in a system in accordance with the present invention.
  • computing device 720 includes processing unit 722 , system memory 724 , and system bus 726 that couples various system components including system memory 724 to the processing unit 722 .
  • the system memory 724 might include read-only memory (ROM) and random access memory (RAM).
  • the system might further include hard-drive 728 , which provides storage for computer readable instructions, data structures, program modules and other data.
  • a user may enter commands and information into the computer 720 through input devices such as a keyboard 740 and pointing device 742 which may be, for example, a mouse or remote control.
  • a monitor 744 or other type of display device is also connected to the system for output.
  • Communications device 743 which in one embodiment may be a modem, provides for communications over a network such as, for example, the Internet.
  • Processor 722 can be programmed with instructions to interact with other computing systems so as to perform the techniques described above with reference to FIG. 5 .
  • the instructions may be received from a network or stored in memory 724 and/or hard drive 728 .
  • Processor 722 may be loaded with any one of several computer operating systems such as Windows NT, Windows 2000, or Linux.
  • the present invention includes a user interface that enables a user to request a pre-defined report.
  • the user may specify an electronic mail delivery address for the report.
  • the user may also specify an interval at which the report is to be updated.
  • the present invention enables a particular report to be produced and formatted only once, and then submitted to multiple users, thereby eliminating the production and formatting of redundant reports.

Abstract

Systems and methods are disclosed that include a user interface that enables a user to request a pre-defined report. The user may specify either or both of an electronic mail delivery address for the report and an interval at which the report is to be updated. Such systems and methods enable a particular report to be produced and formatted only once, and then provided to multiple users, thereby eliminating the production and formatting of redundant reports.

Description

FIELD OF THE INVENTION
The present invention relates to database systems. More specifically, the invention relates to systems and methods for user-friendly retrieval, manipulation, delivery, and formatting of data.
BACKGROUND OF THE INVENTION
A data report includes an organized collection of data. Such a report may be compiled by querying a database for data, which may be imported into a spreadsheet. The spreadsheet may be used to assemble the data into visual aides such as tables, charts, and graphs. The data may be limited to a desired time period such as a week, a month, or a year. The report may be updated at desired intervals by resubmitting the query to the database and importing the newly retrieved data into the spreadsheet.
The compilation of such reports is often labor-intensive and expensive. One reason for the high expense of report compilation is the cost of writing queries. Writing queries is expensive because it requires a proficiency in a query language such as, for example, Structured Query language (SQL). Multiple complex queries may often be required to generate a single report. Thus, to compile a large number of reports, a large number of programmers proficient in a query language must be acquired and retained.
Due to the expense of writing queries, a set of queries necessary to compile a report may be saved. Saving queries enables a report to be updated at desired intervals without having to rewrite the queries. However, even if a report is updated using a set of saved queries, the retrieved data still must be repetitively manipulated upon its receipt. For example, if a report is generated using a spreadsheet, then the data must be manually imported into the spreadsheet every time the report is updated. The manual importation of the retrieved data into the spreadsheet is time-consuming and expensive. Specifically, columns of the spreadsheet must be adjusted to fit the retrieved data.
Another reason for the high cost of report compilation is that the processors used to submit queries and to manipulate data are expensive to operate. Adding to the expense of processor operation is that multiple authors may request redundant reports. The compilation of such redundant reports results in the incurrence of processor expenses to submit redundant sets of queries and to manipulate redundant data.
Thus, there is a need in the art for systems and methods that enable users without query-writing proficiency to request certain predefined reports. There is further a need for such systems and methods to automatically import data into a format that is suitable for such a report, and to provide such reports to multiple users based on only a single retrieval of the data required to build the report.
SUMMARY OF THE INVENTION
A user interface enables a user to request a report. The requested report may be selected from a group of available reports. The request may include an interval at which the report is to be updated. The request may also include an electronic mail address at which to deliver the report.
Sets of one or more pre-defined queries may be stored at a server. Each set of pre-defined queries may be associated with a respective report in the group of available reports. When a report is requested, the respective set of pre-defined queries associated with the requested report is submitted to a database. The query results may be formatted using an electronic spreadsheet.
The validity of the electronic mail delivery address may be verified. If the address is valid, the formatted report may be delivered to the address. If the address is invalid, the request may be ignored.
The report may be updated at the requested interval by resubmitting the stored set of pre-defined queries. The validity of the delivery address may be verified at each update interval. If the address remains valid, the updated report may be delivered to the delivery address.
BRIEF DESCRIPTION OF THE DRAWINGS
The illustrative embodiments will be better understood after reading the following detailed description with reference to the appended drawings, in which:
FIG. 1 is an exemplary prior art user interface for defining a query to be run on a database;
FIG. 2 is an exemplary prior art spreadsheet file including imported query results;
FIG. 3 is an exemplary prior art spreadsheet file including an edited report;
FIG. 4 is a block diagram of a system for data retrieval, manipulation, and delivery in accordance with the present invention;
FIG. 5 is a block diagram of a method for data retrieval, manipulation, and delivery in accordance with the present invention;
FIG. 6 is an exemplary user interface in accordance with the present invention; and
FIG. 7 is a high level diagram of an exemplary computer network for communicating electronic data that can be used in accordance with the present invention.
DETAILED DESCRIPTION
Presently preferred exemplary embodiments of the invention are described below with reference to aforementioned figures. Those skilled in the art will readily appreciate that the description given herein with respect to those figures is for explanatory purposes only and is not intended in any way to limit the scope of the invention. Throughout the description, like reference numerals will refer to like elements in the respective figures.
Generally, a system according to the invention includes a user interface that enables a user to request a pre-defined report. The user may specify an electronic mail delivery address for the report. The user may also specify an interval at which the report is to be updated. The invention enables a particular report to be produced and formatted only once, and then submitted to multiple users, thereby eliminating the production and formatting of redundant reports.
In prior art methods for compiling a report, the report is reproduced and reformatted every time it is prepared. The production of the report includes defining a set of one or more queries directed to the report data. The queries are run on a database, and the query results are received from the database. The received results may be saved in a text file. The results are then formatted into a report. The results may be formatted into a report by opening the text file with an electronic spreadsheet. The spreadsheet may be used to manipulate the query results into a table or chart.
An exemplary prior art user interface for defining a query to be run on a database is shown in FIG. 1. As shown, the user interface 100 is displayed on a device such as, for example, a monitor connected to a personal computer. A user may access the user interface 100 by accessing a database management system (DBMS) running on the personal computer. Upon accessing the DBMS, the user may be required to login.
User interface 100 includes an exemplary query. The query is written in Structured Query Language (SQL), and it includes three statements: a “select” statement, a “from” statement, and a “where” statement. To write a query such as the query shown in FIG. 1, the user must have a proficiency in a query language such as SQL. User interface 100 also includes a command prompt at which a user may enter a command to run the query. For example, the user may press the “F2” key on a keyboard to run the query.
After the query has been run on a database, the query results are received from the database. The received results may be saved in a text file. The results are then formatted into a report. The results may be formatted into a report by opening the text file with an electronic spreadsheet. An exemplary prior art spreadsheet file including imported query results is shown in FIG. 2. As shown, spreadsheet 200 includes multiple rows and columns. The user may make the rows and columns an appropriate size to fit the data by selecting an “Auto Fit” option in a menu (not shown).
The exemplary report 200 a is shown in FIG. 2 at the bottom right portion of spreadsheet 200. Exemplary report 200 a includes sales information for various months in the year 2000. Spreadsheet 200 may display the data in the report in an undesired format. For example, spreadsheet 200 may format numerical data in scientific notation rather than in regular decimal form. To ensure that the data is displayed in the desired formats, the user must set default settings of spreadsheet 200 to the desired formats. Such setting of default format settings may be time consuming and may require a proficiency in using spreadsheet 200.
In addition to including the desired report data, the imported file may also include extraneous data 200 b related to the processing of the query. Such data is shown in FIG. 2 in the top left portion of spreadsheet 200. The user may delete any or all of extraneous data 200 b by highlighting the unwanted data and striking a “delete” key on an attached keyboard. If the imported file includes a large amount of data, the deletion of extraneous data 200 b may be a time consuming process. An exemplary prior art spreadsheet 200 including an edited report 200 a is shown in FIG. 3. As shown, extraneous data 200 b included in the original imported spreadsheet file 200 has been deleted.
The systems and methods of the present invention enable a report such as the report shown in FIG. 3 to be compiled and delivered to multiple users without redundant production and formatting. As set forth above with reference to prior art FIGS. 1–3, such production and formatting may be time consuming and may require a proficiency in query language and formatting applications. Furthermore, the systems and methods of the present invention enable a report to be automatically updated at requested intervals and delivered to a requested electronic mail delivery address.
A block diagram of a system for data retrieval, manipulation, and delivery in accordance with the invention is shown in FIG. 4. As shown, a user at workstation 410 may request a report using a user interface according to the invention. A user interface according to the invention may be an application that may run on workstation 410. Workstation 410 may be a desktop personal computer or a portable personal computing device such as a laptop computer. The user may request a report selected from a group of available reports. The user may also request an electronic mail address to which to deliver the report.
The request is submitted to server 430 over network 420. Network 420 is preferably a local area network (LAN), but it may also be a wide area network (WAN) such as the Internet. Server 430 may process the request by retrieving a set of one or more pre-defined queries directed to the requested report. The pre-defined set of queries may be stored at Server 430. Server 430 submits over Network 420 the retrieved set of queries to database 440. The query is run at database 440, and the query results are submitted to Server 430 over Network 420. Server 430 receives and formats the query results into a report. The report may be formatted using an electronic spreadsheet running at Server 430.
The formatted report may be delivered to the electronic mail address specified by the user. The user may access his or her electronic mail account through an application running on workstation 410. The application may download the electronic mail directly from Server 430 over Network 420. Sever 430 may also deliver the electronic mail to another electronic mail server (not shown). The application running at workstation 410 may download the electronic mail from the electronic mail server.
A flowchart of a method for data retrieval, manipulation, and delivery in accordance with the present invention is shown in FIG. 5. As shown, at step 510, server 430 receives sets of one or more pre-defined queries. Each set of queries is associated with a report in a group of available reports. The queries may be defined at a remote personal computer such as, for example, workstation 410, and submitted to server 430 over Network 420. The queries may be written in a query language such as, for example structured query language (SQL). At step 512, the sets of queries are stored at database 440. The reports in the group of available reports may be periodically added or removed, and the sets of queries associated with those reports may also periodically be respectively added or removed. Furthermore, the queries may be periodically edited or redefined.
At step 514, server 430 provides a user interface that enables a user to request a report. The user interface may be downloaded by a remote personal computer such as, for example, workstation 410 over network 420. The user interface may be updated periodically. The user interface may enable a user to request a report selected from the group of available reports. The request may include an interval at which the report is to be updated and an electronic mail delivery address for the report.
The user interface may also enable a user to contact a system administrator to request a “new” report that is not included in the group of available reports. The system administrator may define a “new” set of queries associated with the new report. The new report may be added to the group of available reports, and the new set of queries may be submitted to server 430 and stored at database 440, thereby enabling the new report to be subsequently requested by later users.
At step 516, server 430 queries database 440 with the set of queries and parameters associated with a requested report. The set of queries and parameters is submitted to database 440 over network 420. After the query is performed, the query results are received at server 430. At step 518, server 430 formats the query results. Server 430 may format the query results using an electronic spreadsheet. The formatting is performed automatically using a predefined routine. That is, the report may be formatted without user intervention.
At step 520, server 430 verifies the validity of the electronic mail delivery address. The address may be verified by contacting the mail server associated with the delivery address. If the deliver address is invalid, the request may be ignored. If the deliver address is valid, the report is delivered to the address at step 522.
After the requested report has been delivered, the report may be updated at the interval requested at step 514. The report may be updated by repeating step 516, in which database 440 is queried with the set of queries associated with the requested report. The results of the resubmitted set of queries are used to compile an updated report with updated data. The updated report may be formatted and delivered to the requested address at the requested interval. The validity of the requested address may be verified again.
An exemplary user interface in accordance with step 514 of FIG. 5 is shown in FIG. 6. As shown, user interface 600 may include a reports drop down menu 610, an update drop down menu 612, a deliver address prompt 614, and a link to the system administrator 616. User interface 600 may be provided by server 430, and downloaded over network 420 by a remote personal computer such as, for example, workstation 410. Server 430 may periodically change or update user interface 600.
User interface 600 may include drop down menu 610 for displaying the reports in the group of available reports. Reports may be periodically added or removed from drop down menu 610. A pre-defined set of queries associated with each report in drop down menu 610 may be stored at database 440. User interface 600 may also include drop down menu 620 for displaying the available update intervals for the requested report. The report requested at drop down menu 610 may be updated at the interval selected at drop down menu 612 by repeating step 516 of FIG. 5, in which database 440 is queried with the set of queries associated with the requested report.
User interface 600 may also include delivery address prompt 614. The report requested at drop down menu 610 may be delivered to the address entered at prompt 614. Updated reports compiled at the interval selected at drop down menu 612 may also be delivered to the address entered at prompt 614. The address entered at prompt 614 may be verified before the report is delivered. If the address is invalid, the request may be ignored.
User interface 600 may also include system administrator link 616. Link 616 enables a user to contact a system administrator to request a “new” report that is not included in the group of available reports displayed at drop down menu 610. The system administrator may define a “new” set of queries associated with the new report. The new report may be added to the group of available reports displayed at drop down menu 610, and the new set of queries may be submitted to server 430 and stored at database 440, thereby enabling the new report to be subsequently requested by later users.
The FIG. 7 is a block diagram of a generic computing system suitable for use in a system in accordance with the present invention. As shown, computing device 720 includes processing unit 722, system memory 724, and system bus 726 that couples various system components including system memory 724 to the processing unit 722. The system memory 724 might include read-only memory (ROM) and random access memory (RAM). The system might further include hard-drive 728, which provides storage for computer readable instructions, data structures, program modules and other data. A user may enter commands and information into the computer 720 through input devices such as a keyboard 740 and pointing device 742 which may be, for example, a mouse or remote control. A monitor 744 or other type of display device is also connected to the system for output. Communications device 743, which in one embodiment may be a modem, provides for communications over a network such as, for example, the Internet. Processor 722 can be programmed with instructions to interact with other computing systems so as to perform the techniques described above with reference to FIG. 5. The instructions may be received from a network or stored in memory 724 and/or hard drive 728. Processor 722 may be loaded with any one of several computer operating systems such as Windows NT, Windows 2000, or Linux.
Thus, a system and method for data retrieval, manipulation, and delivery has been disclosed. The present invention includes a user interface that enables a user to request a pre-defined report. The user may specify an electronic mail delivery address for the report. The user may also specify an interval at which the report is to be updated. The present invention enables a particular report to be produced and formatted only once, and then submitted to multiple users, thereby eliminating the production and formatting of redundant reports.
While the present invention has been described in connection with the preferred embodiments of the various figures, it is to be understood that other similar embodiments may be used or modifications and additions may be made to the described embodiment for performing the same function of the present invention without deviating therefrom. For example, while the present invention is described above in connection with formatting a report using an electronic spreadsheet, any formatting application may be used. Therefore, the present invention should not be limited to any single embodiment, but rather should be construed in breadth and scope in accordance with the appended claims.

Claims (13)

1. A computer-implemented method for data retrieval, the method comprising:
providing a user interface to a server that enables a user to enter a request to generate a report, the request including an electronic mail delivery address associated with the requested report and an interval at which the requested report is to be updated, wherein the interface also includes a system administrator link which enables the user to request an additional report not included in a group of available reports;
retrieving a pre-defined set of queries associated with a requested report by the server to generate the report upon the occurrence of the each interval, wherein the requested report is one of the group of available reports;
generating the requested report by submitting the pre-defined set of inquiries upon each occurrence of the interval by submitting the pre-defined set of queries to a database;
receiving a result based in part in the pre-defined set of inquiries from the database by the server, wherein the server formats the report;
prior to the server attempting to send the report to the electronic mail delivery address of the user upon the occurrence of each of the intervals specified in the request, determining whether the electronic mail delivery address of the user is valid by the server contacting a mail server associated with the electronic mail delivery address;
if the electronic mail delivery address is determined to be not valid, then not attempting to send the report by the server for this occurrence of the interval; and
if the electronic mail delivery address is determined to be valid, then sending the requested report by the server to the electronic mail delivery address for the occurrence of the interval.
2. The computer-implemented method of claim 1, wherein providing the user interface comprises providing a user interface that enables the user to select the requested report from a group of available reports.
3. The computer-implemented method of claim 1, further comprising: storing the pre-defined set of queries.
4. The computer-implemented method of claim 1, further comprising: formatting the requested report.
5. The computer-implemented method of claim 4, wherein formatting the requested report comprises importing the requested report into an electronic spreadsheet.
6. The computer-implemented method of claim 1, wherein the providing a user interface to a server that enables a user to enter a request to generate a report includes providing a plurality of electronic mail delivery addresses associated with the requested report, and wherein sending the requested report by the server to the electronic mail delivery address includes sending the requested report substantially simultaneously by the server to the plurality of electronic mail delivery addresses for the occurrence of the interval.
7. A computer-implemented method for data retrieval, the method comprising:
receiving a plurality of pre-defined query sets resident on a server, each said query set being associated with a respective report, the respective reports forming a group of available reports;
providing a user interface that enables a user to submit a request to the server to generate a report selected from the group of available reports, the request comprising an electronic mail delivery address associated with the report, wherein further the user interface comprises an update drop down menu for displaying an available interval at which the requested report is to be updated, a report drop down menu for displaying the reports in the group of available reports, a system administrator link which enables the user to request an additional report not included in the group of available reports from the system administrator;
prior to the server sending the requested report upon an occurrence of the interval, determining whether the electronic mail delivery address is valid;
if the electronic mail delivery address is net determined to be not valid, then not sending the report; and
if the electronic mail delivery address is determined to be valid, then sending the requested report to the electronic mail delivery address upon the occurrence of the interval, the requested report being generated upon each occurrence of the interval by submitting to a database the pre-defined query set that is associated with the requested report.
8. The computer-implemented method of claim 7, further comprising: storing the pre-defined sets of queries.
9. The computer-implemented method of claim 7, further comprising: terminating delivery of the requested report in response to a termination request.
10. The computer-implemented method of claim 7, further comprising: formatting a set of query results corresponding to the pre-defined query set.
11. The computer-implemented method of claim 10, wherein formatting the set of query result comprises formatting the set of query results into an electronic spreadsheet.
12. A computer-readable medium having stored thereon computer executable instructions for performing a method comprising:
providing a user interface that enables a user to enter a request to generate a report, the request comprising at least one electronic mail delivery address associated with the requested report, and wherein the request further comprises an interval at which the requested report is to be updated, wherein further the interface enables the user to request an additional report not included in the group of available reports from a system administrator by providing a system administrator link;
retrieving a pre-defined set of queries associated with a requested report from a server, wherein the requested report is one of a group of available reports;
prior to sending the requested report by the server upon an occurrence of the interval, determining by the server whether the electronic mail delivery address is valid;
if the electronic mail delivery address is determined to be not valid, then not sending the report; and
if the electronic mail delivery address is determined to be valid, then sending the requested report to the electronic mail delivery address, the requested report being generated upon each occurrence of the interval by submitting the pre-defined set of queries to a database.
13. A computer-readable medium having stored thereon computer-executable instructions for performing a method comprising:
providing a user interface with a server that enables a user to submit a request to generate a report selected from the group of available reports, the request comprising at least an electronic mail delivery address associated with the report and an interval at which the requested report is to be updated, wherein the interface also includes a system administrator link which enables the user to request an additional report not included in the group of available resorts;
generating the requested report by submitting the pre-defined set of inquiries upon each occurrence of the interval by submitting the pre-defined set of queries to a database;
receiving a result based in part in the pre-defined set of inquiries from the database by the server, wherein the server formats the report;
prior to sending the requested report from the server, determining whether the electronic mail delivery address is valid by the server contacting a mail server associated with the electronic mail delivery address;
if the electronic mail delivery address is determined to be not valid, then not sending of the report; and
if the electronic mail delivery address is determined to be valid, then sending the requested report from the server to the electronic mail delivery address upon the occurrence of the interval.
US10/279,563 2002-10-24 2002-10-24 Systems and methods for data retrieval, manipulation, and delivery Expired - Lifetime US7185002B1 (en)

Priority Applications (3)

Application Number Priority Date Filing Date Title
US10/279,563 US7185002B1 (en) 2002-10-24 2002-10-24 Systems and methods for data retrieval, manipulation, and delivery
US11/621,598 US7437369B2 (en) 2002-10-24 2007-01-10 Systems and methods for data retrieval, manipulation, and delivery
US12/250,741 US20090037392A1 (en) 2002-10-24 2008-10-14 Systems and methods for data retrieval, manipulation, and delivery

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
US10/279,563 US7185002B1 (en) 2002-10-24 2002-10-24 Systems and methods for data retrieval, manipulation, and delivery

Related Child Applications (1)

Application Number Title Priority Date Filing Date
US11/621,598 Continuation US7437369B2 (en) 2002-10-24 2007-01-10 Systems and methods for data retrieval, manipulation, and delivery

Publications (1)

Publication Number Publication Date
US7185002B1 true US7185002B1 (en) 2007-02-27

Family

ID=37769742

Family Applications (3)

Application Number Title Priority Date Filing Date
US10/279,563 Expired - Lifetime US7185002B1 (en) 2002-10-24 2002-10-24 Systems and methods for data retrieval, manipulation, and delivery
US11/621,598 Expired - Lifetime US7437369B2 (en) 2002-10-24 2007-01-10 Systems and methods for data retrieval, manipulation, and delivery
US12/250,741 Abandoned US20090037392A1 (en) 2002-10-24 2008-10-14 Systems and methods for data retrieval, manipulation, and delivery

Family Applications After (2)

Application Number Title Priority Date Filing Date
US11/621,598 Expired - Lifetime US7437369B2 (en) 2002-10-24 2007-01-10 Systems and methods for data retrieval, manipulation, and delivery
US12/250,741 Abandoned US20090037392A1 (en) 2002-10-24 2008-10-14 Systems and methods for data retrieval, manipulation, and delivery

Country Status (1)

Country Link
US (3) US7185002B1 (en)

Cited By (8)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070112726A1 (en) * 2002-10-24 2007-05-17 Allen Rick A Systems and methods for data retrieval, manipulation, and delivery
US20080319991A1 (en) * 2007-01-08 2008-12-25 Lsr Technologies System for Searching Network Accessible Data Sets
US20080319944A1 (en) * 2007-06-22 2008-12-25 Microsoft Corporation User interfaces to perform multiple query searches
US20090006324A1 (en) * 2007-06-27 2009-01-01 Microsoft Corporation Multiple monitor/multiple party searches
US20090006358A1 (en) * 2007-06-27 2009-01-01 Microsoft Corporation Search results
US20100106609A1 (en) * 2008-10-16 2010-04-29 Sherman Abe P Inventory analysis and merchandising system and method
US9792545B1 (en) 2009-05-08 2017-10-17 Abe P. Sherman Vendor-based inventory management system and method
CN109063057A (en) * 2018-07-20 2018-12-21 玖富金科控股集团有限责任公司 Data base query method, terminal, server, computer-readable medium and equipment

Families Citing this family (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
KR101756709B1 (en) * 2011-06-17 2017-07-11 삼성전자주식회사 Data management system and method for displaying data thereof
US20140304218A1 (en) * 2013-04-09 2014-10-09 International Business Machines Corporation Augmenting a business intelligence report with a search result

Citations (15)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5826269A (en) * 1995-06-21 1998-10-20 Microsoft Corporation Electronic mail interface for a network server
US6385644B1 (en) * 1997-09-26 2002-05-07 Mci Worldcom, Inc. Multi-threaded web based user inbox for report management
US6434601B1 (en) * 1999-03-31 2002-08-13 Micron Technology, Inc. Pre test electronic mail process
US6594689B1 (en) * 1997-05-08 2003-07-15 Unisys Corporation Multi-platform helper utilities
US6633851B1 (en) * 1999-10-01 2003-10-14 B-50.Com, Llc Systems and methods for generating custom reports based on point-of-sale data
US6694316B1 (en) * 1999-03-23 2004-02-17 Microstrategy Inc. System and method for a subject-based channel distribution of automatic, real-time delivery of personalized informational and transactional data
US6708205B2 (en) * 2001-02-15 2004-03-16 Suffix Mail, Inc. E-mail messaging system
US6732092B2 (en) * 2001-09-28 2004-05-04 Client Dynamics, Inc. Method and system for database queries and information delivery
US6775691B1 (en) * 2000-08-31 2004-08-10 International Business Machines Corporation Server protocol for dead e-mail identification locator
US6816863B2 (en) * 2002-05-09 2004-11-09 International Business Machines Corporation Method, system, and computer product for providing a distribution list
US6829636B1 (en) * 2000-09-28 2004-12-07 International Business Machines Corporation Method and apparatus for controlling dead e-mail address scanning discovery, status retries, and other metrics to enforce e-mail quality of service
US6944662B2 (en) * 2000-08-04 2005-09-13 Vinestone Corporation System and methods providing automatic distributed data retrieval, analysis and reporting services
US6957248B2 (en) * 2000-07-31 2005-10-18 Pitney Bowes Inc. System and method for forwarding electronic messages
US6959324B1 (en) * 2000-09-28 2005-10-25 International Business Machines Corporation Method and apparatus for adding data attributes to e-mail messages to enhance the analysis of delivery failures
US7096220B1 (en) * 2000-05-24 2006-08-22 Reachforce, Inc. Web-based customer prospects harvester system

Family Cites Families (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5966695A (en) * 1995-10-17 1999-10-12 Citibank, N.A. Sales and marketing support system using a graphical query prospect database
US5987464A (en) * 1996-07-26 1999-11-16 Schneider; Eric Method and system for periodically updating data records having an expiry time
US7225249B1 (en) * 1997-09-26 2007-05-29 Mci, Llc Integrated systems for providing communications network management services and interactive generating invoice documents
US6081810A (en) * 1998-02-03 2000-06-27 Electronic Data Systems Corporation Report database system
US6104798A (en) * 1998-02-12 2000-08-15 Mci Communications Corporation Order processing and reporting system for telecommunications carrier services
US6185567B1 (en) * 1998-05-29 2001-02-06 The Trustees Of The University Of Pennsylvania Authenticated access to internet based research and data services
US6466935B1 (en) * 1999-06-04 2002-10-15 International Business Machines Corporation Applying relational database technology to process control in manufacturing processes
US20030009385A1 (en) * 2000-12-26 2003-01-09 Tucciarone Joel D. Electronic messaging system and method thereof
US20030135611A1 (en) * 2002-01-14 2003-07-17 Dean Kemp Self-monitoring service system with improved user administration and user access control
US20040117731A1 (en) * 2002-09-27 2004-06-17 Sergey Blyashov Automated report building system
US7185002B1 (en) * 2002-10-24 2007-02-27 Bellsouth Intellectual Property Corp. Systems and methods for data retrieval, manipulation, and delivery
US20050209937A1 (en) * 2004-03-16 2005-09-22 Marcee Burns Methods, systems, and storage mediums for providing web-based reporting services for telecommunications entities

Patent Citations (16)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5826269A (en) * 1995-06-21 1998-10-20 Microsoft Corporation Electronic mail interface for a network server
US6594689B1 (en) * 1997-05-08 2003-07-15 Unisys Corporation Multi-platform helper utilities
US6385644B1 (en) * 1997-09-26 2002-05-07 Mci Worldcom, Inc. Multi-threaded web based user inbox for report management
US6631402B1 (en) * 1997-09-26 2003-10-07 Worldcom, Inc. Integrated proxy interface for web based report requester tool set
US6694316B1 (en) * 1999-03-23 2004-02-17 Microstrategy Inc. System and method for a subject-based channel distribution of automatic, real-time delivery of personalized informational and transactional data
US6434601B1 (en) * 1999-03-31 2002-08-13 Micron Technology, Inc. Pre test electronic mail process
US6633851B1 (en) * 1999-10-01 2003-10-14 B-50.Com, Llc Systems and methods for generating custom reports based on point-of-sale data
US7096220B1 (en) * 2000-05-24 2006-08-22 Reachforce, Inc. Web-based customer prospects harvester system
US6957248B2 (en) * 2000-07-31 2005-10-18 Pitney Bowes Inc. System and method for forwarding electronic messages
US6944662B2 (en) * 2000-08-04 2005-09-13 Vinestone Corporation System and methods providing automatic distributed data retrieval, analysis and reporting services
US6775691B1 (en) * 2000-08-31 2004-08-10 International Business Machines Corporation Server protocol for dead e-mail identification locator
US6829636B1 (en) * 2000-09-28 2004-12-07 International Business Machines Corporation Method and apparatus for controlling dead e-mail address scanning discovery, status retries, and other metrics to enforce e-mail quality of service
US6959324B1 (en) * 2000-09-28 2005-10-25 International Business Machines Corporation Method and apparatus for adding data attributes to e-mail messages to enhance the analysis of delivery failures
US6708205B2 (en) * 2001-02-15 2004-03-16 Suffix Mail, Inc. E-mail messaging system
US6732092B2 (en) * 2001-09-28 2004-05-04 Client Dynamics, Inc. Method and system for database queries and information delivery
US6816863B2 (en) * 2002-05-09 2004-11-09 International Business Machines Corporation Method, system, and computer product for providing a distribution list

Cited By (12)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070112726A1 (en) * 2002-10-24 2007-05-17 Allen Rick A Systems and methods for data retrieval, manipulation, and delivery
US7437369B2 (en) * 2002-10-24 2008-10-14 At&T Intellectual Property I, L.P. Systems and methods for data retrieval, manipulation, and delivery
US20080319991A1 (en) * 2007-01-08 2008-12-25 Lsr Technologies System for Searching Network Accessible Data Sets
US20100070493A1 (en) * 2007-01-08 2010-03-18 Lsr Technologies System for searching network accessible data sets
US8161064B2 (en) 2007-01-08 2012-04-17 Lsr Technologies System for searching network accessible data sets
US20080319944A1 (en) * 2007-06-22 2008-12-25 Microsoft Corporation User interfaces to perform multiple query searches
US20080319975A1 (en) * 2007-06-22 2008-12-25 Microsoft Corporation Exploratory Search Technique
US20090006324A1 (en) * 2007-06-27 2009-01-01 Microsoft Corporation Multiple monitor/multiple party searches
US20090006358A1 (en) * 2007-06-27 2009-01-01 Microsoft Corporation Search results
US20100106609A1 (en) * 2008-10-16 2010-04-29 Sherman Abe P Inventory analysis and merchandising system and method
US9792545B1 (en) 2009-05-08 2017-10-17 Abe P. Sherman Vendor-based inventory management system and method
CN109063057A (en) * 2018-07-20 2018-12-21 玖富金科控股集团有限责任公司 Data base query method, terminal, server, computer-readable medium and equipment

Also Published As

Publication number Publication date
US20070112726A1 (en) 2007-05-17
US7437369B2 (en) 2008-10-14
US20090037392A1 (en) 2009-02-05

Similar Documents

Publication Publication Date Title
US7437369B2 (en) Systems and methods for data retrieval, manipulation, and delivery
US6816868B1 (en) Database system
US6119126A (en) Object-relational query builder which determines existence of structures from information loaded from the server and cached locally on the client computing system
US7844618B2 (en) Techniques for managing interdependent data objects
EP1585036A2 (en) Management of parameterized database queries
US6418450B2 (en) Data warehouse programs architecture
US8140595B2 (en) Linked logical fields
US7593960B2 (en) System and method for least work publishing
US20040254939A1 (en) Singleton abstract model correspondence to multiple physical models
US8010530B2 (en) Presentation of multilingual metadata
RU2406115C2 (en) Accessing complex data
US20050044065A1 (en) Method and apparatus for enabling national language support of a database engine
WO2002027537A1 (en) System and method for in-context editing
US8527867B2 (en) Enabling users to edit very large XML data
US7765226B2 (en) Method of generating database transaction statements based on existing queries
KR20190087841A (en) A data input/output system using grid interface
CN107480262A (en) A kind of general management system of database based on webpage
WO2021008340A1 (en) Method and apparatus for generating financial data, computer device and storage medium
US7197696B1 (en) System, method and computer program product to populate data into spreadsheets and execute functions and programs within the same
CN101393549A (en) Method and system for modifying table element displaying attribute
US20070094289A1 (en) Dynamic, hierarchical data exchange system
KR20180080423A (en) A database update system based on spreadsheet interface by finding out updated records automatically
US20010047362A1 (en) Automated web site publishing and design system
US20030229633A1 (en) Bean generated SQL for back-end management and configuration
JP2002366401A (en) Integral data mart structure, and operation supporting system

Legal Events

Date Code Title Description
AS Assignment

Owner name: BELLSOUTH INTELLECTUAL PROPERTY CORPORATION, DELAW

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:ALLEN, RICK A.;WRIGHT, ROBERT H.;WEITLAUF, WILLARD;REEL/FRAME:013428/0433;SIGNING DATES FROM 20021007 TO 20021020

STCF Information on status: patent grant

Free format text: PATENTED CASE

FPAY Fee payment

Year of fee payment: 4

REMI Maintenance fee reminder mailed
FEPP Fee payment procedure

Free format text: PAYER NUMBER DE-ASSIGNED (ORIGINAL EVENT CODE: RMPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

Free format text: PAYOR NUMBER ASSIGNED (ORIGINAL EVENT CODE: ASPN); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

AS Assignment

Owner name: AT&T INTELLECTUAL PROPERTY I, L.P., GEORGIA

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:AT&T DELAWARE INTELLECTUAL PROPERTY, INC.;REEL/FRAME:034507/0493

Effective date: 20141208

Owner name: AT&T DELAWARE INTELLECTUAL PROPERTY, INC., DELAWAR

Free format text: CHANGE OF NAME;ASSIGNOR:AT&T BLS INTELLECTUAL PROPERTY, INC.;REEL/FRAME:034632/0780

Effective date: 20071101

Owner name: AT&T INTELLECTUAL PROPERTY, INC., TEXAS

Free format text: CHANGE OF NAME;ASSIGNOR:BELLSOUTH INTELLECTUAL PROPERTY CORPORATION;REEL/FRAME:034632/0485

Effective date: 20070427

Owner name: AT&T BLS INTELLECTUAL PROPERTY, INC., DELAWARE

Free format text: CHANGE OF NAME;ASSIGNOR:AT&T INTELLECTUAL PROPERTY, INC.;REEL/FRAME:034632/0716

Effective date: 20070727

FPAY Fee payment

Year of fee payment: 8

SULP Surcharge for late payment

Year of fee payment: 7

AS Assignment

Owner name: RAKUTEN, INC., JAPAN

Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNOR:AT&T INTELLECTUAL PROPERTY I, L.P.;REEL/FRAME:034765/0147

Effective date: 20141215

MAFP Maintenance fee payment

Free format text: PAYMENT OF MAINTENANCE FEE, 12TH YEAR, LARGE ENTITY (ORIGINAL EVENT CODE: M1553); ENTITY STATUS OF PATENT OWNER: LARGE ENTITY

Year of fee payment: 12

AS Assignment

Owner name: RAKUTEN GROUP, INC., JAPAN

Free format text: CHANGE OF NAME;ASSIGNOR:RAKUTEN, INC.;REEL/FRAME:058314/0657

Effective date: 20210901