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: The present invention comprises compounds of Formula I. wherein: Z4, Z7, Z9, Z11, Z22, Z23, Z26, Z30, Z34, Z35, p, m, n, q, and BRIDGE are defined in the specification. The invention also relates to pharmaceutical compositions and methods for use thereof. The novel compounds are useful for preventing, treating or ameliorating diseases and disorders, such as obesity, type 2 diabetes, the metabolic syndrome, insulin resistance, and dyslipidemia, among others.

Abstract: A low-cost medical pump for ambulatory use provides an improved IV line cartridge attachment allowing for single handed, low force release while preventing inadvertent IV line cartridge release. A rotatable side lever minimizes the force required to move the locking elements against a spring biased force urging the locking elements to a locking position.

Abstract: Embodiments of the present invention relate to a method, system, and computer program product for multiplexing data operation. In some embodiments, a method is disclosed. A query for at least one table comprising a plurality of data records is received. The query indicating a plurality of data operations to be performed on the plurality of data records. The plurality of data operations are combined into a target data operation. An intermediate result of the query is generated by performing the target data operation on the plurality of data records. A final result of the query is determined based on the intermediate result. In other embodiments, a system and a computer program product are disclosed.

Abstract: A method, system, and computer program product to plan and schedule executions of various utility tasks of a utility command during a maintain window, the method including receiving a utility command. The method may also include identifying possible utility tasks used to execute the utility command. The method may also include determining preferred utility tasks. The method may also include calculating a degree of parallelism for the preferred utility tasks. The method may also include generating a utility execution plan for the utility command. The method may also include analyzing the utility execution plan against resource constraints of a time window and sub time windows of the time window. The method may also include generating a time window execution plan for each sub time window of the sub time windows. The method may also include updating the utility execution plan with the time window execution plans.

Abstract: Systems and methods for high availability distributed data storage are provided. In embodiments, a method includes: receiving, by a remote direct memory access (RDMA) switch operatively coupled to a computing device, a request to access a page of a database; determining, by the RDMA switch, a validation state of the page; determining, by the RDMA switch, a status of the page; updating, by the RDMA switch, the status of the page based on the validation state and the request; and reporting, by the RDMA switch, the validation state.

Abstract: A system, program product, and method for enhancing automatic multidimensional query processing. The method includes executing a database query including semi-joining a plurality of dimension tables with a fact table. The method also includes identifying for extraction one or more data values from each dimension table of the plurality of dimension tables. The data values from each dimension table of the plurality of dimension tables are associated with a respective record identification (RID), thereby defining one or more RIDs. The method further includes generating a plurality of RID lists. Each RID list of the plurality of RID lists includes a collection of the one or more RIDs for the respective dimension table. The method also includes merging the plurality of RID lists, sorting, subject to the merging, the plurality of RIDs as a function of data location, and fetching the data values from the fact table.

Abstract: An embodiment includes executing a querying process that returns database documents containing text associated with a database environment. The embodiment tokenizes the database documents into a series of n-gram tokens and groups the tokens into topic classes using natural language processing (NLP). The embodiment also generates a feature map by applying a convolution layer to an image that depicts a database structure graph of the database environment. The embodiment detects an architectural element in the image by applying a region proposal network (RPN) to the feature map and classifies the architectural element into one of the plurality of topic classes using a trained neural network. The embodiment renders, responsive to a user selection of the architectural element, an overlay depicting information about the architectural element using text and other architectural elements that are in a same topic class as the user-selected architectural element.

Abstract: A method includes: obtaining, by a database server, security policies associated with a database hosted by the database server; obtaining, by the database server, first database data associated with the database; creating, by the database server, a knowledge distillation model using the security policies and the first database data; obtaining, by the database server, second database data associated with the database; creating, by the database server, a classification model using the second database data and an output of the knowledge distillation model; receiving, by the database server, a client database request to the database; determining, by the database server, a new security policy rule set using the classification model; and applying, by the database server, the new security policy rule set to the client database request.

