CN109492014A - A kind of database model packet creation method, device and equipment - Google Patents
A kind of database model packet creation method, device and equipment Download PDFInfo
- Publication number
- CN109492014A CN109492014A CN201811603077.2A CN201811603077A CN109492014A CN 109492014 A CN109492014 A CN 109492014A CN 201811603077 A CN201811603077 A CN 201811603077A CN 109492014 A CN109492014 A CN 109492014A
- Authority
- CN
- China
- Prior art keywords
- model
- packet
- model packet
- database
- target
- 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 abstract description 41
- 238000004590 computer program Methods 0.000 claims description 6
- 238000004519 manufacturing process Methods 0.000 claims description 4
- 230000001360 synchronised effect Effects 0.000 abstract description 6
- 238000013515 script Methods 0.000 description 10
- 238000012986 modification Methods 0.000 description 8
- 230000004048 modification Effects 0.000 description 8
- 238000013499 data model Methods 0.000 description 2
- 238000012217 deletion Methods 0.000 description 2
- 230000037430 deletion Effects 0.000 description 2
- 238000003860 storage Methods 0.000 description 2
- 230000006399 behavior Effects 0.000 description 1
- 238000004422 calculation algorithm Methods 0.000 description 1
- 238000010586 diagram Methods 0.000 description 1
- 238000005516 engineering process Methods 0.000 description 1
- 230000007717 exclusion Effects 0.000 description 1
- 238000007726 management method Methods 0.000 description 1
- 238000002360 preparation method Methods 0.000 description 1
- 230000000750 progressive effect Effects 0.000 description 1
- 230000010076 replication Effects 0.000 description 1
- 230000001960 triggered effect Effects 0.000 description 1
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
This application discloses a kind of database model packet creation method, device and equipment, comprising: creation object model packet corresponding with target object；From pre-set product model library, the product model packet with the target object there are relevance is determined, obtain target product model packet；The adduction relationship between the object model packet and the target product model packet is created, so that the object model packet quotes the target product model packet；To currently operation is merged by the target product model packet that the object model packet is quoted, to export the full database model packet of the target object.Above-mentioned full database model packet is obtained on the basis of quoting above-mentioned target product model packet in the application, so that while target product model packet changes, therefore above-mentioned full database model packet can also realize synchronized update automatically, without being additionally updated operation, to simplify synchronizing process.
Description
Technical field
This application involves database technical field, in particular to a kind of database model packet creation method, device and equipment.
Background technique
Sybase model modeling software includes PowerDesigner, ER/Studio, ERWin etc. at present, by upper
Database model modeling software is stated, corresponding database model packet can be created for a project or a product.When one
When product can be implemented in multiple projects, in order to meet specific demand scene in disparity items, need in the said goods pair
Secondary development is carried out on the basis of the product model packet answered, so that the corresponding project model packet of disparity items is obtained, wherein
It include separate copy corresponding with the said goods model packet in each project model packet.But just because of each project mould
Type Bao Zhongjun preserves separate copy corresponding with the said goods model packet, changes so as to cause when the said goods model packet
Later, it is also necessary to additional update specially be carried out to the copy in each project model packet and operated, just can guarantee project model packet
In copy it is consistent with the said goods model packet, it can be seen that, above-mentioned synchronizing process is suitable very complicated.
Summary of the invention
In view of this, the application's is designed to provide a kind of database model packet creation method, device and equipment, pass through
Above scheme can carry out secondary development for target object on the basis of product model packet with a kind of new way, and make
While the said goods model packet changes, the full database model packet obtained after above-mentioned secondary development will be automatically real
Existing synchronized update, without being additionally updated operation, to simplify synchronizing process.Its concrete scheme is as follows:
In a first aspect, this application discloses a kind of database model packet creation methods, comprising:
Create object model packet corresponding with target object；
From pre-set product model library, determines the product model packet with the target object there are relevance, obtain mesh
Mark product model packet；Wherein, the pre-set product model library is for saving the product model packet being pre-created；
The adduction relationship between the object model packet and the target product model packet is created, so that the object model
Packet quotes the target product model packet；
Operation is merged to the target product model packet currently by object model packet reference, described in output
The full database model packet of target object.
Optionally, the object type of the target object is item types or product type.
Optionally, the target product model packet to currently by object model packet reference merges operation
Before, further includes:
Judgement currently by the object model packet quote the target product model packet in each database model be
It is no to meet model requirements corresponding with the target object；
If it is not, then according to the model requirements, to currently being drawn by the object model packet in the object model packet
Corresponding database model is accordingly modified in the target product model packet, obtains modified model copy；
Wherein, the database model include data table model, data sheet field model, view model, index model and
Enumerate model.
Optionally, the target product model packet to currently by object model packet reference merges operation
Before, further includes:
The target product mould for judging the modified model copy and currently being quoted by the object model packet
Whether all database models in type packet can satisfy whole model requirements corresponding with the target object；
If it is not, then creating corresponding new database model in the object model packet, be expanded model.
Optionally, the target product model packet to currently by object model packet reference merges behaviour
Make, to export the full database model packet of the target object, comprising:
The modified model copy and the extended model are determined as to the differential pattern of presently described target object；
It will currently be merged by the target product model packet of object model packet reference and the differential pattern,
To export the full database model packet of the target object.
Optionally, the database model packet creation method, further includes:
Corresponding version number is distributed for the full database model packet.
Optionally, the database model packet creation method, further includes:
The full database model packet is monitored；
If the arbitrary data library model monitored in the full database model packet is modified, corresponding change is recorded
Content, and new version number is distributed for this modified model packet.
Optionally, the database model packet creation method, further includes:
Obtain the increment information inquiry request comprising first version number and the second edition number；
Selected from the changed content recorded positioned at the first version number and the second edition number it
Between all changed contents；
The changed content is merged, to export corresponding incremental model.
Second aspect, this application discloses a kind of database model packet creating devices, comprising:
Model packet creation module, for creating object model packet corresponding with target object；
Model packet determining module, for determining that there are relevances with the target object from pre-set product model library
Product model packet, obtain target product model packet；Wherein, the pre-set product model library is for saving the product being pre-created
Model packet；
Model packet reference model is closed for creating the reference between the object model packet and the target product model packet
System, so that the object model packet quotes the target product model packet；
Model packet merging module, for being carried out to the target product model packet currently quoted by the object model packet
Union operation, to export the full database model packet of the target object.
The third aspect, this application discloses a kind of database model packets to create equipment, comprising:
Memory, for saving computer program；
Processor, for executing the computer program, to realize database model packet creation method above-mentioned.
As it can be seen that the application is creating the corresponding object model packet of target object and is determining from pre-set product model library
There are after the target product model packet of relevance, can further create above-mentioned object model packet and target production with target object out
Adduction relationship between product model packet is creating so that above-mentioned object model packet quotes above-mentioned target product model packet
After above-mentioned adduction relationship, by being merged to the target product model packet currently by object model packet reference,
Export the full database model packet of target object, it can be seen that, the complete number exported during above-mentioned model secondary development
It is based on complete number currently obtained by the target product model packet that the object model packet is quoted namely above-mentioned according to library model packet
It is to obtain on the basis of quoting above-mentioned target product model packet according to library model packet, so that when target product model packet is sent out
While changing more, therefore above-mentioned full database model packet also can realize synchronized update automatically, without being additionally updated
Operation, to simplify synchronizing process.
Detailed description of the invention
In order to illustrate the technical solutions in the embodiments of the present application or in the prior art more clearly, to embodiment or will show below
There is attached drawing needed in technical description to be briefly described, it should be apparent that, the accompanying drawings in the following description is only this
The embodiment of application for those of ordinary skill in the art without creative efforts, can also basis
The attached drawing of offer obtains other attached drawings.
Fig. 1 is a kind of database model packet creation method flow chart disclosed in the present application；
Fig. 2 is a kind of specific database model packet creation method flow chart disclosed in the present application；
Fig. 3 is a kind of database model packet creation method sub-process figure disclosed in the present application；
Fig. 4 is a kind of database model packet creating device structural schematic diagram disclosed in the present application.
Specific embodiment
Below in conjunction with the attached drawing in the embodiment of the present application, technical solutions in the embodiments of the present application carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of embodiments of the present application, instead of all the embodiments.It is based on
Embodiment in the application, it is obtained by those of ordinary skill in the art without making creative efforts every other
Embodiment shall fall in the protection scope of this application.
The embodiment of the present application discloses a kind of database model packet creation method, shown in Figure 1, this method comprises:
Step S11: creation object model packet corresponding with target object.
Step S12: from pre-set product model library, determine that there are the product models of relevance with the target object
Packet, obtains target product model packet；Wherein, the pre-set product model library is for saving the product model packet being pre-created.
It should be pointed out that since a project can be related to multiple product, so target object described in the present embodiment
Object type be specifically as follows item types.Certainly, it is contemplated that can be comprising relatively simple in some more complicated products
Single product, so the object type of target object described in the present embodiment is specifically also possible to product type.That is, this implementation
For target object in example either destination item, is also possible to target product, object model packet corresponding with target object can
To be project model packet or product model packet.
It include the product model packet being pre-created in above-mentioned pre-set product model library, also, each preparatory in the present embodiment
It may each comprise several database models in the product model packet of creation, such as including but not limited to data table model, data literary name
Segment model, index model, enumerates model etc. at view model.
In the present embodiment, need to select the product with target object there are relevance from above-mentioned pre-set product model library
Model packet is as target product model packet, specifically, can first sieve from the corresponding all products of above-mentioned pre-set product model library
The product that target object is relied on is selected, is then selected from the said goods model library corresponding with the above-mentioned product filtered out
Product model packet is as target product model packet.
Step S13: the adduction relationship between the object model packet and the target product model packet is created, so that described
Object model packet quotes the target product model packet.
That is, created object model packet corresponding to target object and determined from pre-set product model library with
It is not by way of copy replication by above-mentioned target product model after the associated target product model packet of target object
Packet direct copying creates the adduction relationship between object model packet and target product model packet into object model packet,
Object model packet REFER object product model packet need to be only allowed, so that destination item or target product possess it
All database models in cited target product model packet, also, in this way when later period target product model packet becomes
While more, model packet corresponding with target object can realize synchronized update automatically, complete without carrying out additional operation
It updates.
Step S14: merging operation to the target product model packet currently by object model packet reference, with
Export the full database model packet of the target object.
It is further noted that any products model packet in above-mentioned pre-set product model library is in addition to can be extraneous
Except reference, its own can also quote other product model packets in above-mentioned pre-set product model library.
Further, if the object type of target object described in the present embodiment is product type, then passing through above-mentioned mistake
It, can also be new using the complete data model packet as one after journey obtains complete data model packet corresponding with the target object
Product model packet save into above-mentioned pre-set product model library, to realize extension to above-mentioned pre-set product model library.
In addition, the present embodiment can use C/S model or B/S mode, the data file of multiple products or project is saved
In server database, multiple person cooperational management is supported.
As it can be seen that the embodiment of the present application is creating the corresponding object model packet of target object and from pre-set product model library
In determine with target object there are after the target product model packet of relevance, can further create above-mentioned object model packet with
Adduction relationship between target product model packet, so that above-mentioned object model packet quotes above-mentioned target product model packet,
After having created above-mentioned adduction relationship, by being closed to the target product model packet currently by object model packet reference
And the full database model packet of target object can be exported, it can be seen that, it is exported during above-mentioned model secondary development
Full database model packet is based on currently being obtained by the target product model packet that the object model packet is quoted namely above-mentioned
Full database model packet is obtained on the basis of quoting above-mentioned target product model packet, so that working as target product mould
While type packet changes, above-mentioned full database model packet also can therefore realize synchronized update automatically, without additionally into
Row updates operation, to simplify synchronizing process.
Shown in Figure 2, the embodiment of the present application discloses a kind of specific database model packet creation method, comprising:
Step S21: creation object model packet corresponding with target object.
Step S22: from pre-set product model library, determine that there are the product models of relevance with the target object
Packet, obtains target product model packet；Wherein, the pre-set product model library is for saving the product model packet being pre-created.
Step S23: the adduction relationship between the object model packet and the target product model packet is created, so that described
Object model packet quotes the target product model packet.
In the present embodiment, the information of project model packet or product model packet specifically can be as shown in table 1:
Table 1
| Field name | Chinese name | Description |
| NAME | Model packet title | For identifying the title of product or project |
| CODE | Model packet encoder | For identifying the unique encodings of product or project |
| TYPE | Model Packet type | Distinguish product model packet and project model packet. |
| REMARK | Description information | The model packet profile |
| CREATE_USER | Founder | Create the operator of the model packet |
| CREATE_TIME | Creation time | Create the time of the model packet |
In the present embodiment, the model packet of a target product or destination item can quote other multiple product model packets,
Adduction relationship between them can be indicated by table 2:
Table 2
In addition, can be with reference to disclosed in previous embodiment accordingly about the more specifical process of above-mentioned steps S21 to S23
Content is no longer repeated herein.
Step S24: each data in the target product model packet that judgement is currently quoted by the object model packet
Whether library model meets model requirements corresponding with the target object.
Wherein, the database model include data table model, data sheet field model, view model, index model and
Enumerate model.Further it will be understood that in order to distinguish the database model of disparity items or product, it can be above-mentioned each
Corresponding model packet encoder is added in the relevant information of database model.
In the present embodiment, the relevant information of data table model can be as shown in table 3:
Table 3
| Field name | Chinese name | Description |
| TITLE | Tables of data title | The title of tables of data |
| NAME | Data table name | The title of tables of data |
| PKG_CODE | Model packet encoder | The coding of affiliated product or project model packet |
| REMARK | Description information | The profile of tables of data |
| CREATE_USER | Founder | Create the operator of tables of data |
| CREATE_TIME | Creation time | Create the time of tables of data |
| LAST_MODIFY_USER | Modify people | The operator of modification tables of data recently |
| LAST_MODIFY_TIME | Modification time | The time of modification tables of data recently |
In the present embodiment, the relevant information of data sheet field model can be as shown in table 4:
Table 4
In the present embodiment, the relevant information of view model can be as shown in table 5:
Table 5
| Field name | Chinese name | Description |
| TITLE | View title | The title of view |
| NAME | View name | The title of view |
| PKG_CODE | Model packet encoder | The coding of affiliated product or project model packet |
| SQL | View SQL | The SQL script of view |
| CREATE_USER | Founder | Create the operator of view |
| CREATE_TIME | Creation time | Create the time of view |
| LAST_MODIFY_USER | Modify people | The operator of nearest view |
| LAST_MODIFY_TIME | Modification time | The time of nearest view |
In the present embodiment, the relevant information of index model can be as shown in table 6:
Table 6
| Field name | Chinese name | Description |
| TABLE_NAME | Tables of data coding | Affiliated tables of data coding |
| NAME | Index name | The title of index |
| PKG_CODE | Model packet encoder | The coding of affiliated product or project model packet |
| COLUMNS | Index field | The set of fields of index |
| TYPE | Index type | Including common, unique etc. |
| CREATE_USER | Founder | Create the operator of view |
| CREATE_TIME | Creation time | Create the time of view |
| LAST_MODIFY_USER | Modify people | The operator of nearest view |
| LAST_MODIFY_TIME | Modification time | The time of nearest view |
In the present embodiment, the relevant information for enumerating model can be as shown in table 7:
Table 7
| Field name | Chinese name | Description |
| NAME | Enumerate title | The unique name enumerated |
| ITEM_NAME | Enumerate project name | The corresponding display Name of each enumerated value |
| ITEM_VALUE | Enumerate item value | The corresponding storage value of each enumerated value |
| PKG_CODE | Model packet encoder | The coding of affiliated product or project model packet |
| SORT_NO | Sort serial number | The sequence shown for enumerated value |
| CREATE_USER | Founder | Create the operator enumerated |
| CREATE_TIME | Creation time | Create the time enumerated |
| LAST_MODIFY_USER | Modify people | The operator enumerated recently |
| LAST_MODIFY_TIME | Modification time | The time enumerated recently |
Step S25: if it is not, then according to the model requirements, to currently by the object in the object model packet
Corresponding database model is accordingly modified in the target product model packet of model packet reference, obtains modified model
Copy.
That is, any database model of the present embodiment in the target product model packet quoted by object model packet can not
When meeting the corresponding model requirements of the target object, phase can be made for the database model in the object model packet
The modification answered, that is, the present embodiment be not directly modify in target product model packet to corresponding database model, and
It is to modify in object model packet for above-mentioned database model, specifically, can be by being directed in object model packet
Above-mentioned database model is modified accordingly, obtains a new model copy being located in object model packet, and utilizing should
The database model originally quoted in model copy covering object model packet is not modifying target product model really to realize
Under the premise of database model in packet, so that the database model in object model packet can satisfy the corresponding mould of target object
Type demand.
Step S26: the mesh for judging the modified model copy and currently being quoted by the object model packet
Whether all database models in mark product model packet can satisfy whole model requirements corresponding with the target object.
Step S27: it if it is not, then creating corresponding new database model in the object model packet, is expanded
Model.
That is, referring to relevant target product model packet in object model packet, and according to model requirements in object mould
After modifying in type packet for the database model quoted accordingly, if object model packet is still unable to satisfy mesh at this time
The corresponding whole model requirements of object are marked, that is, if object model packet does not have the corresponding certain moulds of target object at this time
When type demand, then corresponding new database model can be created in object model packet, thus the model that is expanded.It can manage
Solution, since above-mentioned extended model is created in object model packet, the object model packet not yet by it is extraneous other
In the case that product or project are quoted, the above-mentioned extended model in the object model packet is for other products or project at this time
It is sightless.
In the present embodiment, the type of above-mentioned extended model includes but is not limited to data table model, data sheet field model, view
Graph model, index model and enumerate model.
Step S28: the modified model copy and the extended model are determined as presently described target object
Differential pattern.
In addition, the present embodiment after determining above-mentioned differential pattern, can also export the differential pattern, and extract with
The corresponding whole SQL script of the differential pattern, obtains difference SQL script, and export difference SQL script.
Step S29: the target product model packet and the differential pattern that will be currently quoted by the object model packet
It merges, to export the full database model packet of the target object.
It should be pointed out that after obtaining above-mentioned full database model packet, can also according to later destination item or
The actual demand situation of change of target product modifies the database model in above-mentioned full database model packet accordingly
Operation.It is understood that above-mentioned modification operation includes but is not limited to the operation such as fine tuning, deletion, newly-increased.
Further, it after obtaining above-mentioned full database model packet, can be extracted and the full database with full dose
The corresponding whole SQL script of model packet, and export the SQL script.
It is shown in Figure 3, on the basis of previous embodiment disclosure, in the embodiment of the present application, further comprise:
Step S31: corresponding version number is distributed for the full database model packet.
Step S32: the full database model packet is monitored.
Step S33: if the arbitrary data library model monitored in the full database model packet is modified, phase is recorded
The changed content answered, and new version number is distributed for this modified model packet.
It should be noted that can specifically refine to atomic level when recording above-mentioned changed content, namely specifically can be with
It refine to data table model, data sheet field model, view model, index model and enumerates the ranks such as model, pass through this grade
The each single item changed content of record can be converted into corresponding data library script by other recording mode.
From the foregoing, it will be observed that the present embodiment when creating and modifying above-mentioned full database model packet, can generate corresponding version
This number.It is understood that the present embodiment specifically can according to the change chronological order of model packet, sequentially create from it is small to
Big version number, that is, the change time is more rearward, corresponding version number becomes bigger.
In the present embodiment, when the arbitrary data library model in model packet is modified, specifically it can recorde comprising mutually straining
The version information of more content and newly assigned version number can be determined in change accordingly by inquiring the version information
Appearance and version number.Wherein, above-mentioned version information specifically can be as shown in table 8:
Table 8
Step S34: the increment information inquiry request comprising first version number and the second edition number is obtained.
Step S35: it selects from the changed content recorded positioned at the first version number and described second
All changed contents between version number.
Step S36: merging the changed content, to export corresponding incremental model.
In the present embodiment, increment information inquiry request includes first version number and the second edition number, wherein the above-mentioned first edition
This number is used as starting version number, and the above-mentioned second edition number is as end version number.It can be from aforementioned by above-mentioned two version number
It is inquired in the changed content recorded positioned at above-mentioned starting version number and terminates all changed contents between version number.
In a specific embodiment, above-mentioned increment information inquiry request can be by background system automatically according to preset
Iteration cycle is periodically triggered, and correspondingly, the first version number as starting version number corresponds to each iteration week
At the beginning of phase, the finish time of each iteration cycle is corresponded to as the second edition number for terminating version number.
In another embodiment specific implementation mode, above-mentioned increment information inquiry request can also be initiated by user, at this time may be used
User is allowed to choose arbitrary version number as first version number and the second edition number according to the actual queries needs of itself.
In addition, the present embodiment is after inquiring above-mentioned all corresponding changed contents, it is also necessary to these changed contents
It merges.In some embodiments, it can be merged according to the merging rule on the basis of maximum version number, for example,
In the above-mentioned all changed contents inquired, if repeatedly changing the fields such as field length, field description for same field
Attribute then can only take changed content corresponding with maximum version number.In further embodiments, it can be offset according to mutual exclusion
Merge rule to merge, for example, can then pass through word when successively there are the change operations such as newly-increased, deletion for same field
Cancelling out each other to merge between section.
Further, the present embodiment can also extract and the incremental model pair while exporting corresponding incremental model
The whole SQL scripts answered, obtain corresponding increment SQL script, and export increment SQL script.
Shown in Figure 4, the embodiment of the present application discloses a kind of database model packet creating device, comprising:
Model packet creation module 11, for creating object model packet corresponding with target object；
Model packet determining module 12 is associated with for from pre-set product model library, determining to exist with the target object
The product model packet of property, obtains target product model packet；Wherein, the pre-set product model library is for saving the production being pre-created
Product model packet；
Model packet reference model 13, for creating the reference between the object model packet and the target product model packet
Relationship, so that the object model packet quotes the target product model packet；
Model packet merging module 14, for currently by the object model packet quote the target product model packet into
Row union operation, to export the full database model packet of the target object.
It wherein, can be with reference to disclosed in previous embodiment accordingly about the more specifical course of work of above-mentioned modules
Content is no longer repeated herein.
As it can be seen that the embodiment of the present application is creating the corresponding object model packet of target object and from pre-set product model library
In determine with target object there are after the target product model packet of relevance, can further create above-mentioned object model packet with
Adduction relationship between target product model packet, so that above-mentioned object model packet quotes above-mentioned target product model packet,
After having created above-mentioned adduction relationship, by being closed to the target product model packet currently by object model packet reference
And the full database model packet of target object can be exported, it can be seen that, it is exported during above-mentioned model secondary development
Full database model packet is based on currently being obtained by the target product model packet that the object model packet is quoted namely above-mentioned
Full database model packet is obtained on the basis of quoting above-mentioned target product model packet, so that working as target product mould
While type packet changes, above-mentioned full database model packet also can therefore realize synchronized update automatically, without additionally into
Row updates operation, to simplify synchronizing process.
Further, disclosed herein as well is a kind of database model packets to create equipment, comprising:
Memory, for saving computer program；
Processor, for executing the computer program, to realize database model packet creation method above-mentioned.
It wherein, can be with reference to disclosed in previous embodiment about the specific steps of above-mentioned database model packet creation method
Corresponding contents are no longer repeated herein.
Each embodiment in this specification is described in a progressive manner, the highlights of each of the examples are with it is other
The difference of embodiment, same or similar part may refer to each other between each embodiment.For being filled disclosed in embodiment
For setting, since it is corresponded to the methods disclosed in the examples, so being described relatively simple, related place is referring to method part
Explanation.
The step of method described in conjunction with the examples disclosed in this document or algorithm, can directly be held with hardware, processor
The combination of capable software module or the two is implemented.Software module can be placed in random access memory (RAM), memory, read-only deposit
Reservoir (ROM), electrically programmable ROM, electrically erasable ROM, register, hard disk, moveable magnetic disc, CD-ROM or technology
In any other form of storage medium well known in field.
Detailed Jie has been carried out to a kind of database model packet creation method, device and equipment provided herein above
It continues, specific examples are used herein to illustrate the principle and implementation manner of the present application, and the explanation of above embodiments is only
It is to be used to help understand the method for this application and its core ideas；At the same time, for those skilled in the art, according to this Shen
Thought please, there will be changes in the specific implementation manner and application range, in conclusion the content of the present specification should not manage
Solution is the limitation to the application.
Claims (10)
1. a kind of database model packet creation method characterized by comprising
Create object model packet corresponding with target object；
From pre-set product model library, the product model packet with the target object there are relevance is determined, obtain target production
Product model packet；Wherein, the pre-set product model library is for saving the product model packet being pre-created；
The adduction relationship between the object model packet and the target product model packet is created, so that the object model packet draws
With the target product model packet；
To currently operation is merged by the target product model packet that the object model packet is quoted, to export the target
The full database model packet of object.
2. database model packet creation method according to claim 1, which is characterized in that the object class of the target object
Type is item types or product type.
3. database model packet creation method according to claim 1, which is characterized in that described to currently by the object
The target product model packet of model packet reference merges before operation, further includes:
Whether each database model in the target product model packet that judgement is currently quoted by the object model packet is full
Sufficient model requirements corresponding with the target object；
If it is not, then according to the model requirements, to currently by object model packet reference in the object model packet
Corresponding database model is accordingly modified in the target product model packet, obtains modified model copy；
Wherein, the database model includes data table model, data sheet field model, view model, index model and enumerates
Model.
4. database model packet creation method according to claim 3, which is characterized in that described to currently by the object
The target product model packet of model packet reference merges before operation, further includes:
The target product model packet for judging the modified model copy and currently being quoted by the object model packet
In all database models whether can satisfy whole model requirements corresponding with the target object；
If it is not, then creating corresponding new database model in the object model packet, be expanded model.
5. database model packet creation method according to claim 4, which is characterized in that described to currently by the object
The target product model packet of model packet reference merges operation, to export the full database model of the target object
Packet, comprising:
The modified model copy and the extended model are determined as to the differential pattern of presently described target object；
It will currently be merged by the target product model packet of object model packet reference and the differential pattern, with defeated
The full database model packet of the target object out.
6. database model packet creation method according to any one of claims 1 to 5, which is characterized in that further include:
Corresponding version number is distributed for the full database model packet.
7. database model packet creation method according to claim 6, which is characterized in that further include:
The full database model packet is monitored；
If the arbitrary data library model monitored in the full database model packet is modified, record in corresponding change
Hold, and distributes new version number for this modified model packet.
8. database model packet creation method according to claim 7, which is characterized in that further include:
Obtain the increment information inquiry request comprising first version number and the second edition number；
It is selected from the changed content recorded between the first version number and the second edition number
All changed contents；
The changed content is merged, to export corresponding incremental model.
9. a kind of database model packet creating device characterized by comprising
Model packet creation module, for creating object model packet corresponding with target object；
Model packet determining module, for determining that there are the productions of relevance with the target object from pre-set product model library
Product model packet obtains target product model packet；Wherein, the pre-set product model library is for saving the product model being pre-created
Packet；
Model packet reference model, for creating the adduction relationship between the object model packet and the target product model packet,
So that the object model packet quotes the target product model packet；
Model packet merging module, for being merged to the target product model packet currently by object model packet reference
Operation, to export the full database model packet of the target object.
10. a kind of database model packet creates equipment characterized by comprising
Memory, for saving computer program；
Processor, for executing the computer program, to realize database model as claimed in any one of claims 1 to 8
Packet creation method.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811603077.2A CN109492014A (en) | 2018-12-26 | 2018-12-26 | A kind of database model packet creation method, device and equipment |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811603077.2A CN109492014A (en) | 2018-12-26 | 2018-12-26 | A kind of database model packet creation method, device and equipment |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109492014A true CN109492014A (en) | 2019-03-19 |
Family
ID=65712312
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811603077.2A Pending CN109492014A (en) | 2018-12-26 | 2018-12-26 | A kind of database model packet creation method, device and equipment |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109492014A (en) |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111813880A (en) * | 2020-06-09 | 2020-10-23 | 广东国地规划科技股份有限公司 | Method, system and storage medium for managing territorial space planning project |
| CN113918209A (en) * | 2021-12-16 | 2022-01-11 | 深圳市明源云科技有限公司 | Method and device for generating upgrade list and readable storage medium |
Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1190477A (en) * | 1995-07-07 | 1998-08-12 | 瓦尔数据公司 | Method and apparatus for modifying existing relational database schemas to reflect changes made in corresponding object model |
| US20080263104A1 (en) * | 2006-06-15 | 2008-10-23 | Chowdhary Pawan R | Updating a data warehouse schema based on changes in an observation model |
| CN103810257A (en) * | 2014-01-24 | 2014-05-21 | 华为技术有限公司 | Method and device for upgrading software database and equipment |
| CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
| EP2856345A1 (en) * | 2012-05-24 | 2015-04-08 | Telefonaktiebolaget LM Ericsson (PUBL) | Meta model driven data export from a database and meta model driven data import to a database |
| CN104573100A (en) * | 2015-01-29 | 2015-04-29 | 无锡江南计算技术研究所 | Step-by-step database synchronization method with autoincrement identifications |
| CN105786925A (en) * | 2014-12-26 | 2016-07-20 | 远光软件股份有限公司 | Reference model based dynamic data modeling method and apparatus |
| CN106649771A (en) * | 2016-12-27 | 2017-05-10 | 广州杰赛科技股份有限公司 | Data model updating method and system for database |
-
2018
- 2018-12-26 CN CN201811603077.2A patent/CN109492014A/en active Pending
Patent Citations (8)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN1190477A (en) * | 1995-07-07 | 1998-08-12 | 瓦尔数据公司 | Method and apparatus for modifying existing relational database schemas to reflect changes made in corresponding object model |
| US20080263104A1 (en) * | 2006-06-15 | 2008-10-23 | Chowdhary Pawan R | Updating a data warehouse schema based on changes in an observation model |
| EP2856345A1 (en) * | 2012-05-24 | 2015-04-08 | Telefonaktiebolaget LM Ericsson (PUBL) | Meta model driven data export from a database and meta model driven data import to a database |
| CN103810257A (en) * | 2014-01-24 | 2014-05-21 | 华为技术有限公司 | Method and device for upgrading software database and equipment |
| CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
| CN105786925A (en) * | 2014-12-26 | 2016-07-20 | 远光软件股份有限公司 | Reference model based dynamic data modeling method and apparatus |
| CN104573100A (en) * | 2015-01-29 | 2015-04-29 | 无锡江南计算技术研究所 | Step-by-step database synchronization method with autoincrement identifications |
| CN106649771A (en) * | 2016-12-27 | 2017-05-10 | 广州杰赛科技股份有限公司 | Data model updating method and system for database |
Non-Patent Citations (1)
| Title |
|---|
| S_H_C: "材质-Material和预设体-Prefabs", 《URL: HTTPS://WWW.JIANSHU.COM/P/12E0E06E3112》 * |
Cited By (4)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN111813880A (en) * | 2020-06-09 | 2020-10-23 | 广东国地规划科技股份有限公司 | Method, system and storage medium for managing territorial space planning project |
| CN111813880B (en) * | 2020-06-09 | 2024-03-19 | 广东国地规划科技股份有限公司 | Homeland space planning project management method, system and storage medium |
| CN113918209A (en) * | 2021-12-16 | 2022-01-11 | 深圳市明源云科技有限公司 | Method and device for generating upgrade list and readable storage medium |
| CN113918209B (en) * | 2021-12-16 | 2022-04-15 | 深圳市明源云科技有限公司 | Method and device for generating upgrade list and readable storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8788457B2 (en) | Ensuring that the archival data deleted in relational source table is already stored in relational target table | |
| US11893046B2 (en) | Method and apparatus for implementing a set of integrated data systems | |
| US8478719B2 (en) | System and method for media file synchronization | |
| CN104781809A (en) | Container database | |
| CN102193991B (en) | OLTP(on-line transaction processing)-based data modifying method and system as well as graphic database server | |
| DE202010018481U1 (en) | Asynchronous Distributed Object Upload for Replicated Associative Storage Clusters | |
| EP1585036A2 (en) | Management of parameterized database queries | |
| US20120239617A1 (en) | System and method for media file synchronization | |
| CN111324577B (en) | Yml file reading and writing method and device | |
| CN108369587A (en) | Create the table for exchange | |
| CN105095319A (en) | Time serialization based document identifying, associating, searching and showing system | |
| CN109325158A (en) | A kind of electronic document automation archiving method and system | |
| CN107025242A (en) | The clone method and device of data between database | |
| CN106649412B (en) | Data processing method and equipment | |
| CN104142930A (en) | Universal Delta data loading technology | |
| CN104657387A (en) | Data query method and device | |
| CN107562931A (en) | Data pick-up system and data abstracting method | |
| CN105740383A (en) | Method and system for realizing data consistency of database and cache in big data platform | |
| CN101727473A (en) | Method and system for monitoring and tracking video on internet | |
| CN110737432B (en) | Script aided design method and device based on root list | |
| CN105677751A (en) | Relation-type database scheduling method and system | |
| CN107766374A (en) | The optimization method and system that a kind of mass small documents storage is read | |
| CN109492014A (en) | A kind of database model packet creation method, device and equipment | |
| CN109726192A (en) | System and method for separate management function of master data model version and field based on big data environment | |
| CN108958653A (en) | A kind of space reclamation method, system and relevant apparatus based on bottom aggregate file |
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 | ||
| RJ01 | Rejection of invention patent application after publication | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190319 |