| 摘要 |
A system and a method for analyzing performance of unstructured query language in advance are provided to manage SQL(Structured Query Language) for each business, purpose, and application program by collecting, analyzing, and checking an access path and a raw program before an unstructured SQL program is programmed. A collector(42) collects and classifies dispersed SQL. A storing unit(44) stores the SQL collected and made by the collector, and a storing location, a type, a business type, and a serial number of an original copy related to the SQL. A processing unit(46) stores the access path to a plan table by explaining all SQL received from the collector or the storing unit, and relates the access path of each SQL stored in the plan table to the SQL stored in the storing unit. An analyzer(48) combines and analyzes the SQL stored in the storing unit, call information of the SQL, the access path stored in the processing unit, a catalog table stored in a DBMS(DataBase Management Program), and outputs a result to a screen. |
