The invention relates to data entry operations. More specifically, the invention relates to features to improve efficiency of searching operations.
Many business processes involve data entry operations at one or more points. Consider, for example, a supply chain involving several businesses that cooperate to transform raw materials into a finished product. Each business may track its own inventory, order supplies from an upstream partner, and send goods to a downstream customer. The number and complexity of records processing systems may be proportional to the number and quantity of products handled, the number of suppliers and the number of customers. Accurate, timely data may be critical to the efficient operation of each business.
Data entry may be considered an unskilled or low-skilled task, but the fast and accurate performance of that task may be enormously valuable. Systems and methods to streamline data entry tasks—which may include operations beyond straightforward typing or scanning of information into a database—can contribute significantly to a business's bottom line.
Embodiments of the invention provide configurable search parameter facilities to speed certain data retrieval operations. Search parameters may be saved in various classes so that the most relevant preconfigured searches are readily available to the users who need them.
Embodiments of the invention are illustrated by way of example and not by way of limitation in the figures of the accompanying drawings in which like references indicate similar elements. It should be noted that references to “an” or “one” embodiment in this disclosure are not necessarily to the same embodiment, and such references mean “at least one.”
Other fields in a data entry screen may depend on information in the database in a more complex way. For example, a “delivery” field 107 for an item may be based on information from warehouse stock records, or even on supply, production backlog, and pre-existing orders records. A detailed search may be helpful to locate valid information to fill in such a field.
Embodiments of the invention provide controls to permit a user to perform searches quickly. For example, contact field 103 may display an icon 110 that the user can activate to execute a search and display results which are valid entries for the field in a subordinate or “pop-up” window 120. If one of the results is selected, the system can place its value in the contact field. For fields with more complex search parameters, activating the icon 130 may generate a “dialog” window 140 to display (and perhaps to permit adjustment of) a preconfigured set of parameters before performing the search. A control 150 may activate a list 160 of preconfigured searches (shown here as identified by various names) from which the user can select. The list may include a group of preconfigured searches available to all users 162, a group of searches available only to a single user 165, and/or a generic search without preconfigured parameters 168.
A data-entry system operating according to an embodiment of the invention may proceed as described with reference to the flow chart of
Note that each field of a data entry screen may be associated with a different search. Searches executed to assist in data entry, as described above, may incorporate information from other fields of a screen (or elsewhere) to produce a useful set of results for a field associated with the search. Thus, the results of these searches are different from a preconfigured set of values that may be associated with the form or data entry screen itself. For example, search icon 110 in “Contact” field 103 mentioned in the description of
Clerks in different offices or branches of a company may find different preconfigured searches to be useful. For example, clerks who deal mainly with records pertaining to European customers may find a search for telephone country codes useful, while clerks who deal with American customers may not need country codes, but may use a state-to-area-code search instead. Therefore, in some embodiments, preconfigured search parameters may differ between company branches, business units, or other subdivisions or groups of users. Similarly, a clerk who deals with a limited range of customers or products may find that an automated search, preconfigured to return only values from the limited range, may improve his efficiency significantly. Accordingly, some embodiments may permit preconfigured searches on a per-user basis.
The search preparer makes entries in one or more of the search parameter fields (310). In one embodiment, the preparer can lock certain fields or mark them hidden, so that a user cannot later alter those portions of the search before executing the search. If all the fields are locked or hidden, then the search may be executed directly when a user activates it, instead of presenting the parameters and allowing modifications.
Next, the preparer selects a storage class (320) to indicate whether the preconfigured search is to be available only to one user (perhaps the preparer himself), to users in a certain group, or to all users. The system stores the search parameters (and any “lock” information) in a database or other storage facility as a preconfigured search (330). The search may be associated with a descriptive name or other identifier to assist users in selecting appropriate parameter sets. Some systems may implement a permission or privilege scheme so that only a limited number of users can create preconfigured search settings that are visible to groups of users or to all users.
In one embodiment, a generic prior-art search parameter entry screen may be augmented with a button, selector or other control to permit the currently-configured search to be saved. Alternatively, a search results display screen may be provided with such a button, selector or other control, so that search parameters can be adjusted while performing repeated searches, and saved when the desired results are obtained. Thus, the search facilities of an existing system may be extended with an embodiment of the invention relatively easily.
A search using the current parameter settings can be executed immediately with the “Search” button (470), or the parameters can be saved for the benefit of future users with the “Save As” button (480). Saving the current parameters may lead to a dialog 490 that prompts the operator to specify a name for the search (492) and to select a storage class (494). In this example, the “All Users” choice (496) is unavailable because the operator preparing the search lacks appropriate privileges to make the search so widely available. The preconfigured search parameters can be saved with the “Save” button 498.
As mentioned above, a configurable search facility can be added to an existing search and data entry system relatively easily. In fact, in a carefully architected system, large portions of the existing search facilities will share software codes, and so most or all search instances can be upgraded simultaneously by adding the new functionality to the basic modules.
Systems will often be built upon a database facility 510. Databases that implement the Structured Query Language (“SQL”) are widely used in this role, although other database technologies can also support embodiments of the invention. Atop the database layer are basic system facilities such as system administration 520, reporting 530, data entry 540 and searching 550. The basic search facilities can usefully be extended with preconfigured searches 555 as disclosed herein.
The foundation consisting generally of the logical blocks discussed above can support a variety of vertical applications. This figure shows some elements of one such application, supply chain management (“SCM”). An SCM application collects and integrates data from various aspects of a business's operation and provides methods to analyze the data to understand the current situation, to forecast, and to compare competing options. Data entry 540 may include collection of information relating to supply of input materials 542, demand for processed goods 544, production or manufacturing status 546, and logistics 548 (what items are where). Reporting 530 may deliver raw or derivative information from the database to answer questions about suppliers 532, customers 534, accounts 536 and finances 538. Search facilities 550 may support data entry 540 by locating information necessary to complete various data entry forms, as discussed in relation to
An embodiment of the invention may be a machine-readable medium having stored thereon instructions which cause a processor to perform operations as described above. In other embodiments, the operations might be performed by specific hardware components that contain hardwired logic. Those operations might alternatively be performed by any combination of programmed computer components and custom hardware components.
A machine-readable medium may include any mechanism for storing or transmitting information in a form readable by a machine (e.g., a computer), including but not limited to Compact Disc Read-Only Memory (“CD-ROM”), Read-Only Memory (“ROM”), Random Access Memory (“RAM”), Electrically Erasable Programmable Read-Only Memory (“EEPROM”), and a memory device that permits transmission over the Internet.
One embodiment of the invention includes the machine-readable medium described above and a machine to read and execute the instructions. Such a machine may be a general- or special purpose computing system including one or more processors, memory, a mass storage device, input and output devices, and optionally a communication facility to exchange data with other cooperating systems.
The applications of the present invention have been described largely by reference to specific examples and in terms of particular allocations of functionality to certain hardware and/or software components. However, those of skill in the art will recognize that preconfigured search parameter preparation and use can also be achieved by software and hardware that distribute the functions of embodiments of this invention differently than herein described. Such variations and implementations are understood to be captured according to the following claims.