Abstract: A method to optimize a database is provided. A processor determines a frequency of search for a plurality of columns in a table. A processor determines a length of the plurality of columns. A processor determines a rank for the plurality of columns based, at least in part, on both the frequency of search and the length of the plurality of columns. A processor generates a first set of combinations of the plurality of columns. A processor determines an optimization of the first set of combinations of the plurality of columns. A processor selects an optimal combination of the first set of combinations, wherein the optimization of the optimal combination is greater than the optimization for all other combinations in the first set of combinations. A processor moves the plurality of columns excluded from the optimal combination.

Abstract: The present invention relates to a technical field of touch input and discloses method and device for controlling a mobile apparatus having a touch screen including: generating a virtual keyboard which is larger than a virtual keyboard displaying area in the touch screen; and moving the virtual keyboard in response to a sliding of a touch point, where at least one direction component of a moving direction of the virtual keyboard is opposite to a direction component of a sliding direction of the touch point. With the technical solution of present application, the input experience for the user can be improved.

Abstract: A data pasting method and apparatus. The method determines attributes of a source object that is data to be pasted. The attributes of each candidate paste target is obtained among a plurality of candidate paste targets, the attributes of the candidate paste targets contrain an editable component which determines a matching relationship between each of the candidate paste targets and the source object based on the attributes of the source object and the attributes of the editable component. The method provides recommendation for pasting the source object based on the matching relationship. By adopting the technical solution according to the present application, the efficiency of data pasting operation can be improved. Also provided is an apparatus for implementing the above data pasting method.

Abstract: The present invention relates to a technical field of touch input and discloses method and device for controlling a mobile apparatus having a touch screen including: generating a virtual keyboard which is larger than a virtual keyboard displaying area in the touch screen; and moving the virtual keyboard in response to a sliding of a touch point, where at least one direction component of a moving direction of the virtual keyboard is opposite to a direction component of a sliding direction of the touch point. With the technical solution of present application, the input experience for the user can be improved.

Abstract: A method and system for database indexing, wherein a database index comprises at least one index include. The method and system includes obtaining the number of executions of each of a plurality of Structured Query Language (SQL) statements within a certain time period, respectively, wherein the plurality of SQL statements use the database index. For each of the at least one index include, calculating a number of hits of the index include according to the number of executions of each of the plurality of SQL statements. Further, obtaining a length of the index include, and calculating a hit frequency of the index include by using the number of hits and the length of the index include. The hit frequency equals the number of hits divided by the length.

Abstract: A query block may be cached, not like the traditional solution, which can only cache a query result for the query block. For example, a work file for storing a result set of a query block may be maintained after relevant query has been completed. In subsequent use, once a query for the query block is received, query may be processed quickly by directly reusing the result set. In this way, the data overheads for reducing the query processing can be significantly reduced, and the response time for shorting the query processing can be shortened. Corresponding methods and systems are described in the present disclosure.

Abstract: List display control method and device are provided. The method may include displaying a plurality of list items in a list display area. The method may also include performing at least one of the following based on an operation of a pointer in the list display area: scrolling up, in response to a first operation of the pointer on any list item of the plurality of list items in a first area of the list display area and scrolling down, in response to a second operation of the pointer on any list item of the plurality of list items in a second area of the list display area which is different from the first area.

Abstract: The invention provides for verifying correctness of a database system. A SQL instruction is received and access paths of the received SQL instruction are extended. The SQL instruction is executed by using the extended access paths, and the correctness of the database system is verified according to results of executing the SQL instruction. With the method and system of the invention, the object of verifying correctness of a database system by automatically extending access paths of SQL statement may be achieved, and the object of verifying correctness of a database system scientifically, effectively and purposefully based on ratio of error or defect present in database itself due to various data manipulation approaches (different values of access path elements) may also be achieved.

Abstract: In an exemplary embodiment of this disclosure, a method may include generating a tempo scale set based on a received query, where the query includes a plurality of query values defining a tempo of music to be searched. A tempo word set may be constructed based on the generated tempo scale set. The tempo word set may include one or more tempo words, where each tempo word includes at least one tempo scale in the tempo scale set. The music may be identified using the constructed tempo word set.

Abstract: Embodiments of the invention relate to database large object (LOB) reorganization. An aspect of the invention includes calculating an activity of an inline LOB. The length of an inline LOB is redefined according to the activity of the inline LOB. LOB reorganization is performed based on the redefined length of the inline LOB.

Abstract: A search engine suggestion method, apparatus, and non-transitory article of manufacture embodying computer readable instructions for data search. The method includes: obtaining a query input by a user; obtaining a query suggestion set for the query for each of a plurality of different search engines, the query suggestion set including at least one query suggestion; determining a match degree between each of the search engines and the query based on the query suggestion set and background association information of the query; and suggesting among the plurality of different search engines based on the match degrees. By use of the solutions proposed by this application, it is possible to suggest the user a more appropriate search engine(s) for data search.

