Looking for breakthrough ideas for innovation challenges? Try Patsnap Eureka!

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: 2007-10-24
SHANGHAI BAOSIGHT SOFTWARE CO LTD
View PDF0 Cites 19 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

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

[0012] The method provided by the present invention can import rule text data into database (abbreviation JTXTPORT) in batches, and its system structure is as shown in Figure 1, wherein:

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

[0014]

[0015]

[0016]

[0017] JKJM_B_TABLE

[0018] INPUT_FILE.CSV

[0019] ，

[0020]

[0021]

[0022]

[0023] Operate_date

[0024] 8

[0025] SYSDATE

[0026] 0

[0027]

[0028]

[0029] Operate_user

[0030] 10

[0031] 'SYS_USER'

[0032] 0

[0033]

[0034]

[0035] ID

[0036] 10

[0037] ’’

[0038] 1

[0039]

[0040]

[0041] CODE

[0042] 30

[0043] ’’

[0044] 2

[0045]

[0046]

[0047...

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 leading regular text data into a database, comprising that 1, setting at least one data structure description, which is described based on object data list name, text document name, following distribution memory process name, data separator, and the structure leading data, 2, setting a database connecting description comprising the descriptions of database connection, text data document storage path and batch provided data record number, 3, building an application service platform, 4, transmitting the data structure description document generated in the first step and the database connecting description document generated in the second step to a special distribution path, 5, publishing the distribution path and the description document on the application service platform. The invention can analyze text and organize data to be leaded into database list, which can be applied for kinds of databases and data list structures, with strong flexibility and expansion.

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 Applications(China)
IPC IPC(8): G06F17/30
Inventor 周吉
Owner SHANGHAI BAOSIGHT SOFTWARE CO LTD
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products

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

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com