[REVIEW]: Zoomerjoin: Superlatively Fast Fuzzy-Joins

[editorialbot]

Submitting author: @beniaminogreen (Beniamino Green)
Repository: https://github.com/beniaminogreen/zoomerjoin
Branch with paper.md (empty if default branch): joss
Version: v0.1.0
Editor: @samhforbes
Reviewers: @cjbarrie, @wincowgerDEV
Archive: 10.5281/zenodo.8370652

Status

Status badge code:

HTML: <a href="https://joss.theoj.org/papers/b68ba4bfbce52e56585aea54a5bcba54"><img src="https://joss.theoj.org/papers/b68ba4bfbce52e56585aea54a5bcba54/status.svg"></a>
Markdown: [![status](https://joss.theoj.org/papers/b68ba4bfbce52e56585aea54a5bcba54/status.svg)](https://joss.theoj.org/papers/b68ba4bfbce52e56585aea54a5bcba54)

Reviewers and authors:

Please avoid lengthy details of difficulties in the review thread. Instead, please create a new issue in the target repository and link to those issues (especially acceptance-blockers) by leaving comments in the review thread below. (For completists: if the target issue tracker is also on GitHub, linking the review thread in the issue or vice versa will create corresponding breadcrumb trails in the link target.)

Reviewer instructions & questions

@cjbarrie & @wincowgerDEV, your review will be checklist based. Each of you will have a separate checklist that you should update when carrying out your review.
First of all you need to run this command in a separate comment to create the checklist:

@editorialbot generate my checklist

The reviewer guidelines are available here: https://joss.readthedocs.io/en/latest/reviewer_guidelines.html. Any questions/concerns please let @samhforbes know.

✨ Please start on your review when you are able, and be sure to complete your review in the next six weeks, at the very latest ✨

Checklists

📝 Checklist for @cjbarrie

📝 Checklist for @wincowgerDEV

[editorialbot]

Hello humans, I'm @editorialbot, a robot that can help you with some common editorial tasks.

For a list of things I can do to help you, just type:

@editorialbot commands

For example, to regenerate the paper pdf after making changes in the paper's md or bib files, type:

@editorialbot generate pdf

[editorialbot]

Software report:

github.com/AlDanial/cloc v 1.88  T=0.21 s (211.6 files/s, 24419.4 lines/s)
-------------------------------------------------------------------------------
Language                     files          blank        comment           code
-------------------------------------------------------------------------------
Markdown                         6            239              0            960
HTML                             1             12              2            755
R                               18            189            784            706
Rust                             6            125              9            479
JSON                             1              0              0            189
YAML                             6             35             12            183
TeX                              1              0              0            141
Rmd                              3             73            205             55
TOML                             1              2              0             19
C                                1              2              2              4
Bourne Shell                     1              1              8              2
-------------------------------------------------------------------------------
SUM:                            45            678           1022           3493
-------------------------------------------------------------------------------


gitinspector failed to run statistical information for the repository

[editorialbot]

Wordcount for paper.md is 1491

[editorialbot]

Reference check summary (note 'MISSING' DOIs are suggestions that need verification):

OK DOIs

- 10.1109/sequen.1997.666900 is OK
- 10.1017/CBO9781139924801 is OK
- 10.1093/bioinformatics/btz354 is OK
- 10.1145/997817.997857 is OK
- 10.1017/pan.2021.38 is OK
- 10.32614/RJ-2014-011 is OK
- 10.2139/ssrn.3214172 is OK
- 10.1080/01621459.1969.10501049 is OK

MISSING DOIs

- None

INVALID DOIs

- None

[editorialbot]

👉📄 Download article proof 📄 View article proof on GitHub 📄 👈

[samhforbes]

👋🏼 @beniaminogreen, @cjbarrie, @wincowgerDEV this is the review thread for the paper. All of our communications will happen here from now on.

As a reviewer, the first step is to create a checklist for your review by entering

@editorialbot generate my checklist

as the top of a new comment in this thread.

These checklists contain the JOSS requirements. As you go over the submission, please check any items that you feel have been satisfied. The first comment in this thread also contains links to the JOSS reviewer guidelines.

The JOSS review is different from most other journals. Our goal is to work with the authors to help them meet our criteria instead of merely passing judgment on the submission. As such, the reviewers are encouraged to submit issues and pull requests on the software repository. Please also feel free to comment and ask questions on this thread. In my experience, it is better to post comments/questions/suggestions as you come across them instead of waiting until you've reviewed the entire package.

We aim for reviews to be completed within about 2-4 weeks. Please let me know if any of you require some more time. We can also use EditorialBot (our bot) to set automatic reminders if you know you'll be away for a known period of time.

Please feel free to ping me if you have any questions/concerns.

[cjbarrie]

Review checklist for @cjbarrie

Conflict of interest

• I confirm that I have read the JOSS conflict of interest (COI) policy and that: I have no COIs with reviewing this work or that any perceived COIs have been waived by JOSS for the purpose of this review.

Code of Conduct

• I confirm that I read and will adhere to the JOSS code of conduct.

General checks

• Repository: Is the source code for this software available at the https://github.com/beniaminogreen/zoomerjoin?
• License: Does the repository contain a plain-text LICENSE file with the contents of an OSI approved software license?
• Contribution and authorship: Has the submitting author (@beniaminogreen) made major contributions to the software? Does the full list of paper authors seem appropriate and complete?
• Substantial scholarly effort: Does this submission meet the scope eligibility described in the JOSS guidelines
• Data sharing: If the paper contains original data, data are accessible to the reviewers. If the paper contains no original data, please check this item.
• Reproducibility: If the paper contains original results, results are entirely reproducible by reviewers. If the paper contains no original results, please check this item.
• Human and animal research: If the paper contains original data research on humans subjects or animals, does it comply with JOSS's human participants research policy and/or animal research policy? If the paper contains no such data, please check this item.

Functionality

• Installation: Does installation proceed as outlined in the documentation?
• Functionality: Have the functional claims of the software been confirmed?
• Performance: If there are any performance claims of the software, have they been confirmed? (If there are no claims, please check off this item.)

Documentation

• A statement of need: Do the authors clearly state what problems the software is designed to solve and who the target audience is?
• Installation instructions: Is there a clearly-stated list of dependencies? Ideally these should be handled with an automated package management solution.
• Example usage: Do the authors include examples of how to use the software (ideally to solve real-world analysis problems).
• Functionality documentation: Is the core functionality of the software documented to a satisfactory level (e.g., API method documentation)?
• Automated tests: Are there automated tests or manual steps described so that the functionality of the software can be verified?
• Community guidelines: Are there clear guidelines for third parties wishing to 1) Contribute to the software 2) Report issues or problems with the software 3) Seek support

