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

Method for processing data

A data processing and data technology, applied in the field of data processing, can solve the problems of difficult to write statements, waste of resources, low efficiency, etc., and achieve the effects of efficient data calculation, expanded degrees of freedom, and flexible data structures

Inactive Publication Date: 2010-07-28
北京润乾信息系统技术有限公司
View PDF0 Cites 3 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

This leads to the fact that in some complex multi-table association queries, all association, grouping, and filtering must be considered at one time, which makes it difficult to write this statement. In practical applications, it may even run into several pages. A long SELECT statement is difficult for non-professionals to deal with, and SQL must manually create temporary tables to save intermediate data for calculations that are difficult or impossible to complete in one statement. Not only is the operation complicated, but this All these tables are generated by copying data in batches, which is inefficient and wastes resources

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 processing data
  • Method for processing data
  • Method for processing data

Examples

Experimental program
Comparison scheme
Effect test

example 1

[0037] Example 1. Table 1 in the existing relational database db has the following structure and content:

[0038] Name

language

math

English

Zhang San

82

85

91

Li Si

71

61

78

Wang Wu

50

60

55

Zhao Liu

68

70

72

Sun Qi

73

90

75

[0039] Execute the following statement to import it and generate an arrangement:

[0040] P1=db.query("SELECT * FROME table 1")

[0041] A permutation P1 containing 5 records will then be generated for which:

[0042] P1(1)=={Name=Zhang San, Chinese=82, Mathematics=85, English=91}

[0043] P1(2)=={Name=Li Si, Chinese=71, Mathematics=61, English=78}

[0044] ...

[0045] In this method, in addition to importing tables from relational databases, new arrangements can also be created from existing data.

[0046] A.new(x i :F i ,...) means to create a new arrangement, A is a sequence or arrangement, F i the fields...

example 2

[0048] Example 2. A = ["a", "b", "c"]

[0049] P2=A.new(#: serial number, ~: value)

[0050] The above creates a new permutation P2. It can be represented in a table as follows:

[0051] serial number

value

1

″a ″

2

″b″

3

″c″

[0052] Obviously, the arrangement contains 3 records, and the records inside can be called with P2(i), for example:

[0053] P2(1).value == "a"

[0054] P2(2).value == "b"

example 3

[0055] Example 3. Existing permutation P1:

[0056] serial number

name

area code

1

"Beijing"

010

2

"Shanghai"

021

[0057] and permutation P2:

[0058] name

area

"Zhang San"

"Beijing"

[0059] name

area

"Li Si"

"Shanghai"

[0060] Then use the code:

[0061] P2(1).region = P1(1)

[0062] P2(2).region = P1(2)

[0063] The above assigns the two records of P1 to the fields of the two records in P2 respectively. Due to the freedom of field data types allowed in this method, the "Region" field of P2 can directly refer to the record of P1. After this definition, use it directly:

[0064] P2(1).Region.Area code

[0065] You can return to 021.

[0066] Compared with the traditional method, the reference mechanism in this method brings great convenience for establishing the association between data. Moreover, all reference operations to records in this metho...

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 processing data, belonging to the technical field of computer information processing. The query and access language SQL (structured query language) technology based on a relational database is most frequently used in the prior art but characterized in that the data structure thereof is restricted by the format of sheets and is non-procedural, so the query and access language SQL technology is very complicated while solving complex logical relations in application. The method of the invention is characterized in that the method provides the data management based on a 'record' as the basic unit, provides a 'sequence' having a free structure to assist in the operation, provides pointer-based operation to replace most of data-based operation and provides the basic support for set operation, thereby greatly improving the efficiency and flexibility of data management and calculation; the method of the invention allows a user to operate on a high-level data structure and operation interface without accessing the detailed low-level data storage; and the operation interface has a flexible data structure and a powerful and free calculation system, thus providing more convenient and efficient data management for the user.

Description

technical field [0001] The invention belongs to the technical field of computer information processing, and in particular relates to a data processing method. Background technique [0002] In the current business applications, the organization and management methods for a large amount of data information in relational databases are mainly based on the query and access language SQL technology. The calculation of many complex relationships will be very cumbersome and inefficient. [0003] SQL deliberately weakens the order of records and emphasizes the disorder and equality of data. This is a feature of SQL, but it also brings some inevitable defects. Due to the unordered nature of the data, in some calculations involving the order of records, such as the comparison between this record and the previous record (same period ratio), the table must be sorted manually every time, and the steps are redundant. , The operation is cumbersome and inefficient. [0004] SQL has no conv...

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 北京润乾信息系统技术有限公司
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