5 results about "Natural key" patented technology

This application discloses a data processing method, apparatus, device, and computer-readable storage medium. The method includes the steps of: acquiring collected data and generating a business primary key for the collected data; the business primary key having resource uniqueness; comparing the differences between the collected data and existing data based on the business primary key to obtain a comparison result; and processing the existing data accordingly based on the comparison result. This application enables accurate comparison of collected data and existing data through the business primary key, thereby regaining the ability to manage collected data and preventing collected data from slipping out of control.

The application discloses a multi-type property maintenance work order automatic generation and management method and system, and the method comprises the following steps: triggering a timing task according to the execution time of a maintenance plan, and judging whether the maintenance plan is overdue; when the maintenance plan is not overdue, creating a work order record and writing the work order record into a business data table, and starting a work flow instance with a business primary key in the same database transaction; the work flow instance triggers an execution listener in a node flow process, updates a work order processing state, and executes corresponding business logic according to a node identifier; a timing job record is written in a user task node, a work order timeout mark is updated and a timeout alarm is sent when a timeout deadline arrives, so that the work order automatic generation, process linkage and timeout control are realized.

This application provides a method, apparatus, device, and storage medium for verifying data table consistency. The method includes: acquiring first business primary key information and a first identifier corresponding to multiple first data tables in design states, and second business primary key information and a second identifier corresponding to multiple second data tables in production states; comparing whether the first business primary key information and the second business primary key information are consistent; for first data tables and second data tables with consistent business primary key information, comparing whether the first identifier and the second identifier are consistent; for first data tables and second data tables with consistent identifiers, comparing whether the fields of the first data table and the fields of the second data table are consistent; and determining the verification result of data table consistency based on the primary key information comparison result, the identifier comparison result, and the field comparison result. The verification method according to this application embodiment can automatically verify whether the structures of physical model tables and database tables are consistent and obtain relatively accurate verification results.

The application relates to the technical field of big data processing, and discloses an internet operation and sales data analysis method and system based on big data, which comprises the following steps: acquiring multi-source business data records and extracting business primary keys; based on the business primary keys, the multi-source business data records are collected into corresponding logical containers; the logical containers are subjected to integrity evaluation to determine whether the logical containers meet preset business logic integrity requirements; only when the business logic integrity requirements are met, is the associated analysis of the collected data in the logical containers triggered, and corresponding operation analysis conclusions are generated; when the logical containers receive new business data records, the operation analysis conclusions are corrected according to the new business data records. The application constructs an event-driven analysis unit through the business primary keys and the logical containers, solves the pseudo-association and missing-association problems caused by the inconsistent arrival times of multi-source data, and realizes accurate and dynamically-updatable operation insight.

A batch process operates on structured data in multiple tables, including a first and a second source table, and a first and a second processing table. An additional key is added within each natural key to at least the second source and processing table for identifying a sequence of rows for updating.