zh:notes:huang_river
差别
这里会显示出您选择的修订版和当前版本之间的差别。
| 两侧同时换到之前的修订记录 前一修订版 后一修订版 | 前一修订版 | ||
|
zh:notes:huang_river [2021/09/20 14:09] pzczxs [Import Bibliographic Data to Database] |
zh:notes:huang_river [2022/01/26 10:39] (当前版本) pzczxs 讨论状态变化了 |
||
|---|---|---|---|
| 行 27: | 行 27: | ||
| 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. | ||
| - | ~~DISCUSSION~~ | + | ===== 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.1632118156.txt.gz · 最后更改: 2021/09/20 14:09 由 pzczxs