CN102063434B - Candidate key capture device and candidate key capture method - Google Patents
Candidate key capture device and candidate key capture method Download PDFInfo
- Publication number
- CN102063434B CN102063434B CN200910222294.1A CN200910222294A CN102063434B CN 102063434 B CN102063434 B CN 102063434B CN 200910222294 A CN200910222294 A CN 200910222294A CN 102063434 B CN102063434 B CN 102063434B
- Authority
- CN
- China
- Prior art keywords
- attributes
- data
- combinations
- candidate key
- attribute
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Expired - Fee Related
Links
- 238000000034 method Methods 0.000 title claims abstract description 27
- 239000008280 blood Substances 0.000 description 47
- 210000004369 blood Anatomy 0.000 description 47
- 238000004590 computer program Methods 0.000 description 8
- 238000001914 filtration Methods 0.000 description 7
- 238000010586 diagram Methods 0.000 description 3
- 230000006870 function Effects 0.000 description 3
- 238000010606 normalization Methods 0.000 description 3
- 241000208340 Araliaceae Species 0.000 description 1
- 235000005035 Panax pseudoginseng ssp. pseudoginseng Nutrition 0.000 description 1
- 235000003140 Panax quinquefolius Nutrition 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 235000008434 ginseng Nutrition 0.000 description 1
- 238000012423 maintenance Methods 0.000 description 1
- 238000012216 screening Methods 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Images
Landscapes
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention relates to a candidate key capture device and a candidate key capture method. The candidate key capture device comprises a microprocessor and a storage unit, wherein the storage unit is used for storing a data table which is loaded with a data number of the data table, a plurality of attributes, data difference numbers of the attributes and data types of the attributes; and the microprocessor is used for generating a candidate key according to the data number, the data types and the data difference numbers.
Description
Technical field
The invention relates to a kind of Candidate Key capture device and Candidate Key acquisition method.The invention relates to specifically a kind of information that can be contained according to a tables of data, produce Candidate Key capture device and the Candidate Key acquisition method of a Candidate Key.
Background technology
Along with the arriving of digital times, the storage of data develops the digitizing record by the mode of traditional hard copy record, and for storing a large amount of digitized data, and therefore database also accumulates and educate and give birth to.Be the effectively stored data of management database, the work that information personnel often must be integrated and analyze wanting storage data first produces the tables of data of a tool logical relation, to make things convenient for later use and maintenance.
Take the master data that stores all students of school as example, class, sex and blood group that tables of data may hundreds of students of record etc. information, the huge of its data volume well imagined.Generally speaking, be convenient follow-up effective management, information personnel can carry out tables of data first a series of normalization (normalization) to be processed, and its purpose is to avoid the data in the tables of data to duplicate or mutual conflicting situation, can help tables of data to be easy to use and safeguard simultaneously.Yet normalization process must begin by the Candidate Key of tables of data to carry out, and so-called Candidate Key briefly is exactly the identification pointer of distinguishing different pieces of information.
For example, table 1 is a tables of data of record student master data, its be loaded with 4 students' " student number " and " sex ", and " student number " of table 1 and " sex " can be considered as respectively an attribute of table 1, Candidate Key then is to pick out in the various combinations of attributes by tables of data.
| 1 | 2 | 3 | 4 | |
| Student number | A001 | A002 | A003 | A004 |
| Sex | The woman | The woman | The man | The woman |
Table 1
Particularly, table 1 has " student number ", " sex " and " student number+sex " three kinds of attribute combinations, the Candidate Key of table 1 must be by picking out in aforementioned three kinds of attributes combination, and must satisfy uniqueness and minimality, uniqueness refers to that all aspect numbers that a combinations of attributes presents need more than or equal to the contained data stroke count of tables of data, take table 1 as example, it is loaded with 5 data, and every student all has different student numbers, combinations of attributes " student number " has 5 kinds of aspects at least, therefore be enough to distinguish each contained data of table 1 according to " student number ", and combinations of attributes " student number " is to satisfy uniqueness.
In like manner, combinations of attributes " student number+sex " can present 4 kinds of aspects at least, also meet the requirement of uniqueness, but the aspect that combinations of attributes " sex " can present only has 2 kinds (not being that " woman " is exactly " man "), stroke count (4) less than the contained data of table 1, therefore combinations of attributes " sex " does not then meet the requirement of uniqueness, builds outside the possibility list in the candidate disallowable.In addition, after combinations of attributes " student number+sex " and combinations of attributes " student number " meet the requirement of uniqueness, next just must carry out the judgement of minimality.
Minimality refers to that the number that combinations of attributes comprises attribute needs the smaller the better, from the above, combinations of attributes " student number " and combinations of attributes " student number+sex " have met uniqueness all, but combinations of attributes " student number+sex " is to comprise " student number " and " sex " two attributes, and combinations of attributes " student number " only comprises " student number " this attribute, therefore need have under the requirement of minimality in Candidate Key, combinations of attributes " student number+sex " is with the disallowable Candidate Key that not can be used as, combinations of attributes " student number " is then because meeting simultaneously the requirement of uniqueness and minimality, so combinations of attributes " student number " then can be considered the Candidate Key of table 1.But prior art is to seek the Candidate Key of tables of data by the judgement of uniqueness and minimality with manual type, and this not only makes the acquisition of Candidate Key lack efficient, and the probability that more may correctly capture because information personnel is lacked experience Candidate Key reduces.
In view of this, how to make the Candidate Key acquisition more precisely and have more efficient, the real problem of needing solution for the operator in this field badly.
Summary of the invention
A purpose of the present invention is to provide a kind of Candidate Key capture device.This Candidate Key capture device comprise a storage element and one and this storage element be the microprocessor of electric connection.This storage element is in order to storing a tables of data, and this tables of data is loaded with a data stroke count of this tables of data, a plurality of attribute, respectively a data phase heteromerism and the data type of this attribute respectively of this attribute.This microprocessor produces one first combinations of attributes in order to according to respectively data type and these attributes of this attribute, and this first combinations of attributes comprises at least one selected attribute, this at least one selected attribute be these attributes one of them.This microprocessor is more than or equal to this data stroke count in order to a product of the data phase heteromerism of at least one selected attribute of judging this first combinations of attributes also, and producing a judged result according to a quantity of at least one selected attribute of this first combinations of attributes, it is a Candidate Key that this microprocessor is set this first combinations of attributes according to this judged result.
Another object of the present invention is to provide a kind of Candidate Key acquisition method for aforementioned Candidate Key capture device.This Candidate Key acquisition method comprises the following step: (a) make this microprocessor basis respectively data type and these attributes of this attribute, produce one first combinations of attributes, this first combinations of attributes comprises at least one selected attribute, this at least one selected attribute be these attributes one of them; (b) making the product of data phase heteromerism of at least one selected attribute of this first combinations of attributes of this microprocessor judges is more than or equal to this data stroke count; (c) make this microprocessor produce a judged result according to a quantity of at least one selected attribute of this first combinations of attributes; And (d) make this microprocessor according to this judged result, setting this first combinations of attributes is a Candidate Key.
In addition, for reaching the described purpose of leading portion, the present invention also provides a kind of computer program product, interior storage is a kind of in order to carry out the program of aforementioned Candidate Key acquisition method, this program can be carried out the multiprogram instruction after being loaded this Candidate Key capture device by computer, to finish the described Candidate Key acquisition method of leading portion.
In sum, Candidate Key capture device of the present invention, Candidate Key acquisition method and computer program product thereof can be according to the data stroke count of tables of data and the data types of each attribute, elder generation's filtering can not become the combinations of attributes of Candidate Key, then, again according to the data phase heteromerism of each attribute, the selected attribute number that the data stroke count that tables of data is contained and combinations of attributes comprise, by capturing Candidate Key in the combinations of attributes after the filtering, therefore the present invention can intercept out Candidate Key accurately with in effectively being made up by many pen attributes, select the error that Candidate Key is produced to reduce by manual type, the shortcoming of prior art gets and is effectively overcome by this.
Description of drawings
Behind the embodiment of consulting accompanying drawing and describing subsequently, affiliated technical field has knows that usually the knowledgeable just can understand other purpose of the present invention, advantage and technological means of the present invention and implement aspect, wherein:
Fig. 1 is the schematic diagram of the first embodiment of the present invention; And
Fig. 2 A to Fig. 2 E is the process flow diagram of the second embodiment of the present invention.
Embodiment
Below will explain content of the present invention by embodiment, and the invention relates to a kind of Candidate Key capture device, Candidate Key acquisition method and computer program product thereof, it is according to information contained in the tables of data, captures a Candidate Key.It should be noted that, embodiments of the invention are not limited to specific environment, use or enforcement, and therefore, the description of following examples is not restriction of the present invention only for the purpose of illustration.Should be noted that, in following examples and the accompanying drawing, omit and do not illustrate with the non-directly related assembly of the present invention; And each interelement size relationship is only for asking easy understanding in the accompanying drawing, and is non-in order to limit actual ratio.
The first embodiment of the present invention as shown in Figure 1, it is a kind of schematic diagram of Candidate Key capture device 1, Candidate Key capture device 1 comprises a storage element 11 and a microprocessor 13, storage element 11 is electric connection with microprocessor 13.Candidate Key capture device 1 reads a tables of data 2 from the outside, and tables of data 2 is stored in storage element 11.Tables of data 2 is loaded with a data phase heteromerism of a data stroke count of tables of data 2, a plurality of attribute, each attribute, a data type of each attribute and an expression figure place of each attribute.
For convenience of description, the tables of data 2 of the present embodiment can be the tables of data such as table 2 record student master data, and tables of data 2 has 5 data stroke counts, 4 kinds of attributes (i.e. " sex ", " blood group ", " photo " and " student number ").The data type of attribute " sex " is character string, and the expression figure place is 1, and data phase heteromerism is 2; The data type of attribute " blood group " is character string, and the expression figure place is 2, and data phase heteromerism is 4; The data type of attribute " photo " is the large object of binary (Binary Large Object; Call BLOB in the following text) picture file, the expression figure place be 2, data phase heteromerism is 5; The data type of attribute " student number " is character string, and the expression figure place is 6, and data phase heteromerism is 5.
| Sex (1) | Blood group (2) | Photo (2) | Student number (6) | |
| 1 | The man | A | imgA001 | A001 |
| 2 | The man | B | imgA002 | A002 |
| 3 | The woman | AB | imgA003 | A003 |
| 4 | The woman | B | imgA004 | A004 |
| 5 | The woman | O | imgA005 | A005 |
Table 2
When initial start-up, Candidate Key capture device 1 is processed because not yet carrying out any Candidate Key acquisition, the Candidate Key that does not have any tables of data 2 exists, and accordingly, microprocessor 13 will produce one first combinations of attributes according to data type and these attributes of each attribute first.Specifically, microprocessor 13 elder generations are according to the data type of each attribute, filtering can not be as the attribute of Candidate Key, such as in order to store BLOB file and the large obj ect file of character (the Character Large Object of the files such as picture, sound, image, compressed file; Call CLOB in the following text), may be as the first combinations of attributes of Candidate Key to produce according to screening attribute later.
According to the above, microprocessor 13 is the attribute " photo " of BLOB with data type in the filtering table 2, and then, microprocessor 13 produces the first combinations of attributes according to the attribute after the filtering, this first combinations of attributes comprises at least one selected attribute, selected attribute be attribute one of them.Take table 2 as example, in this stage, microprocessor 13 produces the first combinations of attributes " sex+blood group ", and the first combinations of attributes " sex+blood group " comprises 2 selected attributes " sex " and " blood group ".
Preferably, in the present embodiment, microprocessor 13 also can in the lump according to expression figure place and the data stroke count generation Multiple Attribute Combinatorial of each attribute, meet the requirement of preliminary uniqueness to guarantee combinations of attributes.For example, the expression figure place of attribute " sex " is 1, then combinations of attributes " sex " can be distinguished at most 2 data (being the boys and girls), because combinations of attributes " sex " at most only distinguishing number is the data stroke count (5) that is less than tables of data 2 according to keep count of (2), so microprocessor 13 should filter combinations of attributes " sex ".
On the other hand, the expression figure place of attribute " blood group " is 2, then total expression figure place of the first combinations of attributes " sex+blood group " is 3, then can to distinguish at most 8 data (be woman+A, woman+B, woman+AB, woman+O, man+A, man+B, man+AB and man+O) to combinations of attributes " sex+blood group ", because the first combinations of attributes " sex+blood group " distinguishing number is according to the data stroke count (5) of number (8) greater than tables of data 2, so microprocessor 13 can keep the first combinations of attributes " sex+blood group ".
Then, microprocessor 13 will judge whether storage element 11 has had Candidate Key, and when being initial start-up owing to Candidate Key capture device 1, so storage element 11 will can not have any Candidate Key.After judging that storage element 11 does not have Candidate Key, microprocessor 13 will carry out the judgement of next stage to the first combinations of attributes " sex+blood group ".
Particularly, next microprocessor 13 will judge that whether the product of data phase heteromerism of selected attribute (i.e. " sex " and " blood group ") of the first combinations of attributes " sex+blood group " is more than or equal to this data stroke count.By the relevant narration of aforementioned table 2 as can be known, the data phase heteromerism of selected attribute " sex " is 2, the data phase heteromerism of selected attribute " blood group " is 4, and the product of selected attribute " sex " and the data phase heteromerism of selected attribute " blood group " (namely 8) is greater than data stroke count (5), therefore.Microprocessor 13 will judge that the product of data phase heteromerism of the selected attribute (i.e. " sex " and " blood group ") of the first combinations of attributes " sex+blood group " is more than or equal to this data stroke count.
In the product of the data phase heteromerism of the selected attribute (i.e. " sex " and " blood group ") of judging the first combinations of attributes " sex+blood group " be more than or equal to this data stroke count after, microprocessor 13 will produce a judged result according to a quantity of the selected attribute of the first combinations of attributes " sex+blood group ", and will to set the first combinations of attributes " sex+blood group " according to judged result be a Candidate Key 130.
Specifically, microprocessor 13 is to judge that the quantity of selected attribute of the first combinations of attributes " sex+blood group " whether greater than 1, as no, then is set as the first combinations of attributes one Candidate Key 130.But the first combinations of attributes " sex+blood group " from here as can be known, the first combinations of attributes " sex+blood group " comprises two selected attributes " sex " and " blood group ", judged result must show must the first combinations of attributes " sex+blood group " selected attribute number greater than 1, therefore must be determined further according to this judged result.
Next, microprocessor 13 in connection with selected attribute " sex " and selected attribute " blood group " to produce one in conjunction with combinations of attributes, and follow according to tables of data (i.e. table 2) and in conjunction with combinations of attributes calculations incorporated combinations of attributes one in conjunction with data phase heteromerism, next, microprocessor 13 will judge this in conjunction with data phase heteromerism whether more than or equal to this data stroke count, in this way, then the first combinations of attributes " sex+blood group " is made as Candidate Key 130 and it is stored to storage element 11, as no, then the first combinations of attributes " sex+blood group " not can be Candidate Key 130.
For example, as shown in Table 2, comprise " man+A, man+B, woman+B, woman+AB, woman+O " in conjunction with combinations of attributes, 5 in conjunction with data phase heteromerism, it is to equal data stroke count (5), therefore the first combinations of attributes " sex+blood group " can be made as Candidate Key 130 and it is stored to storage element 11, so far Candidate Key " sex+blood group " produces.
After Candidate Key " sex+blood group " produces, microprocessor 13 also can produce one second combinations of attributes " sex+blood group+student number " according to these data types, these attributes, these expression figure places and this data stroke count, and after one second combinations of attributes " sex+blood group+student number " produced, microprocessor 13 also judged whether storage element 11 has had Candidate Key.
Because Candidate Key " sex+blood group " 130 has been stored in storage element 11, microprocessor 13 will judge that storage element 11 has had Candidate Key 130, and to Candidate Key " sex+blood group " 130 (also can be considered the first combinations of attributes " sex+blood group ") and the second combinations of attributes " sex+blood group+student number " carry out one with (AND) logical operation, producing an operation result, and judge whether this operation result equals the first combinations of attributes " sex+blood group "; In this way, represent that then the second combinations of attributes " sex+blood group+student number " does not meet the requirement of minimality, should give rejecting; As no, microprocessor 13 will continue the second combinations of attributes " sex+blood group+student number " is carried out aforementioned data phase heteromerism and in conjunction with the judgement of combinations of attributes.
Specifically, the selected attribute that aforementioned each combinations of attributes comprises is can a set expression, according to " sex, blood group, photo, student number " this order, the first combinations of attributes " sex+blood group " can (1100) expression, the second combinations of attributes " sex+blood group+student number " can (1101) expression.13 pairs of the first combinations of attributes of microprocessor (1100) and the second combinations of attributes (1101) carry out being (1100) with the operation result of logical operation, it is identical with the first combinations of attributes (1100), this moment, microprocessor 13 judged that just the second combinations of attributes " sex+blood group+student number " does not meet the requirement of minimality, should give rejecting.
Implement aspect in other, if combinations of attributes comprises the three selected attributes such as one first selected attribute, one second selected attribute and one the 3rd selected attribute, microprocessor 13 is combined into one first in conjunction with combinations of attributes with the first selected attribute and the second selected attribute, and the second selected attribute and the 3rd selected attribute be combined into one second in conjunction with combinations of attributes, and judge respectively first in conjunction with combinations of attributes and second in conjunction with combinations of attributes in conjunction with data phase heteromerism whether more than or equal to the data stroke count; If then can set Candidate Key according to the mode of epimere explanation; If not, then microprocessor 13 can continue in conjunction with combinations of attributes and repeat above-mentioned steps.What need emphasize is, how the present invention does not limit in conjunction with selected attribute and produce mode in conjunction with combinations of attributes, and how the visual Demand Design of affiliated technical field is in conjunction with combinations of attributes.
The second embodiment of the present invention is a kind of for the Candidate Key acquisition method such as the described Candidate Key capture device of the first embodiment shown in Fig. 2 A-Fig. 2 E.This Candidate Key capture device comprises a microprocessor and a storage element, this microprocessor and this storage element are electric connection, this storage element is in order to storing a tables of data, and tables of data is loaded with a data stroke count of tables of data, a plurality of attribute, respectively a data phase heteromerism, respectively a data type and the expression figure place of this attribute respectively of this attribute of this attribute.
In addition, the described Candidate Key acquisition method of the second embodiment can be carried out by a computer program product, when the Candidate Key capture device loads this computer program product and carries out a plurality of programmed instruction that this computer program product comprises by a computer after, can finish the described Candidate Key acquisition method of the second embodiment.Aforesaid computer program product can be stored in the computer-readable recording medium, for example ROM (read-only memory) (read only memory; ROM), flash memory, floppy disk, hard disk, CD, Portable disk, tape, can be known and had in any other Storage Media of identical function by the database of network access or the person that is familiar with the technique.
The Candidate Key acquisition method of the second embodiment comprises following steps, see also Fig. 2 A, at first execution in step 301, make microprocessor produce a combinations of attributes according to data type, data stroke count, these expression figure places and these attributes of each attribute, it produces details and illustrates in the first embodiment, therefore not at this detailed description.Wherein, this combinations of attributes has at least one selected attribute, and the selected attribute that combinations of attributes comprises is the attribute that corresponds to tables of data.
Then, in step 302, make the microprocessor judges storage element whether have a Candidate Key, in this way, see also Fig. 2 E, then execution in step 311, make microprocessor that this combinations of attributes and this Candidate Key are carried out one and computing, to produce an operation result, then, in step 312, make this operation result of microprocessor judges whether equal this Candidate Key, in this way, represent that then this combinations of attributes does not meet the requirement of minimality, in step 304, make microprocessor reject this combinations of attributes.
Please return ginseng Fig. 2 A, judge that such as step 302 the storage element position stores a Candidate Key or step 312 judges that this operation result is not equal to this Candidate Key, then execution in step 303, make the product of data phase heteromerism of the selected attribute that this combinations of attributes of microprocessor judges comprises whether more than or equal to the data stroke count, as no, then the same execution in step 304 makes microprocessor reject this combinations of attributes.
The product of judging the data phase heteromerism of the selected attribute that this combinations of attributes comprises such as step 303 is more than or equal to the data stroke count, then execution in step 305, make the number of attributes of the selected attribute that this combinations of attributes of microprocessor judges comprises whether greater than 1, see also Fig. 2 B, as no, then execution in step 306, making microprocessor set this combinations of attributes is Candidate Key, next carry out, step 307 makes microprocessor that Candidate Key is stored to storage element.
See also Fig. 2 C, the number of attributes of judging the selected attribute that this combinations of attributes comprises such as step 305 is greater than 1, then execution in step 308, make microprocessor engage the selected attribute that this combinations of attributes comprises, to produce one in conjunction with community set, then execution in step 309, make microprocessor calculate one in conjunction with data phase heteromerism according to this in conjunction with community set and this tables of data.
Next see also Fig. 2 D, execution in step 310, make microprocessor judges in conjunction with data phase heteromerism whether more than or equal to this data stroke count, if not, then execution in step 304, make microprocessor reject this combinations of attributes.If then execution in step 306, making microprocessor set this combinations of attributes is Candidate Key, next carries out, and step 307 makes microprocessor that Candidate Key is stored to storage element.
Except above-mentioned steps, the second embodiment also can carry out the first embodiment the operation described and function, under technical field have usually know the knowledgeable can be directly acquainted with the second embodiment how based on above-mentioned the first embodiment to carry out these operations and function, therefore do not repeat them here.
In sum, Candidate Key capture device of the present invention, Candidate Key acquisition method and computer program product thereof can be according to the data stroke count of tables of data and the data types of each attribute, elder generation's filtering can not become the combinations of attributes of Candidate Key, then, again according to the data phase heteromerism of each attribute, the selected attribute number that the data stroke count that tables of data is contained and combinations of attributes comprise, by capturing Candidate Key in the combinations of attributes after the filtering, therefore the present invention can intercept out Candidate Key accurately with in effectively being made up by many pen attributes, select the error that Candidate Key is produced to reduce by manual type, the shortcoming of prior art gets and is effectively overcome by this.
The above embodiments only are used for exemplifying enforcement aspect of the present invention, and explain technical characterictic of the present invention, are not to limit protection category of the present invention.Any be familiar with this operator can unlabored change or the arrangement of isotropism all belong to the scope that the present invention advocates, the scope of the present invention should be as the criterion with claim.
Claims (4)
1. one kind is the method that a tables of data is set a Candidate Key, the method is used for a Candidate Key capture device, this Candidate Key capture device comprises a storage element, this tables of data of this storage unit stores, this tables of data is loaded with a data stroke count of this tables of data, a plurality of attribute, respectively a data phase heteromerism and the data type of this attribute respectively of this attribute, and this Candidate Key acquisition method comprises the following step:
(a) according to respectively data type and these attributes of this attribute, produce one first combinations of attributes, this first combinations of attributes comprises at least one selected attribute, this at least one selected attribute be these attributes one of them;
(b) product of data phase heteromerism of judging at least one selected attribute of this first combinations of attributes is more than or equal to this data stroke count;
(c) number of attributes according to this at least one selected attribute of this first combinations of attributes produces a judged result; And
(d) according to this judged result, set this first combinations of attributes and be this Candidate Key of this tables of data.
2. method according to claim 1, it is characterized in that, this tables of data also is loaded with a respectively expression figure place of this attribute, and this step (a) also according to these expression figure places, this data stroke count, these data types and these attributes, produces this first combinations of attributes.
3. method according to claim 1 is characterized in that, this first combinations of attributes comprises a plurality of selected attributes, and this Candidate Key acquisition method also comprises the following step:
(e) according to this judged result, in conjunction with these selected attributes, to produce one in conjunction with combinations of attributes;
(f) according to this in conjunction with combinations of attributes and this tables of data, calculate this in conjunction with combinations of attributes one in conjunction with data phase heteromerism; And
(g) judge that this is more than or equal to this data stroke count in conjunction with data phase heteromerism, to set this first combinations of attributes as this Candidate Key.
4. method according to claim 1 is characterized in that, this step (a) also produces one second combinations of attributes, and this Candidate Key acquisition method also comprises the following step:
(h) this first combinations of attributes and this second combinations of attributes are carried out one and logical operation, to produce an operation result; And
(i) judge that this operation result is not equal to this first combinations of attributes.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910222294.1A CN102063434B (en) | 2009-11-18 | 2009-11-18 | Candidate key capture device and candidate key capture method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN200910222294.1A CN102063434B (en) | 2009-11-18 | 2009-11-18 | Candidate key capture device and candidate key capture method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN102063434A CN102063434A (en) | 2011-05-18 |
| CN102063434B true CN102063434B (en) | 2013-03-27 |
Family
ID=43998714
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN200910222294.1A Expired - Fee Related CN102063434B (en) | 2009-11-18 | 2009-11-18 | Candidate key capture device and candidate key capture method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN102063434B (en) |
Families Citing this family (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN112446043A (en) * | 2019-08-30 | 2021-03-05 | 中国移动通信有限公司研究院 | Method for determining category candidate key and electronic equipment |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5826259A (en) * | 1990-05-21 | 1998-10-20 | Financial Systems Technology Pty. Ltd. | Easily expandable data processing system and method |
| CN1270363A (en) * | 1999-04-09 | 2000-10-18 | 英业达股份有限公司 | Database management method |
| US20020169793A1 (en) * | 2001-04-10 | 2002-11-14 | Latanya Sweeney | Systems and methods for deidentifying entries in a data source |
| CN1885289A (en) * | 2005-06-23 | 2006-12-27 | 华硕电脑股份有限公司 | Data search method and relative apparatus and computer readable medium |
-
2009
- 2009-11-18 CN CN200910222294.1A patent/CN102063434B/en not_active Expired - Fee Related
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5826259A (en) * | 1990-05-21 | 1998-10-20 | Financial Systems Technology Pty. Ltd. | Easily expandable data processing system and method |
| CN1270363A (en) * | 1999-04-09 | 2000-10-18 | 英业达股份有限公司 | Database management method |
| US20020169793A1 (en) * | 2001-04-10 | 2002-11-14 | Latanya Sweeney | Systems and methods for deidentifying entries in a data source |
| CN1885289A (en) * | 2005-06-23 | 2006-12-27 | 华硕电脑股份有限公司 | Data search method and relative apparatus and computer readable medium |
Also Published As
| Publication number | Publication date |
|---|---|
| CN102063434A (en) | 2011-05-18 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20110161132A1 (en) | Method and system for extracting process sequences | |
| CN110019486A (en) | Collecting method, device, equipment and storage medium | |
| CN103955577B (en) | Computer automatic design method for mechanical equipment | |
| CN102880780A (en) | Systems and methods for creating intuitive context for analysis data | |
| CN106104592A (en) | Map band key entity attributes | |
| CN110119395B (en) | Method for realizing association processing of data standard and data quality based on metadata in big data management | |
| KR20120011987A (en) | Tax Statement Data Input And Execution System And Method Thereof | |
| CN108597565B (en) | Clinical queue data collaborative verification method based on OCR and named entity extraction technology | |
| EP2827240A1 (en) | Method for generating control-code by a control-code-diagram | |
| CN109684616A (en) | Dynamic statement formula assembles the method and system made a report on | |
| JP2735698B2 (en) | Interface verification processing method | |
| KR100457375B1 (en) | Method for fast searching and displaying of patent genealogical status from a patent database | |
| CN114118980A (en) | Intelligent checking method and system for digital achievements of building design | |
| CN111160855A (en) | Report sheet automatic auditing method, device, equipment and storage medium | |
| CN112214557B (en) | Data matching classification method and device | |
| CN102063434B (en) | Candidate key capture device and candidate key capture method | |
| CN102707938A (en) | Table-form software specification manufacturing and supporting method and device | |
| CN111913962A (en) | Multi-dimensional annual detailed fund planning system and method | |
| JP5367112B2 (en) | Data analysis support device and data analysis support processing program | |
| TW200417884A (en) | System and method for automatically classifying bill of material | |
| JP4501459B2 (en) | Program, method and apparatus for creating cross table | |
| US11861735B1 (en) | Method for generating a balance sheet that includes operating materials and supplies costs | |
| WO2004038582A1 (en) | Data processing method and data processing program | |
| CN109324963A (en) | The method and terminal device of automatic test profitable result | |
| TWI512504B (en) | Candidate key retrieving apparatus, candidate key retrieving method and computer program product thereof |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C14 | Grant of patent or utility model | ||
| GR01 | Patent grant | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20130327 |