Abstract: A method and system to dynamically associate a workstation with a teleset. Data related to the call are transferred to the workstation during the call. Forming the dynamic association between the workstation and the teleset can include determining a hostname for the workstation, searching for the hostname in configuration data, and, if the hostname is found, dynamically associating the workstation with a teleset associated with the hostname. A server can be notified to transfer data associated with a call on the teleset to the workstation.

Abstract: Techniques to generate data models for an item master having a number of items. Each item is associated with a number of attributes and each attribute is associated with a set of values. In one method, the items in the item master are initially classified into a number of pagesets, with each pageset being defined by a unique combination of values for a first set of (classification) attributes. For each pageset, a second set of (selectable) attributes is determined to uniquely identify the items in the pageset. The selectable attributes may be selected from a list of candidate attributes, which may include mandatory attributes designated to be used as selectable attributes and optional attributes that may be selected for use. Data models are generated for each pageset based in part on the selectable attributes, and include a set of tables descriptive of the items in the pageset.

Abstract: A facility for performing a distinct count metric by utilizing aggregate navigation is provided. For a distinct count query of an identifier of a detail table, where the query specifies zero or more restrictions, the facility identifies an aggregate table that is associated with the detail table. The facility then determines whether the aggregate table contains the identifier that is being distinct counted, and if so, further determines whether the identifier is different in every row of the aggregate table. If it is, then the facility performs a count operation on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query. If the identifier is not different in every row of the aggregate table, the facility performs a distinct count operation on the rows of the aggregate table that satisfy the specified restrictions to obtain a result for the distinct count query.

Abstract: A method and system for accessing and display of data records from large data sets. The method includes defining a plurality of boundaries to logically partition the large data set into a plurality of buckets in accordance with a predefined sort order. The sort order is based on data stored in at least two columns of a database table in which at least a base portion of each data record is stored. In response to a request to retrieve a data record or group of related records, such as all contacts having a given first and last name, a determination is made to which bucket the data record or at least a portion of group of related records are stored in. A query is then formulated to retrieve a subset of the large set of records from the database corresponding to data records contained in the bucket.

Abstract: According to one aspect of the present invention, a method is provided in which a first field and a second field of a data record are displayed to a user using a client program, the second field having one or more attributes that are dependent upon the value of the first field. In response to a detection that the value of the first field has changed, the value of the first field is sent to a server program. The server program is configured to process the change in value of the first field and determine corresponding changes with respect to the one or more attributes of the second field. The corresponding changes with respect to the one or more attributes of the second field are sent from the server program to the client program.

Abstract: A method and system for enabling display of real-time clinical trial enrollment data. A set of computer forms corresponding to an application enable administrative personnel to define a plurality of clinical trial parameters, including trial protocols, clinical sites, and optional regions. As the data is entered, it is stored in a central database, typically through a dedicated connection between a client running the application and the database. Software and infrastructure for supporting an Internet web portal is also provided, whereby the web portal enables clinical site personnel to enter subject enrollment data that is stored in the database as it is entered (i.e., in real-time). Various charts pertaining to the subject enrollment data may then be generated, including subject status charts and subject enrollment rate charts. In general, the charts may be aggregated across individual sites, regions, and all sites corresponding to a given protocol.

Abstract: According to one aspect of the present invention, a system is provided to support a web-based application. The system comprising a set of server-side objects managed by an object manager (OM), the set of server-side objects including a global session object providing access to a repository, a server-side business object, and server-side business components contained in the server-side business object. The system further comprises a set of browser-side objects running on a browser, the set of browser-side objects including a browser-side application object that exists throughout a user-session to manage other browser-side objects. The system also comprises a remote procedure call (RPC) mechanism and a notification mechanism to facilitate communication and synchronization between the browser-side objects and the server-side objects.

Abstract: A method, a program product, and a system for assigning resources to tasks in a rule based, resource constrained system. This is done by receiving as inputs tasks and task attributes; resources and resource attributes; and assignment rules. These inputs are used to searching a database of tasks, task attributes, and assignment rules thereof, to search a database of resources including resource attributes thereof, and to retrieve resources based upon the resource attributes. Resources are assigned to tasks based upon matches and scores of the resource attributes, the task attributes, and the assignment rules.

Abstract: A method, a program product, and a system for assigning resources to tasks in a rule based, resource constrained system. This is done by receiving as inputs tasks and task attributes; resources and resource attributes; and assignment rules. These inputs are used to searching a database of tasks, task attributes, and assignment rules thereof, to search a database of resources including resource attributes thereof, and to retrieve resources based upon the resource attributes. Resources are assigned to tasks based upon matches and scores of the resource attributes, the task attributes, and the assignment rules.

