Method and system for generating dependencies in application-driven data generation supporting left outer join

Abstract

The invention discloses a method for generating dependencies in application-driven data generation that supports left outer joins, comprising the following steps: analyzing the state of the primary key, and calculating the query substring of the primary key column in the left outer join for a given database structure and original query statement The query result of the tree, mark the retained state of the primary key, and make statistics on the retained state of the primary key; calculate the primary key filtering ratio, calculate the primary key filtering ratio of each state according to the given left outer join constraint; fill the foreign key, randomly according to the filtering ratio Foreign keys are populated without duplication, and memory usage is compressed by overflowing files during processing. The invention also discloses a system for realizing the above method. Compared with the prior art, the present invention has the advantages of feature extraction, authenticity constraint and data compression.

Description

technical field [0001] The invention belongs to the field of database technology and data synthesis technology, and in particular relates to a method and system for generating dependency relationships in application-driven data generation supporting left outer joins. Background technique [0002] At present, with the development of the network and the popularization of personal terminals, the amount of data shows an obvious growth trend. At the same time, the demand for data analysis on e-commerce and social media network platforms is also increasing. In these new scenarios and new requirements, re-evaluating the performance of the database has become a new challenge that needs to be faced. In database performance evaluation, load generation is an important link. Whether it is for a new database component or a new data load, it is of great significance to simulate a database instance with the required load characteristics. [0003] An important requirement in generating t...

AI Technical Summary

Problems solved by technology

[0007] 1. It is difficult to meet the cardinality constraints in the data generation process, that is, to control the size of the intermediate result set, and it is often necessary to maintain a large and complex intermediate state

[0008] 2. The authenticity of the generated results is difficult to guarantee, and the generation efficiency is relatively low

Images