Algorithm For Mining The Primary Key In A Comma-Separated File Having 20,000 Entries

Question

[Sameer]

Hello, I am working on a project, i have to write an algorithm for comparing two large databases by defining association rules, so firstly i want to distinguish the primary attributes. That's way i need some help to find primary key in large database of minimum 20,000 attributes. please give me some suggestions that what should i do. sorry if i could not explain properly.
BR Sameer

[Pierre Lindenbaum]

How is it related to bioinformatics? As it is defined here, you'd better ask stackoverflow.com.

[Neilfws]

Yes, please indicate bioinformatics relevance, or we'll have to close this one.

[Giovanni M Dall'Olio]

also, provide an example of the data you want to analyze, and the output you want to get.

[Michael]

A problem like this might occur in bioinformatics when trying to map datasets based on identifiers, then it is important to look for some attribute that could serve as primary key. Still I believe it is not bioinformatics specific enough to warrant it on BioStar instead of Stackoverflow without more explanation

[seidel]

I think the relevance to bioinformatics is plainly obvious. I run into this problem a lot in bioinformatics, and find the question and potential answer informative for anyone in this field.

[Neilfws]

Perhaps I should not have said "relevance". What I want to see is a specific bioinformatics problem, not a general computing problem. And the question could be clearer - it's CSV in the title, but then databases in the main text.

Answer 1

[Kevin Blighe]

Use awk index arrays. With awk, it is also possible to read 2 files in the same command and cross-compare information between these.

Kevin