KR20040029616A - A system and management method have enterprise type program source analysis function - Google Patents

Abstract

PURPOSE: A system and a method having a function to maintain/analyze a source of an enterprise program are provided to reduce a personal/time expense for maintaining/analyzing the program by storing the source of the enterprise program in a database and offering a result of a desired form as analyzing/classifying the source into each type by using the database. CONSTITUTION: An analysis engine part(100) selectively receives the needed source information from an application server(400) and a database server(500), and analyzes the source data of the inputted program. An engine manager(200) collects the source data and a script of the enterprise and transfers it to each engine of the analysis engine part, and stores/manages the result data systematically by constructing the useful level information in an analysis data database(210) as receiving the result data analyzed by each engine. An inquiry part(300) provides the information to a user(700) by dividing the constructed data into a statistics part, an application part, a database part, a business system part, and an effect analysis part.

Description

A SYSTEM AND MANAGEMENT METHOD HAVE ENTERPRISE TYPE PROGRAM SOURCE ANALYSIS FUNCTION}

The present invention relates to a system and method for analyzing and processing a source of an enterprise program. More specifically, the program source is built into a database for an enterprise program, and then the source is parsed according to a business model for rapid reporting. It's about a system for doing that.

In general, as a method of analyzing a program source and informing a user, the developed program is inputted and processed as a simple form, rather than a database, which is developed by developers. There was a problem in that a large amount of manpower was required as well as time consuming due to the search and syntax analysis.

In addition, in the related art, there is a problem that only a specific form such as SQL (Structured Query Language) can be processed, rather than being able to analyze program sources by model.

The present invention is proposed to improve the problems in the prior art as described above, and the user according to the tool (Tool) provided by grouping the source by type and analyzing the database (Source) of the enterprise type program (Source) The goal is to reduce the human and time costs of managing, maintaining, maintaining, and analyzing the program by providing the results in the form desired by the administrator.

1 is a schematic configuration diagram for information processing of the program source management and analysis system of the present invention.

2 is a flowchart illustrating a process and sequence of data according to an operation of the system of the present invention.

<Explanation of symbols for the main parts of the drawings>

100: analysis engine unit 110: AP analysis engine

120: DB information input engine 130: business mapping engine

200: engine management unit 210: analysis data DB

220: AP engine manager 230: DB engine manager

240: business engine manager 300: inquiry

400: AP server 500: DB server

700: user

The object includes: an analysis engine unit for analyzing a program source from information collected from an application server and a database server; An engine manager for building data analyzed by the analysis engine as useful information in a database; And it is possible to achieve through the system with the maintenance / maintenance management and analysis function of the enterprise program source, including; lookup unit to provide the data constructed in accordance with the user's requirements.

Hereinafter, specific embodiments of the present invention will be described in detail with reference to the accompanying drawings.

First, referring to the configuration of the system according to the present embodiment, as illustrated in FIG. 1, the original source of the developed program of the server type / middleware type / client type is referred to as an application (hereinafter referred to as “AP”) server ( 400) and an analysis engine unit 100 for obtaining and analyzing data from a database (hereinafter abbreviated as “DB”) server 500 and analyzing the data analyzed by the analysis engine unit 100 with useful information. The engine management unit 200, which is stored and managed on the data DB 210, and the constructed analysis data data are largely classified into statistics, AP, DB, business system, and impact analysis. ) Consists of an inquiry unit 300 for providing.

Among them, the analysis engine 100 analyzes the AP analysis engine 110 for analyzing the source of the analysis target from the AP server 400 managing the AP source file, and the collected information, and analyzes the result. The DB information input engine 120 for inputting the data DB 210 and the business mapping engine 130 for mapping the determined business information and the information of the AP / DB are provided.

In addition, the engine manager 200 includes an AP engine manager 220, a DB engine manager 230, and a business engine manager 240 for managing each engine 110, 120, and 130 constituting elements of the engine unit 100. .

In the inquiry unit 300, a program developer or a user 700 who performs an analysis project is connected through an in-house communication network or a local area network (LAN).

On the other hand, the application analysis target of the AP server 400 is mainly developed in C / C + +, Delphi.

Oracle database is the first analysis target of DB server 500. It collects table information, index, view, classification information (Synonym), DB-Link and other Shell Script, Stored Procedure Script, etc. To build information.

The maintenance / maintenance management and analysis of the program source by the solution system of the present invention constituting the above-described hardware configuration will be described with reference to FIG. 2.

First, the AP server 400, in which the AP source files are managed, is written in products such as Pro * C, middleware in Tuxdo, and client tools in Delphi and Power Builder. When the program source is imported (ST 1) , the file collected in the file storage of the server is stored in the server where the analysis engine is installed (ST 2) .In this way, when the file is saved, the AP engine manager ( In 220, path information of the stored file is constructed in the analysis data DB 21. (ST 3) ,

Subsequently, the generated file path information and DDL (Data Definition Language) script information are transmitted to the AP analysis engine 110, and the analysis results received from the AP analysis engine 110 are analyzed. 210). (ST 4)

At this time, the AP analysis engine 110 extracts the interrelationships, dependencies, and table use relations between the corresponding program and other programs by reading and analyzing the AP sources of the programs constructing the enterprise system through the path information of the received files. In this case, the information is delivered to the AP engine manager 220. (ST 5)

