Abstract: The methods and computer systems for storing a query plan in a cache. The method can include: determining a use frequency of the query plan; determining a target storage layer for storing the query plan based on the determined use frequency, wherein the cache includes at least two storage layers and each of the storage layers is associated with a compression level of query plans; processing the query plan according to the compression level of the target storage layer; and storing the processed query plan in the target storage layer.

Abstract: Embodiments of the present disclosure provide methods and devices for inserting data in a database. The method can include caching one or more rows of data in a delta table in response to a request to insert the one or more rows in a destination table, wherein the destination table is one of a group of destination tables of a first database, and wherein the delta table contains requested changes of rows of the destination table, the changes being caused by a data operation; determining a priority of the destination table based on runtime information of the destination table relative to the group of destination tables; and scheduling the merging of the inserted rows from the delta table to the destination table based on the determined priority of the destination table. The destination table is in a format of a file storing one or more blocks, each block having a set of sequence of elements clustered from each column of the destination table.

Abstract: Compounds and compositions are provided that can inhibit microsomal prostaglandin E synthase-1 (mPGES-1). The compounds and compositions can reduce inflammation in a subject, such as inflammation caused by an inflammation disorder or symptoms thereof. Pharmaceutical compositions comprising the compound are also provided. Furthermore, methods are provided for reducing inflammation and/or inhibiting mPGES-1. The methods can comprise administering an effective amount of the composition to a subject.

Abstract: Disclosed methods of inhibiting microsomal prostaglandin E2 (PGE2) synthase-1 (mPGES-1) make use of ceftriaxone, aztreonam, cefotetan, pharmaceutically-acceptable salts thereof, and combinations thereof.

Abstract: Compounds and compositions are provided that can inhibit microsomal prostaglandin E synthase-1 (mPGES-1). The compounds and compositions can reduce inflammation in a subject, such as inflammation caused by an inflammation disorder or symptoms thereof. Pharmaceutical compositions comprising the compound are also provided. Furthermore, methods are provided for reducing inflammation and/or inhibiting mPGES-1. The methods can comprise administering an effective amount of the composition to a subject.

Abstract: Intelligent merging for efficient updates in columnar databases are disclosed, including: determining a current age associated with a row in a database, wherein the database comprises a write storage and a read storage, wherein the row is located in the write storage; determining a set of one or more merge criteria based at least in part on a modification age distribution, wherein the modification age distribution is dynamically determined based at least in part on previous transactions at the database; determining whether the current age meets the set of merge criteria; and in response to a determination that the current age meets the set of merge criteria, merging the row from the write storage into the read storage.

Abstract: Compositions and methods are provided for use in binding opioids, such as 6-MAM, morphine, heroin, hydrocodone, oxycodone, meperidine, and fentanyl, while avoiding binding to OUD treatment agents, such as naloxone and naltrexone. Methods are also provided for use in a systematic structure-based virtual screening and design approach for identification of such antibodies. Methods are also provided for use in treating OUD. Methods are also provided for use in detecting an opioid in a sample.

Abstract: A water tank mounting structure and a ventilation treatment apparatus for such structure. The water tank mounting structure comprises a cavity for containing a water tank and a side wall defining the cavity, wherein the side wall comprises an inner side wall spaced apart from an outer side, a first gas hole provided in the inner side wall, and a second gas hole provided in the outer side wall, both holes arranged in a staggered manner perpendicular to the side wall. The arrangement of the double-layer side wall, and the first and second gas holes in the inner and outer side walls, respectively, allows for hot gas in the cavity to be effectively removed. The staggered arrangement of the gas holes allows for water to flow downward along the side wall without invading the cavity when water enters through the second gas hole. A waterproof effect is achieved.

Abstract: A method of treating opioid use disorder involves administering a selective butyrylcholinesterase (BChE) inhibitor.

Abstract: A method of treating pain is disclosed, which involves administering an effective amount of lapatinib or a pharmaceutically-acceptable salt thereof to a subject in need of treatment for pain.

Abstract: Intelligent merging for efficient updates in columnar databases are disclosed, including: determining a current age associated with a row in a database, wherein the database comprises a write storage and a read storage, wherein the row is located in the write storage; determining a set of one or more merge criteria based at least in part on a modification age distribution, wherein the modification age distribution is dynamically determined based at least in part on previous transactions at the database; determining whether the current age meets the set of merge criteria; and in response to a determination that the current age meets the set of merge criteria, merging the row from the write storage into the read storage.

