Abstract: A code optimizer is used to optimize a computer program that references a database by determining the characteristics of the database and making suitable optimizations based on the characteristics of the database. By taking into account the characteristics of a database referenced in the computer program, the optimizer may make suitable optimizations to the computer program. Such optimizations include, without limitation, removing unnecessary calls to the database, removing unnecessary loops, removing unnecessary database operations, providing compile-time errors, and replacing dynamic calls with static data.

Abstract: A query processor caches data retrieved from executing prepared statements, and uses the cached data for subsequent accesses to the data, if certain conditions for using the cached data are met. The preferred embodiments also include a data staleness handler that takes care of issues that arise from data that may have changed in the database but is not reflected in the cache. One way to handle data staleness in the cache is to specifically enable or disable caching in a query. If caching is disabled, the query processor will access the data in the database. Another way to handle data staleness in the cache is to provide a timer that causes the cache to be invalidated when the timer times out. Yet another way to handle data staleness in the cache is to provide specified conditions that must be met for caching to occur, such as time or date limitations. Still another way to handle data staleness in the cache is to provide an update trigger for the data in the database that corresponds to the cached data.

Abstract: An apparatus, program product and method utilize one or more usage statistics, which are reflective of what data is actually and/or likely to be used by a client when processing a database query, to reduce or eliminate the transfer of unnecessary data between a client and server in a client-server database management system. Information such as the columns that are or have been used and/or the number of rows that have been accessed, may be utilized to identify certain data that is likely to not be used during processing of the database query. Based upon the data that has been identified, a subset of the data that would otherwise be returned as a result of the database query may be identified and returned to a client, often substantially reducing the amount of data required to be retrieved by a client in connection with a database query.

Abstract: A client-server computing system suited particularly for homogenous clients of varying functional capabilities. Information handling capabilities are provided at the client and server on a customized, as-needed basis. When a service is needed by a client, the server determines a number of factors that may be relevant to the manner in which the service is to be provided. Then, the server selects from between two or more services having different executable code, and uploads the selected service to the client. Thus, the code may be tailored to the client's capabilities, or other aspects of its function. Services are not permanently retained by a client; rather, the client performs an analysis to determine whether services should be retained or purged. Also, state information is not permanently retained by a client; the server retains the information and uploads that information to the client. The server also manages its resources by loading service components on an as-needed basis.

Abstract: The present invention generally is directed to a system, method and article of manufacture for accessing data independent of the particular manner in which the data is physically represented. In one embodiment, a data repository abstraction layer provides a logical view of the underlying data repository that is independent of the particular manner of data representation. A query abstraction layer is also provided and is based on the data repository abstraction layer. A runtime component performs translation of an abstract query into a form that can be used against a particular physical data representation.

Abstract: The present invention is directed to a method and apparatus of providing programming assistance for an integrated development environment. In one embodiment, a code portion is received. An attempt to retrieve a structured query language (SQL) statement that corresponds with the line code is then made. A recommendation based on the code portion for restructuring the corresponding SQL statement is then generated. The recommendation may include a modified SQL statement, referred to as a recommended SQL statement or a textual spoken language recommendation.

Abstract: The present invention generally provides methods, systems and articles of manufacture for programmatically providing a user interface for creating queries. In one embodiment, the graphical user interface comprises (i) a region for displaying conditions of a user-defined query; and (ii) a graphical element for initiating a process of applying an event profile to a first condition of the query, whereby results returned by execution of the query are restricted to those for which the first condition and a second condition defined by the event profile are contemporaneously true.

Abstract: The present invention generally provides methods, systems and articles of manufacture for programmatically providing a user interface for creating queries. In one embodiment, graphical user interface content which defines a graphical user interface is provided. The graphical user interface comprises (i) a region for displaying conditions of a query; and (ii) a first graphical element for initiating a process of combining two or more conditions of the query together with logic values to form a complex condition. In another embodiment, the graphical user interface further comprises a second graphical element for initiating a process of separating two or more conditions of a complex condition.

Abstract: A database optimizer collects statistics regarding which types of applications are accessing the database, and makes one or more changes to the database schema to optimize performance according to the collected statistics. In a first embodiment, the optimizer detects when a certain type of application accesses the database a percentage of time that exceeds a predefined threshold level, and if the data in the database is stored in a less-than-optimal format for the application, the data type of one or more columns in the database is changed to a more optimal format for the application. This means that the database optimizer must recognize when a different type of application requests data from any changed column, and must potentially perform a conversion from the new data type to the old data type before returning the requested data.

Abstract: Cellular telephones, pagers, PDAs, and other wireless devices, are configured to modify their auditory response based on a schedule. A first device having a scheduling program may network with and modify the auditory response of a second device based upon a schedule set by the user. Also, a wireless device that has a scheduling program may modify its own auditory response based upon a schedule set by the user. Thus, for example, a user of a combined PDA/telephone may schedule a partial or total disablement of the telephone during a meeting, to reduce interruptions of group events.

Abstract: The present invention generally is directed to an alarm device that includes a network interface configured to receive an alarm control signal, an alarm interface for issuing an alarm to a target, and a processing unit which, upon receiving the alarm control signal, executes alarm issuing instructions causing the alarm interface to issue the alarm. The processing unit is configured to execute the alarm issuing instructions only after a presence of the target is detected proximate to the alarm device.

Abstract: A server which service multiple clients according to a defined interface selectively determines whether to by-pass at least some error checks of client requests. Preferably, the client server interface uses a Java Database Connectivity (JDBC) API, there being a set of error checks associated with each type of request. For at least some error checks, the server selectively by-passes error checking. In the exemplary embodiment, the server by-passes error checking of certain error conditions at the client's request. Alternatively, the server might selectively by-pass error checking on the basis of the client's identity, or current server performance, or on a random or intermittent basis.

Abstract: Methods and systems for message format distribution. A sending server is connected to a plurality of receiving servers. The sending server comprises a master database containing information which is periodically provided to the receiving servers. The sending server and the receiving servers communicate using messaging facilities. Changes in the message format are distributed by the sending server to the receiving servers via the messaging facilities. The message format changes are implemented by receiving clients executing on each of the receiving servers. Standard configurable receiving clients are used by all receiving servers, thereby reducing or eliminating development work by the receiving parties.

Abstract: The present invention provides methods and systems for database replication. In general, a source database management system is configured with an access manager. The access manager implements a replication schedule for replicating data to one or more client systems. Replication is performed for a particular client when the access manager determines that one or more threshold criteria have been satisfied.

Abstract: Methods, apparatus and articles of manufacture for determining the validity of words within a programming environment. In one embodiment, an operation of context-sensitive word validity checking in a programming environment is provided. The method comprises, in response to receiving user input information at an input location in the programming environment, determining a context of the input location; determining a validity of the user input information relative to the context; and outputting a visual indication of any invalid user input information.

Abstract: A method and system for predicting server database requests by a client. A database contains a plurality of command sets likely to be sent by a client to a server. The server compares statements received from the client with command sets stored in the database. If the server recognizes a pattern with a command set stored in the database, the server predicts that the client will send this command set and executes the statements contained therein.

Abstract: A client/server computer system having personalizable views of database data. The personalizable views programmed in client profiles which are customized for each client in the client/server computer system. The client/server computer system featuring a translator for converting client application database input and output requests into native database commands. The translator also supporting processing functions on data both retrieved from the database and stored to the database according to each individual client profile. The client/server computer system also supporting a hierarchy of preprogrammable group profiles which may be assigned to a group of clients. The client/server system also providing a security function for database data without modifying either the client applications executing on each client terminal or the native database.