Detecting multi-column composite key column sets

A column set and composite key technology, which is applied in the detection field of multi-column composite key column sets, can solve problems such as constraint errors and undetectable multi-column unique key sets

Active Publication Date: 2014-03-12
INT BUSINESS MASCH CORP
View PDF6 Cites 4 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The disadvantage of this method is that it cannot detect all existing multi-column unique key sets
In addition, such manually restricted constraints may generate errors in case of further insertion into the database of data records comprising combinations of already existing property values

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
  • Detecting multi-column composite key column sets
  • Detecting multi-column composite key column sets

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0116] Those skilled in the art will appreciate that aspects of the present invention can be implemented as a system, method or computer program product. Accordingly, aspects of the invention may take the form of an entirely hardware implementation, an entirely software implementation (including firmware, resident software, microcode, etc.), or an implementation combining software and hardware aspects, all of which may collectively be referred to as a "circuitry" ", "module" or "system". Additionally, aspects of the invention may take the form of a computer program product embodied on one or more computer-readable media having computer-readable program code embodied thereon. Any combination of one or more computer readable medium(s) may be utilized. The computer readable medium may be a computer readable signal medium or a computer readable storage medium. A computer-readable storage medium may be, for example, but not limited to, an electronic, magnetic, optical, electromag...

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

An aspect includes a computer-implemented method for detecting one or more multi-column composite key column sets. The method includes accessing(102) a plurality of first columns(P1-P3), each first column representing a parameter, each first column including a set of distinct parameter values of its respective parameter, each distinct parameter value being stored in association with one or more object identifiers. Two or more of the first columns are selected(104) for use as a current candidate column set, the current candidate column set including at least a first and a second candidate column (112), the current candidate column set being of a current cardinality. The method also includes determining(106), by comparing object-identifiers, whether for the current candidate column set at least one couple of parameter values(219) exists with parameter values respectively stored in association with two or more shared ones of the object identifiers to identify a multi-column composite key column set.

Description

technical field [0001] The present invention relates to the field of data processing, and more particularly to the detection of multi-column composite key column sets. Background technique [0002] In the field of data modeling and data analysis, a common problem is to determine the combination of parameters, where the combination of individual parameter values ​​is unique for each individual data record in the database. The determination of such a unique combination of parameters allows specifying an index structure derived from the parameter values ​​of said unique combination of parameters. Knowledge of the index structure and / or of the unique parameter combination allows to improve the performance of query optimization in the database and thereby increase the speed of data retrieval and data analysis. One of the most common types of databases used to store large amounts of data for production or analysis purposes is the relational database management system, where the "...

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
CPCG06F17/30979G06F17/30336G06F16/2272G06F16/22G06F16/90335
Inventor M·奥博霍费尔Y·萨耶S·内尔克J·赛菲特
Owner INT BUSINESS MASCH CORP
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap