Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

A database file filtering method, device, storage medium and processor

A file filtering and storage medium technology, applied in the field of data processing, can solve the problems of reducing filtering accuracy, low filtering efficiency, hard disk pressure of the server, etc., and achieve the effect of improving efficiency and accuracy

Active Publication Date: 2021-05-11
BEIJING GRIDSUM TECH CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0002] During the operation and maintenance of the SQL-server server, there are often dozens or even hundreds of servers in the domain. During the data storage process of the SQL-server database, as the process continues to accumulate, the database files will continue to increase, which will undoubtedly Put enormous pressure on the hard disk of the server
[0003] At present, programs are usually used to query the database on a certain server (for example, a database larger than 200G with a certain keyword in the file name), and the number of such servers in the production environment is usually relatively large, and the data is manually queried one by one. Performing file filtering will not only reduce the efficiency of filtering, but also reduce the accuracy of filtering

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
  • A database file filtering method, device, storage medium and processor
  • A database file filtering method, device, storage medium and processor
  • A database file filtering method, device, storage medium and processor

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] Exemplary embodiments of the present disclosure will be described in more detail below with reference to the accompanying drawings. Although exemplary embodiments of the present disclosure are shown in the drawings, it should be understood that the present disclosure may be embodied in various forms and should not be limited by the embodiments set forth herein. Rather, these embodiments are provided for more thorough understanding of the present disclosure and to fully convey the scope of the present disclosure to those skilled in the art.

[0036] refer to figure 1 , is an implementation flow chart of a database file filtering method provided in the embodiment of the present application. This embodiment is suitable for operations such as deduplication and filtering of database files in various servers in a local area network. The method in this embodiment can be applied to Domain controller server or terminal in the domain.

[0037] In this embodiment, the database f...

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 discloses a database file filtering method, device, storage medium and processor. The method includes: determining the target domain to be filtered and the target server in the target domain; obtaining the database file storage directory of the target server, and obtaining The file sharing authority of the target server in the target domain; using the file sharing authority, based on the database file storage directory, constructing a query script; based on the query script, filtering the files in the database file storage directory . In the present invention, file filtering is realized based on the storage directory of database files, thereby realizing automatic file filtering for all servers in the domain, thereby improving the efficiency and accuracy of file filtering.

Description

technical field [0001] The invention relates to the technical field of data processing, in particular to a database file filtering method, device, storage medium and processor. Background technique [0002] During the operation and maintenance of the SQL-server server, there are often dozens or even hundreds of servers in the domain. During the data storage process of the SQL-server database, as the process continues to accumulate, the database files will continue to increase, which will undoubtedly It puts huge pressure on the hard disk of the server. [0003] At present, programs are usually used to query the database on a certain server (for example, a database larger than 200G with a certain keyword in the file name), and the number of such servers in the production environment is usually relatively large, and the data is manually queried one by one. Performing file filtering will not only reduce the efficiency of filtering, but also reduce the accuracy of filtering. ...

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
Patent Type & Authority Patents(China)
IPC IPC(8): G06F16/21G06F16/14G06F16/176
CPCG06F16/14G06F16/176G06F16/217
Inventor 赵春猛
Owner BEIJING GRIDSUM TECH CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com