CN107391537A - Generation method, device and the equipment of data relationship model - Google Patents
Generation method, device and the equipment of data relationship model Download PDFInfo
- Publication number
- CN107391537A CN107391537A CN201710279338.9A CN201710279338A CN107391537A CN 107391537 A CN107391537 A CN 107391537A CN 201710279338 A CN201710279338 A CN 201710279338A CN 107391537 A CN107391537 A CN 107391537A
- Authority
- CN
- China
- Prior art keywords
- database
- operation system
- data
- tables
- relational model
- 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.)
- Granted
Links
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/22—Indexing; Data structures therefor; Storage structures
-
- 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/21—Design, administration or maintenance of databases
- G06F16/211—Schema design and management
- G06F16/212—Schema design and management with details for data modelling support
-
- 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/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
- G06F16/288—Entity relationship models
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The embodiment of the present application discloses a kind of generation method of data relationship model, device and equipment, and this method includes：The operation information of built-in function is carried out according to each database to operation system respectively, generates the first relational model of each database of operation system；The operation information of integration across database operation, and the first relational model of each database are carried out according to each database to operation system, generates the second relational model of multiple databases of operation system.Due to can be determined by the embodiment of the present application operation system all databases tables of data between relation, it is thereby achieved that the combing to the relation between the tables of data of all databases of operation system.
Description
Technical field
The application is related to field of computer technology, more particularly to a kind of generation method of data relationship model, device and sets
It is standby.
Background technology
In order to meet the diversified demand of user, there is provided the quantity of the business of difference in functionality is also more and more.Wherein, some
The different departments of same company can be derived from by providing the business of difference in functionality, for example, to meet the idle article of user's processing
Demand, the primary sector of company A can provide the business for selling idle article；To meet that user's low price buys the need of article
Ask, the secondary sector of company A can provide the business for buying second-hand article.
Although these business for providing difference in functionality derive from the different departments of same company, those business can be total to
Enjoy some or a few individual databases, for example, equally by taking above-mentioned company A as an example, as user by smart machine to company A
, can be with registered user's name when two departments buy second-hand article, and second-hand article is bought using the user name.Afterwards, when the use
Family by smart machine to the primary sector of company A sell idle article when, can no longer re-register user name, but use
The user name registered before when buying second-hand article sells idle article.
Because different business can correspond to different operation systems, therefore, when different business shares some or certain
During several databases, operation system corresponding with those business can also share some or a few individual databases.When needs pair
When relation between the tables of data of all databases of operation system is combed, due to each database can correspond to it is multiple
Operation system, and each operation system in the plurality of operation system can correspond to multiple databases, therefore, it is necessary to know with
The association of tables of data is closed in all databases corresponding to all operation systems of each database correlation in the plurality of database
System, the relation between tables of data that just can be in pair all databases related to operation system comb.It is it follows that right
The workload that relation between the tables of data of all databases related to operation system is combed is big and work difficulty is high.
In correlation technique, the pass between the tables of data in database is drawn by the join sentences of analysis operation database
System, to realize the combing to database.But because join sentences can only operate to a database, can not carry out across
The operation of database, therefore, the relation between the tables of data of a database can only obtain by the analysis to join sentences, and
The relation between the tables of data of all databases corresponding to operation system can not be obtained, it follows that correlation technique can not be realized
Combing to the relation between the tables of data of all databases of operation system.
The content of the invention
The purpose of the embodiment of the present application is to provide a kind of generation method of data relationship model, device and equipment, to reality
Now to the combing of the relation between the tables of data of all databases of operation system.
In order to solve the above technical problems, what the embodiment of the present application was realized in：
The embodiment of the present application provides a kind of generation method of data relationship model, and methods described includes：
The operation information of built-in function is carried out according to each database to operation system respectively, generates the operation system
Each database the first relational model；Wherein, the first relational model of the database is used to represent in the database
Tables of data between incidence relation；
The operation information of integration across database operation, and each data are carried out according to each database to operation system
First relational model in storehouse, generate the second relational model of multiple databases of the operation system；Wherein, second relation
Model is used to represent the incidence relation between the tables of data in multiple databases of the operation system.
The embodiment of the present application provides a kind of generating means of data relationship model, and described device includes：
First generation module, the operation for carrying out built-in function according to each database to operation system respectively are believed
Breath, generate the first relational model of each database of the operation system；Wherein, the first relational model of the database is used
Incidence relation between the tables of data in the database is represented；
Second generation module, the operation for carrying out integration across database operation according to each database to operation system are believed
Breath, and the first relational model of each database, generate the second relation mould of multiple databases of the operation system
Type；Wherein, second relational model is used to represent the association between the tables of data in multiple databases of the operation system
Relation.
The embodiment of the present application provides a kind of generation equipment of data relationship model, it is described including：
Processor；And
It is arranged to store the memory of computer executable instructions, the executable instruction makes the place when executed
Manage device：
The operation information of built-in function is carried out according to each database to operation system respectively, generates the operation system
Each database the first relational model；Wherein, the first relational model of the database is used to represent in the database
Tables of data between incidence relation；
The operation information of integration across database operation, and each data are carried out according to each database to operation system
First relational model in storehouse, generate the second relational model of multiple databases of the operation system；Wherein, second relation
Model is used to represent the incidence relation between the tables of data in multiple databases of the operation system.
The technical scheme provided from above the embodiment of the present application, the embodiment of the present application can be respectively according to business systems
Each database of system carries out the operation information of built-in function, generates the first relational model of each database of operation system,
Wherein, the first relational model of database can be used to indicate that the incidence relation between the tables of data in database, it is then possible to
The operation information of integration across database operation, and the first relation of each database are carried out according to each database to operation system
Model, the second relational model of multiple databases of operation system is generated, wherein, the second relational model can be used to indicate that business
The incidence relation between tables of data in multiple databases of system.
In the embodiment of the present application, the association between the tables of data of each data store internal of operation system can first be determined
Relation, it is then possible between the operation information based on operation system integration across database, and the tables of data of each data store internal
Incidence relation, to generate the incidence relation between the tables of data of multiple databases of operation system.Due to being implemented by the application
Example can determine the relation between the tables of data of all databases of operation system, it is thereby achieved that the institute to operation system
There is the combing of the relation between the tables of data of database.
Brief description of the drawings
, below will be to embodiment or existing in order to illustrate more clearly of the embodiment of the present application or technical scheme of the prior art
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments described in application, for those of ordinary skill in the art, do not paying the premise of creative labor
Under, other accompanying drawings can also be obtained according to these accompanying drawings.
Fig. 1 is a kind of embodiment of the generation method of data relationship model of the application；
Fig. 2 is a kind of schematic diagram of first relational model shown in the application；
Fig. 3 is the schematic diagram of the relational model of another kind first shown in the application；
Fig. 4 is a kind of schematic diagram of second relational model shown in the application；
Fig. 5 is the embodiment of the generation method of the application another kind data relationship model；
Fig. 6 is a kind of embodiment of the generating means of data relationship model of the application；
Fig. 7 is the embodiment of the generating means of the application another kind data relationship model；
Fig. 8 is a kind of embodiment of the generation equipment of data relationship model of the application.
Embodiment
The embodiment of the present application provides a kind of generation method of data relationship model, device and equipment.
In order that those skilled in the art more fully understand the technical scheme in the application, it is real below in conjunction with the application
The accompanying drawing in example is applied, the technical scheme in the embodiment of the present application is clearly and completely described, it is clear that described implementation
Example only some embodiments of the present application, rather than whole embodiments.It is common based on the embodiment in the application, this area
The every other embodiment that technical staff is obtained under the premise of creative work is not made, it should all belong to the application protection
Scope.
Embodiment one
As shown in figure 1, the application provides a kind of embodiment of the generation method of data relationship model, to realize to business
The combing of relation between the tables of data of all databases of system.The application can pass through each database to operation system
The operation information of integration across database operation, and the first relational model of each database of operation system are carried out to obtain business system
Second relational model of multiple databases of system, so as to be realized based on the second obtained relational model to operation system
The combing of relation between the tables of data of all databases.This method specifically includes following steps：
In step S101：The operation information of built-in function is carried out according to each database to operation system respectively, it is raw
Into the first relational model of each database of operation system；Wherein, the first relational model of database is used to represent database
In tables of data between incidence relation.
In the present embodiment, above-mentioned database can include relational database, and in addition to relational database, above-mentioned database can
To include or not include other kinds of database, the present embodiment is without limitation.
In one embodiment, aforesaid operations information can be the content of operational order, then can be respectively according to business
Each database of system carries out the content of the operational order of built-in function, to generate the first of each database of operation system
Relational model.Wherein, the operational order of each database progress built-in function to operation system can include SQL
(Structured Query Language, SQL) instructs, and in addition to SQL is instructed, the operation of above-mentioned database refers to
Order can include or not include other kinds of instruction, and the present embodiment is without limitation.
In the present embodiment, the first relational model can be E-R (Entity Relationship Diagram, entity-
Contact) figure, or image, form etc., the present embodiment is without limitation.
In one example, database Q can be the database of operation system, wherein, database Q can be to include student
The database of essential information, specifically, database Q can include table 1, table 2 and table 3：
Table 1
| Student number | Name | Sex | Age |
| … | … | … | … |
| 20170010 | Zhang San | Female | 18 |
| 20170040 | Li Si | Man | 19 |
| … | … | … | … |
Table 2
| Name | Whether elective A | Whether elective B | Whether elective C |
| … | … | … | … |
| Zhang San | It is | It is | It is no |
| Li Si | It is | It is no | It is |
| … | … | … | … |
Table 3
| Name | Whether elective A | Whether elective B | Whether elective C |
| … | … | … | … |
| Li Gang | It is | It is | It is no |
| Shi Lei | It is | It is | It is no |
| … | … | … | … |
In one example, the operation information operated to database Q can include：In table 1, when in student number item
Hold for " 20170010 " when, the content of name item corresponding to acquisition, and in table 2, when the content of name item from table 1 with obtaining
When the content of the name item taken is identical, obtain corresponding to whether the content of elective A items.As shown in Table 1, when in student number item
Hold for " 20170010 " when, the content of corresponding name item can be " Zhang San ", as shown in Table 2, when the name obtained from table 1
When the content of item is " Zhang San ", this is corresponding, and whether the content of elective A items is yes.
It is relevant between table 1 and table 2 from the above-mentioned operation information operated to database Q, table 1 and table 3
Between, and there is no incidence relation between table 2 and table 3.At this point it is possible to generate database Q the first relational model.With table 1
Entitled " the curricula-variable Basic Information Tables of one class of natural sciences ", the entitled " natural sciences of table 3 of entitled " student's Basic Information Table ", table 2
Exemplified by two classes of curricula-variable Basic Information Table ", if the first relational model is schemed for E-R, the first relation as shown in Figure 2 can be obtained
Model.
It should be noted that in order to improve performance, in production environment, during much being operated to database, all
It is rarely employed or without using join sentences, but logical process is done in internal memory, is associated operation.Therefore, in correlation technique
In, the relation between the tables of data drawn by the analysis to join sentences is very limited, the tables of data drawn based on this it
Between relation obtain relational model be also very limited.
And in the present embodiment, the operation that can carry out built-in function according to each database to operation system respectively is believed
Breath, to generate the first relational model between the tables of data in each database of operation system, due to the data in database
When table is operated or be called, corresponding operation information can be produced, therefore, according to each database progress to operation system
The operation information of built-in function, the relation between the tables of data in each database of operation system can be preferably drawn, with
And the relational model between each tables of data corresponding to preferably obtaining.
In step s 102：The operation information of integration across database operation is carried out according to each database to operation system, with
And the first relational model of each database, generate the second relational model of multiple databases of operation system；Wherein, second close
It is the incidence relation that model is used to represent between the tables of data in multiple databases of operation system.
In the present embodiment, the operation information of each database progress integration across database operation to operation system can be bag
Corresponding operation information when being operated to each database of operation system is included, can be directly to operation system specifically
Each database corresponding operation information when being operated, for example, corresponding behaviour when can be artificial directly inquiry database
Make corresponding operation information when information or system access database, wherein, corresponding operation information can when system accesses database
Corresponding operation letter during corresponding operation information and system dereference database during being directly accessed the database including system
Breath, the present embodiment are without limitation.
In the present embodiment, the operation information of each database progress integration across database operation to operation system can also wrap
Include corresponding operation information when operation system calls the tables of data in each database in real-time calculating or off-line calculation.
In one embodiment, each database of above-mentioned operation system carry out the operation information of integration across database operation can be with
Each database including operation system carries out the content of the operational order of integration across database operation.
In the present embodiment, the second relational model can be E-R (Entity Relationship Diagram, entity-
Contact) figure, or image, form etc., the present embodiment is without limitation.
In the present embodiment, the operation that integration across database operation can be carried out according to each database to operation system is believed
Breath, and the first relational model of each database, generate the second relational model of multiple databases of operation system.
Specifically, the operation information of integration across database operation can be first carried out according to each database to operation system, is come
The relation between the tables of data of integration across database in multiple databases of operation system is determined, then, further according to the number of integration across database
The more of operation system are generated according to the relation between the tables of data in the relation between table, and each database of operation system
Second relational model of individual database.
In one example, the database Q in above-mentioned example and database W can be the database of operation system, its
In, database W can include table 4, table 5 and table 6：
Table 4
| Student number | Name | Course A achievement |
| … | … | … |
| 20170110 | Li Gang | 82 |
| 20170140 | Shi Lei | 80 |
| … | … | … |
Table 5
| Student number | Name | Course A achievement |
| … | … | … |
| 20170010 | Zhang San | 92 |
| 20170040 | Li Si | 95 |
| … | … | … |
Table 6
| Student number | Total score |
| … | … |
| 20170010 | 570 |
| 20170410 | 585 |
| … | … |
Wherein, database W can be the database for including student result data, in this example, can first determine data
The relation between tables of data inside the W of storehouse, and generation database W the first relational model：
In this example, the operation information of built-in function is carried out to database W to be included：In table 5, when name item
When content is " Zhang San ", the content of student number item corresponding to acquisition, and in table 6, when the content of student number item from table 5 with obtaining
Student number item content it is identical when, the content always itemized corresponding to acquisition.As shown in Table 5, when the content of name item is " Zhang San "
When, the content of corresponding student number item can be " 20170010 ", as shown in Table 6, when the content of the student number item obtained from table 5 is
When " 20170010 ", the corresponding content always itemized is 570.
It is relevant between table 5 and table 6 from the above-mentioned operation information operated to database W, table 5 and table 4
Between, and there is no incidence relation between table 6 and table 4.At this point it is possible to generate database W the first relational model.With table 4
Entitled " one class of course A of the natural sciences list of results " of entitled " two classes of course A of natural sciences list of results ", table 5, table 6 it is entitled
Exemplified by " the total score tables of one class of natural sciences ", if the first relational model is schemed for E-R, the first relation mould as shown in Figure 3 can be obtained
Type.
In this example, the operation information of each database progress integration across database operation to operation system can include：
The content that have accessed in the tables of data 2 in database Q is the name item of " Zhang San ", and have accessed the tables of data 5 in database W
In content be " 20170010 " student number item.
From the operation information, relevant pass between the tables of data 5 in tables of data 2 and database W in database Q
System.Because the tables of data 2 in database Q is relevant with tables of data 1, the tables of data 5 in database W is relevant with tables of data 6
Connection relation, therefore, it can be deduced that tables of data 2, tables of data 1 in database Q and the tables of data 5 in database W, tables of data 6 it
Between it is relevant.At this point it is possible to the database Q and database W of operation system the second relational model are generated, if the second relation
Model is schemed for E-R, then can obtain the second relational model as shown in Figure 4.
In the present embodiment, the relational model between the tables of data of all databases of operation system can be generated.When need
, can be based on all databases of generation when relation between the tables of data of database that will be all to this combs
Relational model between tables of data is realized.
The application provides a kind of embodiment of the generation method of data relationship model, in the present embodiment, can distinguish root
The operation information of built-in function is carried out according to each database to operation system, generates the first of each database of operation system
Relational model, wherein, the first relational model of database can be used to indicate that the incidence relation between the tables of data in database,
It is then possible to the operation information of integration across database operation is carried out according to each database to operation system, and each database
The first relational model, generate the second relational model of multiple databases of operation system, wherein, the second relational model can be used
The incidence relation between tables of data in the multiple databases for representing operation system.
In the present embodiment, it can first determine that the association between the tables of data of each data store internal of operation system is closed
System, it is then possible to the pass between the operation information based on operation system integration across database, and the tables of data of each data store internal
Connection relation, to generate the incidence relation between the tables of data of multiple databases of operation system.Due to passing through the embodiment of the present application
The relation between the tables of data of all databases of operation system can be determined, it is thereby achieved that owning to operation system
The combing of relation between the tables of data of database.
Embodiment two
As shown in figure 5, the application provides the embodiment of the generation method of another data relationship model, to realize to industry
The combing of relation between the tables of data of all databases of business system.The application can be grasped by the integration across database of operation system
The journal file of the operation information generation of work, and the first relational model of each database of operation system obtain business system
Second relational model of multiple databases of system, so as to be realized pair and operation system based on the second obtained relational model
All databases tables of data between relation combing.This method specifically includes following steps：
In step S501：The operation information of built-in function is carried out according to each database to operation system respectively, it is raw
Into the first journal file corresponding to each database of operation system.
In the present embodiment, above-mentioned first journal file can call data including operation system in real-time calculating process
Day caused by the tables of data in database is called during journal file, and off-line calculation caused by tables of data in storehouse
Will file.
In the present embodiment, if the first journal file includes producing when calling the tables of data in database in real-time calculating process
Raw journal file, then during first journal file is produced, spark, strom or other calculating can be preserved in real time
The relation between tables of data in system, and two or more tables of data are carried out with join operations, and complete join operations
After carry out logical process, after completing logical process, store in hbase.
In the present embodiment, if being produced the first journal file is including calling the tables of data in database during off-line calculation when
Raw journal file, then during first journal file is produced, off-line calculation task can be analyzed, for example, ODPS
(Extract-Transform-Load, number in (Open Data Processing Service, open data processing service)
According to REPOSITORY TECHNOLOGY) task daily record, to draw the upstream-downstream relationship in database between tables of data, and the list item in tables of data
Between upstream-downstream relationship.
In one example, the database of operation system can include tables of data chart1, and tables of data chart2, with
Caused first journal file is exemplified by join files, then caused first journal file can include herein below：
From the content, the operation information of built-in function is carried out to the database to be included：When meeting dt=' $
During the condition on { bizdate (business date) } ', list item a, list item b, list item c are chosen from tables of data chart1, and will include
List item a, list item b, list item c structure are named as A；List item d, list item e, list item f are chosen from tables of data chart2, and will bag
D containing list item, list item e, list item f structure are named as B, then so that structure A list item a and structure B list item d are equal.
In the present embodiment, if the first journal file includes the daily record text of the tables of data of other layers beyond basal layer
Part, then the target matrix of basal layer from the first journal file, according to the journal file of the tables of data of other layers, can be obtained
Journal file, wherein, incidence relation be present between target matrix and the tables of data of other layers.
In one example, operation system can (Operational Data Store, manipulation type data be deposited including ODS
Storage) layer, EDW (Enterprise Data Warehouse, global data warehouse) layers and ADM (Application Data
Mart, application data fairground) layer, wherein, ODS layers can layer, EDW layers can be able to be application for intermediate layer, ADM layers based on
Layer, EDW layers can also include DWD (Data Warehouse Detail, detail data) layer.
When the first journal file includes the journal file of the tables of data of other layers beyond basal layer, it may for example comprise
ADM layers, DWD layers tables of data journal file when, can be from the first journal file, according to the tables of data of ADM layers, DWD layers
Journal file, obtain the journal file of ODS layers, wherein, deposited between the tables of data and ADM layers of ODS layers, the tables of data of DWD layers
In incidence relation.
In one example, tables of data adm can be ADM layers tables of data, tables of data dwd can with the tables of data of DWD layers,
Tables of data ods_1, tables of data ods_2 and tables of data ods_3 can be the tables of data of ODS layers, wherein, ODS layers are to be
Basal layer.So that caused first journal file is join files as an example, then caused first journal file can include following
Content：
From first SQL statement of the journal file, the operation information that built-in function is carried out to the database can be with
Including：When meeting dt=' { bizdate (business date) } ' condition, chosen from tables of data ods_1 list item a, list item b,
List item c, and the structure comprising list item a, list item b, list item c is named as A；List item d, list item are chosen from tables of data ods_2
E, list item f, and the structure comprising list item d, list item e, list item f is named as B, then so that structure A list item a and structure B
List item d it is equal.
From the Article 2 SQL statement of the journal file, the operation information that built-in function is carried out to the database can be with
Including：When meeting dt=' { bizdate (business date) } ' condition, list item a, list item b, table are chosen from tables of data dwd
C, list item e, list item f and the structure comprising list item a, list item b, list item c, list item e, list item f is named as A；From tables of data
List item h, list item g are chosen in ods_3, and the structure comprising list item h, list item g is named as B, then so that structure A table
Item b is equal with structure B list item h.
In step S502：The first journal file according to corresponding to each database of operation system, generate operation system
Each database the first relational model.
In one embodiment shown in the application, if the first journal file is included as shown in the example in step S201
First journal file, then it can determine relevant between the list item b in the list item a and tables of data chart2 in tables of data chart1
Connection relation, at this point it is possible to generate the first relational model of a database comprising tables of data chart1 and tables of data chart2.
If the first journal file includes second journal file as shown in the example in step S201, can be by this
First SQL statement of journal file, can obtain ods_1.a list items and ods_2.d list items are relevant, and dwd.b's is upper
Trip list item is ods_1.b；By Article 2 SQL statement, dwd.b list items can be obtained and ods_3.h list items are relevant.
With reference to two SQL statements, it can be deduced that ods_1.a list items and ods_2.d list items, ods_1.b list items and ods_
3.h list items are relevant.At this point it is possible to generating one includes tables of data ods_1, tables of data ods_2 and tables of data ods_3
Database the first relational model.
It should be noted that in ODPS, the tables of data of ODS layers and the tables of data of production environment be it is one-to-one,
After obtaining the relation between the tables of data of ODS layers, the relation between the tables of data of corresponding production environment can be obtained.
In step S503：The operation information of integration across database operation is carried out according to each database to operation system, it is raw
Into the second journal file corresponding to multiple databases of operation system.
In the present embodiment, the operation entry that can be operated in operation system integration across database buries a little, when going to business system
During the operation entry of system integration across database operation, corresponding second journal file can be automatically generated.
In one example, can be buried a little in the dao of the operation system entrances operated, as the dao for going to operation system
During the entrance of operation, the second journal file corresponding with dao operations can be automatically generated.
In step S504：The second journal file according to corresponding to multiple databases of operation system, and each data
First relational model in storehouse, generate the second relational model of multiple databases of associated services system.
The application provides the embodiment of the generation method of another data relationship model, in the present embodiment, can distinguish
The operation information of built-in function is carried out according to each database to operation system, each database for generating operation system is corresponding
The first journal file, and the first journal file according to corresponding to each database of operation system generates operation system
First relational model of each database, it is then possible to carry out integration across database operation according to each database to operation system
Operation information, generate the second journal file corresponding to multiple databases of operation system, and according to the multiple of operation system
Second journal file corresponding to database, and the first relational model of each database, generate the multiple of associated services system
Second relational model of database.
In the present embodiment, it can first determine that the association between the tables of data of each data store internal of operation system is closed
System, it is then possible to the pass between the operation information based on operation system integration across database, and the tables of data of each data store internal
Connection relation, to generate the incidence relation between the tables of data of multiple databases of operation system.Due to passing through the embodiment of the present application
The relation between the tables of data of all databases of operation system can be determined, it is thereby achieved that owning to operation system
The combing of relation between the tables of data of database.
Embodiment three
The generation method of the data relationship model provided above for the embodiment of the present application, based on same thinking, the application
Embodiment also provides a kind of embodiment of the generating means of data relationship model, as shown in Figure 6：
The generating means of the data relationship model include：First generation module 610 and the second generation module 620, its
In：
First generation module 610, for carrying out the operation of built-in function according to each database to operation system respectively
Information, generate the first relational model of each database of the operation system；Wherein, the first relational model of the database
For representing the incidence relation between the tables of data in the database；
Second generation module 620, for carrying out the operation of integration across database operation according to each database to operation system
Information, and the first relational model of each database, generate the second relation of multiple databases of the operation system
Model；Wherein, second relational model is used to represent the pass between the tables of data in multiple databases of the operation system
Connection relation.
In the embodiment of the present application, first generation module 610 can include (as shown in Figure 7)：
First generation submodule 611, for carrying out the behaviour of built-in function according to each database to operation system respectively
Make information, generate the first journal file corresponding to each database of the operation system；
Second generation submodule 612, for the first journal file corresponding to each database according to the operation system,
Generate the first relational model of each database of the operation system.
In the embodiment of the present application, second generation module 620 can be used for：
The operation information of integration across database operation is carried out according to each database to operation system, generates the operation system
Multiple databases corresponding to the second journal file；
The second journal file according to corresponding to multiple databases of the operation system, and the of each database
One relational model, generation associate the second relational model of multiple databases of the operation system.
In the embodiment of the present application, the secondth generation submodule 612 can be used for：
If first journal file includes the journal file of the tables of data of other layers beyond basal layer, from described
In first journal file, according to the journal file of the tables of data of other described layers, the daily record of the target matrix of basal layer is obtained
File, wherein, incidence relation be present between the tables of data of the target matrix and other described layers；
According to the journal file of the target matrix, the first relation mould of each database of the operation system is generated
Type.
In the embodiment of the present application, each database to operation system carries out the operation information of integration across database operation
Corresponding first operation information during including being operated to each database, and call the number in each database
The second corresponding operation information during according to table.
The application provides a kind of embodiment of the generating means of data relationship model, in the present embodiment, can distinguish root
The operation information of built-in function is carried out according to each database to operation system, generates the first of each database of operation system
Relational model, wherein, the first relational model of database can be used to indicate that the incidence relation between the tables of data in database,
It is then possible to the operation information of integration across database operation is carried out according to each database to operation system, and each database
The first relational model, generate the second relational model of multiple databases of operation system, wherein, the second relational model can be used
The incidence relation between tables of data in the multiple databases for representing operation system.
In the present embodiment, it can first determine that the association between the tables of data of each data store internal of operation system is closed
System, it is then possible to the pass between the operation information based on operation system integration across database, and the tables of data of each data store internal
Connection relation, to generate the incidence relation between the tables of data of multiple databases of operation system.Due to passing through the embodiment of the present application
The relation between the tables of data of all databases of operation system can be determined, it is thereby achieved that owning to operation system
The combing of relation between the tables of data of database.
Example IV
Based on same thinking, the embodiment of the present application also provides a kind of generation equipment of data relationship model, such as Fig. 8 institutes
Show.
The generation equipment of the data relationship model can be above-described embodiment offer for generating data relationship model
Terminal device or server etc..
The generation equipment of data relationship model can produce bigger difference because configuration or performance are different, can include one
Individual or more than one processor 801 and memory 802, one or more storages can be stored with memory 802 should
With program or data.Wherein, memory 802 can be of short duration storage or persistently storage.It is stored in the application program of memory 802
One or more modules (diagram is not shown) can be included, the generation that each module can include to data relationship model is set
Series of computation machine executable instruction in standby.Further, processor 801 could be arranged to communicate with memory 802,
The series of computation machine executable instruction in memory 802 is performed in the generation equipment of data relationship model.Data relationship model
Generation equipment can also include one or more power supplys 803, one or more wired or wireless network interfaces
804, one or more input/output interfaces 805, one or more keyboards 806.
Specifically in the present embodiment, the generation equipment of data relationship model includes memory, and one or one with
On program, one of them or more than one program storage is in memory, and one or more than one program can wrap
One or more modules are included, and each module can include the series of computation in the generation equipment to data relationship model
Machine executable instruction, and it is configured to that either more than one computing device this or more than one program bag contain by one
For carrying out following computer executable instructions：
The operation information of built-in function is carried out according to each database to operation system respectively, generates the operation system
Each database the first relational model；Wherein, the first relational model of the database is used to represent in the database
Tables of data between incidence relation；
The operation information of integration across database operation, and each data are carried out according to each database to operation system
First relational model in storehouse, generate the second relational model of multiple databases of the operation system；Wherein, second relation
Model is used to represent the incidence relation between the tables of data in multiple databases of the operation system.
Alternatively, computer executable instructions when executed, can also make the processor：
The operation information of built-in function is carried out according to each database to operation system respectively, generates the operation system
Each database corresponding to the first journal file；
The first journal file according to corresponding to each database of the operation system, generates each of the operation system
First relational model of database.
Alternatively, computer executable instructions when executed, can also make the processor：
The operation information of integration across database operation is carried out according to each database to operation system, generates the operation system
Multiple databases corresponding to the second journal file；
The second journal file according to corresponding to multiple databases of the operation system, and the of each database
One relational model, generation associate the second relational model of multiple databases of the operation system.
Optionally, computer executable instructions when executed, can also make the processor：
If first journal file includes the journal file of the tables of data of other layers beyond basal layer, from described
In first journal file, according to the journal file of the tables of data of other described layers, the daily record of the target matrix of basal layer is obtained
File, wherein, incidence relation be present between the tables of data of the target matrix and other described layers；
According to the journal file of the target matrix, the first relation mould of each database of the operation system is generated
Type.
Optionally, each database to operation system carries out the operation information of integration across database operation including to each
The database corresponding first operation information when being operated, and call the when institute of the tables of data in each database right
The second operation information answered.
The application provides a kind of embodiment of the generation equipment of data relationship model, in the present embodiment, can distinguish root
The operation information of built-in function is carried out according to each database to operation system, generates the first of each database of operation system
Relational model, wherein, the first relational model of database can be used to indicate that the incidence relation between the tables of data in database,
It is then possible to the operation information of integration across database operation is carried out according to each database to operation system, and each database
The first relational model, generate the second relational model of multiple databases of operation system, wherein, the second relational model can be used
The incidence relation between tables of data in the multiple databases for representing operation system.
In the present embodiment, it can first determine that the association between the tables of data of each data store internal of operation system is closed
System, it is then possible to the pass between the operation information based on operation system integration across database, and the tables of data of each data store internal
Connection relation, to generate the incidence relation between the tables of data of multiple databases of operation system.Due to passing through the embodiment of the present application
The relation between the tables of data of all databases of operation system can be determined, it is thereby achieved that owning to operation system
The combing of relation between the tables of data of database.
In the 1990s, the improvement for a technology can clearly distinguish be on hardware improvement (for example,
Improvement to circuit structures such as diode, transistor, switches) or software on improvement (improvement for method flow).So
And as the development of technology, the improvement of current many method flows can be considered as directly improving for hardware circuit.
Designer nearly all obtains corresponding hardware circuit by the way that improved method flow is programmed into hardware circuit.Cause
This, it cannot be said that the improvement of a method flow cannot be realized with hardware entities module.For example, PLD
(Programmable Logic Device, PLD) (such as field programmable gate array (Field Programmable Gate
Array, FPGA)) it is exactly such a integrated circuit, its logic function is determined by user to device programming.By designer
Voluntarily programming comes a digital display circuit " integrated " on a piece of PLD, without asking chip maker to design and make
Special IC chip.Moreover, nowadays, substitution manually makes IC chip, this programming is also used instead mostly " patrols
Volume compiler (logic compiler) " software realizes that software compiler used is similar when it writes with program development,
And the source code before compiling also write by handy specific programming language, this is referred to as hardware description language
(Hardware Description Language, HDL), and HDL is also not only a kind of, but have many kinds, such as ABEL
(Advanced Boolean Expression Language)、AHDL(Altera Hardware Description
Language)、Confluence、CUPL(Cornell University Programming Language)、HDCal、JHDL
(Java Hardware Description Language)、Lava、Lola、MyHDL、PALASM、RHDL(Ruby
Hardware Description Language) etc., VHDL (Very-High-Speed are most generally used at present
Integrated Circuit Hardware Description Language) and Verilog.Those skilled in the art also should
This understands, it is only necessary to method flow slightly programming in logic and is programmed into integrated circuit with above-mentioned several hardware description languages,
Can is readily available the hardware circuit for realizing the logical method flow.
Controller can be implemented in any suitable manner, for example, controller can take such as microprocessor or processing
Device and storage can by the computer of the computer readable program code (such as software or firmware) of (micro-) computing device
Read medium, gate, switch, application specific integrated circuit (Application Specific Integrated Circuit,
ASIC), the form of programmable logic controller (PLC) and embedded microcontroller, the example of controller include but is not limited to following microcontroller
Device：ARC 625D, Atmel AT91SAM, Microchip PIC18F26K20 and Silicone Labs C8051F320, are deposited
Memory controller is also implemented as a part for the control logic of memory.It is also known in the art that except with
Pure computer readable program code mode realized beyond controller, completely can be by the way that method and step is carried out into programming in logic to make
Controller is obtained in the form of gate, switch, application specific integrated circuit, programmable logic controller (PLC) and embedded microcontroller etc. to come in fact
Existing identical function.Therefore this controller is considered a kind of hardware component, and various for realizing to including in it
The device of function can also be considered as the structure in hardware component.Or even, can be by for realizing that the device of various functions regards
For that not only can be the software module of implementation method but also can be the structure in hardware component.
System, device, module or the unit that above-described embodiment illustrates, it can specifically be realized by computer chip or entity,
Or realized by the product with certain function.One kind typically realizes that equipment is computer.Specifically, computer for example may be used
Think personal computer, laptop computer, cell phone, camera phone, smart phone, personal digital assistant, media play
It is any in device, navigation equipment, electronic mail equipment, game console, tablet PC, wearable device or these equipment
The combination of equipment.
For convenience of description, it is divided into various units during description apparatus above with function to describe respectively.Certainly, this is being implemented
The function of each unit can be realized in same or multiple softwares and/or hardware during application.
It should be understood by those skilled in the art that, embodiments herein can be provided as method, system or computer program
Product.Therefore, the application can use the reality in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Apply the form of example.Moreover, the application can use the computer for wherein including computer usable program code in one or more
The computer program production that usable storage medium is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
The form of product.
The application is with reference to the flow according to the method for the embodiment of the present application, equipment (system) and computer program product
Figure and/or block diagram describe.It should be understood that can be by every first-class in computer program instructions implementation process figure and/or block diagram
Journey and/or the flow in square frame and flow chart and/or block diagram and/or the combination of square frame.These computer programs can be provided
The processors of all-purpose computer, special-purpose computer, Embedded Processor or other programmable data processing devices is instructed to produce
A raw machine so that produced by the instruction of computer or the computing device of other programmable data processing devices for real
The device for the function of being specified in present one flow of flow chart or one square frame of multiple flows and/or block diagram or multiple square frames.
These computer program instructions, which may be alternatively stored in, can guide computer or other programmable data processing devices with spy
Determine in the computer-readable memory that mode works so that the instruction being stored in the computer-readable memory, which produces, to be included referring to
Make the manufacture of device, the command device realize in one flow of flow chart or multiple flows and/or one square frame of block diagram or
The function of being specified in multiple square frames.
These computer program instructions can be also loaded into computer or other programmable data processing devices so that counted
Series of operation steps is performed on calculation machine or other programmable devices to produce computer implemented processing, so as in computer or
The instruction performed on other programmable devices is provided for realizing in one flow of flow chart or multiple flows and/or block diagram one
The step of function of being specified in individual square frame or multiple square frames.
In a typical configuration, computing device includes one or more processors (CPU), input/output interface, net
Network interface and internal memory.
Internal memory may include computer-readable medium in volatile memory, random access memory (RAM) and/or
The forms such as Nonvolatile memory, such as read-only storage (ROM) or flash memory (flash RAM).Internal memory is computer-readable medium
Example.
Computer-readable medium includes permanent and non-permanent, removable and non-removable media can be by any method
Or technology come realize information store.Information can be computer-readable instruction, data structure, the module of program or other data.
The example of the storage medium of computer includes, but are not limited to phase transition internal memory (PRAM), static RAM (SRAM), moved
State random access memory (DRAM), other kinds of random access memory (RAM), read-only storage (ROM), electric erasable
Programmable read only memory (EEPROM), fast flash memory bank or other memory techniques, read-only optical disc read-only storage (CD-ROM),
Digital versatile disc (DVD) or other optical storages, magnetic cassette tape, the storage of tape magnetic rigid disk or other magnetic storage apparatus
Or any other non-transmission medium, the information that can be accessed by a computing device available for storage.Define, calculate according to herein
Machine computer-readable recording medium does not include temporary computer readable media (transitory media), such as data-signal and carrier wave of modulation.
It should also be noted that, term " comprising ", "comprising" or its any other variant are intended to nonexcludability
Comprising so that process, method, commodity or equipment including a series of elements not only include those key elements, but also wrapping
Include the other element being not expressly set out, or also include for this process, method, commodity or equipment intrinsic want
Element.In the absence of more restrictions, the key element limited by sentence "including a ...", it is not excluded that wanted including described
Other identical element also be present in the process of element, method, commodity or equipment.
It will be understood by those skilled in the art that embodiments herein can be provided as method, system or computer program product.
Therefore, the application can be using the embodiment in terms of complete hardware embodiment, complete software embodiment or combination software and hardware
Form.Deposited moreover, the application can use to can use in one or more computers for wherein including computer usable program code
The shape for the computer program product that storage media is implemented on (including but is not limited to magnetic disk storage, CD-ROM, optical memory etc.)
Formula.
The application can be described in the general context of computer executable instructions, such as program
Module.Usually, program module includes performing particular task or realizes routine, program, object, the group of particular abstract data type
Part, data structure etc..The application can also be put into practice in a distributed computing environment, in these DCEs, by
Task is performed and connected remote processing devices by communication network.In a distributed computing environment, program module can be with
In the local and remote computer-readable storage medium including storage device.
Each embodiment in this specification is described by the way of progressive, identical similar portion between each embodiment
Divide mutually referring to what each embodiment stressed is the difference with other embodiment.It is real especially for system
For applying example, because it is substantially similar to embodiment of the method, so description is fairly simple, related part is referring to embodiment of the method
Part explanation.
Embodiments herein is the foregoing is only, is not limited to the application.For those skilled in the art
For, the application can have various modifications and variations.All any modifications made within spirit herein and principle, it is equal
Replace, improve etc., it should be included within the scope of claims hereof.
Claims (11)
1. a kind of generation method of data relationship model, it is characterised in that methods described includes：
The operation information of built-in function is carried out according to each database to operation system respectively, generates each of the operation system
First relational model of individual database；Wherein, the first relational model of the database is used to represent the number in the database
According to the incidence relation between table；
According to the operation information that integration across database operation is carried out to each database of operation system, and each database
First relational model, generate the second relational model of multiple databases of the operation system；Wherein, second relational model
The incidence relation between the tables of data in multiple databases for representing the operation system.
2. according to the method for claim 1, it is characterised in that described to be entered respectively according to each database to operation system
The operation information of row built-in function, the first relational model of each database of the operation system is generated, including：
The operation information of built-in function is carried out according to each database to operation system respectively, generates each of the operation system
First journal file corresponding to individual database；
The first journal file according to corresponding to each database of the operation system, generate each data of the operation system
First relational model in storehouse.
3. according to the method for claim 1, it is characterised in that the basis each database of operation system is carried out across
The operation information of database manipulation, and the first relational model of each database, generation associate the operation system
Second relational model of multiple databases, including：
The operation information of integration across database operation is carried out according to each database to operation system, generates the more of the operation system
Second journal file corresponding to individual database；
The second journal file according to corresponding to multiple databases of the operation system, and the first pass of each database
It is model, generation associates the second relational model of multiple databases of the operation system.
4. according to the method for claim 2, it is characterised in that described corresponding according to each database of the operation system
The first journal file, generate the first relational model of each database of the operation system, including：
If first journal file includes the journal file of the tables of data of other layers beyond basal layer, from described first
In journal file, according to the journal file of the tables of data of other described layers, the journal file of the target matrix of basal layer is obtained,
Wherein, incidence relation be present between the tables of data of the target matrix and other described layers；
According to the journal file of the target matrix, the first relational model of each database of the operation system is generated.
5. method according to any one of claims 1 to 4, it is characterised in that each database to operation system enters
Corresponding first operation information when the operation information of row integration across database operation includes operating each database, and
The second corresponding operation information when calling the tables of data in each database.
6. a kind of generating means of data relationship model, it is characterised in that described device includes：
First generation module, it is raw for carrying out the operation information of built-in function according to each database to operation system respectively
Into the first relational model of each database of the operation system；Wherein, the first relational model of the database is used for table
Show the incidence relation between the tables of data in the database；
Second generation module, for carrying out the operation information of integration across database operation according to each database to operation system, with
And the first relational model of each database, generate the second relational model of multiple databases of the operation system；Its
In, second relational model is used to represent the incidence relation between the tables of data in multiple databases of the operation system.
7. device according to claim 6, it is characterised in that first generation module includes：
First generation submodule, for the operation information of built-in function to be carried out according to each database to operation system respectively,
Generate the first journal file corresponding to each database of the operation system；
Second generation submodule, for the first journal file corresponding to each database according to the operation system, generates institute
State the first relational model of each database of operation system.
8. device according to claim 6, it is characterised in that second generation module is used for：
The operation information of integration across database operation is carried out according to each database to operation system, generates the more of the operation system
Second journal file corresponding to individual database；
The second journal file according to corresponding to multiple databases of the operation system, and the first pass of each database
It is model, generation associates the second relational model of multiple databases of the operation system.
9. device according to claim 7, it is characterised in that the second generation submodule is used for：
If first journal file includes the journal file of the tables of data of other layers beyond basal layer, from described first
In journal file, according to the journal file of the tables of data of other described layers, the journal file of the target matrix of basal layer is obtained,
Wherein, incidence relation be present between the tables of data of the target matrix and other described layers；
According to the journal file of the target matrix, the first relational model of each database of the operation system is generated.
10. according to any described device of claim 6 to 9, it is characterised in that each database to operation system enters
Corresponding first operation information when the operation information of row integration across database operation includes operating each database, and
The second corresponding operation information when calling the tables of data in each database.
11. the generation equipment of a kind of data relationship model, it is characterised in that the generation equipment of the data relationship model includes：
Processor；And
It is arranged to store the memory of computer executable instructions, the executable instruction makes the processing when executed
Device：
The operation information of built-in function is carried out according to each database to operation system respectively, generates each of the operation system
First relational model of individual database；Wherein, the first relational model of the database is used to represent the number in the database
According to the incidence relation between table；
According to the operation information that integration across database operation is carried out to each database of operation system, and each database
First relational model, generate the second relational model of multiple databases of the operation system；Wherein, second relational model
The incidence relation between the tables of data in multiple databases for representing the operation system.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710279338.9A CN107391537B (en) | 2017-04-25 | 2017-04-25 | Method, device and equipment for generating data relation model |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710279338.9A CN107391537B (en) | 2017-04-25 | 2017-04-25 | Method, device and equipment for generating data relation model |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN107391537A true CN107391537A (en) | 2017-11-24 |
| CN107391537B CN107391537B (en) | 2020-09-15 |
Family
ID=60338300
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710279338.9A Active CN107391537B (en) | 2017-04-25 | 2017-04-25 | Method, device and equipment for generating data relation model |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107391537B (en) |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108108441A (en) * | 2017-12-21 | 2018-06-01 | 新博卓畅技术（北京）有限公司 | A kind of database table structure analysis method and system |
| CN110019555A (en) * | 2017-12-26 | 2019-07-16 | 中国科学院沈阳自动化研究所 | A kind of relation data semantization modeling method |
| CN110414259A (en) * | 2018-04-28 | 2019-11-05 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for constructing data element, realizing data sharing |
| CN111143370A (en) * | 2019-12-27 | 2020-05-12 | 北京数起科技有限公司 | Method, apparatus and computer-readable storage medium for analyzing relationships between a plurality of data tables |
| CN113901022A (en) * | 2021-09-22 | 2022-01-07 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and storage medium for establishing business and data relation model |
| CN116244386A (en) * | 2023-02-10 | 2023-06-09 | 北京友友天宇系统技术有限公司 | Identification method of entity association relation applied to multi-source heterogeneous data storage system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5933831A (en) * | 1998-01-09 | 1999-08-03 | Lsi Logic Corporation | Viewing entity relationship diagrams using hyperlinks |
| EP1460862A1 (en) * | 2003-03-19 | 2004-09-22 | Alcatel | Number portability database |
| CN102236701A (en) * | 2010-05-07 | 2011-11-09 | 微软公司 | Dependency graphs for multiple domains |
| CN102591952A (en) * | 2011-12-28 | 2012-07-18 | 用友软件股份有限公司 | Data query device and data query method based on semanteme |
| CN106227892A (en) * | 2016-08-24 | 2016-12-14 | 深圳市卓讯信息技术有限公司 | A kind of intellectual analysis database table relation generates the method and device of E R figure |
| CN106547796A (en) * | 2015-09-23 | 2017-03-29 | 南京中兴新软件有限责任公司 | The execution method and device of data base |
-
2017
- 2017-04-25 CN CN201710279338.9A patent/CN107391537B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US5933831A (en) * | 1998-01-09 | 1999-08-03 | Lsi Logic Corporation | Viewing entity relationship diagrams using hyperlinks |
| EP1460862A1 (en) * | 2003-03-19 | 2004-09-22 | Alcatel | Number portability database |
| CN102236701A (en) * | 2010-05-07 | 2011-11-09 | 微软公司 | Dependency graphs for multiple domains |
| CN102591952A (en) * | 2011-12-28 | 2012-07-18 | 用友软件股份有限公司 | Data query device and data query method based on semanteme |
| CN106547796A (en) * | 2015-09-23 | 2017-03-29 | 南京中兴新软件有限责任公司 | The execution method and device of data base |
| CN106227892A (en) * | 2016-08-24 | 2016-12-14 | 深圳市卓讯信息技术有限公司 | A kind of intellectual analysis database table relation generates the method and device of E R figure |
Cited By (10)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN108108441A (en) * | 2017-12-21 | 2018-06-01 | 新博卓畅技术（北京）有限公司 | A kind of database table structure analysis method and system |
| CN110019555A (en) * | 2017-12-26 | 2019-07-16 | 中国科学院沈阳自动化研究所 | A kind of relation data semantization modeling method |
| CN110019555B (en) * | 2017-12-26 | 2023-08-25 | 中国科学院沈阳自动化研究所 | Relation data semantical modeling method |
| CN110414259A (en) * | 2018-04-28 | 2019-11-05 | 阿里巴巴集团控股有限公司 | A kind of method and apparatus for constructing data element, realizing data sharing |
| CN110414259B (en) * | 2018-04-28 | 2023-08-25 | 阿里巴巴集团控股有限公司 | Method and equipment for constructing data category and realizing data sharing |
| CN111143370A (en) * | 2019-12-27 | 2020-05-12 | 北京数起科技有限公司 | Method, apparatus and computer-readable storage medium for analyzing relationships between a plurality of data tables |
| CN113901022A (en) * | 2021-09-22 | 2022-01-07 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and storage medium for establishing business and data relation model |
| CN113901022B (en) * | 2021-09-22 | 2024-03-15 | 成都飞机工业（集团）有限责任公司 | Method, device, equipment and storage medium for establishing business and data relationship model |
| CN116244386A (en) * | 2023-02-10 | 2023-06-09 | 北京友友天宇系统技术有限公司 | Identification method of entity association relation applied to multi-source heterogeneous data storage system |
| CN116244386B (en) * | 2023-02-10 | 2023-12-12 | 北京友友天宇系统技术有限公司 | Identification method of entity association relation applied to multi-source heterogeneous data storage system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN107391537B (en) | 2020-09-15 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107391537A (en) | Generation method, device and the equipment of data relationship model | |
| CN107562775A (en) | A kind of data processing method and equipment based on block chain | |
| CN107644286A (en) | Workflow processing method and device | |
| CN109739893A (en) | A kind of metadata management method, equipment and computer-readable medium | |
| CN110162796B (en) | News thematic creation method and device | |
| US10685062B2 (en) | Relational database management | |
| CN108268617A (en) | User view determines method and device | |
| CN106897340A (en) | A kind of data table updating method and device | |
| US20190392077A1 (en) | Facet-based query refinement based on multiple query interpretations | |
| US20200410355A1 (en) | Explainable machine learning based on heterogeneous data | |
| Grover et al. | BCD: BigData, cloud computing and distributed computing | |
| CN107633008A (en) | Web project data processing method, device, server and system | |
| CN107016039A (en) | The method and Database Systems of database write-in | |
| CN109062918A (en) | A kind of method and device of SQL statement conversion | |
| US11436412B2 (en) | Predictive event searching utilizing a machine learning model trained using dynamically-generated event tags | |
| CN107026897A (en) | A kind of methods, devices and systems of data processing | |
| CN107451204A (en) | A kind of data query method, apparatus and equipment | |
| CN107391529A (en) | A kind of method and device for realizing Object Relation Mapping ORM | |
| CN109582476A (en) | Data processing method, apparatus and system | |
| CN110134860A (en) | User's portrait generation method, device and equipment | |
| Randour | Automated synthesis of reliable and efficient systems through game theory: A case study | |
| US20160085758A1 (en) | Interest-based search optimization | |
| US11379504B2 (en) | Indexing and mining content of multiple data sources | |
| CN107506399A (en) | Method, system, equipment and the storage medium of data cell quick segmentation | |
| US20210034987A1 (en) | Auxiliary handling of metadata and annotations for a question answering system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee after: Innovative advanced technology Co.,Ltd. Address before: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee before: Advanced innovation technology Co.,Ltd. Effective date of registration: 20200923 Address after: Cayman Enterprise Centre, 27 Hospital Road, George Town, Grand Cayman, British Islands Patentee after: Advanced innovation technology Co.,Ltd. Address before: A four-storey 847 mailbox in Grand Cayman Capital Building, British Cayman Islands Patentee before: Alibaba Group Holding Ltd. |