Meanwhile, the DB engine manager 230 collects DB information such as Table information, Index, View, Synonym, Trigger, and DDL script from the DB server 500 of the corresponding company (ST 6) , DB information input engine 120 is to look up and analyze a variety of information collected in the database of the company and then to build in the analysis data DB 210 of the system engine. (ST 7)

In addition, the business mapping engine 130 establishes a relationship between the system, the program, and the database by grouping the naming conventions of the corresponding companies based on the analyzed AP information and the DB information. (ST 8)

In particular, in the business mapping engine 130 of the present system, the mapping is performed based on a naming convention used at the time of designing a program. Through this, it is possible to grasp program or database information that deviates from the naming convention. In addition, it is possible to improve the quality of the corporate system by modifying / supplementing based on the identified information.

The system configuration information constructed by the above process provides the information in various formats according to the use of the user 700 in the inquiry unit 300, and (ST 9) the user can later modify or change the corresponding company system. It is possible to prevent accidents that may occur in the city.

On the other hand, in the information shown by the query unit 300, the statistics section (I) is based on the information extracted by the system analysis, the information on the resource reserves for each part and the whole of the program and DB possessed by the system This information is provided by the business group and type.

In other words, the AP section (II) provides mutual calling relations, dependencies, DB usage information, etc. of programs, and visually provides overall structure information and system information from the work system to the last DB.

In addition, the DB section III provides various types of DB information, related information, and usage information by the program.

The business system sector (Ⅳ) can provide the AP / DB resource information for each company's work.

Lastly, the impact analysis section (Ⅴ) analyzes the impact of a specific program or DB information on other objects and provides the relational information. Through this, the user grasps the pre-impact information on the object to be modified and performs stable development work. Can be done.

In addition, the file transfer function for downloading the target program source to be analyzed by the engine, the script extraction function of the DB, the function for querying the program source, the function for querying the image of the corresponding program, and the function for querying related document files are added. It includes the printing function for document processing and the function to save the search result in Microsoft Excel file (csv format) and download it to the user's PC.

In addition, the inquiry unit 300 of the present system includes a section for providing system resource statistics and the entire system system as a graphic function.

Therefore, by analyzing the original source of the program developed in the general language of server type, middleware type, and client type through the solution system of the present invention, extract the contents of the components included in the program, and analyze the correlation of the extracted contents You can see that the contents can be databased in a new form.

In addition, although specific embodiments (configurations and effects) of the present invention have been described and illustrated above, the local configuration of the system constituting the solution of the present invention and the analysis process and procedures using the same may be variously modified and implemented by those skilled in the art. It is self-evident.

However, such modified embodiments should not be individually understood from the technical spirit or the prospect of the present invention, and such modified embodiments shall fall within the appended claims of the present invention.

As described above, the present invention can compensate for the disadvantages that it is not easy to maintain the association and consistency between programs due to a long development period and a large number of program sources in the case of large-scale projects. Since the developed status can be grasped at a glance, there is an advantage of making it easy to maintain and maintain the enterprise-type project and overall analysis and development.

Therefore, when the system of the present invention is applied to the project in the future, it is possible to significantly reduce the time and input required for maintenance, repair, and analysis in the project, and also have many effects in terms of cost reduction due to the efficient operation of idle personnel. It will be enjoyed.

Claims (3)

Among the programs constructing the corresponding company system, the source information required from the application server 400 in which the analysis target application source (AP Source) is managed and the database server 500 in which various DB information of the company is constructed are obtained. An analysis engine unit 100 which selectively obtains and analyzes source data of an input program; Collect and deliver the source data and scripts of the company to each engine of the analysis engine unit 100, and receive the result data analyzed in each engine to build useful level information in the analysis data database 210 systematically Engine management unit 200 to store and manage the; An inquiry unit 300 for dividing the constructed data into a statistic section, an application section, a database section, a business system section, and an impact analysis section so as to inquire each corresponding information to the user 700 in a desired form; System with maintenance and management of enterprise program source, characterized in that the configuration, including. The method according to claim 1, The analysis engine 100 may include an application analysis engine 110 for extracting a correlation between a corresponding program and other programs, a table use relationship, and the like, and a database information input engine for searching and inputting various types of information of a corresponding company ( And a business mapping engine (130) for grouping the naming conventions of the companies in stages of extraction. A storage step of designating a corresponding AP server having an application (AP) source file for building an enterprise system, collecting the source file from the server, and storing the source file primarily in a server on which an analysis engine is installed; Constructing the path information of the stored file in the analysis data DB, but delivers the built file path to the AP analysis engine to perform the analysis, and receives the analysis result again to build the AP information to build in the analysis data DB ; DB information construction step of collecting the DB information of the company from the DB server of the company and building it in the analysis data DB; Analyze the constructed AP / DB information to extract and inform the interrelationships between the program and other programs, and group the naming conventions of the company in the extraction stage to build business group and level information A processing step of processing to a level specified by the user; An inquiry step of dividing the processed information into a statistics section, an application section, a database section, a business system section, and an impact analysis section to provide each user with a corresponding visual information; Maintenance and maintenance of the enterprise program source, characterized in that consisting of.