KR101927578B1

KR101927578B1 - System for providing enterprise information and method

Info

Publication number: KR101927578B1
Application number: KR1020160016277A
Authority: KR
Inventors: 김백규
Original assignee: 중소기업은행
Priority date: 2016-02-12
Filing date: 2016-02-12
Publication date: 2019-03-07
Also published as: KR20170094935A

Abstract

The present invention relates to a system and method for providing enterprise information, and a method for providing enterprise information in an enterprise information providing system according to an embodiment of the present invention includes collecting source data for a plurality of enterprise information from an accounting server and an external server, Generating a company name index using the morphological analysis method for the source data, analyzing a reference relationship between the companies for the indexed company, and analyzing a reference relationship between the companies by using a multidimensional model Generating a plurality of data marts; and generating a plurality of tables for the plurality of data marts by subject and providing the plurality of tables to the sub-system.

Description

BACKGROUND OF THE INVENTION 1. Field of the Invention The present invention relates to an information providing system,

The present invention relates to a system and method for providing enterprise information.

A data warehouse (DW) system is a system for users to analyze data of various operating systems. While the operating system supports certain functions for operations such as inventory management, accounting information, and sales system, the data warehouse can provide a function to integrate and analyze data generated by various operating systems.

On the other hand, financial institutions such as conventional banks have used the transaction information to identify major customers and buyers of the clients and to use them for marketing and risk management.

However, if only the transaction information of the financial institution is used, information can be confirmed only for the company having the account in the bank, and it is difficult to confirm the company by using only the account number. In addition, since companies often use a plurality of account numbers, it is difficult to accurately analyze the data of an opponent company or the like with respect to an arbitrary company.

[Prior Art Literature]
Korean Patent Laid-Open No. 10-2014-0135277 ( published on November 26, 2014 )
Korean Patent Laid-Open No. 10-2002-0003858 (published Jan. 15, 2002)

The present invention has been proposed in order to solve the above problems, and it is an object of the present invention to provide an enterprise information providing system and a business information providing system which enable companies to analyze not only companies that directly deal with financial institutions, The purpose of the method is to provide.

It is still another object of the present invention to provide a system and method for providing enterprise information, which can improve data results, confirmation of consistency, manual labor, and time consuming tasks.

According to another aspect of the present invention, there is provided a company information providing method for collecting a plurality of pieces of enterprise information from an accounting server and an external server, Generating a plurality of data marts by generating a multidimensional model for each company analysis topic on the data of the data warehouse; And generating a plurality of tables for each of the plurality of data marts by subject and providing the plurality of tables to the subsystem.

The information related to the withdrawal is processed as purchase and the information related to the deposit is processed as sales, thereby analyzing the customer and the buyer.

The company information providing system of the present invention collects source data for a plurality of company information from an accounting server and an external server, generates a company name index using the morpheme analysis method for the collected source data, A plurality of data marts for generating a multidimensional model for each company analysis subject for the data of the data warehouse and a plurality of tables for each subject matter for the plurality of data marts, And an information providing unit for providing a table generated according to a request of the subsystem.

The data warehouse constructs a company name dictionary in a dictionary form based on the company name based on the company name, updates the newly collected information to the company name dictionary, and analyzes reference relationships among the companies based on the company name dictionary .

As described above, according to the present invention, when collecting information on a plurality of companies and collecting company information including general information, financial information, and non-financial information, a database is constructed so that accurate and objective Information can be provided.

Also, according to at least some embodiments, since non-financial information including the company longevity, business structure, industry orientation, management ability, and affiliation is also collected and analyzed with respect to the main business enterprise in which a plurality of companies are trading, It is possible to accurately grasp the value of the main business enterprise that did not exist, and it is effective to increase the accuracy of the enterprise analysis based on this.

