Method and device for creating database table model

A database and model technology, applied in the computer field, can solve problems such as inconsistency of target database table types, unfavorable maintenance and expansion, and low efficiency of manual research, so as to achieve unified programs, convenient maintenance and expansion, and reduce the time for research and modeling Effect

Active Publication Date: 2015-11-18
BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD +1
View PDF3 Cites 35 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

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,...

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
  • Method and device for creating database table model
  • Method and device for creating database table model
  • Method and device for creating database table model

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0026] Exemplary embodiments of the present invention are described below in conjunction with the accompanying drawings, which include various details of the embodiments of the present invention to facilitate understanding, and they should be regarded as exemplary only. Accordingly, those of ordinary skill in the art will recognize that various changes and modifications of the embodiments described herein can be made without departing from the scope and spirit of the invention. Also, descriptions of well-known functions and constructions are omitted in the following description for clarity and conciseness.

[0027] figure 1 is a schematic diagram of main steps of a method for creating a database table model according to an embodiment of the present invention. Such as figure 1 As shown, a method for creating a database table model in the present invention mainly includes the following steps S11 to S14.

[0028] Step S11: saving the source table information required for creat...

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 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...

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
IPC IPC(8): G06F17/30
CPCG06F16/211G06F16/258
Inventor 宋增超张飞王彦明
Owner BEIJING JINGDONG SHANGKE INFORMATION TECH CO LTD
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