Software paper

• Summary: Has a clear description of the high-level functionality and purpose of the software for a diverse, non-specialist audience been provided?
• A statement of need: Does the paper have a section titled 'Statement of need' that clearly states what problems the software is designed to solve, who the target audience is, and its relation to other work?
• State of the field: Do the authors describe how this software compares to other commonly-used packages?
• Quality of writing: Is the paper well written (i.e., it does not require editing for structure, language, or writing quality)?
• References: Is the list of references complete, and is everything cited appropriately that should be cited (e.g., papers, datasets, software)? Do references in the text use the proper citation syntax?

[cjbarrie]

This is a very good package. Easy to use and well written. There are just a few small changes I would recommend.

1. You do not provide the code you used to arrive at the benchmarks. It would be helpful to have this to test the claims of the article.
2. You do not attach data in the package that you use (corpus_1 and corpus_2) to demonstrate the package functionality. I think some version of this could be attached within R package file size constraints. If not, just provide a link as Wickham has done for e.g., babynames package in the past.
3. It would be helpful to have vignette documentation for the other package functions. The documentation remains quite minimal at the moment.
4. There are no Community guidelines I can see on the Github repo.

Additionally, some small typos in the article:

• In Summary section: "typically runs in runs in linear"
• In Statement of Need section: " is probabilistic a probabilistic algorithm"
• In Other Functionalities section: "implementation the probabilistic record-linkage"
• In Other Functionalities section: "to pairs to units"

For validating the package functionality, I did the following for now. It would be helpful if some version of this were incorporated in the documentation so users can test functionality easily:

library(dplyr)

url <- "https://raw.githubusercontent.com/beniaminogreen/zoomerjoin/main/vignettes/bonica.csv"
data <- read.csv(url(url))

set.seed(123L)
corpus_1 <- data %>%
  sample_n(500000) %>%
  select(x) %>%
  rename(field = x)

corpus_2 <- data %>%
  sample_n(500000) %>%
  select(x) %>%
  rename(field = x)


start_time <- Sys.time()
join_out <- jaccard_inner_join(corpus_1, corpus_2,
                               by = "field", n_gram_width=6,
                               n_bands=20, band_width=6, threshold = .8)
print(Sys.time() - start_time)

[beniaminogreen]

Hi,

Thanks for your detailed feedback and your kind words about the package.

Writing in response to the four points you raise:

