Resources Contact Us Home
Browse by: INVENTOR PATENT HOLDER PATENT NUMBER DATE
 
 
Table format data processing method and table format data processing
7996761 Table format data processing method and table format data processing
Patent Drawings:

Inventor: Yajima
Date Issued: August 9, 2011
Application: 10/588,058
Filed: February 2, 2005
Inventors: Yajima; Mantaro (Hiroshima, JP)
Assignee:
Primary Examiner: Nguyen; Chau
Assistant Examiner:
Attorney Or Agent: Wenderoth Lind & Ponack, L.L.P.
U.S. Class: 715/227; 715/212; 715/217; 715/220; 715/228
Field Of Search: 715/227; 715/228; 715/212; 715/217; 715/219; 715/220
International Class: G06F 17/00
U.S Patent Documents:
Foreign Patent Documents: 336586; 9-134349; 10-162086; 10-187679; 2001-357342; 2003-223606; 2003-323580
Other References: International Preliminary Report on Patentability dated Nov. 14, 2006 issued in corresponding International Application PCT/JP2005/007558.cited by other.
International Preliminary Report on Patentability dated Sep. 19, 2006 issued in corresponding International Application PCT/JP2005/001512. cited by other.









Abstract: A method of automatic data input/output to/from another document format or data file with a high visibility and an easy document format definition operation, even in a document format having a derivative area as a second data description area in a single cell. The method includes performing an item definition for correlating data or a data field with an item name in a document format, and specifying a difference condition as a description condition unique to the derivative area against a main area as a first description area in the same cell, for the data field having the derivative area as a second data area in a single cell. According to the specified item definition and the difference condition, data or a record as a set of data description areas to be simultaneously referenced at the document data input/output is identified for each of the derivative areas.
Claim: The invention claimed is:

1. A method of using an information processing apparatus for processing data related to a table format of a table having at least one of rows and columns separated by aruled line, the information processing apparatus including (i) a means to generate and store table format data that represents the table format, the table format data including (a) character string data specifying a code string and a position of acharacter string or a symbol on the table format, (b) line data specifying a category and a position of a line on the table format, one category of the line being the ruled line, and (c) cell data specifying a boundary position of a cell of a pluralityof cells, each of the plurality of cells being a rectangular area surrounded by ruled lines on the table format, (ii) a means to designate each set of a plurality of sets of cells, of the plurality of cells, as a respective data field and to associate acorresponding item name with each respective data field of the designated data fields, such that each of a plurality of corresponding item names is associated with a respective data field, wherein the designated data fields comprise a plurality of datafields, (iii) a means to relate a difference condition character string to a first data field of the plurality of data fields, the difference condition character string representing a difference condition that is a difference in a method of outputtingdata between two unitary areas specified in the first data field, and each of the two unitary areas being a rectangular area in which one datum is entered, (iv) a means to display the table format based on the table format data, and (v) a means to storea data file containing a plurality of file records, each of the plurality of file records being a set of a datum, wherein each respective constituent datum of each of the plurality of file records is associated with a proper item name, the methodcomprising: (1) specifying, for each respective data field of the plurality of data fields, item definition data that relates a corresponding item name, of the plurality of corresponding item names, to the respective data field, of the plurality of datafields, such that the first data field, of the plurality of data fields, is associated with a first item name of the plurality of corresponding item names, wherein each other data field, of the plurality of data fields, is disposed to the left of orabove the first data field on the table format; (2) specifying difference condition definition data for the first data field, the difference condition definition data being specified based on the difference condition character string related to thefirst data field, the difference condition definition data defining the difference condition and including information of data changing and information of the item name registered therein, such that a datum is to be changed according to the informationof data changing, and the datum to be changed is associated with the item name registered as the information of item name; (3) identifying a set of cells, of the plurality of cells, as a relational cell set based on the cell data identified in the itemdefinition data specified for each respective data field, wherein each constituent cell of the relational cell set is respectively identified in a data field, of the plurality of data fields, having a proper item name associated therewith, such that afirst constituent cell of the relational cell set is identified in the first data field, such that the first constituent cell is located on a target column and on a target row of the table format, and such that each other constituent cell of theconstituent cells of the relational cell set is located on only one of the target column and the target row; (4) identifying a first unitary area and a second unitary area in relation to the first constituent cell of the relational cell set in the firstdata field, wherein a rectangular area obtained by uniting the first unitary area and the second unitary area occupies a vertical range and a horizontal range, such that each respective constituent cell of the relational cell set other than the firstconstituent cell fully occupies only one of the vertical range and the horizontal range, and such that the first unitary area and the second unitary area are identified by a predetermined method based on cell data representing the first constituent cellof the relational cell set; (5) specifying a main record that is a combination of each respective constituent datum associated with the proper item name, each respective constituent datum of the main record being identified as a datum entered in eachrespective constituent cell of the relational cell set, and the proper item name associated with each respective constituent datum of the main record being identified as an item name associated with a data field, of the plurality of data fields,containing a corresponding constituent cell of the relational cell set; (6) specifying a sub-record by changing a constituent datum of each respective constituent datum of the main record according to the information of data changing included in thedifference condition definition data, and the changed constituent datum being associated with the item name registered as the information of the item name included in the difference condition definition data; (7) outputting a constituent datum of afirst file record fetched out from the data file into the identified first unitary area, the output constituent datum of the first file record being associated with the first item name in the first file record, wherein each constituent datum of the mainrecord and associated with an item name other than the first item name, is the same as a constituent datum (i) of the first file record and (ii) sharing a same associated item name; and (8) outputting a constituent datum of a second file record fetchedout from the data file into the identified second unitary area, the output constituent datum of the second file record being associated with the first item name in the second file record, wherein each constituent datum of the sub-record and associatedwith an item name other than the first item name, is the same as a constituent datum (i) of the second file record and (ii) sharing a same associated item name.

