CN105930355B - A kind of multi-source image database design method - Google Patents
A kind of multi-source image database design method Download PDFInfo
- Publication number
- CN105930355B CN105930355B CN201610217985.2A CN201610217985A CN105930355B CN 105930355 B CN105930355 B CN 105930355B CN 201610217985 A CN201610217985 A CN 201610217985A CN 105930355 B CN105930355 B CN 105930355B
- Authority
- CN
- China
- Prior art keywords
- data
- image
- index
- static
- dynamic
- 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.)
- Expired - Fee Related
Links
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/50—Information retrieval; Database structures therefor; File system structures therefor of still image data
- G06F16/51—Indexing; Data structures therefor; Storage structures
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F21/00—Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
- G06F21/60—Protecting data
- G06F21/62—Protecting access to data via a platform, e.g. using keys or access control rules
- G06F21/6218—Protecting access to data via a platform, e.g. using keys or access control rules to a system of files or objects, e.g. local or distributed file system or database
Abstract
The invention discloses a kind of multi-source image database design methods, include the following steps: the description method for using object-oriented and image data objects system is divided with source, the image of same position or the same area to a variety of sources, design map the image data of reality with hierarchical mode data structure；When design database, the library table of application program creates at least two table spaces, and one for storing data, another is used for storage table index data, the data file of two table spaces is placed on different physical disks；Static table is established on static table space, establishes dynamic table on dynamic table space, the index of static table is established on static index table space, the index of dynamic table is established on dynamic index table space；The mode of application permission and user group mixed management manages data；Carry out the backup of database.The access efficiency of multi-source data can be improved in the present invention, guarantees the safety and confidentiality of multi-source data, improves user experience.
Description
Technical field
The present invention relates to database fields, and in particular to a kind of multi-source image database design method.
Background technique
The store method of traditional multi-source data is saved by file mode mostly, and this store method makes figure
The storage of picture is disorderly and unsystematic, and there is also very big drawbacks to the lookup of image classification；Meanwhile image file is only to protect
There are in file, the confidentiality of image and safety also be cannot be guaranteed, and client interactivity and linkage are poor, development cost
Height, poor user experience (ineffective).
Summary of the invention
To solve the above problems, multi-source number can be improved the present invention provides a kind of multi-source image database design method
According to access efficiency, guarantee the safety and confidentiality of multi-source data, and then standardized inquiry and behaviour of the application system to data
Make approach.
To achieve the above object, the technical scheme adopted by the invention is as follows:
A kind of multi-source image database design method, includes the following steps:
S1, the description method for using object-oriented and with source divide image data objects system, to the same of a variety of sources
The image of one position or the same area, design map the image data of reality with hierarchical mode data structure；Hierarchical mode knot
Structure includes area level, source layer, application layer, image layer, defines the essential information of this layer of characteristic of mapping in each layer, and layer with
Corresponding relationship between layer is one-to-many relationship；
S2, when design database, the library table of application program creates at least two table spaces, one of them is for depositing
Data are stored up, another is used for storage table index data, is then placed on the data file of the two table spaces not in physical layer
On same physical disk；The I/ that system performance can be thus generated to avoid the I/O operation of table data and the I/O operation of index
O competition.
S3, in order to improve data base access system library table efficiency, static table is established on static table space, in dynamic table sky
Between on establish dynamic table, the index of static table is established on static index table space, on dynamic index table space establish dynamic
The index of table, static table and static index table are one-to-one relationship, between static table space and static index table space
It is one-to-one relationship, equally, between dynamic table and dynamic index table, between dynamic table space and dynamic index table space all
It is one-to-one relationship；In such a way come improve database retrieval, operation, input and output efficiency
S4, in order to realize the safe and reliable management to multi-source data, store data in database, and application power
It limits with the mode of user group mixed management and manages data, each user belongs to a user group, and user group has group corresponding
Priority assignation；And simultaneously, individual subscriber can also have priority assignation individually, other than group；All operations of system, all by being
System operation log is recorded；The password logged in system user is encrypted, and is added and uses in systems management data library
Family table, by encrypting and decrypting function by the password encryption of user, decryption；Different types of user is arranged by setting permission
The range of user's operation.In system use process, the permission of user name, password and user group will not relate to, it is ensured that
The safety of data.
S5, in order to prevent paroxysmal event, using data backup, log, roll-back segment and several knots of control file etc.
Structure realizes the backup of database, and then protects the safety of multi-source data.
Wherein, described
Region essential information is continent, country, area, coordinate, range；
Source essential information is source name, specifications and models, style of shooting, established standards；
It is Apply Names, application purpose, application effect using essential information；
Image essential information is image identifier, image size, image resolution ratio, image metadata.
The invention has the following advantages:
The efficiency of management of multi-source image data is improved, the safety of multi-source image data management and confidentiality are protected
Card.
Detailed description of the invention
Fig. 1 is the structure chart of database in the embodiment of the present invention.
Fig. 2 is system management layer membership credentials figure in the embodiment of the present invention.
Specific embodiment
In order to which objects and advantages of the present invention are more clearly understood, the present invention is carried out with reference to embodiments further
It is described in detail.It should be appreciated that the specific embodiments described herein are merely illustrative of the present invention, it is not used to limit this hair
It is bright.
The embodiment of the invention provides a kind of multi-source image database design methods, which comprises the steps of:
S1, the description method for using object-oriented and with source divide image data objects system, to the same of a variety of sources
The image of one position or the same area, design map the image data of reality with hierarchical mode data structure；Hierarchical mode knot
Structure includes area level, source layer, application layer, image layer, defines the essential information of this layer of characteristic of mapping in each layer, and layer with
Corresponding relationship between layer is one-to-many relationship；
S2, when design database, the library table of application program creates at least two table spaces, one of them is for depositing
Data are stored up, another is used for storage table index data, is then placed on the data file of the two table spaces not in physical layer
On same physical disk；The I/ that system performance can be thus generated to avoid the I/O operation of table data and the I/O operation of index
O competition.
S3, in order to improve data base access system library table efficiency, as shown in Figure 1, establish static table on static table space,
Dynamic table is established on dynamic table space, the index of static table is established on static index table space, in dynamic index table space
On establish the index of dynamic table, static table and static index table are one-to-one relationship, static table space and static index table
It is also one-to-one relationship between space, equally, between dynamic table and dynamic index table, dynamic table space and dynamic index table
It is all one-to-one relationship between space；In such a way come improve database retrieval, operation, input and output effect
Rate.
S4, multi-source image data are different from other general datas, have the characteristics that data volume is big, in order to guarantee metadata
Data are completely stored in database by safety, system requirements, this just brings system and carries out data storage, operation and output
Efficiency when display, so in order to realize the safe and reliable management to multi-source data, as shown in Fig. 2, data are stored
In the database, and the mode of application permission and user group mixed management manages data, and each user belongs to a use
Family group, user group have the corresponding priority assignation of group；And simultaneously, individual subscriber can also have priority assignation individually, other than group；
All operations of system, are all recorded by System Operation Log；The password logged in system user is encrypted, and is being
In reason database under the overall leadership be added user's table, by encrypting and decrypting function by the password encryption of user, decryption；To different types of use
The range of user's operation is arranged by setting permission for family.In system use process, user name, password will not relate to, with
And the permission of user group, it is ensured that the safety of data.
S5, in order to prevent paroxysmal event, using data backup, log, roll-back segment and several knots of control file etc.
Structure realizes the backup of database, and then protects the safety of multi-source data.
This specific implementation is provided with index table space in order to promote effectiveness of retrieval, for each table space；For each table, if
Concordance list is set.And data table space and index table space are respectively stored on different physical disks, avoiding need not
The I/O competition wanted.The operating right of user can be set by user group, and the modification of user group permission directly affects the behaviour of user
Make permission；In application process, the modification of bottom can also be carried out to permission, user level only carries out the management of username and password
Maintenance, and by user and permission stratified management, improve the safety and reliability of system；Pass through database management language reality
Show and standardized management is carried out to multi-source data, has improved the efficiency of application layer access and processing data, reduce server
Security risk；Key algorithm is completed in data bottom simultaneously to realize, is improved speed, is greatly promoted application layer user experience.
The above is only a preferred embodiment of the present invention, it is noted that for the ordinary skill people of the art
For member, without departing from the principle of the present invention, it can also make several improvements and retouch, these improvements and modifications are also answered
It is considered as protection scope of the present invention.
Claims (2)
1. a kind of multi-source image database design method, which comprises the steps of:
S1, the description method for using object-oriented and with source divide image data objects system, to the same position in a variety of sources
It sets or the image of the same area, design maps the image data of reality with hierarchical mode data structure；Hierarchical mode structure packet
Include area level, source layer, application layer, image layer, define the essential information of this layer of characteristic of mapping in each layer, and layer and layer it
Between corresponding relationship be one-to-many relationship；
S2, when design database, the library table of application program creates at least two table spaces, one of them is for storing number
According to another is used for storage table index data, is then placed on the data file of the two table spaces in physical layer different
On physical disk；
S3, static table is established on static table space, establishes dynamic table on dynamic table space, built on static index table space
The index of vertical static table, establishes the index of dynamic table on dynamic index table space, and static table and static index table are one a pair of
The relationship answered also is one-to-one relationship between static table space and static index table space, equally, dynamic table and dynamic rope
Draw between table, is all one-to-one relationship between dynamic table space and dynamic index table space；
S4, it stores data in database, and the mode of application permission and user group mixed management manages data, each
User belongs to a user group, and user group has the corresponding priority assignation of group；And simultaneously, individual subscriber can also have individually,
Priority assignation other than group；All operations of system, are all recorded by System Operation Log；The password that system user is logged in
Be encrypted, in systems management data library be added user's table, by encrypting and decrypting function by the password encryption of user, solution
It is close；Different types of user is arranged by setting permission the range of user's operation；
S5, the backup that database is realized using data backup, log, roll-back segment and control several structures of file, Jin Erbao
Protect the safety of multi-source data.
2. a kind of multi-source image database design method according to claim 1, which is characterized in that described
Region essential information is continent, country, area, coordinate, range；
Source essential information is source name, specifications and models, style of shooting, established standards；
It is Apply Names, application purpose, application effect using essential information；
Image essential information is image identifier, image size, image resolution ratio, image metadata.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610217985.2A CN105930355B (en) | 2016-04-02 | 2016-04-02 | A kind of multi-source image database design method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610217985.2A CN105930355B (en) | 2016-04-02 | 2016-04-02 | A kind of multi-source image database design method |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN105930355A CN105930355A (en) | 2016-09-07 |
| CN105930355B true CN105930355B (en) | 2019-05-28 |
Family
ID=56840503
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610217985.2A Expired - Fee Related CN105930355B (en) | 2016-04-02 | 2016-04-02 | A kind of multi-source image database design method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN105930355B (en) |
Families Citing this family (2)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN109241328A (en) * | 2018-08-23 | 2019-01-18 | 上海尤卡城信息科技有限责任公司 | augmented reality service providing method and device |
| CN110309155B (en) * | 2019-06-14 | 2020-05-12 | 西南交通大学 | Image data management system and method based on database technology and hierarchical data |
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 |
| CN103838825A (en) * | 2014-01-23 | 2014-06-04 | 北京东方泰坦科技股份有限公司 | Global geographical name data integrating and encoding method |
Family Cites Families (1)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060101072A1 (en) * | 2004-10-21 | 2006-05-11 | International Business Machines Corproation | System and method for interpreting scan data |
-
2016
- 2016-04-02 CN CN201610217985.2A patent/CN105930355B/en not_active Expired - Fee Related
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 |
| CN103838825A (en) * | 2014-01-23 | 2014-06-04 | 北京东方泰坦科技股份有限公司 | Global geographical name data integrating and encoding method |
Non-Patent Citations (1)
| Title |
|---|
| 多源图像情报空间数据集成管理模型研究与原型建立;王寿彪等;《国土资源遥感》;20130630;第25卷(第2期) |
Also Published As
| Publication number | Publication date |
|---|---|
| CN105930355A (en) | 2016-09-07 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN106022155B (en) | Method and server for database security management | |
| US8352731B2 (en) | Secure decentralized storage system | |
| CN102651775B (en) | Based on method, the equipment and system of many tenants shared object management of cloud computing | |
| WO2018032374A1 (en) | Encrypted storage system for block chain and method using same | |
| US9558366B2 (en) | Computer system for storing and retrieval of encrypted data items, client computer, computer program product and computer-implemented method | |
| CN104079574A (en) | User privacy protection method based on attribute and homomorphism mixed encryption under cloud environment | |
| CN102821096A (en) | Distributed storage system and file sharing method thereof | |
| De Capitani di Vimercati et al. | Private data indexes for selective access to outsourced data | |
| US20120257743A1 (en) | Multiple independent encryption domains | |
| CN104298472A (en) | Layered computing virtualization implementing method and device | |
| US20170053125A1 (en) | Methods and systems of encrypting file system directories | |
| CN103888468A (en) | Privacy protection method based on trusted third party attribute fuzzy grouping under cloud environment | |
| CN102970317A (en) | Safety design scheme of private cloud storage system | |
| CN105930355B (en) | A kind of multi-source image database design method | |
| CN107562521B (en) | Resource management method and device | |
| CN105100248A (en) | Cloud storage security realization method based on data encryption and access control | |
| CN111368269B (en) | Fine-grained access control method based on dense point labeling | |
| CN106682521A (en) | File transparent encryption and decryption system and method based on driver layer | |
| US20220237311A1 (en) | Enhanced Securing and Secured Processing of Data at Rest | |
| CN104298930A (en) | Method and system for tracking movable media and electronic document circulation trajectories of movable media in LAN | |
| CN107742141B (en) | Intelligent identity information acquisition method and system based on RFID technology | |
| CN106250453A (en) | The cipher text retrieval method of numeric type data based on cloud storage and device | |
| CN115022020B (en) | Access control method and system based on multidimensional set calculation | |
| US20180088846A1 (en) | Multi-user dynamic storage allocation and encryption | |
| Tian et al. | A trusted control model of cloud storage |
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 | ||
| CF01 | Termination of patent right due to non-payment of annual fee | ||
| CF01 | Termination of patent right due to non-payment of annual fee |
Granted publication date: 20190528 Termination date: 20210402 |