CN109542870A - Database data management method and system - Google Patents
Database data management method and system Download PDFInfo
- Publication number
- CN109542870A CN109542870A CN201811233409.2A CN201811233409A CN109542870A CN 109542870 A CN109542870 A CN 109542870A CN 201811233409 A CN201811233409 A CN 201811233409A CN 109542870 A CN109542870 A CN 109542870A
- Authority
- CN
- China
- Prior art keywords
- data
- database
- different
- module
- management
- 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
Abstract
The present invention provides a kind of database data management method and system, which comprises according to different user roles, the permission of setting access database；According to the different type of tables of data, database is divided into different submodules；According to the document that user provides, different tables of data is created under different submodules；It is shown and the record in management data list according to different tables of data.Database data management method according to an embodiment of the present invention, is managed by the way that database is divided into multiple submodule, and different tables of data can be created under different submodules, realizes that the automation of data imports；Database can be safeguarded by multiple personnel, be reduced costs, and save the analysis time of database, and low to the requirement of the professional knowledge of personnel, convenient for management.
Description
Technical field
The present invention relates to field of database management, more particularly, to a kind of database data management method and database
Data management system.
Background technique
During system deployment, many times the source of data is different, and system implements have certain periodicity.It can
Deployment is good in production environment for energy system, but can not take data due to various aspects, in the short time, still
User wants to see final effect interface again.At this time majority of case can select the mode imported by hand, and data are directly sharp
With the tool of similar navicate etc., it is importing directly into data.
In actual application scenarios, the time for giving related personnel's importing data is limited, and needs to import people
Member knows quite well the structure of entire database, the related service being related to, and causes to have the following problems: needing specified personnel
It is specially safeguarded, executes the work such as importing, the deletion of data；Understanding, the arrangement works amount of analytical database are big；Due to being hand
Work operation, will lead to time lag.Accordingly, there exist improve to need.
Summary of the invention
In view of this, the present invention provides a kind of database data management method and system, the automation of data can be realized
It imports, it is low to the professional knowledge requirement of personnel, reduce cost.
In order to solve the above technical problems, on the one hand, the present invention provides a kind of database data management method, the method packet
It includes: according to different user roles, the permission of setting access database；According to the different type of tables of data, database is divided
For different submodules；According to the document that user provides, different tables of data is created under different submodules；According to different
Tables of data is shown and the record in management data list.
According to some embodiments of the present invention, the method also includes: according to user provide document, to the word of tables of data
Segment information is safeguarded.
Second aspect, the embodiment of the present invention provide a kind of database data management system, comprising: priority assignation module, institute
Priority assignation module is stated for the permission according to different user role setting access databases；Module management module, the mould
The database can be divided into different submodules and is managed to the submodule by block management module；Management data table
Module, the management data table module can create different tables of data under different submodules；Data display module, it is described
Data display module can be shown and the record in management data list according to different tables of data.
According to some embodiments of the present invention, the priority assignation module can be arranged according to different user roles and access
The permission of different submodules.
According to some embodiments of the present invention, the module management module is in user maintenance data, according to tables of data
The database is divided into the different submodules by different type.
According to some embodiments of the present invention, multiple submodules are divided into multiple levels.
According to some embodiments of the present invention, the document that the management data table module is provided according to user is in different institutes
It states and creates different tables of data under submodule.
According to some embodiments of the present invention, the management data table module can tie up the field information of tables of data
Shield.
According to some embodiments of the present invention, the field information includes code table information and external key.
According to some embodiments of the present invention, the database data management system is developed using Java language, client
It is developed using vue.js.
Above-mentioned technical proposal of the invention one of at least has the advantages that:
Database data management method and system according to an embodiment of the present invention, by the way that database is divided into multiple submodules
Block is managed, and different tables of data can be created under different submodules, realizes that the automation of data imports；Data
Library can be safeguarded by multiple personnel, be reduced costs, and save the analysis time of database, and to the professional knowledge of personnel
It is required that it is low, it is convenient for management.
Detailed description of the invention
Fig. 1 is the flow chart of the database data management method of the embodiment of the present invention；
Fig. 2 is the schematic diagram of the database data management system of the embodiment of the present invention；
Fig. 3 is the schematic diagram of the electronic equipment of the embodiment of the present invention.
Appended drawing reference:
Database data management method 100；
Database data management system 200；
Priority assignation module 210；Module management module 220；Management data table module 230；Data display module 240；
Electronic equipment 300；
Memory 310；Operating system 311；Application program 312；
Processor 320；Network interface 330；Input equipment 340；Hard disk 350；Show equipment 360.
Specific embodiment
Below in conjunction with drawings and examples, specific embodiments of the present invention will be described in further detail.Following reality
Example is applied for illustrating the present invention, but is not intended to limit the scope of the invention.
Database data management method 100 according to an embodiment of the present invention is specifically described in conjunction with attached drawing first below.
As shown in Figure 1, database data management method 100 according to an embodiment of the present invention includes:
According to different user roles, the permission of setting access database.
According to the different type of tables of data, database is divided into different submodules.
According to the document that user provides, different tables of data is created under different submodules.
It is shown and the record in management data list according to different tables of data.
In other words, database data management method 100 according to an embodiment of the present invention mainly can in terms of four logarithm
According to library carry out data management, first, according to different user role, the module of its Internet access is set, realizes system permission
Effectively management；Second, user, according to the different type of tables of data, database is divided into safeguarding relevant data procedures
Different submodules, allows that there are the submodules of multiple levels；Third, the document that user provides according to related management personnel,
Different tables of data is created under different submodules；4th, the note according to different tables of data, in display or increase tables of data
Record, while providing the function that batch imports.
Preferably, database data management method 100 further include: according to the document that user provides, to the field of tables of data
Information is safeguarded, wherein field information may include code table information, external key etc..
Database data management method 100 according to an embodiment of the present invention as a result, by the way that database is divided into multiple sons
Module is managed, and different tables of data can be created under different submodules, realizes that the automation of data imports；Number
It can be safeguarded, be reduced costs by multiple personnel according to library, save the analysis time of database, and know the profession of personnel
Knowledge require it is low, it is convenient for management.
As shown in Fig. 2, database data management system 200 according to an embodiment of the present invention includes: priority assignation module
210, module management module 220, management data table module 230 and data display module 240.
Specifically, the priority assignation module 210 is used for the permission according to different user role setting access databases,
The database can be divided into different submodules and is managed to the submodule by the module management module 220,
The management data table module 230 can create different tables of data, the data display module 240 under different submodules
It can be shown according to different tables of data and the record in management data list.
That is, database data management system 200 according to an embodiment of the present invention is mainly by priority assignation module
210, four module compositions such as module management module 220, management data table module 230 and data display module 240, each module
Corresponding function can be realized respectively, wherein the permission in user accesses data library can be set in priority assignation module 210, realizes
Database can be divided into different submodules by effective management of system permission, module management module 220, and to submodule into
Row management；Management data table module 230 can create different tables of data, data display module 240 under different submodules
Then it can be shown according to different tables of data and increase the record in tables of data, while also provide the function that batch imports.
Database data management system 200 according to an embodiment of the present invention as a result, by the way that database is divided into multiple sons
Module is managed, and different tables of data can be created under different submodules, realizes that the automation of data imports；Number
It can be safeguarded, be reduced costs by multiple personnel according to library, save the analysis time of database, and know the profession of personnel
Knowledge require it is low, it is convenient for management.
According to one embodiment of present invention, the priority assignation module 210 can be arranged according to different user roles
Access the permission of different submodules.The setting for passing through priority assignation module 210, can be such that different user roles is accessed
The permission of different submodules.
In certain specific embodiments of the invention, the module management module 220 in user maintenance data, according to
The database is divided into the different submodules by the different type of tables of data.Preferably, multiple submodules are divided into
Multiple levels.Database is divided into multiple and different submodules as a result, can be safeguarded, be reduced costs by multiple personnel, section
The analysis time of database is saved.
Optionally, according to one embodiment of present invention, the document that the management data table module 230 is provided according to user
Different tables of data is created under the different submodules.Preferably, the management data table module 230 can be to tables of data
Field information safeguarded.Further, the field information includes code table information and external key.
That is, the document that user can provide according to related management personnel, creates difference under different submodules
Tables of data, while the field information of tables of data is safeguarded, the field information of tables of data includes code table information, external key etc..
According to one embodiment of present invention, the database data management system is developed using Java language, client
It is developed using vue.js.
Wherein, Java is a kind of object oriented program language that can write cross-platform program.Java skill
Art has brilliant versatility, high efficiency, platform transplantation and safety, is widely used in PC, data center, game control
Platform, scientific supercomputer, mobile phone and internet.
Data base management system is developed using Java language as a result, and the importing of data can be realized in the background, client
It is developed using vue.js, can safeguard different form datas, not only reduce maintenance cost, save point of database
It analyses the time, and the professional knowledge of personnel is required lower.
In addition, the computer storage medium includes one or more the present invention also provides a kind of computer storage medium
Computer instruction, one or more computer instruction realize any of the above-described database data manager when being executed
Method 100.
That is, the computer storage medium is stored with computer program, the computer program is transported by processor
When row, so that the processor executes any of the above-described database data management method 100.
As shown in figure 3, the embodiment of the invention provides a kind of electronic equipment 300, including memory 310 and processor 320,
The memory 310 is for storing one or more computer instruction, and the processor 320 is for calling and executing described one
Or a plurality of computer instruction, to realize any of the above-described method.
That is, electronic equipment 300 includes: processor 320 and memory 310, it is stored in the memory 310
Computer program instructions, wherein when the computer program instructions are run by the processor, so that the processor 320
Execute any of the above-described method 100.
Further, as shown in figure 3, electronic equipment 300 further include network interface 330, input equipment 340, hard disk 350,
With display equipment 360.
It can be interconnected by bus architecture between above-mentioned each interface and equipment.It may include any that bus architecture, which can be,
The bus and bridge of the interconnection of quantity.One or more central processing unit (CPU) specifically represented by processor 320, Yi Jiyou
The various circuit connections for one or more memory that memory 310 represents are together.Bus architecture can also will be such as outer
Peripheral equipment, voltage-stablizer are together with the various other circuit connections of management circuit or the like.It is appreciated that bus architecture is used
Connection communication between these components of realization.Bus architecture further includes power bus, controls always in addition to including data/address bus
Line and status signal bus in addition, these are all it is known in the art, therefore is no longer described in greater detail herein.
The network interface 330 can connect to network (such as internet, local area network), dependency number obtained from network
According to, and can be stored in hard disk 350.
The input equipment 340, can receive operator input various instructions, and be sent to processor 320 for
It executes.The input equipment 340 may include keyboard or pointing device (for example, mouse, trace ball (trackball), sense of touch
Plate or touch screen etc..
The display equipment 360, the result that processor 320 executes instruction acquisition can be shown.
The memory 310, program necessary to running for storage program area and data and processor 320 are counted
The data such as the intermediate result during calculation.
It is appreciated that the memory 310 in the embodiment of the present invention can be volatile memory or nonvolatile memory,
It or may include both volatile and non-volatile memories.Wherein, nonvolatile memory can be read-only memory (ROM),
Programmable read only memory (PROM), Erasable Programmable Read Only Memory EPROM (EPROM), electrically erasable programmable read-only memory
(EEPROM) or flash memory.Volatile memory can be random access memory (RAM), be used as External Cache.Herein
The memory 310 of the device and method of description is intended to include but is not limited to the memory of these and any other suitable type.
In some embodiments, memory 310 stores following element, executable modules or data structures, or
Their subset of person or their superset: operating system 311 and application program 312.
Wherein, operating system 311 include various system programs, such as ccf layer, core library layer, driving layer etc., for real
Existing various basic businesses and the hardware based task of processing.Application program 312 includes various application programs, such as browser
(Browser) etc., for realizing various applied business.Realize that the program of present invention method may be embodied in application program
In 312.
The method that the above embodiment of the present invention discloses can be applied in processor 320, or be realized by processor 320.
Processor 320 may be a kind of IC chip, the processing capacity with signal.During realization, the above method it is each
Step can be completed by the integrated logic circuit of the hardware in processor 320 or the instruction of software form.Above-mentioned processing
Device 320 can be general processor, digital signal processor (DSP), specific integrated circuit (ASIC), ready-made programmable gate array
(FPGA) either other programmable logic device, discrete gate or transistor logic, discrete hardware components, may be implemented or
Person executes disclosed each method, step and the logic diagram in the embodiment of the present invention.General processor can be microprocessor or
Person's processor is also possible to any conventional processor etc..The step of method in conjunction with disclosed in the embodiment of the present invention, can be straight
Connect and be presented as that hardware decoding processor executes completion, or in decoding processor hardware and software module combination executed
At.Software module can be located at random access memory, and flash memory, read-only memory, programmable read only memory or electrically-erasable can
In the storage medium of this fields such as programmable memory, register maturation.The storage medium is located at memory 310, and processor 320 is read
Information in access to memory 310, in conjunction with the step of its hardware completion above method.
It is understood that embodiments described herein can with hardware, software, firmware, middleware, microcode or its
Combination is to realize.For hardware realization, processing unit be may be implemented in one or more specific integrated circuits (ASIC), number letter
Number processor DSP), digital signal processing appts (DSPD), programmable logic device (PLD), field programmable gate array
(FPGA), general processor, controller, microcontroller, microprocessor, other electronics lists for executing herein described function
In member or combinations thereof.
For software implementations, it can be realized herein by executing the module (such as process, function etc.) of function described herein
The technology.Software code is storable in memory and is executed by processor.Memory can in the processor or
It is realized outside processor.
Specifically, processor 320 is also used to read the computer program, executes any of the above-described method.
In several embodiments provided herein, it should be understood that disclosed method and apparatus, it can be by other
Mode realize.For example, the apparatus embodiments described above are merely exemplary, for example, the division of the unit, only
For a kind of logical function partition, there may be another division manner in actual implementation, such as multiple units or components can combine
Or it is desirably integrated into another system, or some features can be ignored or not executed.Another point, shown or discussed phase
Coupling, direct-coupling or communication connection between mutually can be through some interfaces, the INDIRECT COUPLING or communication of device or unit
Connection can be electrical property, mechanical or other forms.
It, can also be in addition, the functional units in various embodiments of the present invention may be integrated into one processing unit
It is that the independent physics of each unit includes, can also be integrated in one unit with two or more units.Above-mentioned integrated list
Member both can take the form of hardware realization, can also realize in the form of hardware adds SFU software functional unit.
The above-mentioned integrated unit being realized in the form of SFU software functional unit can store and computer-readable deposit at one
In storage media.Above-mentioned SFU software functional unit is stored in a storage medium, including some instructions are used so that a computer
Equipment (can be personal computer, server or the network equipment etc.) executes receiving/transmission method described in each embodiment of the present invention
Part steps.And storage medium above-mentioned includes: USB flash disk, mobile hard disk, read-only memory (Read-Only Memory, abbreviation
ROM), random access memory (Random Access Memory, abbreviation RAM), magnetic or disk etc. are various can store
The medium of program code.
The above is a preferred embodiment of the present invention, it is noted that for those skilled in the art
For, without departing from the principles of the present invention, it can also make several improvements and retouch, these improvements and modifications
It should be regarded as protection scope of the present invention.
Claims (10)
1. a kind of database data management method, which is characterized in that the described method includes:
According to different user roles, the permission of setting access database；
According to the different type of tables of data, database is divided into different submodules；
According to the document that user provides, different tables of data is created under different submodules；
It is shown and the record in management data list according to different tables of data.
2. the method according to claim 1, wherein the method also includes:
According to the document that user provides, the field information of tables of data is safeguarded.
3. a kind of database data management system characterized by comprising
Priority assignation module, the priority assignation module are used for the permission according to different user role setting access databases；
The database can be divided into different submodules and to the son by module management module, the module management module
Module is managed；
Management data table module, the management data table module can create different tables of data under different submodules；
Data display module, the data display module can be shown and the note in management data list according to different tables of data
Record.
4. database data management system according to claim 3, which is characterized in that the priority assignation module being capable of root
The permission of different submodules is accessed according to different user role settings.
5. database data management system according to claim 3, which is characterized in that the module management module is in user
When safeguarding data, according to the different type of tables of data, the database is divided into the different submodules.
6. database data management system according to claim 5, which is characterized in that multiple submodules are divided into multiple
Level.
7. database data management system according to claim 3, which is characterized in that the management data table module according to
The document that user provides creates different tables of data under the different submodules.
8. database data management system according to claim 3, which is characterized in that the management data table module can
The field information of tables of data is safeguarded.
9. database data management system according to claim 8, which is characterized in that the field information includes code table letter
Breath and external key.
10. database data management system according to claim 3, which is characterized in that database data management system
System is developed using Java language, and client is developed using vue.js.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811233409.2A CN109542870A (en) | 2018-10-23 | 2018-10-23 | Database data management method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201811233409.2A CN109542870A (en) | 2018-10-23 | 2018-10-23 | Database data management method and system |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN109542870A true CN109542870A (en) | 2019-03-29 |
Family
ID=65844258
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201811233409.2A Pending CN109542870A (en) | 2018-10-23 | 2018-10-23 | Database data management method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN109542870A (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243851A1 (en) * | 2003-05-28 | 2004-12-02 | Chung-I Lee | System and method for controlling user authorities to access one or more databases |
| CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
| CN102724221A (en) * | 2011-03-30 | 2012-10-10 | 上海微河信息科技有限公司 | Enterprise information system using cloud computing and method for setting user authority thereof |
| CN104298726A (en) * | 2014-09-26 | 2015-01-21 | 惠州市亿能电子有限公司 | BMS data storage system and method based on database |
| CN108388599A (en) * | 2018-02-01 | 2018-08-10 | 平安科技（深圳）有限公司 | Electronic device, Data Migration and call method and storage medium |
-
2018
- 2018-10-23 CN CN201811233409.2A patent/CN109542870A/en active Pending
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20040243851A1 (en) * | 2003-05-28 | 2004-12-02 | Chung-I Lee | System and method for controlling user authorities to access one or more databases |
| CN102063479A (en) * | 2010-12-22 | 2011-05-18 | 北京中电普华信息技术有限公司 | Method and system for controlling data access right |
| CN102724221A (en) * | 2011-03-30 | 2012-10-10 | 上海微河信息科技有限公司 | Enterprise information system using cloud computing and method for setting user authority thereof |
| CN104298726A (en) * | 2014-09-26 | 2015-01-21 | 惠州市亿能电子有限公司 | BMS data storage system and method based on database |
| CN108388599A (en) * | 2018-02-01 | 2018-08-10 | 平安科技（深圳）有限公司 | Electronic device, Data Migration and call method and storage medium |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US20230032882A1 (en) | Systems and methods for database investigation tool | |
| US10198425B2 (en) | Methods and apparatus for reusing report design components and templates | |
| US7451459B2 (en) | Systems, methods, and apparatus for indicating processor hierarchical topology | |
| WO2021051546A1 (en) | Link abnormality recognition method, server and computer-readable storage medium | |
| CN111475262B (en) | Transaction request processing method, device, equipment and medium in blockchain | |
| EP2245552A1 (en) | Multi-threaded codeless user-defined functions | |
| US20080155518A1 (en) | Methods and apparatus for tokenizing workflow process objects | |
| CN112181962A (en) | Report form checking method, device, equipment and storage medium | |
| US20220067180A1 (en) | Security policy management for database | |
| CN110716960B (en) | Database query method, device, equipment and storage medium | |
| US10747766B2 (en) | Context based access path selection | |
| JP2007532997A (en) | Method and apparatus for constructing representations of objects and entities | |
| CN109542870A (en) | Database data management method and system | |
| US11914557B2 (en) | Techniques for performing lifecycle operations on a data store | |
| CN104714883A (en) | Method and equipment for improving efficiency on tracing array by dynamically allocating timestamp counters | |
| US20120123955A1 (en) | Calculation engine for compensation planning | |
| US20160140156A1 (en) | Distributed storage system with pluggable query processing | |
| US20210241328A1 (en) | Techniques and Architectures for Customizable Modular Line Item Evaluation | |
| CN113609128A (en) | Method and device for generating database entity class, terminal equipment and storage medium | |
| CN109558181A (en) | Method, computer storage medium and the equipment of the compatible OCX control of non-IE browser | |
| US7991743B2 (en) | User-definable run-time grouping of data records | |
| US20050102311A1 (en) | Method and system for direct linkage of a relational database table for data preparation | |
| CN113312410B (en) | Data map construction method, data query method and terminal equipment | |
| Janjusic et al. | Trace driven data structure transformations | |
| Dixon et al. | A portable, extensible and fast stochastic volatility model calibration using multi and many‐core processors |
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: 20190329 |
|
| RJ01 | Rejection of invention patent application after publication |