CN102629264A - Method for realizing data sharing and generating financial certificates in heterogeneous database system - Google Patents

Abstract

The invention provides a method for realizing data sharing and generating financial certificates in a heterogeneous database system. The method comprises the followings: unifying base data codes and building an original base data code comparison table; building database link service; sorting out data and building a data template; and carrying out data exchange so as to form credential data of a financial system. The method provided by the invention can be widely applied to building trades and large-scale and integrated group enterprises, and solves the condition of isolated information resources in group enterprises. Data in a business system can generate credential data of the financial system through arrangement and modeling. A heterogeneous database system can be connected, date share can be achieved, the information utilization can be improved, all systems are enabled to cooperate with each other effectively, and an upstream business system can send data to a downstream management system directly. Therefore, the production rate and the work efficiency of the enterprises can be improved by reasonably using information, and the availability of all application systems is enhanced.

Description

A kind of method that in heterogeneous database system, realizes data sharing and generate financial voucher

Technical field

Invention relates to a kind of Computer Applied Technology, provides a kind of method that in heterogeneous database system, realizes data sharing and generate financial voucher specifically.Or a kind of in heterogeneous database system, through the database link service, realize the data sharing of a plurality of operation systems and form the program of financial voucher data processing, the method that solves conglomerate's information island situation is provided.

Background technology

Conglomerate has set up some specialized systems at present; Like financial system, goods and materials system, manpower system etc.; Because building time is different, the developer is different, and the difference on the database technology that infosystem adopted; Caused between the application system separate, the situation that information resources barrier between different departments, information are difficult to share.Information is kept in each individual event infosystem, can not be effectively mobile, form information island, and hindered the further utilization of data message.

Information management lacks effective information processing and knowledge transfer means, and information utilization is low; The operation system at the upper reaches can't effectively be delivered to data in the management system in downstream, and information resources are disperseed, and information is obtained difficulty; Lack effectively work synergistic mechanism, can't in time link up cooperation, influence work efficiency.

If can the Database Systems of isomery be coupled together; Realize data sharing; Improve information utilization, and make each system effectively collaborative, the operation system at the upper reaches is directly given data transfer the management system in downstream; So just can reasonable use information improve the throughput rate and the work efficiency of enterprise, and improve the availability of each application system.

Summary of the invention

The purpose of this invention is to provide a kind of method that in heterogeneous database system, realizes data sharing and generate financial voucher.

The objective of the invention is to realize that by following mode this comprises following step:

1) encodes through the basic data of unified a plurality of management systems; Set up the coding of original base data and the table of comparisons of normal data coding; The data of each information management system can both be understood, for a plurality of information management system data sharings provide precondition by other infosystems;

2) under the inconsistent situation of type of database that a plurality of management systems are used, the data sharing exchange of system is to carry out through the chaining service of database, and in certain large database, the step of setting up database Connection Service is following therein:

A. set up open database interconnecting interface data source;

B. configuration file is monitored in configuration;

C. setting up data connects

Utilize the link configuration of data base management system (DBMS) to realize the link of the heterogeneous database of two main flows, guarantee the safe, efficient of exchanges data;

3) flow process of the good operation system of combing, the working rule of standard operation system is according to the rule of data traffic flows; Set up data template; Offer the financial management system in downstream, in operation system, set up corresponding relation generating the required data of financial voucher and the information of financial voucher according to every kind of operation flow; Form the data template of the type; Set up the peek relation, close to tie up to according to peek then and set up the Data Receiving table in the financial management system, for the financial voucher that generates the type provides required data capsule;

4) carry out exchanges data, form the voucher data of financial system, through the database link service of setting up; According to the data template of setting up the peek relation,, form financial voucher data the financial management system of the data transfer of upstream business system to downstream; When preserving data, to regenerate the numbering and the ISN of voucher according to the data of system's Central Plains documentary numbering; And in the coding contrast relationship writing system log sheet, prevent next time to repeat to import, the user can be through importing daily record; Revising does not have the successfully data of importing, imports once more then.

