CN103605699A - Method and device for configuring relations of data - Google Patents
Method and device for configuring relations of data Download PDFInfo
- Publication number
- CN103605699A CN103605699A CN201310549644.1A CN201310549644A CN103605699A CN 103605699 A CN103605699 A CN 103605699A CN 201310549644 A CN201310549644 A CN 201310549644A CN 103605699 A CN103605699 A CN 103605699A
- Authority
- CN
- China
- Prior art keywords
- data structure
- standard
- attribute
- definition
- data structures
- Prior art date
- Legal status (The legal status 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 status listed.)
- Pending
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/25—Integrating or interfacing systems involving database management systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2291—User-Defined Types; Storage management thereof
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
Abstract
The invention discloses a method and a device for configuring relations of data. The method includes steps of defining standard data structures: defining attributes of the standard data structures and defining presentation reports according to the attributes; configuring relations of data structures and attributes: configuring relations of the standard data structures, the attributes of the standard data structures, specific business data structures in business systems to be checked and attributes of the specific business data structures; defining standard objects and configuring relations: configuring relations of the standard objects and business objects of the specific business data structures in the business systems to be checked. The method and the device have the advantages that the relations of the standard data structures, the attributes of the standard data structures, the standard objects, the actual business data structures, the attributes of the actual business data structures and the business objects are configured after the standard data structures and the standard objects are defined, so that only the relations of the standard data structures and changed data structures to be checked need to be reconfigured without customized development by the aid of developers after the data structures to be checked change, and the method and the device are high in use flexibility.
Description
Technical field
The invention belongs to enterprise information management system technical field, more particularly, relate to a kind of method and device for the data correlation configuration in the information management system of different structure.
Background technology
Data check refers to that enterprise checks or monitoring work in order to complete checking of self control of interior business being carried out, such as inside and outside audit work, internal audit work, internal control work etc.
ERP system or managing and control system for general enterprise-level, conventionally there is the data structure of a lot of isomeries, as in a large-scale ERP system, owing to may being the mis system being provided by different manufacturers, the difference that can cause data structure, such as having two financial management systems in the financial system using in certain large-scale conglomerate, and in these two systems, use the list structure of storage voucher data completely different, therefore can not directly check the data checks such as inspection or monitoring.
Carry out traditional conventionally adopt when checking, auditing below two kinds of ways:
One, for specific data structure, carry out integrated form customized development, for existing data structure, by developer, develop customization and check rule, then by user, operate execution, this mode is helpless to the data system of isomery, and range of application is narrower.
Two, formulate the data structure of standard and the query function of standard, in the Database Systems of different structure, by the script being customized by developer in advance, carry out the extraction of data, the standard data structure by data pick-up for having customized, is then inquiring about inspection.Though the front a kind of method range of application of this method is wider, but must customize in advance script by developer before use, otherwise whole system cannot be moved.When the data structure of examine operation system changes, must to script, be modified by developer, and then extracted data just can check inquiry.And query manipulation all has developer to define exploitation, need new query manipulation again to develop corresponding program by developer and realize.
As known from the above, existing data check mode, or need to check that supervisory personnel has developer to carry out customized treatment all points that check that need before using, maybe need the database of isomery to extract or integrate, and in the time of the key point variation that will check or checked data structure generation adjustment, all need developer again to carry out could using after writing of code, be not easy to check that supervisory personnel operates.
Summary of the invention
The object of this invention is to provide a kind of method and device that the data of different structure database is carried out to associated configuration, so that check that supervisory personnel carries out data check.
To achieve these goals, the present invention takes following technical solution:
A data correlation collocation method, comprises the following steps:
Standard data structure definition step, defines the attribute of standard data structure, and represents form according to attribute definition;
The associated configuration step of data structure and attribute, carries out associated configuration by concrete operational data structure and attribute in standard data structure and attribute and examine operation system;
Standard object definition and associated configuration step, definition standard object, and the business object of concrete operational data structure in standard object and examine operation system is carried out to associated configuration.
In standard data structure definition step of the present invention, the content of the attribute of data structure comprises Chinese, Property Name, attribute type, length, attribute specification.
The content of standard object definition of the present invention and associated configuration step Plays object comprises sorting code number, specific name, classification ID, Sort Code and organization id.
A data correlation inking device, comprising:
Standard data structure definition unit, for defining the attribute of standard data structure and representing form according to attribute definition;
The associated configuration step unit of data structure and attribute, for carrying out associated joining by standard data structure and attribute thereof with data structure and the attribute of the concrete business of examine operation system;
Standard object definition and associated configuration unit, for defining standard object, and carry out associated configuration by the business object of concrete operational data structure in standard object and examine operation system.
From above technical scheme, the present invention is by definition standard data structure, then the data structure of the standard data structure defining and examine business is carried out to the mapping of attribute field, then in standard data structure, define corresponding standard object, after standard object and business practical object are shone upon, can carry out data check.Because the present invention is after definition standard data structure and standard object, by standard data structure and attribute thereof, standard object and actual traffic data structure and attribute thereof, business object is carried out associated configuration, for standard data structure, check rule setting, therefore need not from Database Systems, peek or integrate during data check, when the data structure of examine changes, user is customized rules or change script and again peek again, only need to be by the data structure of the examine after standard data structure and change again associated configuration, without developer's customized development, use dirigibility is high, and not only can be from longitudinally examine business datum having been carried out to standardization, data recording in can also showing for horizontal data checks.
Accompanying drawing explanation
In order to be illustrated more clearly in the embodiment of the present invention, to the accompanying drawing of required use in embodiment or description of the Prior Art be done to simple introduction below, apparently, accompanying drawing in the following describes is only some embodiments of the present invention, for those of ordinary skills, do not paying under the prerequisite of creative work, can also obtain according to these accompanying drawings other accompanying drawing.
Fig. 1 is the process flow diagram of the inventive method;
Fig. 2 is the operation interface schematic diagram of the bank account data structure of definition standard;
Fig. 3 is for representing the operation interface schematic diagram of form according to bank account data structure definition;
Fig. 4 is the associated configuration operation interface schematic diagram of standard data structure and concrete operational data structure;
Fig. 5 is standard object defining operation interface schematic diagram;
Fig. 6 is the operation interface schematic diagram of standard object and business object associated configuration;
Fig. 7 is the structured flowchart of data correlation inking device of the present invention.
Embodiment
Below in conjunction with the accompanying drawing in the embodiment of the present invention; technical scheme in the embodiment of the present invention is clearly and completely described; obviously; described embodiment is only the present invention's part embodiment; rather than whole embodiment; embodiment based in the present invention, those of ordinary skills, not making the every other embodiment obtaining under creative work prerequisite, belong to the scope of protection of the invention.
With reference to Fig. 1, Fig. 1 is the process flow diagram of the data correlation collocation method that provides of the embodiment of the present invention, and the method comprises the following steps:
S101, standard data structure definition step, comprising the definition of attribute in data structure and according to attribute to representing the definition of form.
As shown in Figure 2, Fig. 2 is the operation interface schematic diagram of the bank account data structure of definition standard, during the bank account data structure of definition standard, first the attribute in data structure is defined, for example, group capital administration authority, Bank Account Number, account purposes, affiliated bank capital are collected the attributes such as product and defined, and wherein the content of each attribute comprises Chinese, Property Name, attribute type, length, attribute specification etc.;
Attribute definition in data structure well after, according to defined attribute, to representing form, define the attribute that selection will be shown in representing form.Represent form for follow-up execution check, result presentation when the monitor check rule such as audit.As shown in Figure 3, Fig. 3 is for representing the operation interface schematic diagram of form according to the attribute definition of expense reimbursement request for data structure, the attributes such as Compatible object ID, Compatible object sign, bank account information and the bank of deposit in selection expense reimbursement request for data structure are as representing the attribute of showing in form, so that the relevant data of aforementioned attribute are shown in result.
The associated configuration step of S102, data structure and attribute;
In the system of different structure, the definition of the data structure of concrete business and attribute thereof is had nothing in common with each other, after defining standard data structure, data structure and the attribute of concrete business in standard data structure and attribute and examine operation system need to be carried out to associated configuration, set up mapping relations, so that check that supervisory personnel can verify under the data structure of unified standard.
As shown in Figure 4, during associated configuration, first the bank account data structure of standard and the bank account table of examine operation system are carried out associatedly, then the respective attributes table of the bank account table in the attributes such as group capital administration authority, account purposes, Bank Account Number, affiliated higher level's bank account in the bank account data structure of standard and concrete operation system is carried out to associated configuration.
S103, standard object definition and associated configuration step, definition standard object, carries out associated configuration by the business object of concrete operational data structure in standard object and examine operation system.
As shown in Figure 5, Fig. 5 is the operation interface schematic diagram of the standard object of the account purposes attribute in the bank account data structure of definition standard.The standard object of defined account purposes is presented in corresponding data structure.The content of standard object definition comprises sorting code number, specific name, classification ID, Sort Code and organization id.
Define after standard object, will the business object of concrete operational data structure in standard object and examine operation system be carried out to associated configuration.As shown in Figure 6, Fig. 6 is the operation interface schematic diagram of standard object and business object associated configuration.Business object in the account purposes system table of the standard object of the account purposes of definition and concrete business is carried out to associated configuration, set up mapping relations, corresponding relation is as following table:
| Account purposes standard data structure | Examine operation system account purposes table |
| Bank account purposes special family | Special family |
| Bank account purposes trade union's account | Trade union's account |
After the normal data of examine having been configured by above step, can carry out data check.When the data structure of examine operation system is revised, as account purposes in operation system is revised as " special specially family " from " specially family ", or the use of funds record sheet in operation system is revised as MONEY by original amount of money Property Name from JE, as long as the data structure in standard data structure or its attribute and new data structure or its attribute are carried out to associated configuration, make the data structure of standard data structure and concrete business there are corresponding mapping relations, can carry out and check according to fixed rule.
As shown in Figure 7, the present invention also provides a kind of data correlation inking device, comprising:
Standard data structure definition unit, for definition data structure attribute with represent form according to attribute definition;
The associated configuration step of data structure and attribute, for data structure and the attribute of standard data structure and attribute and the concrete business of examine operation system are carried out to associated configuration, sets up mapping relations;
Standard object definition and associated configuration unit, for carrying out associated configuration by the business object of standard object and the concrete operational data structure of examine operation system.
It should be noted that, the contents such as the information interaction between each module/unit of said apparatus, implementation, owing to conceiving based on unified with the inventive method embodiment, its technique effect bringing is identical with the inventive method embodiment, particular content can, referring to the narration in the inventive method embodiment, repeat no more herein.
It will be appreciated by those skilled in the art that, unit and the algorithm steps of each example of describing in conjunction with embodiment disclosed herein, can realize with electronic hardware, computer software or the combination of the two, for the interchangeability of hardware and software is clearly described, composition and the step of each example described according to function in the above description in general manner.These functions are carried out with hardware or software mode actually, depend on application-specific and the design constraint of technical scheme.Professional and technical personnel realizes described function with distinct methods in the time of can specifically should being used for to each, but this realization should not thought and exceeds scope of the present invention.
The software module that the method for describing in conjunction with embodiment disclosed herein or the step of algorithm can directly use hardware, processor to carry out, or the combination of the two is implemented.Software module can be placed in random access memory (RAM), internal memory, ROM (read-only memory) (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or the known any other forms of storage medium of technical field.
Above-mentioned explanation to the disclosed embodiments, makes professional and technical personnel in the field can realize or use the present invention.To the multiple modification of previous embodiment, will be apparent for those skilled in the art, in the present invention, defined General Principle can, in the situation that not departing from the spirit or scope of the present invention, realize in other embodiments.Therefore, the present invention will can not be restricted to previous embodiment, but will meet the widest scope consistent with principles of this disclosure and features of novelty.
Claims (6)
1. a data correlation collocation method, is characterized in that, comprises the following steps:
Standard data structure definition step, defines the attribute of standard data structure, and represents form according to attribute definition;
The associated configuration step of data structure and attribute, carries out associated configuration by concrete operational data structure and attribute in standard data structure and attribute and examine operation system;
Standard object definition and associated configuration step, definition standard object, and the business object of concrete operational data structure in standard object and examine operation system is carried out to associated configuration.
2. data correlation collocation method according to claim 1, is characterized in that: in described standard data structure definition step, the content of the attribute of data structure comprises Chinese, Property Name, attribute type, length, attribute specification.
3. data correlation collocation method according to claim 1 and 2, is characterized in that: the content of described standard object definition and associated configuration step Plays object comprises sorting code number, specific name, classification ID, Sort Code and organization id.
4. a data correlation inking device, is characterized in that, comprising:
Standard data structure definition unit, for defining the attribute of standard data structure and representing form according to attribute definition;
The associated configuration step unit of data structure and attribute, for carrying out associated joining by standard data structure and attribute thereof with data structure and the attribute of the concrete business of examine operation system;
Standard object definition and associated configuration unit, for defining standard object, and carry out associated configuration by the business object of concrete operational data structure in standard object and examine operation system.
5. data correlation inking device according to claim 4, is characterized in that: the content of the attribute in described standard data structure comprises Chinese, Property Name, attribute type, length, attribute specification.
6. according to the data correlation inking device described in claim 4 or 5, it is characterized in that: the content of described standard object comprises sorting code number, specific name, classification ID, Sort Code and organization id.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310549644.1A CN103605699A (en) | 2013-11-07 | 2013-11-07 | Method and device for configuring relations of data |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310549644.1A CN103605699A (en) | 2013-11-07 | 2013-11-07 | Method and device for configuring relations of data |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN103605699A true CN103605699A (en) | 2014-02-26 |
Family
ID=50123922
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310549644.1A Pending CN103605699A (en) | 2013-11-07 | 2013-11-07 | Method and device for configuring relations of data |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN103605699A (en) |
Cited By (3)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105335461A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | System and method for quickly writing fact value of XBRL instance document |
| CN105677776A (en) * | 2015-12-30 | 2016-06-15 | 厦门欣欣信息有限公司 | Data processing method and device |
| CN109447389A (en) * | 2018-09-05 | 2019-03-08 | 航天信息股份有限公司 | A kind of method and system for being managed to weighing business datum |
Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1604082A (en) * | 2003-08-29 | 2005-04-06 | 微软公司 | Mapping architecture for arbitrary data models |
| CN1790322A (en) * | 2004-12-17 | 2006-06-21 | 国际商业机器公司 | Method and system of creating a logical table from multiple differently formatted physical tables |
| CN101576922A (en) * | 2009-06-25 | 2009-11-11 | 用友软件股份有限公司 | Access system and access method |
| CN102103710A (en) * | 2009-12-21 | 2011-06-22 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
-
2013
- 2013-11-07 CN CN201310549644.1A patent/CN103605699A/en active Pending
Patent Citations (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1604082A (en) * | 2003-08-29 | 2005-04-06 | 微软公司 | Mapping architecture for arbitrary data models |
| CN1790322A (en) * | 2004-12-17 | 2006-06-21 | 国际商业机器公司 | Method and system of creating a logical table from multiple differently formatted physical tables |
| CN101576922A (en) * | 2009-06-25 | 2009-11-11 | 用友软件股份有限公司 | Access system and access method |
| CN102103710A (en) * | 2009-12-21 | 2011-06-22 | 中国移动通信集团公司 | ERP (Enterprise Resource Planning) system access control method and platform |
Non-Patent Citations (3)
| Title |
|---|
| 宋利康 等: "企业模型与ERP系统间映射技术", 《航空学报》 * |
| 王鲁 等: "供应链企业ERP生产管理数据互联互通的研究", 《大连交通大学学报》 * |
| 边世红 等: "ERP系统中对象模型向实体关系模型的映射", 《计算机工程与设计》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN105335461A (en) * | 2015-09-24 | 2016-02-17 | 四川长虹电器股份有限公司 | System and method for quickly writing fact value of XBRL instance document |
| CN105335461B (en) * | 2015-09-24 | 2019-03-26 | 四川长虹电器股份有限公司 | The system and method for no write de-lay XBRL instance document fact value |
| CN105677776A (en) * | 2015-12-30 | 2016-06-15 | 厦门欣欣信息有限公司 | Data processing method and device |
| CN109447389A (en) * | 2018-09-05 | 2019-03-08 | 航天信息股份有限公司 | A kind of method and system for being managed to weighing business datum |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20170277769A1 (en) | Techniques to manage time-varying cluster configuration information | |
| US7177822B2 (en) | Common database system for sales and marketing process | |
| US8555248B2 (en) | Business object change management using release status codes | |
| US8886590B2 (en) | Master data management in a data warehouse/data mart | |
| EP1677243A1 (en) | Method and apparatus for metadata driven business logic processing | |
| CN102810057A (en) | Log recording method | |
| US20090024639A1 (en) | Data mapping and import system | |
| CN110032594B (en) | Customizable data extraction method and device for multi-source database and storage medium | |
| CN102231194A (en) | Method and system for managing life cycle of object | |
| CN101714078A (en) | Code generation method and device | |
| CN111145011B (en) | Banking system building method and device | |
| CN105677346A (en) | Dynamic expansion method of web interface and server | |
| CN103729713A (en) | Audit result display configuration method and device | |
| CN117033460B (en) | Automatic data model construction system and method based on bus matrix | |
| CN103903085B (en) | A kind of method and device for isolating Report form application scene | |
| Shahbaz | Data mapping for data warehouse design | |
| CN1987775A (en) | Method and apparatus for resolving events | |
| CN103605699A (en) | Method and device for configuring relations of data | |
| CN110378569A (en) | Industrial relations chain building method, apparatus, equipment and storage medium | |
| CN107392560A (en) | A kind of Excel list datas issue acquisition method and system based on internet | |
| US8069148B2 (en) | Configuration of multiple database audits | |
| CN102999618B (en) | Personal behavior attribute information base method for building up and the system at family is returned based on address | |
| JP7279524B2 (en) | Data management program, data management method and data management system | |
| CN104123104A (en) | Log control system and method | |
| CN102866985A (en) | Data formatting device and method for on-line analytical processing system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20140226 |