Recently, as the establishment of information system has called for standardization, a variety of methodologies have emerged and its management tools are under development. While the resulting quality of data was considered important in the past, now...
Recently, as the establishment of information system has called for standardization, a variety of methodologies have emerged and its management tools are under development. While the resulting quality of data was considered important in the past, now more attention is paid to the structural quality that brings specific results. This indicates that if standardization is not physically and properly reflected, it is not actually standardized, despite a well-organized standardization.
In this thesis we presented a method to design and utilize a DDL Trigger that is provided in the DBMS itself to reflect such standard data in a physically correct manner based on the premise of standardization. When DDL occurs, the application is decided by linking and comparing it with the central standard data, the purpose of which is fundamentally to block the production of non-standard data through pre-verification. In particular, since the parameter of procedure is directly involved in table operation, data stability can be enhanced if it is managed in the standard data area. In conclusion, the DDL Trigger has such effects as saving potential follow-up cost and maintaining the consistency of data by forcing the standard policy, not just simply suggesting the standard.