1. Thanks for flagging the lack of the benchmarking code. I originally included this in the package, but it was accidentally deleted at some stage. I will include it at the top of the benchmarking vignette so that it's easily available to you and other users.
   Unfortunately, the benchmarking takes something like 6 hours to run on a 8-core server. Most of this time is spent running the fuzzyjoin code, so it might be practical to only run the zoomerjoin code to verify its performance. Alternatively, I can reduce the size of the datasets or the number of trials to make sure it is replicable in a reasonable amount of time.

2. I have the corpus data in the vignettes file, but I am not sure if this is the right place. I will read through the R package book and make sure that I put the files in an appropriate place, and that the files are visible to users. I also very much like the code snippet that you provided, so I will include it or something similar.

3. I agree that the package should have better documentation for the Euclidean distance joins, and the fuzzy string grouping, which I will add in the next few days.

4. I have included a contributing guide / community code of conduct in the contributing.md file in the root of the repo. Not sure if this is the right place, or the right format for the guidelines. I'll change it in the next commit if this does not meet the requirements.

I'll also make sure to fix the typos you flag in the paper.

Best and many thanks,
Ben

[beniaminogreen]

@editorialbot generate pdf

[editorialbot]

👉📄 Download article proof 📄 View article proof on GitHub 📄 👈

[beniaminogreen]

Writing to share some of the updates to the package over the past few days. In addition to fixing typos and fixing a bug in the euclidean joining code, I have:

1. Updated the guided tour vingette to show off the jaccard_string_group and jaccard_curve functions, as well as adding a very short vingette on joining using the euclidean distance.

2. added the DIME / Bonica data so it is packaged with the R repository, which makes the functionality of the package easier to experiment. This change is reflected in the README and vignettes.

3. The benchmarking vingette now contains the code that is used to generate the benchmarks (although it isn't run every time). As mentioned before, this code takes several hours to run due to the large size of the datasets used.

Because of this, I have also uploaded this gist which runs the same benchmarking code over a smaller set of inputs to show the difference in scaling between the two methods for smaller datasets. It should run in ~20 mins on a modern laptop.

[wincowgerDEV]

Review checklist for @wincowgerDEV

Conflict of interest

• I confirm that I have read the JOSS conflict of interest (COI) policy and that: I have no COIs with reviewing this work or that any perceived COIs have been waived by JOSS for the purpose of this review.

Code of Conduct

• I confirm that I read and will adhere to the JOSS code of conduct.

General checks

• Repository: Is the source code for this software available at the https://github.com/beniaminogreen/zoomerjoin?
• License: Does the repository contain a plain-text LICENSE file with the contents of an OSI approved software license?
• Contribution and authorship: Has the submitting author (@beniaminogreen) made major contributions to the software? Does the full list of paper authors seem appropriate and complete?
• Substantial scholarly effort: Does this submission meet the scope eligibility described in the JOSS guidelines
• Data sharing: If the paper contains original data, data are accessible to the reviewers. If the paper contains no original data, please check this item.
• Reproducibility: If the paper contains original results, results are entirely reproducible by reviewers. If the paper contains no original results, please check this item.
• Human and animal research: If the paper contains original data research on humans subjects or animals, does it comply with JOSS's human participants research policy and/or animal research policy? If the paper contains no such data, please check this item.

Functionality

• Installation: Does installation proceed as outlined in the documentation?
• Functionality: Have the functional claims of the software been confirmed?
• Performance: If there are any performance claims of the software, have they been confirmed? (If there are no claims, please check off this item.)

Documentation

• A statement of need: Do the authors clearly state what problems the software is designed to solve and who the target audience is?
• Installation instructions: Is there a clearly-stated list of dependencies? Ideally these should be handled with an automated package management solution.
• Example usage: Do the authors include examples of how to use the software (ideally to solve real-world analysis problems).
• Functionality documentation: Is the core functionality of the software documented to a satisfactory level (e.g., API method documentation)?
• Automated tests: Are there automated tests or manual steps described so that the functionality of the software can be verified?
• Community guidelines: Are there clear guidelines for third parties wishing to 1) Contribute to the software 2) Report issues or problems with the software 3) Seek support

Software paper

• Summary: Has a clear description of the high-level functionality and purpose of the software for a diverse, non-specialist audience been provided?
• A statement of need: Does the paper have a section titled 'Statement of need' that clearly states what problems the software is designed to solve, who the target audience is, and its relation to other work?
• State of the field: Do the authors describe how this software compares to other commonly-used packages?
• Quality of writing: Is the paper well written (i.e., it does not require editing for structure, language, or writing quality)?
• References: Is the list of references complete, and is everything cited appropriately that should be cited (e.g., papers, datasets, software)? Do references in the text use the proper citation syntax?

