CN107247812A - The generation method and generating means of a kind of database - Google Patents
The generation method and generating means of a kind of database Download PDFInfo
- Publication number
- CN107247812A CN107247812A CN201710609268.9A CN201710609268A CN107247812A CN 107247812 A CN107247812 A CN 107247812A CN 201710609268 A CN201710609268 A CN 201710609268A CN 107247812 A CN107247812 A CN 107247812A
- Authority
- CN
- China
- Prior art keywords
- database
- template
- configuration information
- expected data
- data storehouse
- 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
- 238000000034 method Methods 0.000 title claims abstract description 26
- 238000009434 installation Methods 0.000 description 4
- 230000008859 change Effects 0.000 description 2
- 230000006870 function Effects 0.000 description 2
- 230000007717 exclusion Effects 0.000 description 1
- 230000004048 modification Effects 0.000 description 1
- 238000012986 modification Methods 0.000 description 1
- 230000008569 process Effects 0.000 description 1
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/21—Design, administration or maintenance of databases
Abstract
The embodiment of the invention discloses a kind of generation method of database and generating means, including obtain the mutually different database configuration information of M groups;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of database template;Obtain expected data storehouse configuration information;A database template is selected to be used as target data library template from M database template of generation according to the expected data storehouse configuration information of acquisition;According to target database template generation database.The technical scheme provided from the present invention, due to generating volume of data library template according to different database configuration informations, therefore, when creating database, according to expected data storehouse configuration information the database template for possessing disparate databases configuration information can be selected to generate database, so as to it is simple, easily realize automatically generating for database, dramatically save human cost.
Description
Technical field
The present invention relates to the generation method and generating means of data processing field, more particularly to a kind of database.
Background technology
Database (Database) is the warehouse for coming tissue, storage and management data according to data structure.
In correlation technique, the generation of database needs a series of option of manual configuration, therefore configuration process is cumbersome, very
Labor intensive cost.
The content of the invention
In order to solve the above-mentioned technical problem, the present invention provides a kind of generation method and generating means of database, so as to
It is enough that database is automatically generated according to database template.
In order to reach the object of the invention, the invention provides a kind of generation method of database, including:
Obtain the mutually different database configuration information of M groups;Wherein, M is positive integer;
I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of database mould
Plate;Wherein, i=1,2...M;
Obtain expected data storehouse configuration information;
One database is selected from M database template of generation according to the expected data storehouse configuration information of acquisition
Template is used as target data library template;
According to the target database template generation database.
I-th group of database configuration information in the M groups database configuration information includes OS Type, version database
I-th group of database configuration information life in the internal memory that this and database take, the M group database configuration informations according to acquisition
Into i-th of database template, including:
The OS Type, the version database that i-th group of database configuration information of acquisition is included
The internal memory that this and the database take inserts the correspondence position of default script, generates the script of i-th of database template;
The script of i-th of database template is run, i-th of database template is generated.
The expected data storehouse configuration information according to acquisition selects a database from M database template of generation
Template as target data library template, including:
Judge whether the expected data storehouse configuration information obtained meets preset rules;Wherein, the preset rules are used
In the irrational expected data storehouse configuration information of exclusion;
If the expected data configuration information obtained meets the preset rules, according to the expected data storehouse of acquisition
Configuration information selects a database template to be used as target data library template from the M database template of generation.
Expected data storehouse configuration information includes desired operation system type, expected data storehouse version and expected data storehouse
The internal memory of occupancy, the expected data storehouse configuration information according to acquisition selects a number from M database template of generation
According to library template as target data library template, including:
OS Type and the desired operation system class whether are deposited in the M database template for judging generation
It is interior that the internal memory that type, database version and expected data storehouse version, and database take and the expected data storehouse take
Deposit all identical database templates;
If in the presence of selection operation system type and the desired operation system from the M database template of generation
Type is identical, and database version is identical with expected data storehouse version, and the internal memory and the expected data of database occupancy
One database template of internal memory identical that storehouse takes, is used as target data library template;
If being not present, selection operation system type and the desired operation system from the M database template of generation
Type of uniting is identical, and database version and the expected data storehouse version identical alternate data library template;
The internal memory for selecting database to take from the alternate data library template selected is accounted for the expected data storehouse
The absolute difference of internal memory is minimum, and a number of the internal memory less than the internal memory that the expected data storehouse takes that database takes
According to library template, target data library template is used as.
After the target database template generation database according to selection, in addition to:
Obtain database management instructions;
The database of generation is managed according to the database management instructions.
The invention provides a kind of generating means of database, including:
First acquisition module, for obtaining the mutually different database configuration information of M groups;Wherein, M is positive integer;
First processing module, for i-th group of database configuration information life in the M group database configuration informations according to acquisition
Into i-th of database template;Wherein, i=1,2...M;
Second acquisition module, for obtaining expected data storehouse configuration information;
Selecting module, for according to the expected data storehouse configuration information of acquisition from M database template of generation
One database template of selection is used as target data library template;
Second processing module, for according to the target database template generation database.
I-th group of database configuration information in the M groups database configuration information includes OS Type, version database
The internal memory that this and database take;
The first processing module includes:
First generation unit, for the operating system for including i-th group of database configuration information of acquisition
The internal memory that type, the database version and the database take inserts the correspondence position of default script, generates i-th of data
The script of library template;
Second generation unit, the script for running i-th of database template generates i-th of database mould
Plate.
The selecting module includes:
Whether judging unit, the expected data storehouse configuration information for judging to obtain meets preset rules;Wherein, institute
Stating preset rules is used to exclude irrational expected data storehouse configuration information;
Processing unit, if meeting the preset rules for the expected data configuration information obtained, according to acquisition
Expected data storehouse configuration information selects a database template to be used as number of targets from the M database template of generation
According to library template.
Expected data storehouse configuration information includes desired operation system type, expected data storehouse version and expected data storehouse
The internal memory of occupancy;The processing unit specifically for:
OS Type and the desired operation system class whether are deposited in the M database template for judging generation
It is interior that the internal memory that type, database version and expected data storehouse version, and database take and the expected data storehouse take
Deposit all identical database templates;
If in the presence of selection operation system type and the desired operation system from the M database template of generation
Type is identical, and database version is identical with expected data storehouse version, and the internal memory and the expected data of database occupancy
One database template of internal memory identical that storehouse takes, is used as target data library template;
If being not present, selection operation system type and the desired operation system from the M database template of generation
Type of uniting is identical, and database version and the expected data storehouse version identical alternate data library template;
The internal memory for selecting database to take from the alternate data library template selected is accounted for the expected data storehouse
The absolute difference of internal memory is minimum, and a number of the internal memory less than the internal memory that the expected data storehouse takes that database takes
According to library template, target data library template is used as.
Also include:
3rd acquisition module, for obtaining database management instructions;
3rd processing module, for being managed according to the database management instructions to the database of generation.
Compared with prior art, the present invention at least includes obtaining the mutually different database configuration information of M groups;Wherein, M is
Positive integer;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of database template;
Wherein, i=1,2...M;Obtain expected data storehouse configuration information;According to the expected data storehouse configuration information of acquisition from the M of generation
A database template is selected to be used as target data library template in individual database template;According to target database template generation data
Storehouse.The technical scheme provided from the present invention, due to generating volume of data storehouse according to different database configuration informations
Template, therefore, when creating database, can possess disparate databases configuration information according to the selection of expected data storehouse configuration information
Database template generation database, so as to simply, easily realize automatically generating for database, dramatically save
Human cost.
Other features and advantages of the present invention will be illustrated in the following description, also, partly becomes from specification
Obtain it is clear that or being understood by implementing the present invention.The purpose of the present invention and other advantages can be by specification, rights
Specifically noted structure is realized and obtained in claim and accompanying drawing.
Brief description of the drawings
Accompanying drawing is used for providing further understanding technical solution of the present invention, and constitutes a part for specification, with this
The embodiment of application is used to explain technical scheme together, does not constitute the limitation to technical solution of the present invention.
Fig. 1 is a kind of schematic flow sheet of the generation method of database provided in an embodiment of the present invention;
Fig. 2 is the schematic flow sheet of the generation method of another database provided in an embodiment of the present invention;
Fig. 3 is the schematic flow sheet of the generation method of another database provided in an embodiment of the present invention;
Fig. 4 is a kind of structural representation of the generating means of database provided in an embodiment of the present invention;
Fig. 5 is the structural representation of the generating means of another database provided in an embodiment of the present invention;
Fig. 6 is the structural representation of the generating means of another database provided in an embodiment of the present invention.
Embodiment
For the object, technical solutions and advantages of the present invention are more clearly understood, below in conjunction with accompanying drawing to the present invention
Embodiment be described in detail.It should be noted that in the case where not conflicting, in the embodiment and embodiment in the application
Feature can mutually be combined.
The embodiment of the present invention provides a kind of generation method of database, as shown in figure 1, this method includes:
Step 101, the acquisition mutually different database configuration information of M groups.
Wherein, M is positive integer.
It should be noted that the mutually different database configuration information of M groups can be inputted by user.
Specifically, database can be oracle database, it in database field is always to maintain the leading position that it, which is,
Product, is one kind of current database most popular in the world, its portability is good, easy to use, function is strong, it is adaptable to all kinds of
Large, medium and small various microcomputer environment.
Step 102, i-th of number is generated according to i-th group of database configuration information in the M group database configuration informations of acquisition
According to library template.
Wherein, i=1,2...M.
Specifically, i-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of number
Referred to according to library template:The 1st group of database configuration information in the M group database configuration informations of acquisition generates the 1st number
According to library template;The 2nd group of database configuration information in the M group database configuration informations of acquisition generates the 2nd database mould
Plate ... generates m-th database template according to the M groups database configuration information in the M group database configuration informations of acquisition.Institute
The database template of generation be applied to cloud computing management platform OpenStack, OpenStack be one it is intended that client provide cloud
The open source projects of service, are combined by several main components such as calculating, mirror image, storage, network and complete the related work of cloud service
Make, its target be for the hundreds of millions of user in the whole world provides implementation simply, can on a large scale extend, enrich, the cloud meter that standard is unified
Calculate management platform.
Specifically, can be by the message composition for the database template to be generated into script, so that with one-touch fortune
The mode of the row script generates database template, wherein, rely on bag batch installation procedure comprising database in script, initial
Change database user and subscriber group information, initialization data library database associated profile, installation data library services,
Table management tool program, registration database switching on and shutting down service routine and the branch of installation database oracle listener, installation database
Database is held with startup procedure.
Step 103, acquisition expected data storehouse configuration information.
It should be noted that expected data storehouse configuration information can be inputted by user.
Step 104, a number selected from M database template of generation according to the expected data storehouse configuration information of acquisition
Target data library template is used as according to library template.
Specifically, selecting a number from M database template of generation according to the expected data storehouse configuration information of acquisition
Referred to according to library template as target data library template:One, which is selected, from M database template of generation meets expected data
The database template of storehouse configuration information is used as target data library template.
Step 105, the target database template generation database according to selection.
The generation method for the database that the embodiment of the present invention is provided, obtains the mutually different database configuration information of M groups;
Wherein, M is positive integer;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of number
According to library template;Wherein, i=1,2...M;Obtain expected data storehouse configuration information;According to the expected data storehouse configuration information of acquisition
A database template is selected to be used as target data library template from M database template of generation;According to target database mould
Plate generates database.The technical scheme provided from the present invention, due to generating one according to different database configuration informations
Series data library template, therefore, when creating database, can possess different pieces of information according to the selection of expected data storehouse configuration information
The database template generation database of storehouse configuration information, so that automatically generating for database simply, is easily realized, very big journey
Save human cost degree.
The embodiment of the present invention provides the generation method of another database, wherein, as shown in Fig. 2 this method includes:
Step 201, the acquisition mutually different database configuration information of M groups.
Wherein, M is positive integer;I-th group of database configuration information in M group database configuration informations includes operating system class
The internal memory that type, database version and database take;I=1,2...M.
Specifically, because every group of database configuration information is all accounted for including OS Type, database version and database
These three information of internal memory, therefore the mutually different database configuration information of M groups refers to:In M group database configuration informations
Three kinds of information in any one group of database configuration information and three kinds of INFORMATION OF INCOMPLETE phases in other group of database configuration information
Together;Wherein, OS Type includes Windows operating system and (SuSE) Linux OS etc..
Step 202, the OS Type for including i-th group of database configuration information of acquisition, database version and
The internal memory that database takes inserts the correspondence position of default script, generates the script of i-th of database template.
Specifically, default script is the script for generating database template, preset in script on OS Type
Perform sentence, on database version perform sentence and on database take internal memory perform sentence in property value
All need specifically to insert, to generate the script of complete database template.By in i-th group of database configuration information of acquisition
Including OS Type, the internal memory that takes of database version and database insert the correspondence position of default script, generation i-th
The script of individual database template is referred to:OS Type that i-th group of database configuration information of acquisition is included, data
The internal memory that storehouse version and database take inserts the correspondence position of default script, generates the script of i-th of database template;It will obtain
The internal memory that OS Type, database version and the database that the i-th group of database configuration information taken includes take is inserted
The correspondence position of default script, generates the script ... of i-th of database template by i-th group of database configuration information of acquisition
Including OS Type, the internal memory that takes of database version and database insert the correspondence position of default script, generation i-th
The script of individual database template.
Step 203, the script for running i-th of database template, generate i-th of database template.
Specifically, the script of i-th of database template of operation, i-th of database template of generation is referred to:Run the 1st
The script of database template, generates the 1st database template;The script of the 2nd database template is run, the 2nd data are generated
Library template ... runs the script of m-th database template, generates m-th database template.
Specifically, after M database template of generation, M database template can be uploaded into cloud management platform, by cloud pipe
Platform carries out unified management to it.Cloud management platform is a kind of function more perfect virtual management platform, uses cloud
Management platform can be realized easily the work such as docks with organizational structure, wherein, the computer programming used in cloud management platform
Language is JAVA.
Step 204, acquisition expected data storehouse configuration information.
Step 205, judge obtain expected data storehouse configuration information whether meet preset rules.
Wherein, preset rules are used to exclude irrational expected data storehouse configuration information.
If step 206, the expected data configuration information obtained meet preset rules, configured according to the expected data storehouse of acquisition
Information selects a database template to be used as target data library template from M database template of generation.
Step 207, the target database template generation database according to selection.
It should be noted that if M database template of generation is uploaded to cloud management platform, step 204~step 207 is equal
It can be realized in cloud management platform.
The generation method for the database that the embodiment of the present invention is provided, obtains the mutually different database configuration information of M groups;
Wherein, M is positive integer;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of number
According to library template;Wherein, i=1,2...M;Obtain expected data storehouse configuration information;According to the expected data storehouse configuration information of acquisition
A database template is selected to be used as target data library template from M database template of generation;According to target database mould
Plate generates database.The technical scheme provided from the present invention, due to generating one according to different database configuration informations
Series data library template, therefore, when creating database, can possess different pieces of information according to the selection of expected data storehouse configuration information
The database template generation database of storehouse configuration information, so that automatically generating for database simply, is easily realized, very big journey
Save human cost degree.
The embodiment of the present invention provides the generation method of another database, wherein, i-th in M group database configuration informations
Group database configuration information includes the internal memory that OS Type, database version and database take, the configuration of expected data storehouse
Information includes the internal memory that desired operation system type, expected data storehouse version and expected data storehouse take, as shown in figure 3, the party
Method includes:
Step 301, the acquisition mutually different database configuration information of M groups.
Wherein, M is positive integer;I-th group of database configuration information in M group database configuration informations includes operating system class
The internal memory that type, database version and database take;I=1,2...M.
Step 302, the OS Type for including i-th group of database configuration information of acquisition, database version and
The internal memory that database takes inserts the correspondence position of default script, generates the script of i-th of database template.
Wherein, i=1,2...M.
Step 303, the script for running i-th of database template, generate i-th of database template.
Step 304, acquisition expected data storehouse configuration information.
Step 305, judge obtain expected data storehouse configuration information whether meet preset rules.
Wherein, preset rules are used to exclude irrational expected data storehouse configuration information.
If step 306, the expected data configuration information obtained meet preset rules, M database template of generation is judged
In whether deposit OS Type and desired operation system type, database version and expected data storehouse version, and database accounts for
Internal memory all identical database templates that internal memory and expected data storehouse take.
If specifically, expected data configuration information does not meet preset rules, no longer performing other any operations, terminate whole
Individual flow.
If step 307, in the presence of selection operation system type and desired operation system from M database template of generation
Type is identical, and database version is identical with expected data storehouse version, and the internal memory and expected data storehouse occupancy of database occupancy
One database template of internal memory identical, is used as target data library template.
If step 308, being not present, selection operation system type and desired operation system from M database template of generation
Type of uniting is identical, and database version and expected data storehouse version identical alternate data library template.
Step 309, selection database takes from the alternate data library template selected internal memory and expected data storehouse are accounted for
The absolute difference of internal memory is minimum, and a database of the internal memory less than the internal memory that expected data storehouse takes that database takes
Template, is used as target data library template.
It should be noted that step 307 and step 308,309 being step arranged side by side, step 307 is performed, or perform step
308、309。
Specifically, only when the internal memory that the database of database template takes is less than the internal memory that expected data storehouse takes,
Database could be generated according to database template.
Step 310, according to target database template generation database.
Step 311, acquisition database management instructions.
Sent it should be noted that data base administration order can be user.
Specifically, database management instructions include database delete command, the reset command of database, the closing of database
Order, the adjustment order of the committed memory size of database and the backup command of database;Wherein, when database is in running
After the memory space of middle storage daily record is full, database is caused not continue to run with, so as to need the reset command according to database
Daily record is transferred to another memory space so that obtaining database can continue to operation;When the storage that database is used to store daily record is empty
Between it is smaller in first sub-distribution, but memory space is distributed during being used in the later stage can not cause database within a period of time
Normal operation, so as to need to be adjusted memory space according to the adjustment order of the committed memory size of database.
Step 312, according to database management instructions database is managed.
The generation method for the database that the embodiment of the present invention is provided, obtains the mutually different database configuration information of M groups;
Wherein, M is positive integer;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of number
According to library template;Wherein, i=1,2...M;Obtain expected data storehouse configuration information;According to the expected data storehouse configuration information of acquisition
A database template is selected to be used as target data library template from M database template of generation;According to target database mould
Plate generates database.The technical scheme provided from the present invention, due to generating one according to different database configuration informations
Series data library template, therefore, when creating database, can possess different pieces of information according to the selection of expected data storehouse configuration information
The database template generation database of storehouse configuration information, so that automatically generating for database simply, is easily realized, very big journey
Save human cost degree.
The embodiment of the present invention provides a kind of generating means of database, as shown in figure 4, the generating means 4 include:
First acquisition module 41, for obtaining the mutually different database configuration information of M groups;Wherein, M is positive integer.
First processing module 42, for i-th group of database configuration information in the M group database configuration informations according to acquisition
Generate i-th of database template;Wherein, i=1,2...M.
Second acquisition module 43, for obtaining expected data storehouse configuration information.
Selecting module 44, for being selected according to the expected data storehouse configuration information of acquisition from M database template of generation
A database template is selected as target data library template.
Second processing module 45, for according to target database template generation database.
Further, on the basis of the corresponding embodiments of Fig. 4, the embodiment of the present invention provides the generation dress of another database
Put, as shown in figure 5, first processing module 42 includes:
First generation unit 421, for i-th group of database configuration information of acquisition is included OS Type,
The internal memory that database version and database take inserts the correspondence position of default script, generates the script of i-th of database template.
Second generation unit 422, the script for running i-th of database template, generates i-th of database template.
Selecting module 44 includes:
Whether judging unit 441, the expected data storehouse configuration information for judging to obtain meets preset rules;Wherein, in advance
If providing to be used to exclude irrational expected data storehouse configuration information.
Processing unit 442, if meeting preset rules for the expected data configuration information obtained, according to the expectation number of acquisition
A database template is selected to be used as target data library template from M database template of generation according to storehouse configuration information.
It is further desirable to which database configuration information includes desired operation system type, expected data storehouse version and expects number
The internal memory taken according to storehouse.
Processing unit 442 specifically for:
OS Type and desired operation system type, database whether are deposited in M database template for judging generation
Version and expected data storehouse version, and internal memory all identical database moulds that the internal memory of database occupancy and expected data storehouse take
Plate.
If in the presence of, selection operation system type is identical with desired operation system type from M database template of generation,
Database version is identical with expected data storehouse version, and the internal memory and the internal memory identical of expected data storehouse occupancy of database occupancy
One database template, is used as target data library template.
If being not present, selection operation system type and desired operation system type phase from M database template of generation
Together, and database version and expected data storehouse version identical alternate data library template.
The internal memory for selecting the internal memory that database takes to be taken with expected data storehouse from the alternate data library template selected
Absolute difference it is minimum, and the internal memory that takes of database is less than a database template of the internal memory that expected data storehouse takes, and makees
For target data library template.
Further, on the basis of the corresponding embodiments of Fig. 5, the embodiment of the present invention provides the generation dress of another database
Put, as shown in fig. 6, the generating means 4 also include:
3rd acquisition module 46, for obtaining database management instructions.
3rd processing module 47, for being managed according to database management instructions to the database of generation.
The generating means for the database that the embodiment of the present invention is provided, obtain the mutually different database configuration information of M groups;
Wherein, M is positive integer;I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of number
According to library template;Wherein, i=1,2...M;Obtain expected data storehouse configuration information;According to the expected data storehouse configuration information of acquisition
A database template is selected to be used as target data library template from M database template of generation;According to target database mould
Plate generates database.The technical scheme provided from the present invention, due to generating one according to different database configuration informations
Series data library template, therefore, when creating database, can possess different pieces of information according to the selection of expected data storehouse configuration information
The database template generation database of storehouse configuration information, so that automatically generating for database simply, is easily realized, very big journey
Save human cost degree..
In actual applications, first acquisition module 41, first processing module 42, the life of the first generation unit 421, second
Into unit 422, the second acquisition module 43, selecting module 44, judging unit 441, processing unit 442, Second processing module 45,
Three acquisition modules 46 and the 3rd processing module 46 can be by the central processing unit (Central in the generating means of database
Processing Unit, CPU), microprocessor (Micro Processor Unit, MPU), digital signal processor
(Digital Signal Processor, DSP) or field programmable gate array (Field Programmable Gate
Array, FPGA) etc. realize.
Although disclosed herein embodiment as above, described content be only readily appreciate the present invention and use
Embodiment, is not limited to the present invention.Technical staff in any art of the present invention, is taken off not departing from the present invention
On the premise of the spirit and scope of dew, any modification and change, but the present invention can be carried out in the form and details of implementation
Scope of patent protection, still should be subject to the scope of the claims as defined in the appended claims.
Claims (10)
1. a kind of generation method of database, it is characterised in that including:
Obtain the mutually different database configuration information of M groups;Wherein, M is positive integer;
I-th group of database configuration information in the M group database configuration informations of acquisition generates i-th of database template;Its
In, i=1,2...M;
Obtain expected data storehouse configuration information;
One database template is selected from M database template of generation according to the expected data storehouse configuration information of acquisition
It is used as target data library template;
According to the target database template generation database.
2. generation method according to claim 1, it is characterised in that i-th group of number in the M groups database configuration information
Include the internal memory that OS Type, database version and database take, the M group numbers according to acquisition according to storehouse configuration information
I-th of database template is generated according to i-th group of database configuration information in the configuration information of storehouse, including:
The OS Type that i-th group of database configuration information of acquisition is included, the database version and
The internal memory that the database takes inserts the correspondence position of default script, generates the script of i-th of database template;
The script of i-th of database template is run, i-th of database template is generated.
3. generation method according to claim 2, it is characterised in that the expected data storehouse configuration information according to acquisition
A database template is selected from M database template of generation as target data library template, including:
Judge whether the expected data storehouse configuration information obtained meets preset rules;Wherein, the preset rules are used to arrange
Except irrational expected data storehouse configuration information;
If the expected data configuration information obtained meets the preset rules, configured according to the expected data storehouse of acquisition
Information selects a database template to be used as target data library template from the M database template of generation.
4. generation method according to claim 3, it is characterised in that expected data storehouse configuration information includes expecting to grasp
Make the internal memory that system type, expected data storehouse version and expected data storehouse take, it is described to be configured according to the expected data storehouse of acquisition
Information selects a database template as target data library template from M database template of generation, including:
OS Type and the desired operation system type whether are deposited in the M database template for judging generation, number
The internal memory all phases taken according to the internal memory of storehouse version and expected data storehouse version, and database occupancy with the expected data storehouse
Same database template;
If in the presence of selection operation system type and the desired operation system type from the M database template of generation
Identical, database version is identical with expected data storehouse version, and the internal memory that database takes is accounted for the expected data storehouse
One database template of internal memory identical, is used as target data library template;
If being not present, selection operation system type and the desired operation system class from the M database template of generation
Type is identical, and database version and the expected data storehouse version identical alternate data library template;
Select what the internal memory that database takes took with the expected data storehouse from the alternate data library template selected
The absolute difference of internal memory is minimum, and a database of the internal memory less than the internal memory that the expected data storehouse takes that database takes
Template, is used as target data library template.
5. the generation method according to claim any one of 1-4, it is characterised in that the target database according to selection
After template generation database, in addition to:
Obtain database management instructions;
The database of generation is managed according to the database management instructions.
6. a kind of generating means of database, it is characterised in that including:
First acquisition module, for obtaining the mutually different database configuration information of M groups;Wherein, M is positive integer;
First processing module, for i-th group of database configuration information generation the in the M group database configuration informations according to acquisition
I database template;Wherein, i=1,2...M;
Second acquisition module, for obtaining expected data storehouse configuration information;
Selecting module, for being selected according to the expected data storehouse configuration information of acquisition from M database template of generation
One database template is used as target data library template;
Second processing module, for according to the target database template generation database.
7. generating means according to claim 6, it is characterised in that i-th group of number in the M groups database configuration information
Include the internal memory that OS Type, database version and database take according to storehouse configuration information;
The first processing module includes:
First generation unit, for i-th group of database configuration information of acquisition is included the OS Type,
The internal memory that the database version and the database take inserts the correspondence position of default script, generates i-th of database mould
The script of plate;
Second generation unit, the script for running i-th of database template generates i-th of database template.
8. generating means according to claim 7, it is characterised in that the selecting module includes:
Whether judging unit, the expected data storehouse configuration information for judging to obtain meets preset rules;Wherein, it is described pre-
If providing to be used to exclude irrational expected data storehouse configuration information;
Processing unit, if meeting the preset rules for the expected data configuration information obtained, according to acquisition
Expected data storehouse configuration information selects a database template to be used as target database from the M database template of generation
Template.
9. generating means according to claim 8, it is characterised in that expected data storehouse configuration information includes expecting to grasp
Make the internal memory that system type, expected data storehouse version and expected data storehouse take;The processing unit specifically for:
OS Type and the desired operation system type whether are deposited in the M database template for judging generation, number
The internal memory all phases taken according to the internal memory of storehouse version and expected data storehouse version, and database occupancy with the expected data storehouse
Same database template;
If in the presence of selection operation system type and the desired operation system type from the M database template of generation
Identical, database version is identical with expected data storehouse version, and the internal memory that database takes is accounted for the expected data storehouse
One database template of internal memory identical, is used as target data library template;
If being not present, selection operation system type and the desired operation system class from the M database template of generation
Type is identical, and database version and the expected data storehouse version identical alternate data library template;
Select what the internal memory that database takes took with the expected data storehouse from the alternate data library template selected
The absolute difference of internal memory is minimum, and a database of the internal memory less than the internal memory that the expected data storehouse takes that database takes
Template, is used as target data library template.
10. the generating means according to claim any one of 6-9, it is characterised in that also include:
3rd acquisition module, for obtaining database management instructions;
3rd processing module, for being managed according to the database management instructions to the database of generation.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710609268.9A CN107247812B (en) | 2017-07-25 | 2017-07-25 | Database generation method and generation device |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN201710609268.9A CN107247812B (en) | 2017-07-25 | 2017-07-25 | Database generation method and generation device |
Publications (2)
Publication Number | Publication Date |
---|---|
CN107247812A true CN107247812A (en) | 2017-10-13 |
CN107247812B CN107247812B (en) | 2021-01-15 |
Family
ID=60011805
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN201710609268.9A Active CN107247812B (en) | 2017-07-25 | 2017-07-25 | Database generation method and generation device |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN107247812B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN109492057A (en) * | 2018-10-26 | 2019-03-19 | 深圳点猫科技有限公司 | A kind of educational system is used for Hive offline computing method and electronic equipment |
CN110968565A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Database creation method and system |
Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104102511A (en) * | 2014-07-17 | 2014-10-15 | 福建星海通信科技有限公司 | SQL (structured query language) Server based automatic script upgrading system and method |
CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
CN106326380A (en) * | 2016-08-15 | 2017-01-11 | 北京和兑科技有限公司 | Commodity cloud database creating method and device |
-
2017
- 2017-07-25 CN CN201710609268.9A patent/CN107247812B/en active Active
Patent Citations (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104717233A (en) * | 2013-12-11 | 2015-06-17 | 中国电信股份有限公司 | Database deployment method and device |
CN104102511A (en) * | 2014-07-17 | 2014-10-15 | 福建星海通信科技有限公司 | SQL (structured query language) Server based automatic script upgrading system and method |
CN104408118A (en) * | 2014-11-25 | 2015-03-11 | 北京国双科技有限公司 | Database establishing method and device |
CN106326380A (en) * | 2016-08-15 | 2017-01-11 | 北京和兑科技有限公司 | Commodity cloud database creating method and device |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN110968565A (en) * | 2018-09-30 | 2020-04-07 | 北京国双科技有限公司 | Database creation method and system |
CN109492057A (en) * | 2018-10-26 | 2019-03-19 | 深圳点猫科技有限公司 | A kind of educational system is used for Hive offline computing method and electronic equipment |
Also Published As
Publication number | Publication date |
---|---|
CN107247812B (en) | 2021-01-15 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN106649378B (en) | Data synchronization method and device | |
RU2005136461A (en) | METHOD AND SYSTEM FOR CONTROL OF ACCESS TO INFORMATION ABOUT PRESENCE AT A BASIS | |
US20160012150A1 (en) | System and method for main distribution network graph/model/data integration based on remote access and information interaction | |
WO2015031486A1 (en) | System and method for virtual assistants with shared capabilities and agent store | |
CN107908521A (en) | A kind of monitoring method of container performance on the server performance and node being applied under cloud environment | |
CN104484469B (en) | One kind supports more non-stop-machine expansion methods of hash map data base cluster systems | |
CN111162520B (en) | Power grid mapping method and system | |
WO2016133534A1 (en) | An automatically invoked unified visualization interface | |
CN107247812A (en) | The generation method and generating means of a kind of database | |
CN110858194A (en) | Method and device for expanding database | |
US20200389366A1 (en) | Method for managing multiple servers and device employing method | |
WO2014040488A1 (en) | Method and device for guaranteeing consistency of planning data | |
CN107357522A (en) | Data processing method and device | |
CN109286545A (en) | A kind of smart home device management method and device | |
TW201933851A (en) | Service update method and device, system | |
CN103516857B (en) | A kind of method and apparatus that contact head image is set | |
CN105786925A (en) | Reference model based dynamic data modeling method and apparatus | |
CN106156044B (en) | Database switching method and device | |
CN113312052A (en) | Component calling method and device, electronic equipment and storage medium | |
CN107436883A (en) | The method, apparatus and system of data pick-up based on complementation | |
CN112256760B (en) | Data prediction method and device, computer equipment and storage medium | |
CN104317916A (en) | Device and method for expanding business receipts of data association unit | |
CN106294721A (en) | A kind of company-data statistics and deriving method and device | |
CN106803285A (en) | A kind of self-defined orientation generation method and device of AR books | |
CN113296969A (en) | Information processing method and device and electronic equipment |
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 | ||
TA01 | Transfer of patent application right |
Effective date of registration: 20201207 Address after: 215100 No. 1 Guanpu Road, Guoxiang Street, Wuzhong Economic Development Zone, Suzhou City, Jiangsu Province Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd. Address before: 450018 Henan province Zheng Dong New District of Zhengzhou City Xinyi Road No. 278 16 floor room 1601 Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd. |
|
TA01 | Transfer of patent application right | ||
GR01 | Patent grant | ||
GR01 | Patent grant |