Active Database Pattern Based on SQL Server
Chunfang Wang
Abstract
Chunfang Wang
Abstract
As the RDBMS,SQL Server was used by more and more commercial organizations,but SQL Server was still the passive database management system.This article proposed the active database pattern based on SQL Server,which can enhance the function of SQL Server,enlarge the application field of SQL Server.According to the data processing procedure of SQL Server,the characteristics of active database are analyzed,and the architecture of active database was given based on SQL Server.Finally the data processing procedure was explained with an example.
A significance statement is not available in the OpenAlex record.
A contribution statement is not available in the OpenAlex record.
Method details are not available in the OpenAlex metadata.
Findings are not separately available in the OpenAlex metadata.
Limitations are not available in the OpenAlex metadata.
Application details are not available in the OpenAlex metadata.
As the RDBMS,SQL Server was used by more and more commercial organizations,but SQL Server was still the passive database management system.This article proposed the active database pattern based on SQL Server,which can enhance the function of SQL Server,enlarge the application field of SQL Server.According to the data processing procedure of SQL Server,the characteristics of active database are analyzed,and the architecture of active database was given based on SQL Server.Finally the data processing procedure was explained with an example.
Key concepts: Data Transformation Services, User-defined function, Computer science, Log shipping, Autocommit, Database, Stored procedure, Business Intelligence Markup Language