3 results about "Pooled data" patented technology

This invention discloses an adaptive multi-table data normalization method based on RPA and OCR technologies. Using RPA tools and OCR technology, this invention can synchronously adjust the corresponding data content in the "Floating Summary" and "Normal Transfer" sub-tables of the summary table after the client modifies the data. Then, it performs data aggregation and merging on the two sub-tables separately. Finally, after confirming that the data does not need modification, the data in the summary table is finally aggregated and merged into the group's audit standard notes to the financial statements, thereby generating an audit report. This invention achieves automated merging and aggregation processing of massive amounts of single-file data through RPA and OCR technologies. Under the premise of intelligently identifying basic data table information, quickly matching and capturing data, and accurately summarizing data, it achieves the normalization and reverse writing of audit standard notes to the financial statements, solving the problems of traditional manual data aggregation and merging methods, which may result in aggregation errors, large workloads, and high labor costs due to repeated data adjustments and modifications.

This application discloses a data query method, apparatus, device, and storage medium. The method includes: establishing a target data table in a target database, the target data table including all field attributes from at least two source data tables; merging data from at least two source data tables to obtain merged data; inserting the merged data into the target data table; obtaining a first operation on the data in the source data tables, wherein the first operation includes at least one of an add operation, a modify operation, and a delete operation; generating a target operation based on the first operation; and executing the target operation, which is an operation on the target data table used to synchronize the data in the target data table with the data in the source data tables; and performing a data query based on the target data table. According to the embodiments of this application, the speed of data query can be improved.

This invention relates to the field of enterprise management technology, specifically to a big data-based enterprise financial shared assessment method and system, comprising the following steps: acquiring and sorting procurement and acceptance data for cumulative comparison; determining settlement quantities based on amount and unit price to screen discrepancy nodes; locating acceptance intervals and associating them with cost centers and suppliers; combining multiple time periods to divide segments and merge data; and associating business segments with cost categories to calculate indicators. In this invention, by constructing a continuous sequence around acceptance time and quantity and performing cumulative verification, introducing settlement amount and unit price to derive quantity identifiers and identify discrepancy nodes, extracting acceptance segments by procurement batch and time interval and fusing associated identifiers, and dividing business segments according to multiple time nodes for integration and mapping, business events are aligned and linked within a unified time framework, strengthening data continuity and node traceability capabilities, improving anomaly identification capabilities and segment attribution consistency, and enhancing the stability and analytical consistency of assessment results.