2. The method of claim 1, wherein the first unitary area and the second unitary area is identified by dividing the first constituent cell of the relational cell set based on specified symbols or a specified line entered at the specifiedposition in the first constituent cell.

3. The method of claim 1, wherein the sub-record is obtained by replacing a corresponding constituent datum of the main record with a datum registered as the information of data changing in the difference condition definition data, thecorresponding constituent datum of the main record being associated with an item name registered as the information of the item name in the difference condition definition data.

4. The method of claim 1, wherein a datum is output into the second unitary area, the datum output into the second unitary area representing a numerical value that is a sum of each numerical value represented by a constituent datum of each filerecord of a sub-set of file records of the plurality of file records, the datum output into the second unitary area being associated with the first item name, the first item name being designated as tabulation category, wherein each constituent datum ofthe sub-record and associated with an item name other than the first item name, is the same as a constituent datum (i) of each file record of the plurality of file records and (ii) sharing a same associated item name.

5. An information processing apparatus for processing data related to a table format of a table having at least one of rows and columns separated by a ruled line, the information processing apparatus comprising: a means to generate and storetable format data that represents the table format, the table format data including (a) character string data specifying a code string and a position of a character string or a symbol on the table format, (b) line data specifying a category and aposition of a line on the table format, one category of the line being the ruled line, and (c) cell data specifying a boundary position of a cell of a plurality of cells, each of the plurality of cells being a rectangular area surrounded by ruled lineson the table format; a means to designate each set of a plurality of sets of cells, of the plurality of cells, as a respective data field and to associate a corresponding item name with each respective data field of the designated data fields, such thateach of a plurality of corresponding item names is associated with a respective data field, wherein the designated data fields comprise a plurality of data fields; a means to relate a difference condition character string to a first data field of theplurality of data fields, the difference condition character string representing a difference condition that is a difference in a method of outputting data between two unitary areas specified in the first data field, and each of the two unitary areasbeing a rectangular area in which one datum is entered; a means to display the table format based on the table format data; a means to store a data file containing a plurality of file records, each of the plurality of file records being a set of adatum, wherein each respective constituent datum of each of the plurality of file records is associated with a proper item name; a means for specifying, for each respective data field of the plurality of data fields, item definition data that relates acorresponding item name, of the plurality of corresponding item names, to the respective data field, of the plurality of data fields, such that the first data field, of the plurality of data fields, is associated with a first item name of the pluralityof corresponding item names, wherein each other data field, of the plurality of data fields, is disposed to the left of or above the first data field on the table format; a means for specifying difference condition definition data for the first datafield, the difference condition definition data being specified based on the difference condition character string related to the first data field, the difference condition definition data defining the difference condition and including information ofdata changing and information of the item name registered therein, such that a datum is to be changed according to the information of data changing, and the datum to be changed is associated with the item name registered as the information of item name; a means for identifying a set of cells, of the plurality of cells, as a relational cell set based on the cell data identified in the item definition data specified for each respective data field, wherein each constituent cell of the relational cell setis respectively identified in a data field, of the plurality of data fields, having a proper item name associated therewith, such that a first constituent cell of the relational cell set is identified in the first data field, such that the firstconstituent cell is located on a target column and on a target row of the table format, and such that each other constituent cell of the constituent cells of the relational cell set is located on only one of the target column and the target row; a meansfor identifying a first unitary area and a second unitary area in relation to the first constituent cell of the relational cell set in the first data field, wherein a rectangular area obtained by uniting the first unitary area and the second unitary areaoccupies a vertical range and a horizontal range, such that each respective constituent cell of the relational cell set other than the first constituent cell fully occupies only one of the vertical range and the horizontal range, and such that the firstunitary area and the second unitary area are identified by a predetermined method based on cell data representing the first constituent cell of the relational cell set; a means for specifying a main record that is a combination of each respectiveconstituent datum associated with the proper item name, each respective constituent datum of the main record being identified as a datum entered in each respective constituent cell of the relational cell set, and the proper item name associated with eachrespective constituent datum of the main record being identified as an item name associated with a data field, of the plurality of data fields, containing a corresponding constituent cell of the relational cell set; a means for specifying a sub-recordby changing a constituent datum of each respective constituent datum of the main record according to the information of data changing included in the difference condition definition data, and the changed constituent datum being associated with the itemname registered as the information of the item name included in the difference condition definition data; a means for outputting a constituent datum of a first file record fetched out from the data file into the identified first unitary area, the outputconstituent datum of the first file record being associated with the first item name in the first file record, wherein each constituent datum of the main record and associated with an item name other than the first item name, is the same as a constituentdatum (i) of the first file record and (ii) sharing a same associated item name; and a means for outputting a constituent datum of a second file record fetched out from the data file into the identified second unitary area, the output constituent datumof the second file record being associated with the first item name in the second file record, wherein each constituent datum of the sub-record and associated with an item name other than the first item name, is the same as a constituent datum (i) of thesecond file record and (ii) sharing a same associated item name.

