CN105653631A - Database management method and apparatus - Google Patents
Database management method and apparatus Download PDFInfo
- Publication number
- CN105653631A CN105653631A CN201510997388.1A CN201510997388A CN105653631A CN 105653631 A CN105653631 A CN 105653631A CN 201510997388 A CN201510997388 A CN 201510997388A CN 105653631 A CN105653631 A CN 105653631A
- Authority
- CN
- China
- Prior art keywords
- database
- disk
- current account
- resource
- occupation
- 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
- 238000007726 management method Methods 0.000 title claims abstract description 46
- 238000000034 method Methods 0.000 claims abstract description 39
- 239000002699 waste material Substances 0.000 abstract description 2
- 238000002955 isolation Methods 0.000 description 6
- 238000010586 diagram Methods 0.000 description 5
- 230000008901 benefit Effects 0.000 description 4
- 238000004590 computer program Methods 0.000 description 2
- 238000005516 engineering process Methods 0.000 description 2
- 238000005457 optimization Methods 0.000 description 2
- 230000000052 comparative effect Effects 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000012217 deletion Methods 0.000 description 1
- 230000037430 deletion Effects 0.000 description 1
- 230000000694 effects Effects 0.000 description 1
- 230000007613 environmental effect Effects 0.000 description 1
- 230000006870 function Effects 0.000 description 1
- 230000010354 integration Effects 0.000 description 1
- 238000012544 monitoring process Methods 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
- G06F16/217—Database tuning
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0602—Interfaces specially adapted for storage systems specifically adapted to achieve a particular effect
- G06F3/0614—Improving the reliability of storage systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0602—Interfaces specially adapted for storage systems specifically adapted to achieve a particular effect
- G06F3/062—Securing storage systems
- G06F3/0622—Securing storage systems in relation to access
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0628—Interfaces specially adapted for storage systems making use of a particular technique
- G06F3/0629—Configuration or reconfiguration of storage systems
- G06F3/0631—Configuration or reconfiguration of storage systems by allocating resources to storage systems
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F3/00—Input arrangements for transferring data to be processed into a form capable of being handled by the computer; Output arrangements for transferring data from processing unit to output unit, e.g. interface arrangements
- G06F3/06—Digital input from, or digital output to, record carriers, e.g. RAID, emulated record carriers or networked record carriers
- G06F3/0601—Interfaces specially adapted for storage systems
- G06F3/0668—Interfaces specially adapted for storage systems adopting a particular infrastructure
- G06F3/067—Distributed or networked storage systems, e.g. storage area networks [SAN], network attached storage [NAS]
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Human Computer Interaction (AREA)
- Databases & Information Systems (AREA)
- Data Mining & Analysis (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention provides a database management method and apparatus. The method comprises the steps of determining a preset database resource configuration corresponding to a current account; and according to the preset database resource configuration, controlling resource occupation of the current account to a database. Through the database management scheme provided by the invention, the problem of database resource waste can be avoided.
Description
Technical field
The present invention relates to database technical field, particularly relate to a kind of data base management method and device.
Background technology
Cloud database refers to database that is optimised or that be deployed in a virtual computation environmental, and cloud database can realize paying as required, as required expansion, high availability and store the advantages such as integration. A cloud database can simultaneously for different account provides database service, user successfully register and after the database resource asked is configured, the service that cloud database provides can be used, such as: carry out process data by cloud database, store data etc.
Although cloud database can be the offer database service of multiple account at present simultaneously, but existing database management schemes, it is only the reliability of database can be managed, to ensure that database can smoothly as each account provides service. Cloud database can't control for the database resource shared by each account. Such as: it is 5G that a certain account application takies database disk size, still can be smooth when the account has occupied the disk space of 5G in database disk, write data, database then cannot perceive the actual of disk and take space beyond the space applied for, more this phenomenon can not be limited or prevent. Like this, when the database resource taken when account is actual is beyond the database resource applied for, account then can freely use the resource exceeding part, correspondingly, this part resource that account freely uses then cannot create income, will in a disguised form cause the database wasting of resources.
Visible, existing database management schemes is because cannot effectively manage data base resource, and finally causes the database wasting of resources.
Summary of the invention
In view of existing database management schemes is because cannot effectively manage data base resource, and finally cause the problem of the database wasting of resources, it is proposed that the present invention is to provide a kind of data base management method and the device that overcome the problems referred to above.
According to an aspect of the present invention, it provides a kind of data base management method, comprising: determine the presetting database resource distribution that current account is corresponding; And according to described presetting database resource distribution, control current account to the resource occupation of described database.
Preferably, described presetting database resource distribution comprises: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
Preferably, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further: judge whether current account disk occupation value in the database exceeds described disk quota value by file system; If then current account being performed the soft restriction operation of disk.
Preferably, the described step that current account carries out disk soft restriction operation comprises further: display is used to indicate the information that current account actual disk occupation value has exceeded described disk quota value; And/or, the read-write number of times of described database disk unit time is limited to by described current account the predetermined times that disk is carried out read-write operation by the unit time that described database resource disposition comprises.
Preferably, described according to described presetting database resource distribution, control current account the step of the resource occupation of described database to be comprised further: judge whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value; If then interrupting current account to the operation of the disk in described database.
Preferably, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further: the maximum of the bandwidth of current account is controlled to described preset band width values.
Preferably, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further: current account EMS memory occupation maximum in the database is controlled to described internal memory quota value.
Preferably, described method also comprises: the data that data corresponding for current account are corresponding with other accounts of described database service isolated.
Preferably, the step that the described data that data corresponding for current account are corresponding with other accounts of described database service carry out isolating comprises further: controlling described current account only can data corresponding to current account that stores of reading and writing and performing in described database.
According to another aspect of the present invention, it provides a kind of data bank management device, comprising: determination module, for determining the presetting database resource distribution that current account is corresponding; And control module, for according to described presetting database resource distribution, controlling current account to the resource occupation of described database.
Preferably, described presetting database resource distribution comprises: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
Preferably, described control module comprises: the first disk control module, for judging whether current account disk occupation value in the database exceeds described disk quota value by file system; Soft limiting module, if the judged result for described disk control module is yes, then performs the soft restriction operation of disk to current account.
Preferably, described soft limiting module comprises: display module, for showing the information being used to indicate current account actual disk occupation value and having exceeded described disk quota value; And/or, read-write number of times adjusting module, carries out the predetermined times of read-write operation for the read-write number of times of described database disk unit time is limited to unit time that described database resource disposition comprises by described current account to disk.
Preferably, described control module comprises: the 2nd disk control module, for judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value; Hard limiting module, if the judged result for the 2nd disk control module is yes, then interrupts current account to the operation of the disk in described database.
Preferably, described control module comprises: broadband speeds control module, for the maximum of the bandwidth of current account is controlled to described preset band width values.
Preferably, described control module comprises: Memory control module, for current account EMS memory occupation maximum in the database is controlled to described internal memory quota value.
Preferably, described data bank management device also comprises: isolation module, for the data that data corresponding for current account are corresponding with other accounts of described database service being isolated.
Preferably, described isolation module specifically for: controlling described current account only can data corresponding to current account that stores of reading and writing and performing in described database.
The database management schemes that the embodiment of the present invention provides, determine the preset data base resource that account is corresponding, use in the service process that database provides in account, according to the presetting database resource distribution determined to control current account to the resource occupation of described database, to guarantee that the database resource that account can take does not exceed the database resource applied for, thus the resource of database is avoided freely to be taken. Due to the embodiment of the present invention provide database management schemes database is managed time, database resource can not freely be taken, and therefore can not waste database resource.
Above-mentioned explanation is only the general introduction of technical solution of the present invention, in order to the technique means of the present invention can be better understood, and can be implemented according to the content of specification sheets, and in order to above and other objects of the present invention, feature and advantage can be become apparent, below especially exemplified by the specific embodiment of the present invention.
Accompanying drawing explanation
By reading hereafter detailed description of the preferred embodiment, various other advantage and benefit will become clear for those of ordinary skill in the art and understand. Accompanying drawing is only for illustrating the object of preferred implementation, and does not think limitation of the present invention. And in whole accompanying drawing, represent identical parts with identical reference symbol. In the accompanying drawings:
Fig. 1 shows the steps flow chart schematic diagram of a kind of according to an embodiment of the invention data base management method;
Fig. 2 shows the steps flow chart schematic diagram of a kind of according to an embodiment of the invention data base management method;
Fig. 3 shows the steps flow chart schematic diagram of a kind of according to an embodiment of the invention data base management method;
Fig. 4 shows the structural representation of a kind of according to an embodiment of the invention data bank management device; And
Fig. 5 shows the structural representation of a kind of according to an embodiment of the invention data bank management device.
Embodiment
Exemplary embodiment of the present disclosure is described below with reference to accompanying drawings more in detail. Although show exemplary embodiment of the present disclosure in accompanying drawing, it should be understood, however, that the embodiment that can realize the disclosure in a variety of manners and should do not set forth here limits. On the contrary, it is provided that these embodiments are to can more thoroughly understand the disclosure, and can pass on complete for the scope of the present disclosure to the technician of this area.
Embodiment one
With reference to Fig. 1, show the flow chart of steps of a kind of data base management method of the embodiment of the present invention one.
The data base management method of the embodiment of the present invention comprises the following steps:
Step S101: determine the presetting database resource distribution that current account is corresponding.
The service that database can provide for multiple account simultaneously, each account needs presetting database resource distribution before the service using database to provide, database resource disposition is uploaded to database after having preset, and database can determine the presetting database resource distribution that each account is corresponding. Wherein, presetting database resource distribution corresponding to each account that database is served can be the same or different.
Presetting database resource distribution can comprise: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time. Certainly, it is possible to comprise above-mentioned various resource configuration parameter simultaneously. Wherein, the unit time can be the second, minute etc.
Step S102: according to presetting database resource distribution, control current account to the resource occupation of database.
When controlling current account to the resource occupation of database according to presetting database resource distribution, mainly according to concrete resource configuration parameter, the resource occupation of database is controlled. Tool body controlling means can be arranged according to actual demand by those skilled in the art, and this does not do in embodiment of the present invention concrete restriction.
Such as: presetting database resource distribution is disk quota value, then according to disk quota value, the disk space shared by current account is controlled. Such as: presetting database resource distribution is preset band width values, then according to preset bandwidth value, the bandwidth of current account is controlled. Again such as: presetting database resource distribution is disk quota value and preset band width values, while then the disk space shared by current account being controlled according to disk quota value, in addition it is also necessary to according to preset bandwidth value, the bandwidth speed of current account is controlled.
The data base management method that the embodiment of the present invention provides, determine the preset data base resource that account is corresponding, use in the service process that database provides in account, according to the presetting database resource distribution determined to control current account to the resource occupation of described database, to guarantee that the database resource that account can take does not exceed the database resource applied for, thus the resource of database is avoided freely to be taken. Due to the embodiment of the present invention provide database management schemes database is managed time, database resource can not freely be taken, and therefore database resource can not be wasted.
Embodiment two
With reference to Fig. 2, show the flow chart of steps of a kind of data base management method of the embodiment of the present invention two.
The data base management method of the embodiment of the present invention specifically comprises the following steps:
Step S201: the data that data corresponding for current account are corresponding with other accounts of database service are isolated by database.
Owing to data corresponding for each account simultaneously for multiple account provides service, therefore, in order to ensure the security of the data that each account is corresponding, then can be isolated by database, the data of self correspondence only can be operated by each account.
This, see correlation technique, is not done concrete restriction by the concrete scheme data that account is corresponding isolated in the embodiment of the present invention. A kind of by the mode that data corresponding with other accounts of database service for data corresponding for current account carry out isolating it is preferably: controlling current account only can data corresponding to the current account that stores of reading and writing and performing in database.
Step S202: database determines the presetting database resource distribution that current account is corresponding.
Wherein, presetting database resource distribution can comprise: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time. Unit time can be every second, every minute or every millisecond etc.
The embodiment of the present invention comprises for presetting database resource distribution: disk is carried out the predetermined times of read-write operation by disk quota value and unit time, follow-up step is described.
Wherein, the predetermined times that disk is carried out read-write operation by disk quota value and unit time can be arranged according to actual demand by current account user, and certainly, difference is arranged to be needed to pay corresponding service fee. Concrete restriction is not done in the setting of the concrete value in the embodiment of the present invention, disk being carried out by disk quota value and unit time to the predetermined times of read-write operation.
Step S203: by file system, database judges whether current account disk occupation value in a database exceeds disk quota value; If then performing step S204, if not, then performing setting operation.
Wherein, setting operation can be set to continue the current account of monitoring disk occupation value in a database, and judges whether to exceed disk quota value.
Database obtains current account disk occupation value in a database by file system, then compare with default disk quota value, if comparative result is for exceeding, then need the situation that current account takies database disk to control, namely perform step S204.
Preferably, file system is XFS file system. XFS file system is the high level logs file system of SGI exploitation, and XFS has retractility, and stability is strong.
Step S204: current account is performed the soft restriction operation of disk by database.
Current account being carried out when the soft restriction of disk operates can in the following way:
Mode one: display is used to indicate the information that current account actual magnetic takies dish value and exceeded disk quota value.
Such as: show a disk warning information, like this, it may also be useful to by this warning information, the user of current account can learn that shared disk value has reached disk quota value. User then can take to save measure accordingly, such as: the disk space buying a certain size again to database application. Again such as: by the data deletion in database disk to discharge certain disk space.
Mode two: the read-write number of times of database disk unit time is limited to by current account the predetermined times that disk is carried out read-write operation by the unit time that database resource disposition comprises.
Such as: the unit time is the second, it is 1 time that disk is carried out the predetermined times of read-write operation by every second, so, when performing the soft restriction of disk, then to the read-write number of times of database disk p.s., current account is limited to 1 time. Like this, due to disk read or write speed slowly, as the user using current account then by read-write to data volume to perceive available disk space not enough, therefore, user then can take to save measure accordingly.
Mode three: while display is used to indicate the information that current account actual disk occupation value has exceeded described disk quota value, is limited to the predetermined times that disk is carried out read-write operation by the unit time that described database resource disposition comprises by described current account to the read-write number of times of database disk unit time.
When disk is performed soft restriction by mode three, providing user points out such user can clearly recognize Insufficient disk space, then initiatively take measures to save, compared to directly interrupting current account taking further disk space, more can promote the experience of user. Simultaneously, mode three is taked to the mode that the read-write number of times of database disk unit time is limited by current account, very low due to what the read-write number of times of database disk unit time was limited, therefore too many disk space can't be taken, that is, mode three is when ensureing that disk space is not freely taken in a large number, it is also contemplated that the use sense having arrived user is subject to, and improves the experience of user.
It should be noted that, in specific implementation process, when the disk occupation value of database being controlled by current account according to disk quota value, it is not limited to adopt the mode of soft restriction disclosed in the step S203 to step S204 provided in the embodiment of the present invention, it is also possible to adopt the mode of hard restriction to control.
The mode that the disk occupation value of database controls is by the mode that a kind of preferred employing limits firmly by current account: judge whether current account disk occupation value in a database exceeds the first disk quota value by file system, wherein, the first disk quota value is greater than disk quota value; If then interrupting current account to the operation of the disk in database.
Such as: disk quota value is 5G, the first disk quota value is 1.2 times of disk quota value; So, according to disk quota value control current account the disk occupation value of database is controlled time, it can not be done any restriction operation when current account disk occupation value in a database exceeds 5G, but when current account disk occupation value in a database exceeds 6G, then directly interrupt current account to the operation of the disk in database.
The data base management method provided by the embodiment of the present invention, when adopting the disk quota value preset current account disk occupation value in a database to be controlled, when judging that current account disk occupation value in a database exceeds disk quota value, then current account is performed the soft restriction operation of disk, both ensured that disk space was not freely taken in a large number effectively to be managed by database, the experience of user can have been promoted again.
Embodiment three
With reference to Fig. 3, show the flow chart of steps of a kind of data base management method of the embodiment of the present invention three.
The data base management method of the embodiment of the present invention specifically comprises the following steps:
Step 301: the data that data corresponding for current account are corresponding with other accounts of database service are isolated by database.
Owing to data corresponding for each account simultaneously for multiple account provides service, therefore, in order to ensure the security of the data that each account is corresponding, then can be isolated by database, the data of self correspondence only can be operated by each account.
This, see correlation technique, is not done concrete restriction by the concrete scheme data that account is corresponding isolated in the embodiment of the present invention. A kind of by the mode that data corresponding with other accounts of database service for data corresponding for current account carry out isolating it is preferably: controlling current account only can data corresponding to the current account that stores of reading and writing and performing in database.
Step S302: database determines the presetting database resource distribution that current account is corresponding.
Wherein, presetting database resource distribution can comprise: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
The concrete parameter that presetting database resource distribution comprises can use user to preset according to actual demand by current account, and this does not do in embodiment of the present invention concrete restriction.
Step S303: database, according to presetting database resource distribution, controls current account to the resource occupation of database.
When controlling current account to the resource occupation of database according to presetting database resource distribution, mainly according to concrete resource configuration parameter, the resource occupation of database is controlled. Below respectively to the first: according to disk quota value and unit time, disk is carried out the predetermined times of read-write operation, control current account to the resource occupation of database; 2nd kind: control current account to the resource occupation of database according to preset band width values; The third: control current account according to internal memory quota value and the concrete control mode of the resource occupation of database is described:
The first: according to disk quota value and unit time, disk is carried out the predetermined times of read-write operation, control current account and the two of the resource occupation of database kinds of concrete modes are respectively:
1): judge whether current account disk occupation value in a database exceeds disk quota value by file system; If then current account being performed the soft restriction operation of disk.
Wherein, when the execution soft restriction of disk of current account being operated, it is possible to display is used to indicate the actual information taking disk value and having exceeded described disk quota value of current account; And/or, the read-write number of times of described database disk unit time is limited to by described current account the predetermined times that disk is carried out read-write operation by the unit time that described database resource disposition comprises.
2): judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, the first disk quota value is greater than disk quota value; If then interrupting current account to the operation of the disk in database.
2nd kind: controlling current account according to preset band width values to the concrete mode of the resource occupation of database is:
The maximum of the bandwidth of current account is controlled to preset band width values.
Such as: preset band width values is 10Mb/S, so when the bandwidth of current account is controlled, then the maximum of its bandwidth is controlled at 10Mb/S.
It should be noted that, preset bandwidth value can comprise uplink bandwidth value, and downlink bandwidth value. , it is also possible to upper row, downlink bandwidth value are preset to identical value, certainly also namely preset bandwidth value only comprises a band width values.
The third: controlling current account according to internal memory quota value to the concrete mode of the resource occupation of database is:
Current account EMS memory occupation maximum in a database is controlled to internal memory quota value.
Such as: internal memory quota value is 1G, when current account internal memory in a database has taken 1G, but when also needing to hold over the internal memory in database, a part of internal memory release that current account then can be taken by database, continue as current account and memory service is provided, but in any case current account EMS memory occupation maximum in a database is all 1G.
It should be noted that, above-mentioned is only respectively to control separately, according to each resource configuration parameter, the explanation that the resource occupation of database carries out by current account. In specific implementation process, comprise disk quota value, preset band width values, internal memory quota value and unit time simultaneously if presetting resource distribution disk carried out the predetermined times of read-write operation, then need executed in parallel the first, the 2nd kind and the third mode to be to control current account to the resource occupation of database. Comprise disk quota value, preset band width values and unit time simultaneously if presetting resource distribution disk is carried out the predetermined times of read-write operation, then need executed in parallel the first and the 2nd kind of mode to control current account to the resource occupation of database. Comprise disk quota value, internal memory quota value and second unit time simultaneously if presetting resource distribution disk is carried out the predetermined times of read-write operation, then need executed in parallel the first and the third mode to control current account to the resource occupation of database. If preset resource distribution to comprise preset band width values and internal memory quota value simultaneously, then need executed in parallel the 2nd kind and the third mode to control current account to the resource occupation of database.
The data base management method provided by the embodiment of the present invention, determine the preset data base resource that account is corresponding, use in the service process that database provides in account, according to the presetting database resource distribution determined to control current account to the resource occupation of described database, to guarantee that the database resource that account can take does not exceed the database resource applied for, thus the resource of database is avoided freely to be taken. Due to the embodiment of the present invention provide data base management method database is managed time, database resource can not freely be taken, and therefore database resource can not be wasted.
Embodiment four
With reference to Fig. 4, show the structure block diagram of a kind of data bank management device of the embodiment of the present invention three.
The data bank management device of the embodiment of the present invention can comprise: determination module 401, for determining the presetting database resource distribution that current account is corresponding; And control module 402, for according to described presetting database resource distribution, controlling current account to the resource occupation of described database.
The data bank management device provided by the embodiment of the present invention, determine the preset data base resource that account is corresponding, use in the service process that database provides in account, according to the presetting database resource distribution determined to control current account to the resource occupation of described database, to guarantee that the database resource that account can take does not exceed the database resource applied for, thus the resource of database is avoided freely to be taken. Due to the embodiment of the present invention provide data bank management device database is managed time, database resource can not freely be taken, and therefore database resource can not be wasted.
Embodiment five
With reference to Fig. 5, show the structure block diagram of a kind of data bank management device of the embodiment of the present invention five.
The embodiment of the present invention is the further optimization to the data library device in embodiment four, and the data bank management device after optimization, specifically can comprise: determination module 501, for determining the presetting database resource distribution that current account is corresponding; And control module 502, for according to described presetting database resource distribution, controlling current account to the resource occupation of described database.
Preferably, described presetting database resource distribution can comprise: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
Preferably, control module 502 comprises: the first disk control module 5021, for judging whether current account disk occupation value in the database exceeds described disk quota value by file system; Soft limiting module 5022, if the judged result for described disk control module is yes, then performs the soft restriction operation of disk to current account.
Preferably, described soft limiting module comprises: display module 50221, for showing the information being used to indicate current account actual disk occupation value and having exceeded described disk quota value; And/or, read-write number of times adjusting module 50222, carries out the predetermined times of read-write operation for the read-write number of times of described database disk unit time is limited to unit time that described database resource disposition comprises by described current account to disk.
Preferably, described control module 502 comprises: the 2nd disk control module 5023, for judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value; Hard limiting module 5024, if the judged result for the 2nd disk control module is yes, then interrupts current account to the operation of the disk in described database.
Preferably, described control module 502 comprises: broadband speeds control module 5025, for the maximum of the bandwidth of current account is controlled to described preset band width values.
Preferably, described control module 502 comprises: Memory control module 5026, for current account EMS memory occupation maximum in the database is controlled to described internal memory quota value.
Preferably, described data bank management device also comprises: isolation module 503, for the data that data corresponding for current account are corresponding with other accounts of described database service being isolated.
Preferably, described isolation module 503 specifically for: controlling described current account only can data corresponding to current account that stores of reading and writing and performing in described database.
The data bank management device of the present embodiment is used for realizing corresponding data base management method in previous embodiment one to embodiment three, and has the useful effect of corresponding embodiment of the method, does not repeat them here.
Each embodiment in this specification sheets all adopts the mode gone forward one by one to describe, each embodiment emphasis illustrate be the difference with other embodiments, between each embodiment identical similar part mutually see. For system embodiment, due to itself and embodiment of the method basic simlarity, so what describe is fairly simple, relevant part illustrates see the part of embodiment of the method.
The database management schemes provided at this is intrinsic not relevant to any certain computer, virtual system or other equipment. Various general-purpose system can also with use based on together with this teaching. According to description above, it is to construct the structure required by system with the present invention program is apparent. In addition, the present invention is not also for any certain programmed language. It should be appreciated that various programming language can be utilized to realize the content of the present invention described here, and the description done by language-specific above is the preferred forms in order to disclose the present invention.
In specification sheets mentioned herein, describe a large amount of detail. However, it is understood that embodiments of the invention can be put into practice when not having these details. In some instances, it is not shown specifically known method, structure and technology, so that not fuzzy understanding of this description.
Similarly, it is to be understood that, one or more in order to what simplify the disclosure and help to understand in each inventive aspect, above to, in the description of the exemplary embodiment of the present invention, each feature of the present invention is grouped together in single embodiment, figure or the description to it sometimes. But, the method for the disclosure should be construed to the following intention of reflection: namely the present invention for required protection requires feature more more than the feature clearly recorded in each claim. More properly saying, as the following claims reflect, inventive aspect is all features less than disclosed single embodiment above. Therefore, the claim book following embodiment is thus incorporated to this embodiment clearly, and wherein each claim itself is as the independent embodiment of the present invention.
Those skilled in the art it can be appreciated that the module in the equipment in embodiment can be carried out adaptively change and they are arranged in one or more equipment different from this embodiment. Module in embodiment or unit or assembly can be combined into a module or unit or assembly, and multiple submodule block or subelement or subgroup part can be put them in addition. Except at least some in such feature and/or process or unit mutually repels, it is possible to adopt any combination all processes or the unit of all features disclosed in this specification sheets (comprising adjoint claim, summary and accompanying drawing) and so disclosed any method or equipment to be combined. Unless expressly stated otherwise, each feature disclosed in this specification sheets (comprising adjoint claim, summary and accompanying drawing) can by providing alternative features that is identical, equivalent or similar object to replace.
In addition, the technician of this area can understand, although embodiments more described herein comprise in other embodiment some included feature instead of further feature, but the combination of the feature of different embodiment means to be within the scope of the present invention and forms different embodiments. Such as, in detail in the claims, the one of any of claimed embodiment can use with arbitrary array mode.
Each parts embodiment of the present invention with hardware implementing, or can realize with the software module run on one or more treater, or realizes with their combination. It will be understood by one skilled in the art that the some or all functions of the some or all parts that microprocessor or digital signal processor (DSP) can be used in practice to realize in database management schemes according to embodiments of the present invention. Such as, the present invention can also be embodied as part or all the equipment for performing method as described herein or device program (computer program and computer program). The program of such the present invention of realization can store on a computer-readable medium, or can have the form of one or more signal. Such signal can be downloaded from internet website and obtain, or provides on carrier signal, or provides with any other form.
Should it is to be noted that above-described embodiment the present invention will be described instead of limits the invention, and those skilled in the art can design alternative embodiment when not departing from the scope of claims. In the claims, it should not any reference symbol construction between bracket is become limitations on claims. Word " comprises " element or step not getting rid of and exist and do not arrange in the claims. Word "a" or "an" before being positioned at element is not got rid of and be there is multiple such element. The present invention can by means of including the hardware of some different elements and realize by means of the computer suitably programmed. In the unit claim listing some devices, some in these devices can be carry out particular embodiment by same hardware branch. Word first, second and third-class use do not represent any order. Can be title by these word explanations.
The present invention discloses A1, a kind of data base management method, comprising:
Determine the presetting database resource distribution that current account is corresponding; And
According to described presetting database resource distribution, control current account to the resource occupation of described database.
A2, method according to A1, wherein, described presetting database resource distribution comprises: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
A3, method according to A2, wherein, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Judge whether current account disk occupation value in the database exceeds described disk quota value by file system;
If then current account being performed the soft restriction operation of disk.
A4, method according to A3, wherein, the described step that current account carries out the soft restriction operation of disk comprises further:
Display is used to indicate the information that current account actual disk occupation value has exceeded described disk quota value; And/or,
The read-write number of times of described database disk unit time is limited to by described current account the predetermined times that disk is carried out read-write operation by the unit time that described database resource disposition comprises.
A5, method according to A2, wherein, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value;
If then interrupting current account to the operation of the disk in described database.
A6, method according to A2, wherein, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
The maximum of the bandwidth of current account is controlled to described preset band width values.
A7, method according to A1, wherein, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Current account EMS memory occupation maximum in the database is controlled to described internal memory quota value.
A8, method according to A1, wherein, described method also comprises:
The data that data corresponding for current account are corresponding with other accounts of described database service are isolated.
A9, method according to A8, wherein, the step that the described data that data corresponding for current account are corresponding with other accounts of described database service carry out isolating comprises further:
Controlling described current account only can data corresponding to current account that stores of reading and writing and performing in described database.
The invention also discloses B10, a kind of data bank management device, comprising:
Determination module, for determining the presetting database resource distribution that current account is corresponding; And
Control module, for according to described presetting database resource distribution, controlling current account to the resource occupation of described database.
B11, device according to B10, wherein, described presetting database resource distribution comprises: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
B12, device according to B11, wherein, described control module comprises:
By file system, first disk control module, for judging whether current account disk occupation value in the database exceeds described disk quota value;
Soft limiting module, if the judged result for described disk control module is yes, then performs the soft restriction operation of disk to current account.
B13, device according to B12, wherein, described soft limiting module comprises:
Display module, for showing the information being used to indicate current account actual disk occupation value and having exceeded described disk quota value; And/or,
Read-write number of times adjusting module, carries out the predetermined times of read-write operation for the read-write number of times of described database disk unit time is limited to unit time that described database resource disposition comprises by described current account to disk.
B14, device according to B11, wherein, described control module comprises:
2nd disk control module, for judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value;
Hard limiting module, if the judged result for the 2nd disk control module is yes, then interrupts current account to the operation of the disk in described database.
B15, device according to B11, wherein, described control module comprises:
Broadband speeds control module, for being controlled to described preset band width values by the maximum of the bandwidth of current account.
B16, device according to B10, wherein, described control module comprises:
Memory control module, for being controlled to described internal memory quota value by current account EMS memory occupation maximum in the database.
B17, device according to B10, wherein, described data bank management device also comprises:
Isolation module, for isolating the data that data corresponding for current account are corresponding with other accounts of described database service.
B18, device according to B17, wherein, described isolation module specifically for: controlling described current account only can data corresponding to the current account that stores of reading and writing and performing in described database.
Claims (10)
1. a data base management method, comprising:
Determine the presetting database resource distribution that current account is corresponding; And
According to described presetting database resource distribution, control current account to the resource occupation of described database.
2. method according to claim 1, it is characterised in that, described presetting database resource distribution comprises: disk is carried out at least one in the predetermined times of read-write operation by disk quota value, preset band width values, internal memory quota value and unit time.
3. method according to claim 2, it is characterised in that, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Judge whether current account disk occupation value in the database exceeds described disk quota value by file system;
If then current account being performed the soft restriction operation of disk.
4. method according to claim 3, it is characterised in that, the described step that current account carries out the soft restriction operation of disk comprises further:
Display is used to indicate the information that current account actual disk occupation value has exceeded described disk quota value; And/or,
The read-write number of times of described database disk unit time is limited to by described current account the predetermined times that disk is carried out read-write operation by the unit time that described database resource disposition comprises.
5. method according to claim 2, it is characterised in that, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Judging whether current account disk occupation value in the database exceeds the first disk quota value by file system, wherein, described first disk quota value is greater than described disk quota value;
If then interrupting current account to the operation of the disk in described database.
6. method according to claim 2, it is characterised in that, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
The maximum of the bandwidth of current account is controlled to described preset band width values.
7. method according to claim 1, it is characterised in that, described according to described presetting database resource distribution, control current account and the step of the resource occupation of described database is comprised further:
Current account EMS memory occupation maximum in the database is controlled to described internal memory quota value.
8. method according to claim 1, it is characterised in that, described method also comprises:
The data that data corresponding for current account are corresponding with other accounts of described database service are isolated.
9. method according to claim 8, it is characterised in that, the step that the described data that data corresponding for current account are corresponding with other accounts of described database service carry out isolating comprises further:
Controlling described current account only can data corresponding to current account that stores of reading and writing and performing in described database.
10. a data bank management device, comprising:
Determination module, for determining the presetting database resource distribution that current account is corresponding; And
Control module, for according to described presetting database resource distribution, controlling current account to the resource occupation of described database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510997388.1A CN105653631B (en) | 2015-12-25 | 2015-12-25 | Database management method and device |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201510997388.1A CN105653631B (en) | 2015-12-25 | 2015-12-25 | Database management method and device |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105653631A true CN105653631A (en) | 2016-06-08 |
| CN105653631B CN105653631B (en) | 2020-08-14 |
Family
ID=56476906
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201510997388.1A Active CN105653631B (en) | 2015-12-25 | 2015-12-25 | Database management method and device |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105653631B (en) |
Cited By (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107276827A (en) * | 2017-07-25 | 2017-10-20 | 郑州云海信息技术有限公司 | Qos implementation method and device in a kind of distributed memory system |
Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060041587A1 (en) * | 2004-08-18 | 2006-02-23 | International Business Machines Corporation | Disk quota management with limits classes |
| CN101699436A (en) * | 2009-10-20 | 2010-04-28 | 中兴通讯股份有限公司 | Method, device and system for resource management |
| US7953701B2 (en) * | 2003-08-08 | 2011-05-31 | Hitachi, Ltd. | Method of controlling total disk usage amount in virtualized and unified network storage system |
| CN103297496A (en) * | 2012-03-02 | 2013-09-11 | 国际商业机器公司 | Method and system of enhanced storage quota management for cloud computing system |
| CN104915441A (en) * | 2015-06-26 | 2015-09-16 | 上海承蓝电子科技有限公司 | Image data visualization method, and device and system thereof |
| CN105094692A (en) * | 2014-05-22 | 2015-11-25 | Tcl集团股份有限公司 | Disk quota control method and system based on Android system |
-
2015
- 2015-12-25 CN CN201510997388.1A patent/CN105653631B/en active Active
Patent Citations (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US7953701B2 (en) * | 2003-08-08 | 2011-05-31 | Hitachi, Ltd. | Method of controlling total disk usage amount in virtualized and unified network storage system |
| US20060041587A1 (en) * | 2004-08-18 | 2006-02-23 | International Business Machines Corporation | Disk quota management with limits classes |
| CN101699436A (en) * | 2009-10-20 | 2010-04-28 | 中兴通讯股份有限公司 | Method, device and system for resource management |
| CN103297496A (en) * | 2012-03-02 | 2013-09-11 | 国际商业机器公司 | Method and system of enhanced storage quota management for cloud computing system |
| CN105094692A (en) * | 2014-05-22 | 2015-11-25 | Tcl集团股份有限公司 | Disk quota control method and system based on Android system |
| CN104915441A (en) * | 2015-06-26 | 2015-09-16 | 上海承蓝电子科技有限公司 | Image data visualization method, and device and system thereof |
Non-Patent Citations (1)
| Title |
|---|
| 谢延红: "基于"网闸"的高校公共多媒体教室计算机管理方案及实践", 《计算机时代》 * |
Cited By (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN107276827A (en) * | 2017-07-25 | 2017-10-20 | 郑州云海信息技术有限公司 | Qos implementation method and device in a kind of distributed memory system |
| CN107276827B (en) * | 2017-07-25 | 2021-04-23 | 郑州云海信息技术有限公司 | Method and device for realizing Qos in distributed storage system |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105653631B (en) | 2020-08-14 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US9952970B2 (en) | Cache allocation for disk array | |
| US9292205B2 (en) | Methods and systems for adaptive queue depth management | |
| US20140324774A1 (en) | Techniques for managing a data replication mode | |
| CN110753131A (en) | Microservice distributed current limiting method and device, storage medium and electronic equipment | |
| US9886395B2 (en) | Evicting cached stores | |
| US10528461B2 (en) | Controlling wear among flash memory devices based on remaining warranty | |
| US20050132145A1 (en) | Contingent processor time division multiple access of memory in a multi-processor system to allow supplemental memory consumer access | |
| CN111245732B (en) | Flow control method, device and equipment | |
| CN108292244B (en) | Data processing device, data processing method, and computer-readable recording medium | |
| CN112579263A (en) | Task execution method and device, storage medium and electronic equipment | |
| CN110737401A (en) | Method, apparatus and computer program product for managing redundant array of independent disks | |
| US8504787B1 (en) | Techniques for determining data protection storage requirements | |
| CN111124304B (en) | Data migration method and device, electronic equipment and storage medium | |
| US10706024B2 (en) | Techniques for managing a data replication mode | |
| CN105653631A (en) | Database management method and apparatus | |
| CN112020079A (en) | Wireless communication device and method for electronic device, and storage medium | |
| CN111562883B (en) | Cache management system, method and device for solid state disk | |
| CN111124253B (en) | Method, apparatus and computer program product for managing storage devices | |
| EP2703993A2 (en) | Information processing apparatus, computer program, and copy control method | |
| CN107209656B (en) | Adjusting speaker settings | |
| CN112204514A (en) | Techniques for preserving life expectancy of non-volatile memory | |
| CN105242878B (en) | A kind of method and device of QoS controls | |
| JP6273907B2 (en) | Vehicle equipment | |
| CN110059062B (en) | Stripe setting method and system of file system and related components | |
| US20170149242A1 (en) | Adjusting an extended power line disruption time and end-of-life used for at least one battery backup unit in a system |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| C10 | Entry into substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant | ||
| TR01 | Transfer of patent right |
Effective date of registration: 20240116 Address after: 100088 room 112, block D, 28 new street, new street, Xicheng District, Beijing (Desheng Park) Patentee after: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Address before: Room 112, block D, No. 28, Xinjiekou outer street, Xicheng District, Beijing 100088 (Desheng Park) Patentee before: BEIJING QIHOO TECHNOLOGY Co.,Ltd. Patentee before: Qizhi software (Beijing) Co.,Ltd. |
|
| TR01 | Transfer of patent right |