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

Enhancement-type CSV file format used for describing relational data

A file format and relational data technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as not including relational data, small data storage capacity, and inability to fully describe relational data, etc., to achieve The decoding algorithm is simple, easy to read, and avoids ambiguity

Inactive Publication Date: 2010-07-28
INSPUR COMMON SOFTWARE
View PDF0 Cites 13 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0005] CSV files are used for data storage. The capacity is smaller than XML, and the function is stronger than TXT. However, CSV files still do not have the ability to fully describe relational data. It does not contain the data field information in relational data, but only saves the name of the data field. information, so it is difficult to accurately deserialize from CSV files into a relational recordset

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
  • Enhancement-type CSV file format used for describing relational data
  • Enhancement-type CSV file format used for describing relational data
  • Enhancement-type CSV file format used for describing relational data

Examples

Experimental program
Comparison scheme
Effect test

Embodiment

[0046] In order to make the above objects, features and advantages of the present invention more comprehensible, the present invention will be further described in detail below in conjunction with the accompanying drawings and specific embodiments.

[0047] Taking an employee information table as an example, the data types of its fields are as follows

[0048] field name

type of data

length

primary key

staff code

String

50

yes

Name

String

50

gender

String

6

date of birth

DateTime

0

salary

Currency

0

[0049] The source data is relational data

[0050] staff code

Name

gender

date of birth

salary

001

Zhang Gang

male

1977-12-26

3000

002

Li Mei

Female

1978-07-07

4000

[0051] The first step to generate the file header is as follows (including version identif...

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 provides an enhancement-type CSV file format used for describing relational data, wherein, with the adoption of the CSV basic sign mode and according to the self-description capability of metadata, one relational record set is serialized completely; the file format is used for serializing one row into a character sequence excluding a carriage-return line feed sign; and the file format in the invention is used for describing the relational data by the character sequence. The invention has the characteristics that the file format facilitates the data exchange between heterogeneous information systems, has self-description of the structure, independence of a platform, compact and firm structure, simple and strict grammar and man-machine readability and supports Unicode.

Description

technical field [0001] The invention relates to a man-machine-readable and efficient character string encoding method and file format in the data exchange process of an information system, in particular to an enhanced CSV file format for describing relational data. Background technique [0002] Contemporary software development technologies are changing with each passing day, and data access technologies are numerous. Relational data exchange between different systems is a very common application. [0003] XML is a standard for information exchange, but as a general-purpose markup language, if you want to describe relational data, it needs to be deeply expanded. The structure is relatively complicated, and there are many redundant characters, which is not concise enough. For this reason, developers often use the CSV file format. [0004] The comma-separated value format (English full name is Comma Separated Values, referred to as CSV), is a plain text format used to store d...

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
IPC IPC(8): G06F17/30
Inventor 王兴山赵启杰
Owner INSPUR COMMON SOFTWARE
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