The Research of Information Extraction in Information System from SQL Server Based on System Table

Huan Tong Chen; Wei Zheng; Yao Fei Chen; Ying Hua Ni

doi:10.4028/www.scientific.net/AMR.675.35

Paper Titles

Comparative Analysis of Industrial Restructuring in the Resource-Based Cities Based on Shift-Share Method
p.17

Research on Symbiotic Order of the Eco-Industrial Chain for Recycling Waste Materials Based on Input-Output Method
p.21

Research and Design of Information System for Mobile Autonomous and Open Learning Based on RIA and Integrated Framework
p.27

The Robust Control Research for Non-Linear Inverted Pendulum System in Mechanical Industry
p.31

The Research of Information Extraction in Information System from SQL Server Based on System Table
p.35

Railway Passenger Trains Information Inquiry System Based on Short Message Modem
p.39

Vehicle-Mounted Alarm and Navigation Positioning System with Properties of Information System for Industry
p.43

Evaluation of the Efficiency of Information Sharing Policies Using a TOPSIS Method in Materials Supply Chain
p.47

Study on Elevator Manufacturing Industry with Modeling and Simulation of Virtual Elevator Control System Based on TwinCAT Soft-PLC
p.51

HomeAdvanced Materials ResearchAdvanced Materials Research Vol. 675The Research of Information Extraction in...

The Research of Information Extraction in Information System from SQL Server Based on System Table

Abstract:

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.

You might also be interested in these eBooks

View Preview

Info:

Periodical:

Advanced Materials Research (Volume 675)

Pages:

35-38

DOI:

https://doi.org/10.4028/www.scientific.net/AMR.675.35

Citation:

Cite this paper

Online since:

March 2013

Authors:

Huan Tong Chen, Wei Zheng, Yao Fei Chen, Ying Hua Ni

Keywords:

Information Extraction, Skill Assessment, SQL Server, System Table

Export:

RIS, BibTeX

Price:

Permissions CCC:

Request Permissions

Permissions PLS:

Request Permissions

Сopyright:

Citation:

References

[1] Xu Jun, Liu Quan Bo, He Ke Kang. CAA new area of research - IT Skills Assessment Automation (1), E-education Research, vol. 105, no. 1(2002),P. 33-37.

Google Scholar

[2] Chen Yaofei, Chen Huantong, Ni Yinghua. Automatic Marking in SQL Server Skills Assessment Based on XML, Computer Systems & Applications, Vol. 3(2010),P. 158-161, 186.

Google Scholar

[3] LI Gui-cheng, CUI Jun. Design and implementation of automatic examination paper markingfor database operation, Computer Engineering and Design, Vol. 25, no. 6(2004), P. 1005-1006, 1018.

Google Scholar

[4] Chen Yaofei, Chen Huantong. Application of System Table in SQL Server Skills Assessment, Journal of Jinhua College of Profession and Technology, Vol. 2(2008), P. 36-38.

Google Scholar

[5] Chen Yaofei, Chen Huantong. Design and Realization of Skills Assessment Scheme for SQL Server Database, Computer Applications and Software, Vol. 11(2009),P. 147-149.

Google Scholar