[wincowgerDEV]

@beniaminogreen, I ran into an issue with the installation and posted here: beniaminogreen/zoomerjoin#70

[wincowgerDEV]

@beniaminogreen recommendation on line 77 of the manuscript, I don't think you want to claim that your package never creates false positives. True positive matches in character datasets are often subjective and may be complex (beyond the capabilities of jacard similarity), it may confuse readers when they do not get the expected output.

[wincowgerDEV]

@beniaminogreen, I recommend adding some code examples in text to demonstrate your points, it will help readers understand which function to use to achieve which outcomes you are talking about.

[wincowgerDEV]

@beniaminogreen, it isn't clear where the code for producing the euclidean synthetic dataset is described in the manuscript. I think there should be a link in the manuscript to where the code is that produced the figure.

[beniaminogreen]

I agree with the comment that "no false positives" might mislead users as to what zoomerjoin can accomplish. I'd still like to flag the fact that zoomerjoin will never identify units that are less similar than the threshold the user selects as matches, but I'll see if there's a way to say this that sets expectations better.

The code for the synthetic dataset and benchmarking can be found in this vignette, and I'll include a link in the paper. I also like the suggestion of adding code examples, so I'll add a small example of joining using the Euclidean and Jaccard distances to the article.

I thought that including a contrubuting.md file was enough to satisfy the JOSS requirements, but since both of you have raised this as a concern, I will write up a more detailed set of instructions on contributing or reporting bugs.

Best,
Ben

[beniaminogreen]

@editorialbot generate pdf

[editorialbot]

👉📄 Download article proof 📄 View article proof on GitHub 📄 👈

[beniaminogreen]

Updating the article to make it responsive to comments above. Specifically: have added code for the synthetic dataset, linked to benchmarking vignette, and added an example use of euclidean_inner_join. Also, have removed sentence about no false positives because I agree it could set the wrong expectation for people considering the package.

Added contributing instructions in a separate update to the repo.

Best,
Ben

[beniaminogreen]

Hi All,

Thanks for your detailed feedback about the package.

In response to some of the comments you've given, I have made the rust code in the package capture R's random seed, so you can set the seed and make sure that all the results are repicable. This helped me catch a locking issue with some of the rust code.

I've bundled a version of the dime dataset with the package so that users can start experimenting with the joining function immediately after installing the package.

It looks like both of you are having difficulty replicating some of the performance claims in the paper. Ideally, I would like to include benchmarks on large datasets to show off the scaling of the package, but I recognize that this makes it tough for replicators. Is there any way I can make it easier for you to run the benchmarks?

Similarly, please don't hesitate to let me know if I can make it easier for you to sign off on any of the other steps.

Best, and many thanks for your help,
Ben

[editorialbot]

Done! archive is now 10.5281/zenodo.8370652

[samhforbes]

@editorialbot recommend-accept

[editorialbot]

Attempting dry run of processing paper acceptance...

[editorialbot]

Reference check summary (note 'MISSING' DOIs are suggestions that need verification):

OK DOIs

- 10.1109/sequen.1997.666900 is OK
- 10.1017/CBO9781139924801 is OK
- 10.1093/bioinformatics/btz354 is OK
- 10.1145/997817.997857 is OK
- 10.1017/pan.2021.38 is OK
- 10.32614/RJ-2014-011 is OK
- 10.2139/ssrn.3214172 is OK
- 10.1080/01621459.1969.10501049 is OK

MISSING DOIs

- None

INVALID DOIs

- None

[editorialbot]

The paper's PDF and metadata files generation produced some warnings that could prevent the final paper from being published. Please fix them before the end of the review process.

citation rextednr not found

[editorialbot]

⚠️ Error preparing paper acceptance. The generated XML metadata file is invalid.

IDREFS attribute rid references an unknown ID "ref-rextednr"

[beniaminogreen]

on it.

[beniaminogreen]

Just fixed - I had introduced a minor spelling error in a citation somewhere in the revision process.

[samhforbes]

@editorialbot generate pdf

[editorialbot]

👉📄 Download article proof 📄 View article proof on GitHub 📄 👈

[samhforbes]

@editorialbot recommend-accept

[editorialbot]

Attempting dry run of processing paper acceptance...

[editorialbot]

Reference check summary (note 'MISSING' DOIs are suggestions that need verification):

OK DOIs

- 10.1109/sequen.1997.666900 is OK
- 10.1017/CBO9781139924801 is OK
- 10.1093/bioinformatics/btz354 is OK
- 10.1145/997817.997857 is OK
- 10.1017/pan.2021.38 is OK
- 10.32614/RJ-2014-011 is OK
- 10.2139/ssrn.3214172 is OK
- 10.1080/01621459.1969.10501049 is OK

