CN101667195A - Storing system and method of multiuser database - Google Patents
Storing system and method of multiuser database Download PDFInfo
- Publication number
- CN101667195A CN101667195A CN200910093477A CN200910093477A CN101667195A CN 101667195 A CN101667195 A CN 101667195A CN 200910093477 A CN200910093477 A CN 200910093477A CN 200910093477 A CN200910093477 A CN 200910093477A CN 101667195 A CN101667195 A CN 101667195A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- storage
- growth form
- logical relation
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Pending
Links
- 238000000034 method Methods 0.000 title claims abstract description 22
- 238000012797 qualification Methods 0.000 claims description 9
- 238000013500 data storage Methods 0.000 claims description 6
- 241001269238 Data Species 0.000 description 2
- 238000007726 management method Methods 0.000 description 2
- 230000004048 modification Effects 0.000 description 2
- 238000012986 modification Methods 0.000 description 2
- 238000013523 data management Methods 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 230000002950 deficient Effects 0.000 description 1
- 230000004807 localization Effects 0.000 description 1
- 239000013589 supplement Substances 0.000 description 1
- 238000005303 weighing Methods 0.000 description 1
Images
Abstract
The invention provides a storing system and a method of a multiuser database, aiming to solving the problem of low access efficiency of the multiuser database with mass storage volume in the prior art. The system comprises a public server consisting of a database for storing logic relational databases of all users and one or more storage increase databases for storing storage increase data of oneuser. The method comprises the following steps: arranging the logic relational database on the public server and storing the logic relational data of all the users into the database; arranging the oneor more storage increase databases on the public server, wherein each storage increase database corresponds to one client; and storing the storage increase database corresponding to the client into the database. The invention is applied to the multiuser database with mass storage volume and can improve the retrieval efficiency of the storage increase databases and also improve the retrieval efficiency when each user retrieves.
Description
Technical field
The present invention relates to database storage techniques, be meant a kind of multiuser database storage device and method of big data quantity especially.
Background technology
System is in operation and all can produces data, and the management most popular method of data just is to use database.But the increase of passing and client's quantity in time can the very huge data of generation.In the database access of big data quantity, access efficiency is a very important index, and can fast data are presented to the user be the major criterion of weighing a system.Be stored in that safety of data also is the problem that the user is concerned about very much on the public data services device.
In the existing public data services, the data of storing on the public server can be divided into logical relation type data and storage growth form data.
Logical relation type data are to describe the data of each subsystem or relation between objects and attribute in the system.These data characteristic are that the dynamic growth amplitude is smaller, and the data volume of single table is limited, and need unification to visit and write.
Storage growth form data are the very large data of Data Growth amount, such as some professional Flow Records, log record, supplement the call history record of record, call center etc. with money.This data are historical data mostly, are mainly used in the retrieval visit.
Prior art is that these two kinds of data all are stored in the public database, causes the too huge recall precision that causes of database to reduce like this.Simultaneously, so not only safety of data can't be ensured reliably on the public server, also is easy to generate loss of data.
Summary of the invention
At defective that exists in the prior art and deficiency, the purpose of this invention is to provide multiuser database storage system and method, store respectively according to the characteristic of data, to improve the access efficiency of data.
For achieving the above object, the present invention proposes a kind of multiuser database storage system, comprise public server, it is characterized in that described public server comprises:
At least one logical relation type database, this logical relation type database storing has user's logical relation type data to some extent;
One or more storage growth form databases, each storage growth form database storing has a user's storage growth form data.
Wherein, described system also comprises:
Home server, described home server is electrically connected described public server, and the storage growth form data on the described public server are backed up;
Client, described client are electrically connected described home server and described public server; When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
Wherein, described system also comprises:
Data qualification module, described data qualification module judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write, and if not, then these data are system data; If, then read the increment of each data, and whether judge this increment greater than pre-set threshold value, if then this Data Identification is storage growth form data, and store described storage growth form database into; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.
Simultaneously, the invention allows for a kind of multiuser database method for storing, comprising:
At least one logical relation type database is set on public server, and with all users' logical relation type data storage in described logical relation type database;
One or more storage growth form databases are set on public server, each corresponding client of storage growth form database, and with this client's storage growth form data storage in corresponding storage growth form database.
Wherein, described method also comprises:
Home server is set, and makes described home server be electrically connected described public server so that the storage growth form data on the described public server are backed up;
When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
Wherein, described method also comprises:
Judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write, and if not, then these data are system data; If judge then that in the unit interval whether the increment of each data if then this Data Identification be storage growth form data, and stores described storage growth form database greater than threshold values; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.
Technique scheme has following advantage: because the user pays close attention to is storage growth form data, so the present invention will store the growth form data and logical relation type data are stored respectively, improve the recall precision of storing the growth form database with this.For each client a storage growth form database, the recall precision when improving each client's retrieve stored growth form data with this are set respectively simultaneously.
Description of drawings
Fig. 1 is the preferred embodiment structural representation of the multiuser database storage system that proposes of the present invention.
Embodiment
Below in conjunction with drawings and Examples, the specific embodiment of the present invention is described in further detail.Following examples are used to illustrate the present invention, but are not used for limiting the scope of the invention.
Embodiment 1
First embodiment of the invention has proposed a kind of multiuser database storage system, comprises public server, and described public server comprises:
At least one logical relation type database, this logical relation type database storing has user's logical relation type data to some extent;
One or more storage growth form databases, each storage growth form database storing has a user's storage growth form data.
First embodiment of the invention is to adopt a plurality of databases are set on public server, and one of them database is used to deposit all users' logical relation type data; The remainder data storehouse is used to store the storage growth form data of unique user.This is because storage growth form data are mainly used in retrieval, and the increment of data is very big.For each user is provided with an independent database to deposit storage growth form data, can improve user's recall precision.
In order further to improve the access efficiency of data, can branch storehouse or submeter be set for storage growth form database.For example, according to multiple dimensions such as data based time dimension, client's dimension are divided, be stored in respectively in branch storehouse or the submeter then.Like this can be so that control the data volume of each branch storehouse or submeter, to guarantee the visit effectiveness of retrieval.
Embodiment 2
Second embodiment of the invention is the improvement as above-mentioned first embodiment, and as shown in Figure 1, promptly except public server, the multiuser database storage system also comprises:
Home server, described home server is electrically connected described public server, and the storage growth form data on the described public server are backed up;
Client, described client are electrically connected described home server and described public server; When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
In the present embodiment, having set up home server backs up with the storage growth form data to public server.Improved storage growth form safety of data like this.Simultaneously, the user can send request of access to home server earlier when visit storage growth form data, if when home server does not have Backup Data or the failure of visit home server, just sends request of access to public server.Access efficiency in the time of can improving user capture like this reduces the load of public server.
Embodiment 3
The third embodiment of the present invention is to improve on the basis of first or second embodiment, and promptly above-mentioned multiuser database storage system also comprises:
Data qualification module, described data qualification module judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write, if otherwise these data are system; If, judge that then described data are reading the increment of each data, and whether judge this increment greater than pre-set threshold value, if then this Data Identification is storage growth form data, and store described storage growth form database into; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.
The data qualification module that proposes in the present embodiment can detect the increment of data automatically, thereby data are classified, with storage respectively.Certainly, do not adopt the data qualification module of present embodiment,, can realize the purpose that data are classified yet by manually data being classified.Simultaneously, if data are with system or subsystem logical relation to be arranged and need unification to visit and write, then this data are system datas.Therefore having only when data and system or subsystem does not have logical relation and does not need unified visit and write, and just needing to distinguish be to store growth form data or logic growth form data.
Embodiment 4
The fourth embodiment of the present invention is a kind of multiuser database method for storing, comprising:
At least one logical relation type database is set on public server, and with all users' logical relation type data storage in this database;
One or more storage growth form databases are set on public server, described each corresponding client of storage growth form database, and with the storage growth form data storage of this client's correspondence in this database.
Fourth embodiment of the invention is to adopt a plurality of databases are set on public server, and one of them database is used to deposit all users' logical relation type data; A plurality of databases are used to store the storage growth form data of unique user.This is because storage growth form data are mainly used in retrieval, and the increment of data is very big.For each user is provided with an independent database to deposit storage growth form data, can improve user's recall precision.
In order further to improve the access efficiency of data, can branch storehouse or submeter be set for storage growth form database.For example, according to multiple dimensions such as data based time dimension, client's dimension are divided, be stored in respectively in branch storehouse or the submeter then.Like this can be so that control the data volume of each branch storehouse or submeter, to guarantee the visit effectiveness of retrieval.
Embodiment 5
The fifth embodiment of the present invention is to improve on the basis of the 4th embodiment, and promptly described method also comprises:
Home server is set, and makes described home server be electrically connected described public server so that the storage growth form data on the described public server are backed up;
When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
In the present embodiment, having set up home server backs up with the storage growth form data to public server.Improved storage growth form safety of data like this.Simultaneously, the user can send request of access to home server earlier when visit storage growth form data, if when home server does not have Backup Data or the failure of visit home server, just sends request of access to public server.Access efficiency in the time of can improving user capture like this reduces the load of public server.
Embodiment 6
The sixth embodiment of the present invention is to improve on the basis of the 4th or the 5th embodiment, and promptly described method also comprises:
Judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write, if otherwise these data are system data; If, then judge described data in the unit interval, whether the increment of each data if then this Data Identification be storage growth form data, and stores described storage growth form database greater than threshold values; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.Set up the step that data are classified in the present embodiment, can detect the increment of data automatically, thereby data are classified, with storage respectively.Certainly, do not adopt the data qualification module of present embodiment,, can realize the purpose that data are classified yet by manually data being classified.Simultaneously, if data are with system or subsystem logical relation to be arranged and need unification to visit and write, then this data are system datas.Therefore having only when data and system or subsystem does not have logical relation and does not need unified visit and write, and just needing to distinguish be to store growth form data or logic growth form data.
As can be seen from the above embodiments, the multiuser database storage system and the method for the embodiment of the invention, the prior art of comparing has the following advantages:
1, data in the database is classified, and utilize disparate databases to store different types of data,, improve access efficiency to simplify store read process to data;
2, convenient each user's data of management, and can carry out data management according to each user's data amount;
3, storage growth form data are carried out the localization storage, and, realize the cloud storage by long-range and local Hot Spare.Can make things convenient for the user to manage exclusive data like this, further improve the recall precision of database with this.Improve the hot standby host system of database, guarantee the complete sum safety of user data.
The above only is embodiments of the present invention; should be pointed out that for those skilled in the art, under the prerequisite that does not break away from the technology of the present invention principle; can also make some improvement and modification, these improve and modification also should be considered as protection scope of the present invention.
Claims (6)
1, a kind of multiuser database storage system comprises public server, it is characterized in that, described public server comprises:
At least one logical relation type database, this logical relation type database storing has user's logical relation type data to some extent;
One or more storage growth form databases, each storage growth form database storing has a user's storage growth form data.
2, multiuser database storage system according to claim 1 is characterized in that, described system also comprises:
Home server, described home server is electrically connected described public server, and the storage growth form data on the described public server are backed up;
Client, described client are electrically connected described home server and described public server; When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
3, multiuser database storage system according to claim 1 and 2 is characterized in that, described system also comprises:
Data qualification module, described data qualification module judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write; If not, then these data are system data; If, then read the increment of each data, and whether judge this increment greater than pre-set threshold value, if then this Data Identification is storage growth form data, and store described storage growth form database into; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.
4, a kind of multiuser database method for storing comprises:
At least one logical relation type database is set on public server, and with all users' logical relation type data storage in described logical relation type database;
One or more storage growth form databases are set on public server, each corresponding client of storage growth form database, and with this client's storage growth form data storage in corresponding storage growth form database.
5, multiuser database method for storing according to claim 4 is characterized in that, described method also comprises:
Home server is set, and makes described home server be electrically connected described public server so that the storage growth form data on the described public server are backed up;
When the described storage growth form of client-access data, send request of access to this home server; If home server stores this data, then these data are sent to client; If when home server did not have these data or visit failure, this client sent request of access to the storage growth form database of public server.
6, according to claim 4 or 5 described multiuser database method for storing, it is characterized in that described method also comprises:
Judge whether described data do not have logical relation with system or subsystem and do not need unification to visit and write, and if not, then these data are system data; If judge then that in the unit interval whether the increment of each data if then this Data Identification be storage growth form data, and stores described storage growth form database greater than threshold values; Otherwise with this Data Identification is logical relation type data, and stores described logical relation type database into.
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910093477A CN101667195A (en) | 2009-10-10 | 2009-10-10 | Storing system and method of multiuser database |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
CN200910093477A CN101667195A (en) | 2009-10-10 | 2009-10-10 | Storing system and method of multiuser database |
Publications (1)
Publication Number | Publication Date |
---|---|
CN101667195A true CN101667195A (en) | 2010-03-10 |
Family
ID=41803811
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
CN200910093477A Pending CN101667195A (en) | 2009-10-10 | 2009-10-10 | Storing system and method of multiuser database |
Country Status (1)
Country | Link |
---|---|
CN (1) | CN101667195A (en) |
Cited By (3)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN104508663A (en) * | 2012-07-27 | 2015-04-08 | 微软公司 | Automatic transaction retry after session failure |
CN110222054A (en) * | 2019-05-22 | 2019-09-10 | 福建大屏网络科技有限公司 | A kind of method, apparatus, terminal device and storage medium improving retrieval rate |
US10936591B2 (en) | 2012-05-15 | 2021-03-02 | Microsoft Technology Licensing, Llc | Idempotent command execution |
-
2009
- 2009-10-10 CN CN200910093477A patent/CN101667195A/en active Pending
Cited By (4)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US10936591B2 (en) | 2012-05-15 | 2021-03-02 | Microsoft Technology Licensing, Llc | Idempotent command execution |
CN104508663A (en) * | 2012-07-27 | 2015-04-08 | 微软公司 | Automatic transaction retry after session failure |
CN104508663B (en) * | 2012-07-27 | 2018-01-30 | 微软技术许可有限责任公司 | Automatic processing after conversation failure retries |
CN110222054A (en) * | 2019-05-22 | 2019-09-10 | 福建大屏网络科技有限公司 | A kind of method, apparatus, terminal device and storage medium improving retrieval rate |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN100565512C (en) | Eliminate the system and method for redundant file in the document storage system | |
CN103294710B (en) | A kind of data access method and device | |
CN106708427A (en) | Storage method suitable for key value pair data | |
CN101582076A (en) | Data de-duplication method based on data base | |
CN104301360A (en) | Method, log server and system for recording log data | |
CN103916459A (en) | Big data filing and storing system | |
CN111367469B (en) | Method and system for migrating layered storage data | |
EP2916240A1 (en) | Database storage system based on compact disk and method using the system | |
CN103049224B (en) | By the methods, devices and systems of data importing physical tape | |
CN103970852A (en) | Data de-duplication method of backup server | |
CN102521419A (en) | Hierarchical storage realization method and system | |
CN104298736A (en) | Method and device for aggregating and connecting data as well as database system | |
CN104462389A (en) | Method for implementing distributed file systems on basis of hierarchical storage | |
CN104935469A (en) | Distributive storage method and system for log information | |
CN101673192A (en) | Method for time-sequence data processing, device and system therefor | |
CN105786410A (en) | Method for increasing processing speed of data storage system and data storage system | |
CN103294413B (en) | Support the distributed memory real-time storage device and method of magnanimity acquisition terminal | |
CN103488685A (en) | Fragmented-file storage method based on distributed storage system | |
CN107249135A (en) | Video data storage systems and its operating method and index server | |
WO2023185111A1 (en) | Quick access method and device for data file | |
CN102724279B (en) | System for realizing log-saving and log-managing | |
CN102722450B (en) | Storage method for redundancy deletion block device based on location-sensitive hash | |
CN101667195A (en) | Storing system and method of multiuser database | |
CN103455391B (en) | A kind of apparatus and method of data protection of dynamic conditioning | |
CN103699340B (en) | A kind of request processing method and equipment |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
C06 | Publication | ||
PB01 | Publication | ||
C10 | Entry into substantive examination | ||
SE01 | Entry into force of request for substantive examination | ||
DD01 | Delivery of document by public notice |
Addressee: Bejing Infobird Software Co.,Ltd. Pang Shanshan Document name: Notification that Application Deemed to be Withdrawn |
|
C02 | Deemed withdrawal of patent application after publication (patent law 2001) | ||
WD01 | Invention patent application deemed withdrawn after publication |
Open date: 20100310 |