The Research of Information Extraction in Information System from SQL Server Based on System Table

被引：0
|
作者：
Chen, Huantong [1 ]
Zheng, Wei [2 ]
Chen, Yaofei [1 ]
Ni, Yinghua [3 ]
机构：
[1] Jinhua Polytech, Jinhua 321017, Peoples R China
[2] Zhejiang Radio & Tv Univ, Hangzhou 310030, Zhejiang, Peoples R China
[3] Zhejiang Normal Univ, Xingzhi Coll, Jinhua 321004, Peoples R China
来源：
ADVANCED RESEARCH ON INDUSTRY, INFORMATION SYSTEM AND MATERIAL ENGINEERING | 2013年 / 675卷
关键词：
SQL Server; System Table; Information Extraction; Skill Assessment;
D O I：
10.4028/www.scientific.net/AMR.675.35
中图分类号：
TM [电工技术]; TN [电子技术、通信技术];
学科分类号：
0808 ; 0809 ;
摘要：
This article describes the information extraction in information system from SQL Server. Through the system tables all information of SQL Server's internal objects in information system can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object's information extraction in information system. Describe the relationships of system tables in SQL Server through the graph and table in detail. A visual basic procedure using system table method is designed to achieve the table's structure information for all user tables in specified SQL Server database. This method is more complete than the method based on ADOX.
引用
收藏
页码：35 / +
页数：2
相关论文
共 50 条
  • [41] Concurrency Control and Self-optimization based on SQL Server Database System
    Guo, Rongchuan
    PROCEEDINGS OF THE 2016 2ND INTERNATIONAL CONFERENCE ON MATERIALS ENGINEERING AND INFORMATION TECHNOLOGY APPLICATIONS (MEITA 2016), 2017, 107 : 59 - 63
  • [42] Information Extraction Methods for Text Documents in a Cognitive Integrated Management Information System
    Hernes, Marcin
    2015 IEEE 2ND INTERNATIONAL CONFERENCE ON CYBERNETICS (CYBCONF), 2015, : 287 - 292
  • [43] Extraction of land subsidence information from digital water table model
    Pan, Y
    Duan, FZ
    Zhu, L
    IGARSS 2005: IEEE International Geoscience and Remote Sensing Symposium, Vols 1-8, Proceedings, 2005, : 5219 - 5222
  • [44] Corpus-Based Information Extraction and Opinion Mining for the Restaurant Recommendation System
    Pronoza, Ekaterina
    Yagunova, Elena
    Volskaya, Svetlana
    STATISTICAL LANGUAGE AND SPEECH PROCESSING, SLSP 2014, 2014, 8791 : 272 - 284
  • [45] An Information Extraction System of B2B Based on Knowledge Base
    Cui Yang
    Yang Bingru
    2009 INTERNATIONAL CONFERENCE ON E-BUSINESS AND INFORMATION SYSTEM SECURITY, VOLS 1 AND 2, 2009, : 743 - 746
  • [46] Text Information Extraction and Aggregation in a Mobile-based Emergency Response System
    Amailef, Khaled
    Lu, Jie
    Ma, Jun
    NEW PERSPECTIVES ON RISK ANALYSIS AND CRISIS RESPONSE, 2009, : 186 - 191
  • [47] Tourist Information Extraction Method from Tweets Without Tourist Spot Names for Tourist Information Visualization System
    Watanabe, Sayuri
    Yoshino, Takashi
    COLLABORATION TECHNOLOGIES AND SOCIAL COMPUTING, 2017, 10397 : 107 - 115
  • [48] ChemEx: information extraction system for chemical data curation
    Atima Tharatipyakul
    Somrak Numnark
    Duangdao Wichadakul
    Supawadee Ingsriswang
    BMC Bioinformatics, 13
  • [49] Implementation and evaluation of a negation tagger in a pipeline-based system for information extraction from pathology reports
    Mitchell, KJ
    Becich, MJ
    Berman, JJ
    Chapman, WW
    Gilbertson, J
    Gupta, D
    Harrison, J
    Legowski, E
    Crowley, RS
    MEDINFO 2004: PROCEEDINGS OF THE 11TH WORLD CONGRESS ON MEDICAL INFORMATICS, PT 1 AND 2, 2004, 107 : 663 - 667
  • [50] Combining information extraction and data integration in the ESTEST system
    Williams, Dean
    Poulovassilis, Alexandra
    ICSOFT 2006: PROCEEDINGS OF THE FIRST INTERNATIONAL CONFERENCE ON SOFTWARE AND DATA TECHNOLOGIES, VOL 2, 2006, : 13 - +
12345