TWM578817U - Processing system for converting data of data system into relational data format - Google Patents

Abstract

The utility model discloses a processing system for converting data of data system into relational data format, which includes a data processing program in a server and a data storage module. The data processing program can capture associated data tables, a first file and a second file in the data system, and the data table includes a first field having key values and a second field having markup language format content. The data processing program also can compare the markup language format content of the data tables with content of the first file and the second file, converts tags represented by codes in the markup language format content of the data tables into meaningful tags and data, and then generates a relational data table having an relational data format based on key values of the data tables and the data. Furthermore, the data storage module can store the relational data table having the relational data format.

Description

The data used to convert the data system is the processing system of the associated data format

This creation relates to a data conversion or processing technique, and more particularly to a processing system for converting data systems (such as bank core systems) into an associated data format.

The T24 is a fully integrated modular Core Banking solution that supports a wide range of retail banking (Retail Banking), Private Banking, Corporate Banking, and General Banking (Universal Banking). Different business types, such as Banking), Islamic Banking, and Microfinance, provide parameterization of trading products around the clock, and can be quickly adjusted to meet the needs of the business.

In recent years, financial transaction data has accumulated rapidly, and T24 data is stored in the form of XML (Extensible Markup Language), but the way of storing such data is not easy to analyze and count data. In the past, in the face of huge XML data, there is no systematic processing method. Most of them are used when a certain data is needed, and the data sheets associated with the data are taken out individually, even in the OFS language from T24.撷 Take out and then process, analyze or use the extracted data sheet to reduce the efficiency of data analysis or use.

Therefore, how to effectively increase the efficiency of data analysis or use to become the field One of the major research topics for technicians.

The present invention provides a processing system for converting data systems (such as a bank core system) into an associated data format, which can convert data of a data system (such as a banking core system) (such as XML format content) into associated data. A formatted data sheet (meaningful material) to effectively increase the efficiency with which relevant data is analyzed or used by an associated data sheet.

The processing system for converting the data system into the associated data format includes: a data processing program contained in the server, which is a plurality of data tables of a data system and one of the plurality of data tables associated with the data system. a file and a second file, and each data table includes a first field having a key value and a second field having a markup language format, wherein the data processing program is used to compare the data The content of the markup language format of the second field of the table and the contents of the first file and the second file are used to convert the label represented by the code in the markup language format content of the second field of each data table into a meaningful label.俾 parsing meaningful data, and then providing the data processing program with at least one correlation based on the key value of the first field of each data table and the meaningful data parsed from the content of the mark language format of the second field The associated data table of the data format; and a data storage module is a related data table generated by the data processing program and having an associated data format.

In order to make the above features and advantages of the present invention more comprehensible, the embodiments are described below in detail with reference to the accompanying drawings. Additional features and advantages of the present invention will be set forth in part in the description which follows. The features and advantages of the present invention are recognized and attained by means of the elements and combinations particularly pointed out in the appended claims. It should be understood that the foregoing general description and the following detailed description are merely illustrative Sexual and explanatory, and do not want to limit the scope of this creation.

1‧‧‧Processing system

10‧‧‧Server

11‧‧‧Information System

12‧‧‧Information Sheet

13‧‧‧First file

14‧‧‧Second file

20‧‧‧Server

21‧‧‧ETL (Extract-Convert-Load) program

22‧‧‧ Temporary data storage module

23‧‧‧Data processing program

24‧‧‧ Data Storage Module

25‧‧‧Related data sheet

31‧‧‧Data warehousing system

32‧‧‧Bank Reporting System

33‧‧‧ General ledger system

34‧‧‧Regulatory reporting system

35‧‧‧Application

Figure 1 is a schematic diagram showing the architecture of a processing system for converting data systems into an associated data format; Figure 2A is an embodiment of the data sheet of the creation; Figure 2B is the first file of the creation. Embodiments; FIG. 2C is an embodiment of the second file of the creation; and FIG. 3 is an embodiment of the related profile of the creation.

The embodiments of the present invention are described in the following specific embodiments, and those skilled in the art can easily understand other advantages and functions of the present invention by the contents disclosed in the present specification, and can also be implemented by other different embodiments. Or application.

1 is a schematic diagram of the architecture of the processing system 1 for converting the data system 11 (such as the bank core system) into an associated data format, and FIG. 2A is an embodiment of the data sheet 12 of the creation, 2B. The figure is an embodiment of the first file 13 of the creation, the 2C is an embodiment of the second file 14 of the creation, and the third figure is an embodiment of the associated data table 25 of the creation.

As shown in FIG. 1, the processing system 1 for converting the data system 11 (such as the bank core system) into an associated data format mainly includes a data processing module and a data storage module carried in the server 20. 24, wherein the data processing module has a data processing program 23, and the data processing module and the data storage module 24 are connected to each other or transfer data.

