Abstract: A computer-implemented method dynamically detects and corrects an error in a query. The method includes identifying an error in a first query. The method further includes generating a set of alternate execution structures for the first query. The method includes running each of the alternate execution structures, including generating a set of results corresponding to each set of alternate execution structure, comparing each of the set of results against each other of the set of results, and storing each of the set of alternate execution structures to include a result of the set of results, for each alternate structure. The method further includes selecting, from the set of alternate execution structures, a first alternate execution structure based on a predetermined criteria, and implementing the first alternate structure in place of the first query.

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: An organic wastewater treatment method based on a multi-element co-doping TiO2 nano photocatalytic material includes preparing a sulfur-titanium dioxide mixture, hydrothermally reacting the sulfur-titanium dioxide mixture with copper chloride, ammonia, strong alkali, a transition metal salt and the like, reacting the resulting reaction product with hydrofluoric acid, then performing temperature programming thermal treatment in air to obtain the multi-element co-doping TiO2 nano photocatalytic material, and then treating organic wastewater with the multi-element co-doping TiO2 nano photocatalytic material under the irradiation of visible light.

Abstract: A computer-implemented method improves the performance of write ahead logging. The method includes generating a set of query data and a set of log data, where the set of log data is configured to create a write ahead log, and the set of query data is configured to make changes to data in a database. The method also includes writing the set of query data to a virtual file system. The method further includes separating the set of log data into a set of control intervals, where each control interval includes an entry. The method includes writing, each entry into a log buffer, where the writing the set of query data to the virtual file system and the writing each entry into the log buffer are performed in parallel. The method also includes combining each entry into a complete log.

Abstract: The present disclosure provides a Wnt family member 4/tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein zeta (Wnt4/YWHAZ) co-modified mesenchymal stem cell (MSC)-derived exosome, and a preparation method and use thereof, belonging to the technical field of skin repair. In the present disclosure, the MSC-derived exosome is modified by overexpressing adenovirus vectors expressing a Wnt4 gene and a YWHAZ gene in the MSCs, such that the exosome overexpresses the Wnt4 gene and the YWHAZ gene, to achieve a medicinal purpose of promoting regeneration and repair of a scalded skin tissue in a rat with the MSC-derived exosome.

Abstract: A processor may allocate a first buffer segment from a buffer pool. The first buffer segment may be configured with a first contiguous range of memory for a first data partition of a data table. The first data partition comprising a first plurality of data blocks. A processor may store the first plurality of data blocks in order into the first buffer segment. A processor may retrieve the target data block from the first buffer segment in response to a data access request for a target data block of the first plurality of data blocks.

Abstract: A wireless earphone comprising a housing that defines an interior cavity having an inner surface and an outer surface; an opening extending through the housing from the inner surface to the outer surface; and a mesh assembly disposed over the opening and comprising a permanent assembly coupled to the housing and a replaceable assembly removably coupled to the permanent assembly and comprising a mesh.

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 device for providing drug verification may work in conjunction with drug delivery devices such as medical pumps to provide a chemical and concentration analysis of drugs being delivered forming a signature that can be compared to a signature associated with the proper drug, reducing errors in medicine delivery and ensuring proper use of medicines throughout their lifecycle.

Abstract: In an approach, a processor obtains a plurality of security policies for managing security of a database, the security policies defining respective sets of items to be monitored. A processor stores, respectively, the sets of items defined by the plurality of security policies in one or more item tables based on a predetermined criterion, the predetermined criterion comprising security policy relevance, security policy structure, and available space in the one or more item tables. A processor creates, for each of the one or more item tables, one or more respective index tables associated with the items in the respective item table. A processor creates, for each of the one or more item tables, a fast traverse block (FTB) associated with the created one or more respective index tables.

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: In an approach for database index optimization, a processor detects a pattern of characters and numeric digits of an index key. The index key provides an access to a database through an index access without a sorting operation. A processor determines a converting format based on the pattern of the index key. The pattern includes a string of the numeric digits. A processor converts the index key into a converted key by converting the string of the numeric digits into an integer. A processor saves the converted key into a storage.

Abstract: Disclosed is a computer-implemented method to adjust partition keys. The method includes identifying a target table that is a target of a query, the target table including a set of initial partitions. The method also includes determining a set of common queries, wherein each of the common queries are configured to retrieve data from the target table. The method further includes identifying a plurality of core ranges. The method includes merging the core ranges into a new set of partitions. The method further includes setting, in response to the merging, updated partition keys. Further aspects of the present disclosure are directed to systems and computer program products containing functionality consistent with the method described above.

Abstract: A computer-implemented method provides application-based query transformations. The method includes determining an application is initiated. The method includes identifying a set of execution units included in the application. The execution units are based on of a set of queries in the application and a set of actions in the application. The method also includes building a query dependency graph (QDG) comprising a plurality of nodes, wherein each node of the plurality of nodes is correlated to an execution unit, and each node is linked to at least one additional node, the link indicating a relative execution order and a common attribute each node and the additional node. The method includes merging, based on a performance architecture, two or more of the set of execution units into a section. The method includes processing the application according to the QDG.

Abstract: In one embodiment, a method according to the present disclosure includes receiving a topology change advertisement at a remote core edge node and performing a network address information removal operation. The topology change advertisement is received from a core edge node that is in communication with an access network. The topology change advertisement indicates that a topology change has occurred in the access network. The network address information removal operation removes network address information stored by the remote core edge node. The network address information is used by the remote core edge node in participating in communications with the core edge node.

Abstract: An organic wastewater treatment method based on a multi-element co-doping TiO2 nano photocatalytic material includes preparing a sulfur-titanium dioxide mixture, hydrothermally reacting the sulfur-titanium dioxide mixture with copper chloride, ammonia, strong alkali, a transition metal salt and the like, reacting the resulting reaction product with hydrofluoric acid, then performing temperature programming thermal treatment in air to obtain the multi-element co-doping TiO2 nano photocatalytic material, and then treating organic wastewater with the multi-element co-doping TiO2 nano photocatalytic material under the irradiation of visible light.

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: 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: The present invention relates to a monoclonal antibody platform designed to be coupled to therapeutic peptides to increase the half-life of the therapeutic peptide in a subject. The invention also relates to pharmaceutical compositions and methods for use thereof.

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.