CN110427362B

CN110427362B - Method and device for acquiring database types

Info

Publication number: CN110427362B
Application number: CN201810391040.1A
Authority: CN
Inventors: 李凯; 浦世亮; 姜伟浩; 闫春
Original assignee: Hangzhou Hikvision Digital Technology Co Ltd
Current assignee: Hangzhou Hikvision Digital Technology Co Ltd
Priority date: 2018-04-27
Filing date: 2018-04-27
Publication date: 2022-03-08
Anticipated expiration: 2038-04-27
Also published as: WO2019206302A1; CN110427362A

Abstract

The application relates to a method and a device for acquiring database types, and belongs to the field of data storage. The method comprises the following steps: acquiring a database table; acquiring statistical information of data items in the database table, wherein the statistical information of the data items at least comprises the number of data records in the database table, a data set corresponding to the database table and the storage times of each data in the data set, and the data set comprises data obtained by removing the duplication of the data stored in the columns corresponding to the data items; and determining the database type of the database table according to the statistical information of the data items in the database table. The device comprises: the device comprises a first acquisition module, a second acquisition module and a determination module. The method and the device can improve the efficiency of the database types.

Description

Method and device for acquiring database types

Technical Field

The present application relates to the field of data storage, and in particular, to a method and an apparatus for obtaining a database type.

Background

The data warehouse is used for collectively storing various database tables of a company or database tables of a plurality of companies. The database tables in the data warehouse include two database types, a business table and a dictionary table. For example, a company's attendance table is a business table, and it is assumed that the attendance table includes three columns, a first column for storing the name of an employee, a second column for storing a department, and a third column for storing a time to punch a card.

In order to reduce the capacity of the attendance table, the name of each employee corresponds to a number, and each department also corresponds to a number, so that the number corresponding to the name of each employee is substantially stored in the first column, and the number corresponding to the department to which each employee belongs is stored in the second column. Meanwhile, the attendance table also corresponds to two dictionary tables, wherein one dictionary table is used for storing the name of each employee and the number corresponding to the name, and the other dictionary table is used for storing each department and the number corresponding to the department.

The database warehouse includes a plurality of database tables, and the database type of each database table needs to be acquired. Currently, each database table can be manually read from a data warehouse and then the data type of each database table can be determined empirically. This manual approach is inefficient in obtaining database types.

Disclosure of Invention

In order to improve the efficiency of the database type, the embodiment of the application provides a method and a device for acquiring the database type. The technical scheme is as follows:

in a first aspect, the present application provides a method for obtaining a database type, the method comprising:

acquiring a database table;

acquiring statistical information of data items in the database table, wherein the statistical information of the data items at least comprises the number of data records in the database table, a data set corresponding to the database table and the storage times of each data in the data set, and the data set comprises data obtained by removing the duplication of the data stored in the columns corresponding to the data items;

and determining the database type of the database table according to the statistical information of the data items in the database table.

Optionally, the determining the database type of the database table according to the statistical information of the data items in the database table includes:

when the statistical information of at least one data item in the database table meets the preset service table condition, determining the database type of the database table as a service table;

and when the statistical information of each data item in the database table meets the preset dictionary table condition, determining the database type of the database table as a dictionary table.

Optionally, when the statistical information of at least one data item in the database table meets a preset service table condition, determining that the database type of the database table is a service table includes:

selecting statistical information of one data item from the statistical information of the data items in the database table as target statistical information;

when the number of the data records is larger than a first numerical value and the number of the data items with the storage times larger than N included in the target statistical information reaches M, determining that the type of the database table is a service table, wherein M and N are integers larger than 1, and the first numerical value is N times the number of the data included in the data set in the target statistical information.

Optionally, when the statistical information of at least one data item in the database table meets a preset service table condition, determining that the database type of the database table is a service table, further includes:

and when the number of the data records is not more than a first value and/or the number of the data items with the storage times larger than N included in the target statistical information is less than M, reselecting the statistical information of one data item from the statistical information of the unselected data items in the database table as the target statistical information.

Optionally, when the statistical information of each data item in the database table meets a preset dictionary table condition, determining that the database type of the database table is a dictionary table includes:

and when the number of data in a data set included in the statistical information of each data item in the database table is equal to the number of data records and the storage times of each data in the statistical information of each data item is 1, determining that the database type of the database table is a dictionary table.

Optionally, the method further includes:

after determining a service table and a dictionary table in a data warehouse, acquiring the dictionary table corresponding to a target service table according to a data set corresponding to the target service table and a data set corresponding to each dictionary table in the data warehouse, wherein the target service table is any service table in the data warehouse.

Optionally, the obtaining the dictionary table corresponding to the target service table according to the data set corresponding to the target service table and the data set corresponding to each dictionary table in the data warehouse includes:

acquiring a target data set comprising a data set corresponding to the target service table from a data set corresponding to each dictionary table in the data warehouse;

