Abstract: A method, computer program product, and computer system for improving performance of a SQL execution sequence of SQL statements. The SQL execution sequence is recorded in an event log. Original results of executing the SQL statements and an original CPU cost of executing the SQL statements in accordance with the original access path are recorded in a logical log. A new access path is generated from analysis of the event log and the logical log. The SQL statements are executed in accordance with the new access path resulting in new results of executing the SQL statements including a new CPU cost of executing the SQL statements in accordance with the new access path. In response to a determination that the new results replicate the original results and that the new CPU cost is less than the original CPU cost, the original access path is replaced with the new access path.

Abstract: Provided is a parent phytase variant, which relates to the technical field of protein engineering. The variant, relative to the parent phytase thereof, has one or more amino acid substitutions at positions corresponding to positions 295, 349, and 374 of SEQ ID NO: 1. Compared to the parent phytase, the variant has increased thermal stability.

Abstract: A computer implemented method for managing buffer pool usage includes identifying a database comprising one or more buffer pools and a set of database objects, adding a virtual layer between the set of database objects and the one or more buffer pools, wherein the virtual layer is configured to manage buffer pool resource utilization, managing, using the added virtual layer, buffer pool resource utilization with respect to the set of database objects, wherein the managing comprises defining buffer pool usage corresponding to the set of database objects, dynamically mapping database objects to the buffer pools based, at least in part, on the defined buffer pool usage, analyzing, by one or more processors, queues to identify updated buffer pool usage, and adjusting database object allocation according to the identified updated resource usage. A computer program product and computer system corresponding to the method are also disclosed.

Abstract: A method includes training, by a computing device, a model to identify SQL queries; identifying, by the computing device, incoming SQL queries; grouping, by the computing device, the incoming SQL queries into groups; monitoring, by the computing device, resource usage of the incoming SQL queries in the groups; and allocating, by the computing device, resources to an SQL query of the incoming SQL queries based on the monitoring.

Abstract: A simulated dataset is queried for regression by validating a structured query language (SQL) statement, determining a pattern type of the SQL statement, reconstructing the SQL statement according to a predetermined process for the pattern type, creating a mutated SQL statement for querying a simulated dataset, and validating the mutated SQL statement. The simulated dataset is based on a confidential dataset having the confidential elements removed or replaced.

Abstract: In the subject matter described herein, a method, device and computer program product for controlling the projector are proposed. According to the method, the application for controlling the project can be started. The application can determine the operation mode by determining whether the current host device is the projector or a terminal device for controlling the projector. Once the operation mode of the application is determined, the method can control the projector based on the operation mode and via the application service operating on the projector. The application service can provide an interface for controlling a device driver of the projector.

Abstract: Provided is a method for upgrading pyrolysis oil through seawater electrochemical pretreatment of biomass and use thereof. The method includes: (1) crushing and sieving a biomass raw material to obtain a crushed biomass raw material, adding the crushed biomass raw material to a salt solution and mixing to be uniform to obtain a reactant mixture; performing an electrolytic reaction on the reactant mixture under conditions of stirring and an external voltage of 5-15 V for 2-8 hours to obtain a product mixture; after the electrolytic reaction, subjecting the product mixture to a suction filtration, collecting a filter cake, washing the filter cake and drying to obtain a pretreated biomass, and (2) subjecting the pretreated biomass obtained in step (1) to a pyrolysis reaction at a temperature of 400-600° C. for 30-90 minutes in a protective gas atmosphere, and collecting a pyrolysis oil by an organic solvent.

Abstract: The present disclosure relates to a system for measuring a naked-eye stereoscopic image, a method and apparatus for processing an image and a display device. The system includes: a naked-eye stereoscopic display device, configured to display preset images in sequence; an image acquisition device, configured to obtain monochromatic images by capturing display contents of the naked-eye stereoscopic display device, and send the monochromatic images to a processor; and a processor, configured to acquire at least one preset crosstalk amount to each stereoscopic pixel of the naked-eye stereoscopic display device from each view point according to the monochromatic images, where each of the at least one preset crosstalk amount represents a proportion coefficient that measures how much a view from another view point affects a color value of a view from a target view point.

Abstract: A computer-implemented method to generate and utilize a hybrid index. The method includes receiving a first query, where the first query is configured to perform a first command. The method further includes generating a hybrid index, where the hybrid index defines a connection between a first table and a second table of a set of tables. The method also includes executing the first query using the hybrid index. The method includes returning a set of results for the first query to a source of the query.

Abstract: A computer-implemented method, system and computer program product for improving performance of a distributed database. A query is received to store version data in the distributed database. Upon receiving the query to store the version data, the version data is stored in a row of a data page of a main table of a heap organized table/index organized table of the distributed database, where the row of the data page of the main table of the heap organized table/index organized table of the distributed database contains a pointer pointing to a later/previous version of the version data if the later/previous version of the version data is stored in the data page thereby chaining version data bi-directionally.

Abstract: A display device, a sound producing control method, a method and device for determining parameters. The display device includes a plurality of exciters arranged on the display panel, the display panel producing sound on a screen through the plurality of exciters; wherein, the plurality of the exciters are formed as at least one sound producing unit, each sound producing unit includes at least two exciters, and each exciter in the same sound producing unit is connected to a same audio signal input end, in one sound producing unit, a signal filter is provided on an audio transmission line from the audio signal input end to at least one exciter, and used for low frequency compensation of a sound produced by the entire sound producing unit.

Abstract: A computer implemented method manages a location of database object descriptions in a storage, the computer implemented method. A number of processor units identifies a set of workload groups that are coming up for execution. The number of processor units loads the database object descriptions for the set of workload groups into a highest performance storage in a storage system. The number of processor units manages the location of the database object descriptions in the storage system based on access to database objects by set of workload groups.

Abstract: A method for planting submerged plants is disclosed. The method includes the steps of selecting a combination of two submerged plants; planting the combination of submerged plants; measuring a biomass and evaluating the biomass. By discussing the influence of planting proportion on the biomass of submerged plant community, the structure of submerged plant community can be optimized, and the success rate of submerged vegetation restoration and reconstruction can be improved by using the positive interaction between plant species.

Abstract: A method, system, and computer program product for abnormal data detection. According to the method, a plurality of data points collected at different time points are classified into a plurality of groups. A plurality of groups of potential abnormal data points are determined from the plurality of groups. Correlations between a first group of the plurality of groups of potential abnormal data points with other groups of potential abnormal data points are determined. In response to the first group of the plurality of groups of potential abnormal data points being uncorrelated to a majority of the other groups of potential abnormal data points based on the correlations, data points in the first group are identified as abnormal data points.

Abstract: One or more computer processors match a query pattern to a received query; context information related to the received query; retrieve a set of query records including the same context information as the obtained context information from an index knowledge base, wherein each query record in the set of query records include context information related to a respective history query, the query pattern, an index type associated with the query pattern, and performance information relating to the query pattern and the index type; determine that a subset of the retrieved query records includes one or more query patterns equivalent to the matched query pattern; select a query pattern and an associated index type from the subset of query records based on associated performance information in the set of query records; and perform the received query by applying the selected query pattern and the associated index type.

Abstract: A display device, a method for realizing panoramic sound, a non-transitory storage medium are provided. The method includes: performing space model parameter modification on preset space model based on application environment; determining middle audio source information based on video source information as read, determining side audio source information based on video source information and modified space model parameter; determining top audio source information based on sound image position information and side audio source information; controlling middle sound production circuit to produce sound based on middle audio source information, two side sound production circuits to produce sound based on side audio source information, top sound production circuit to produce sound based on top audio source information.

Abstract: Processing range operation data management statements in a database is provided. The method comprises receiving statements for range operations that specify referenced pages in the database. The range operations are stored in a search structure in a table directory in the database and applied to any referenced pages in a memory buffer pool. Application of the range operations is postponed for any referenced pages not in the memory buffer pool. The database determines if reading the postponed pages into the buffer pool would exceed a specified input/output threshold. If reading the postponed pages into the buffer pool does not exceed the specified threshold, the database reads the postponed pages from disk to the buffer pool asynchronously in parallel, and the range operations are then applied to the postponed pages. Pages modified by the range operations are then written from the buffer pool back to disk.

Abstract: Methods, computer program products, and systems are presented. The method computer program products, and systems can include, for instance: receiving an incoming query statement, wherein the incoming query statement comprises a query statement expression that includes an input variable; predicting an input variable value associated to the input variable; selecting an access path for runtime execution of the query statement in dependence on the predicted input variable value; and performing runtime execution of the query statement using the selected access path.

Abstract: A method of managing a storage system comprises detecting a reference to a first page in the storage system. The method also comprises creating a first candidate block for the first page based on the detecting. The first candidate block may comprise a continuous series of pages that begins with the first page. The method also comprises monitoring subsequent references to pages within the first candidate block. The method also comprises determining that the first candidate block meets a first set of hot-block requirements. The method also comprises relocating the first candidate block to a hot-block space in a buffer pool based on the determining, resulting in a first hot block.

Abstract: Modifying an index for a database is provided. An index tree for the database is traversed by: identifying a next node in the index tree, requesting a lock of the next node in the index tree, responsive to locking of the next node in the index tree, releasing a lock of a current node of the index tree, and making the next node in the index tree the current node of the index tree, until the current node of the index tree is a leaf node of the index tree. Responsive to determining to split the leaf node, the lock of the leaf node is released and, after releasing the lock of the leaf node, a lock of a non-leaf node parent of the leaf node in the index tree is requested.