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 条
  • [31] Developing a mountaineering plan sharing system based on information extraction from unstructured documents
    Nohara, Akihiro
    Shiramatsu, Shun
    Ozono, Tadachika
    Shintani, Toramatsu
    IEEJ Transactions on Electronics, Information and Systems, 2015, 135 (12) : 1470 - 1480
  • [32] Relevant Piece of Information Extraction from Presentation Slide Page for Slide Information Retrieval System
    Hayama, Tessai
    Kunifuji, Susumu
    KNOWLEDGE, INFORMATION, AND CREATIVITY SUPPORT SYSTEMS, 2011, 6746 : 22 - +
  • [33] An automated information extraction system from the knowledge graph based annual financial reports
    Mohsin, Syed Farhan
    Jami, Syed Imran
    Wasi, Shaukat
    Siddiqui, Muhammad Shoaib
    PEERJ COMPUTER SCIENCE, 2024, 10
  • [34] Cloze: A Building Metadata Model Generation System based on Information Extraction
    He, Fang
    Wang, Dan
    PROCEEDINGS OF THE 2022 THE 9TH ACM INTERNATIONAL CONFERENCE ON SYSTEMS FOR ENERGY-EFFICIENT BUILDINGS, CITIES, AND TRANSPORTATION, BUILDSYS 2022, 2022, : 109 - 118
  • [35] Template Based Industrial Big Data Information Extraction and Query System
    Wang, Jie
    Peng, Yan
    Lin, Yun
    Wang, Kang
    DATA MINING AND BIG DATA, DMBD 2017, 2017, 10387 : 247 - 254
  • [36] Design and evaluation of an ontology based information extraction system for radiological reports
    Soysal, Ergin
    Cicekli, Ilyas
    Baykal, Nazife
    COMPUTERS IN BIOLOGY AND MEDICINE, 2010, 40 (11-12) : 900 - 911
  • [37] Towards an Information Extraction System based on Ontology to Match Resumes and Jobs
    Celik, Duygu
    Karakas, Askin
    Bal, Gulsen
    Gultunca, Cem
    Elci, Atilla
    Buluz, Basak
    Alevli, Murat Can
    2013 IEEE 37TH ANNUAL COMPUTER SOFTWARE AND APPLICATIONS CONFERENCE WORKSHOPS (COMPSACW), 2013, : 333 - 338
  • [38] Design of social media information extraction system based on deep learning
    Wang H.
    Gao Y.
    International Journal of Web Based Communities, 2023, 19 (2-3) : 161 - 174
  • [39] An Automated Stock Recommendation System from Stock Investment Research using Domain Specific Information Extraction
    Tapjinda, Tayida
    Vechpanich, Potsawee
    Leelasupakul, Nutchaya
    Prompoon, Nakornthip
    Patanothai, Chate
    PROCEEDINGS OF THE 2015 12TH INTERNATIONAL JOINT CONFERENCE ON COMPUTER SCIENCE AND SOFTWARE ENGINEERING (JCSSE), 2015, : 30 - 35
  • [40] An Information Extraction System for Protein Function Prediction
    Taha, Kamal
    Yoo, Paul D.
    2015 IEEE CONFERENCE ON COMPUTATIONAL INTELLIGENCE IN BIOINFORMATICS AND COMPUTATIONAL BIOLOGY (CIBCB), 2015, : 215 - 221
12345