and acquiring a dictionary table corresponding to the target data set, and determining the acquired dictionary table as the dictionary table corresponding to the target service table.

In a second aspect, the present application provides an apparatus for obtaining a database type, the apparatus comprising:

the first acquisition module is used for acquiring a database table;

a second obtaining module, configured to obtain statistical information of data items in the database table, where the statistical information of the data items at least includes the number of data records in the database table, a data set corresponding to the database table and the storage frequency of each data in the data set, and the data set includes data obtained by deduplication of data stored in a column corresponding to the data item;

and the determining module is used for determining the database type of the database table according to the statistical information of the data items in the database table.

Optionally, the determining module includes:

the first determining unit is used for determining the database type of the database table as a business table when the statistical information of at least one data item in the database table meets the preset business table condition;

and the second determining unit is used for determining the database type of the database table as a dictionary table when the statistical information of each data item in the database table meets the preset dictionary table condition.

Optionally, the first determining unit is configured to:

Optionally, the first determining unit is further configured to:

Optionally, the second determining unit is configured to:

Optionally, the apparatus further comprises:

and the third obtaining module is used for obtaining the dictionary table corresponding to the target service table according to the data set corresponding to the target service table and the data set corresponding to each dictionary table in the data warehouse after the service table and the dictionary table in the data warehouse are determined, wherein the target service table is any one service table in the data warehouse.

Optionally, the third obtaining module includes:

an obtaining unit, configured to obtain a target data set including a data set corresponding to the target service table from a data set corresponding to each dictionary table in the data warehouse;

and the determining unit is used for acquiring the dictionary table corresponding to the target data set and determining the acquired dictionary table as the dictionary table corresponding to the target service table.

In a third aspect, the present application provides a non-transitory computer readable storage medium for storing a computer program which is loaded and executed by a processor to implement the instructions of the first aspect or any of the alternative methods of the first aspect.

The technical scheme provided by the embodiment of the application can have the following beneficial effects:

the method comprises the steps of obtaining statistical information of data items in a database table, wherein the statistical information of the data items at least comprises the number of data records in the database table, a data set corresponding to the database table and the storage frequency of each data in the data set, the data set comprises data obtained by removing duplication of data stored in columns corresponding to the data items, and determining the database type of the database table according to the statistical information of the data items in the database table, so that the database type of the database table can be automatically determined, and the efficiency of obtaining the database type is improved.

It is to be understood that both the foregoing general description and the following detailed description are exemplary and explanatory only and are not restrictive of the application.

Drawings

The accompanying drawings, which are incorporated in and constitute a part of this specification, illustrate embodiments consistent with the present application and together with the description, serve to explain the principles of the application.

Fig. 1 is a flowchart of a method for obtaining a database type according to an embodiment of the present application;

FIG. 2 is a flow chart of another method for obtaining database types according to an embodiment of the present disclosure;

FIG. 3 is a schematic structural diagram of an apparatus for obtaining database types according to an embodiment of the present disclosure;

fig. 4 is a schematic structural diagram of a terminal according to an embodiment of the present application.

With the above figures, there are shown specific embodiments of the present application, which will be described in more detail below. These drawings and written description are not intended to limit the scope of the inventive concepts in any manner, but rather to illustrate the inventive concepts to those skilled in the art by reference to specific embodiments.

Detailed Description

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, like numbers in different drawings represent the same or similar elements unless otherwise indicated. The embodiments described in the following exemplary embodiments do not represent all embodiments consistent with the present application. Rather, they are merely examples of apparatus and methods consistent with certain aspects of the present application, as detailed in the appended claims.

The data warehouse is used for collectively storing various database tables of a company or database tables of a plurality of companies. The database tables in the data warehouse are divided into service tables and dictionary tables, and each service table corresponds to at least one dictionary table. The service table is used for storing service data, and for the service data repeatedly appearing in the service table, the service data can be replaced by a numerical value with the data volume smaller than that of the service data in the service table, so that the capacity of the service table can be saved, and the purpose of saving storage space is achieved.

The corresponding relation between the service data and the numerical value can be stored in the dictionary table corresponding to the service table. Therefore, when the business data is searched in the business table, the numerical value corresponding to the business data is directly searched from the business table, and then the numerical value is restored to the business data corresponding to the numerical value according to the dictionary table corresponding to the business table.

For example, the attendance table of a company is a business table, and referring to table 1 below, it is assumed that the attendance table includes three data items, namely, a name, a department and a time of punching a card, each data item corresponds to one column, the first column is used for storing the name of an employee, the second column is used for storing the department, and the third column is used for storing the time of punching the card.

TABLE 1

Name (I)	Department of department	Time of punching card
			Zhang San	Finance department	T1
Wangsan	Personnel department	T2
			Zhang San	Finance department	T3