The data processing program 23 of FIG. 1 can retrieve a plurality of data tables 12 of a data system 11 (such as a bank core system) (see data table 12 of FIG. 2A) and a first file associated with one of the plurality of data tables 12. (See Figure 2B) and a second file 14 (see Figure 2C), and the data table 12 of Figure 2A includes a first field (e.g., field RECID) having a key value (e.g., 1000, 1001), And a second field with a markup language (such as XML; Extensible Markup Language) format content (such as the field XMLRECORD). The data table 12 can be stored in a data storage module (not shown) of the server 10, and the data storage module can be a hard disk, a memory, or a database composed of a hard disk or a memory.

Meanwhile, the data processing program 23 of FIG. 1 can compare the markup language (eg, XML) format content of the second field of the data table 12 of FIG. 2A (for example, the field XMLRECORD) with the first file of the second file 13 and the first file. The contents of the two files 14 are converted into meaningful meanings in the markup language (such as XML) format content of the second field of the data table 12 of the 2A map by a code (for example, c1, c2, ..., c15). The tag, 俾 parses the meaningful data, and then the data processing program 23 according to the key value of the first field (for example, the field RECID) of each data table 12 (for example, the key value 1000, 1001) and the second field (for example, The meaningful data parsed in the markup language (eg, XML) format content of the field XMLRECORD) produces at least one (eg, plural) relational data table 25 having an associated data format (see Figure 3). Meanwhile, the data storage module 24 of FIG. 1 can store the associated data table 25 having the associated data format generated by the data processing program 23.

The data system 11 (such as the bank core system) of the above FIG. 1 may be the Temenos T24 bank core system, the first file 13 may be a definition file of the plurality of data tables 12, and the data storage module 24 may be a hard disk, a memory, or the like. Or an associated database of hard drives or memory. Further, in the field RECID of Fig. 2C, the plural data table 12 of Fig. 1 (Fig. 2A) is indicated by "data sheet 1" and "data sheet 2".

The data processing program 23 of the above FIG. 1 can normalize the meaningful data parsed from the content of the markup language (eg, XML) format of the second field of the data table 12 shown in FIG. 2 to generate the third image. Correlation data sheet 25. Moreover, the data processing program 23 of FIG. 1 may also be based on the key values (eg, key values 1000, 1001) of the first field (eg, field RECID) of the data table 12 shown in FIG. 2 and from the second field ( For example, the meaningful data parsed in the markup language (eg, XML) format content of the field XMLRECORD) generates the field name of the associated data table 25 of FIG. 3 (eg, field name ID, DATETIME...) and corresponding content. (eg 1000, 1001, 1061140548...).

The processing system 1 for converting the data system 11 (such as the bank core system) into the associated data format in FIG. 1 may include an ETL (Extract-Transform-Load) program 21 and a temporary The data storage module 22 and the ETL (extraction-conversion-loading) program 21 can pre-move the data table 12 of the data system 11 to the temporary data storage module 22 for the data processing program 23 from the temporary data storage module. In Table 22, the plural data table 12 is obtained. The data storage module 24 can be a hard disk, a memory, or a database composed of a hard disk or a memory.

The contents of the multiple data table 12 of the data system 11 shown in Fig. 1 may vary with time, so the ETL (extraction-conversion-loading) program 21 may pre-move the multiple data table 12 of the data system 11 at different times. To the temporary data storage module 22, and the temporary data storage module 22 can also store the multiple data table 12 at the time point when the ETL (extraction-conversion-loading) program 21 is moved from the data system 11 for the data processing program. The data table 12 at the time point when the ETL (extraction-conversion-loading) program 21 is moved is directly retrieved from the temporary data storage module 22, so that the data processing program 23 can be extracted from the data system 11 without The multiple data table 12, which varies from time to time, is used by the data processing program 23 to obtain a plurality of data tables 12 of a specific time or preset time.

The contents of both the first file 13 and the second file 14 in FIG. 1 are fixed contents. The ETL (extraction-conversion-loading) program 21 does not need to move the first file 13 and the second file 14 to the temporary data storage module 22, so that the data processing program 23 can be self-serving. The first file 13 and the second file 14 are directly captured in the device 10, thereby saving the file migration time of the ETL (extraction-conversion-loading) program 21 and the data storage space of the temporary data storage module 22.

The data storage module 24 of FIG. 1 may have an associated database (not shown) for pre-storing the associated data table 25 of the associated data format generated by the data processing program 23 through the associated database. At least one peripheral system retrieves the associated data table 25 from the associated database to extract or analyze meaningful data from the associated data table 25. Moreover, the markup language (e.g., XML) format content of the second field of the data table 12 of Figure 2 (e.g., field XMLRECORD) is difficult to resolve for the peripheral system. The foregoing peripheral system may be, for example, a data warehouse (DW) system 31, a bank reporting system (ROD) 32, a general Ledger (GL) system 33, and a Regulatory Report (RR) system 34. Or at least one application (Application; APP) 35.

