Research of Information Extraction from SQL Server Based on SQL-DMO

被引：0
|
作者：
Zheng, Wei [1 ]
Wu, Yaping [2 ]
Chen, Yaofei [3 ]
机构：
[1] Zhejiang Radio & Tv Univ, Hangzhou 310030, Zhejiang, Peoples R China
[2] Shaoxing Univ, Shaoxing, Peoples R China
[3] Jinhua Polytechn, Jinhua 321007, Peoples R China
来源：
AUTOMATION EQUIPMENT AND SYSTEMS, PTS 1-4 | 2012年 / 468-471卷
关键词：
Information Extraction; SQL-DMO; SQL Server; Skill Assessment;
D O I：
10.4028/www.scientific.net/AMR.468-471.278
中图分类号：
TP [自动化技术、计算机技术];
学科分类号：
0812 ;
摘要：
This article describes the SQL Server object model SQL-DMO. Through the object model all information of SQL Server's internal objects can be obtained, including databases, data tables, stored procedures and triggers and so on. Analysis the method of the object's information extraction. Get the child object by analyzing the parent object's collection property and get internal information by analyzing the object's properties. A visual basic procedure is designed to achieve the table's structure information for all user tables in specified SQL Server database. This method is more complete and simple than the method based on system table.
引用
收藏
页码：2878 / +
页数：2
相关论文
共 50 条
  • [31] Solutions on oil refinery information storage construction on the basis of MS SQL server
    Sherstuk, Y
    EXPERT SYSTEMS WITH APPLICATIONS, 2004, 26 (01) : 73 - 79
  • [32] Data acquisition in Virtual Instruments system based on labVIEW and SQL server
    Hua, Cong
    Jing, Liu
    Qiu Mian-Hao
    Zhang Xiao-fen
    ISTM/2007: 7TH INTERNATIONAL SYMPOSIUM ON TEST AND MEASUREMENT, VOLS 1-7, CONFERENCE PROCEEDINGS, 2007, : 2089 - 2092
  • [33] Organization and Query of Point Clouds Data Based on SQL Server Spatial
    Chen, Yijin
    Zhang, Huixia
    Fu, Xiaoxue
    PROCEEDINGS OF 2010 3RD IEEE INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND INFORMATION TECHNOLOGY (ICCSIT 2010), VOL 7, 2010, : 178 - 181
  • [34] The Research on the New Type of Belt Conveyor Barometric Real-time Detection Device Based on the SQL Server
    Su, Chang
    Xu, Fenglei
    2016 2ND INTERNATIONAL CONFERENCE ON MECHANICAL, ELECTRONIC AND INFORMATION TECHNOLOGY ENGINEERING (ICMITE 2016), 2016, : 370 - 373
  • [35] Research and Comparison of SQL Optimization Techniques based on MapReduce
    Liu, Qin
    Hong, Haijie
    Zhu, Hongming
    Fan, Hongfei
    INTERNATIONAL CONFERENCE ON COMPUTER SCIENCE AND APPLICATION ENGINEERING (CSAE), 2017, 190 : 286 - 292
  • [36] Tuning an SQL-based PDM system in a worldwide client/server environment
    Müller, E
    Dadam, P
    Enderle, J
    Feltes, M
    17TH INTERNATIONAL CONFERENCE ON DATA ENGINEERING, PROCEEDINGS, 2001, : 99 - 108
  • [37] Research and development on ticketing system based on SQL database
    Duan, Yuntao
    Hu, Siping
    PROCEEDINGS OF THE 1ST INTERNATIONAL CONFERENCE ON INFORMATION TECHNOLOGIES IN EDUCATION AND LEARNING, 2016, 32
  • [38] 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
  • [39] Design and Implementation of Database Security Based on Server SQL Online Course Selection
    Xu, Jingxiu
    Xiong, Jinmeng
    PROCEEDINGS OF THE 2016 INTERNATIONAL CONFERENCE ON SENSOR NETWORK AND COMPUTER ENGINEERING, 2016, 68 : 211 - 214
  • [40] A web page query technology based on ASP.NET and SQL Server
    Zhao, Guangshun
    Meng, Qingjin
    Bi, Jianxue
    2021 PROCEEDINGS OF THE 40TH CHINESE CONTROL CONFERENCE (CCC), 2021, : 6466 - 6469
12345