Wangsan	Personnel department	T4
			Wangsan	Personnel department	T5
Zhang San	Finance department	T6

In the attendance table shown in table 1, the names of the employees and the departments to which the employees belong may be repeated, and in order to reduce the capacity of the attendance table and save the storage space, the "zhang san" in table 1 may be replaced with a value 1, the "wang bi" may be replaced with a value 2, the "finance department" may be replaced with a value 1, and the "personnel department" may be replaced with a value 2, and the attendance table after replacement is shown in table 2 below.

TABLE 2

Name (I)	Department of department	Time of punching card
			1	1	T1
2	2	T2
			1	1	T3
2	2	T4
			2	2	T5
1	1	T6

Meanwhile, the attendance table shown in table 2 also corresponds to two dictionary tables, namely a first dictionary table shown in table 3 below and a second dictionary table shown in table 4 below. The first dictionary table is used for storing the corresponding relation between names and numerical values, and the second dictionary table is used for storing the corresponding relation between departments and numerical values. A first dictionary table shown in table 3 below stores a correspondence relationship including "zhangsan" and a numerical value 1, and a correspondence relationship including "wangsi" and a numerical value 2; and, a correspondence relationship including "finance department" and a numerical value 1 for storage and a correspondence relationship including "personnel department" and a numerical value 2 for storage are stored in a second dictionary table shown in the following table 4.

TABLE 3

Name (I)	Numerical value
		Zhang San	1
Wangsan	2

TABLE 4

Name (I)	Numerical value
		Finance department	1
Personnel department	2

For each database table in the database, it is necessary to obtain what kind of database type the database table is, in the embodiment of the present application, the database type of the database table may be obtained through any one of the following embodiments, and the database type may be a service table or a dictionary table.

Referring to fig. 1, an embodiment of the present application provides a method for obtaining a database type, where the method includes:

step 101: a database table is obtained.

Step 102: and acquiring the statistical information of the data items in the database table.

The statistical information of the data item at least includes the number of data records in the database table, the data set corresponding to the database table and the storage frequency of each data in the data set, and the data set includes data obtained by deduplication of data stored in a column corresponding to the data item.

Step 103: and determining the database type of the database table according to the statistical information of the data items in the database table.

In the embodiment of the application, the statistical information of the data items in the database table is obtained, the statistical information of the data items at least comprises the number of data records in the database table, the data set corresponding to the database table and the storage frequency of each data in the data set, the data set comprises the data obtained by de-duplicating the data stored in the column corresponding to the data items, and the database type of the database table is determined according to the statistical information of the data items in the database table, so that the database type of the database table can be automatically determined, and the efficiency of obtaining the database type is improved.

Referring to fig. 2, an embodiment of the present application provides a method for obtaining a database type, where the method includes:

step 201: a database table located in a data warehouse is obtained.

In this step, a database table may be read from the data warehouse, i.e., each data record in the database table is read.

Optionally, when reading each data record in the database, the number of data records included in the database table may be obtained, and if the number of data records exceeds a preset number threshold P, P data records are sampled from the database table. And if the number of the data records does not exceed the preset data threshold value P, acquiring each data record in the database table. P is an integer greater than 1.

When the number of the data records exceeds a preset number threshold P, P data records are sampled from the database table, so that the number of data to be processed can be reduced and the operation amount can be reduced when the data of the column where each data item is located in the database table is processed in the subsequent steps.

Optionally, there are various ways to sample P data records from the database table. For example, the top P data records may be obtained from the database table; alternatively, P data records located at the middle position may be obtained from the database table; alternatively, the last P data records may be obtained from the database table; alternatively, P data records may be randomly selected from the database table.

The manner of acquiring P data records may be implemented in other manners besides the above-mentioned manners, and is not exhaustive.

Step 202: and acquiring the statistical information of the data items in the database table.

In this step, for any data item in the database table, a column corresponding to the data item is obtained in the database table, the number of rows included in the column is counted to obtain the number of data records included in the database table, after data stored in the column is deduplicated, data left after deduplication is formed into a data set corresponding to the database table, and the number of storage times of each data in the data set is counted in the column, so that statistical information of the data item is obtained.

Optionally, the statistical information of the data item may further include one or more of information such as an identifier of the database table, an identifier of the data item, the number of times of storage of each of the M pieces of data with the largest number of times of storage, whether the database table is sampled, the number of data records sampled in the case of sampling, the number of data missing in the corresponding column of the data item, and the like. M is a preset value and is an integer greater than 1.

For example, suppose that a database table as shown in table 2 is read, for a data item "name" of the database table, a first column where the "name" is located is obtained in the database table shown in table 2, the row number 6 included in the first column is counted, the number of data records included in the database table is obtained to be 6, after data stored in the first column is deduplicated, data 1 and 2 left after deduplication are combined into a first data set corresponding to the database table, and the storage times 3 of the data 1 and the storage times 3 of the data 2 in the first data set are counted in the first column. The resulting statistical information for the data item "name" includes the number of data records 3, the first data set including data 1 and 2, the number of times of storage 3 of data 1, and the number of times of storage 3 of data 2.