Excellent effect of the present invention: solved the situation of some conglomerate's information island, several isolated relatively information management systems are organically coupled together, realized data sharing, and, form financial voucher data with the data patterning of putting in order.Said method comprises: unified basic data coding, set up the original base digital coding table of comparisons; Set up the database link service; Disposal data is set up data template; Carry out exchanges data, form the voucher data of financial system.The present invention widely applies in building trade and large-scale synthesis type conglomerate, has solved the situation of conglomerate's information island.Data in the operation system are directly generated the voucher data of financial system through arrangement, medelling by business datum.Owing to unified the basic data coding; Set up the database link service, medelling data, have simple to operate; Data exchange safety, effective characteristics; Successfully having solved a plurality of infosystems of conglomerate can not shared data, and Data Source relies on the problem of manual typing fully, has good value for applications.

Description of drawings

Fig. 1 is the chaining service structural representation of two heterogeneous database systems;

Fig. 2 is the data-switching process flow diagram;

Embodiment

Explanation at length below with reference to Figure of description method of the present invention being done.

According to the inventionly a kind ofly in two heterogeneous database management systems, realize data sharing, and the data of putting in order are sent to the method that financial management system generates the voucher data.Step is following:

1. this method is to establish unified coding rule earlier.Generally the coding rule according to the operation system at the upper reaches is reference, the basic data coding rule of unified each system.Original basic data need contrast with standard code in each system, sets up the contrast relationship table; Newly-increased data are quoted the basic data in the upstream business system by the management system in downstream.The basic data deletion action of not making amendment, the operation of only stopping using.In system, should set up required basic data contrast relationship, below existing at least in several list structures and each table main field following:

The unit department table of comparisons (DWBMDZ)

Field number	The field title	Field type
			DWBMDZ_BZDWBH	Standard unit's numbering	Varchar(10)
DWBMDZ_BZBMBH	Standard department numbering	Varchar(20)
			DWBMDZ_BZBMMC	The standard department name	Varchar(50)
DWBMDZ_GLDWBH	Management system unit's numbering	Varchar(10)
			DWBMDZ_GLBMBH	Management system department numbering	Varchar(20)
DWBMDZ_GLBMMC	The management system department name	Varchar(50)

Subscriber's meter (USERDZ)

Field number	The field title	Field type
			USERDZ_BZUSERID	The Standard User numbering	Varchar(10)
USERDZ_BZUSER	The Standard User title	Varchar(20)
			USERDZ_GLUSERID	The management system Customs Assigned Number	Varchar(10)
USERDZ_GLUSER	The management system user's name	Varchar(20)

2. can link through the Database Systems of chaining service with that, their data can be shared two isomeries.Chaining service is through calling the access interface of a kind of Sybase system, and the configuration database link information is provided with the data access security information, accomplishes the connection of heterogeneous database system.The tables of data title that needs only in visit during the integration across database visit adds with the title of chaining service just passable at the back.So not only realize sharing of two heterogeneous database system data, guaranteed safety of data again, thus the data security of making, effectively, transmit rapidly.

Shown in Figure 1 is the chaining service of two heterogeneous database systems.

3. the flow process of the good operation system of combing, the working rule of standard operation system.So just can set up data template, offer the financial management system in downstream according to the rule of data traffic flows.The information that is exactly the typing of the document information in the operation system is carried out standard; Then the data that need in the business paper to generate financial voucher are built up template; At last set up the Data Receiving table in the financial management system in downstream, required data are provided for generating financial voucher according to data template.

Shown in Figure 2 is the data-switching process flow diagram.

4. carry out exchanges data, form the voucher data of financial system.Because the database link service of setting up can realize the data sharing of two heterogeneous databases easily,, form financial voucher data the management system of the data transfer of upstream business system to downstream.In the process of exchanges data, to regenerate the numbering and the ISN of voucher according to the data of system's Central Plains documentary numbering when preserving data, and, prevent next time to repeat to import in the coding contrast relationship writing system log sheet.Produce and import result's report, writing system daily record simultaneously.The user can not have the successfully data of importing through importing result's report, revising, and imports once more then.

