I asked this question on stackoverflow a few weeks ago, but have not gotten a useable answer, even after a colleague added a 150pt bounty.

Is it possible to query the doi for each record in a table of citations?

I have a table (csv version) that includes the last name of the first author, the title, journal, year, and page numbers for each citation. I expect most (>90%) of the rows to have a valid doi, but using the [simple query uploader at CrossRef], I get a hit rate of ~7%.

There is also an XML-based query format that allows fuzzy matching, but this seems to have a limit on the number of queries that can be sent at one time.

The table is currently in MySQL, but starting with the .csv file would be a great help.

  • $\begingroup$ This might fit better on academia.stackexchange. $\endgroup$
    – Dan
    Mar 27, 2012 at 5:45
  • $\begingroup$ @dan perhaps another site, but not academia according to their faq( academia.stackexchange.com/faq) $\endgroup$ Mar 27, 2012 at 6:16
  • $\begingroup$ Someone brought this to the academia meta, and the consensus was that it's on-topic there. One of the mods can initiate the move request. $\endgroup$
    – eykanal
    Mar 27, 2012 at 12:34
  • $\begingroup$ @eykanal I don't think that is the case - the only and accepted answer says "The question on the scicomp board would not be appropriate here, but other questions in that area might be." $\endgroup$ Mar 27, 2012 at 13:55
  • $\begingroup$ Hrm, guess I gotta learn to read the whole answer and not just the first part :/ $\endgroup$
    – eykanal
    Mar 27, 2012 at 14:21

1 Answer 1


This is an open problem. There are better and worse ways to attack it but, start by reading Karen Coyle's summary of this problem. The bibliography attached to that article as well is excellent.

In short, the problem of quantifying sameness between two bibliographic records is hard, and a substantial amount machine-learning research has centered around this topic.


Not the answer you're looking for? Browse other questions tagged or ask your own question.