33 results about "Identity column" patented technology

The invention discloses a database query optimization method and equipment. The method includes: receiving a first query command, the first query command includes at least first and second query statements, the second query statement obtains a second query result from a second table, and the first query statement passes the second query statement result and the first filter condition to obtain the first query result from the first table, the first and second tables point to the same basic table in the database; generate the definition statement of the third table based on the second query statement, the third table The table is used to store the third query result, the third query result includes at least one of the first query result and the data value on the record identification column; and the definition statement is used to replace the second query statement, and based on the first Use three tables to rewrite the first query statement, so as to convert the first query command into a second query command. Therefore, the present invention can realize data query operation with lower calculation cost.

The invention discloses a secure communication system for improving a software defined network. The secure communication system comprises an application layer, a secure communication service layer, acontrol layer and a forwarding layer, wherein the application layer comprises a plurality of clients, and the clients are used as request clients or target clients; and the security communication service layer is provided with a security database, and the security database stores a client identity identifier list, a security communication service layer public and private key pair, a plurality of client public keys and a plurality of client network addresses. The problem that privacy is prone to leakage due to the fact that information and data of an existing software-defined network are spreadon the network in a plaintext mode can be solved. The external malicious invasion is easily caused by programmability of a software-defined network, and the like.

The present invention provides a distributed massive data processing method and device, comprising: sending an index request to a metadata server; receiving a list of available servers returned by the metadata server; splitting the original data to be indexed to obtain the split Block data, and assign a digital number to the block data; use the block information of the block data as the key value, map the storage location of the block data to the list of available server identifiers; The block data is sent to the second data index server to store the block data; and the index completion information returned by the metadata server is received. Using the above method and device, multiple second data index servers can store the received block data at the same time, which greatly improves the storage efficiency, and the search of the stored original data can be completed through the index completion information, Greatly improved the retrieval efficiency.

The invention discloses a method and a device of realizing data updating at an OLAP (Online Analytical Processing) database. The method includes: adding a row identifier column and a time stamp columnin a data table, wherein the row identifier column is used for recording a row identifier of each row in the data table, and the time stamp column is used for recording modification time of each rowin the data table; determining a to-be-modified row in the data table when a modification instruction is received; modifying the to-be-modified row according to the modification instruction, and writing current modification time into the time stamp column of the to-be-modified row to generate a first newly-added row; inserting the first newly-added row into the data table; when a data reading instruction is received, obtaining at least one result row in the data table according to the data reading instruction, acquiring a row, which corresponds to each row identifier and has most recent modification time, in the at least one result row to form a result table, and returning, to a user, parts in the result table after removing the row identifier column and the time stamp column. The invention also discloses a method and a device of realizing a data snapshot at the OLAP database.

The invention discloses a file query method, system, and computer-readable storage medium. The method includes the steps of: after the first terminal receives an acquisition instruction for acquiring files in the database sent by the second terminal, acquire all files in the database according to the acquisition instruction. Store the attribute information of the file, and store the attribute information in the memory; generate the identification list of the file according to the attribute information, and send the identification list to the second terminal; after receiving the query instruction sent by the second terminal according to the identification list, Find out the corresponding attribute information from the memory according to the query instruction and send it to the second terminal, so that the second terminal can receive the attribute information and display the corresponding file according to the attribute information. The present invention realizes that when the second terminal needs to display the files stored in the first terminal, it does not need to inquire the database of the first terminal every time a file is displayed, and improves the efficiency of the second terminal in displaying the files of the first terminal.

Embodiments of the present invention provide a method for handover between public land mobile network identifications, a base station, and a communications network, so that a base station can control user equipment to be handed over between PLMN identifications. The method for handover between PLMN identifications includes: acquiring, by a base station, a first PLMN identification list, where the first PLMN identification list is configured by the base station and is used for indicating a handover allowed PLMN identification corresponding to each first identification currently supported by the base station, and the first identification includes one or more of a base station identification, an operator identifier, and a cell identifier; and controlling, by the base station according to the first PLMN identification list, user equipment to be handed over between PLMN identifications, where the handover between the PLMN identifications includes network handover and network redirection. The method for handover between public land mobile network identifications, the base station, and the communications network provided in the embodiments of the present invention are used for handover between public land mobile networks.