Embodiment

Do a detailed description with regard to concrete embodiment below.

1. unify the basic data coding.Because the coding of the basic data of each system all is different, so need the coding rule of unified basic data.Newly-increased data are quoted the basic data of the operation system at the upper reaches by the management system in downstream; If each management system will be set up the table of comparisons of original base digital coding and standard code because long-term use or other reasons can not carry out the modification of basic data in system.

2. set up the database link service, through calling the access interface of a kind of Sybase system, the configuration database link information is provided with the data access security information, accomplishes the connection of heterogeneous database system.The tables of data title that needs only in visit during the integration across database visit adds with the title of chaining service just passable at the back.Specify the foundation and the use of database link service below:

A. on a database server, set up an open database interconnecting interface data source.Open database interconnecting interface with in the window system just can be created, called after SData;

B., this database is set monitors configuration file.The database installation directory db_1 create down an initSData.ora file arranged, add following content:

The data source of HS_FDS_CONNECT_INFO=SData//set up.

HS_FDS_TRACE_LEVEL＝OFF

The database installation directory db_1 a listener.ora file is arranged under the catalogue, in SID_LIST_LISTENER, add a SID_DESC, content is:

The tnsnames.ora file is set:

The database installation directory network under a tnsnames.ora is arranged; Need in this document, add a tns name service; The tns name service of passing through to be added is set up data and is connected; With the open database interconnecting interface in the windows system is intermediary, just can accomplish the connection of database to other databases.The content of being added is:

C. set up the data link.

Create database link MsSql connect to sa identified by password using ' orcl ' //orcl is the tns service naming; Sa is a user name; Password is a password; MsSql is the data connection name

In the A database, just can visit the tables of data in the B database like this.Example is following:

SELECT*FROM?SYSCOLUMNSMsSql。

3. the flow process of the good operation system of combing, the working rule of standard operation system, disposal data is set up data template.For example professional with the material warehouse-in; The material warehouse-in has buying storage bill and turnover material storage bill, according to business rule, sets up the data template of this business rule; Form the peek rule of financial voucher, the standard active data is provided just can for the financial management system in downstream.Be material putaway rule data template below.

Material putaway rule data template

The material warehouse-in is divided into the buying storage bill will increase document types with turnover material storage bill, so just can generate the voucher summary info through document types, can also process other data according to the difference of document types.Debit's subject of the warehouse-in of material is corresponding according to concrete material type numbering; The credit account of material warehouse-in is to distinguish according to the modes of payments in the document; Increase modes of payments information, form contrast relationship, be used to generate the credit account of financial system with credit account.In financial accounting, need to adjust the information of auxiliary accounts such as supplier, engineering project, in the typing business paper, will these information be entered in the operation system, make things convenient for data extract.

After having set up data template, will set up the Data Receiving table in the financial management system in downstream according to the contrast relationship of data template.Still be example with the top material warehouse-in of telling, set up the Data Receiving table that material is gone into library template at financial system, list structure need comprise following field at least:

				Bullets	CLRKSJY_ZZJG	VARchar(40)	?.
Field number	The field title	Field type	Explanation of field
				Document ID	CLRKSJY_DJID	VARchar(40)	The major key field of document table
The document numbering	CLRKSJY_DJBH	VARchar(40)	?.
				The unit numbering	CLRKSJY_DWID	VARchar(40)	?.
The material type numbering	CLRKSJY_CLLB	VARchar(40)	Contrast with debit's subject
				The modes of payments	CLRKSJY_ZFFS	char(1)	Cash 0, cash in banks 1, prepayment 2, borrow money 3, other 4
The warehouse-in document types	CLRKSJY_DJLX	char(1)	0 expression buying warehouse-in; 1 expression turnover material warehouse-in
				The warehouse-in amount of money	CLRKSJY_RKJE	Decimal(20，8)	?.
Supplier unit's numbering	CLRKSJY_GYDW	VARchar(40)	?.
				The document date	CLRKSJY_DATE	VARchar(10)	?.
