Check patentability & draft patents in minutes with Patsnap Eureka AI!

Data lead-in method and device

A data import and data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as memory occupation, memory overflow, and other program operation impacts

Active Publication Date: 2010-10-20
YONYOU NETWORK TECH
View PDF4 Cites 19 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

If the amount of data is relatively large, tens of thousands of rows of data will occupy memory for a long time, which may cause memory overflow or affect the operation of other programs

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
  • Data lead-in method and device
  • Data lead-in method and device
  • Data lead-in method and device

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0037] Embodiments of the present invention will be described in detail below with reference to the accompanying drawings.

[0038] figure 1 is a flowchart of the data import method according to the present invention. Such as figure 1 As shown, the method includes the following steps:

[0039] Step S102, defining a thesaurus of information about each database table to be imported and configuring the memory upper limit of the amount of imported data in the information system;

[0040]Step S104, analyzing the database table to be imported according to the file name and thesaurus of the file to be imported;

[0041] Step S106, according to the database table and thesaurus to be imported, automatically establish a mapping relationship between each column of the file to be imported and each column of the database table to be imported; and

[0042] Step S108, according to the configuration of the information system, import the data in the file to be imported into the information...

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 data lead-in method and a device, wherein the method comprises the steps: defining lexicons of information of each database table to be led in and configuring the upper limit of the internal memory of the leading-in datum volume in an information system; according to names and lexicons of documents to be led in, analyzing the database tables to be led in; according to the database tables and the lexicons to be led in, automatically building the mapping relationships between lists of the documents to be led in and lists of the database tables to be led in; and according to the configuration of the information system, leading the data of the documents to be led into the information system. Therefore, the invention can obviously promote the usability and accessibility of the data lead-in process, reduces the complexity of the lead-in process, saves the time of the data lead-in and enhances the lead-in robustness.

Description

technical field [0001] The present invention generally relates to the field of computer information systems, and more specifically relates to a data import method and device, which allows users to conveniently and intelligently import business data in files (Excel, Text, etc.) into information based on user habits and configurations. system. Background technique [0002] Data import is to import external data stored in the file system, such as business data in Excel or Text, into the information system. The data import function is already an essential function in the information system, and its importance and frequency of use are relatively high. [0003] Taking the import of Excel files as an example, the current general import scheme operation steps are the first step to select an Excel file and the database table to be imported, the second step to establish the corresponding relationship between the columns of the Excel file and the columns of the database table, and the...

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 YONYOU NETWORK TECH
Features
  • R&D
  • Intellectual Property
  • Life Sciences
  • Materials
  • Tech Scout
Why Patsnap Eureka
  • Unparalleled Data Quality
  • Higher Quality Content
  • 60% Fewer Hallucinations
Social media
Patsnap Eureka Blog
Learn More

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

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