Abstract: A graphical user interface allows performing operations simply by dragging a first object over a second object. One or more attributes of the second object are effectively “picked up” by virtue of dragging over the second object. In this manner, the user interface is more friendly, more intuitive, and reduces the number of pointer clicks to implement a particular function, thereby enhancing the efficiency of the user.

Abstract: A method, apparatus and program product initiate generation of a metafile at a client computer. The metafile is evaluated at a network server for a potential viral risk. Program code executing at the server may correlate the evaluated potential risk to a risk level stored in a database. The program code may attach a color designator or other assignment indicative of the assessed risk level to the data. A user at the client computer may act on the data based on the attached risk level.

Abstract: An apparatus and method for a graphical user interface allow performing operations simply by dragging a first object to touch a second object. The selection of the first object places a corresponding first object in a chain of objects. When the selected first object touches a second object, a corresponding second object is added to the chain of objects. This process may continue for the selection of many objects by merely touching each object with the selected first object, which causes a corresponding object to be added to the chain of objects. The chain of objects may then be processed as an atomic group of operations that may be rolled back if any of the operations in the group fail.

Abstract: A database optimizer collects statistics regarding applications accessing a 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. In a second embodiment, the optimizer detects when one type of application accesses a column a percentage of time that exceeds a first predefined threshold level and is less than a second predefined threshold level, and creates a new column in the database so the data is present in both formats.

Abstract: A graphical query interface provides visual feedback to a user during the construction of a query. In a first embodiment, the visual feedback helps the user determine the quality of the query as the query is being built. The relationship of columns in the database is graphically displayed to a user. When the user selects a column in the database, a filtered display mechanism displays only those columns or records that satisfy the portion of the query already constructed. In a second embodiment, the visual feedback eliminates some possible selections in the query tree due to previously-made selections that eliminate the eliminated selections as possibilities. In the second embodiment, the visual feedback mechanism may function according to data values in columns, and may also function according to known relationships between columns themselves.

Abstract: Embodiments of the invention are generally related to data processing, and more specifically to processing data retrieved from a database. A GUI screen displaying query results may provide for the selection of a data standard to be applied to the query results. An analysis routine may identify specific results that comport with a selected data standard and visually identify the specific query results that comport with the selected data standard.

Abstract: Data standards are defined for data according to various criteria. A data standard may be selected for an abstract query, wherein the data standard identifies a quality of data. A query may be generated based on the abstract query and the selected data standard, wherein the query is configured to retrieve results of the abstract query that are in accordance with the selected data standard.

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: An apparatus and method define the concept of a “database breakpoint.” One or more conditions in the database are specified as a database breakpoint in a debug environment for debugging a computer program that accesses the database. When the database conditions exist, one or more debug functions may be performed with respect to the execution of the computer program. Examples of debug functions include halting execution of the computer program and halting operations to the database by other programs. With both the computer program and database halted, the user may then interrogate the database to determine its state, and may interrogate the program to determine its state. Database breakpoints greatly enhance the utility of a debugger by providing additional conditions for debugging a computer program that accesses a database.

Abstract: An apparatus, program product and method dynamically optimize prepared statements resident in a statement pool to permit subsequent reuses of such statements to utilize the optimized representations of such statements. The optimization of pooled statements may be performed responsive to the tracked usage of the statements in a statement pool, to direct the overhead associated with such optimization to those statements that are more likely to be utilized in the future. Among a multitude of possible optimizations, a pooled statement that requests data in a format other than that utilized by the database being accessed may be modified to request the data in the format used by the database, thereby decreasing the overhead in the database associated with format conversions.

Abstract: An instant messaging system having logic for managing IM messages and an intelligent queuing mechanism. One aspect of the present invention is a method for selectively filtering instant messages, comprising receiving an instant message and analyzing the instant message to generate a priority score. Another aspect of the present invention is a graphical user interface for an instant messaging application, comprising at least one visible conversation pane for displaying relatively higher priority conversations, and at least one minimized conversation pane representing relatively lower priority conversations to the at least one minimized conversation panel.

Abstract: An apparatus, program product and method effectively merge computer documentation for multiple API sets together to facilitate user access to such computer documentation. Such merging of computer documentation may include, in part, the incorporation, into a navigation file, of a plurality of API set links associated with a plurality of API sets, as well as the incorporation, into an index file, of a plurality of index links to documentation files for at least two of the plurality of API sets. Furthermore, computer documentation may be displayed to a user by displaying selected information in a plurality of display regions of a computer display. In a first display region, at least a portion of a first navigation file may be displayed, with the first navigation file including a plurality of API set links associated with a plurality of API sets.

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 database operation mechanism includes the capability of specifying a predefined database operation as a source of data for a different database operation. When the different database operation needs to be performed, the database operation mechanism determines whether the different database operation can use a predefined database operation as a data source. If so, the predefined database operation is specified as the source of data for the different database operation. If the different database operation cannot use a predefined database operation as a data source, the database operation mechanism determines whether the different database operation can use a modified form of a predefined database operation as a data source. If so, the different database operation may use the modified predefined database operation as a source of 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 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: 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: A method, system and article of manufacture for generating a logical field specification for a logical field associated with a physical entity of data in a computer system, the physical entity of data having a particular physical data representation, the method comprising: providing a logical field specification template comprising a plurality of specification sub-fields, each specification sub-field designated by a sub-field descriptor; accessing the physical entity of data to determine data items associated with the sub-field descriptors; and linking each specification sub-field to a corresponding determined data item.

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: 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.