Abstract: A system according to which a network of physical sensors are configured to detect and track the performance of aircraft engines. The physical sensors are placed in specific locations to detect an exhaust gas temperature, vibration, speed, oil pressure, and fuel flow for each aircraft engine. The performance of each aircraft engine is then viewed in combination with oil consumption associated with that aircraft engine and the routine maintenance program associated with that aircraft engine to route the aircraft and move the aircraft, in accordance with the routing, to a specific location. The sensors efficiently track the performance and physical condition of the engines. Moreover, a listing of identified “at-risk” engines is displayed on a screen of a GUI in a manner that allows for easy navigation and display. Data point(s) that triggered the identification of each “at-risk” engine are easily accessible and viewable.

Abstract: Systems and methods are provided to predict connection configurations in a distributed database environment. In embodiments, a method includes: building, by a computing device, a dynamic machine learning predictive model for a first new node connection in a distributed database environment based on configuration data of the first new node connection; determining, by the computing device, a group of nodes in the distributed database environment of a same type of node as the new node connection; federating, by the computing device, the dynamic machine learning predictive model of the first new node connection with other dynamic machine learning predictive models of other nodes in the group of nodes, thereby generating a federated predictive model for the same type of node; and generating, by the computing device, a predicted connection configuration for a second new node connection of the same type of node using the federated predictive model.

Abstract: A computer implemented system and method allow database performance testing and improvement. The method comprises using a database system (DBS) for embedding a virtual resource simulation system (VRSS) into a node of the DBS, loading a new configuration parameter of a database into the VRSS, receiving, by the VRSS from the DBS, an action control block (ACB), and dynamically activating and assigning a service task by a service task dispatcher of the VRSS to process the ACB. The method further comprises simulating a process of database execution based on a content of the ACB by creating a limited database internal data structure that is based on the ACB and the new configuration parameter, and manipulating the limited database internal structure to produce a simulation result. The method further comprises utilizing a metric associated with the simulation result of the new configuration parameter in the simulated process of database execution.

Abstract: A digital syringe is used with conventional polymer disposable syringe construction to be practical in the medical environment. Errors associated with the larger volumes of the syringes (which exacerbate minor errors in plunger position) and the flexibility and dimensional variations of the polymer plungers are accommodated by direct measurement of the syringe plunger position rather than indirect measurement of motor position and inference of syringe plunger position. This direct measurement eliminates mechanical tolerances (“stack up”) in the motor, gear train, and lead screw on plunger movement, an effect exacerbated by flexibility of the plunger and changes in syringe resistance and medicament viscosity, for example, with different medicaments or when the syringe is refrigerated. The digital syringe may be combined with the motor unit to provide additional versatility.

Abstract: An LED tube lamp includes a first and second members and a connection member. Each of the first and second members includes lighting part and an end part. Each lighting part includes LED light strip. The connection member includes electrical connection portions and joining portions for the first and second members. The connection member connects the first member with the second member by the joining portions and the electrical connection portions and makes the first member substantially coaxial to the second member.

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 digital syringe is used with conventional polymer disposable syringe construction to be practical in the medical environment. Errors associated with the larger volumes of the syringes (which exacerbate minor errors in plunger position) and the flexibility and dimensional variations of the polymer plungers are accommodated by direct measurement of the syringe plunger position rather than indirect measurement of motor position and inference of syringe plunger position. This direct measurement eliminates mechanical tolerances (“stack up”) in the motor, gear train, and lead screw on plunger movement, an effect exacerbated by flexibility of the plunger and changes in syringe resistance and medicament viscosity, for example, with different medicaments or when the syringe is refrigerated. The digital syringe may be combined with the motor unit to provide additional versatility.

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: An acoustic mesh comprising a first portion that is acoustically closed; and a second portion that surrounds the first portion and is acoustically open, wherein a surface area of the second portion is at least one percent a total surface area of the acoustic mesh.

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.