CN109408593A - A kind of data base management system, device and method - Google Patents
A kind of data base management system, device and method Download PDFInfo
- Publication number
- CN109408593A CN109408593A CN201811204935.6A CN201811204935A CN109408593A CN 109408593 A CN109408593 A CN 109408593A CN 201811204935 A CN201811204935 A CN 201811204935A CN 109408593 A CN109408593 A CN 109408593A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- server
- user
- management device
- 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
Classifications
-
- 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
- G06F21/6227—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 where protection concerns the structure of data, e.g. records, types, queries
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computer Security & Cryptography (AREA)
- Bioethics (AREA)
- General Health & Medical Sciences (AREA)
- Computer Hardware Design (AREA)
- Health & Medical Sciences (AREA)
- Software Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Databases & Information Systems (AREA)
- Storage Device Security (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
The invention discloses a kind of data base management systems, device and method, including data bank management device, at least one first database, at least one first server, at least one second database and security server.The present invention forms complementation, eliminates spontaneous limitation, to meet storage and analysis to mass data, and according to user's request call database information, establish corresponding subdata base, can satisfy users ' individualized requirement by carrying out joint deployment to multitype database.
Description
Technical field
The present invention relates to database fields, and in particular to a kind of data base management system, device and method.
Background technique
With the explosive growth of information, big data era arrives, is analyzed big data and also increasingly go deep into us
Life.And basis of the database as big data analysis, also therefore it is widely used.
Database general at present includes: NewSQL database, OldSQL database and NoSQL database, every kind of data
Library is for storing different types of data, wherein the NewSQL database number high suitable for processing structure and value density
According to not supporting unstructured and semi-structured data, OldSQL database is suitable for processing structure and low value density
Data do not support unstructured and semi-structured data, NoSQL database to be suitable for handling unstructured and low value density
Data do not support structuring data.And existing most of big data analysis are based on a kind of Database more, the number that can be handled
It is relatively simple according to type, it is unable to satisfy the data analysis requirements of high number increases type multiplicity at all.
Meanwhile user all need daily obtain mass data, that is, need frequently to access database, when access people compared with
When more, the processing load of database will increase, and be unable to satisfy user to the individual demand of data.
Summary of the invention
In order to solve the deficiencies in the prior art, the present invention devises a kind of data base management system, device and method, passes through
Data bank management device is managed multitype database, and according to user's request call database information, establishes corresponding son
Database, to meet users ' individualized requirement.
To achieve the goals above, technical scheme is as follows:
A kind of data base management system, including data bank management device, at least one first database, at least one first
Server, at least one second database and security server；
The data bank management device is configured as being connected with first database, and stores for sorting data into the
In one database；With
It is connected with first server, and for the data in first database to be sent into first server；
The first server is configured as corresponding with first database, and for the first data sent
Library data carry out data analysis, obtain data analysis result；
Second database, is configured as being connected with data administrator and first server, and for storing first
The data analysis result of server；
The security server is configured as being connected with data bank management device, and the logon rights for verifying user.
Further, the first database include at least NewSQL database and/or NoSQL database, described second
Database includes at least OldSQL database.
Further, the data bank management device is for judging data type, and is distinguished according to judging result
Data are stored into corresponding first database；
The data bank management device is used to transfer the data in first database according to user command, and is sent into corresponding
Data analysis is carried out in first server；
The data bank management device is used to call the data in the second database according to user command, and establishes corresponding
Subdata base, so that user checks data by the subdata base.
Further, the security server for obtaining user login information, and judges the administrative power for the number of entering an item in an account book
Limit allows its management operation if the management of the logon account is operated without departing from its administration authority.
A kind of data bank management device, comprising:
Data acquisition module, for obtaining at least one data；
Data processing module is stored data respectively to right for judging data type, and according to data type
In the first database answered；
User command execution module, for the data in first database to be sent into corresponding first clothes according to user command
It is engaged in device, carries out data analysis；With
For calling the data in the second database according to user command, and corresponding subdata base is established, so that user
Data are checked by the subdata base.
Further, second database is used for the data analysis result of first server.
Further, the first database include at least NewSQL database and/or NoSQL database, described second
Database includes at least OldSQL database.
A kind of data base management method, comprising:
Data type is judged, is sorted data into and is stored into first database according to judging result；
The data in first database, which are transferred, according to user command is sent into progress data analysis in corresponding first server,
And analysis result is stored into the second database；
The data in the second database are called according to user command, and establish corresponding subdata base, so that user passes through
The subdata base checks data.
Further, the data base management method further includes verifying to user management permission, specifically includes acquisition
User login information, and judge the administration authority for the number of entering an item in an account book, if the management of the logon account is operated without departing from its administrative power
Limit then allows its management operation.
Further, the first database include at least NewSQL database and/or NoSQL database, described second
Database includes at least OldSQL database.
Compared with prior art, the beneficial effects of the present invention are:
Detailed description of the invention
The accompanying drawings constituting a part of this application is used to provide further understanding of the present application, and the application's shows
Meaning property embodiment and its explanation are not constituted an undue limitation on the present application for explaining the application.
Fig. 1 is database system structure schematic diagram of the invention；
Fig. 2 is data base management method flow chart of the invention.
Specific embodiment
The present invention is described further with specific embodiment with reference to the accompanying drawing.
It is noted that following detailed description is all illustrative, it is intended to provide further instruction to the application.Unless another
It indicates, all technical and scientific terms used herein has usual with the application person of an ordinary skill in the technical field
The identical meanings of understanding.
It should be noted that term used herein above is merely to describe specific embodiment, and be not intended to restricted root
According to the illustrative embodiments of the application.As used herein, unless the context clearly indicates otherwise, otherwise singular
Also it is intended to include plural form, additionally, it should be understood that, when in the present specification using term "comprising" and/or " packet
Include " when, indicate existing characteristics, step, operation, device, component and/or their combination.
As background technique is introduced, existing big data analysis exists in the prior art and is based on a kind of database, nothing more
Method meets growing, wide variety data analysis requirements, and is unable to satisfy conditional data conscientious to user and opens,
The problem of meeting users ' individualized requirement, therefore, this application provides a kind of data base management systems, device and method, pass through
Data bank management device is managed multitype database, and according to user's request call database information, establishes corresponding son
Database, to meet users ' individualized requirement.
As shown in Figure 1, a kind of data base management system, including data bank management device, at least one first database, extremely
A few first server, at least one second database and security server；
The data bank management device is configured as being connected with first database, and stores for sorting data into the
In one database；With
It is connected with first server, and for the data in first database to be sent into first server；
The first server is configured as corresponding with first database, and for the first data sent
Library data carry out data analysis, obtain data analysis result；
Second database, is configured as being connected with data administrator and first server, and for storing first
The data analysis result of server；
The security server is configured as being connected with data bank management device, and the logon rights for verifying user.
The first database includes at least NewSQL database and/or NoSQL database, and second database is at least
Including OldSQL database.
The data bank management device respectively stores data according to judging result for judging data type
To in corresponding first database；
The data bank management device is used to transfer the data in first database according to user command, and is sent into corresponding
Data analysis is carried out in first server；
The data bank management device is used to call the data in the second database according to user command, and establishes corresponding
Subdata base, so that user checks data by the subdata base.
The security server for obtaining user login information, and judges the administration authority for the number of entering an item in an account book, if described step on
The management for recording account is operated without departing from its administration authority, then allows its management operation.
A kind of data bank management device, comprising:
Data acquisition module, for obtaining at least one data；
Data processing module is stored data respectively to right for judging data type, and according to data type
In the first database answered；
User command execution module, for the data in first database to be sent into corresponding first clothes according to user command
It is engaged in device, carries out data analysis；With
For calling the data in the second database according to user command, and corresponding subdata base is established, so that user
Data are checked by the subdata base.
Second database is used for the data analysis result of first server.
The first database includes at least NewSQL database and/or NoSQL database, and second database is at least
Including OldSQL database.
As shown in Fig. 2, a kind of data base management method, comprising:
Data type is judged, is sorted data into and is stored into first database according to judging result；
The data in first database, which are transferred, according to user command is sent into progress data analysis in corresponding first server,
And analysis result is stored into the second database；
The data in the second database are called according to user command, and establish corresponding subdata base, so that user passes through
The subdata base checks data.
The data base management method further includes verifying to user management permission, specifically includes to obtain user and log in and believe
Breath, and judge the administration authority for the number of entering an item in an account book, if the management of the logon account is operated without departing from its administration authority, allow it
Management operation.
The first database includes at least NewSQL database and/or NoSQL database, and second database is at least
Including OldSQL database.
The foregoing is merely preferred embodiment of the present application, are not intended to limit this application, for the skill of this field
For art personnel, various changes and changes are possible in this application.Within the spirit and principles of this application, made any to repair
Change, equivalent replacement, improvement etc., should be included within the scope of protection of this application.
Above-mentioned, although the foregoing specific embodiments of the present invention is described with reference to the accompanying drawings, not protects model to the present invention
The limitation enclosed, those skilled in the art should understand that, based on the technical solutions of the present invention, those skilled in the art are not
Need to make the creative labor the various modifications or changes that can be made still within protection scope of the present invention.
Claims (10)
1. a kind of data base management system, it is characterised in that: including data bank management device, at least one first database, extremely
A few first server, at least one second database and security server；
The data bank management device is configured as being connected with first database, and stores for sorting data into the first number
According in library；With
It is connected with first server, and for the data in first database to be sent into first server；
The first server is configured as corresponding with first database, and for the first database number sent
According to data analysis is carried out, data analysis result is obtained；
Second database, is configured as being connected with data administrator and first server, and for storing first service
The data analysis result of device；
The security server is configured as being connected with data bank management device, and the logon rights for verifying user.
2. a kind of data base management system as described in claim 1, which is characterized in that the first database includes at least
NewSQL database and/or NoSQL database, second database include at least OldSQL database.
3. a kind of data base management system as described in claim 1, which is characterized in that the data bank management device for pair
Data type is judged, and is respectively stored data into corresponding first database according to judging result；
The data bank management device is used to transfer the data in first database according to user command, and is sent into corresponding first
Data analysis is carried out in server；
The data bank management device is used to call the data in the second database according to user command, and establishes corresponding subnumber
According to library, so that user checks data by the subdata base.
4. a kind of data base management system as described in claim 1, which is characterized in that the security server, for obtaining
User login information, and judge the administration authority for the number of entering an item in an account book, if the management of the logon account is operated without departing from its administrative power
Limit then allows its management operation.
5. a kind of data bank management device, it is characterised in that: include:
Data acquisition module, for obtaining at least one data；
Data processing module is stored data respectively to corresponding for judging data type, and according to data type
In first database；
User command execution module, for the data in first database to be sent into corresponding first server according to user command
In, carry out data analysis；With
For calling the data in the second database according to user command, and corresponding subdata base is established, so that user passes through
The subdata base checks data.
6. a kind of data bank management device as claimed in claim 5, which is characterized in that second database is for the first clothes
The data analysis result of business device.
7. a kind of data bank management device as claimed in claim 5, which is characterized in that the first database includes at least
NewSQL database and/or NoSQL database, second database include at least OldSQL database.
8. a kind of data base management method, it is characterised in that: include:
Data type is judged, is sorted data into and is stored into first database according to judging result；
The data in first database are transferred according to user command and are sent into progress data analysis in corresponding first server, and will
Analysis result is stored into the second database；
The data in the second database are called according to user command, and establish corresponding subdata base, so that user is described in
Subdata base checks data.
9. a kind of data base management method as claimed in claim 8, which is characterized in that the data base management method further includes
User management permission is verified, acquisition user login information is specifically included, and judges the administration authority for the number of entering an item in an account book, if institute
The management for stating logon account is operated without departing from its administration authority, then allows its management operation.
10. a kind of data base management method as claimed in claim 8, which is characterized in that the first database includes at least
NewSQL database and/or NoSQL database, second database include at least OldSQL database.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811204935.6A CN109408593A (en) | 2018-10-16 | 2018-10-16 | A kind of data base management system, device and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811204935.6A CN109408593A (en) | 2018-10-16 | 2018-10-16 | A kind of data base management system, device and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109408593A true CN109408593A (en) | 2019-03-01 |
Family
ID=65467296
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811204935.6A Pending CN109408593A (en) | 2018-10-16 | 2018-10-16 | A kind of data base management system, device and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109408593A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103067463A (en) * | 2012-12-19 | 2013-04-24 | 新浪网技术(中国)有限公司 | Centralized management system and centralized management method for user root permission |
| CN105183916A (en) * | 2015-10-16 | 2015-12-23 | 辽宁工程技术大学 | Device and method for managing unstructured data |
| CN107220310A (en) * | 2017-05-11 | 2017-09-29 | 中国联合网络通信集团有限公司 | A kind of database data management system, method and device |
| CN107563219A (en) * | 2017-08-28 | 2018-01-09 | 深圳市华傲数据技术有限公司 | A kind of data base management method and device |
| CN107689949A (en) * | 2017-03-31 | 2018-02-13 | 平安科技（深圳）有限公司 | Data base authority management method and system |
-
2018
- 2018-10-16 CN CN201811204935.6A patent/CN109408593A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN103067463A (en) * | 2012-12-19 | 2013-04-24 | 新浪网技术(中国)有限公司 | Centralized management system and centralized management method for user root permission |
| CN105183916A (en) * | 2015-10-16 | 2015-12-23 | 辽宁工程技术大学 | Device and method for managing unstructured data |
| CN107689949A (en) * | 2017-03-31 | 2018-02-13 | 平安科技（深圳）有限公司 | Data base authority management method and system |
| CN107220310A (en) * | 2017-05-11 | 2017-09-29 | 中国联合网络通信集团有限公司 | A kind of database data management system, method and device |
| CN107563219A (en) * | 2017-08-28 | 2018-01-09 | 深圳市华傲数据技术有限公司 | A kind of data base management method and device |
Non-Patent Citations (1)
| Title |
|---|
| 洪漪 等: "大数据环境下的信息架构与数据模型", 《信息资源管理学报》 * |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN105247529B (en) | The synchronous voucher hash between directory service | |
| US9098535B2 (en) | Global information management system and method | |
| Li | Optimization of the enterprise human resource management information system based on the internet of things | |
| CN108551393A (en) | Lightguide cable link operation management system based on enterprise's intranet and extranet data interchange | |
| CN110109874A (en) | A kind of non-stop layer distributed document retrieval method based on block chain | |
| CN109408488A (en) | A kind of science data information consulting service platform | |
| US20160125070A1 (en) | Unified system for real-time coordination of content-object action items across devices | |
| CN102508919A (en) | Data processing method and system | |
| Cao et al. | To pool or not to pool: Queueing design for large-scale service systems | |
| CN108804241A (en) | Cross-platform method for scheduling task, system, computer equipment and storage medium | |
| CN105450878B (en) | The distribution method and distribution system of resource of attending a banquet code | |
| Park et al. | Future Information Technology: 6th International Conference on Future Information Technology, FutureTech 2011, Crete, Greece, June 28-30, 2011. Proceedings | |
| CN112835784B (en) | Method for evaluating and optimizing interoperation capacity of complex giant system | |
| Baker et al. | The development of a common enumeration of vulnerabilities and exposures | |
| CN109408593A (en) | A kind of data base management system, device and method | |
| CN110110153A (en) | A kind of method and apparatus of node searching | |
| CN112511501A (en) | Data safety monitoring system for 5G application | |
| Oliveira et al. | Evaluating energy efficiency and security for internet of things: a systematic review | |
| Komisarek et al. | Network Intrusion Detection in the Wild-the Orange use case in the SIMARGL project | |
| CN206209712U (en) | A kind of data mining device, application server and server cluster | |
| CN109033810A (en) | A kind of Rights Management System | |
| CN109951376A (en) | A kind of instant message applications information collecting method, device, system and storage medium | |
| CN109361651A (en) | A kind of aggregation gateway | |
| CN107545004A (en) | The method, apparatus and search engine system of a kind of search | |
| Hu et al. | [Retracted] Internet False News Information Feature Extraction and Screening Based on 5G Internet of Things Combined with Passive RFID |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| RJ01 | Rejection of invention patent application after publication |
Application publication date: 20190301 |
|
| RJ01 | Rejection of invention patent application after publication |