Unlock instant, AI-driven research and patent intelligence for your innovation.

Management method based on SQL scripts for shopping mall database

A management method and database technology, applied in database management systems, digital data processing, special data processing applications, etc., can solve problems such as huge, large server resources such as cpu, and inconvenient lightweight service deployment and configuration management.

Inactive Publication Date: 2017-12-05
上海火数信息科技有限公司
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Therefore, the CPU and other server resources consumed are relatively large.
Web server-based development frameworks such as .NetFrameWork and Java are also very large, and it is not convenient for deployment and configuration management for lightweight services

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Management method based on SQL scripts for shopping mall database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0031] The following will clearly and completely describe the technical solutions in the embodiments of the present invention with reference to the accompanying drawings in the embodiments of the present invention. Obviously, the described embodiments are only some, not all, embodiments of the present invention. Based on the embodiments of the present invention, all other embodiments obtained by persons of ordinary skill in the art without making creative efforts belong to the protection scope of the present invention.

[0032] Such as figure 1 Shown, the present invention provides the management method based on SQL script storehouse database, comprises the following steps:

[0033] Step S1: configure the database based on the SQL script, specifically including the following steps:

[0034] Step S1a: Determine a database management task item set, specifically classify database management application requirements, and determine a database management task item set.

[0035] St...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a management method based on SQL scripts for a shopping mall database. The method includes the steps of on the basis of the SQL scripts, configuring the database; conducting running-phase configuration on the database under configuration and conducting pre-configuration on each parameter of monitoring systems; during the running phase, running the database under the running-phase configuration and conducting remote configuration, information checking and control management on each monitoring system through a remote configuration supervisor. According to the management method based on the SQL scripts for the shopping mall database, SQL script sets can be automatically executed, the execution result information of the SQL scripts is stored, and according to the information, an application analysis report is generated; by adopting the method, errors of the database during running and maintenance can be reduced, running and maintenance efficiency of the database can be improved, and the running and maintenance costs of the database can be decreased, so that the management method based on the SQL scripts for the shopping mall database is particularly suitable for management of shopping mall data.

Description

technical field [0001] The invention relates to the field of shopping mall databases, in particular to a management method for shopping mall databases based on SQL scripts. Background technique [0002] At present, the commonly used web servers for shopping mall databases, such as IIS and Apache, are heavyweight web servers (the heavyweight is mainly due to the large size of the software package and the high coupling degree of the software), but the speed and performance are not as good as other lightweight web servers. Using the traditional select model, the relatively stable Prefork mode is a multi-process mode, which requires frequent forking of child processes. Therefore, the CPU and other server resources consumed are relatively large. Web server-based development frameworks such as .NetFrameWork and Java are also very large, and it is not convenient for deployment and configuration management for lightweight services. In this context, a lightweight and efficient web ...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
IPC IPC(8): G06F17/30
CPCG06F16/25G06F16/21
Inventor 陈磊轩
Owner 上海火数信息科技有限公司