Data export and import method based on object definition

A data export and object data technology, applied in relational databases, database models, structured data retrieval, etc., can solve problems such as high technical requirements, difficult data import and export, unfavorable expansion and promotion and application, and achieve flexible and applicable configuration expansion Extensive, data-consistent, controllable and flexible effects

Inactive Publication Date: 2016-06-22
INSPUR COMMON SOFTWARE
View PDF6 Cites 7 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

However, the data structure design of database application software generally gives priority to software implementation. Data is often scattered and saved in multiple data tables, and the database system also saves a lot of state information that is not related to object data, which makes it difficult for data import and export. bring difficulties
At present, this kind of data import and export is generally implemented by writing specific programs for different data objects, or using the import and export functions between databases, which requires high technical requirements and is not conducive to expansion and promotion of applications.

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 export and import method based on object definition
  • Data export and import method based on object definition
  • Data export and import method based on object definition

Examples

Experimental program
Comparison scheme
Effect test

specific Embodiment

[0039] In an ERP enterprise management software, the BI model resources such as universal query, electronic map, and comprehensive exhibition board produced by the developer or implementer need to be exported from the development or implementation test database, preset or exported to the customer's formal application environment, so that Provide customers with rich BI display effects, which creates the demand for importing and exporting BI model resources.

[0040] Based on this requirement, by establishing a BI model resource template and writing a BI model import and export tool program, a data import and export method that can be flexibly expanded is implemented, which is implemented in the following steps:

[0041] Step 1: Create a BI model resource template.

[0042] First, classify BI model resources, such as universal query, electronic map, multidimensional analysis, and comprehensive display board.

[0043] Create object templates corresponding to different model reso...

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 export and import method based on object definition. The method comprises the following steps that a data object template is defined, and data export and import are achieved based on the data object template, wherein in the data object template, each data object corresponds to 1-n pieces of object data list information; data export is conducted, wherein the defined data object template is read, a database is connected, data lists for object classification in the database are read according to the object definition to be selected by a data export user, and the export data is stored in an SQLite file database; data import is conducted, wherein the SQLite database is opened, export object data lists are loaded, and data is acquired from the SQLite database according to needs of the user. Compared with the prior art, the data export and import method based on object definition has the advantages that data export and import between different databases and isomerous databases can be achieved in database software development and implementation, the development efficiency and consigned efficiency are improved, and the data export and import method is high in practicality and easy to popularize.

Description

technical field [0001] The invention relates to the field of computer application technology, in particular to a data export and import method based on object definition. Background technique [0002] In the computer field, an object is an abstraction of an objective thing. In the present invention, an object refers to an abstraction of the data in the database. It can correspond to a single data table or multiple associated data tables, and is organized into data information with a unique identifier. This unique identifier is called object number. [0003] Extensible Markup Language (ExtensibleMarkupLanguage, abbreviated as XML) is a markup language used in the computer field to mark electronic files to make them structural. It is usually used to mark data, define data types, and is a source language that allows users to define their own markup language. In the present invention, XML is used to define information such as object corresponding data table and access conditi...

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
CPCG06F16/27G06F16/25G06F16/284
Inventor 吴晓波
Owner INSPUR COMMON SOFTWARE
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