zh:notes:huang_river
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:huang_river [2021/09/19 20:35] pzczxs [Difference Analysis on the Huang River Domain] |
zh:notes:huang_river [2022/01/26 10:39] (当前版本) pzczxs 讨论状态变化了 |
||
|---|---|---|---|
| 行 18: | 行 18: | ||
| </code> | </code> | ||
| - | As for our case, there are 379 records in total. These DOI numbers are corrected manually one by one with the help of the following SQL 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> | <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 = ???; | > 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 = ???; | ||
| 行 26: | 行 26: | ||
| 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. | 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.1632054949.txt.gz · 最后更改: 2021/09/19 20:35 由 pzczxs