Unlock instant, AI-driven research and patent intelligence for your innovation.

Method for introducing regular file into data base

A text data and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of lack of flexibility and scalability

Active Publication Date: 2009-10-21
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF9 Cites 1 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The commonly used remote database connection or text communication interface needs to establish and maintain a fixed remote database connection, establish data exchange, or pre-define the structure of the transmission text. The disadvantage of the current technology is that the interface is solidified and lacks flexibility. , scalability

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 for introducing regular file into data base

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0010] The present invention will be described in further detail below in conjunction with the accompanying drawings.

[0011] Method provided by the present invention can import text data file into database (abbreviation JTXTPORT) in batches, its system structure as shown in Figure 1, wherein:

[0012] Step 1, setting at least one data structure description file (dispatcher.xml). Its structure is as follows:

[0013]

[0014]

[0015]

[0016] JKJM_B_TABLE

[0017] INPUT_FILE.CSV

[0018] ，

[0019]

[0020]

[0021]

[0022] Operate_date

[0023] 8

[0024] SYSDATE

[0025] 0

[0026]

[0027]

[0028] Operate_user

[0029] 10

[0030] 'SYS USER'

[0031] 0

[0032]

[0033]

[0034] ID

[0035] 10

[0036] ”

[0037] 1

[0038]

[0039]

[0040] CODE

[0041] 30

[0042] ”

[0043] 2

[0044]

[0045]

[0046] NAME

[0047] 30 ...

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 discloses a method for importing a text data file into a database, comprising the following steps: step 1, setting at least one data structure description file, aiming at the name of the data table to be imported, the name of the text data file, the name of the subsequent calling stored procedure, The data separator and the structure of the imported data are described. Step 2. Set up a database connection description file, including the description of the database connection, the storage path of the text data file and the number of data records submitted in batches; Step 3. Establish an application service platform; Step 4. Upload the data structure description file generated in step 1 and the database connection description file generated in step 2 to a specific configuration path; step 5, publish the above configuration path and description file on the application service platform. The invention can analyze text data files, and organize data into database tables, can face multi-type databases and multi-type data table structures, and has the characteristics of flexibility and expandability.

Description

technical field [0001] The invention relates to a computer data processing method, in particular to a method for importing data into a database. Background technique [0002] At present, in the total investment information system of construction projects, it is often necessary to collect various relevant data from many business ports. These data are the key to the normal functioning of the total investment information system of construction projects. The various computer systems used and the corresponding databases. [0003] The commonly used remote database connection or text communication interface needs to establish and maintain a fixed remote database connection, establish data exchange, or pre-define the structure of the transmission text. The disadvantage of the current technology is that the interface is solidified and lacks flexibility. , Scalability. Contents of the invention [0004] The technical problem to be solved by the present invention is to provide a me...

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): G06F17/30
Inventor 周吉
Owner SHANGHAI BAOSIGHT SOFTWARE CO LTD