CN107203615A - The system and method that database configuration and management are realized in Bat orders are carried based on Windows - Google Patents

The system and method that database configuration and management are realized in Bat orders are carried based on Windows Download PDF

Info

Publication number
CN107203615A
CN107203615A CN201710369781.5A CN201710369781A CN107203615A CN 107203615 A CN107203615 A CN 107203615A CN 201710369781 A CN201710369781 A CN 201710369781A CN 107203615 A CN107203615 A CN 107203615A
Authority
CN
China
Prior art keywords
user
data
database
module
bat
Prior art date
Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
Granted
Application number
CN201710369781.5A
Other languages
Chinese (zh)
Other versions
CN107203615B (en
Inventor
王新亚
赵小强
王勇
Current Assignee (The listed assignees may be inaccurate. Google has not performed a legal analysis and makes no representation or warranty as to the accuracy of the list.)
Suzhou Inspur Intelligent Technology Co Ltd
Original Assignee
Zhengzhou Yunhai Information Technology Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Zhengzhou Yunhai Information Technology Co Ltd filed Critical Zhengzhou Yunhai Information Technology Co Ltd
Priority to CN201710369781.5A priority Critical patent/CN107203615B/en
Publication of CN107203615A publication Critical patent/CN107203615A/en
Application granted granted Critical
Publication of CN107203615B publication Critical patent/CN107203615B/en
Active legal-status Critical Current
Anticipated expiration legal-status Critical

Links

Classifications

    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/21Design, administration or maintenance of databases
    • GPHYSICS
    • G06COMPUTING; CALCULATING OR COUNTING
    • G06FELECTRIC DIGITAL DATA PROCESSING
    • G06F21/00Security arrangements for protecting computers, components thereof, programs or data against unauthorised activity
    • G06F21/60Protecting data
    • G06F21/62Protecting access to data via a platform, e.g. using keys or access control rules
    • G06F21/6218Protecting 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

Landscapes

  • Engineering & Computer Science (AREA)
  • Theoretical Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Physics & Mathematics (AREA)
  • General Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • Bioethics (AREA)
  • Software Systems (AREA)
  • Computer Security & Cryptography (AREA)
  • Computer Hardware Design (AREA)
  • General Health & Medical Sciences (AREA)
  • Health & Medical Sciences (AREA)
  • Data Mining & Analysis (AREA)
  • Storage Device Security (AREA)

Abstract

The system and method that database configuration and management are realized in Bat orders are carried based on Windows the invention discloses a kind of, including user right is distributed and login for user right and check priority assignation and correction verification module;Verification Input Interface Control is carried out to the integrality that information is inputted in user's operating process and module is checked;For generating dynamic password, the dynamic password verified to the dynamic password that user inputs is set and correction verification module;Carry out database command conversion and perform, Query Result gives customer data base enquiry module;User is inputted after primary data information (pdi) by prompting, program carries out Data Enter, is verified and is returned to input result, the data inputting module confirmed to user;Deletion action is carried out by user's input condition, the data removing module for deleting result is verified and return;User sets up database and tables of data by option mode and carries out database by option, the database of backup and the recovery of data is created and data backup and resume module.

Description

Based on Windows carry Bat orders realize database configuration and management system and Method
Technical field
The present invention relates to factory's large-scale data technical field of measurement and test, to test data, the management of test database and dimension Shield, more particularly to a kind of method for carrying Bat orders based on Windows to realize test database configuration and management, pass through Bat Program realizes convenient, the efficient and foolproof management of the configuration, management and regular maintenance of test database, to ensure server The safety of data and the stabilization of test.
Background technology
Some current small manufacturing enterprises and supplier, during production and management, there is test data management aspect Demand.But technical force not enough, can not oneself exploitation, using Large-scale professional management software in cost and technology all Be short of, specific aim it is not strong, and the management software of some system integrations is strongly professional, and configuration and management database need Spend a lot of time to learn, and need certain experience accumulation, manager-related factors require high, by enterprise is small, personnel Technical merit and production, test, management cost are limited, it is impossible to meeting being actually needed for these enterprises, current city well Still lack the management software and instrument of simple efficient and easy left-hand seat on field, in view of the situation we have developed based on Windows carry the Bat programs of order realize test database configuration, management and regular maintenance it is convenient, efficient and stupid Melon formula is managed, to ensure the safety of server data and the stabilization of test.
The content of the invention
For solving the above-mentioned problems of the prior art, it is an object of the present invention to provide one kind is carried based on Windows Bat orders come realize test database configuration and management system and method;The method of the present invention is easily understood, efficiently, general Property it is good, easy to operate, cost is low, manufacturing enterprise is not required to the abilities that a large amount of inputs just possess configuration and management database, utilizes use Family rights management and dynamic password management, security reliability height, it is ensured that the security of database data.
The present invention solve technical problem technical scheme be:
It is a kind of Bat orders are carried based on Windows come realize test database configuration and management system, the system by The user of authority is set to be completed by database management operation, including:
It is main to be responsible for user right distribution and login user right inspection priority assignation and correction verification module;
It is main to be responsible for carrying out verification Input Interface Control to the integrality for inputting information in user's operating process and check mould Block;
It is mainly used to generate dynamic password, and the dynamic password that the dynamic password inputted to user is verified is set and school Test module;
Database command conversion is carried out for the different querying condition of user and is performed, and then prints Query Result to user Database query module;
Inputted for user by prompting after primary data information (pdi), program carries out Data Enter, verify and return to input result, The data inputting module confirmed to user is printed with inquiry mode;
Need to carry out deletion action during suppressing exception data, by user's input condition for user, verify and return to deletion As a result, the data removing module confirmed to user is printed with inquiry mode;
User sets up database and tables of data by option mode and carries out database, the backup of data and extensive by option Multiple database is created and data backup and resume module.
A kind of method for carrying Bat orders based on Windows to realize test database configuration and management system,
Mainly comprise the following steps:
1) program basic parameter information configuration, user believes according to configuration parameters such as use environment, security, use habits Breath;
2) user selects database manipulation option and verifies authorization privilege according to actual grant authority, the letter such as dynamic password Breath;
3) after authority and password authentification terminate, inputted according to prompting, program can carry out corresponding database manipulation, and print Operating result;After this terminates, continuation can be returned according to demand or is exited.
Comprise the following steps that:
1) priority assignation and correction verification module, are mainly responsible for user right distribution and login user right inspection, Yong Hudeng After entering, according to the corresponding operating right of authority distribution;
2) Input Interface Control and inspection module, it is main to be responsible for carrying out the integrality for inputting information in user's operating process Verification;
3) dynamic password is set and correction verification module, is mainly used to generate dynamic password, and to the dynamic password of user's input Verified;
4) database query module, carries out database command conversion for the different querying condition of user and performs, then Query Result is printed to user;
5) data inputting module, after user is by prompting input primary data information (pdi), program carries out Data Enter, verifies and returns Input result is returned, is printed and confirmed to user with inquiry mode;
6) data removing module, when user needs suppressing exception data, deletion action, verification are carried out by user's input condition And deletion result is returned, printed and confirmed to user with inquiry mode;
7) database is created and data backup and resume module, user is set up database sum by option mode According to table, and pass through option progress database, the backup and recovery of data.
It is specific to be completed using following steps:
1) data base administration main program is utilized, program main menu selection interface is developed based on BAT orders, each work(is integrated Energy program module, realizes the connection of main-menu option and program execution module, reaches management and safeguards database function;
2) priority assignation and correction verification module, development of user authority recognition and checking routine based on BAT orders;
3) input and correction verification module, development of user inputting interface and Input Data Verification program based on BAT orders;
4) password is set and correction verification module, and development behavior password is generated based on BAT orders, and user's input password school Test program;
5) data inquiry module, combines database client utility based on BAT orders, and realization is looked into according to querying condition Database is ask, and type information is to user;
6) data inputting module, combines database client utility based on BAT orders, and realization is entered according to typing condition Row data inputting, and type information is to user;
7) data removing module, combines database client utility based on BAT orders, and realization is deleted according to conditional information Except data, and type information is to user;
8) DB Backup and recovery module, based on BAT orders combine database client utility, realize according to Family option creates database, tables of data, an one-key backup database and data, the function such as One-key recovery database and data.
Beneficial effects of the present invention:
1. the method that the present invention realizes test database configuration and management by carrying Bat orders based on Windows, Order is carried based on Bat under Windows, the method that complete black box data base administration is safeguarded is realized, with program is small, versatility It is good, support local remote operation, simple to operate, authority and dynamic password combine and meet database manipulation security requirement.This hair The bright difficulty for simplifying database manipulation maintenance, realizes the simplification of database maintenance, reduces technical difficulty, more laminating enterprise Industry mobility of people is big, and the orientation time is short, the characteristics of Personnel Skill Levels are not high.
, can even running under all Windows system environments 2. versatility of the present invention is good;
3. the present invention is applicable the safety management mode of permission grant and dynamic password combination, improve database maintenance can By property.
Brief description of the drawings
Fig. 1 is modular structure schematic diagram of the invention;
Fig. 2 is illustrative view of functional configuration of the invention.
Embodiment
For a better understanding of the present invention, embodiments of the present invention are explained in detail below in conjunction with the accompanying drawings.
The present invention realizes one kind and carries order based on conventional Windows systems, allows user to realize number by option operations According to the system and method for library management, the present invention supports local management and passes through network remote management.Illustrated with reference to Fig. 1, Fig. 2 It is as follows:
Fig. 1 is modular structure schematic diagram of the invention.One kind carries Bat orders based on Windows to realize test data The system that storehouse configures and managed, the system is completed by the user of setting authority by database management operation, including:
It is main to be responsible for user right distribution and login user right inspection priority assignation and correction verification module;
It is main to be responsible for carrying out verification Input Interface Control to the integrality for inputting information in user's operating process and check mould Block;
It is mainly used to generate dynamic password, and the dynamic password that the dynamic password inputted to user is verified is set and school Test module;
Database command conversion is carried out for the different querying condition of user and is performed, and then prints Query Result to user Database query module;
Inputted for user by prompting after primary data information (pdi), program carries out Data Enter, verify and return to input result, The data inputting module confirmed to user is printed with inquiry mode;
Need to carry out deletion action during suppressing exception data, by user's input condition for user, verify and return to deletion As a result, the data removing module confirmed to user is printed with inquiry mode;
User sets up database and tables of data by option mode and carries out database, the backup of data and extensive by option Multiple database is created and data backup and resume module.
One kind carries order based on conventional Windows systems, allows user to realize the side of data base administration by option operations Method, mainly comprises the following steps:
1) program basic parameter information configuration, user believes according to configuration parameters such as use environment, security, use habits Breath;
2) user selects database manipulation option and verifies authorization privilege according to actual grant authority, the letter such as dynamic password Breath;
3) after authority and password authentification terminate, inputted according to prompting, program can carry out corresponding database manipulation, and print Operating result;After this terminates, continuation can be returned according to demand or is exited.
With reference to Fig. 2, Fig. 2 is illustrative view of functional configuration of the invention.Specifically include following steps:
(1) priority assignation and correction verification module, are mainly responsible for user right distribution and login user right inspection, Yong Hudeng After entering, according to the corresponding operating right of authority distribution;
(2) Input Interface Control and inspection module, main to be responsible for entering the integrality for inputting information in user's operating process Row verification;
(3) dynamic password is set and correction verification module, is mainly used to generate dynamic password, and to the dynamic password of user's input Verified;
(4) database query module, carries out database command conversion for the different querying condition of user and performs, then Query Result is printed to user;
(5) data inputting module, after user is by prompting input primary data information (pdi), program carries out Data Enter, and verification is simultaneously Input result is returned, is printed and confirmed to user with inquiry mode;
(6) data removing module, when user needs suppressing exception data, deletion action, school are carried out by user's input condition Test and return to deletion result, printed and confirmed to user with inquiry mode;
(7) database create and data backup and resume module, allow user by option mode set up database and Tables of data, and pass through option progress database, the backup and recovery of data.
Described step describes in detail as follows:
1. utilizing data base administration main program, program main menu selection interface is developed based on BAT orders, each work(is integrated Energy program module, realizes the connection of main-menu option and program execution module, reaches management and safeguards database function;
2. utilize priority assignation and correction verification module, development of user authority recognition and checking routine based on BAT orders;
3. using Input Interface Control and module is checked, development of user inputting interface and input number based on BAT orders According to checking routine;
4. being set using dynamic password and correction verification module, development behavior password is generated based on BAT orders, and user is defeated Enter cryptographic check program;
5. utilizing database query module, database client utility is combined based on BAT orders, is realized according to inquiry Condition query database, and type information is to user;
6. utilizing data inputting module, database client utility is combined based on BAT orders, is realized according to typing bar Part carries out data inputting, and type information is to user;
7. utilizing data removing module, database client utility is combined based on BAT orders, realization is believed according to condition Breath deletes data, and type information is to user;
8. being created using database and data backup and resume module, database client is combined based on BAT orders Instrument, realizes and creates database according to user option, tables of data, an one-key backup database and data, One-key recovery database and The functions such as data.
Although above-mentioned the embodiment of invention is described with reference to accompanying drawing, not to the scope of the present invention Limitation, on the basis of technical scheme, those skilled in the art need not pay creative work and can make Various modifications or deform still within protection scope of the present invention.

Claims (4)

1. a kind of carry the system that database configuration and management are realized in Bat orders based on Windows, the system is by setting authority User completed by database management operation, it is characterized in that, including:
It is main to be responsible for user right distribution and login user right inspection priority assignation and correction verification module;
It is main to be responsible for carrying out verification Input Interface Control to the integrality for inputting information in user's operating process and check module;
It is mainly used to generate dynamic password, and the dynamic password that the dynamic password inputted to user is verified is set and calibration mode Block;
Database command conversion is carried out for the different querying condition of user and is performed, and then prints Query Result to user data Library inquiry module;
Inputted for user by prompting after primary data information (pdi), program carries out Data Enter, verify and return to input result, to look into Inquiry mode prints the data inputting module confirmed to user;
Need to carry out deletion action during suppressing exception data, by user's input condition for user, verify and return to deletion result, The data removing module confirmed to user is printed with inquiry mode;
User sets up database and tables of data by option mode and carries out database, the backup of data and recovery by option Database is created and data backup and resume module.
2. the system that database configuration and management are realized in Bat orders is carried based on Windows described in a kind of utilization claim 1 Method, it is characterized in that, mainly comprise the following steps:
1) program basic parameter information configuration, user is according to use environment, security, use habit configuration parameter information;
2) user selects database manipulation option and verifies authorization privilege, dynamic password information according to actual grant authority;
3) after authority and password authentification terminate, inputted according to prompting, program can carry out corresponding database manipulation, and printing As a result;After this terminates, continuation can be returned according to demand or is exited.
A kind of Bat orders are carried based on Windows realize database configuration and the system managed 3. as claimed in claim 2 Method, it is characterized in that, comprise the following steps that:
1) distributed for user right using priority assignation and correction verification module and login user right inspection, after user logins, according to The corresponding operating right of authority distribution;
2) integrality that information is inputted in user's operating process is verified using Input Interface Control and inspection module;
3) set using dynamic password and correction verification module is used for generating dynamic password, and school is carried out to the dynamic password that user inputs Test;
4) carry out database command conversion using database query module, for the different querying condition of user and perform, then Query Result is printed to user;
5) data inputting module is utilized, after user is by prompting input primary data information (pdi), program carries out Data Enter, and verification is simultaneously Input result is returned, is printed and confirmed to user with inquiry mode;
6) data removing module is utilized, when user needs suppressing exception data, deletion action, school are carried out by user's input condition Test and return to deletion result, printed and confirmed to user with inquiry mode;
7) created and data backup and resume module using database, user is set up database sum by option mode According to table, and pass through option progress database, the backup and recovery of data.
A kind of Bat orders are carried based on Windows realize database configuration and the system managed 4. as claimed in claim 3 Method, it is characterized in that, it is specific to be completed using following steps:
1) data base administration main program is utilized, program main menu selection interface is developed based on BAT orders, each function journey is integrated Sequence module, realizes the connection of main-menu option and program execution module, reaches management and safeguards database function;
2) priority assignation and correction verification module, development of user authority recognition and checking routine based on BAT orders;
3) input and correction verification module, development of user inputting interface and Input Data Verification program based on BAT orders;
4) password is set and correction verification module, and development behavior password is generated based on BAT orders, and user's input cryptographic check journey Sequence;
5) data inquiry module, combines database client utility based on BAT orders, realizes and inquires about number according to querying condition According to storehouse, and type information is to user;
6) data inputting module, combines database client utility based on BAT orders, and realization enters line number according to typing condition According to typing, and type information is to user;
7) data removing module, combines database client utility based on BAT orders, realizes and deletes number according to conditional information According to, and type information is to user;
8) DB Backup and recovery module, combine database client utility based on BAT orders, and realization is selected according to user Item creates database, tables of data, an one-key backup database and data, One-key recovery database and data function.
CN201710369781.5A 2017-05-23 2017-05-23 System and method for realizing database configuration and management based on Windows self-contained Bat command Active CN107203615B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
CN201710369781.5A CN107203615B (en) 2017-05-23 2017-05-23 System and method for realizing database configuration and management based on Windows self-contained Bat command

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
CN201710369781.5A CN107203615B (en) 2017-05-23 2017-05-23 System and method for realizing database configuration and management based on Windows self-contained Bat command