Abstract: Embodiments relate to a system, computer program product and method for database query optimization. An aspect includes a method that extracts complex predicates from a query statement, the query statement having at least two complex predicates. The method then executes a query associated with the query statement and obtains at least a respective execution structure cost (?Ti) for each of the complex predicates. The method also calculates an overall execution structure cost corresponding to each of the complex predicates, the complex predicates being arranged according to result of the query and the execution structure costs (?Ti); and optimizes a database query by selecting the arrangement of complex predicates having a lowest overall execution structure cost.

Abstract: A computer program product and method for estimating a filter factor for access path optimization in a database are provided. The method includes extracting from a statement segment for database query a relation condition which defines the relationship between a variable and a first table. The method includes obtaining first statistics information according to the relation condition and the statistics information of the first table. The method includes extracting from the statement segment a filter condition which defines the relationship between the variable and a second table. The method includes obtaining second statistics information according to the filter condition and the statistics information of the second table, and according to the first statistics information and the second statistics information, estimating the filter factor of the filter condition.

Abstract: The present invention discloses a mechanism for determining criticality of a SQL statement. A plurality of elements in the SQL statement is extracted. A score of the SQL statement is calculated based on a correlation relation among respective elements in the plurality of elements and base scores of the respective elements. The criticality of the SQL statement is determined based on the score of the SQL statement. In this way, a database administrator only needs to define a small number of rules according his own needs. In the meantime, the mechanism automatically analyzes a received simple or complex SQL statement according to the small number of rules defined by the user to determine its criticality, without missing any critical SQL statement, and thereby protect security of data in the database.

Abstract: A terminal that includes a transmitter, a receiver, and an updater. The transmitter is configured to broadcast a first data packet in response to the terminal being connected to a local area network (LAN). The first data packet includes at least one of an Internet protocol (IP) address and a media access control (MAC) address of the terminal as well as a domain name of the terminal. The receiver is configured to receive a second data packet broadcasted by another terminal on the LAN. The second data packet includes at least one of an IP address and a MAC address of the other terminal as well as a domain name of the other terminal. The updater is configured to update a domain name system (DNS) configuration in the terminal based on the second data packet received by the receiver.

Abstract: A method and apparatus for generating an extended page snippet in a search engine. The method includes: retrieving and returning an associated table webpage having a table related to an inquired keyword; obtaining a parsed result of the table in the associated table webpage, and extracting column names and respective row instances on the basis of the parsed result; determining the row instances related to the inquired keyword; and generating a page snippet in a table style in accordance with the column names and the relative row instances. The page snippet in the table style can be generated by using a solution of the present invention.

Abstract: Managing a sharing relationship of tables. A super schema is formed incorporating a plurality of tables in a database according to data types of respective columns of the plurality of tables. A free storage capacity of the super schema is evaluated according to holes not occupied by any table in the super schema. A sharing relationship of the plurality of tables is determined according to the free storage capacity of the super schema. The sharing relationship of a large number of tables in a database can be managed effectively, so as to design or optimize the sharing solution among the tables.

Abstract: Embodiments of the invention relate to organizing data records in a relational database. An aspect of the invention includes creating index items for a plurality of data records. Each index item includes a counter and the creating results in a plurality of counters. The numerical values of counters in corresponding index items are updated for data records in the plurality of data records that are subjected to random access. The plurality of data records are reorganized based upon the numerical values of the plurality of counters.

Abstract: A method of transferring files in a data-processing network using a current node within the network includes reading an outbound content and outbound characteristics of an outbound file. An outbound message is created having outbound strings including a first set of the outbound strings representing the outbound characteristics and a second set of the outbound strings representing the outbound content. The outbound message is sent to a receiver node within the network. An inbound message is received from a sender node within the network. The inbound message has inbound strings including a first set of the inbound strings representing inbound characteristics and a second set of the inbound strings representing inbound content. An inbound file having the inbound content is stored, and the inbound characteristics are applied to the inbound file.

Abstract: A search engine suggestion method, apparatus, and non-transitory article of manufacture embodying computer readable instructions for data search. The method includes: obtaining a query input by a user; obtaining a query suggestion set for the query for each of a plurality of different search engines, the query suggestion set including at least one query suggestion; determining a match degree between each of the search engines and the query based on the query suggestion set and background association information of the query; and suggesting among the plurality of different search engines based on the match degrees. By use of the solutions proposed by this application, it is possible to suggest the user a more appropriate search engine(s) for data search.