Abstract: The A method and system for server synchronization with a computing device via a companion device is disclosed. In one embodiment, the method comprises synchronizing a device and an enterprise server via a companion device, which comprises retrieving a record extraction sequence from the server; providing the record extraction sequence to the handheld device from the companion device; and extracting records stored on a database according to the record extraction sequence, wherein the extracted records are not already stored on the computing device.

Abstract: The invention provides user configurable and reconfigurable scripting, methods of scripting, and systems for scripting for use by call centers, technical support centers, and marketers. Scripts are interactive tools that guide a telemarketer, a sales person, or a technical support technician through a telephone call with a customer. Scripts are characterized by going on to particular subsequent questions as a function of the customer's answer to a previous question.

Abstract: A system and method for providing access to CRM data via a voice interface. In one embodiment, the system includes a voice recognition unit and a speech processing server that work together to enable users to interact with the system using voice commands guided by navigation context sensitive voice prompts, and provide user-requested data in a verbalized format back to the users. Digitized voice waveform data are processed to determine the voice commands of the user. The system also uses a “grammar” that enables users to retrieve data using intuitive natural language speech queries. In response to such a query, a corresponding data query is generated by the system to retrieve one or more data sets corresponding to the query. The user is then enabled to browse the data that are returned through voice command navigation, wherein the system “reads” the data back to the user using text-to-speech (TTS) conversion.

Abstract: According to one aspect of the present invention, a method includes displaying a search center pane after a user selects a search icon from a search tool bar to begin a user session. The search center pane includes a search frame. The search frame includes a close button. The method also includes selecting a search category from a dropdown list of search categories in the search frame. The method further includes entering a search keyword. In addition, the method includes searching a database for data records matching the search category and the search keyword. Furthermore, the method includes caching the data records matching the search category and the search keyword to maintain persistency of the data records until the user selects the close button to terminate the user session.

Abstract: According to one aspect of the present mechanism, a method is provided in which a search request containing search criteria is received from a first user. A search is performed based on the search criteria to retrieve records in one or more databases that match the search criteria. A list of search results based on the retrieved records is displayed to the first user. In response to the first user's request to associate a particular search result in the list to a particular object, associate the particular search result to the particular object.

Abstract: A method of and system for collecting, storing, and retrieving data in a data base management system. The database management system includes a master database server (4), at least one workgroup server (315), and a plurality of workgroup user clients (310). The workgroup server (315) is interposed between the master database server (4) and said workgroup user clients (310). The method creating a transaction in a local database resident on one of the workgroup user clients (310), entering the transaction into a transaction log resident on the workgroup user client (310), and creating a transaction file corresponding to the transaction in an outbox of said workgroup user client (310). Next, the transaction file is copied to an inbox identified to the workgroup user client (310) and updating the transaction file into a workgroup database (305) resident on the workgroup server (315). The workgroup database (305) includes a transaction log.

Abstract: Attaching files and other objects in a distributed computing environment. This includes adding file attachments and non-database objects, such as, text file data, web file data, image file data, and other file attachment objects to databases. These objects may be retrieved at the convenience of a node to which the objects are sent. Visibility rules can be set to determine which attachments and objects are seen by a node. Distribution rules for an object determine whether a node must request the object or whether the node is forced to receive the object.

Abstract: Method and system for determination and granting of access to data and files by the file or database creator, owner or manager or by group or user access profiles. The database is partitionable among data owners, and access is awarded based upon the requestor's organizational attributes.

Abstract: A method to convert data between a relational format and an XML document, by creating a set of XML Mapping Definition from metadata; selecting relational data from a relational application database, and converting the relational data to the XML document using the set of XML Mapping Definition.

Abstract: According to one aspect of the present invention, a method includes displaying a search tool bar including a search icon. The method also includes displaying a search center pane after a user selects the search icon, wherein the search center pane includes a search frame. The method further includes selecting a search category from a dropdown list of search categories in the search frame. In addition, the method includes entering a search keyword. Furthermore, the method includes searching a database for data records matching the search category and the search keyword.

Abstract: Techniques for managing multiple threads in an asynchronous environment, such as a browser, are described. As a method, instantiating an event thread in response to a user event by a shell event handler block that provides shell functions for a user event. Once the event thread as been instantiated, managing the event thread by a generic thread manager block that provides a plurality of multithread management functions for the shell event handler. When required, blocking and unblocking the event thread by a blocking system that is arranged to block and unblock threads.