A portion of the disclosure of this patent document contains material which is subject to copyright protection. The copyright owner has no objection to the facsimile reproduction by anyone of the patent document or the patent disclosure as it appears in the Patent and Trademark Office patent file or records, but otherwise reserves all copyright rights whatsoever.
1. Field of the Invention
The present invention relates to databases and, more particularly, to database programs capable of accessing databases.
2. Description of the Related Art
Databases are used to store data in a manner that facilitates subsequent use of the data. A database includes one or more files, each of which contain one or more records. A record holds information about a subject or item in its various fields.
To allow a user to more easily access and manage data stored in databases, database programs have recently been developed. Database programs, among other things, often provide a user interface which allows the user to conveniently interact with the database program. By interacting with the user interface, the user of the database can perform various operations on the data stored in the database. The interface provided by the database program is typically a Graphical User Interface which allows the user to conveniently interact with the database program and, in turn, with the database. The user may interact with the graphical user interface to, for example, view the data in various ways. The visual representations provided to the user can include, for example, a browse mode. The browse mode allows records to be viewed, changed, sorted, deleted, or added.
Accordingly, a database program provides the user with the ability to conveniently access databases. Unfortunately, however, conventional database programs typically require a desktop computer to operate. In some cases, handheld devices (e.g., remote wireless phones) can be used to access a database, but this typically requires some programming (e.g., writing scripts). Furthermore, another problem is that the conventional techniques typically require the user to switch between different modes to perform everyday tasks. For example, the user may use a remote wireless phone to find a phone number stored in a database, but there is no convenient way for the user to place a call to that phone number. Typically, the user has to write down the phone number and switch to the phone mode before the call can be placed.
In view of the foregoing, there is a need for database programs which can operate on handheld devices.
Broadly speaking, the invention relates to techniques for providing access to databases from handheld devices. In accordance with one aspect of the invention, a database system is disclosed. The database system provides a graphical user interface which is displayed on handheld devices. This allows users of handheld devices to conveniently by interacting with the graphical user interface. As will be appreciated, the user can access the database to perform a variety of operations. Moreover, the user can perform these operations without having to write programs and virtually in real time. Thus, the user can conveniently access the database and be provided with up-to-date information. In addition, the user can be provided with hyperlinks which allow the user to conveniently perform various tasks without having to switch between different operation modes.
The invention can be implemented in numerous ways, including as a method, an apparatus, a computer readable medium, and a database system. Several embodiments of the invention are discussed below.
As a database program one embodiment of the invention is capable of accessing at least one database capable of having one or more records stored therein; and communicating with a handheld device. This allows the at least one database to be accessed from the handheld device through the database program.
As a method for providing a handheld device with access to a database, one embodiment of the invention includes the acts of: receiving a request from a handheld device to access a database capable of having one or more records stored therein; determining whether the request should be granted; accessing the database when it is determined that the request should be granted; and displaying information relating to the database on the handheld device.
As a database system, one embodiment of the invention includes: a database capable of having one or more records stored therein; a database program capable of accessing the database; and an interface capable of communicating with a handheld device and the database program, thereby allowing the handheld device to access the database.
As a computer readable medium, one embodiment of the invention includes computer program code for a database system. The database system includes a database capable of having one or more records stored therein; a database program capable of accessing the database; and an interface capable of communicating with a handheld device and the database program, thereby allowing the handheld device to access the database.
The advantages of the invention are numerous. Different embodiments or implementations may yield one or more of the following advantages. One advantage of the invention is that database operations can conveniently be performed using a handheld device by interacting with a graphical user interface which is displayed on the handheld device. Another advantage of the invention is that the user can perform various tasks without having to switch between different operational modes. Still another advantage is that the invention can be implemented to operate using existing database programs and conventions. Yet another advantage of the invention is that users of handheld devices can be provided with up-to-date database information.
Other aspects and advantages of the invention will become apparent from the following detailed description, taken in conjunction with the accompanying drawings, illustrating by way of example the principles of the invention.
The present invention will be readily understood by the following detailed description in conjunction with the accompanying drawings, wherein like reference numerals designate like structural elements, and in which:
As noted in the background of the invention, there is a need for database programs which can provide users of handheld devices with the ability to access data from a database. Accordingly, the invention pertains to techniques for providing access to databases from handheld devices. In accordance with one aspect of the invention, a database system is disclosed. The database system provides a graphical user interface which is displayed on handheld devices. This allows users of handheld devices to conveniently by interacting with the graphical user interface. As will be appreciated, the user can access the database to perform a variety of operations. Moreover, the user can perform these operations without having to write programs and virtually in real time. Thus, the user can conveniently access the database and be provided with up-to-date information. In addition, the user can be provided with hyperlinks which allow the user to conveniently perform various tasks without having to switch between different operation modes.
Embodiments of these aspects of the invention are discussed below with reference to
Moreover, the remote handheld device 204 can also access the database 206. Typically, the remote handheld device 204 uses the remote interface 210 in order to access the database program 208. The database program 208 can, in turn, access the database 206 and relay information back to the remote interface 210 which can pass the information back to the remote handheld device 204. It should be noted that the remote handheld device 204 can, for example, be a wireless phone which uses a telecom server to communicate with the database program 208. The telecom server can, for example, use an HTTP protocol while the wireless phone is an “imode” compatible device.
The database program 208 and/or remote interface 210, for example, can be running on a server. The remote interface 210, among other things, can convert the data it receives from the database program 208. The data can be converted (e.g., compacted) and then presented to the remote handheld device 204 for display. As will be appreciated, the user can conveniently access data by interacting with a graphical user interface which is presented to the user on a display 214 of the remote handheld device 204. Inputs 216 and 218 are provided to allow the user to interact with the graphical user interface. As will be appreciated, the user can access the database without having to write programming code (e.g., scripts).
If it is determined at operation 304 that a request to access the database has not been received, the method 304 proceeds to operation 306 where it is determined whether a request to end display of the graphical user interface had been received. If it is determined at operation 306 that a request to end the display of the graphical user interface has been received, the method 300 ends. However, if it is determined at operation 306 that a request to end the display of the graphical user interface has not been received, the method 300 proceeds to operation 304 where it is determined whether a request to access the database has been received.
On the other hand, if it is determined at operation 304 that a request to access the database has been received, the method 300 proceeds to operation 308, where a determination is made as to whether the request to access the database should be granted. If it is determined at operation 308 that the request should not be granted, the method 300 proceeds to operation 306 where it is determined whether a request to end the display of the graphical user interface has been received. However, if it is determined at operation 308 that the request to access the database should be granted, the method 300 proceeds to operation 310 where the database is accessed.
Next, at operation 312, information relating to the database is generated in a format which is appropriate for the handheld device. As will be appreciated, the information can, for example, be compacted in a compact HTML and the like. In any case, at operation 314, the information relating to the database is displayed on the handheld device. Thereafter, the method 300 proceeds to operation 316 where it is determined whether a request to end the display of the graphical user interface has been received. If it is determined at operation 316 that a request to end the display of the graphical user interface has not been received, the method 300 proceeds to operation 304 where it is determined whether a request to access the database has been received. However, if it is determined at operation 316 that a request to end the display of the graphical user interface has been received, the method 300 ends.
From the list view option 408, the user can select a “form view” option 411 which, among other things, provides the user with hypertext links (e.g., URLs, phone numbers, etc.). As will be appreciated, the user can conveniently use these hyperlinks to perform a variety of tasks (e.g., access a website, send an email, make a phone call, etc.). In addition, from the form view option 411 the user can use the functions of “edit” 412, “delete” 414, “duplicate” 416, “new” 410 and “find” 420 to perform a variety of tasks on records stored in a database. These options can be implemented to perform similar tasks as those provided by a database program which operates on a desktop computer (e.g., database program 208 of
As noted above, the main page 402 of
If it is determined at operation 604 that a database has been selected, the method 600 proceeds to operation 607 where a database homepage is selected for the database. Next, at operation 608, it is determined which functions should be made available for (i.e., are applicable to) the selected database. Thereafter, at operation 610, a database homepage with only those functionalities that were determined to be applicable to the database is displayed. The method 600 ends following operation 610.
As noted above, a graphical user interface can be implemented for handheld devices which provide a list option view (e.g., the list option 408 of
Furthermore, the graphical user interface can provide the user of the handheld device with the ability to view a particular record in the database (e.g., form view option 411 of
As will be appreciated by those skilled in the art, the invention can be implemented to provide similar functions as provided by database programs which operate on desktop computers. By way of example, the “find” option 406 of
Similarly, other operations (e.g., edit, delete, duplicate, new, etc.) can provide similar functions as provided by database programs which operate on desktop computers. It should be noted that the invention can be implemented to provide the user with virtually real time access to a database. This means that the user can be provided with information that is up-to-date. By way of example, after a request to create or update a record has been made from a handheld device, the database can be updated immediately to reflect the change. As a result, the users can be provided with up-to-date information.
The invention can use a combination of hardware and software components. The software can be embodied as computer readable code on a computer readable medium. The computer readable medium can be any data storage device that can store data which can thereafter be read by a computer system. Examples of computer readable medium include read-only memory, random-access memory, CD-ROMs, magnetic tape, and optical data storage devices. The computer readable media can also be distributed over a network-coupled computer system so that the code is stored and executed in a distributed fashion.
The advantages of the invention are numerous. Different embodiments or implementations may yield one or more of the following advantages. One advantage of the invention is that database operations can conveniently be performed using a handheld device by interacting with a graphical user interface which is displayed on the handheld device. Another advantage of the invention is that the user can perform various tasks without having to switch between different operational modes. Still another advantage is that the invention can be implemented to operate using existing database programs and conventions. Yet another advantage of the invention is that users of handheld devices can be provided with up-to-date database information.
The many features and advantages of the present invention are apparent from the written description, and thus, it is intended by the appended claims to cover all such features and advantages of the invention. Further, since numerous modifications and changes will readily occur to those skilled in the art, it is not desired to limit the invention to the exact construction and operation as illustrated and described. Hence, all suitable modifications and equivalents may be resorted to as falling within the scope of the invention.
This application claims the benefit of U.S. Provisional Application No. 60/355,731, filed Feb. 4, 2002, and entitled “DATABASE PROGRAMS FOR REMOTE DEVICES,” which is hereby incorporated by reference herein.
Number | Name | Date | Kind |
---|---|---|---|
6539237 | Sayers et al. | Mar 2003 | B1 |
6714778 | Nykanen et al. | Mar 2004 | B1 |
20020103908 | Rouse et al. | Aug 2002 | A1 |
Number | Date | Country | |
---|---|---|---|
60355731 | Feb 2002 | US |