CN102800014A - Financial data processing method for supply chain financing - Google Patents

Financial data processing method for supply chain financing Download PDF

Info

Publication number
CN102800014A
CN102800014A CN2012102460848A CN201210246084A CN102800014A CN 102800014 A CN102800014 A CN 102800014A CN 2012102460848 A CN2012102460848 A CN 2012102460848A CN 201210246084 A CN201210246084 A CN 201210246084A CN 102800014 A CN102800014 A CN 102800014A
Authority
CN
China
Prior art keywords
data
according
financing
financial
different
Prior art date
Application number
CN2012102460848A
Other languages
Chinese (zh)
Inventor
吴林
马东平
胡联奎
Original Assignee
北京华胜天成科技股份有限公司
北京华胜天成软件技术有限公司
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by 北京华胜天成科技股份有限公司, 北京华胜天成软件技术有限公司 filed Critical 北京华胜天成科技股份有限公司
Priority to CN2012102460848A priority Critical patent/CN102800014A/en
Publication of CN102800014A publication Critical patent/CN102800014A/en

Links

Abstract

The invention discloses a financial data processing method for supply chain financing. The method is characterized by comprising the following steps: I, establishing multiple corresponding data channels for different enterprise information systems; II, establishing a corresponding adapter for each data channel, and storing different types of data taken from the corresponding data channels into a buffer according to the types through the adapter; III, establishing an XML table logically in a matrix relationship according to the data type and format required by a financing system; and IV, reading different types of data in the buffer, and converting different types of data obtained by the adapter through different data channels into the data type required by the financing system according to the matrix relationship in the XML table.

Description

一种用于供应链融资的金融数据处理方法 Financial data processing method for supply chain financing

技术领域 FIELD

[0001] 本发明属于计算机数据处理领域,尤其涉及一种用于供应链融资的金融数据处理方法。 [0001] The present invention belongs to the field of computer data processing, in particular, it relates to financial data processing method for financing the supply chain.

背景技术 Background technique

[0002] 中小微企业融资难是普遍问题,其中一个原因是金融/投资机构和企业之间的融资信息不对称,金融/投资机构对中小微企业的的信息没有透明了解,对于订单,原材料,半成品,成品等进销存信息不能有效的读取过来,这其中的原因本质上在于多家中小微企业的不同计算机软件系统,每个系统类型不一样,系统数据接口不一样,数据语义不统一(比如男女在一些系统中用O、1,一些系统用男女),很难将数据接收并且统一化的处理。 [0002] small micro-enterprise financing is a common problem, one reason is that the financing of information between financial / investment institutions and enterprises asymmetry, financial / investment institutions is not transparent understanding of information small and medium micro enterprises, and for orders, raw materials, semi-finished and finished products inventory information can not be read effectively over, that a number of small and medium micro enterprises on different computer software system which is essentially the reason, each system type is not the same, not the same as the system data interface, data semantics is not uniform (some systems, such as men and women with O, 1, some systems with male and female), it is difficult to receive and unified data processing. 现有金融/投资机构的做法是将各个中小微企业将系统中的数据扫描进来或者将数据取出来,打印出来,继而交给金融/投资机构,金融投资机构再手工的将数据录入进去,或者把数据影印扫描件录入进去。 Practice existing financial / investment institutions are the various small and medium micro enterprise data systems scanned in or take out the data, print it out, and then handed over to the financial / investment institutions, financial investment institutions and then manually entering data into it, or photocopy data input into the scanning member.

[0003] 现有技术有以下几个方面的缺点,第一、若手工录入数据,则消耗大量的人力成本,同时为了保证无误差,多道程序使得效率低下,并且消耗大量时间。 [0003] disadvantages of the prior art has the following aspects, first, if the manual data entry, a lot of labor costs is consumed, while in order to ensure error-free, multi-channel program causing inefficient and time consuming. 第二、若只是将数据影印扫描件录入进去,首先可读性较差,与现有金融机构系统的结合性差;其次在进行贷款风险评估的时候,影印数据是无法读取到风险评估模型中去的;第三、不管是手工录入还是影印扫描,实时性都很差,无法将最新的数据提供给银行进行贷款。 Second, if only photocopies scanned copy of the data entered into it, first of all poor readability, and the existing system of financial institutions, combined with poor; secondly performing loan risk assessment when photocopied data can not be read into the risk assessment model go; third, whether entered manually or photocopying scanning, real-time are very poor, the latest data will not provide a loan to the bank.

发明内容 SUMMARY