For another example, suppose that a database table as shown in table 2 is read, a second column where the "department" is located is obtained in the database table shown in table 2 for the data item "department" of the database table, the row number 6 included in the second column is counted, the number of data records included in the database table is obtained to be 6, data stored in the second column is deduplicated, data 1 and 2 left after deduplication form a second data set corresponding to the database table, and the number of storage times 3 of data 1 and the number of storage times 3 of data 2 in the second data set are counted in the second column. The statistical information of the data item "department" thus obtained includes the number of data records 6, the second data set including data 1 and 2, the number of storage times 3 of data 1, and the number of storage times 3 of data 2.

Among them, it should be noted that: if the database table is a business table, the number of data records in the database table may be much larger than the number of data in each data set corresponding to the database table, and the storage times of each data included in the statistical information of each data item are both greater than or equal to 1.

If the database table is a dictionary table, the number of data records in the database table may be equal to the number of data in each data set corresponding to the database table, and the number of storage times of each data included in the statistical information of each data item is 1.

For example, suppose that for the database table shown in table 3, the statistical information of the data item "name" in the database table is obtained, the statistical information includes the number 2 of data records, and the database table corresponds to the third data set including "zhang san" and "wang di", the number 1 of storage times of "zhang san" and the number 1 of storage times of "wang di". And acquiring statistical information of data item 'numerical value' in the database table, wherein the statistical information comprises the number of data records 2, and the database table corresponds to a fourth data set comprising data 1 and 2, the storage times 1 of the data 1 and the storage times 1 of the data 2.

For another example, assume that, for the database table shown in table 4, statistical information of the data item "department" in the database table is obtained, the statistical information includes the number of data records 2, and the database table corresponds to the fifth data set including "finance department" and "personnel department", the number of storage times 1 of "finance department" and the number of storage times 1 of "personnel department". And acquiring statistical information of data item 'numerical value' in the database table, wherein the statistical information comprises the number of data records 2, and the database table corresponds to a sixth data set comprising data 1 and 2, the storage times 1 of the data 1 and the storage times 1 of the data 2.

Step 203: and determining the database type of the database table according to the statistical information of the data items in the database table.

Optionally, when the statistical information of at least one data item in the database table meets a preset service table condition, determining the database type of the database table as a service table; and when the statistical information of each data item in the database table meets the preset dictionary table condition, determining the database type of the database table as a dictionary table.

The preset service table condition refers to statistical information corresponding to at least one data item in a database table, the number of data records in the statistical information is greater than a first numerical value, the number of data items of which the storage times included by the statistical information is greater than N reaches M, the database table is a service table, N is a preset numerical value and is an integer greater than 1, and the first numerical value is N times the number of data included by a data set in the statistical information.

The preset business table condition may further include an additional condition, for example, if all the business tables in the data warehouse are attendance tables, the additional condition may be the total number of employees included in the company, and the statistical information, in addition to satisfying the business table condition, determines that the database table is the business table only when the number of data in the data set in the statistical information is less than or equal to the total number of employees.

Optionally, the operation of determining whether the database type of the database table is a business table may include the following operations 1031 to 1033, which are respectively:

1031: and selecting the statistical information of one data item from the statistical information of the data items in the database table as target statistical information.

1032: and when the number of the data records in the target statistical information is greater than a first numerical value and the number of the data items with the storage times greater than N included in the target statistical information reaches M, determining the database type of the database table as a service table, and ending the return.

And M and N are integers larger than 1, and the first numerical value is N times of the number of data included in the data set in the target statistical information.

1033: and when the number of the data records is not more than the first value and/or the number of the data items with the storage times larger than N, which are included in the target statistical information, is less than M, reselecting the statistical information of one data item from the statistical information of the unselected data items in the database table as the target statistical information, and returning to the step of 1031 execution.

When the operation to 1033 is executed, if the statistical information of all the data items in the database table is selected, it indicates that the database table is not a business table, and the return is ended.

For example, assuming that N and M are both 2, for the statistical information of the first data item in the database table shown in table 2, the statistical information includes the number of data records 6, the first data set including data 1 and 2, the number of storage times 3 of data 1, and the number of storage times 3 of data 2. The first value is 2 times the number of data included in the first data set, namely the first value is equal to 4, and the number of data records is greater than the first value; and the data with the storage times larger than 1 includes data 1 and 2, that is, the number of the data with the storage times larger than 1 is 2, that is, the number of the data reaches M, so that the database table shown in table 2 can be determined as the service table.

