Abstract: A computer-implemented method for managing an index table associated with a data table includes obtaining an index entry associated with a key in the data table. The computer-implemented method further includes determining whether an index page associated with the index entry is in a buffer pool, wherein the buffer pool includes a plurality of index pages loaded from the index table and at least one temp index. The computer-implemented method further includes adding, in response to determining that the index page associated with the index entry is not in the buffer pool, the index entry into the at least one temp index. The computer-implemented method further includes consolidating the at least one temp index into the index table.

Abstract: An approach is provided for optimizing a database buffer pool. Based on statistics about read and write operations in a range of pages, the range of pages is determined to be a candidate for a hot read range for which locks and latches are avoided in processing operations in the hot read range. Using an on-time trigger or pre-trigger process, the hot read range is created from the range of pages by marking start and end points in the range of pages. Write operation(s) are determined to be included in the hot read range by marking an object control block. The write operation(s) are added to a write pending list. The read operations in the hot read range are performed without a latch or lock. The write operation(s) are merged from the write pending list to the range of pages and the write operation(s) are performed.

Abstract: Soft motherboards having rigid plugin modules are described herein. In one aspect of the present disclosure, an electronic device can include a polymeric substrate having: a plurality of slots, each configured for receiving an electronic module; one or more electrical junctions including a stretchable conductive interconnect electronically coupling a slot to another slot of the plurality of slots; and at least one electronic module including: a film configured to: support other components of the electronic module; and be inserted, and be partially housed in, one of the plurality of slots of the polymeric substrate; and at least one electrode coupled to the film and positioned to be in contact with a corresponding electrical junction of the polymeric substrate when the film is partially housed in the polymeric substrate.

Abstract: A method including acquiring to-be-processed information corresponding to a real-time video application, the to-be-processed information comprising at least one of the following: customer identity information and real-time video identification information; identifying a target object and an information intent corresponding to the to-be-processed information; determining, according to the target object and the information intent, at least one response corresponding to the to-be-processed information; and sending the at least one response to a send terminal corresponding to the customer identity information.

Abstract: Database log writing is based on log pipeline contention. A determination is made as to whether contention in writing data to a log pipeline, which is used in writing data from memory to storage, is at a prespecified level. Based on determining that the contention in writing the data to the log pipeline is at the prespecified level, a split operation is automatically performed to create a new log pipeline.

Abstract: An approach is provided for automatically updating a data type of a database column. Based on a database definition, category, and usage, the column is determined to be a candidate for a data type change. For first values in the column values, costs of processing queries using a new data type are determined to be less than other costs of processing the queries using other data types. For exception value(s) in the column values, costs of processing the queries using the original data type are determined to be less than other costs of processing the queries using other data types. The original data type is replaced with the new data type for the first values and the original data type is retained for the exception value(s). The first values are associated with a first schema and the exception value(s) are associated with a second schema.

Abstract: Trace processing in a database system is facilitated by obtaining database trace data collected from database tracing a database system, and data analyzing, by one or more processors, the database trace data to determine one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system. Trace processing is further facilitated by applying the one or more field-related rules to a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.

Abstract: An apparatus comprises at least one processing device comprising a processor coupled to a memory and a drive bay enclosure of a storage system comprising a housing with one or more drive bays, the housing of the drive bay enclosure comprising one or more status indicators proximate an opening for at least a given one of the one or more drive bays. The at least one processing device is configured to perform steps of determining status information for the given drive bay, and controlling the one or more status indicators proximate the opening for the given drive bay based at least in part on the determined status information.

Abstract: The present application provides a medical imaging method and system and a non-transitory computer-readable storage medium. The medical imaging method comprises obtaining an original image acquired by an X-ray imaging system, and post-processing the original image based on a trained network to obtain an optimized image after processing.

Abstract: Provided is a thermostable glucose oxidase obtained by introducing at least one pair of disulfide bonds into an amino acid sequence of a wild-type Aspergillus niger glucose oxidase or a mutant Aspergillus niger glucose oxidase. The glucose oxidase is suitable for application in the fields of food, chemical engineering, medicine, agriculture and feeds.

Abstract: A method, system, and computer program product for recommending an initial database security model. The method may include identifying a plurality of nodes connected to a security network. The method may also include analyzing security characteristics of each node of the plurality of nodes. The method may also include identifying, from the security characteristics, key factors for each node. The method may also include calculating similarities between each node of the plurality of nodes. The method may also include building a self-organized centerless network across the plurality of nodes by grouping nodes with high similarities based on the similarities between each node, where the self-organized centerless network is a centerless network without a central management server, and includes groups of nodes from the plurality of nodes. The method may also include generating federated security models for the groups of nodes.

Abstract: Trace processing in a database system is facilitated by obtaining database trace data collected from database tracing a database system, and data analyzing, by one or more processors, the database trace data to determine one or more field-related rules to, in part, reduce impact on system performance of database tracing in the database system. Trace processing is further facilitated by applying the one or more field-related rules to a database trace in the database system to adjust trace fields of the database trace according to the one or more field-related rules, thereby reducing impact on system performance of the database trace in the database system.

Abstract: Systems and methods for pre-allocating and utilizing storage space in a relational database are provided. In embodiments a method includes: obtaining transaction data including data regarding record insertions in a relational database, wherein each record of the record insertions is associated with a key value; identifying a type of each of the record insertions as either a random insertion type or a key range insertion type based on the database transaction data, wherein the random insertion type comprises records associated with respective key values inserted in a random order, and the key range insert type comprises records associated with a range of key values inserted within a certain time period; predicting a new range of key values associated with future record insertions based on the type of each of the record insertions; and pre-allocating page space in one or more pages of the relational database for the future record insertions.

Abstract: Database recovery is based on workload priorities. A database workload is divided into a plurality of workload groups. A workload group of the plurality of workload groups is selected for recovery, in which the selecting is based on a priority of the workload group. One or more recovery actions are performed for the workload group selected for recovery.

Abstract: Leveraging the competence of a computing cluster and a storage cluster by dynamically adjusting an SQL (structured query language) execution path to optimize system performance with fast response time under a distributed relational database on a data storage platform. Also, endpoint devices are divided into groups for the purpose of responding to queries and/or query blocks. The most suitable group of endpoint devices is chosen to respond to a given query or query block.

Abstract: A brake system of a vehicle is disclosed. The braking system includes: a sensor configured to transmit a signal; a brake control unit (BCU) connected to the sensor and configured to determining a braking torque in response to the received signal; an electric motor connected to the BCU and configured to generate the braking torque; a braking mechanism connected to the electric motor to produce an braking effect from the braking torque; and a transmission situated between the braking mechanism and the wheel and configured to amplify the braking effect.

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: A computer-implemented method to estimate an execution time for large query batches. The method includes identifying a batch of queries, where the batch of queries where each query is configured to retrieve data from a database. Selecting a first query and generating an access path for the first query including one or more mini plans. Building a learning model for the one or more mini plans. Estimating an estimated execution time for each of the one or more mini plans. Adding each of the estimated execution times for each of the one or more mini plans to determine a first total estimated time for the first query. Displaying the first total estimated time.

Abstract: A computer-implemented method selects an access path for high cost and/or complex queries. The method includes building a classification model configured to identify a lowest cost access path. The method further includes receiving a query, where the query is configured to retrieve a set of data from a database. The method also includes generating an access map for the query, where the access map includes one or more potential access paths to execute the query. The method includes collecting, for the query, a set of data for each potential access path. The method further includes classifying, by the classification model, the query. The method also includes selecting a first access path of the one or more potential access paths and executing the query.

Abstract: In a computer-implemented method for improving performance of a database optimizer, a processor calculates a first execution time for a database query executing through a first access path of a database system. A processor generates a second access path. A processor determines a second execution time via a simulation of the database query through the second access path. A processor determines that the second execution time is less than the first execution time. A processor, responsive to determining that the second execution time is less than the first execution time, sends the second access path to the database optimizer.