Method and system for generating dependencies in application-driven data generation supporting left outer join
A data generation, application-driven technology, applied in the field of database technology and data synthesis, can solve the problems of low efficiency, difficult to guarantee the authenticity of the generated results, difficult to meet the cardinality constraints, etc., to improve computing efficiency, efficient real-time generation performance, and achieve generation performance effect
- Summary
- Abstract
- Description
- Claims
- Application Information
AI Technical Summary
Problems solved by technology
Method used
Image
Examples
Embodiment
[0062] Primary key status statistics: According to the given query template and data table structure, first calculate the query subtree with the left outer join as the root node from the bottom up, and obtain the query result of the subtree. According to this result, you can get the query subtree in the data table Whether the primary key is removed during the query process, that is, the retention status of the primary key. Use a bitmap to describe the retention status of each column of the primary key, use T to indicate retention, and F to indicate discarding, and combine tuples with the same retention status to count the proportion and content of the whole, and the table is as follows figure 1 Shown in T1
[0063] Calculate the constraints of the left outer join: first compress the data. For example, assuming that the left outer join only considers the status columns C1 and C2, the status column C3 can be compressed, and the data of the same items in the first two columns ca...
PUM
Abstract
Description
Claims
Application Information
- R&D Engineer
- R&D Manager
- IP Professional
- Industry Leading Data Capabilities
- Powerful AI technology
- Patent DNA Extraction
Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.
© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com