A method and device for acquiring database type

A database and data warehouse technology, applied in the field of obtaining database types, can solve problems such as low efficiency of database types, and achieve the effect of improving efficiency

Active Publication Date: 2022-03-08
HANGZHOU HIKVISION DIGITAL TECH
View PDF10 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This manual method is less efficient in obtaining database types

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 method and device for acquiring database type
  • A method and device for acquiring database type
  • A method and device for acquiring database type

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0054] Reference will now be made in detail to the exemplary embodiments, examples of which are illustrated in the accompanying drawings. When the following description refers to the accompanying drawings, the same numerals in different drawings refer to the same or similar elements unless otherwise indicated. The implementations described in the following exemplary embodiments do not represent all implementations consistent with this application. Rather, they are merely examples of apparatuses and methods consistent with aspects of the present application as recited in the appended claims.

[0055] The data warehouse is used to centrally store individual database tables of a company or database tables of multiple companies. The database tables in the data warehouse are divided into two types: business tables and dictionary tables, and each business table corresponds to at least one dictionary table. The business table is used to store business data. For the business data th...

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

This application relates to a method and device for acquiring database types, belonging to the field of data storage. The method includes: acquiring a database table; acquiring statistical information of data items in the database table, the statistical information of the data items at least includes the number of data records in the database table, and the data set corresponding to the database table and the storage times of each data in the data set, the data set includes the data stored in the column corresponding to the data item after deduplication; according to the statistical information of the data item in the database table, Determines the database type of the database table. The device includes: a first acquisition module, a second acquisition module and a determination module. This application can improve the efficiency of database types.

Description

technical field [0001] The present application relates to the field of data storage, in particular to a method and device for acquiring database types. Background technique [0002] The data warehouse is used to centrally store individual database tables of a company or database tables of multiple companies. The database tables in the data warehouse include two database types: business tables and dictionary tables. For example, a company's attendance sheet is a business table. Suppose the attendance sheet includes three columns. The first column is used to store the employee's name, the second column is used to store the department, and the third column is used to store the punch time. [0003] In order to reduce the capacity of the attendance sheet, each employee's name corresponds to a number, and each department also corresponds to a number, so that the number corresponding to each employee's name is actually stored in the first column, and the second column stores the n...

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/22G06F16/2458G06F16/28
CPCG06F16/22G06F16/28G06F16/2458G06F16/20
Inventor 李凯浦世亮姜伟浩闫春
Owner HANGZHOU HIKVISION DIGITAL TECH
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Try Eureka
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap