CN1369840A - Method for integrating information cross databases and its architecture - Google Patents
Method for integrating information cross databases and its architecture Download PDFInfo
- Publication number
- CN1369840A CN1369840A CN 01107546 CN01107546A CN1369840A CN 1369840 A CN1369840 A CN 1369840A CN 01107546 CN01107546 CN 01107546 CN 01107546 A CN01107546 A CN 01107546A CN 1369840 A CN1369840 A CN 1369840A
- Authority
- CN
- China
- Prior art keywords
- database
- main file
- information
- integration
- product main
- 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
- 238000000034 method Methods 0.000 title claims description 28
- 239000000463 material Substances 0.000 claims abstract description 28
- 230000010354 integration Effects 0.000 claims description 59
- 238000004891 communication Methods 0.000 abstract description 4
- 238000007726 management method Methods 0.000 description 15
- 238000005516 engineering process Methods 0.000 description 5
- 238000010586 diagram Methods 0.000 description 4
- 238000013500 data storage Methods 0.000 description 3
- 239000002699 waste material Substances 0.000 description 2
- 230000015572 biosynthetic process Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 238000005755 formation reaction Methods 0.000 description 1
- 238000004519 manufacturing process Methods 0.000 description 1
Images
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Based on main table of product, three layers typed data structure, which includes material list/main table of product/relevant information object, is built. Various modules of information management software or information objects, which are stored on material list, main table of product, relevant informatino object in same database, are integrated into an information module. The linkage between information modules in different database is realized by use of tree structure of main table of product so as to form a integrated structure of informatino system providing shared information and communication between various information objects in different databases.
Description
The present invention relates to a kind of method and structure thereof of setting up the conformability infosystem, particularly relate to a kind of information object of integration across database can the integration so that the method for information sharing and system architecture thereof.
With regard to ordinary consumer, computer software product can be divided into two kinds of system software and application software haply, and the former forms the necessary software of computer system, and the latter then is general company, educational unit and individual employed instrument.
If from the use aspect, we can be divided into following basic layer from low to high with system:
Operating system is as UNIX or WINDOWS 95,98, NT system;
Data base management system (DBMS) (DBMS);
Product Information Management (PDM) system;
With some comparatively huge application software or communication management application software, for example:
CAD/CAM/CAE software;
ERP (ERP) software;
Production management related softwares such as MIS/MRP/MRP II/CRP/JIS; And
Office automation management software.
Yet in the Computer information network of an enterprise, may include a plurality of different system softwares (as UNIX and PDM), and a plurality of different communication management application softwares (as CAD/CAM/CAE software and MIS software), and in numerous and jumbled company information network like this like this, when any user wants to seek the data of integration across database even interdepartmental system, all will face the problem that data is sought difficulty even can't be found required information.
In this company information network, also have a problem, that is exactly the waste that repeats to cause the data storage resource of data, for example: sales department need some about the data of a certain product (as Parts List, part drawing etc.), but because system's difference or needed data be not in the database that he can visit, cause the sales force can't obtain the related data that in fact in the infosystem of design department, has existed, the sales force may they system or database in rebuild this product data, this has just caused the waste of the data storage resource of enterprise, and has reduced work efficiency.
The object of the present invention is to provide a kind of method that the information object of integration across database is integrated to reach the conformability infosystem structure of according to said method setting up, particularly providing a kind of can link the different information management software modules of exploitation respectively or the information object that is dispersed in the disparate databases, makes can intercom mutually between the different software modules and the conformability infosystem structure of shared information.
For achieving the above object, the present invention has adopted following technical scheme: method and system architecture thereof that the information object of integration across database of the present invention is integrated are based on a product main file (Item Master), set up relevant information contact each other in the disparate databases by this product main file.Promptly by setting up the means of a kind of information module (Information Module), mainly be to utilize three-layer type (3-Tier) data structure that includes the bill of materials (BillOf Material), product main file and relevant information object, set up a kind of connection bill of materials, product main file and relevant information module.With above-mentioned information module is elementary cell, information module by this three layers structure, all relevant informations that will belong to certain product in the same database, certain plan or certain information object are integrated, the special construction that the present invention utilizes a kind of product main file tree structure of integration across database to be constituted links the information module that is dispersed in the disparate databases.
Compared with prior art, the present invention can finish the integration to the relevant information of the product in a certain database (for example certain commodity, certain plan) and all these products of territory preferably, and can mutual communication between the relevant information object of integration across database and can share information.The user is all relevant informations of this product of management and use easily, have improved work efficiency.
Below in conjunction with graphic detailed technology content of the present invention is described, wherein
Fig. 1 is the information integrating method of integration across database of the present invention and a relevant information system of system architecture thereof;
Fig. 2 is the information integrating method of integration across database of the present invention and a most preferred embodiment of system architecture thereof;
Fig. 3 is the information integrating method of integration across database of the present invention and the information module schematic internal view of system architecture thereof;
Fig. 4 is the information integrating method of integration across database of the present invention and the information module internal relations synoptic diagram of system architecture thereof;
Fig. 5 is the information integrating method of integration across database of the present invention and a conformability infosystem structural representation of system architecture thereof;
Fig. 6 is a product main file tree structure synoptic diagram among Fig. 5;
Fig. 7 is the information integrating method of integration across database of the present invention and another embodiment of system architecture thereof;
Fig. 8 is the information integrating method of integration across database of the present invention and a product core texture synoptic diagram of system architecture thereof;
Fig. 9 is the graph of a relation between the different product core texture of the information integrating method of integration across database of the present invention and system architecture thereof.
In the explanation hereinafter, will be example, technology contents of the present invention will be described one by one with infosystem shown in Figure 1; Suppose to include following several database and application module in the infosystem of certain enterprise:
CAE database 10d:CAE application module;
MRP II database 10f:MRP II application module; And
Above database, all be to exist according to tree structure form shown in Figure 1, and these databases all only are associated with its database of father node, if the relevant information of certain product is present in respectively in the different databases, then, can't finish information search or use to integration across database only with tree structure shown in Figure 1 and relation.
In order to address this problem, the present invention proposes the technology of utilizing all information that a kind of product main file object will be relevant with a certain product to integrate.One product main file object is all arranged in each database, based on this product main file object, integrate the product main file object of all relevant informations of identical product and link mutually being dispersed in being used in the disparate databases, to reach the purpose of integrating relevant information in all databases.
So the disclosed method of the present invention, all should include following steps basically:
1, in each database, sets up product main file object, in order to integrate all relevant in this database information with a certain product;
2, set up a kind of product main file tree structure of integration across database, and in this step, mainly be to rely on the product main file object that is dispersed in disparate databases to construct mutual contact, reach the purpose of integrating relevant information in all databases.
For example, in infosystem shown in Figure 1, there are all relevant informations of an A product to be distributed in design database 10b, among these three databases of 3D CAD database 10c and MRP database 10e, then according to method proposed by the invention, the product main file object of A product will be present in these three databases respectively and the MIS database 10a that is used for the product main file object of A product in these three databases is integrated among, and these are dispersed in the product main file object of the A product in the disparate databases, can utilize a kind of integration across database hinged node 70a, 70b, 70c and 70d are (as Fig. 2, Fig. 5, shown in Figure 8) set up contact to each other, have the conformability infosystem of structure as shown in Figure 2 thereby constitute.
Therefore, if we need be from design database 10b, when going to seek information relevant among the MRP database 10e with the A product with the mode of integration across database, can be by the product main file object 101 of A product among the design database 10b, go for the product main file object 102 of A product among the MIS database 10a, find out the product main file object 103 of A product among the MRP database 10e again, can obtain information relevant among the MRP database 10e by the product main file object 103 of A product at last with the A product.
First step according to said method of the present invention, at first in each database, set up product main file object, the method of utilizing this product main file object that all relevant with certain product in this database information are got in touch by foundation is integrated and is become an information module, cooperate above-mentioned second step to set up a kind of product main file tree structure of integration across database again, just can finish conformability infosystem structure of the present invention.
As shown in Figure 3, information module 20 includes three kinds of objects among the present invention, be respectively: the bill of materials (BOM) object 30, product main file object 40, and relevant information object 50 (as archives or data), because most relevant information object 50 all is to be stored in among a kind of project database (Project_Database), below be referred to as project database object 50, and these three kinds of objects will constitute a kind of three-layer type data structure according to linking relationship shown in Figure 4.
Bill of materials object 30 is by many (see figure 4)s that bill of materials node 301 is formed of tree structure, they are used for storing the laminarity structure of the other product of same superclass, the other product of these superclass may be a certain product (as a motor), a certain plan (as marketing plan) or a certain information object (as Human Resources Management System).In the present invention, the structure that bill of materials object 30 can product also can be the structure of plan, the structure of software, the structure of spare part, structure or even the occurrences in human life and the financial structure etc. of stock control.
With regard to information module 20 product main file object 40 itself, be be used for integrating and link information module 20 among all various information that are associated, particularly, be to be used for setting up and manage certain product in the information module 20 at its place and to get in touch with the data between all information that this product is associated.
As shown in Figure 4, information module 20 of the present invention includes single product main file object 40, utilize all relevant informations of these product main file object 40 certain products of management, just utilize this product main file object 40 the information relevant among bill of materials object 30 and the project database object 50 of being dispersed in this product (as one or more bill of materials nodes 301, also may be one or more archives or data 501a, 501b 501c) is linked into a kind of information module 20 of three layers structure.In general, among an information module 20, may include a plurality of bill of materials objects 30, and a plurality of project database objects 50, therefore single product main file object 40 may be related with one or more bill of materials object 30 and one or more project database object 50 formations, and this needs decide according to the distribution situation of information in bill of materials object 30 and project database object 50 relevant with this product.
Link type in the above-mentioned this conformability infosystem structure can include following three kinds:
Logical connection (Logic link) is used for setting up the mutual contact of the other object of superclass among the same information module 20.For example, utilize the logical connection type just can set up linking relationship between bill of materials object 30, product main file object 40 and project database object 50 threes; (in each figure, representing) with solid line
Layering link (Hierachical Link) is used for setting up the mutual contact of each subclass object (as bill of materials node 301) among the other object of same superclass (as bill of materials object 30);
Hyperlink (Hyperlink) is used to link integration across database or different information management software module information module 10 to each other, to set up a kind of conformability infosystem structure of information sharing.(in each figure, dotting)
For the information module 20,20a and the 20b that belong in the disparate databases, the present invention utilizes a kind of particular link structure that is made of the product main file tree structure of integration across database, link being dispersed in the disparate databases relevant information module 20,20a and 20b, make and to share information each other between the information management software module of integration across database or the information object.
As shown in Figure 5, the product main file tree structure of this integration across database has mainly comprised: the product main file object 40 that lays respectively at information module 20,20a and 20b in the disparate databases, and the product main file that is based upon in the information integrated database 60 is managed object 61, so in the product main file tree structure example of this integration across database, product main file management object 61 is a father node, and product main file object 40 then is the child node (see figure 6) of product main file management object 61.
So according to this method of setting up the product main file tree structure of integration across database, be applied among the aforementioned infosystem illustrated in figures 1 and 2, then wherein lay respectively at the product main file object 101 of A product among the design database 10b, and the product main file object 103 of A product among the MRP database 10e, be the child node in the product main file tree structure of this integration across database, and be arranged in MIS database 10a A product product main file object 102 are aforementioned the two father nodes.In like manner, to different information systems carry out Integration Design the time, we can also be by upwards setting up the means of father node, set up father node management object 62 (see figure 6)s of a product main file management object 61 that is used for managing being arranged in different information systems S1 and S2, and constitute a kind of conformability infosystem structure that can interdepartmental system.
Among the product main file tree structure of this integration across database, lay respectively at the product main file management object 61 of father node, and any one is arranged in the product main file object 40 of child node, all be to utilize project database node 70a, 70b, 70c and 70d in a kind of database that lays respectively at its place to set up mutual contact, and this contact between project database node 70a, 70b, 70c and 70d is a kind of hyperlink, therefore can finish the Info Link of integration across database.
Seeing also shown in Figure 7ly again, is another embodiment of the present invention.Comprising utilizing product main file object to set up a kind of technology of product structure core 80, this product structure core 80 is a kind of with a kind of data structure notion of product concept as the basis, in this technology, it is other that we are divided into two kinds of superclass with product main file object, a kind of actual products main file (Real Item Master) object 81 that is called, another kind then is called concept product main file (Option Item Master) object 82.
As shown in Figure 8, actual products main file object 81 has been represented different actual products (for example A board ballpoint pen, B board ballpoint pen) respectively, and concept product main file object 82 refers to the abstract classification (ballpoint pen for example of products, pen, writing brush just are meant the abstract classification of product).Between actual products main file object 81 and concept product main file object 82, utilize the relation of logical connection to represent the contact of actual products and specific products kind.Because concept product main file object 82 has been represented a kind of abstract product category, we can utilize it to explain or show multiple possible information such as the spare part structure of a certain series products or material structure to form structure, therefore, concept product main file object 82 is a kind of tree structures, has comprised many concept product main file object nodes 821.
Therefore in like manner, the actual products main file object 81 in a certain database has a plurality of, and concept product main file object 82 also has a plurality of, may have a plurality of actual products main file objects 81 and identical concept product main file object 82 is associated.With bill of materials object 30 links of this product structure core 80 and different product (for example A board ballpoint pen, B board ballpoint pen), just become a kind of product core texture again.
As shown in Figure 9, be to include actual products main file object 81, concept product main file object 82 and bill of materials object 30 product core textures and other is dispersed in the relation structure diagram that the product core texture in the disparate databases 10 is integrated with this according to aforesaid method.
Claims (12)
1. the information integrating method of an integration across database is used for the various information objects in the disparate databases are linked into a kind of system architecture that can communicate with one another and can share information, it is characterized in that, comprises following steps:
In each database, set up a product main file object, be used for linking all relevant in the database at its place information with a certain product;
Set up the tree structure of the product main file object of an integration across database, at least include product main file management object in this tree structure, and aforementioned each product main file object that is dispersed in the disparate databases, this product main file management object and aforementioned each product main file object that is dispersed in the disparate databases are linked, and make each this product main file object become the child node of this product main file management object.
2. the information integrating method of integration across database according to claim 1, it is characterized in that, in each database, set up in the step of product main file object, also comprise and set up a kind of step that includes the information module of described product main file object, a bill of materials object and a relevant information object.
3. as the information integrating method of integration across database as described in the claim 2, it is characterized in that, set up the step of described information module, also comprise the step of setting up the mutual logical relation of described product main file object and described bill of materials object and described relevant information object.
4. as the information integrating method of integration across database as described in the claim 3, it is characterized in that also including described bill of materials object set up becomes a kind of step of tree structure of hierarchy that is used for storing the other product of same superclass that includes a plurality of bill of materials nodes.
5. the information integrating method of integration across database according to claim 1, it is characterized in that, wherein set up the step of tree structure of the product main file object of described integration across database, also include and set up a step that is used for storing the information integrated database of described product main file management object.
6. as the information integrating method of integration across database as described in the claim 5, it is characterized in that, set up the step of described information integrated database, also include:
Produce the step of an integration across database hinged node;
Set up the step of this integration across database hinged node and described product main file management object logical connection to each other; With
Set up the step of this integration across database hinged node and described product main file object hyperlink to each other.
7. the integration system structure of the information of an integration across database includes a plurality of databases, product main file and an information integrated database, and it is characterized in that: described database includes at least one bill of materials object and relevant information object; Product main file object is based upon in any described database, and becomes a kind of information module that is used for integrating the three-layer type data structure of all information relevant with a certain product with described bill of materials object and described relevant information Module Links; Information integrated database includes at least one product main file management object, and the integration across database hinged node that links with described product main file management object, wherein said product main file management object is to utilize described integration across database hinged node and described product main file object to be created as the product main file tree structure of an integration across database with the hyperlink relation, and described product main file management object is the father node position that is positioned at described product main file object, in order to link all product main file objects of identical product in described a plurality of database.
8. as the information integration system structure of integration across database as described in the claim 7, it is characterized in that described bill of materials object includes a plurality of nodes that are used for storing the hierachical structure of the other product of same superclass.
9. as the information integration system structure of integration across database as described in the claim 7, it is characterized in that, is the relation of logical connection between described product main file object and described bill of materials object and the described relevant information object.
10. as the information integration system structure of integration across database as described in the claim 7, it is characterized in that described product main file object also comprises an actual products main file object and a notion product main file object.
11. the information integration system structure as integration across database as described in the claim 10 is characterized in that described concept product main file object is a kind of tree structure, it includes many object nodes, is used for storing the laminarity structure of a certain series products.
12. the information integration system structure as integration across database as described in the claim 10 is characterized in that described actual products main file object and concept product main file object utilize the relation of logical connection to represent the relation of actual products and specific products kind.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01107546 CN1369840A (en) | 2001-02-17 | 2001-02-17 | Method for integrating information cross databases and its architecture |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN 01107546 CN1369840A (en) | 2001-02-17 | 2001-02-17 | Method for integrating information cross databases and its architecture |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN1369840A true CN1369840A (en) | 2002-09-18 |
Family
ID=4656467
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN 01107546 Pending CN1369840A (en) | 2001-02-17 | 2001-02-17 | Method for integrating information cross databases and its architecture |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN1369840A (en) |
Cited By (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100583089C (en) * | 2004-07-22 | 2010-01-20 | 威盛电子股份有限公司 | database application management system and method |
| CN101877011A (en) * | 2010-03-09 | 2010-11-03 | 苏州工业园区七星电子有限公司 | SNS-based social bookmark sharing system and method |
| CN101883121A (en) * | 2010-03-09 | 2010-11-10 | 苏州工业园区七星电子有限公司 | Combined system and method between net digest trees |
| CN101477547B (en) * | 2009-01-20 | 2011-05-11 | 中国测绘科学研究院 | Regulation based spatial data integration method |
| US8126850B2 (en) | 2008-08-13 | 2012-02-28 | Alibaba Group Holding Limited | Method and system for saving database storage space |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
| CN108351895A (en) * | 2015-11-11 | 2018-07-31 | 皇家飞利浦有限公司 | To the database integration for going identificationization and/or the longitudinal information of addition |
| CN110427507A (en) * | 2019-07-23 | 2019-11-08 | 武昌理工学院 | A processing method for real estate surveying and mapping |
-
2001
- 2001-02-17 CN CN 01107546 patent/CN1369840A/en active Pending
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN100583089C (en) * | 2004-07-22 | 2010-01-20 | 威盛电子股份有限公司 | database application management system and method |
| US8126850B2 (en) | 2008-08-13 | 2012-02-28 | Alibaba Group Holding Limited | Method and system for saving database storage space |
| CN101650717B (en) * | 2008-08-13 | 2013-07-31 | 阿里巴巴集团控股有限公司 | Method and system for saving storage space of database |
| US9471440B2 (en) | 2008-08-13 | 2016-10-18 | Alibaba Group Holding Limited | Method and system for processing product properties |
| CN101477547B (en) * | 2009-01-20 | 2011-05-11 | 中国测绘科学研究院 | Regulation based spatial data integration method |
| CN101877011A (en) * | 2010-03-09 | 2010-11-03 | 苏州工业园区七星电子有限公司 | SNS-based social bookmark sharing system and method |
| CN101883121A (en) * | 2010-03-09 | 2010-11-10 | 苏州工业园区七星电子有限公司 | Combined system and method between net digest trees |
| CN103646100A (en) * | 2013-12-20 | 2014-03-19 | 北京中电普华信息技术有限公司 | Report data organization model |
| CN108351895A (en) * | 2015-11-11 | 2018-07-31 | 皇家飞利浦有限公司 | To the database integration for going identificationization and/or the longitudinal information of addition |
| CN110427507A (en) * | 2019-07-23 | 2019-11-08 | 武昌理工学院 | A processing method for real estate surveying and mapping |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US6609129B1 (en) | Method for integrating various information objects among different databases into a system structure | |
| JP4222947B2 (en) | Method, program, and system for representing multimedia content management objects | |
| US8010487B2 (en) | Synchronization and collaboration within peer-to-peer and client/server environments | |
| CN1251088C (en) | Target integrated management system | |
| US7254584B1 (en) | Relationship-based inherited attributes system | |
| CN1811767A (en) | Systems and methods for providing a user interface with an automatic search menu | |
| CN1369840A (en) | Method for integrating information cross databases and its architecture | |
| CN1547137A (en) | Mass file management system and method based on database | |
| CN117787432A (en) | Machine learning method and device based on lake-warehouse integration | |
| CN101833511A (en) | Data management method, device and system | |
| CN101578579A (en) | Taxonomy object modeling | |
| US7882114B2 (en) | Data processing method and data processing program | |
| CN113297400A (en) | Metadata extraction method of 3D printing model | |
| CN1707496A (en) | Knowledge management method and system based on activity | |
| CN1432948A (en) | Material list conforming method via computer software | |
| CN1301479C (en) | Organizational structure establishment method and authority control method | |
| CN1588368A (en) | Based on mode XML storage method and use | |
| CN114610718B (en) | A method and device for storing and managing three-level structures of over-the-counter derivative contract elements | |
| CN114490038B (en) | A performance optimization method for complex PDM systems | |
| CN1598816A (en) | A system for automatically generating keyword classification lists | |
| CN116561222B (en) | A spatial data management method that enables efficient updating and querying | |
| CN1755688A (en) | classify objects | |
| CN115934211A (en) | Universal data mode applied to big data CDP field and application thereof | |
| CN1667613A (en) | Structured task naming | |
| CN1527229A (en) | Hotal management system for group accommodation |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
| WD01 | Invention patent application deemed withdrawn after publication |