The preset dictionary table condition means that when the number of data in the data set included in the statistical information of each data item in the database table is equal to the number of data records in the database table and the storage frequency of each data in the statistical information of each data item is 1, the database table is a dictionary table.

Optionally, determining the database type of the database table as a dictionary table includes:

and when the number of data in the data set included in the statistical information of each data item in the database table is equal to the number of data records and the storage times of each data in the statistical information of each data item is 1, determining that the database type of the database table is a dictionary table.

For example, for the database table shown in table 3, the statistical information of the first data item of the database table includes the number 2 of data records, the third data set including "zhang san" and "wang bi", the number 1 of storage times of "zhang san" and the number 1 of storage times of "wang bi". The number of data records 2 is equal to the number of data records 2 included in the third data set, and the storage frequency of each data record is 1. And the number of the first and second groups,

the statistical information of the second data item of the database table includes the number 2 of data records, a fourth data set including data 1 and 2, the number 1 of storage times of data 1, and the number 1 of storage times of data 2. The number of the data records 2 is equal to the number 2 of the data included in the fourth data set, and the storage frequency of each data is 1, so the database table shown in table 3 is a dictionary table.

For another example, for the database table shown in table 4, the statistical information of the first data item of the database table includes the number 2 of data records, the fifth data set including "finance department" and "personnel department", the number 1 of times of storage of "finance department" and the number 1 of times of storage of "personnel department". The number of data records 2 is equal to the number of data records 2 included in the fifth data set, and the storage frequency of each data record is 1. And the number of the first and second groups,

the statistical information of the second data item of the database table includes the number 2 of data records, including the sixth data set of data 1 and 2, the number 1 of times of storage of data 1, and the number 1 of times of storage of data 2. The number of the data records 2 is equal to the number 2 of the data included in the sixth data set, and the storage frequency of each data is 1, so that the database table shown in table 4 is a dictionary table.

When the database type of the database table is obtained, the process may return to step 201, that is, one database table is obtained from the database again and the database type of the database table is obtained until the database type of each database table in the database is obtained, that is, each service table and the dictionary table in the database are obtained.

Step 204: after the service table and the dictionary table in the data warehouse are determined, the dictionary table corresponding to the target service table is obtained according to the data set corresponding to the target service table and the data set corresponding to each dictionary table in the data warehouse, and the target service table is any service table in the data warehouse.

In this step, selecting a data set from the data sets corresponding to the target service table, and acquiring a target data set including the selected data set from the data sets corresponding to the dictionary tables in the data warehouse; and acquiring a dictionary table corresponding to the target data set, and determining the acquired dictionary table as the dictionary table corresponding to the target service table.

For example, for a first data set and a second data set corresponding to the service table shown in table 2, the first data set is selected; acquiring a fourth data set and a sixth data set comprising the first data set from a third data set and a fourth data set corresponding to a dictionary table shown in table 3 and a fifth data set and a sixth data set shown in table 4 in the data warehouse; and determining the dictionary table shown in the table 3 corresponding to the fourth data set and the dictionary table shown in the table 4 corresponding to the sixth data set as the dictionary table corresponding to the service table shown in the table 2.

Selecting a second data set, and acquiring a fourth data set and a sixth data set comprising the second data set from a third data set and a fourth data set corresponding to the dictionary table shown in table 3 and a fifth data set and a sixth data set shown in table 4 in the data warehouse; and determining the dictionary table shown in the table 3 corresponding to the fourth data set and the dictionary table shown in the table 4 corresponding to the sixth data set as the dictionary table corresponding to the service table shown in the table 2.

Step 205: and associating the target service table with a dictionary table corresponding to the target service table.

Optionally, the target service table and the dictionary table corresponding to the target service table may be displayed, so that a technician selects the dictionary table really corresponding to the target service table from the displayed dictionary table, obtains the dictionary table selected by the technician, and associates the target service table with the dictionary table selected by the technician.

Optionally, a database table with continuously increasing data records in the data warehouse may also be determined, and the process is as follows:

the method comprises the steps of acquiring the number of data records in each database table in a data warehouse in real time within a time period of preset time length, determining the database table with the number of data records increasing times exceeding a preset time threshold according to the number of data records in each database table within the time period, wherein the determined database table is the database table with the data records in the data warehouse increasing continuously.

Optionally, after determining a database table in which data records in the data warehouse are increasing, the increasing data records in the database table may also be acquired periodically or aperiodically, and the process is as follows:

for each data item in the database table, reading each data item stored in the column corresponding to the data item, if the read data items are sequentially changed data, determining the data item as a target data item, and acquiring target data corresponding to the target data item in the last record from the database table.

And then, when the added data record is read from the database table each time, finding out the target data in the column corresponding to the target data item in the database table so as to obtain the target data record where the target data is located, and reading each data record behind the target data record from the database table as the added data record.

And acquiring data corresponding to the target data item from the last read data record, and updating the target data into the acquired data.

