Please wait a minute...
New Technology of Library and Information Service  2010, Vol. 26 Issue (2): 95-99    DOI: 10.11925/infotech.1003-3513.2010.02.17
article Current Issue | Archive | Adv Search |
A VBA Implementation of General Duplicate Checking and Comparison Template System
Xu Hai   Yao Xiang
(Library of Nanjing University of Aeronautics and Astronautics, Nanjing 210016, China)
Download: PDF(677 KB)   HTML  
Export: BibTeX | EndNote (RIS)      

This article discusses the design and implementation of general duplicate checking and comparison template system used for Chinese periodical acquisition. Based on the technology of Excel VBA,this system which is developed by Library of Nanjing University of Aeronautics and Astronautics in 2009, designs and develops a general duplicate checking and comparison template aimed at all kinds of providers’ directory data. It achieves accurate, efficient and batch duplicate checking and comparison in the library periodical acquisition work and provides a friendly graphic interface. The system promotes the automation and scientization of library acquisition work.

Key wordsPeriodical acquisition      Duplicate checking      Comparison      VBA     
Received: 08 January 2010      Published: 25 February 2010


Corresponding Authors: Xu Hai     E-mail:
About author:: Xu Hai,Yao Xiang

Cite this article:

Xu Hai,Yao Xiang. A VBA Implementation of General Duplicate Checking and Comparison Template System. New Technology of Library and Information Service, 2010, 26(2): 95-99.

URL:     OR

[1] 别立谦,何燕华. 高校图书馆中文期刊采访工作的障碍和对策[J]. 大学图书馆学报, 2003,21(4):53-57.
[2] 马维峰. Excel VBA应用开发从基础到实践[M]. 北京:电子工业出版社, 2006.
[3] Thomas H Cormen, Charles E Leiserson. 算法导论[M]. 潘金贵,顾铁成,李成法,等译. 北京:机械工业出版社, 2006.

[1] Liu Hongxu,Qu Jiansheng. Using Meta-analysis Software for Domain Knowledge Discovery[J]. 现代图书情报技术, 2016, 32(5): 9-21.
[2] Yu Jian, Xu Chen, Wang Meijun, Zhang Minhao, Yue Zhen'gan, Wu Xia, Zhao Chunmei. Design and Application of Data Fusion Software on Papers Indexed By SCI and EI[J]. 现代图书情报技术, 2014, 30(11): 79-87.
[3] Wang Jie. Application of Android in Book Acquisition Duplicate Checking System[J]. 现代图书情报技术, 2012, 28(4): 84-88.
[4] Ji Jiuming, Li Weijiao, Dong Taohong, Li Nan, Chen Jian. A Designation of Sci-tech Novelty Searching Project Management Supporting Off-line Based on VBA[J]. 现代图书情报技术, 2011, 27(10): 90-94.
[5] Li Jing Tan Ying Shi Qiaomei. Design and Implementation of E-mail Pushing Service System for Paper Indexed by Three Famous Indexes[J]. 现代图书情报技术, 2010, 26(6): 83-87.
[6] Wang Jie. The Development of Duplicate Checking System in Book Outside Acquisition Based on Smart Phone[J]. 现代图书情报技术, 2009, 25(7-8): 122-125.
[7] Yuan Fuyong,Guo Lina,Mao Weiwei. Re-ranking Algorithm Based on the Inter-Documents Comparison[J]. 现代图书情报技术, 2009, 25(11): 49-52.
[8] Yang Daiqing,Zhang Aixia. Academician Ontology Modeling and Automatically Instance Storing[J]. 现代图书情报技术, 2008, 24(4): 44-48.
[9] Han Tao. A Study on Web Service Resource Framework[J]. 现代图书情报技术, 2007, 2(5): 13-16.
[10] Hua Bolin . Anatomy of Statistic Analysis Technology in Bibliometric and Analytic System via VBA[J]. 现代图书情报技术, 2007, 2(4): 70-74.
[11] Hua Bolin . Implementation of Preprocess Technology in Bibliometric and Analytic Research via VBA[J]. 现代图书情报技术, 2007, 2(3): 69-72.
[12] Long Haojian . Merging Two Degree’s Dissertations Databases of Different Structure with Word[J]. 现代图书情报技术, 2007, 2(3): 80-82.
[13] Zhu Weili,Han Yu,Xiao Xiaodan,Chen Xianlai . Study of Automatic Construction of Medicine Keyword-Descriptor Comparison List[J]. 现代图书情报技术, 2006, 1(8): 51-54.
[14] Xu Dezhi,Liu Zheng . A Comparison Study on OWL Knowledge Base Systems[J]. 现代图书情报技术, 2006, 1(11): 36-40.
[15] Lin Guina,Gao Xianfeng,Bi Zhongdong,Zhou Jingzhi . Some Problems in the Construction of  Storage System in Digtal Library[J]. 现代图书情报技术, 2006, 1(10): 85-88.
  Copyright © 2016 Data Analysis and Knowledge Discovery   Tel/Fax:(010)82626611-6626,82624938