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 条
  • [21] QuAChIE: Question Answering based Chinese Information Extraction System
    Ru, Dongyu
    Wang, Zhenghui
    Qiu, Lin
    Zhou, Hao
    Li, Lei
    Zhang, Weinan
    Yu, Yong
    PROCEEDINGS OF THE 43RD INTERNATIONAL ACM SIGIR CONFERENCE ON RESEARCH AND DEVELOPMENT IN INFORMATION RETRIEVAL (SIGIR '20), 2020, : 2177 - 2180
  • [22] QA System for Food Safety Events Based on Information Extraction
    Chen Y.
    Zhang X.
    Chen A.
    Zhao X.
    Dong Y.
    Nongye Jixie Xuebao/Transactions of the Chinese Society for Agricultural Machinery, 2020, 51 : 442 - 448
  • [23] Building Information Extraction System Based on Computing Domain Ontology
    Ta, Chien D. C.
    Tuoi Phan Thi
    16TH INTERNATIONAL CONFERENCE ON INFORMATION INTEGRATION AND WEB-BASED APPLICATIONS & SERVICES (IIWAS 2014), 2014, : 454 - 458
  • [24] Ontology-based Drug Product Information Extraction System
    Li, Wen-jie
    Shen, Nan
    PROCEEDINGS OF THE 2009 2ND INTERNATIONAL CONFERENCE ON BIOMEDICAL ENGINEERING AND INFORMATICS, VOLS 1-4, 2009, : 1672 - +
  • [25] IExM: Information Extraction System for Movies
    Chen, Peng-Yu
    Lee, Yi-Hui
    Wu, Yueh-Han
    Ma, Wei-Yun
    WWW'17 COMPANION: PROCEEDINGS OF THE 26TH INTERNATIONAL CONFERENCE ON WORLD WIDE WEB, 2017, : 189 - 193
  • [26] A Study on Chinese Information Extraction System Based on Description Logics
    Zhu Qian
    Cheng Xian-yi
    2011 INTERNATIONAL CONFERENCE ON FUTURE COMPUTER SCIENCE AND APPLICATION (FCSA 2011), VOL 3, 2011, : 339 - 341
  • [27] Information Extraction from Research Papers Based on Statistical Methods
    Kavila, Selvani Deepthi
    Rani, D. Fathima
    PROCEEDINGS OF THE SECOND INTERNATIONAL CONFERENCE ON COMPUTER AND COMMUNICATION TECHNOLOGIES, IC3T 2015, VOL 3, 2016, 381 : 573 - 580
  • [28] Profile generation from web sources: an information extraction system
    Rishabh Ranjan
    H. Vathsala
    Shashidhar G. Koolagudi
    Social Network Analysis and Mining, 2022, 12
  • [29] Profile generation from web sources: an information extraction system
    Ranjan, Rishabh
    Vathsala, H.
    Koolagudi, Shashidhar G.
    SOCIAL NETWORK ANALYSIS AND MINING, 2022, 12 (01)
  • [30] A System for Adaptive Information Extraction from Highly Informal Text
    Alonso i Alemany, Laura
    Carrascosa, Rafael
    NATURAL LANGUAGE PROCESSING AND INFORMATION SYSTEMS, 2011, 6716 : 145 - 152