ORACLE-based umbrella data import/export method

A data import and umbrella technology, applied in the field of umbrella data import and export, can solve the problem of not being able to import external data from one point to multiple points, so as to reduce the number of parsing and execution times and improve efficiency

Active Publication Date: 2010-05-12
LINKAGE SYST INTEGRATION
View PDF1 Cites 8 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] The purpose of the present invention is: to propose a method for importing and exporting umbrella-shaped data based on a transaction-specific temporary table and a multi-dimensional memory slice. export to multiple points raised by

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
  • ORACLE-based umbrella data import/export method
  • ORACLE-based umbrella data import/export method
  • ORACLE-based umbrella data import/export method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0016] Specific implementation

[0017] Programmable umbrella import API: After the process imports external data into the transaction-specific temporary table by calling the encapsulated OCI data exchange interface, the process calls the umbrella import API. The API uses a custom ORACLE function or procedure as an actual parameter to analyze the temporary Table data, and import temporary table data into multiple entity tables in a multi-dimensional manner. The dispersion of the data and the multi-dimensional statistical granularity depend entirely on the actual parameters of the API, which can provide a lot of freedom and flexibility. Programmable Umbrella Export API: The process exports internal data to the memory array by calling the encapsulated OCI data exchange interface, and the process calls the umbrella export API. The API executes with a custom function pointer as a parameter, and the data in the memory array Distributed export to multiple data files, the degree of data...

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

An ORACLE based umbrella data import / export method is characterized in that when data are imported, a main process (program) reads the external data into a memory in batch in the form of memory arrays, an encapsulated OCI data exchange interface is called to resolve the memory arrays in batch, and the resolved memory arrays are imported into a temporary table special for transactions; after the external data are imported into the temporary table, the umbrella imported API based on the temporary table uses the user-defined ORACLE function or process as the parameter to be executed by calling the umbrella imported API, the external data are dispersed in a plurality of user-defined physical tables, and the user-defined ORACLE function or process defines the dispersion of the data in the temporary table; the internal data are exported in batch: when the data are exported, the encapsulated OCI data exchange interface is called to read the internal data into the memory in the form of memoryarrays, and the memory arrays are exported in batch; and after the internal data are exported into the memory arrays, the umbrella exported API based on the multi-dimensional memory chip uses the user-defined ORACLE function pointer as the parameter to be executed by calling the umbrella exported API, and the internal data are exported into a plurality of files in a disperse manner.

Description

Technical field [0001] The invention relates to ORACLE data import and export technology, in particular to an umbrella data import and export method in which data is imported from one point to multiple points or one point is exported to multiple points. Background technique [0002] At present, there are two main types of data import and export technologies. The first type is data backup and recovery, and the second type is importing external data to database tables or exporting internal data to data files. The present invention mainly belongs to the second category, namely external data import Export to library tables or internal data to data files. The second type of data import and export methods currently include SQL*Loader, spool, etc. Most of these tools and methods work on the cost of import and export, and the efficiency of mass execution, but currently these tools only support the point-to-point import and export of data according to the original information. Operation,...

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/30G06F9/44
CPCG06F17/30592G06F17/30286G06F16/283
Inventor 何毅陆如华邓建强王金松余志刚邵九松
Owner LINKAGE SYST INTEGRATION
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