zh:notes:huang_river
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:huang_river [2021/09/19 20:24] pzczxs [Difference Analysis in the Huang River Domain] |
zh:notes:huang_river [2022/01/26 10:39] (当前版本) pzczxs 讨论状态变化了 |
||
|---|---|---|---|
| 行 1: | 行 1: | ||
| - | ====== Difference Analysis on the Huang River Domain ====== | + | ====== Gap Analysis on the Huang River Domain ====== |
| ===== Citation Information ===== | ===== Citation Information ===== | ||
| 行 12: | 行 12: | ||
| ===== Import Bibliographic Data to Database ===== | ===== Import Bibliographic Data to Database ===== | ||
| Import bibliographic data in the format of BibTeX to the database by running <color red>TargetArticleBibTexImporter.java</color> in the package <color red>cn.edu.bjut.ui</color>. | Import bibliographic data in the format of BibTeX to the database by running <color red>TargetArticleBibTexImporter.java</color> in the package <color red>cn.edu.bjut.ui</color>. | ||
| + | |||
| + | Several DOI numbers do not follow the specification ([[https://doi.org/10.1007/s11192-019-03162-4|Xu et al. 2019]]). In addition, several cited articles are attached multiple DOI numbers. One can retrieve those cited articles by running the following SQL statement. | ||
| + | <code sql> | ||
| + | > SELECT id, text, doi_original, doi FROM cited_article WHERE flag = 1; | ||
| + | </code> | ||
| + | |||
| + | As for our case, there are 192 records in total. These DOI numbers are corrected manually one by one with the help of the following SQL code. | ||
| + | <code sql> | ||
| + | > SELECT ta.id AS id, title, doi, publication_year, journal FROM target_article_cited_article AS ta_ca, target_article AS ta WHERE ta.id = ta_ca.target_article_id AND ta_ca.cited_article_id = ???; | ||
| + | </code> | ||
| + | |||
| + | Then, one can run <color red>CitedArticleDoiUpdater.java</color> in the package <color red>cn.edu.bjut.ui</color> to import these DOI numbers to the database. | ||
| + | |||
| + | By running <color red>CitedArticleDoiLogMerger.java</color>, the records with the same DOI number will be merged according to log file <color red>CitedArticleDoiUpdater.log</color> in the directory of data. | ||
| + | |||
| + | ===== Update DOI number of Cited Articles ===== | ||
| + | <code sql> | ||
| + | > DELETE FROM target_article_cited_article WHERE cited_article_id = 73139; | ||
| + | </code> | ||
| + | |||
| + | <color red>CitedArticleDoiUpdater.java</color> in the package <color red>cn.edu.bjut.ui</color>; | ||
| + | |||
| + | <color red>CitedArticleDoiLogMerger.java</color> in the package <color red>cn.edu.bjut.ui</color>; | ||
| + | |||
| + | <color red>CitedArticleDoiChecker.java</color> in the package <color red>cn.edu.bjut.ui</color>; | ||
| + | |||
| + | <code sql> | ||
| + | > UPDATE target_article_cited_article SET cited_article_id = 47682 WHERE cited_article_id = 57643; | ||
| + | > DELETE FROM cited_article WHERE id = 57643; | ||
| + | > UPDATE target_article_cited_article SET cited_article_id = 46251 WHERE cited_article_id = 81228; | ||
| + | > DELETE FROM cited_article WHERE id = 81228; | ||
| + | > UPDATE target_article_cited_article SET cited_article_id = 3193 WHERE cited_article_id = 27281; | ||
| + | > DELETE FROM cited_article WHERE id = 27281; | ||
| + | > UPDATE target_article_cited_article SET cited_article_id = 82304 WHERE cited_article_id = 82236; | ||
| + | > DELETE FROM cited_article WHERE id = 82236; | ||
| + | </code> | ||
| + | |||
| + | ~~DISCUSSION:closed~~ | ||
zh/notes/huang_river.1632054284.txt.gz · 最后更改: 2021/09/19 20:24 由 pzczxs