In the embodiment of the application, whether the data table is a business table or a dictionary table is determined according to the statistical information of the data items in the database table by acquiring the statistical information of each data item in the database table, and the business table and the dictionary table in the data warehouse are determined according to the above mode, so that the efficiency of acquiring the database type of the database table is improved. Still further, the dictionary table corresponding to each service table is obtained, so that the service tables and the dictionary tables corresponding to the service tables can be automatically associated.

The following are embodiments of the apparatus of the present application that may be used to perform embodiments of the method of the present application. For details which are not disclosed in the embodiments of the apparatus of the present application, reference is made to the embodiments of the method of the present application.

Referring to fig. 3, an embodiment of the present application provides an apparatus 300 for acquiring a database type, where the apparatus 300 includes:

a first obtaining module 301, configured to obtain a database table;

a second obtaining module 302, configured to obtain statistical information of data items in the database table, where the statistical information of the data items at least includes the number of data records in the database table, a data set corresponding to the database table and the storage frequency of each data in the data set, and the data set includes data obtained by deduplication of data stored in a column corresponding to the data item;

a determining module 303, configured to determine a database type of the database table according to the statistical information of the data items in the database table.

Optionally, the determining module 303 includes:

Optionally, the first determining unit is configured to:

Optionally, the first determining unit is further configured to:

Optionally, the second determining unit is configured to:

Optionally, the apparatus further comprises:

Optionally, the third obtaining module includes:

With regard to the apparatus in the above-described embodiment, the specific manner in which each module performs the operation has been described in detail in the embodiment related to the method, and will not be elaborated here.

Fig. 4 shows a block diagram of a terminal 400 according to an exemplary embodiment of the present invention. The terminal 400 may be a portable mobile terminal such as: a smart phone, a tablet computer, an MP3 player (Moving Picture Experts Group Audio Layer III, motion video Experts compression standard Audio Layer 3), an MP4 player (Moving Picture Experts Group Audio Layer IV, motion video Experts compression standard Audio Layer 4), a notebook computer, or a desktop computer. The terminal 400 may also be referred to by other names such as user equipment, portable terminal, laptop terminal, desktop terminal, etc.

Generally, the terminal 400 includes: a processor 401 and a memory 402.

Processor 401 may include one or more processing cores, such as a 4-core processor, an 8-core processor, or the like. The processor 401 may be implemented in at least one hardware form of a DSP (Digital Signal Processing), an FPGA (Field-Programmable Gate Array), and a PLA (Programmable Logic Array). The processor 401 may also include a main processor and a coprocessor, where the main processor is a processor for Processing data in an awake state, and is also called a Central Processing Unit (CPU); a coprocessor is a low power processor for processing data in a standby state. In some embodiments, the processor 401 may be integrated with a GPU (Graphics Processing Unit), which is responsible for rendering and drawing the content required to be displayed by the display screen. In some embodiments, the processor 401 may further include an AI (Artificial Intelligence) processor for processing computing operations related to machine learning.

Memory 402 may include one or more computer-readable storage media, which may be non-transitory. Memory 402 may also include high speed random access memory, as well as non-volatile memory, such as one or more magnetic disk storage devices, flash memory storage devices. In some embodiments, a non-transitory computer readable storage medium in memory 402 is used to store at least one instruction for execution by processor 401 to implement a method of obtaining a database of the type provided by method embodiments herein.

In some embodiments, the terminal 400 may further optionally include: a peripheral interface 403 and at least one peripheral. The processor 401, memory 402 and peripheral interface 403 may be connected by bus or signal lines. Each peripheral may be connected to the peripheral interface 403 via a bus, signal line, or circuit board. Specifically, the peripheral device includes: at least one of radio frequency circuitry 404, touch screen display 405, camera 406, audio circuitry 407, positioning components 408, and power supply 409.

The peripheral interface 403 may be used to connect at least one peripheral related to I/O (Input/Output) to the processor 401 and the memory 402. In some embodiments, processor 401, memory 402, and peripheral interface 403 are integrated on the same chip or circuit board; in some other embodiments, any one or two of the processor 401, the memory 402 and the peripheral interface 403 may be implemented on a separate chip or circuit board, which is not limited by this embodiment.

The Radio Frequency circuit 404 is used for receiving and transmitting RF (Radio Frequency) signals, also called electromagnetic signals. The radio frequency circuitry 404 communicates with communication networks and other communication devices via electromagnetic signals. The rf circuit 404 converts an electrical signal into an electromagnetic signal to transmit, or converts a received electromagnetic signal into an electrical signal. Optionally, the radio frequency circuit 404 includes: an antenna system, an RF transceiver, one or more amplifiers, a tuner, an oscillator, a digital signal processor, a codec chipset, a subscriber identity module card, and so forth. The radio frequency circuitry 404 may communicate with other terminals via at least one wireless communication protocol. The wireless communication protocols include, but are not limited to: the world wide web, metropolitan area networks, intranets, generations of mobile communication networks (2G, 3G, 4G, and 5G), Wireless local area networks, and/or WiFi (Wireless Fidelity) networks. In some embodiments, the rf circuit 404 may further include NFC (Near Field Communication) related circuits, which are not limited in this application.