[0004] 针对现有技术的缺陷,本发明的目的在于提供一种用于供应链融资的金融数据处理方法,其能够将不同企业的信息管理系统中的数据实时从企业系统中抽取出来,并转换成能够直接供融资系统进行风险评估、贷款以及贷后监管使用的统一数据格式。 [0004] for the disadvantages of the prior art, an object of the present invention to provide a method for processing financial data for financing the supply chain, which can be different enterprise data management system real-time information extracted from the system out of business, and can be directly converted into a risk assessment system for financing, mortgage loans, and unified data format used after regulation.

[0005] 本发明所述用于供应链融资的金融数据处理方法,其特征在于包括如下步骤: [0005] The method for processing financial data supply chain financing of the present invention, characterized by comprising the steps of:

[0006] 步骤一、针对不同的企业信息系统建立多种相应的数据通道; [0006] Step a, to establish a respective plurality of data channels for different enterprise information system;

[0007] 步骤二、针对每种数据通道建立相应的适配器,通过适配器将经由相应数据通道取来的不同类型的数据按照类型存储到缓存器中; [0007] Step two, to establish the appropriate data for each channel adapter, to fetch the corresponding data via the data channels of different types according to the type stored in the buffer through the adapter;

[0008] 步骤三、根据融资系统所需要的数据类型以及格式建立一张逻辑上是矩阵关系的XML 表; [0008] Step three, the establishment of the data type and format of financial systems is required on a logical relationship between a matrix table XML;

[0009] 步骤四、读取缓存器中不同类型的数据,依据所述XML表中的矩阵关系将适配器通过不同数据通道获取的不同类型的数据转换成融资系统所需的数据类型。 [0009] Step 4 buffer read different types of data, according to the matrix relation table XML data types required by the adapter converts the different data channels of different types of acquired data to the financial system.

[0010] 进一步,本发明所述的用于供应链融资的金融数据处理方法,其特征在于所述数据通道采用JBDC、OBDC, HTTP、HTTPS、或者FTP连接方式。 [0010] Further, financial data processing method for financing the supply chain of the present invention, wherein said data channel uses JBDC, OBDC, HTTP, HTTPS, or FTP connection.

[0011] 进一步,本发明所述的用于供应链融资的金融数据处理方法,其特征在于所述适配器设有缓存数组,其根据读取到的数据类型按照if switch语句匹配数据类型存储到相应的缓存空间中。 [0011] Further, financial data processing method for financing the supply chain of the present invention, wherein said adapter is provided with an array of buffer, based on the read data according to the type of data type matches if switch statement stored in the respective cache space. [0012] 进一步,本发明所述的用于供应链融资的金融数据处理方法,其特征在于数据在缓存器中采用行列式存储,并利用分布式检索进行数据查找。 [0012] Further, financial data processing method for financing the supply chain of the present invention is characterized in that the data stored in the buffer employed in the determinant, and retrieve data using a distributed lookup.

[0013] 进一步,本发明所述的用于供应链融资的金融数据处理方法,其特征在于针对不同的企业信息系统建立的数据通道采用安全身份认证技术,并在数据传输过程中进行数据加密。 [0013] Further, financial data processing method for financing the supply chain of the present invention is characterized in that for the establishment of different enterprise information system using the data channel security authentication technology, data encryption and data transmission process.

[0014] 本发明所述的用于供应链融资的金融数据处理方法通过将来自不同企业信息系统的不同格式的数据转换成能够供融资平台读取的统一格式的数据,从而在融资平台和企业信息系统之间建立金融数据的直接通道,省去了手工录入数据的麻烦易错效率低下的问题,并且能够实时将最新的数据提供给融资平台进行融资操作。 [0014] Financial data processing method for financing the supply chain according to the present invention by the data in different formats from different enterprise information system can be converted into a unified format for data read financing platform to finance companies and internet establish a direct channel between the information systems of financial data, eliminating the hassle of manual data entry error prone low efficiency, and the latest data in real time to provide financing to finance operations platform.

附图说明 BRIEF DESCRIPTION

[0015] 图I是用于执行本发明所述用于供应链融资的金融数据处理方法的整体框架图; [0015] Figure I is an overall view of a financial data frame processing method for performing the present invention for supply chain financing;

[0016] 图2是本发明所述的用于供应链融资的金融数据处理方法的流程图。 [0016] FIG 2 is a flowchart of a data processing method for supplying a financial chain financing of the present invention.

具体实施方式 Detailed ways

[0017] 为使本发明的上述目的、特征和优点更加明显易懂,下面结合附图和具体实施例对本发明作进一步详细的说明。 [0017] For the above-described objects, features and advantages of the present invention will become apparent from the following drawings and specific embodiments described in further detail in conjunction with the present invention.

