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

Method for storing electronic table unit lattice content with relational data base

A technology of electronic form and database, applied in the direction of electronic digital data processing, special data processing applications, instruments, etc., can solve the problems of lack of support for data and data sharing and reference, failure to obtain and record information of electronic form cells, etc.

Inactive Publication Date: 2006-03-01
北京勤哲软件技术有限责任公司
View PDF0 Cites 18 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

The problem is that this corresponding method does not have the meaning of obtaining and recording the cell information of the spreadsheet, only mechanically records the location information, and lacks support for further sharing and citing of data and materials

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 storing electronic table unit lattice content with relational data base
  • Method for storing electronic table unit lattice content with relational data base
  • Method for storing electronic table unit lattice content with relational data base

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0061] (1) Single data item combination mode

[0062] Accompanying drawing 1 has exemplified the combination mode of single data item. In the figure, B2, D2, F2, B3: D3, F3, B4, D4, F4 form a data table, which is defined as follows:

[0063] Form Name: Employee Registration Form

[0064] Composite mode: single data item

[0065] field name

type of data

worksheet

address

start line

cut off line

start column

cutoff column

illustrate

Name

Word

Sheet1

B2

2

2

2

2

gender

Word

Sheet1

D2

2

2

4

4

Only "male", "female"

date of birth

date

Sheet1

F2

2

2

6

6

identity number

Word

Sheet1

B3: D3

3

3

2

4

contact number

Word

Sheet1

F3

3

3

6

6

Entry Time

date

Sheet1

B4

4

4

...

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 invented method includes the following steps: 1. combining electronic list unit lattice into the combined mode of relational data base list; 2. concrete description of combined mode; 3. storing data list definition on the electronic list; 4. providing an interface operation mode which can be visually understood for user, inputting data list definition; and 5. utilizing the inputted and stored data list definition to attain the goal of storing the contents in the electronic list unit lattice into the relational data base.

Description

1. Technical field [0001] The invention relates to a method for storing electronic table cell information with a relational database. 2. Background technology [0002] Spreadsheet definition: [0003] A spreadsheet is the general term for a class of files created by spreadsheet software, commonly known as "workbooks." A "workbook" is composed of several worksheets, and each worksheet is composed of several rows and columns. The intersection of each row and each column forms a cell, and the cell can use its row number and column number (also known as a cell) address) to identify. Cells can store information such as numbers, text, dates, images, links, and objects, as well as calculation formulas. Consecutive cells can be merged. [0004] Relational database definition: [0005] A relational database is a structured data set consisting of data tables, and various relationships can exist between data tables. A data table consists of fields. Relational databases follow re...

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/30G06F17/24
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