1 is a block diagram showing a schematic configuration of a corporate information management system according to an embodiment of the present invention and its associated source system and subsystem.
2 is a block diagram illustrating a company information providing system according to an embodiment of the present invention.
FIG. 3 is a flowchart illustrating a method for providing enterprise information according to an embodiment of the present invention.
4 is an example of a table generated by the enterprise information providing system according to the embodiment of the present invention.
5 is a flowchart illustrating an example of a company analysis method according to an embodiment of the present invention.

Also, the singular forms "as used herein include plural referents unless the context clearly dictates otherwise. In the present application, the term " comprising " or " comprising " or the like should not be construed as necessarily including the various elements or steps described in the specification, Or may be further comprised of additional components or steps.

Further, the suffix " module " and " part " for components used in the present specification are given or mixed in consideration of ease of specification, and do not have their own meaning or role.

Furthermore, terms including ordinals such as first, second, etc. used in this specification can be used to describe various elements, but the elements should not be limited by the terms. The terms are used only for the purpose of distinguishing one component from another. For example, without departing from the scope of the present invention, the first component may be referred to as a second component, and similarly, the second component may also be referred to as a first component.

Hereinafter, exemplary embodiments of the present invention will be described in detail with reference to the accompanying drawings, wherein like reference numerals refer to like or similar elements throughout the several views, and redundant description thereof will be omitted.

In the following description, well-known functions or constructions are not described in detail since they would obscure the invention in unnecessary detail. It is to be noted that the accompanying drawings are only for the purpose of facilitating understanding of the present invention, and should not be construed as limiting the scope of the present invention with reference to the accompanying drawings.

1 is a block diagram showing a schematic configuration of a corporate information management system according to an embodiment of the present invention and its associated source system and subsystem.

1, a company information providing system 100 comprises a data house 120 having an object relational model for source data stored in a source system 10, And constitutes a plurality of data marts 140 which are multidimensional models. The information providing unit 160 of the company information providing system 100 may analyze the data of the plurality of data marts 140 and provide the analyzed data to the requesting subsystem 20.