Purchasing agent's numbering	CLRKSJY_CGYID	VARchar(40)	?.

Document ID in the Data Receiving table is the major key as table, is used to prevent that data from repeating to import use; Other field data can be carried out association through numbering and generated title.

4. carry out exchanges data,, form the voucher data of financial system according to data template.In the management system in downstream, just can make things convenient for the data that obtain the upstream business system rapidly, form the voucher data of financial system.In the process of exchanges data; To generate the numbering and the ISN of voucher when preserving data according to the data of system's Central Plains documentary numbering; And, prevent next time to repeat to import convenient simultaneously inquiry reconciliation in voucher numbering and the business paper numbering contrast relationship writing system log sheet; And generation imports result's report, writing system daily record simultaneously.The user can not have the successfully data of importing through importing result's report, revising, and imports once more then.

Wherein create log sheet (DJLOGS) structure

Field number	The field title	Field type
			DJLOGS_YYBH	Application numbers	Varchar(20)
DJLOGS_DWBH	The unit numbering	varchar(10)
			DJLOGS_BMBH	Department's numbering	varchar(20)
DJLOGS_PZNM	The voucher ISN	Varchar(20)
			DJLOGS_YBH	The service system document numbering	Varchar(30)
DJLOGS_XBH	Service system document ID	Varchar(30)

This system can link together the Database Systems of isomery effectively, is based on that database connects, and this not only has the characteristics that are easy to dispose, and has ensured safe, the transmission efficiently of data.Solved that large-scale conglomerate application system is complicated, data volume is big, can not carry out the situation that active data is shared.

The present invention at present widely applies in building trade and large-scale synthesis type conglomerate; So just can organically couple together a plurality of management systems, not only solve the problem that a plurality of systems repeatedly import data, save a large amount of work of operator; Heightened work efficiency; But also having guaranteed validity, the promptness of data, the data of management system all are to derive from operation system, and can form the voucher data of financial management system easily.Solved large-size enterprise group and carried out data sharing, formed the present situation of information island because the Database Systems of isomery cause a plurality of infosystems to connect.This method can improve user's throughput rate and work efficiency, and improves the availability of each information management system, and they are organically linked together, and has very high popularization and economic worth.

Except that the described technical characterictic of instructions, be the known technology of those skilled in the art.

Claims (1)

1. method that in heterogeneous database system, realizes data sharing and generate financial voucher is characterized in that this comprises following step:

1) encodes through the basic data of unified a plurality of management systems; Set up the coding of original base data and the table of comparisons of normal data coding; The data of each information management system can both be understood, for a plurality of information management system data sharings provide precondition by other infosystems;

2) under the inconsistent situation of type of database that a plurality of management systems are used, the data sharing exchange of system is to carry out through the chaining service of database, and in certain large database, the step of setting up database Connection Service is following therein:

A. set up open database interconnecting interface data source;

B. configuration file is monitored in configuration;

C. setting up data connects:

Utilize the link configuration of data base management system (DBMS) to realize the link of the heterogeneous database of two main flows, guarantee the safe, efficient of exchanges data;

3) flow process of the good operation system of combing, the working rule of standard operation system is according to the rule of data traffic flows; Set up data template; Offer the financial management system in downstream, in operation system, set up corresponding relation generating the required data of financial voucher and the information of financial voucher according to every kind of operation flow; Form the data template of the type; Set up the peek relation, close to tie up to according to peek then and set up the Data Receiving table in the financial management system, for the financial voucher that generates the type provides required data capsule;

4) carry out exchanges data, form the voucher data of financial system, through the database link service of setting up; According to the data template of setting up the peek relation,, form financial voucher data the financial management system of the data transfer of upstream business system to downstream; When preserving data, to regenerate the numbering and the ISN of voucher according to the data of system's Central Plains documentary numbering; And in the coding contrast relationship writing system log sheet, prevent next time to repeat to import, the user can be through importing daily record; Revising does not have the successfully data of importing, imports once more then.

Images