Publications (2)

Publication Number Publication Date
CN107203615A true CN107203615A (en) 2017-09-26
CN107203615B CN107203615B (en) 2021-01-29

Family

ID=59906419

Family Applications (1)

Application Number Title Priority Date Filing Date
CN201710369781.5A Active CN107203615B (en) 2017-05-23 2017-05-23 System and method for realizing database configuration and management based on Windows self-contained Bat command

Country Status (1)

Country Link
CN (1) CN107203615B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110321979A (en) * 2019-06-21 2019-10-11 上海翊视皓瞳信息科技有限公司 A kind of management method and system applied to wisdom factory

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030014381A1 (en) * 1998-11-11 2003-01-16 John J. Mcmillan Method and system for identifying and resolving software conflicts and computer-readable storage medium having a program for executing the method
CN101477485A (en) * 2009-01-15 2009-07-08 中山大学 MySQL database remote backup and reduction method based on ASP.net
CN101859428A (en) * 2010-04-02 2010-10-13 上海博繁企业发展有限公司 Equipment check and management system
CN106095678A (en) * 2016-06-08 2016-11-09 上海爱数信息技术股份有限公司 Automatization's result inspection method of data bank service operation under windows platform

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20030014381A1 (en) * 1998-11-11 2003-01-16 John J. Mcmillan Method and system for identifying and resolving software conflicts and computer-readable storage medium having a program for executing the method
CN101477485A (en) * 2009-01-15 2009-07-08 中山大学 MySQL database remote backup and reduction method based on ASP.net
CN101859428A (en) * 2010-04-02 2010-10-13 上海博繁企业发展有限公司 Equipment check and management system
CN106095678A (en) * 2016-06-08 2016-11-09 上海爱数信息技术股份有限公司 Automatization's result inspection method of data bank service operation under windows platform

