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 条
  • [1] Automatic Marking of SQL Server Based on SQL-DMO
    Chen, Yaofei
    Zheng, Wei
    Chen, Huantong
    SENSORS, MEASUREMENT AND INTELLIGENT MATERIALS, PTS 1-4, 2013, 303-306 : 2369 - +
  • [2] 基于SQL-DMO的SQL Server远程管理
    田原
    辽宁工程技术大学学报(自然科学版), 2006, (S2) : 185 - 187
  • [3] 利用SQL-DMO操纵MS SQL Server数据库
    顾海杰
    电脑编程技巧与维护, 2002, (03) : 50 - 53
  • [4] 使用SQL-DMO增强基于SQL Server的应用程序功能
    年庆飞
    电脑编程技巧与维护, 2000, (11) : 55 - 58
  • [5] The Research of Information Extraction in Information System from SQL Server Based on System Table
    Chen, Huantong
    Zheng, Wei
    Chen, Yaofei
    Ni, Yinghua
    ADVANCED RESEARCH ON INDUSTRY, INFORMATION SYSTEM AND MATERIAL ENGINEERING, 2013, 675 : 35 - +
  • [6] 基于SQL-DMO的SQLServer应用系统
    赵凯
    兵工自动化, 2004, (04) : 87 - 88
  • [7] 基于SQL-DMO的数据备份和恢复的设计与实现
    王西锋
    张晓孪
    李乃乾
    陕西理工学院学报(自然科学版), 2007, (03) : 46 - 50
  • [8] 用Delphi对SQL-DMO进行封装的一种实现
    黄河
    温州职业技术学院学报, 2003, (03) : 37 - 41
  • [9] Research on the Remote Data Collection Based SQL Server
    QI Xiangyang~1 LIN Shuzhong~1 CUI Hui~2 WANG Jiangfeng~2 SUN Huilai~1 (1.School of Mechanical & Electronic Engineering
    武汉理工大学学报, 2006, (S3) : 828 - 832
  • [10] Research on the remote data collection based SQL Server
    Qi Xiangyang
    Lin Shuzhong
    Cui Hui
    Wang Jiangfeng
    Sun Huilai
    1ST INTERNATIONAL SYMPOSIUM ON DIGITAL MANUFACTURE, VOLS 1-3, 2006, : 828 - 832
12345