MISSING DOIs

- None

INVALID DOIs

- None

[editorialbot]

👋 @openjournals/sbcs-eics, this paper is ready to be accepted and published.

Check final proof 👉📄 Download article

If the paper PDF and the deposit XML files look good in openjournals/joss-papers#4604, then you can now move forward with accepting the submission by compiling again with the command @editorialbot accept

[arfon]

@editorialbot accept

[editorialbot]

Doing it live! Attempting automated processing of paper acceptance...

[editorialbot]

⚠️ Couldn't acccept/publish paper. An error happened.

[beniaminogreen]

Hmm. I don't understand the error message in the github workflow log, but please let me know if there's anything I can do to fix it.

[arfon]

@editorialbot accept

[editorialbot]

Doing it live! Attempting automated processing of paper acceptance...

[editorialbot]

Ensure proper citation by uploading a plain text CITATION.cff file to the default branch of your repository.

If using GitHub, a Cite this repository menu will appear in the About section, containing both APA and BibTeX formats. When exported to Zotero using a browser plugin, Zotero will automatically create an entry using the information contained in the .cff file.

You can copy the contents for your CITATION.cff file here:

CITATION.cff

cff-version: "1.2.0"
authors:
- family-names: Green
  given-names: Beniamino
  orcid: "https://orcid.org/0009-0006-4501-597X"
contact:
- family-names: Green
  given-names: Beniamino
  orcid: "https://orcid.org/0009-0006-4501-597X"
doi: 10.5281/zenodo.8370652
message: If you use this software, please cite our article in the
  Journal of Open Source Software.
preferred-citation:
  authors:
  - family-names: Green
    given-names: Beniamino
    orcid: "https://orcid.org/0009-0006-4501-597X"
  date-published: 2023-09-26
  doi: 10.21105/joss.05693
  issn: 2475-9066
  issue: 89
  journal: Journal of Open Source Software
  publisher:
    name: Open Journals
  start: 5693
  title: "Zoomerjoin: Superlatively-Fast Fuzzy Joins"
  type: article
  url: "https://joss.theoj.org/papers/10.21105/joss.05693"
  volume: 8
title: "Zoomerjoin: Superlatively-Fast Fuzzy Joins"

If the repository is not hosted on GitHub, a .cff file can still be uploaded to set your preferred citation. Users will be able to manually copy and paste the citation.

Find more information on .cff files here and here.

[editorialbot]

🐘🐘🐘 👉 Toot for this paper 👈 🐘🐘🐘

[editorialbot]

🚨🚨🚨 THIS IS NOT A DRILL, YOU HAVE JUST ACCEPTED A PAPER INTO JOSS! 🚨🚨🚨

Here's what you must now do:

0. Check final PDF and Crossref metadata that was deposited 👉 Creating pull request for 10.21105.joss.05693 joss-papers#4623
1. Wait a couple of minutes, then verify that the paper DOI resolves https://doi.org/10.21105/joss.05693
2. If everything looks good, then close this review issue.
3. Party like you just published a paper! 🎉🌈🦄💃👻🤘

Any issues? Notify your editorial technical team...

[arfon]

@cjbarrie, @wincowgerDEV – many thanks for your reviews here and to @samhforbes for editing this submission! JOSS relies upon the volunteer effort of people like you and we simply wouldn't be able to do this without you ✨

@beniaminogreen – your paper is now accepted and published in JOSS ⚡🚀💥

[editorialbot]

🎉🎉🎉 Congratulations on your paper acceptance! 🎉🎉🎉

If you would like to include a link to your paper from your README use the following code snippets:

Markdown:
[![DOI](https://joss.theoj.org/papers/10.21105/joss.05693/status.svg)](https://doi.org/10.21105/joss.05693)

HTML:
<a style="border-width:0" href="https://doi.org/10.21105/joss.05693">
  <img src="https://joss.theoj.org/papers/10.21105/joss.05693/status.svg" alt="DOI badge" >
</a>

reStructuredText:
.. image:: https://joss.theoj.org/papers/10.21105/joss.05693/status.svg
   :target: https://doi.org/10.21105/joss.05693

This is how it will look in your documentation:

We need your help!

The Journal of Open Source Software is a community-run journal and relies upon volunteer effort. If you'd like to support us please consider doing either one (or both) of the the following:

• Volunteering to review for us sometime in the future. You can add your name to the reviewer list here: https://reviewers.joss.theoj.org/join
• Making a small donation to support our running costs here: https://numfocus.org/donate-to-joss