Unlock instant, AI-driven research and patent intelligence for your innovation.

Solution for integrity of data in decision support system

A decision support system and data integrity technology, applied in the field of data integrity, can solve problems such as not being able to solve a large number of text data comparisons well, and achieve the effect of reducing workload

Inactive Publication Date: 2014-06-04
DALIAN LINGDONG TECH DEV
View PDF3 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] Therefore, when the system is collecting data, the data related to water conservancy projects are stored in the excel file in the form of text, and the integrity check of the data is required before the data is imported into the database. The data integrity check is an unordered data Comparison sorting problem, in which the data integrity check of primary key and foreign key is a comparison sorting problem, and the optimal time complexity of comparison sorting is o(nlogn), which cannot solve the comparison of a large amount of text data well

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Solution for integrity of data in decision support system
  • Solution for integrity of data in decision support system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0030] The present invention will be further described below in conjunction with the accompanying drawings. The algorithm mainly adopts the idea of ​​divide and conquer, links related tables, and uses the primary key of the previous table as a bucket for the comparison between the primary key of the next table and the external key. The algorithm is described as follows:

[0031] Step 0: According to the table structure of the database, establish such as figure 1 The storage structure of the tree relationship

[0032] Step 1: For the data table of the 0-layer node, use the comparison and sorting algorithm with a time complexity of o(nlogn) to sort. If the same data item appears, output the wrong result to the file. Create buckets with sorted data as key values.

[0033] Step 2: For the data table of the leaf node of layer 1, according to the bucket generated in step 1, load the primary key of the table into the bucket. If it is found that the bucket does not exist during th...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention discloses a solution for integrity of data in a decision support system. The solution comprises the following steps that integrity of the data in the data collection process is described through a bucket sorting algorithm; expression of a database topological structure is carried out; related tables are connected, and a primary key of a previous table serves as a bucket which is used for comparison between a primary key of a next table and an external key. According to the solution for integrity of the data in the decision support system, due to the fact that the bucket sorting algorithm is used for carrying out algorithm description of data integrity checking, time complexity of the bucket sorting algorithm is reduced to o (N), massive original data which are stored in a text mode can be input into a database, and data integrity constraint checking is automatically achieved; due to the fact that the bucket sorting algorithm is used for accomplishing integrity checking, difficulty of processing of the massive data is lowered, the time for processing of the massive data is shortened, and the operating cost of the decision support system is reduced.

Description

technical field [0001] The invention relates to a method for solving data integrity, in particular to a method for solving data integrity in a decision support system. Background technique [0002] In recent years, data acquisition and its application technology have received more and more attention from people, and data acquisition systems have also been applied rapidly. In scientific research, a large amount of dynamic information can be obtained by using a data acquisition system, which is a powerful tool for studying instantaneous physical processes and one of the important means for obtaining scientific mysteries. The more timely the data collection and processing, the higher the work efficiency and the better the results. In the flood control system, there are many types of flood control projects, with large functional differences, wide coverage, large geographical differences, and large spans of longitude and latitude. There are both commonality and individuality amo...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
CPCG06F16/25G06F16/27Y02A10/40
Inventor 刘博梅昱婷
Owner DALIAN LINGDONG TECH DEV