Abstract: There are provided a method, device, and storage medium for processing a data table. The method includes: performing an equivalent join on a left table and a right table in two data tables that are to be joined by a hash join, and acquiring first associated data of an association between the left table and the right table; filtering the first associated data according to a predetermined non-equivalent filtering condition, and determining second associated data satisfying the predetermined non-equivalent filtering condition in the first associated data; identifying, in a predetermined data structure according to a target join type of the two data tables; and processing the left table and/or the right table according to the target join type of the two data tables and the predetermined data structure to generate a target join table.

Abstract: The present disclosure provides a data reading method and device for a database and storage medium, which includes: receiving a query condition for a Value column in an LSM-Tree database; querying first alternative data with Value meeting the query condition from the LSM-Tree database; constructing a right table according to Key of the first alternative data, taking total data in the LSM-Tree database as a left table, and carrying out Semi Join based on the left table and the right table, so as to acquire second alternative data matched with each Key of the right table from the left table; querying target data with Value meeting the query condition from the second alternative data. The present disclosure can realize a predicate pushdown function of an LSM-Tree database in Merge-On-Read scene, in which, a large amount of data scanning is avoided while write performance and query performance are balanced.

Abstract: The present application discloses an index query method, apparatus, and device based on a database, wherein index optimization is performed for a read-only scenario. The method includes: determining a page identification corresponding to a target key in a data query request based on a hash value of the target key; obtaining a page index file corresponding to the page identification, wherein the page index file has a page index structure, the page index structure includes an entry array, a chunk bitmap and a length array, the entry array includes entry data of the page index file, and the entry data is sorted in an order of buckets to which the entry data belong and in an order of the entry data in the buckets; and querying, in the page index file, whether there is a value corresponding to the target key.

Abstract: The present application discloses a data processing method and an apparatus based on a columnar storage database and a device, which are used for improving performance of data writing in a scenario where a database has data loss. The method comprises: storing, for a target column in a data table, a line loss identification of the target column by using a bitmap corresponding to the target column, wherein each bit of the bitmap corresponds to whether each line of the target column has data loss, and the target column is any column in the data table; storing actual data included in the target column; receiving a data read request, wherein the data read request includes a column; and establishing, in a memory, a memory structure of the column based on a bitmap corresponding to the column and actual data included in the column.

Abstract: Embodiments of the present application provide a data processing method for a data service system based on a read-write separation architecture, an electronic device, and a computer-readable storage medium, wherein the method includes: receiving a data read request sent by a client, constructing a query plan corresponding to the data read request and generating a data direct read indication; sending the query plan and the data direct read indication to a query server of the data service system, where the data direct read indication is used to indicate reading data in a write server of the data service system; and responding to the data read request according to data obtained by executing, by the query server, the query plan and the data direct read indication.

Abstract: An electrode assembly, a battery, and an electric device. The electrode assembly includes a first electrode, a second electrode, a first separator, and a second separator. One of the first separator and the second separator is disposed between the first electrode and the second electrode. The other of the first separator and the second separator is disposed on a side that is of the first electrode or the second electrode and that faces away from the first separator. One of the first separator and the second separator does not include a porous coating. The other of the first separator and the second separator includes a porous coating. The thickness of the porous coating is 0.5 ?m to 8 ?m. The electrode assembly in the present application includes a specific first separator and a specific second separator, which can effectively improve cycling performance of the battery.

Abstract: A materialized view construction method, a device, and a medium in a database system are provided. The method includes: receiving a materialized view construction request for a target base table; determining whether the materialized view construction request satisfies a preset construction condition after determining that the target base table belongs to a target type; and constructing a materialized view of the target base table based on a target query statement when determining that the materialized view construction request is executable.

Abstract: Embodiments of the present disclosure provide a database processing method and device and a storage medium. The method includes: receiving an operation instruction for a database, and determining whether dictionary-based optimization is enabled for a target column associated with the operation instruction; in response to determining that the dictionary-based optimization is enabled, obtaining a dictionary corresponding to the target column, wherein the dictionary includes a mapping relationship between a value included in the target column and a corresponding replacement value; encoding the target column based on the dictionary to replace the value included in the target column with the corresponding replacement value; and converting, based on the dictionary, the operation instruction into an operation instruction corresponding to the encoded target column, executing the converted operation instruction, and decoding an operation result based on the dictionary.

Abstract: Connectors to a set of differential transmit signal contacts for multiple lanes of a communications link may incur signal crosstalk between adjacent lanes. Similar signal crosstalk at the other end of the communications link may be incurred by connectors to a set of differential receive signal contacts. The connector arrangement may provide opposite polarities to the signal crosstalk contributions at opposite ends of the link, creating a substantial reduction in crosstalk.

Abstract: A protein scaffold capable of carrying radioactive signals and application thereof in antibody detection are provided. The present disclosure successfully finds out a protein scaffold R12 capable of carrying radioactive signals, which is used for assisting part of antigens to capture corresponding antibodies; and because the method is used for carrying signals and eliminating more severe screening conditions of cross reaction in the screening process, the method is not limited to the method in application, and the method can be directly used for a technical platform which only needs to eliminate the cross reaction.

Abstract: A protein scaffold capable of carrying radioactive signals and application thereof in antibody detection are provided. The present disclosure successfully finds out a protein scaffold R12 capable of carrying radioactive signals, which is used for assisting part of antigens to capture corresponding antibodies; and because the method is used for carrying signals and eliminating more severe screening conditions of cross reaction in the screening process, the method is not limited to the method in application, and the method can be directly used for a technical platform which only needs to eliminate the cross reaction.

Abstract: The present disclosure provides a data reading method and device for a database and storage medium, which includes: receiving a query condition for a Value column in an LSM-Tree database; querying first alternative data with Value meeting the query condition from the LSM-Tree database; constructing a right table according to Key of the first alternative data, taking total data in the LSM-Tree database as a left table, and carrying out Semi Join based on the left table and the right table, so as to acquire second alternative data matched with each Key of the right table from the left table; querying target data with Value meeting the query condition from the second alternative data. The present disclosure can realize a predicate pushdown function of an LSM-Tree database in Merge-On-Read scene, in which, a large amount of data scanning is avoided while write performance and query performance are balanced.

Abstract: The present disclosure relates to a data processing method, a medium and an electronic device for a database. The method includes: obtaining a first execution statement for performing a target operation; reading, when a data source corresponding to the first execution statement includes first data corresponding to a committed transaction and second data corresponding to an uncommitted transaction, a materialized view obtained after performing the target operation on the first data as a target materialized view from a pre-created materialized view set; reading the second data and performing the target operation on the second data to obtain operation result data; performing data merging processing on the target materialized view and the operation result data to obtain merged data; and performing the target operation on the merged data to obtain an execution result corresponding to the first execution statement.

Abstract: The present disclosure relates to a database-based data processing method, device, medium, and apparatus, the method including: receiving a target query statement; determining a corresponding target materialized view for executing the target query statement according to a data query time corresponding to the target query statement and a time granularity of the materialized view in a database, wherein the database is constructed with the materialized view at different time granularities; rewriting the target query statement according to the time granularity of the target materialized view to obtain a plurality of target sub-query statements, wherein the target sub-query statements include sub-query statements which are queried based on the target materialized view; and merging the target sub-query statements, and performing a data query according to a query statement obtained by merging.

Abstract: There are provided a method, device, and storage medium for processing a data table. The method includes: performing an equivalent join on a left table and a right table in two data tables that are to be joined by a hash join, and acquiring first associated data of an association between the left table and the right table; filtering the first associated data according to a predetermined non-equivalent filtering condition, and determining second associated data satisfying the predetermined non-equivalent filtering condition in the first associated data; identifying, in a predetermined data structure according to a target join type of the two data tables; and processing the left table and/or the right table according to the target join type of the two data tables and the predetermined data structure to generate a target join table.

Abstract: Technologies are provided for circuit topology detection in an electric power circuit. In some embodiments, a computing device can access phasor data associated with the electric power circuit including an arrangement of switching devices and multiple phasor measurement units. The computing device also can access threshold data defining individualized zero-current threshold values for respective ones of the multiple phasor measurement units. The computing device can determine one or more zero-current branches present in the arrangement of switching devices by applying the individualized zero-current thresholds to the accessed phasor data. The computing device can further determine, based on the one or more zero-current branches a circuit topology corresponding to the arrangement of switching devices.

Abstract: The present disclosure relates to systems, non-transitory computer-readable media, and methods for, within a transportation matching system, identifying a threshold deviation angle or a threshold deviation radius, determining a directional filter, and providing a transportation match probability indicator based on the directional filter. In particular, in one or more embodiments, the disclosed systems provide a deviation angle control element or a dispatch radius control element for selectively designating the threshold deviation angle or the threshold deviation radius. In one or more embodiments, the disclosed systems update the transportation match probability indicator based on user manipulation of the deviation angle control element or the dispatch radius control element.

Abstract: An end cap assembly, a battery cell, a battery, an electrical device, and a method and device for manufacturing a battery cell are provided. The end cap assembly includes an end cap and a pressure relief mechanism. The pressure relief mechanism is connected to the end cap. The pressure relief mechanism is configured to: keep in a first pressure relief state when an internal pressure or temperature of the battery cell is greater than or equal to a first threshold and less than a second threshold, so as to release the internal pressure of the battery cell; and keep in a second pressure relief state when the internal pressure or temperature of the battery cell is greater than or equal to the second threshold, so as to release the internal pressure of the battery cell.