Database table structure construction method and device, computer equipment and storage medium

A construction method and database technology, applied in the direction of database index, database management system, computing, etc., can solve the problems of incomplete database table structure, difficult management, data leakage, etc., and achieve complete construction of database table structure and intelligent construction of database table structure. , the effect of ensuring reliability and availability

CN113051272APending Publication Date: 2021-06-29深圳红途科技有限公司
5 Cites 0 Cited by

Patent Information

Authority / Receiving Office
CN · China
Current Assignee / Owner
Publication Date
2021-06-29

Smart Images

  • Figure 1
    Figure 1
  • Figure 2
    Figure 2
  • Figure 3
    Figure 3
Patent Text Reader

Abstract

The embodiment of the invention discloses a database table structure construction method and device, computer equipment and a storage medium. The method comprises the following steps:formulating a collection strategy and issuing the collection strategy to an application server, so that the application server collects user behavior data and application transmission data to obtain intermediate data, and specifically, the application server sets an actual collection strategy by adopting a switching mode according to the collection strategy; intercepting the access data by the application server by adopting a byte enhancement technology to obtain intercepted data; the application server collects user behavior data and application transmission data from the intercepted data according to an actual collection strategy to obtain intermediate data; gathering intermediate data; filtering the intermediate data based on the application database access interface to obtain target data; and analyzing and constructing a database table structure according to the target data. By implementing the method provided by the embodiment of the invention, the database table structure can be constructed more comprehensively, automatically, intelligently and completely, and the security is high.
Need to check novelty before this filing date? Find Prior Art

Description

technical field

[0001] The present invention relates to a data processing method, and more specifically refers to a database table structure construction method, device, computer equipment and storage medium. Background technique

[0002] When auditing the database and identifying sensitive data in the database, the database table structure information is needed, and the table structure information generally includes database IP (Internet Interconnection Protocol, Internet Protocol) or domain name, database name, table name, field name and other information.

[0003] There are two main ways to construct the database table structure. One is to use network traffic to analyze database-related protocols and extract SQL (Structured Query Language, Structured Query Language) statements, and then construct database tables by analyzing SQL syntax and semantics. Structural information, and the other is to use an authorized database account to connect to the database to pull table str...

Examples

Embodiment Construction

[0056] 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 some of the embodiments of the present invention, but not all of them. 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.

[0057] It should be understood that when used in this specification and the appended claims, the terms "comprising" and "comprises" indicate the presence of described features, integers, steps, operations, elements and / or components, but do not exclude one or Presence or addition of multiple other features, integers, steps, operations, elements, components and / or collections thereof.

[0058] It should also be understood that the terminology used ...