The display screen 405 is used to display a UI (User Interface). The UI may include graphics, text, icons, video, and any combination thereof. When the display screen 405 is a touch display screen, the display screen 405 also has the ability to capture touch signals on or over the surface of the display screen 405. The touch signal may be input to the processor 401 as a control signal for processing. At this point, the display screen 405 may also be used to provide virtual buttons and/or a virtual keyboard, also referred to as soft buttons and/or a soft keyboard. In some embodiments, the display screen 405 may be one, providing the front panel of the terminal 400; in other embodiments, the display screen 405 may be at least two, respectively disposed on different surfaces of the terminal 400 or in a folded design; in still other embodiments, the display 405 may be a flexible display disposed on a curved surface or a folded surface of the terminal 400. Even further, the display screen 405 may be arranged in a non-rectangular irregular pattern, i.e. a shaped screen. The Display screen 405 may be made of LCD (Liquid Crystal Display), OLED (Organic Light-Emitting Diode), and other materials.

The camera assembly 406 is used to capture images or video. Optionally, camera assembly 406 includes a front camera and a rear camera. Generally, a front camera is disposed at a front panel of the terminal, and a rear camera is disposed at a rear surface of the terminal. In some embodiments, the number of the rear cameras is at least two, and each rear camera is any one of a main camera, a depth-of-field camera, a wide-angle camera and a telephoto camera, so that the main camera and the depth-of-field camera are fused to realize a background blurring function, and the main camera and the wide-angle camera are fused to realize panoramic shooting and VR (Virtual Reality) shooting functions or other fusion shooting functions. In some embodiments, camera assembly 406 may also include a flash. The flash lamp can be a monochrome temperature flash lamp or a bicolor temperature flash lamp. The double-color-temperature flash lamp is a combination of a warm-light flash lamp and a cold-light flash lamp, and can be used for light compensation at different color temperatures.

The audio circuit 407 may include a microphone and a speaker. The microphone is used for collecting sound waves of a user and the environment, converting the sound waves into electric signals, and inputting the electric signals to the processor 401 for processing, or inputting the electric signals to the radio frequency circuit 404 for realizing voice communication. For the purpose of stereo sound collection or noise reduction, a plurality of microphones may be provided at different portions of the terminal 400. The microphone may also be an array microphone or an omni-directional pick-up microphone. The speaker is used to convert electrical signals from the processor 401 or the radio frequency circuit 404 into sound waves. The loudspeaker can be a traditional film loudspeaker or a piezoelectric ceramic loudspeaker. When the speaker is a piezoelectric ceramic speaker, the speaker can be used for purposes such as converting an electric signal into a sound wave audible to a human being, or converting an electric signal into a sound wave inaudible to a human being to measure a distance. In some embodiments, audio circuitry 407 may also include a headphone jack.

The positioning component 408 is used to locate the current geographic position of the terminal 400 for navigation or LBS (Location Based Service). The Positioning component 408 can be a Positioning component based on the Global Positioning System (GPS) in the united states, the beidou System in china, or the galileo System in russia.

The power supply 409 is used to supply power to the various components in the terminal 400. The power source 409 may be alternating current, direct current, disposable or rechargeable. When the power source 409 includes a rechargeable battery, the rechargeable battery may be a wired rechargeable battery or a wireless rechargeable battery. The wired rechargeable battery is a battery charged through a wired line, and the wireless rechargeable battery is a battery charged through a wireless coil. The rechargeable battery may also be used to support fast charge technology.

In some embodiments, the terminal 400 also includes one or more sensors 410. The one or more sensors 410 include, but are not limited to: acceleration sensor 411, gyro sensor 412, pressure sensor 413, fingerprint sensor 414, optical sensor 415, and proximity sensor 416.

The acceleration sensor 411 may detect the magnitude of acceleration in three coordinate axes of the coordinate system established with the terminal 400. For example, the acceleration sensor 411 may be used to detect components of the gravitational acceleration in three coordinate axes. The processor 401 may control the touch display screen 405 to display the user interface in a landscape view or a portrait view according to the gravitational acceleration signal collected by the acceleration sensor 411. The acceleration sensor 411 may also be used for acquisition of motion data of a game or a user.