Non-Patent Citations (3)

* Cited by examiner, † Cited by third party
Title
吴汝明 等: "《Access2010数据库系统与应用教程》", 31 March 2015 *
秦秀媛 等: "《数据库原理及应用》", 31 October 2016 *
龙帝168: "最简单的方式制作Oracle数据库备份", 《百度文库》 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN110321979A (en) * 2019-06-21 2019-10-11 上海翊视皓瞳信息科技有限公司 A kind of management method and system applied to wisdom factory

Also Published As

Publication number Publication date
CN107203615B (en) 2021-01-29

Similar Documents

Publication Publication Date Title
CN109086627B (en) Form data operation auditing method
CN104376237B (en) A kind of method of controlling security and system for being directed to information in production process
CN108764833B (en) Method for setting approval roles according to departments by workflow approval nodes
CN108984715B (en) Method for setting approval process based on basis field
CN110472388B (en) Equipment management and control system and user permission control method thereof
CN106055967A (en) SAAS platform user organization permission management method and system
CN102930226A (en) Method for controlling use permission of fine-grained client
CN106357724A (en) Uniformly integrated information management platform system
CN105184144A (en) Multi-system privilege management method
CN106570406A (en) Data level authority configuration method and apparatus
CN102467642A (en) Permission control method and device for application software
CN111259378A (en) Multi-tenant management system and implementation method thereof
CN109740333A (en) The right management method of integrated system and subsystem, server and storage medium
US20210174303A1 (en) Approval workflow entrusting and re-entrusting methods
CN113111339B (en) Access control method, device, equipment and medium for application service
CN107146154A (en) A kind of method and device of data management
CN108958870B (en) Shortcut function setting method
US20150317463A1 (en) Active directory for user authentication in a historization system
CN109033861B (en) Method for authorizing authorized operator in system
CN107203615A (en) The system and method that database configuration and management are realized in Bat orders are carried based on Windows
CN105117822B (en) Electric system basic data lean processing method
WO2017114210A1 (en) Apparatus and method for security control of data processing system
CN108809930B (en) User authority management method and device
CN113688376A (en) Tenant authority control method for realizing container cloud platform based on CMDB system and RBAC model
CN105335664A (en) Permission management system based on B/S mode

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
TA01 Transfer of patent application right
TA01 Transfer of patent application right

Effective date of registration: 20210106

Address after: Building 9, No.1, guanpu Road, Guoxiang street, Wuzhong Economic Development Zone, Wuzhong District, Suzhou City, Jiangsu Province

Applicant after: SUZHOU LANGCHAO INTELLIGENT TECHNOLOGY Co.,Ltd.

Address before: Room 1601, floor 16, 278 Xinyi Road, Zhengdong New District, Zhengzhou City, Henan Province

Applicant before: ZHENGZHOU YUNHAI INFORMATION TECHNOLOGY Co.,Ltd.

GR01 Patent grant
GR01 Patent grant