In particular, the enterprise information providing system 100 can build company-specific information in a dictionary by utilizing a text data analysis technique on the metadata obtained from the source system 10. [ The company-specific information in the following form is called a company name dictionary. The company name dictionary can be in the form of a table for indexing, and the names of the companies are listed so as not to be duplicated.

The company name dictionary includes not only the business partner of the bank but also the other business partner of the business concerned.

The source system 10 may include an accounting server 12 and an external source server 14.

The account system server 12 may include various servers or databases (e.g., credit, receipt, foreign exchange, agency system, etc.) for processing the service being used by the bank.

The external source server 14 is a server outside the corresponding bank that provides the enterprise data. The external source server 14 may include, for example, a credit rating agency server or an accountant server.

When the credit rating agency server requests a credit rating of a company that the financial institution trades, the credit rating agency server analyzes the credit rating of the credit rating agency and transmits the analyzed result to the company information providing system 100.

In addition, according to an embodiment of the present invention, it is possible to provide credit rating information for a company requested by the enterprise information providing system 100. [ For example, if the enterprise information providing system 100 selects a main business for an enterprise, analyzes the selected main business, and requests a credit rating for the main business based on the analysis result, The rating agency may provide the credit rating information of the enterprise.

The accounting agency server provides the financial information of the company including the information about the economic resources, capital fluctuation and cash flow of the enterprise to the enterprise requested by the enterprise information providing system (100).

As described above, the enterprise information providing system 100 collects a plurality of pieces of business information from at least one of the server 12 and the external source server 14, It is extracted and stored for each company, and a database is constructed based on the stored company-specific information.

The company information providing system 100 provides company-specific information or company-related analysis information at the request of the subsystem 20.

The subsystem 20 can acquire the analyzed information of the source data using the enterprise information providing system 100. [

The subsystem 20 may be a business terminal inside a bank, a web server accessible by the business terminal, such as a sales performance portal, or another information utilization system. The information utilization system may include a credit management system, an early warning system, and the like.

A detailed description of the enterprise information providing system 100 according to the present invention will be described later with reference to FIG.

1, the company information providing system 100 is illustrated as a server separate from the source system 10 and the subsystem 20, but the present invention is not limited thereto. In the present invention, The providing system 100 may be comprised of a source system 10 and a subsystem 20 and one system (or server) or may comprise at least two or more servers (or devices) It is clear that it is possible to implement the server in the form of a separate server for each component constituting each server.

Hereinafter, a company information providing system 100 and a configuration method thereof according to the present invention will be described in detail with reference to FIG.

2 is a block diagram illustrating a company information providing system according to an embodiment of the present invention.

2, the enterprise information providing system 100 according to the present invention may include a data house 120, a data mart 140, and an information provider 160. [ In the present invention, the enterprise information providing system 100 may include a staging area 110 and a plurality of table storage units 150.

The staging area 110 is a temporary area for receiving the source data to the data house part 120. In other words, the staging area may temporarily store the data in order to load the source data into the data house part 120. The staging area may not require a predetermined format for storing data, and thus may store various types of data such as a table format or a file format. The staging area is not an essential component of the enterprise information providing system 100 according to the present invention and may be added according to necessity in implementation.

The data house unit 120 stores the collected source data and performs predetermined refining or processing on the data to construct a data house which is integrated data of an ER (Entity-Relationship) model. In other words, the data house unit 120 can integrate and refine various refined source data into one model (ER model).

More specifically, the data house unit 120 integrates the refined source data and extracts the company name from the enterprise-related data having a relationship with each other to generate the company name dictionary 130. The company name dictionary is used to build an enterprise integrated information database.

In addition, the data house unit 120 can perform predetermined data processing for eliminating duplication of constituent data and maintaining consistency. Extract company name and build company name text dictionary.

The data mart 140 may construct multidimensional modeled data centered on the analysis subject to the integrated data of the data house 120 based on predetermined business rules. For example, the data mart 140 may be configured as statistics on an analysis topic, such as statistics. For example, the data mart 140 may collect data necessary for performance analysis such as the original performance and the adjustment performance based on the reference performance according to a certain model rule. Here, the adjustment results are based on the following factors: consideration of customers, reclassification of customers, reverse margins, others, recommendation accounts, manual adjustments, non-performing MOUs and adjustment of employee earnings.

In addition, the data mart 140 according to the present invention groups the analysis criteria (configuration data) implemented in the data house unit 120 according to a predetermined business rule, for each analysis purpose (for example, purchase / sale) . The data mart 140 may not perform the processing of the data in addition to simply aggregating (e.g., grouping) the analysis criteria implemented in the data house unit 120. [

An example of the analysis standard is as follows.

Analysis of change in sales: 3 month average sales immediately before the application average compared to the average sales amount increased more than the predetermined standard or decreased more than the predetermined standard

Sales / Purchase concentration: Sales or purchase amount is concentrated more than the standard ratio

Credit Rating of Major Customers: Major customers as of the date of application are large corporations or credit rating agencies.

Whether to find new customers: Finding new customers for the past year and creditworthiness of new customers

(Sales - Purchase) Amount Change: Revenue transferred from the past 1 year - Amount of purchase increased above the standard rate

Inter-company transaction network analysis: Sales / purchase transaction with the target company by utilizing the DB of the main sales / buyer transaction information node and creating a node between the transaction and sales transaction company. To establish an intercompany trading network and analyze the bankruptcy risk propagation etc.

The plurality of table storage units 150 according to the present invention may constitute a plurality of tables for each data mart of a plurality of data marts. For example, the table may include at least one of a table of information on the main customers and main buyers by company, an analysis table of transactions of major customers and buyers, an analysis table of enterprises with risk management, .

The information providing unit 160 provides company information to a server and a terminal connected through a network communication network.

FIG. 3 is a flowchart illustrating a company information providing method according to an embodiment of the present invention, and FIG. 4 is an example of a table generated by a company information providing system according to an embodiment of the present invention.

Referring to FIG. 3, not only company-related information including general information, financial information, and non-financial information, but also details of settlement of accounts, history of trades, delivery unit price Related information including the account information (S100).

The company name index is generated using the morphological analysis method for the collected source data (S120).

The company name index can be called a company name dictionary. First, the name of the company is extracted from the collected source data using the morphological analysis method, and the data cleaning process such as deleting the duplicated data is performed. After the data cleaning process, the company name dictionary can be constructed by performing data conversion according to the format of an arbitrary company name dictionary.

The reference relationship between the companies is analyzed for the indexed company (S130).

For example, only the transactions identified as intercompany transactions are extracted, the withdrawal related information is processed as purchase, and the deposit related information is processed as sales to analyze the customer and the buyer. Monthly statistics are used to obtain status information on major customers and buyers of the company. Analyze the share of transactions based on the current status of the customer and the buyer.

As described above, the company information providing system of the present invention analyzes the relationship between companies based on the company name as an index based on the integrated data including the information related to the account and the general information not related to the account, (S), counterparty, and counterparty account.

A plurality of data marts are generated as a multidimensional model for the corporate analytic subject for the data of the data warehouse (S140).

The plurality of data marts are analyzed by topic to generate a plurality of tables and provided to the subsystem (S150).

For example, a table of sales structure through analysis of transaction weight, an enterprise analysis table for each company, and a transaction network analysis (default risk propagation) table are created.

Based on the information provided by the service system, the service system can acquire information on the non-traded company of the counterparty trading with the trading company. It is possible to extract a company having a low level of accumulated deposit amount as compared to the declared sales amount and conduct marketing for attracting a settlement account to the company.

It is possible to perform risk management by acquiring information on companies with a sharp decrease in sales information and sales information.

By applying the system according to an embodiment of the present invention, it is possible to provide differentiated services, such as providing management consulting for a sales-oriented company, or providing a preferential rate to a buyer of a superior company.

4, the sales company name, the computer customer number, the sales company account number, the transaction bank code, the sales company business number, the purchase company name, the computer customer advocate, the purchase company account number, the transaction Bank code, purchasing company number, sum of monthly transaction amount, month of transaction basis, and transaction weight.

5 is a flowchart illustrating an example of a company analysis method according to an embodiment of the present invention.

As an example of a company analysis method, a method of generating evaluation information for each company will be described. In order to generate company-specific evaluation information, text data is analyzed on the financial information and non-financial information of a trading company according to a company name using a company name dictionary, and the evaluation factors for the trading company are classified into financial evaluation and non-financial evaluation (S410) .

Then, a ratio value corresponding to the evaluation factors classified as financial evaluation and non-financial evaluation for the main business is generated (S420). At this time, the respective ratio values corresponding to the respective evaluation factors can be generated by predetermined criteria based on the importance judgment of the company management person in charge.

Thereafter, the relationship between the generated ratios and the change trend are analyzed (S430).

Thereafter, the credit rating for the main business is determined based on the analysis result (S440). For example, in determining the credit rating for the main business, at least one of the rating agencies requests the server to receive credit rating information (e.g., a credit score corresponding to at least one credit rating item) Or may determine the credit rating for the main business by using a predetermined credit rating calculation method (or algorithm) previously stored in the financial institution server.

Thereafter, the evaluation information for each company is generated based on the determined credit rating of the main business enterprise (S450). Through the company-specific evaluation information, management companies and financial institutions that manage a plurality of companies can set a company credit management result such as direct marketing, including direct marketing, and a credit limit to a company in the corporate credit business as a whole. In particular, financial institutions will be able to minimize the risk of recovering from providing credit services.

The above-described method can be implemented by various means. For example, embodiments of the present invention may be implemented by hardware, firmware, software, or a combination thereof.

In the case of hardware implementation, the method according to embodiments of the present invention may be implemented in one or more Application Specific Integrated Circuits (ASICs), Digital Signal Processors (DSPs), Digital Signal Processing Devices (DSPDs), Programmable Logic Devices (PLDs) , FPGAs (Field Programmable Gate Arrays), processors, controllers, microcontrollers, microprocessors, and the like.

In the case of an implementation by firmware or software, the method according to embodiments of the present invention may be implemented in the form of a module, a procedure or a function for performing the functions or operations described above. The software code can be stored in a memory unit and driven by the processor. The memory unit may be located inside or outside the processor, and may exchange data with the processor by various well-known means.

The embodiments disclosed herein have been described with reference to the accompanying drawings. Thus, the embodiments shown in the drawings are not to be construed as limiting, and those skilled in the art will understand that the present invention can be combined with each other, and when combined, some of the components may be omitted.

Here, terms and words used in the present specification and claims should not be construed as limited to ordinary or dictionary meanings, but should be construed as meaning and concept consistent with the technical idea disclosed in the present specification.

Therefore, the embodiments described in the present specification and the configurations shown in the drawings are only examples described in this specification, and not all of the technical ideas disclosed in this specification are described. Therefore, It is to be understood that equivalents and modifications are possible.

10: Source system
12: Account Server
14: External source server
120: Data House
140: Data Mart
160: Information provision

Claims

As a method for providing enterprise information of a corporate information providing system of a financial institution,
The data warehouse collects source data for a plurality of enterprise information from an accounting server and an external server and generates a company name index using the morpheme analysis method for the collected source data. Creating a company name dictionary, the source data being aggregate data including information related to the account and general information not related to the account;
Analyzing a reference relationship between the companies for the indexed company in the data warehouse;
Generating a plurality of data marts by generating a multidimensional model for each data analysis model of the data warehouse; And
Creating a plurality of tables for the subject matter in the data mart and providing the tables to the subsystem
, &Lt; / RTI &
Wherein the data warehouse includes a step of updating the company name dictionary with newly collected information about the company based on the company name,
The company name dictionaries are listed in an index table format so that the names of the companies are not duplicated, and include the companies of the enterprise of the enterprise and the companies of the companies of the enterprise,
Wherein the step of analyzing the reference relationship between the companies for the indexed firm comprises:
Based on the company name dictionary, the reference relationship is analyzed among companies, and the account of one or more accounts, counterparts, and counterparts of the relevant company is analyzed,
The plurality of tables generated for each of the plurality of data marts by topic may be classified into a table of status information of a main customer and a main buyer according to each company, a transaction weight table of a major customer and a buyer, And a corporate analysis table which is rapidly reduced.

The method according to claim 1,
Wherein the step of analyzing the reference relationship between the companies comprises the steps of extracting only the transactions identified as inter-company transactions, processing the withdrawal related information as purchases, and processing the deposit related information as sales to analyze the customer and the buyer Delivery method.

delete

As a corporate information providing system of a financial institution,
Data for collecting source data for a plurality of company information from an accounting server and an external server, generating a company name index using the morphological analysis method for the collected source data, and analyzing the reference relationship among the companies to the indexed company Warehouse - the source data is aggregate data including information related to the account and general information not related to the account;
A plurality of data marts for generating a multidimensional model for the data analysis of the data warehouse; And
A plurality of data marts, and a plurality of data marts;
, &Lt; / RTI &
The data warehouse constructs a company name dictionary in a dictionary form based on the company name based on the company name, updates the newly collected information to the company name dictionary, and analyzes the reference relationship among the companies based on the company name dictionary , Analyzes the accounts of one or more accounts of the company, the counterparty and the counterparty,
Wherein the company name dictionary includes a list of companies in the form of an index for not duplicating the name of a company and includes even a company of a business partner and a business partner of the business partner company, A table of information on the main customers and main buyers according to the data mart, an analysis table of the transactions of the major customers and the buyers, an analysis table of enterprises with a concentration on a specific customer, and an analysis table of the companies whose revenues decrease sharply Company information providing system.

5. The method of claim 4,
Wherein the data warehouse extracts only the transactions identified as inter-company transactions, processes withdrawal-related information as purchase, and processes the deposit-related information as sales to analyze the customer and the buyer.

delete