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

Database account cleaning method and device and electronic equipment

A cleaning method and database technology, applied in the database field, can solve problems such as inaccessibility of database nodes and unfavorable database high availability

Active Publication Date: 2021-03-02
TENCENT TECH (SHENZHEN) CO LTD
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0004] However, when the middleware is down or the service is unavailable, the business service cannot be accessed by any database node, which is not conducive to the high availability of the database

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
  • Database account cleaning method and device and electronic equipment
  • Database account cleaning method and device and electronic equipment
  • Database account cleaning method and device and electronic equipment

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] Example embodiments will now be described more fully with reference to the accompanying drawings. Example embodiments may, however, be embodied in many forms and should not be construed as limited to the examples set forth herein; rather, these embodiments are provided so that this disclosure will be thorough and complete and will fully convey the concept of example embodiments to those skilled in the art.

[0055] Furthermore, the described features, structures, or characteristics may be combined in any suitable manner in one or more embodiments. In the following description, numerous specific details are provided in order to give a thorough understanding of the embodiments of the present disclosure. However, those skilled in the art will appreciate that the technical solutions of the present disclosure may be practiced without one or more of the specific details, or other methods, components, means, steps, etc. may be employed. In other instances, well-known methods...

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 the technical field of databases, and provides a database account cleaning method and device and electronic equipment. The database account cleaning method comprises the following steps: acquiring current connection information and historical accumulated connection information of an account at a node at each time point; according to the historical cumulative connection information collected at the ith time point and the historical cumulative connection information collected at the i1th time point, whether the node is restarted between the i1th time point and the ith time point is determined, and i is an integer greater than 1; in response to the fact that the node is restarted between the i-1th time point and the ith time point, updating the final login time of thefirst account corresponding to the current connection information acquired at the ith time point to the ith time point; and cleaning the first account based on the last login time of the first account at the node. According to the technical scheme, the data security of the database can be effectively guaranteed, and the high availability of the database is improved.

Description

technical field [0001] The present disclosure relates to the technical field of databases, in particular, to a method and device for clearing database accounts, and an electronic device for implementing the above method for clearing database accounts. Background technique [0002] Database security management is an important measure to ensure data security. Among them, the management of database account rights is an important part of security management. Abnormal accounts (for example, account privileges are enlarged) are a great security risk to the database. Therefore, it is necessary to clean up abnormal accounts in the database. [0003] In the account clearing solution in the related technology, the structural diagram of the database architecture is as follows: figure 1 , the database middleware is set between the database cluster and the business service, specifically, the middleware establishes connections with node 1, node 2...node n in the database cluster respec...

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 Applications(China)
IPC IPC(8): G06F16/215G06F16/21G06F16/22
CPCG06F16/215G06F16/217G06F16/2282
Inventor 禤欢子沈登徽
Owner TENCENT TECH (SHENZHEN) 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