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 条
  • [1] Research of Information Extraction from SQL Server Based on SQL-DMO
    Zheng, Wei
    Wu, Yaping
    Chen, Yaofei
    AUTOMATION EQUIPMENT AND SYSTEMS, PTS 1-4, 2012, 468-471 : 2878 - +
  • [2] Research on Information Extraction Based on Web Table Structure and Ontology
    Wang, Xiaofeng
    MECHATRONICS AND INDUSTRIAL INFORMATICS, PTS 1-4, 2013, 321-324 : 2254 - 2259
  • [3] An NLP based Information Extraction System for Patents
    Vahab, Naima
    Neethu, K., V
    Binu, R.
    Mathew, Sinoy
    Khamari, Lokanath
    PROCEEDINGS OF THE INTERNATIONAL CONFERENCE ON INFORMATICS AND ANALYTICS (ICIA' 16), 2016,
  • [4] Information extraction from the Web: System and techniques
    Xiao, L
    Wissmann, D
    Brown, M
    Jablonski, S
    APPLIED INTELLIGENCE, 2004, 21 (02) : 195 - 224
  • [5] Information Extraction from the Web: System and Techniques
    Luo Xiao
    Dieter Wissmann
    Michael Brown
    Stephan Jablonski
    Applied Intelligence, 2004, 21 : 195 - 224
  • [6] Investigating the Suitability of a .NET/SQL Server Approach for Developing a Remotely Accessible Information System for Vehicle Inspectors
    Kumar, Justin
    Chaczko, Zenon
    Moulton, Bruce
    Mahadevan, Venkatesh
    PROCEEDINGS OF 2009 INTERNATIONAL CONFERENCE ON MACHINE LEARNING AND COMPUTING (IACSIT ICMLC 2009), 2009, : 136 - 140
  • [7] A modular information extraction system
    Feldman, Ronen
    Regev, Yizhar
    Gorodetsky, Maya
    INTELLIGENT DATA ANALYSIS, 2008, 12 (01) : 51 - 71
  • [8] A hybrid ontology-based information extraction system
    Gutierrez, Fernando
    Dou, Dejing
    Fickas, Stephen
    Wimalasuriya, Daya
    Zong, Hui
    JOURNAL OF INFORMATION SCIENCE, 2016, 42 (06) : 798 - 820
  • [9] An internet based multilingual investment information extraction system
    Fang, L
    Sheng, HY
    Zhang, DM
    Yao, TF
    INTERNET CHALLENGE: TECHNOLOGY AND APPLICATIONS, 2002, : 1 - 9
  • [10] Design and Implement of Information Extraction System Based on XML
    Xuan, Yanyan
    Hu, Yan
    DCABES 2008 PROCEEDINGS, VOLS I AND II, 2008, : 1400 - 1404
12345