The gyro sensor 412 may detect a body direction and a rotation angle of the terminal 400, and the gyro sensor 412 may cooperate with the acceleration sensor 411 to acquire a 3D motion of the terminal 400 by the user. From the data collected by the gyro sensor 412, the processor 401 may implement the following functions: motion sensing (such as changing the UI according to a user's tilting operation), image stabilization at the time of photographing, game control, and inertial navigation.

The pressure sensor 413 may be disposed on a side bezel of the terminal 400 and/or a lower layer of the touch display screen 405. When the pressure sensor 413 is disposed on the side frame of the terminal 400, a user's holding signal to the terminal 400 can be detected, and the processor 401 performs left-right hand recognition or shortcut operation according to the holding signal collected by the pressure sensor 413. When the pressure sensor 413 is disposed at the lower layer of the touch display screen 405, the processor 401 controls the operability control on the UI interface according to the pressure operation of the user on the touch display screen 405. The operability control comprises at least one of a button control, a scroll bar control, an icon control and a menu control.

The fingerprint sensor 414 is used for collecting a fingerprint of the user, and the processor 401 identifies the identity of the user according to the fingerprint collected by the fingerprint sensor 414, or the fingerprint sensor 414 identifies the identity of the user according to the collected fingerprint. Upon recognizing that the user's identity is a trusted identity, processor 401 authorizes the user to perform relevant sensitive operations including unlocking the screen, viewing encrypted information, downloading software, paying, and changing settings, etc. The fingerprint sensor 414 may be disposed on the front, back, or side of the terminal 400. When a physical key or vendor Logo is provided on the terminal 400, the fingerprint sensor 414 may be integrated with the physical key or vendor Logo.

The optical sensor 415 is used to collect the ambient light intensity. In one embodiment, the processor 401 may control the display brightness of the touch display screen 405 based on the ambient light intensity collected by the optical sensor 415. Specifically, when the ambient light intensity is high, the display brightness of the touch display screen 405 is increased; when the ambient light intensity is low, the display brightness of the touch display screen 405 is turned down. In another embodiment, the processor 401 may also dynamically adjust the shooting parameters of the camera assembly 406 according to the ambient light intensity collected by the optical sensor 415.

A proximity sensor 416, also known as a distance sensor, is typically disposed on the front panel of the terminal 400. The proximity sensor 416 is used to collect the distance between the user and the front surface of the terminal 400. In one embodiment, when the proximity sensor 416 detects that the distance between the user and the front surface of the terminal 400 gradually decreases, the processor 401 controls the touch display screen 405 to switch from the bright screen state to the dark screen state; when the proximity sensor 416 detects that the distance between the user and the front surface of the terminal 400 gradually becomes larger, the processor 401 controls the touch display screen 405 to switch from the breath screen state to the bright screen state.

Those skilled in the art will appreciate that the configuration shown in fig. 4 is not intended to be limiting of terminal 400 and may include more or fewer components than those shown, or some components may be combined, or a different arrangement of components may be used.

Other embodiments of the present application will be apparent to those skilled in the art from consideration of the specification and practice of the application disclosed herein. This application is intended to cover any variations, uses, or adaptations of the invention following, in general, the principles of the application and including such departures from the present disclosure as come within known or customary practice within the art to which the invention pertains. It is intended that the specification and examples be considered as exemplary only, with a true scope and spirit of the application being indicated by the following claims.

It will be understood that the present application is not limited to the precise arrangements described above and shown in the drawings and that various modifications and changes may be made without departing from the scope thereof. The scope of the application is limited only by the appended claims.

Claims

1. A method of obtaining database types, the method comprising:

acquiring a database table;

determining the database type of the database table according to the statistical information of the data items in the database table;

wherein, the determining the database type of the database table according to the statistical information of the data items in the database table includes:

2. The method as claimed in claim 1, wherein when the statistical information of at least one data item existing in the database table satisfies a preset service table condition, determining the database type of the database table as a service table comprises:

3. The method as claimed in claim 2, wherein when the statistical information of at least one data item existing in the database table satisfies a preset service table condition, determining the database type of the database table as a service table, further comprises:

4. The method of claim 1, wherein when the statistical information of each data item in the database table satisfies a predetermined dictionary table condition, determining the database type of the database table as a dictionary table comprises:

5. The method of any one of claims 1 to 4, further comprising:

6. The method according to claim 5, wherein the obtaining the dictionary table corresponding to the target service table according to the data set corresponding to the target service table and the data set corresponding to each dictionary table in the data warehouse comprises:

7. An apparatus for obtaining database types, the apparatus comprising:

the first acquisition module is used for acquiring a database table;

the determining module is used for determining the database type of the database table according to the statistical information of the data items in the database table;

wherein the determining module comprises:

8. The apparatus of claim 7, wherein the first determining unit is to:

9. The apparatus of claim 8, wherein the first determining unit is further configured to:

10. The apparatus of claim 7, wherein the second determining unit is to:

11. The apparatus of any one of claims 7 to 10, further comprising:

12. The apparatus of claim 11, wherein the third obtaining module comprises: