METHOD AND SYSTEM FOR MANAGING SQL QUERY USING METASQL COMPONENT

摘要

PURPOSE: A method and a system for managing an SQL(Structured Query Language) query using a metaSQL component are provided to enhance efficiency for the system development by managing the SQL query at the outside in order not to execute recompile again even if the SQL query of a program source is changed. CONSTITUTION: An SQL query file manager manages the SQL query as a file form having a constant extension. A memory stores an SQL query file managed by the SQL query manager in a constant directory. A program source part(10) is inserted by the information of the SQL query file. The metaSQL component(20) brings a query execution result by reading the SQL query file information from the program source part and accessing a database(40), and returns the execution result to the program as vector.