6. A non-transitory computer-readable recording medium having a computer program recorded thereon, the program being for controlling an information processing apparatus to process data related to a table format of a table having at least one ofrows and columns separated by a ruled line, the information processing apparatus including (i) a means to generate and store table format data that represents the table format, the table format data including (a) character string data specifying a codestring and a position of a character string or a symbol on the table format, (b) line data specifying a category and a position of a line on the table format, one category of the line being the ruled line, and (c) cell data specifying a boundary positionof a cell of a plurality of cells, each of the plurality of cells being a rectangular area surrounded by ruled lines on the table format, (ii) a means to designate each set of a plurality of sets of cells, of the plurality of cells, as a respective datafield and to associate a corresponding item name with each respective data field of the designated data fields, such that each of a plurality of corresponding item names is associated with a respective data field, wherein the designated data fieldscomprise a plurality of data fields, (iii) a means to relate a difference condition character string to a first data field of the plurality of data fields, the difference condition character string representing a difference condition that is a differencein a method of outputting data between two unitary areas specified in the first data field, and each of the two unitary areas being a rectangular area in which one datum is entered, (iv) a means to display the table format based on the table format data,and (v) a means to store a data file containing a plurality of file records, each of the plurality of file records being a set of a datum, wherein each respective constituent datum of each of the plurality of file records is associated with a proper itemname, the program causing the information processing apparatus to execute a method comprising: (1) specifying, for each respective data field of the plurality of data fields, item definition data that relates a corresponding item name, of the pluralityof corresponding item names, to the respective data field, of the plurality of data fields, such that the first data field, of the plurality of data fields, is associated with a first item name of the plurality of corresponding item names, wherein eachother data field, of the plurality of data fields is disposed to the left of or above the first data field on the table format; (2) specifying difference condition definition data for the first data field, the difference condition definition data beingspecified based on the difference condition character string related to the first data field, the difference condition definition data defining the difference condition and including information of data changing and information of the item nameregistered therein, such that a datum is to be changed according to the information of data changing, and the datum to be changed is associated with the item name registered as the information of item name; (3) identifying a set of cells, of theplurality of cells, as a relational cell set based on the cell data identified in the item definition data specified for each respective data field, wherein each constituent cell of the relational cell set is respectively identified in a data field, ofthe plurality of data fields, having a proper item name associated therewith, such that a first constituent cell of the relational cell set is identified in the first data field, such that the first constituent cell is located on a target column and on atarget row of the table format, and such that each other constituent cell of the constituent cells of the relational cell set is located on only one of the target column and the target row; (4) identifying a first unitary area and a second unitary areain relation to the first constituent cell of the relational cell set in the first data field, wherein a rectangular area obtained by uniting the first unitary area and the second unitary area occupies a vertical range and a horizontal range, such thateach respective constituent cell of the relational cell set other than the first constituent cell fully occupies only one of the vertical range and the horizontal range, and such that the first unitary area and the second unitary area are identified by apredetermined method based on cell data representing the first constituent cell of the relational cell set; (5) specifying a main record that is a combination of each respective constituent datum associated with the proper item name, each respectiveconstituent datum of the main record being identified as a datum entered in each respective constituent cell of the relational cell set, and the proper item name associated with each respective constituent datum of the main record being identified as anitem name associated with a data field, of the plurality of data fields, containing a corresponding constituent cell of the relational cell set; (6) specifying a sub-record by changing a constituent datum of each respective constituent datum of the mainrecord according to the information of data changing included in the difference condition definition data, and the changed constituent datum being associated with the item name registered as the information of the item name included in the differencecondition definition data; (7) outputting a constituent datum of a first file record fetched out from the data file into the identified first unitary area, the output constituent datum of the first file record being associated with the first item namein the first file record, wherein each constituent datum of the main record and associated with an item name other than the first item name, is the same as a constituent datum (i) of the first file record and (ii) sharing a same associated item name; and (8) outputting a constituent datum of a second file record fetched out from the data file into the identified second unitary area, the output constituent datum of the second file record being associated with the first item name in the second filerecord, wherein each constituent datum of the sub-record and associated with an item name other than the first item name, is the same as a constituent datum (i) of the second file record and (ii) sharing a same associated item name.
Description:
 
 
  Recently Added Patents
Dry-cooling unit with gravity-assisted coolant flow
Air filter
Coding circuitry for difference-based data transformation
Methods of enhancing diabetes resolution
Jacket liner
Flame-protected impact-modified polycarbonate compositions
Wrench
  Randomly Featured Patents
Controlling computer response message traffic
Pair of slippers
Position detecting apparatus, positioning apparatus, and information recording apparatus using the same
Pressureless steam cooker
Small footprint optoelectronic transceiver with laser
Modular instruction using cognitive constructs
Image read-out method and apparatus
Liquid crystal display having a control factor for reducing a chromaticity difference between displayed white and displayed black
Low-speed DLL employing a digital phase interpolator based upon a high-speed clock
Anthracene containing photoconductors