摘要:
A portable phone is equipped with a position detector that detects the geographical position of the portable phone, and the function of the phone can be changed according to its geographical position. One or more “regions” may be defined by the user of the portable phone, and the ring parameters for each region may be set independently of the other regions. In this manner a phone in accordance with the preferred embodiments may ring with one tone at home, ring with a different tone at work, ring with a louder volume when on a job site, not ring at all when in church, and ring with a vibration when at the theater. The preferred embodiments further allow assigning a telephone number to a defined geographical region, and ringing the portable phone only when within the geographical region that corresponds to the phone number.
摘要:
A method, system and article of manufacture for query execution management in a data processing system and, more particularly, for managing execution of queries having one or more related query conditions. One embodiment provides a method for managing execution of a query against data of a database. The method comprises receiving a current query against the data of the database, the current query including a plurality of query conditions, for each query condition of the plurality of query conditions, determining whether a previously generated dynamic bitmap index can be re-used for the query condition of the current query, the dynamic bitmap index having been previously generated for a previous query condition associated with a previous query executed against the data of the database; and if the dynamic bitmap index has been generated for the previous query condition, retrieving the dynamic bitmap index, and determining a query result for the current query using all retrieved dynamic bitmap indexes.
摘要:
A method, apparatus and article of manufacture for data processing in data processing systems and, more particularly, for packaging and deploying enterprise information system resources using Java™ archive files. One embodiment for packaging enterprise information system resources using a Java™ archive file comprises bundling the enterprise information system resources, creating a deployment descriptor for the bundled enterprise information system resources, and packaging the bundled enterprise information system resources and the deployment descriptor into the Java™ archive file.
摘要:
A web server computer system includes a virus checker and mechanisms for checking e-mails and their attachments, downloaded files, and web sites for possible viruses. The virus checker allows a web server to perform virus checking of different types of information real-time as the information is requested by a web client. In addition, a web client may also request that the server perform virus checking on a particular drive on the web client. If this case, the web server may receive information from the web client drive, scan the information for viruses, and inform the web client whether any viruses were found. In the alternative, the web server may download a client virus checker to the web client and cause the client virus checker to be run on the web client. The preferred embodiments thus eliminate the need for virus checking software to be installed on each web client.
摘要:
A method autonomically refreshes a materialized query table (MQT) in a computer database to improve database performance and utility. In preferred embodiments, the query optimizer autonomically initiates a refresh of MQT depending on an estimated time for the query to access the base tables. In other preferred embodiments, the query optimizer estimates the time for the query to access the base tables and compares it to the estimated time to refresh the MQT to determine whether to refresh the MQT and run the query over the MQT rather than the base tables.
摘要:
A method, apparatus and computer program product are provided for implementing enhanced query governor functions. Query execution includes first checking for a timeout value for a query. Responsive to identifying a timeout value for the query, an execution time for the query is reset and a monitor for each timeout value for the query is started. Then the execution of the query is started. The execution of predefined events is monitored during the execution of the query. The predefined events include a begin or end of processing of at least one of a trigger and a user defined function (UDF). Execution status of the query is periodically checked. Responsive to identifying the query is executing, checking for any expired timeout value is performed. The execution of the query is halted responsive to an identified expired timeout value.
摘要:
A satellite radio receiver includes a display that displays information regarding one or more channels that are not currently being listened to. For a music channel, this information may include the name of the artist, the song title, time left in the song, etc. For a news channel, this information may include the news currently being discussed, the name of the news program, the time remaining, etc. For a sports channel, this information may include the name of the channel, a description of the sporting event, the time remaining, etc. The preferred embodiments include different ways to select which channels are “favorites” and therefore displayed on the display. One way is to keep track of which channels are most frequently listened to, and to display information regarding those channels.
摘要:
A web server computer system includes a virus checker and mechanisms for checking e-mails and their attachments, downloaded files, and web sites for possible viruses. The virus checker allows a web server to perform virus checking of different types of information real-time as the information is requested by a web client. In addition, a web client may also request that the server perform virus checking on a particular drive on the web client. If this case, the web server may receive information from the web client drive, scan the information for viruses, and inform the web client whether any viruses were found. In the alternative, the web server may download a client virus checker to the web client and cause the client virus checker to be run on the web client. The preferred embodiments thus eliminate the need for virus checking software to be installed on each web client.
摘要:
Methods, articles of manufacture, and systems for reducing network traffic for database transactions between a requesting client and a database server are provided. For some embodiments, the client may access statistical information regarding the data, such as that commonly contained in indexes (e.g., encoded vector indexes), conventionally generated for use by a query optimizer. For some embodiments, based on the statistical information regarding the data, the client may request that the server send small byte-code representations of data from the database, rather than the actual data. The small byte-code representations may be significantly smaller than the actual represented data, thus reducing network traffic between the client and server. The client may then retrieve the actual represented data from a corresponding data representation record.
摘要:
The select statement of a query is processed to determine whether any of the columns in the select statement appear in the predicate of the query. For each column in the select statement that also appears in the predicate of the query, the column may be eliminated from the result set by writing the value for the column in a side data structure. In this manner, the amount of data returned in the result set is reduced, thereby enhancing system performance in running the query.