[0018] 图I是用于执行本发明所述用于供应链融资的金融数据处理方法的整体框架图;如图所示,多家中小微企业具有不同的ERP、CRM等企业信息系统,ERP系统和CRM系统处理的系统数据和信息包括企业里面所有的物流(企业固定资产,流动资产,产品各种物的信息),资金流(包括应收,应付等钱),信息流(指在企业内部的各种过程信息数据),这些系统数据的类型格式是由不同的企业根据数据属性类型自己定义的,比如物流的属性中的名称,存储位置,仓储信息等都采用string字符串类型来描述,资金流里面大多数是数字,可以采用int整数型或者float浮点数型来进行描述;还有就是I和0这种,不是正就是负的数据,通常采用布尔型进行描述存储。 [0018] FIG. I is used for performing the present invention, the entire supply chain of financial data frame of FIG financing processing method; As shown, a number of small and medium companies having different micro ERP, CRM enterprise information system, ERP system data and information system and CRM systems including handling all of the logistics business inside (fixed assets, current assets, information products of various objects), cash flow (including accounts payable and other money), information flow (refer to enterprises various processes internal information data), the type of the data format of these systems are different types of enterprises according to their definition of data attributes, such as name attribute in the stream storage location, storage information, adopted string string type described , which are digital cash flow, can float int integer or floating point type employed to describe; 0 and I that there is not positive is negative data, usually stored Boolean be described. 在数据存储中,格式是一方面,更重要的一方面是数据中的语义,也就是数据的潜台词,比如I和0,通过对其进行语义配置,可以分别代表性别中的男和女,这就是数据的语义。 In data storage, the format is one thing, more important aspect is the data semantics, that is the subtext of data, such as I and 0, by its semantic configuration, can represent the gender of male and female respectively, which It is semantic data. 由于不同企业的数据属性类型是自己定义的,所以每个系统类型不一样,系统数据接口不一样,数据语义不统一(比如男女在一些系统中用0、1,一些系统用男女)。 Due to the different types of enterprise data attributes of their own definition, it is not the same for each system type, system data interface is not the same, no unified semantic data (such as men and women with some systems 0,1, some systems with male and female). 为此,需要针对多家中小微企业不同的ERP、CRM等企业信息系统,建立与与之对应的多种不同技术类型的数据通道(channel),比如不同的系统有不同的技术架构,不同语言开发的,有java的,有微软那套c,c#等的,所以连接系统的数据库需要选择不同的连接技术进行对接。 To this end, it is necessary for a number of small and medium micro enterprises different ERP, CRM and other enterprise information system, and the corresponding number of different types of technical data channel (channel), such as different systems have different technical architectures, different languages development, we have java, it is Microsoft's set of c, c #, etc., so the database connection systems need to choose a different connection technology for docking. 例如可以采用JDBC或ODBC数据库连接技术,其中JDBC(Java DataBase Connectivity, java数据库连接)是一种用于执行SQL语句的Java API,可以为多种关系数据库提供统一访问,它由一组用Java语言编写的类和接口组成。 For example, can use JDBC or ODBC database connectivity technologies, JDBC (Java DataBase Connectivity, java Database Connectivity) is a Java API to execute SQL statements used, can provide unified access to a variety of relational database, which consists of a set of Java language writing classes and interfaces. JDBC为工具/数据库开发人员提供了一个标准的API,据此可以构建更高级的工具和接口,使数据库开发人员能够用纯Java API编写数据库应用程序。 JDBC provides a tool / database developers with a standard API, thus can build more sophisticated tools and interfaces to make the database developers to write database applications using a pure Java API. 开放数据库互连(ODBC)是MICROSOFT提出的数据库访问接口标准。 Open Database Connectivity (ODBC) is a standard database access interface MICROSOFT raised. 开放数据库互连定义了访问数据库的API —个规范,这些API独立于不同厂商的DBMS,也独立于具体的编程语言(但是MICROSOFT的ODBC文档是用C语言描述的,许多实际的ODBC驱动程序也是用C语言写就的。)ODBC规范后来被X/0PEN和IS0/IEC采纳,作为SQL标准的一部分,具体内容可以参看《ISO/IEC 9075-3 : 1995 (E) Call-LevelInterface (SQL/CU)》等相关的标准文件。 Open Database Connectivity defines the API to access the database - a specification, the API is independent of the different manufacturers of DBMS, but also independent of a specific programming language (MICROSOFT but the ODBC documentation is written in C language, and many practical ODBC driver also it's written in C language) ODBC specification was later X / 0PEN and IS0 / IEC adopted as part of the SQL standard, the specific content can be found in "ISO / IEC 9075-3:. 1995 (E) Call-LevelInterface (SQL / CU ) "and other related standards documents.

