CN104717233B - Database portion arranging method and device - Google Patents
Database portion arranging method and device Download PDFInfo
- Publication number
- CN104717233B CN104717233B CN201310671059.9A CN201310671059A CN104717233B CN 104717233 B CN104717233 B CN 104717233B CN 201310671059 A CN201310671059 A CN 201310671059A CN 104717233 B CN104717233 B CN 104717233B
- Authority
- CN
- China
- Prior art keywords
- database
- library
- template
- newdata
- module
- 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.)
- Active
Links
Classifications
-
- H—ELECTRICITY
- H04—ELECTRIC COMMUNICATION TECHNIQUE
- H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
- H04L41/00—Arrangements for maintenance, administration or management of data switching networks, e.g. of packet switching networks
- H04L41/02—Standardisation; Integration
- H04L41/024—Standardisation; Integration using relational databases for representation of network management data, e.g. managing via structured query language [SQL]
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/10—File systems; File servers
- G06F16/13—File access structures, e.g. distributed indices
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Computer Networks & Wireless Communication (AREA)
- Signal Processing (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The present invention discloses a kind of database portion arranging method and device.Wherein in database portion arranging method, when receiving the newdata library request of database application user transmission, resource packet associated with specified tissue is selected to select corresponding database template in database template associated with the specified tissue library pre-established；The memory space and capacity of database file are set in resource packet, to utilize the database template newdata library of selection；The parameter set in newdata library is set, the username and password in newdata library is set, newdata library access file and newdata library Universally Unique Identifier are generated, the newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to database application user.Consequently facilitating different tissues, different types of database in centralized management cloud platform promote the offer efficiency of cloud platform database service without being concerned about the specific location and deployment process of database.
Description
Technical field
The present invention relates to the communications field, in particular to a kind of database portion arranging method and device.
Background technique
With the development of cloud computing and virtualization technology, many business platforms are all deployed in cloud computing platform (hereinafter referred to as
Cloud platform) unified management virtual machine in, meanwhile, most of business platform contains database part, and initial stage is due to database
Requirement to hardware performance is relatively high, is mounted on independent physical server more, with the maturation and stabilization of virtualization technology,
Most of database also gradually starts directly to be installed and configured on a virtual machine.
Database is main in the deployment way of cloud platform at present are as follows: cloud platform administrator disposes database particular virtual first
Machine simultaneously installs operating system, by database administrator by figure or command line mode access of virtual machine operating system, pacifies manually
Dress database software simultaneously configures custom parameter, and other software modules of business platform pass through network IP(Internet
Protocol, Internet protocol) service of addresses access data library.The way to manage of database has following several in existing cloud platform
Point problem:
First: quantity database constantly increases in cloud platform, and the database from different departments and business is mixed in together.
Cloud platform administrator lacks the global monitoring view and managerial ability to database in cloud platform and corresponding virtual resource.Cloud platform
Database is voluntarily installed, configures and is monitored by service management person, influences database to the service efficiency of virtual resource.
Second: it is longer the time required to the deployment of cloud platform database and configuration, it can only voluntarily be manually completed by service management person,
It is higher to the database configuration of database application user and technical requirements.
Third: the work such as mass data qurush grade, clone, Backup and Restore and security hardening can only be by business pipe in cloud platform
Reason person voluntarily manually completes, and can not accomplish by cloud platform administrator United Dispatching and implementation.Reduce database in cloud platform
Operational efficiency increases the security risk of database and cloud platform itself in cloud platform.
Summary of the invention
The embodiment of the present invention provides a kind of database portion arranging method and device.By being managed to database in cloud platform is unified
Reason, installation, distribution and configuration optimization reduce user's request for data to provide a user faster easy-to-use database service
The integral deployment time in library and difficulty.Realize that cloud platform carries the unified monitoring of database resource, tune by organizational structure management
Degree and life cycle management improve the management regulation of database in cloud platform.By unified upgrading, clone, Backup and Restore and
Security hardening reduces the complexity of database maintenance in cloud platform.
According to an aspect of the present invention, a kind of database portion arranging method is provided, comprising:
When receiving the newdata library request of database application user transmission, extracted from the request of newdata library
Specified tissue information and database template information in organizational structure；
Resource packet associated with the specified tissue in organizational structure is selected, to distribute related money for newdata library
Source；
In database template associated with the specified tissue library pre-established, select opposite with database template information
The database template answered；
The memory space and capacity of database file are set in resource packet, so as to newly-built using the database template of selection
Database；
The parameter set in newdata library is set；
The username and password in newdata library is set；
Generate newdata library access file and newdata library Universally Unique Identifier；
The newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to database application
User.
Preferably, when establishing database template library associated with specified tissue, comprising:
Select server cluster using as deployed position in cloud platform；
Organizational structure is established on demand；
It establishes and knits associated resource packet with each of organizational structure；
Establish database template library associated with each tissue；
The database template library of foundation is imported in resource packet associated with respective organization.
Preferably, it establishes with the step of each tissue associated database template library and includes:
For each tissue, at least one virtual machine is established in cloud platform；
The database of needs is installed in the virtual machine of foundation；
The virtual machine of installation database is encapsulated as database template；
Establish default database configuration parameter set.
Preferably, select server cluster to include: as the step of deployed position in cloud platform
Judge in cloud platform with the presence or absence of server cluster；
If the presence server cluster in cloud platform, selected in cloud platform already existing server cluster using as
Deployed position；
If in cloud platform be not present server cluster, in cloud platform New Server cluster using as deployment position
It sets.
According to another aspect of the present invention, a kind of database deployment device, including interface unit, extraction unit, money are provided
Source packet selecting unit, template selection unit, the first setting unit, the second setting unit, third setting unit and information generate single
Member, in which:
Interface unit, the newdata library request that application user in library sends for receiving data；According to information generating unit
Instruction, the newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to database application and uses
Family；
Extraction unit, when for receiving the newdata library request of database application user transmission when interface unit, from
The specified tissue information and database template information in organizational structure are extracted in the request of newdata library；
Resource packet selecting unit, for selecting resource packet associated with the specified tissue in organizational structure, to be new
Build database distribution related resource；
Template selection unit, in database template associated with the specified tissue library pre-established, selection with
The corresponding database template of database template information；
First setting unit, for the memory space and capacity of database file to be arranged in resource packet, to utilize choosing
The database template newdata library selected；
Second setting unit, for the parameter set in newdata library to be arranged；
Third setting unit, for the username and password in newdata library to be arranged；
Information generating unit, for generating newdata library access file and newdata library Universally Unique Identifier；Refer to
Show that the newdata library of generation is accessed file by interface unit and newdata library Universally Unique Identifier is sent to database Shen
It please user.
Preferably, above-mentioned apparatus further includes that template library establishes unit, and it includes cluster selection mould that wherein template library, which establishes unit,
Block, organizational structure establish module, resource packet establishes module, template library establishes module and template library import modul, in which:
Cluster selecting module, for being selected in cloud platform when establishing database template library associated with specified tissue
Server cluster is selected using as deployed position；
Organizational structure establishes module, for establishing organizational structure on demand；
Resource packet establishes module, knits associated resource packet with each of organizational structure for establishing；
Template library establishes module, for establishing database template library associated with each tissue；
Template library import modul, the database template library for that will establish import resource packet associated with respective organization
In.
Preferably, it includes that virtual machine establishes module, installation module, package module and parameter set foundation that template library, which establishes module,
Module, in which:
Virtual machine establishes module, and for being directed to each tissue, at least one virtual machine is established in cloud platform；
Module is installed, for installing the database of needs in the virtual machine of foundation；
Package module, for the virtual machine of installation database to be encapsulated as database template；
Parameter set establishes module, for establishing default database configuration parameter set.
Preferably, cluster selecting module includes identification module and selecting module, in which:
Identification module, for judging in cloud platform with the presence or absence of server cluster；
Selecting module, for the judging result according to identification module, if the presence server cluster in cloud platform, in cloud
Select already existing server cluster using as deployed position in platform；If server cluster is not present in cloud platform,
New Server cluster is using as deployed position in cloud platform.
The present invention by select relevant database module in the associated database template library of specified tissue, according to
The memory space and capacity of setting utilize the database module newdata library of selection.Consequently facilitating in centralized management cloud platform
Different tissues, different types of database promote cloud platform data without being concerned about the specific location and deployment process of database
The offer efficiency of library service.
Detailed description of the invention
In order to more clearly explain the embodiment of the invention or the technical proposal in the existing technology, 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
Some embodiments of invention without any creative labor, may be used also for those of ordinary skill in the art
To obtain other drawings based on these drawings.
Fig. 1 is the schematic diagram of database portion arranging method one embodiment of the present invention.
Fig. 2 is the schematic diagram that the present invention establishes database template library one embodiment.
Fig. 3 is the schematic diagram that the present invention establishes database template one embodiment.
Fig. 4 is the schematic diagram that database of the present invention disposes device one embodiment.
Fig. 5 is the schematic diagram that database of the present invention disposes another embodiment of device.
Fig. 6 is the schematic diagram that template library of the present invention establishes unit one embodiment.
Fig. 7 is the schematic diagram that template library of the present invention establishes module one embodiment.
Fig. 8 is the schematic diagram of cluster selecting module one embodiment of the present invention.
Fig. 9 is the schematic diagram of cloud platform database management system architecture one embodiment of the present invention.
Figure 10 is the schematic diagram of cloud database management platform framework one embodiment of the present invention.
Figure 11 is the schematic diagram of database interface module one embodiment of the present invention.
Figure 12 is the schematic diagram of database management services module one embodiment of the present invention.
Figure 13 is the schematic diagram of policy service management module one embodiment of the present invention.
Figure 14 is the schematic diagram that cloud computing architecture of the present invention integrates module one embodiment.
Specific embodiment
Following will be combined with the drawings in the embodiments of the present invention, and technical solution in the embodiment of the present invention carries out clear, complete
Site preparation description, it is clear that described embodiments are only a part of the embodiments of the present invention, instead of all the embodiments.Below
Description only actually at least one exemplary embodiment be it is illustrative, never as to the present invention and its application or make
Any restrictions.Based on the embodiments of the present invention, those of ordinary skill in the art are not making creative work premise
Under every other embodiment obtained, shall fall within the protection scope of the present invention.
Unless specifically stated otherwise, positioned opposite, the digital table of the component and step that otherwise illustrate in these embodiments
It is not limited the scope of the invention up to formula and numerical value.
Simultaneously, it should be appreciated that for ease of description, the size of various pieces shown in attached drawing is not according to reality
Proportionate relationship draw.
Technology, method and apparatus known to person of ordinary skill in the relevant may be not discussed in detail, but suitable
In the case of, the technology, method and apparatus should be considered as authorizing part of specification.
It is shown here and discuss all examples in, any occurrence should be construed as merely illustratively, without
It is as limitation.Therefore, the other examples of exemplary embodiment can have different values.
It should also be noted that similar label and letter indicate similar terms in following attached drawing, therefore, once a certain Xiang Yi
It is defined in a attached drawing, then in subsequent attached drawing does not need that it is further discussed.
Fig. 1 is the schematic diagram of database portion arranging method one embodiment of the present invention.As shown in Figure 1, the method for the present embodiment
Steps are as follows:
Step 101, it when receiving the newdata library request of database application user transmission, is requested from newdata library
In extract specified tissue information and database template information in organizational structure.
Step 102, resource packet associated with the specified tissue in organizational structure is selected, to be the distribution of newdata library
Related resource.
For example, related resource includes CPU(Central Processing Unit needed for database, central processing list
Member) and memory source.
Step 103, in database template associated with the specified tissue library pre-established, selection and database template
The corresponding database template of information.
Step 104, the memory space and capacity of database file are set in resource packet, to utilize the database of selection
Template newdata library.
Step 105, the parameter set in newdata library is set.
Step 106, the username and password in newdata library is set.
Step 107, newdata library access file and newdata library Universally Unique Identifier (Universally are generated
Unique Identifier, abbreviation: UUID).
Step 108, the newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to number
Apply for user according to library.
Based on the database portion arranging method that the above embodiment of the present invention provides, by data associated with specified tissue
Relevant database module is selected in library template library, according to the memory space and capacity of setting, utilizes the database module of selection
Newdata library.Consequently facilitating different tissues, different types of database in centralized management cloud platform, without being concerned about database
Specific location and deployment process, promoted cloud platform database service offer efficiency.
Fig. 2 is the schematic diagram that the present invention establishes database template library one embodiment.As shown in Fig. 2, the side of the present embodiment
Method step includes:
Step 201, when establishing database template library associated with specified tissue, server set is selected in cloud platform
Group is using as deployed position.
For example, several service servers can form a virtual cluster, the shared and United Dispatching of resource is realized.
Preferably, when selecting server cluster, judge in cloud platform with the presence or absence of server cluster.If in cloud platform
Middle presence server cluster then selects already existing server cluster using as deployed position in cloud platform；If flat in cloud
Server cluster is not present in platform, then in cloud platform New Server cluster using as deployed position.
Step 202, organizational structure is established on demand.
For example, establishing a company organization X, establishes two subordinaties and organize A, B, and establish two database administrator, point
The administration authority of tissue A, B are not authorized.
Step 203, it establishes and knits associated resource packet with each of organizational structure.
For example, establishing a resource packet, several physical servers in cloud platform cluster are selected, are used for subsequent carrying number
According to library, settable following parameter:
1) share (total amount is no more than physical resource) of CPU and memory source, reserved (the resource lower limit of minimum guarantee),
It limits (current upper bound can adjust in the later period no more than total amount)；
2) memory space (based on the logical memory blocks imported in the shared storage of cloud platform)；
3) network configuration (the shared network parameter of this resource packet, including VLAN(Virtual Local Area
Network, virtual LAN), netmask, gateway, DNS(Domain Name System, domain name system) and can be distributively
Location section).
Step 204, database template library associated with each tissue is established.
Step 205, the database template library of foundation is imported in resource packet associated with respective organization.
Preferably, in the present embodiment, a virtual machine can be established after step 201, this reality is executed by the virtual machine
Apply other steps of example.The wherein settable following parameter of virtual machine:
1) system administration network settings, including IP address, gateway and DNS；
2) cloud platform management VLAN and IP address, for calling virtualization layer interface；
3) internal network communication VLAN is communicated for database and this system；
4) Administrator account.
Fig. 3 is the schematic diagram that the present invention establishes database template one embodiment.As shown in figure 3, above-mentioned steps 204 are specific
It comprises the following methods:
Step 301, for each tissue, at least one virtual machine is established in cloud platform.
Step 302, the database of needs is installed in the virtual machine of foundation.
Step 303, the virtual machine of installation database is encapsulated as database template.
Step 304, default database configuration parameter set is established.
Fig. 4 is the schematic diagram that database of the present invention disposes device one embodiment.As shown in figure 4, the device includes interface
Unit 401, extraction unit 402, resource packet selecting unit 403, template selection unit 404, the first setting unit 405, second set
Set unit 406, third setting unit 407 and information generating unit 408, in which:
Interface unit 401, the newdata library request that application user in library sends for receiving data；It is generated according to information single
The newdata library of generation is accessed file and newdata library Universally Unique Identifier is sent to database by the instruction of member 408
Apply for user.
Extraction unit 402, for receiving the newdata library request of database application user transmission when interface unit 401
When, the specified tissue information and database template information in organizational structure are extracted from the request of newdata library.
Resource packet selecting unit 403, for selecting resource packet associated with the specified tissue in organizational structure, so as to for
Related resource is distributed in newdata library.
Template selection unit 404, for selecting in database template associated with the specified tissue library pre-established
Database template corresponding with database template information.
First setting unit 405, for the memory space and capacity of database file to be arranged in resource packet, to utilize
The database template newdata library of selection.
Second setting unit 406, for the parameter set in newdata library to be arranged.
Third setting unit 407, for the username and password in newdata library to be arranged.
Information generating unit 408, for generating newdata library access file and newdata library Universally Unique Identifier；
Indicate that the newdata library of generation is accessed file by interface unit 401 and newdata library Universally Unique Identifier is sent to data
Apply for user in library.
Device is disposed based on the database that the above embodiment of the present invention provides, by data associated with specified tissue
Relevant database module is selected in library template library, according to the memory space and capacity of setting, utilizes the database module of selection
Newdata library.Consequently facilitating different tissues, different types of database in centralized management cloud platform, without being concerned about database
Specific location and deployment process, promoted cloud platform database service offer efficiency.
Fig. 5 is the schematic diagram that database of the present invention disposes another embodiment of device.Compared with embodiment illustrated in fig. 4, in Fig. 5
It further include that template library establishes unit 501, for establishing database template library in illustrated embodiment.
Fig. 6 is the schematic diagram that template library of the present invention establishes unit one embodiment.As shown in fig. 6, template library establishes unit
Module 602 is established including cluster selecting module 601, organizational structure, resource packet establishes module 603, template library establishes 604 and of module
Template library import modul 605.Wherein:
Cluster selecting module 601 is used for when establishing database template library associated with specified tissue, in cloud platform
Select server cluster using as deployed position.
Organizational structure establishes module 602, for establishing organizational structure on demand.
Resource packet establishes module 603, knits associated resource packet with each of organizational structure for establishing.
Template library establishes module 604, for establishing database template library associated with each tissue.
Template library import modul 605, the database template library for that will establish import resource associated with respective organization
Bao Zhong.
Fig. 7 is the schematic diagram that template library of the present invention establishes module one embodiment.As shown in fig. 7, template library establishes module
Module 701, installation module 702, package module 703 and parameter set, which are established, including virtual machine establishes module 704.Wherein:
Virtual machine establishes module 701, and for being directed to each tissue, at least one virtual machine is established in cloud platform.
Module 702 is installed, for installing the database of needs in the virtual machine of foundation.
Package module 703, for the virtual machine of installation database to be encapsulated as database template.
Parameter set establishes module 704, for establishing default database configuration parameter set.
Fig. 8 is the schematic diagram of cluster selecting module one embodiment of the present invention.As shown in figure 8, cluster selecting module includes
Identification module 801 and selecting module 802.Wherein:
Identification module 801, for judging in cloud platform with the presence or absence of server cluster.
Selecting module 802, for the judging result according to identification module 801, if the presence server cluster in cloud platform,
Then select already existing server cluster using as deployed position in cloud platform；If server set is not present in cloud platform
Group, then in cloud platform New Server cluster using as deployed position.
Cloud platform database management system architecture is described below.As shown in figure 9, the system includes cloud data depositary management
Platform 901, cloud computing virtual platform 902, set of physical resources 903 and cloud computing manage platform 904.Wherein:
Cloud database management platform 901: service management person can be browsed and be managed the data of my application by this system
Library, cloud platform administrator can be disposed and be managed all cloud platform databases by this system.This system is virtual using cloud computing
Change the interface schedule virtual resource that platform 902 provides, while receiving the management of cloud computing management platform 904.Wherein in cloud data
It is equipped with database of the present invention in depositary management platform and disposes device.
Cloud computing virtual platform 902: unified management set of physical resources 903 provides for cloud database management platform 901
Virtual resource interface.
Set of physical resources 903: including CPU, memory, storage and network interface resources.
Cloud computing manages platform 904: being managed collectively all cloud computing related resources, realizes virtual including database
Machine manage and dispatch, by cloud platform, administrator is operated, while can manage cloud database management platform 901 with calling interface.
Figure 10 is the schematic diagram of cloud database management platform framework one embodiment of the present invention.As shown in Figure 10, cloud data
Depositary management platform includes database interface module 1001, database management services module 1002, tactical management service module 1003
Module 1004 is integrated with cloud computing architecture.Wherein:
Database interface module 1001, as shown in figure 11, including Oracle interface (Oracle Call Interface, letter
Claim: OCI), MySQL interface (C language API) and Postgres interface (Libpq interface) kind database interface module, may be used also certainly
The interface module for supporting other databases to be added on demand.The API and modification configuration file for calling these databases to provide can
To complete automatic installation database, the in a pre-installation configuration of custom parameter modification database, after being installed or replicate data library
The unique instance of modification database identifies SID automatically afterwards.
Database management services module 1002, as shown in figure 12, it may include following module:
Database disposes functional module: receiving the parameter configuration and the selection of database template of user's input, calls corresponding
Database interface module disposes database in specified tissue and storage location on demand, and completes parameter configuration.
Database update module: according to user's selection or specified template, single or multiple same templates is automatically updated and are generated
Database, realize batch data library patch update.
Data base backup recovery module: the virtualization interface module in virtualization interface is called, using virtual
The clone of machine or snapshot functions generate the backup file of Database Virtual Machine, realize the backup and recovery of database.
Database cloning module: the virtualization interface module in virtualization interface is called, virtual machine is utilized
Cloning function directly generates the copy of Database Virtual Machine, needs to modify the unique identifier of database instance.
Database resource monitoring module: the schedule virtual resources module in virtualization interface is called to obtain database empty
The operating index and performance parameter of quasi- machine obtain the common performance indicator of database using script built-in in database template,
And it is presented in platform interface by patterned mode.
Outside function interface module: providing the interface API of above functions module, calls for external cloud management platform.
Tactical management service module 1003, as shown in figure 13, it may include following module:
Organizational structure management module: logical hierarchy management, a kind of tissue are carried out to user, tissue and database in cloud platform
Method is to set certain company as top layer tissue, and internal difference departments are second level tissue, the artificial user of each department's database application, respectively
Storage frequently-used data library template and database instance in Departmental organization.
Safety management module: the various functions in platform are assigned as several permissions.For pipe needed for user's setting
Permission is managed, while administration authority can be divided according to tissue and each database, realizes that each user is only capable of browsing or managing referring to
Fixed database.
Template management module: it is responsible for generating and manages all database templates, provide and be encapsulated as Database Virtual Machine
The function of template, and corresponding database interface module can be called, self-defining data library template preset parameter.
Cloud computing architecture integrates module 1004, as shown in figure 14, it may include following module:
Schedule virtual resources module: by calling virtualization interface module, using the resource reservation function of resource packet,
The virtual resource upper limit, lower limit and the amplitude of variation of specified database are set, realize the service quality guarantee of operation system database
(QoS).
Virtualization interface module: the management function of virtual machine by calling external cloud computing virtual platform provides
The functional interfaces such as virtual machine open and close, clone, snapshot.Including tri- kinds of virtualization interfaces of VMware, Xen and Hyper-V.
For example, user logs in this system, is created first by organizational structure management module or selection is organized, be recorded in
In institutional framework table.Following user distributes virtual resource packet by schedule virtual resources module, for the tissue, and system passes through void
Quasi-ization functional interface module and cloud computing platform communication, realize virtual resource allocation.Then user is new by template management module
Database template is built, system needs that virtualization interface module is called to create template virtual machine, recalls corresponding database
Interface module installs in virtual machine, configuration database.
Then user uses database deployment module, established tissue, database template is selected, in designated storage location
Newdata library, and optional customized database configuration parameters.Database deployment module calls virtualization interface in system
Clone data library template generates the virtual machine and database of specified configuration, and inputs modification database parameter according to user.Finally
System collects database UUID, username and password, exports as database access file, is downloaded for user to connect data
Library.
By applying the present invention, it is available following the utility model has the advantages that
1, the virtualization of database is realized, for users, without the specific location and deployment process of being concerned about database.Cloud
Platform administrator can manage different tissues in cloud platform, different types of database concentratedly.
2, the life cycle and resource of database are managed concentratedly.According to preconfigured database template, parameter template and
Organizational structure, administrator can be convenient the whole life cycle and customized details for efficiently managing cloud platform database.
3, the database update and database service providing method automated promotes the offer effect of cloud platform database service
Rate, so that service-user and cloud platform administrator are not required to understand in depth to database technical detail.
Those of ordinary skill in the art will appreciate that realizing that all or part of the steps of above-described embodiment can pass through hardware
It completes, relevant hardware can also be instructed to complete by program, the program can store in a kind of computer-readable
In storage medium, storage medium mentioned above can be read-only memory, disk or CD etc..
Description of the invention is given for the purpose of illustration and description, and is not exhaustively or will be of the invention
It is limited to disclosed form.Many modifications and variations are obvious for the ordinary skill in the art.It selects and retouches
It states embodiment and is to more preferably illustrate the principle of the present invention and practical application, and those skilled in the art is enable to manage
The solution present invention is to design various embodiments suitable for specific applications with various modifications.
Claims (6)
1. a kind of database portion arranging method characterized by comprising
When receiving the newdata library request of database application user transmission, tissue is extracted from the request of newdata library
Specified tissue information and database template information in framework；
Resource packet associated with the specified tissue in organizational structure is selected, to distribute related resource for newdata library；
In database template associated with the specified tissue library pre-established, select corresponding with database template information
Database template；
The memory space and capacity of database file are set in resource packet, to utilize the database template newdata of selection
Library；
The parameter set in newdata library is set；
The username and password in newdata library is set；
Generate newdata library access file and newdata library Universally Unique Identifier；
The newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to database application user；
Wherein when establishing database template library associated with specified tissue, comprising:
Select server cluster using as deployed position in cloud platform；
Organizational structure is established on demand；
It establishes and knits associated resource packet with each of organizational structure；
Establish database template library associated with each tissue；
The database template library of foundation is imported in resource packet associated with respective organization.
2. the method according to claim 1, wherein
It establishes with the step of each tissue associated database template library and includes:
For each tissue, at least one virtual machine is established in cloud platform；
The database of needs is installed in the virtual machine of foundation；
The virtual machine of installation database is encapsulated as database template；
Establish default database configuration parameter set.
3. the method according to claim 1, wherein
Select server cluster to include: as the step of deployed position in cloud platform
Judge in cloud platform with the presence or absence of server cluster；
If the presence server cluster in cloud platform, select already existing server cluster using as deployment in cloud platform
Position；
If server cluster is not present in cloud platform, New Server cluster is using as deployed position in cloud platform.
4. a kind of database disposes device, which is characterized in that including interface unit, extraction unit, resource packet selecting unit, template
Unit, template selection unit, the first setting unit, the second setting unit, third setting unit and information generating unit are established in library,
Wherein:
Interface unit, the newdata library request that application user in library sends for receiving data；According to the finger of information generating unit
Show, the newdata library of generation is accessed into file and newdata library Universally Unique Identifier is sent to database application user；
Extraction unit, when for receiving the newdata library request of database application user transmission when interface unit, from newly-built
The specified tissue information and database template information in organizational structure are extracted in database request；
Resource packet selecting unit, for selecting resource packet associated with the specified tissue in organizational structure, to be newly-built number
Related resource is distributed according to library；
Template library establishes unit, comprising:
Cluster selecting module, for selecting clothes in cloud platform when establishing database template library associated with specified tissue
Device cluster be engaged in using as deployed position；
Organizational structure establishes module, for establishing organizational structure on demand；
Resource packet establishes module, knits associated resource packet with each of organizational structure for establishing；
Template library establishes module, for establishing database template library associated with each tissue；
Template library import modul, the database template library for that will establish import in resource packet associated with respective organization；
Template selection unit, in database template associated with the specified tissue library pre-established, selection and data
The corresponding database template of library template information；
First setting unit, for the memory space and capacity of database file to be arranged in resource packet, to utilize selection
Database template newdata library；
Second setting unit, for the parameter set in newdata library to be arranged；
Third setting unit, for the username and password in newdata library to be arranged；
Information generating unit, for generating newdata library access file and newdata library Universally Unique Identifier；Instruction connects
The newdata library of generation is accessed file to mouth unit and newdata library Universally Unique Identifier is sent to database application and uses
Family.
5. device according to claim 4, which is characterized in that it includes that virtual machine establishes module, peace that template library, which establishes module,
Die-filling piece, package module and parameter set establish module, in which:
Virtual machine establishes module, and for being directed to each tissue, at least one virtual machine is established in cloud platform；
Module is installed, for installing the database of needs in the virtual machine of foundation；
Package module, for the virtual machine of installation database to be encapsulated as database template；
Parameter set establishes module, for establishing default database configuration parameter set.
6. device according to claim 4, which is characterized in that cluster selecting module includes identification module and selecting module,
Wherein:
Identification module, for judging in cloud platform with the presence or absence of server cluster；
Selecting module, for the judging result according to identification module, if the presence server cluster in cloud platform, in cloud platform
It is middle to select already existing server cluster using as deployed position；If server cluster is not present in cloud platform, in cloud
New Server cluster is using as deployed position in platform.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310671059.9A CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201310671059.9A CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN104717233A CN104717233A (en) | 2015-06-17 |
| CN104717233B true CN104717233B (en) | 2019-03-19 |
Family
ID=53416194
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201310671059.9A Active CN104717233B (en) | 2013-12-11 | 2013-12-11 | Database portion arranging method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN104717233B (en) |
Families Citing this family (14)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN106020857A (en) * | 2016-04-06 | 2016-10-12 | 杭州沃趣科技股份有限公司 | Automatic disposition method used for Oracle Real Application Cluster database cluster |
| CN107665141B (en) * | 2016-07-27 | 2020-12-29 | 腾讯科技（深圳）有限公司 | Database configuration method and equipment thereof |
| CN107818104B (en) * | 2016-09-13 | 2021-12-14 | 腾讯科技（深圳）有限公司 | Database deployment method, database deployment device, control equipment and system |
| CN106844643A (en) * | 2017-01-13 | 2017-06-13 | 王洋 | A kind of Database Dynamic generation method based on template engine |
| CN107330682A (en) * | 2017-06-30 | 2017-11-07 | 杭州创匠信息科技有限公司 | A kind of mobile payment deployment system and its method |
| CN107247812B (en) * | 2017-07-25 | 2021-01-15 | 苏州浪潮智能科技有限公司 | Database generation method and generation device |
| CN108959385B (en) * | 2018-05-31 | 2024-02-06 | 康键信息技术（深圳）有限公司 | Database deployment method, device, computer equipment and storage medium |
| CN108920685B (en) * | 2018-07-12 | 2021-11-26 | 郑州云海信息技术有限公司 | Management method and device for database in cloud data system |
| CN109522295B (en) * | 2018-11-16 | 2021-07-20 | 中国银行股份有限公司 | Automatic database object constructing and deploying method and device |
| CN111581179A (en) * | 2019-02-19 | 2020-08-25 | 上海云桓信息科技有限公司 | Data migration method and tool from Oracle to MySQL |
| CN110781189B (en) * | 2019-10-25 | 2022-08-26 | 北京达佳互联信息技术有限公司 | Document platform construction method and device, electronic equipment and storage medium |
| CN112579143A (en) * | 2020-12-24 | 2021-03-30 | 江苏杰瑞信息科技有限公司 | Management platform system for designing software information security |
| CN113076112A (en) * | 2021-04-07 | 2021-07-06 | 网易（杭州）网络有限公司 | Database deployment method and device and electronic equipment |
| CN113778462A (en) * | 2021-09-14 | 2021-12-10 | 中国电信集团系统集成有限责任公司 | Method for personalized configuration of operating system and intelligent integration platform |
Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| CN102880715A (en) * | 2012-10-09 | 2013-01-16 | 南京市测绘勘察研究院有限公司 | Data pool management method and data pool management system on basis of cloud storage |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20130325890A1 (en) * | 2012-05-31 | 2013-12-05 | Ca, Inc. | Leveraging persisted data queries in stream-based complex event processing |
-
2013
- 2013-12-11 CN CN201310671059.9A patent/CN104717233B/en active Active
Patent Citations (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN101477549A (en) * | 2009-01-20 | 2009-07-08 | 中国测绘科学研究院 | Knowledge base supported spatial database design method |
| CN102880715A (en) * | 2012-10-09 | 2013-01-16 | 南京市测绘勘察研究院有限公司 | Data pool management method and data pool management system on basis of cloud storage |
Also Published As
| Publication number | Publication date |
|---|---|
| CN104717233A (en) | 2015-06-17 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN104717233B (en) | Database portion arranging method and device | |
| US10652207B2 (en) | Cloud network automation for IP address and DNS record management | |
| CN109906637B (en) | Network slice management system and method in management plane | |
| EP2675127B1 (en) | Method and device for automatically migrating system configuration item | |
| US9760358B2 (en) | System and method for test to production support in a cloud platform environment | |
| CN104781783B (en) | The integrated calculating platform disposed in existing computing environment | |
| CN109600269A (en) | A kind of cloud management platform based on DCOS | |
| US9201702B2 (en) | Integrated cloud data center management | |
| CN108370328B (en) | Management method and device of NFV MANO policy descriptor | |
| US9742688B2 (en) | System and method for supporting service resources and feature sets in a cloud platform environment | |
| US8000260B2 (en) | Method for dynamic information technology infrastructure provisioning | |
| CN105323282A (en) | Enterprise application deployment and management system for multiple tenants | |
| WO2014039866A1 (en) | System and method for providing a service management engine for use with a cloud computing environment | |
| WO2012054160A2 (en) | High availability of machines during patching | |
| WO2014039889A1 (en) | System and method for orchestration of services for use with a cloud computing environment | |
| KR20170024606A (en) | Service orchestration method and apparatus in software-defined networking, and storage medium | |
| WO2014039896A1 (en) | System and method for dynamic modification of service definition packages with a cloud computing environment | |
| CN108111332A (en) | Using the mixing cloud management system and method for SDN | |
| CN114666333A (en) | Control method for cloud computing resource scheduling problem based on multi-tenant theory | |
| US20200092188A1 (en) | System and method for creating, deploying, and administering distinct virtual computer networks | |
| CN110881039B (en) | Cloud security management system | |
| CN112487378A (en) | Tenant authority management system suitable for big data platform | |
| CN106354507A (en) | Enterprise-level application management system and method for operating same | |
| CN115915404A (en) | Network slice deployment system and method based on NFV-MANO | |
| JP2017528855A (en) | Hierarchical subscription management |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| EXSB | Decision made by sipo to initiate substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |