Method and device for creating database table model

Abstract

The invention provides a method and a device for creating a database table model. A demand analysis stage and a model design stage before a target database is created can be substantially shortened, a standard database table model can be quickly established, data loading efficiency is improved, and data warehouse construction is quickened. The method for creating the database table model comprises the following steps: storing source table information which is required for creating a target table and is obtained from a dictionary table of a source database; converting a source table field name and a source table field type to obtain a target table field name and a target table field type which can be identified by the target database; obtaining a corresponding target table name from source table identification information, and obtaining a table establishing code of the target table according to the target table name, the target name field name, the target table field type, a source table field description and a source table description; and executing the table establishing code to generate an integral target table model.

Description

technical field [0001] The invention relates to the field of computer technology, in particular to a method and device for creating a database table model. Background technique [0002] Database (Database) is a warehouse that organizes, stores and manages data according to the data structure. It was produced more than 60 years ago. With the development of information technology and the market, especially after the 1990s, data management It is no longer just storing and managing data, but has transformed into various data management methods that users need. There are many types of databases, ranging from the simplest tables storing various data to large database systems capable of storing massive amounts of data, which have been widely used in various aspects. [0003] In the e-commerce industry, the data source of the big data platform warehouse is the various business systems of the enterprise. Due to the different business scenarios within the enterprise, various database...

AI Technical Summary

Problems solved by technology

[0007] 1. There are differences between the manual offline research version and the actual model;

[0008] 2. The efficiency of manual research is low, and the design and development cycle is long;

[0009] 3. The target database table type is not uniform, which is not conducive to maintenance and expansion

Images