[0019] 对于不同的数据通道,除了这里提到的数据库系统的连接方式,还可以有http以及https等方式来建立通道,这两种方式是通过网络协议来取得数据,主要是看企业系统软件的具体情况。 [0019] For different data channels, in addition to connection database systems mentioned here, there are also other ways to http and https established channel, which is two ways to get data through the network protocol, mainly to see the enterprise system software situation. 为了适应不同的企业信息系统,融资平台所建立的数据通道需要支持全部的方式,比如有些公司存储时按照excel表文件的方式存储,此时,数据通道可以采用ftp文件系统的连接方式。 In order to adapt to different enterprise information systems, financing platform established data channel we need to support all the way, such as when some companies excel table file storage memory in accordance with the way this time, the data channel can be connected to the way the file system using ftp.

[0020] 下面以JDBC连接技术为例,来说明数据通道的具体建立过程。 [0020] In the following JDBC connection technology, for example, to illustrate the specific process of establishing the data channel. 首先是针对企业不同类型的系统,包括订单系统、采购系统、生产系统、库存系统、应收以及应付等,需要在平台处有特定的适配单元,来明确从系统中取得哪些数据信息,继而形成action,利用JDBC链接连接到数据库并且将数据传输过来,由于JDBC技术具有JDBC API,所以就不必为访问Sybase数据库专门写一个程序,为访问Oracle数据库又专门写一个程序,或为访问Informix数据库又编写另一个程序等等,程序员只需用JDBC API写一个程序就够了,它可向相应数据库发送SQL调用,这是一个基于JAVA平台的系统,具体如何建立有以下4个步骤,第一、装载驱动,针对不同的数据库系统,就如上面所说的不同数据库系统,比如oracle的加载oracle, jdbc. driver. oracleDriver。 The first is for different types of enterprise systems, including order systems, procurement systems, production systems, inventory systems, such as accounts receivable and payable, the need for a specific adapter unit at the platform, which explicitly obtain data from the system, then form action, use JDBC link to connect to the database and data transmission over, because the JDBC technology JDBC API, so you do not have to access the Sybase database dedicated to write a program for accessing Oracle databases and specialized write a program, or to access the Informix database yet write another program, etc., programmers simply write a program using JDBC API enough, it can send calls to the appropriate SQL database, which is a system based on the JAVA platform, specifically how to establish the following four steps, first loading drive, for different database systems, as mentioned above, different database systems, such as loading the oracle oracle, jdbc. driver. oracleDriver. 第二步、设定url (统一资源定位符),和用户名和密码。 The second step, set the url (uniform resource locator), and the user name and password. 第三步,建立连接,利用第二步的url进行定位,然后利用用户名和密码进行登录。 The third step is to establish a connection using the second step url locate, and then use the user name and password. 第四步、利用sql语言取得数据。 The fourth step, take advantage of sql language acquired data. 在适配单元处需要有专门的实例类来承载这些数据,包括driver类,用来确定驱动! The adaptation unit has a dedicated instance of the class required to carry the data, including the class driver for determining drive! attribute类,用来对数据做属性分析;Type类,用来确定数据类型;store类,用来进行数据存储;等等。 attribute class used to make the data attribute analysis; the Type class to determine the data type; Store class, for storing data; and the like. 然后将实例类传递到映射层进行mapping过程,同样的,在mapping的时候将有订单映射表、采购映射表、生产映射表、库存映射表、应付映射表及应收映射表。 Then the instance of the class passed to the mapping layer mapping process, the same, while mapping the mapping table will have orders, procurement map, map production, inventory mapping table, the mapping table and accounts payable map. 当mapping后的数据会专门放入到一个数据工厂中,这是一个数据仓库,包含之前所提到的3类数据信息流数据,资金流数据以及物流数据。 When mapping data will be placed in a dedicated plant data, which is a data warehouse, data class 3 containing the previously mentioned stream data, stream data, and data flow of funds. 融资系统内的融资模型就把数据工厂当做自己的数据源,直接取得所需数据来进行计算,包括风险评估、担保贷款以及贷后监督,并将得出的结果分别提供给贷款平台中的贷前评估、贷款流程以及贷后监督,这些以服务提供的方式给金融/担保机构。 Financing model within the financing system put the data factory as their data source directly obtain the necessary data to be calculated, including risk assessment, as well as after-loan supervision and guaranteed loans, and the results are provided to the mortgage loans platform before the assessment, loan processing and post-loan supervision, these services provide a way to give financial / security agencies.

[0021] 通过数据通道建立,同时在融资系统内的平台中针对每个通道设置一个适配器adapter,针对每种数据通道建立相应的适配器,通过适配器可以将经由相应数据通道取来的不同类型的数据按照类型存储到缓存器中;这里的适配概念就是将取来的不同数据,按照类型进行存储,针对不同的channel方式有不同的适配器,比如上面的JDBC吧,取过来的数据有string,有int,还有float,还有这些数据自带的语义,在系统这边就需要按照不同的类型数据进行缓存,适配器有个缓存数组,然后根据读取到的数据类型按照if switch语句匹配数据类型存储到相应的缓存空间中(这里可以是一个物理存储设备,也可以使逻辑设备)。 [0021] By establishing a data channel adapter while the adapter is provided a platform within the financing system for each channel, to establish the appropriate data for each channel adapter, the adapter can be taken via the respective data channels of different types of data according to the type stored in the buffer; adaptation concept here is to fetch different data, stored by type, different channel adapters for different ways, such as JDBC above it, has taken over the data string, there int, as well as float, as well as the semantics of the data comes, it is necessary for the system side according to different types of data cache, the adapter has a buffer array, and then match the data type if switch statement according to the type of data according to the read the corresponding cache memory space (this may be a physical storage device, may cause the logic device).

[0022] 适配器将融资系统需要的数据通过channel取过来,然后执行映射mapping过程;映射这里分三步进行处理,第一步:初始化过程,即就是xml表建立的过程,因为融资系统内模型是建立好的,所以所需要的数据类型以及格式都是确定的,就需要建立一张大型逻辑上是矩阵关系的表,实际存储的方式是xml表,在这张表内将可能出现的结果对应都存在,比如现有的所有系统中对于男女的描述基本上都是男女或者1、0或者MF或者X0。 Data [0022] Adapter will require financing system by taking over the channel, and then perform a mapping process mapping; mapping process here in three steps, the first step: initialization process, i.e. process xml table is established, as is the financing system model well established, so that the desired data type and format are determined, the need to build a large matrix logic table relationship is actually stored. xml table, the results in this table will likely correspond to are present, all systems such as a conventional description of men and women or men are substantially or 1,0 or MF X0. 这张表是提前按照统计经验提前建立好的,而且还可以继续根据需求再进行变更或添加。 This table is in advance in accordance with well-established statistical experience in advance, but also continue to further changes or additions as required. 第二步:根据模型的需求,比如要需求性别这个属性,到缓存中找到数据然后依据这张表中各种数据类型之间的矩阵关系进行转换,当融资模型规定对于男女的标准格式是I和O时,那男女MF、XO之类的数据类型可以根据XML表中各种数据类型之间的矩阵关系转化成为I和O即可。 Step two: according to the needs of the model, such as to demand sex this property to find the cache data is then converted according to the matrix relationship between the various data types in this table, when financing model specifies a standard format for the men and women that I and O when, the MF that men and women, such data types can XO conversion matrix in accordance with the relationship between the various data types in the XML tables I and O to be. 数据在缓存器中采用行列式存储,完全大表式的存储,不是传统的对象存储,并利用分布式检索快速进行查找。 Using data stored in the buffer determinant, large tabular completely stored, not the traditional object storage and retrieval using a distributed fast lookup.

[0023] 通过配置XML表,参照这张表可以将不同通道上来的不同格式数据转化成同一种格式,来供融资系统进行金融模型建立。 [0023] The different data channels onto different formats can be converted into the same format to establish a system for financing financial model XML configuration table by referring to this table. 其中,金融模型是可以选择的,提前将各个金融/投资机构的模型算法输入进来并且设定序号,存入一个二维数组中,这样就可以在各个模型之间进行转换。 Among them, the financial model can be selected in advance of each model algorithm financial / investment institutions come in and set the number of input, into a two-dimensional array, so that you can switch between the various models. 金融模型是需要利用担保集约池的担保数据来建模,所以在金融模型中,专门一个接口形成session会话,专门和担保池进行数据交互。 Financial data model is the need to use the guarantee pool to guarantee intensive modeling, so the financial model, the interface form a special session session, dedicated and secured pool data exchange. 在贷款后进行贷款监控的时候,同样也将利用金融模型中的贷后监督模型,每次贷款监控的时候,利用模型中的API,监控系统调用模型,同时将从mapping后的数据转入模型中进行计算,形成结果。 Time monitoring of loan after loan after loan-use will also supervise the financial model in the model, each credit monitoring when using the model of the API, a model system to monitor calls, and transferred from the data model mapping in calculation, the result is formed. 最后金融/投资机构和平台系统的交互都是通过Web service的方式去实现,基于soap协议进行传输,首先是和担保集约池系统进行担保的交互,进行标的的评估。 Finally, interactive financial / investment institutions and platform systems are to be achieved by way of Web service, transmission protocol based soap, and first and foremost guarantee intensive pond systems interact guarantees, to evaluate the subject matter. 其次是和模型系统的交互,将各家金融/投资机构的模型初始化和更新。 Second and interactive model of the system will initialize the model various financial / investment institutions and updates. 最后是和监控系统进行交互,金融/投资机构利用监控系统查看贷后企业对于资金的使用,利用监督模型得出企业还款风险等。 Finally, and monitoring systems interact, financial / investment institutions to use monitoring system for corporate credit review the use of funds by the supervision model derived repayment risk enterprises.

[0024] 数据交互过程中,因为传输的数据都是企业的核心经营数据,所以本发明针对不同的企业信息系统建立的数据通道采用安全身份认证技术,并在数据传输过程中进行数据加密。 [0024] data exchange process, because the data transmission is the core business data, the present invention established for different data channels using enterprise information systems security authentication technologies, and data encryption in data transmission. 数据经过hash加密处理过才进行传输的,并且附有校验位来确定是否数据被修改过。 Data was processed through the hash encrypted for transmission, and with the parity bit to determine whether the data has been modified.

[0025] 图2是本发明所述的用于供应链融资的金融数据处理方法的流程图;如图所示,本发明所述用于供应链融资的金融数据处理方法包括如下四个步骤,为了更清楚地说明本发明的执行过程,结合某一企业的利用供应链金融实施的例子来进行描述: [0025] FIG 2 is a flowchart of a method for processing financial data supply chain financing according to the present invention; As shown, the present invention is a method for processing financial data supply chain financing comprises the four steps, in order to more clearly illustrate the implementation process of the present invention, with examples of the use of SCF embodiment of an enterprise be described:

[0026] 步骤一、针对不同的企业信息系统建立多种相应的数据通道; [0026] Step a, to establish a respective plurality of data channels for different enterprise information system;

[0027] 系统需要XX企业的ERP和CRM中订单系统、采购系统、生产系统的数据来进行建模,里面的数据有之前提到的订单号是int型,订单内容是string型,订单金额是int型等等其他很多数据。 [0027] ERP and CRM systems need in order systems, procurement systems, data production system XX enterprises to model, order number inside the data have previously mentioned int type, content is a string-type orders, order amount is int data type, and so many others. ERP系统是java程序编写的,是采用对象存储,存储在mysql数据库中。 ERP system is prepared by the java program is stored using object, stored in the database mysql. 系统对外有两种方式提出数据,一种是直接连接数据库,一种是利用系统提供的API,以table表的形式取得。 System External data presented there are two ways, one is directly connected to the database An API is provided by the system acquires the form of a table of the table. 经上分析,针对XX企业建立两类数据通道,一种是mysql的JDBC,先启动driver,然后配置后,就能直接建立好;一种是通过HTTP连接来写脚本调用API建立。 Through the analysis, two types of enterprise data channel for XX, one is the mysql JDBC, first start the driver, and then after the configuration, you can directly establish good; one is through the HTTP connection to write the script calls the API is built.

[0028] 步骤二、针对每种数据通道建立相应的适配器,通过适配器将经由相应数据通道取来的不同类型的数据按照类型存储到缓存器中; [0028] Step two, to establish the appropriate data for each channel adapter, to fetch the corresponding data via the data channels of different types according to the type stored in the buffer through the adapter;

[0029] XX企业建立两类数据通道,所以在系统端有两个适配器,一个是针对JDBC的适配器,一个是针对HTTP的适配器。 [0029] XX enterprises to establish two types of data channels, so there are two adapters in the system side, one for JDBC adapters, one for the HTTP adapter. 适配器连接缓存器,缓存器里面有int,sting和float等不同类型的数组,适配器利用判断语句将不同类型数据存储在不同数组中,在这里要注意语义的存储,数据的存储时是二维数组,在0行中存储数据的属性名,I行存储数据的属性特征,2行存储数据的属性描述。 Adapter buffer, the buffer which has a different type of int, sting, and the like float array, the adapter is determined by using different types of statement data stored in different arrays in memory semantics to note here, store data is a two-dimensional array , property name data stored in row 0, row I wherein attribute data is stored, the attribute data stored in the line 2 is described. 适配器和缓存器之间的是通过系统内存作为缓冲连接起来的。 It is connected via system memory as a buffer between the adapter and buffers. [0030] 步骤三、根据融资系统所需要的数据类型以及格式建立一张逻辑上是矩阵关系的XML 表; [0030] Step three, the establishment of the data type and format of financial systems is required on a logical relationship between a matrix table XML;

[0031] 就拿融资系统需要XX企业的订单系统的订单相关信息来说,拿最简单的布尔类型,订单完成情况就只有2个,完成与不完成,在融资系统中需要的是true和false这种数据类型并且数据格式是布尔类型。 [0031] Take the order-related information systems required XX financing system for corporate orders, to take the most simple Boolean type, order the completion of only two complete and not complete, within the financing system is needed is true and false this data type and the data format of Boolean type. 在XX企业的订单系统中,是string类型,用0和I,以及部分F和N是来代表,在进行矩阵变换,这个只有两种类型,就是二维矩阵变换,存储到xml表上上面采用行列式存储就是,有2行I列,列表示需要变换成的属性ture和false,两行代表0和I以及F和N。 In order XX enterprise system, of type string, with 0 and I, and portion F and N are represented, performing matrix conversion, the only two types, that is, a two-dimensional matrix transform, stored using the above table xml determinant is stored, there are two rows I columns, column indicates the need ture and properties into a false, two rows represent 0 and I and F and N.

[0032] 步骤四、读取缓存器中不同类型的数据,依据所述XML表中的矩阵关系将适配器通过不同数据通道获取的不同类型的数据转换成融资系统所需的数据类型。 [0032] Step 4 buffer read different types of data, according to the matrix relation table XML data types required by the adapter converts the different data channels of different types of acquired data to the financial system.

[0033] 从缓存器中的各种类型数组中进行检索,这里采用hadoop加Iucene的分布式检索,多个线程并行进行处理,来进行匹配相应的数据,然后到xml表中进行变换。 [0033] from the buffer array to retrieve various types, where retrieving hadoop added Iucene distributed, a plurality of process threads in parallel, to match the corresponding data, and then converted into xml table. 如上面的订单完成情况,在string里面去寻找,因为是二维数组,先要找到属性名,检索属性描述关键词,确定后将数组中的数据读取出来,继而到xml表中去匹配和转换,然后交给系统的金融模型。 As the completion of the above orders, the string inside to find, because it is a two-dimensional array, first find the property name, property description keyword retrieval, the array will determine the data is read out, and then go into the xml table and matching conversion, and then to the financial model of the system.

[0034] 本发明所述的用于供应链融资的金融数据处理方法通过将来自不同企业信息系统的不同格式的数据转换成能够供融资平台读取的统一格式的数据,从而在融资平台和企业信息系统之间建立金融数据的直接通道,省去了手工录入数据的麻烦易错效率低下的问题,并且能够实时将最新的数据提供给融资平台进行融资操作。 [0034] The financial data processing method for financing the supply chain according to the present invention by the data in different formats from different enterprise information system can be converted into a unified format for data read financing platform to finance companies and internet establish a direct channel between the information systems of financial data, eliminating the hassle of manual data entry error prone low efficiency, and the latest data in real time to provide financing to finance operations platform.

[0035] 以上是对本发明的优选实施例进行的详细描述,但本领域的普通技术人员应该意识到,在本发明的范围内和精神指导下,各种改进、添加和替换都是可能的,例如调整接口调用顺序、改变消息格式和内容、使用不同的编程语言(如C、C++、Java等)实现等。 [0035] The above is the detailed description of the preferred embodiments carried out the invention, but those of ordinary skill in the art will be appreciated that, within the scope and spirit of the present invention under the guidance of various modifications, additions and substitutions are possible, calling sequence, for example, to adjust the interface change message format and content, using different programming languages ​​(such as C, C ++, Java, etc.) and the like to achieve. 这些都在本发明的权利要求所限定的保护范围内。 These are within the scope of the claims of the present invention is defined.

Claims (5)

1. 一种用于供应链融资的金融数据处理方法,其特征在于包括如下步骤: 步骤一、针对不同的企业信息系统建立多种相应的数据通道, 步骤二、针对每种数据通道建立相应的适配器,通过适配器将经由相应数据通道取来的不同类型的数据按照类型存储到缓存器中; 步骤三、根据融资系统所需要的数据类型以及格式建立一张逻辑上是矩阵关系的XML表; 步骤四、读取缓存器中不同类型的数据,依据所述XML表中的矩阵关系将适配器通过不同数据通道获取的不同类型的数据转换成融资系统所需的数据类型。 1. financial data processing method for financing the supply chain, comprising the following steps: Step a, to establish a respective plurality of data channels for different enterprise information systems, two step, to establish the appropriate data for each channel adapter, an adapter will fetch the corresponding data via the data channels of different types according to the type stored in the buffer; step three, the establishment of a logical relationship between the XML is a matrix table according to the type and format of financial data required by the system; step Fourth, the buffer read different types of data, according to the matrix relation table XML data types required by the adapter converts the different data channels of different types of acquired data to the financial system.
2.根据权利要求I所述的用于供应链融资的金融数据处理方法,其特征在于所述数据通道采用JBDC、OBDC, HTTP、HTTPS、或者FTP连接方式。 The financial data processing method for financing the supply chain according to claim I, wherein said data channel uses JBDC, OBDC, HTTP, HTTPS, or FTP connection.
3.根据权利要求I所述的用于供应链融资的金融数据处理方法,其特征在于所述适配器设有缓存数组,其根据读取到的数据类型按照if switch语句匹配数据类型存储到相应的缓存空间中。 3. The financial data processing method according to claim I for financing the supply chain, wherein said adapter is provided with buffer array that matches the data according to the read statement if switch according to the type of data stored in the respective type cache space.
4.根据权利要求I或3所述的用于供应链融资的金融数据处理方法,其特征在于数据在缓存器中采用行列式存储,并利用分布式检索进行数据查找。 4. I financial data processing method for supplying or financing chain according to claim 3, characterized in that the data stored in the buffer employed in the determinant, and retrieve data using a distributed lookup.
5.根据权利要求I所述的用于供应链融资的金融数据处理方法,其特征在于针对不同的企业信息系统建立的数据通道采用安全身份认证技术,并在数据传输过程中进行数据加LU O I according to claim financial data processing method according to the supply chain for financing, characterized in that the established for different data channels using the enterprise information system security authentication technology, and data encryption LU O data transfer process
CN2012102460848A 2012-07-13 2012-07-13 Financial data processing method for supply chain financing CN102800014A (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN2012102460848A CN102800014A (en) 2012-07-13 2012-07-13 Financial data processing method for supply chain financing

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN2012102460848A CN102800014A (en) 2012-07-13 2012-07-13 Financial data processing method for supply chain financing

Publications (1)

Publication Number Publication Date
CN102800014A true CN102800014A (en) 2012-11-28

Family

ID=47199113

Family Applications (1)

Application Number Title Priority Date Filing Date
CN2012102460848A CN102800014A (en) 2012-07-13 2012-07-13 Financial data processing method for supply chain financing

Country Status (1)

Country Link
CN (1) CN102800014A (en)

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103929477A (en) * 2014-03-31 2014-07-16 国网山东省电力公司 Intersystem non-coupling integration simulation method and system based on Http
CN107018042A (en) * 2017-04-13 2017-08-04 广东神马搜索科技有限公司 Tracking method and tracking system for online service system

Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050050068A1 (en) * 2003-08-29 2005-03-03 Alexander Vaschillo Mapping architecture for arbitrary data models
CN102324074A (en) * 2011-10-28 2012-01-18 山东城通科技有限公司 Informatization application cluster platform of small and medium enterprises
CN102571720A (en) * 2010-12-27 2012-07-11 中国移动通信集团辽宁有限公司 Method and device for processing heterogeneous information contents

Patent Citations (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20050050068A1 (en) * 2003-08-29 2005-03-03 Alexander Vaschillo Mapping architecture for arbitrary data models
CN102571720A (en) * 2010-12-27 2012-07-11 中国移动通信集团辽宁有限公司 Method and device for processing heterogeneous information contents
CN102324074A (en) * 2011-10-28 2012-01-18 山东城通科技有限公司 Informatization application cluster platform of small and medium enterprises

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
郭杨: "异构数据交换中关键技术研究", 《电脑知识与技术》 *

Cited By (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN103929477A (en) * 2014-03-31 2014-07-16 国网山东省电力公司 Intersystem non-coupling integration simulation method and system based on Http
CN107018042A (en) * 2017-04-13 2017-08-04 广东神马搜索科技有限公司 Tracking method and tracking system for online service system

Similar Documents

Publication Publication Date Title
Wang et al. Data quality
Sadalage et al. NoSQL distilled: a brief guide to the emerging world of polyglot persistence
US7814470B2 (en) Multiple service bindings for a real time data integration service
US7814142B2 (en) User interface service for a services oriented architecture in a data integration platform
US8060553B2 (en) Service oriented architecture for a transformation function in a data integration platform
Plattner A common database approach for OLTP and OLAP using an in-memory column database
CN101308490B (en) Dynamic report generation method and platform
US20050278270A1 (en) Data services handler
US20050228808A1 (en) Real time data integration services for health care information data integration
US20050262191A1 (en) Service oriented architecture for a loading function in a data integration platform
US20050223109A1 (en) Data integration through a services oriented architecture
US20050262189A1 (en) Server-side application programming interface for a real time data integration service
US20060010058A1 (en) Multidimensional database currency conversion systems and methods
CN102207940B (en) Method and system for checking data
US20060010195A1 (en) Service oriented architecture for a message broker in a data integration platform
US20050232046A1 (en) Location-based real time data integration services
US20050262193A1 (en) Logging service for a services oriented architecture in a data integration platform
US20140172776A1 (en) Column smart mechanism for column based database
JP5833406B2 (en) Data management architecture associated with the generic data item using the reference
US8650150B2 (en) System and method of relating data and generating reports
Plattner A course in in-memory data management
US20100017395A1 (en) Apparatus and methods for transforming relational queries into multi-dimensional queries
US20070203933A1 (en) Method for generating data warehouses and OLAP cubes
US20150379429A1 (en) Interactive interfaces for machine learning model evaluations
CN101828182B (en) ETL-less zero redundancy system and method for reporting OLTP data

Legal Events

Date Code Title Description
C06 Publication
C10 Entry into substantive examination
RJ01