The present application discloses a method and device for automatically checking data matching. The method includes: reading the path information of the preset stored basic data table and the path information of the stored voice graphic identification list, and obtaining the basic data table and the voice graphic identification respectively. list, extract the first voice data identifier and the first graphic data identifier associated with the basic data contained in the basic data table, and the second voice data identifier and the second graphic data identifier contained in the voice graphic identifier list, and convert the first The voice data identifier and the first graphic data identifier are matched with the second voice data identifier and the second graphic data identifier respectively, and data matching is automatically checked according to the matching result. Through the above method, the efficiency of automatic checking of data matching can be effectively improved, and the accuracy rate of automatic checking of data matching can also be improved.

The invention provides a data de-identification method, a data de-identification device and a non-volatile computer-readable storage medium for executing the data de-identification method. The data de-identification method includes: obtaining original data, wherein the original data includes an identity column, a condition field, and a record field, obtaining situational conditions according to the condition field, and obtaining multiple identification data and situational conditions according to the identity column records, from Acquiring context segment sequences corresponding to each identification data that meet the context conditions from the original data, obtaining sequence data according to the identification data and the context segment sequences corresponding to the identification data, and adjusting the sequence data to obtain de-identified data.

The invention provides a data consistency verification method, device, electronic equipment and readable storage medium, and relates to the field of computer technology. After the same sorting process, take out the first elements of the two record lists and compare their unique identifier sizes until there are no remaining elements in either list, and put the first element with the largest unique identifier back into the original queue. The first element with the smallest unique identifier is classified into the verification result table to realize data consistency verification for each element in the two record lists. The verification result table includes: only the elements in the first record list The first result of the , the second result of only elements in the second record list. The problem of difficult data verification in the prior art when the data in the target database and the source database are not exactly the same is solved.

The application discloses a load balancing method, device and system. A specific implementation of the method includes: for each server in the server cluster, determine the topic of the message that the server is responsible for processing, and determine the identification of the client that has established a connection with the server and subscribed to the message of the topic, so as to generate At least one identification list corresponding to the server and divided according to the topic; for each generated identification list, extracting a preset identification list corresponding to the identification list, and in response to determining that the identification list is consistent with the preset identification list No match, update the identification list based on the preset identification list; analyze the IP address of the client indicated by the identification in the updated identification list to generate a target identification set; send each generated target identification set to the storage server. This embodiment improves the efficiency of establishing a connection and improves the stability of the connection.

The invention discloses a method for determining an access domain and an auxiliary method for determining the access domain. The method for determining the access domain includes: receiving an invitation INVITE message including the target identifier of the called user; according to the target identifier and the stored user identifier list registered in the long-term evolution voice bearer VoLTE network, obtain the called user in the VoLTE network Registration information; if the registration information is a registered state, it is determined that the called user's access domain is an Internet Protocol Multimedia Subsystem IMS domain; if the registration information is an unregistered state, it is determined that the called user's access domain is a circuit switched CS domain; Wherein, the user identification list is updated according to the IMS deregistration request or IMS registration request actively sent by the user terminal, and the IMS deregistration request or IMS registration request is sent by the user terminal according to the result of its own network switching. According to the method for determining the access domain and the auxiliary method for determining the access domain provided in the embodiments of the present invention, the determination of the access domain can be quickly realized.

The present application relates to a knowledge graph-based event data processing method, device, device, and medium. The method includes: obtaining query conditions; using the query conditions to filter and call the word pointer array of the event intelligence knowledge graph, and locate the word pointer array corresponding to the query condition Target array element; using the event pointer array of the event intelligence knowledge map, match each element in the event identification list corresponding to the target linked list element, and obtain the target second linked list corresponding to the matched event identification, to indicate that the event to be retrieved is in the event The element information of the corresponding target event intelligence in the intelligence knowledge graph. The event intelligence knowledge graph includes event entities, time entities, location entities, person entities, cause entities, process entities, and result entities. The relationship types of the graph include time description relationships, location description relationships, participation description relationships, and development description relationships. It can reliably complete the analysis and processing of event intelligence data.