Abstract: Efficient large column values storage in columnar databases is disclosed, including: providing a database comprising a write storage, a read storage, and an auxiliary storage, and wherein the auxiliary storage is used to store a large column value of a row that is associated with either the write storage or the read storage, wherein the large column value comprises a column value that meets a set of large column value criteria; and operating the database using the write storage, the read storage, and the auxiliary storage.

Abstract: The present disclosure provides systems and methods for an indexing system in databases. One method for locating a row in a row-group columnar storage database comprises: receiving a query to locate a target row in the row-group columnar storage database that comprises rows of data divided into one or more blocks of data having columns of data that correspond to the rows of data, and one or more block information tables having column information corresponding to the columns of data in the one or more blocks of data, each block information table of the one or more block information tables being associated with a corresponding block of data of the one or more blocks of data; and locating the target row using the column information from the one or more block information tables.

Abstract: The present disclosure provides systems and methods for prefetching data in databases. One method for prefetching data in a database comprises receiving a database query on the database, determining one or more sets of adjacent columns access by the database query, and for each set of adjacent columns of the one or more determined sets, prefetching data in the adjacent columns.

Abstract: Embodiments of the present disclosure provide methods and devices for inserting data in a database. The method can include caching one or more rows of data in a delta table in response to a request to insert the one or more rows in a destination table, wherein the destination table is one of a group of destination tables of a first database, and wherein the delta table contains requested changes of rows of the destination table, the changes being caused by a data operation; determining a priority of the destination table based on runtime information of the destination table relative to the group of destination tables; and scheduling the merging of the inserted rows from the delta table to the destination table based on the determined priority of the destination table. The destination table is in a format of a file storing one or more blocks, each block having a set of sequence of elements clustered from each column of the destination table.

Abstract: The presently-disclosed subject matter describes fusion proteins comprising butyrylcholinesterase (BChE) having an improved production yield and biological half-life and nucleotides encoding the same.

Abstract: Embodiments of the present disclosure provide methods and devices for formatting a database. The method can include clustering, into each block, a set of sequence of elements from each column of a database; generating a file storing one or more blocks having the clustered set of sequences of elements; providing a first table storing file schema information that associates the elements with the file; and providing a second table for storing block schema information that associates the columns with the one or more blocks.

Abstract: The present disclosure provides a method for generating a classification model in a database system. The method comprises generating a plurality of database tables by performing data clustering on a database, acquiring a plurality of queries associated with information from the database, generating training data by executing each of the plurality of queries on the plurality of database tables, and training a classification model using the training data, wherein the classification model is used to select a database table for a query based on corresponding performance information associated with the query on the database during executing of the query. The present disclosure also provides a method for executing a query on a database using a classification model. The method comprises obtaining the classification model, obtaining a database query, generating a target table by inputting the database query into the classification model, and executing the database query on the target table.

Abstract: A manufacturing method of a textured and coated electrode wire, comprising: selecting a copper-zinc alloy as a core material, preparing, by means of electroplating/hot-dipping, a metal zinc coating on a surface of the wire material, then performing pre-treatment on the coated electrode wire by means of discontinuous diffusion annealing to obtain a coated electrode wire material having a multi-layer structure of Zn/?-Cu ?-Cu/?-Cu, and then using multiple cold drawing treatments and a stress-relief annealing treatment to modify the electrode wire and obtain a textured and coated electrode wire material. Compared to conventional copper alloy electrode wires and zinc-coated electrode wires, the material has advantages of a fast cutting speed, low cutting cost, low environmental pollution, etc.

Abstract: A scale-style micro-texture electrode wire material and a preparation method therefor and use thereof. In particular, the electrode wire material has a scale-style micro-texture layer on the surface, and the electrode wire material comprises: i) an alloy substrate layer as an inner layer; ii) an interdiffusion layer as an intermediate layer; and iii) a plating layer as an outer layer; and a contact angle of the electrode wire material to a cooling liquid is 105-150°. A method for preparing the electrode wire material and a use thereof. Due to the special surface bionic structure, the electrode wire can obviously reduce the cutting resistance and improve the cooling speed, thereby improving the cutting speed and effectively improving the use performance of the electrode wire. The preparation method has the characteristics of simple process and easy for industrial production.