search

NLeSC / rcn_py

RCN is a python package to analyze Research Collaboration Network
MIT License
1 stars 0 forks source link

Store data in a database #3

Closed Peter9192 closed 1 year ago

Peter9192 commented 1 year ago

A database might be more suitable for storing data tables, especially when they grow bigger. Perhaps start with a simple sqlite database?

ZNBai commented 1 year ago

Sure, thank you for the suggestion. I am going to work on SQLite, with 3 main tables:

  1. Publication table: DOI(primary key), title, abstract, etc.
  2. Author table: ORCID(primary key), author_name, country, etc.
  3. Author-Publication table: ORCID(primary key), DOI(primary key) (Thanks for Stefan's help)