The data system 11, the data table 12, the first file 13, the second file 14, the ETL (extraction-conversion-loading) program 21, the temporary data storage module 22, the data processing program 23, and the data storage module 24, Can be located in the same server or in different servers. For example, in the embodiment of FIG. 1, the data system 11, the data table 12, the first file 13 and the second file 14 are located in the server 10, and the ETL (extraction-conversion-loading) program 21, temporary data storage The module 22, the data processing program 23 and the data storage module 24 are located in the server 20, and the server 10 or the server 20 can be a standard server, a data server, a file server, an application server, and a cloud server. , web server or remote server. However, the invention is not limited thereto.

In summary, the data used in this creation to transform the data system (such as the bank core system) into a relational data format processing system can have at least the following features, advantages or technical effects:

1. This creation can transform the data system (such as the bank core system) data (such as the markup language (such as XML) format content that is difficult to parse for the peripheral system) into the associated data table with the associated data format (meaningful Information) to effectively increase the efficiency of the analysis or use of relevant data by means of an associated data sheet.

2. The contents of the multiple data sheets of the data system (such as the bank's core system) in this creation will change with time. The ETL (Extraction-Conversion-Loading) program can move the data sheet of the data system to the temporary data in advance. The storage module is used by the data processing program to quickly or directly retrieve the data sheet of the time point when the ETL (extraction-conversion-loading) program is moved from the temporary data storage module.

3. The author creates a relational data table with an associated data format by pre-storing the data processing program through the associated database for the at least one peripheral system to directly retrieve the associated data table from the associated database, and then self-associate Extracting or analyzing meaningful data in a data sheet, so that the peripheral system of the prior art can only obtain a meaningless code from the data sheet of the data system (such as the bank core system) in the markup language (such as XML) format content ( The problem of the label represented by the code numbers c1 to c15 of Figure 2A.

The above-described embodiments are merely illustrative of the principles, features, and effects of the present invention, and are not intended to limit the scope of the present invention. Anyone skilled in the art can do so without departing from the spirit and scope of the present invention. The embodiment is modified and changed. Any equivalent changes and modifications made using the content disclosed in this work should be covered by the scope of the patent application. Therefore, the scope of protection of this creation should be as listed in the scope of patent application.

Claims (12)

A processing system for converting a data system into an associated data format, comprising: a data processing program carried in a server, which is a plurality of data tables of a data system and associated with one of the plurality of data tables a file and a second file, each of the data tables including a first field having a key value and a second field having a markup language format content, wherein the data processing program is for comparing the data The content of the markup language format of the second field of the table and the content of the first file and the second file are converted into tags marked with codes in the markup language format content of the second field of each data table. a meaningful label, analysing meaningful data, and then providing the data processing program with the key value of the first field of each data table and the meaningful meaning of the content of the markup language format from the second field The data generates at least one associated data table having an associated data format; and a data storage module stores the association generated by the data processing program with the associated data format Table. The processing system of claim 1, wherein the data system is a banking core system. The processing system of claim 2, wherein the bank core system is a Temenos T24 bank core system, and the first file is a definition file of the plural data table. The processing system of claim 1 or 2, wherein the data system, the data table, the first file, the second file, the data processing program, and the data storage module are located in the same server or different servers. . The processing system of claim 1, wherein the data storage module is a hard disk, a memory, or an associated database composed of the hard disk or a memory. The processing system of claim 1, wherein the data processing program normalizes the meaningful data parsed from the markup language format content of the second field of the data table to generate the Associated data sheet. The processing system of claim 6, wherein the markup language format content is XML (Extensible Markup Language) format content. The processing system of claim 6 or 7, wherein the data processing program is based on a key value of the first field of each of the data tables and a content of the markup language format from the second field. The meaningful data is analyzed to generate the column name and corresponding content of the associated data table. The processing system of claim 1 or 2 further includes an ETL (extraction-conversion-loading) program and a temporary data storage module, wherein the ETL (extract-convert-load) program The plurality of data sheets of the data system are moved to the temporary data storage module in advance for the data processing program to retrieve the plurality of data sheets from the temporary data storage module. The processing system of claim 9, wherein the content of the plurality of data sheets of the data system varies with time, and the temporary data storage module stores the ETL (extract-convert-load) program a plurality of data sheets at a point in time when the data processing system is moved from the temporary data storage module to capture the time point at which the ETL (extraction-conversion-loading) program is moved Multiple data sheets. The processing system of claim 1, wherein the data storage module has an associated database for pre-storing the data processing program to generate the associated data format through the associated database. The associated data table, wherein at least one peripheral system retrieves the associated data table from the associated database to extract or analyze the meaningful data from the associated data table Information. The processing system of claim 11, wherein the peripheral system is a data storage system, a bank reporting system, a general ledger system, a regulatory reporting system, or at least one application.