WO2009153831A1 - テーブルの表示と操作のプログラム - Google Patents
テーブルの表示と操作のプログラム Download PDFInfo
- Publication number
- WO2009153831A1 WO2009153831A1 PCT/JP2008/001566 JP2008001566W WO2009153831A1 WO 2009153831 A1 WO2009153831 A1 WO 2009153831A1 JP 2008001566 W JP2008001566 W JP 2008001566W WO 2009153831 A1 WO2009153831 A1 WO 2009153831A1
- Authority
- WO
- WIPO (PCT)
- Prior art keywords
- record
- item
- displayed
- referenced
- program
- Prior art date
Links
Images
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/24—Querying
- G06F16/248—Presentation of query results
Definitions
- the present invention is a program for displaying the contents of a table in which a relation is set in a database and operating this table based on instructions from an operator or another program.
- the computer displays the contents of the database table in a table format (table format) on the screen, and edits and prints according to the instructions of the operator.
- table format table format
- FIG. 1 when the value of the item X0103 of each record of the table A0101 is limited to the reference to the record of the specific table B0102, “the relation from the item X0103 to the table B0102 is set” Say.
- the value of the item X0103 of the record recorded in the table A 0101 indicates the primary key of a record in the table B 0102. This is referred to as reference 0104.
- the reference source table, the table A0101 in FIG. 1 is called a slave table, and the reference table, the table B0102 in FIG.
- the expression is unified as a reference source table or table A and a reference destination table or table B.
- FIG. 1 As the value of the item X, a label is also displayed in addition to the primary key. For example, “3B: 3” indicates the table B0102 primary key 3 and the label “3B”. This is for ease of understanding, and the reference primary key is usually recorded. In FIG. 2 and subsequent figures of this specification, only labels are shown with emphasis on ease of understanding for humans.
- Patent Document 1 a graph is embedded in the cell of the table and displayed.
- Patent Document 2 records in a plurality of tables are alternately integrated into one table.
- Patent Document 3 when a cursor is placed on an item for which a relation has been set, the value of the reference destination record is displayed. Both are different from the present invention.
- Patent Document 4 shows a mechanism of “sorting items and highlighting a line that matches a filter condition specified for the item”.
- Patent Document 5 shows a method of expressing three-dimensional data with a plurality of two-dimensional spreadsheets.
- Japanese Patent Laid-Open No. 2004-228561 expresses the interrelationship of data chunks expressed in a spreadsheet or word processor in a graph. Both are different from the present invention.
- JP 2000-285179 A Japanese Laid-Open Patent Publication No. 10-40314 JP 2000-35998 PR US Patent 7,370,047 “System and methodfor filtering and sorting data”, Gorman May 6, 2008 US Patent 6,282,551 “System and methods for improved spreadsheet interface with user-familiar objects”, Anderson et al, August 28, 2001.
- PCT / US2000 / 006640 “METHOD AND APPARATUS FOR ORGANIZING AND PROCESSING INFORMATION USINGA DIGITAL COMPUTER”, HUGH Harlan M, March14, 2000
- the table B is displayed as a part of the display of the table A. Specifically, a list of the labels of the records in the table B that is the reference destination is displayed at the position of the column of the item X in the table A0301. This is “item X (table B)” 0303 and is located between “item X ⁇ 1” 0302 and “item X + 1” 0304.
- the display of the item X0308 of the table A0306 may be left, and the label of the record of the reference destination table B may be displayed near the item X0308. More specifically, “item X-1” 0307 and “item X” 0308 are followed by “item X (table B)” 0309, followed by “item X + 1” 0310. .
- “Item X (Table B)” 0309 may be placed before “Item X” 0310 in the table A 0306 at the bottom of FIG. 3, or the head or tail of the table A 0306 or an arbitrary position. May be put on.
- the “item X (table B)” 0303 may be placed at the head or tail of the table A0301 or at an arbitrary position.
- “Difference highlight” By listing the records of table B as one item of table A, when looking at the records of table A side by side, for “item X (table B)”, the exact record It does not necessarily indicate a value. Therefore, in order to clearly show this to the operator, “item X (table B)” in table A is displayed differently from the other items in table A.
- the background color of the row of the item X (table B) is different from the background color of the table A”
- the font of the row of the item X (table B) is different from the table A”
- the row of the item X (table B) is changed
- the difference can be emphasized by setting the display of “Table A” to be raised ”,“ Item X (Table B) ”0303, 0300309 as shown in FIG.
- the label (record) of “item X (table B)” 0303, 0309 corresponds to the label (specified in the record a), in this case “2B ”Is selected and placed in the same row (position) as the records a 0305 and 0311.
- the dotted line (the left and right dotted lines in 2B) of record a in FIG. 3 represents the selected state.
- the program adds a dummy label to “item X (table B)” 0303, 0309, so that the corresponding record of “item X (table B)” 0303, 0309 ⁇ The label “2B” can be moved to the same line as the record a.
- “Related display (2)” Record “1B” displayed in “Item X (Table B)” 0403 is specified by left click, “Select” 0404 is specified from the right click popup, and “1B” is specified. To the selected state 0405. In conjunction with this, the record in the table A 0401 with the item X 0402 value of 1B is displayed as the selection state 0406, 0407, close to the label 1B 0405 (for example, side by side as shown in FIG. 4).
- “Specifying and changing the value of item X” When a record 2a0504 is newly added to the table A0501, the value of the item X0502 is set to a predetermined default, for example, “undecided” 0505, 0506. In order to change this setting, the target of “item X (table B)” 0503, for example, “2B” is specified by left-clicking, and “setting” 0507 is selected from the right-click popup. As a result, the labels of the item X0502 and “item X (table B)” 0503 are set to “2B”.
- the target label of “item X (table B)” is designated by left clicking, and “setting” 0507 is selected from the right click popup. As a result, the value of item X and the value of “item X (table B)” 0503 in the previously selected record are changed.
- “Add to item X” To add a new record to “item X (table B)” 0503, one record of item “item X (table B)” 0503, “2B” in FIG. Click to specify, right-click to display a popup, and select "Add Above” 0508 or "Add Below” 0509. A new record is created between 2B and 1B above in the case of “added above”, and a label input is accepted between 2B and 3B below it in the case of “added below”. Enter a string or number as a label.
- a new record can be added to the “item X (table B)” 0503 and designated.
- record 2a0504 is newly added to table A0501.
- the values of the item X0502 and “item X (table B)” 0503 are default, and the record 2a is selected.
- a record may be added to “item X (table B)” in advance, and when a new record is added to table A, it may be specified as the value of item X.
- a record can be added to “item X (table B)”.
- a record can be added to “item X (table B)”.
- the information in the related table B can be grasped and managed only by the operation focusing on the table A, so that the operator can operate the data with a good view.
- Table B Relation between tables An example where only some labels are displayed Table B embedded as a column of Table A
- table B Setting the value of item X, adding and deleting records to item X
- table B Computer configuration by the program of the present invention “(2) Means for Displaying Records in Table A (Item) Referenced Table (Table B) as Table A Column,“ Item X (Table B) ””” “(3) For the selection of a record in table A, the label of the record of“ item X (table B) ”referenced by this record is highlighted, and (4) means for displaying both on the same line or near”.
- a computing device In general, a computing device, a main storage device, a secondary storage device, an input / output device, a display device, and the like are connected by a bus.
- the computer executes the program of the present invention, the computer 0601 functions as an aggregate of the following means. This is shown in FIG.
- This computer interprets information in the database 0602 and displays it on the display device 0609, interprets an instruction of the operator 0612 or an instruction from another program 0611 in the input receiving means 0610, edits the contents of the database, and edits the printer 0613. Print on. Since this computer that has read the program of the present invention displays a database table, “(1) means for displaying table (table A)” 0603 is essential.
- FIG. 7 shows the processing procedure of “(2) Means for Displaying Table A (Item) Referenced Table (Table B) Record as Column of Table A,“ Item X (Table B) ””. Show. “Accept specification of items in table A” 0701, “Create a space for one column in table A” 0702, “Set item name in this column as“ item X (table B) ”, for example,“ 0703 ” Then, “display list of record labels of reference table in this column” 0704 of the designated item.
- FIG. 9 shows the processing procedure of “means for highlighting the record in table A that refers to the selected record in (5)“ item X (table B) ””. “Accept selection of record of item X (table B)” 0901, “Identify record of table A that refers to this record” 0902, “Highlight this identified record” 0903, “Both are the same Show in line or near "0904 To do.
- FIG. 10 shows the processing procedure of “(6) Means for Setting Reference to Record of“ Item X (Table B) ”in Selected Record of Table A”. “Accept specification of record (record a) in table A” 1001, “Accept specification of record (record b) in item X (table B)” 1002, “Set reference from record a to record b” 1003.
- FIG. 11 shows a processing procedure of “(7)“ Means for adding a new record to “item X (table B)” ”0608. “Detect that item X (table B) is a processing target” 1101, “Detect new record creation instruction for table B” 1102, “Create new record in table B” 1103, Accept and set an instruction for the value of each item ”1104.
- the display of the item X (with reference to the table B set) is left and “ In the second embodiment, a column of “item X (table B)” is created and the records of the reference destination table B are arranged.
- the column of “item X (table B)” is always displayed when there is an item for which a relation is set, for example, item X, when table A is opened.
- Example 3 and Example 4 and Example 5 described later can be implemented in combination with Example 1 or Example 2 described above.
- the operator When opening the table A, the operator specifies in advance whether or not to display the column of “item X (table B)” for the item for which the relation of the table A is set, for example, the item X. With reference to this, the display / non-display of “item X (table B)” is determined in the fourth embodiment.
- table A is displayed in a normal state, and when an operator instructs display of a column of “item X (table B)” for an item for which a relation is set, for example, item X, a program corresponding to this is displayed. Displays “item X (table B)”. When the operator designates “close” for “item X (table B)”, the program closes “item X (table B)” and displays the original item X correspondingly.
- Example 5 can be implemented in combination. That is, the operator's instruction in the fifth embodiment is recorded and used in the fourth embodiment.
- All the information of the reference destination table is displayed in the table column of the table, and the reference relationship between the records of both is accurately displayed. In the middle of adding a record, it is possible to add a record to which this record refers. Also, records can be deleted by checking the reference relationship. Since these are realized, the operator can operate the data in the table with good visibility.
Landscapes
- Engineering & Computer Science (AREA)
- Theoretical Computer Science (AREA)
- Computational Linguistics (AREA)
- Data Mining & Analysis (AREA)
- Databases & Information Systems (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- User Interface Of Digital Computer (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
0309に表示された(テーブルBの)レコードとの対応を表示するため、以下の仕掛けを導入する。
0309に縦のスクロールバーが出て、「項目X(テーブルB)」0303, 0309 の対応するレコードは、レコードaと同じ行まで移動される。
0102 テーブルB(主テーブル)
0103 項目X
0104 参照
0201 テーブルA
0202 テーブルB
0203 項目X
0301 テーブルA
0302 項目X-1
0303 項目X(テーブルB)
0304 項目X+1
0306 テーブルA
0307 項目X-1
0308 項目X
0309 項目X(テーブルB)
0310 項目X+1
0401 テーブルA
0402 項目X
0403 項目X(テーブルB)
0404 選択
0405 1B(表示が「1B」のレコード)
0406 選択状態になった、1Bを参照するレコード(の左部分)
0407 選択状態になった、1Bを参照するレコード(の右部分)
0501 テーブルA
0502 項目X
0503 項目X(テーブルB)
0504 レコード2a
0505 デフォルト値:未定 (項目X)
0506 デフォルト値:未定 (「項目X(テーブルB)」)
0507 設定
0508 上に追加
0509 下に追加
0510 削除
0601 計算機
0602 データベース
0603 (1)テーブル(テーブルA)を表示する手段
0604 (2)テーブルA(の項目)の参照先のテーブル(テーブルB)のレコードを、テーブルAの列、「項目X(テーブルB)」、として表示する手段
0605 (3)テーブルAのレコードの選択に対し、このレコードが参照する「項目X(テーブルB)」のレコードのラベルを強調表示し、(4)両者を同じ行または近くに表示する手段
0606 (5)「項目X(テーブルB)」の選択されたレコードを参照するテーブルAのレコードを強調表示する手段
0607 (6)テーブルAの選択されたレコードに、「項目X(テーブルB)」のレコードへの参照を設定する手段
0608 (7)「項目X(テーブルB)」に、新規レコードを追加する手段
0609 表示装置
0610 入力受付手段
0611 他のプログラム
0612 操作者
0613 プリンタ
0701 テーブルAの項目の指定を受付する処理
0702 テーブルAに一列分の空きを作成する処理
0703 この列の項目名を、例えば「項目X(テーブルB)」と、設定する処理
0704 参照先のテーブルのレコードのラベル一覧をこの列に表示する処理
0801 テーブルAのレコードの選択を受付する処理
0802 このレコードが参照する「項目X(テーブルB)」のレコードを特定する処理
0803 特定したレコードのラベルを強調表示する処理
0804 両者を同じ行または近くに表示する処理
0901 項目X(テーブルB)のレコードの選択を受付する処理
0902 このレコードを参照するテーブルAのレコードを特定する処理
0903 特定されたレコードを強調表示する処理
0904 両者を同じ行または近くに表示する処理
1001 テーブルAのレコード(レコードa)の指定を受け付ける処理
1002 項目X(テーブルB)のレコード(レコードb)の指定を受け付ける処理
1003 レコードaからレコードbへの参照を設定する処理
1101 項目X(テーブルB)が処理対象である事を検出する処理
1102 テーブルBに対する新レコードの作成の指示を検出する処理
1103 テーブルBに新レコードを作成する処理
1104 新レコードの各項目の値の指示を受付け設定する処理
などがバスで接続されている。本発明のプログラムを計算機が実行すると、計算機0601は以下の手段の集合体として機能する。これを図6に示す。
する。
Claims (4)
- リレーショナルデータベースを操作する計算機を、
(1)表を表示する手段と
(2)該表からリレーションが設定された参照先のテーブルのレコードを、該表の列として表示する手段と
(3)該表のレコードが選択された時、該レコードが参照する該列のレコードを強調表示する手段
として機能させるためのプログラム。 - 請求項1のプログラムであって、計算機に、
(4)該表から選択されたレコードと、該レコードが参照する該列のレコードを、該表の中で同じ行または近くに表示する手段、
も加えて機能させるためのプログラム。 - 請求項1のプログラムであって、計算機に、
(5)該列から選択されたレコードを参照する該表のレコードを、強調表示する手段、
も加えて機能させるためのプログラム。 - 請求項1のプログラムであって、計算機に、
(6)該表から選択されたレコードに、該列のレコードへの参照を設定する手段、
も加えて機能させるためのプログラム。
Priority Applications (4)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
JP2010517548A JP5377481B2 (ja) | 2008-06-18 | 2008-06-18 | テーブルの表示と操作のプログラム |
US12/996,382 US8271867B2 (en) | 2008-06-18 | 2008-06-18 | Program for displaying and operating table |
CN200880129975.7A CN102067117B (zh) | 2008-06-18 | 2008-06-18 | 显示和操作表的方法 |
PCT/JP2008/001566 WO2009153831A1 (ja) | 2008-06-18 | 2008-06-18 | テーブルの表示と操作のプログラム |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
PCT/JP2008/001566 WO2009153831A1 (ja) | 2008-06-18 | 2008-06-18 | テーブルの表示と操作のプログラム |
Publications (1)
Publication Number | Publication Date |
---|---|
WO2009153831A1 true WO2009153831A1 (ja) | 2009-12-23 |
Family
ID=41433763
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
PCT/JP2008/001566 WO2009153831A1 (ja) | 2008-06-18 | 2008-06-18 | テーブルの表示と操作のプログラム |
Country Status (4)
Country | Link |
---|---|
US (1) | US8271867B2 (ja) |
JP (1) | JP5377481B2 (ja) |
CN (1) | CN102067117B (ja) |
WO (1) | WO2009153831A1 (ja) |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102411559A (zh) * | 2010-09-21 | 2012-04-11 | 金蝶软件(中国)有限公司 | 一种标识数据信息的方法及装置 |
Families Citing this family (7)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
EP2187327A1 (en) * | 2008-11-18 | 2010-05-19 | F. Hoffmann-Roche AG | Method for graphically processing displayed data records for minimizing a selection error rate |
US9069748B2 (en) | 2011-10-04 | 2015-06-30 | Microsoft Technology Licensing, Llc | Selective generation and display of data items associated with a spreadsheet |
US8990675B2 (en) * | 2011-10-04 | 2015-03-24 | Microsoft Technology Licensing, Llc | Automatic relationship detection for spreadsheet data items |
CN103699387B (zh) * | 2013-12-27 | 2018-01-23 | 金蝶软件(中国)有限公司 | 表格处理方法和系统 |
US10311141B1 (en) * | 2015-09-21 | 2019-06-04 | Workday, Inc. | Data driven spreadsheet chart system |
WO2017189933A1 (en) | 2016-04-27 | 2017-11-02 | Krypton Project, Inc. | System, method, and apparatus for operating a unified document surface workspace |
CN108319632A (zh) * | 2017-10-17 | 2018-07-24 | 杨宇平 | 一种基于关系数据库的数据组合显示方法 |
Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH0281270A (ja) * | 1988-09-19 | 1990-03-22 | Hitachi Ltd | データベース・システムのデータ表示装置 |
JPH05342071A (ja) * | 1992-06-12 | 1993-12-24 | Kobe Nippon Denki Software Kk | 動的表結合方式 |
Family Cites Families (17)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US4809158A (en) * | 1985-10-23 | 1989-02-28 | Mccauley Peter B | Sorting method and apparatus |
US5619688A (en) * | 1993-09-02 | 1997-04-08 | Microsoft Corporation | Method and system for constructing database queries using a field selection grid |
US5604854A (en) * | 1994-04-22 | 1997-02-18 | Borland International, Inc. | System and methods for reformatting multi-dimensional spreadsheet information |
US5826257A (en) * | 1996-03-20 | 1998-10-20 | Microsoft Corporation | Method and structure for maintaining and utilizing a lookup value associated with a stored database value |
US5870747A (en) * | 1996-07-09 | 1999-02-09 | Informix Software, Inc. | Generalized key indexes |
US5987472A (en) * | 1997-03-31 | 1999-11-16 | Combustion Engineering, Inc. | System and method for handling database cross references |
US6481011B1 (en) * | 1998-06-16 | 2002-11-12 | Prevue Networks, Inc. | Program guide system with user designated color coding |
US6626959B1 (en) * | 1999-06-14 | 2003-09-30 | Microsoft Corporation | Automatic formatting of pivot table reports within a spreadsheet |
US7155667B1 (en) * | 2000-06-21 | 2006-12-26 | Microsoft Corporation | User interface for integrated spreadsheets and word processing tables |
US7155665B1 (en) * | 2001-06-18 | 2006-12-26 | Microsoft Corporation | Method for creating an embedded database in a spreadsheet |
US7685515B2 (en) * | 2003-04-04 | 2010-03-23 | Netsuite, Inc. | Facilitating data manipulation in a browser-based user interface of an enterprise business application |
US7685510B2 (en) * | 2004-12-23 | 2010-03-23 | Sap Ag | System and method for grouping data |
US7526719B1 (en) * | 2005-03-21 | 2009-04-28 | Autodesk, Inc. | File format for table styles |
EP2181402A1 (fr) * | 2007-02-23 | 2010-05-05 | Enrico Maim | Procedes d'extraction, de combinaison, de synthese et de visualisation de donnees multidimensionnelles provenant de differentes sources |
US8347204B2 (en) * | 2008-05-05 | 2013-01-01 | Norm Rosner | Method and system for data analysis |
EP2283445A1 (en) * | 2008-05-19 | 2011-02-16 | F. Hoffmann-La Roche AG | Computer research tool for the organization, visualization and analysis of metabolic-related clinical data and method thereof |
US8473467B2 (en) * | 2009-01-02 | 2013-06-25 | Apple Inc. | Content profiling to dynamically configure content processing |
-
2008
- 2008-06-18 US US12/996,382 patent/US8271867B2/en active Active
- 2008-06-18 WO PCT/JP2008/001566 patent/WO2009153831A1/ja active Application Filing
- 2008-06-18 JP JP2010517548A patent/JP5377481B2/ja not_active Expired - Fee Related
- 2008-06-18 CN CN200880129975.7A patent/CN102067117B/zh not_active Expired - Fee Related
Patent Citations (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
JPH0281270A (ja) * | 1988-09-19 | 1990-03-22 | Hitachi Ltd | データベース・システムのデータ表示装置 |
JPH05342071A (ja) * | 1992-06-12 | 1993-12-24 | Kobe Nippon Denki Software Kk | 動的表結合方式 |
Cited By (1)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
CN102411559A (zh) * | 2010-09-21 | 2012-04-11 | 金蝶软件(中国)有限公司 | 一种标识数据信息的方法及装置 |
Also Published As
Publication number | Publication date |
---|---|
JPWO2009153831A1 (ja) | 2011-11-17 |
JP5377481B2 (ja) | 2013-12-25 |
CN102067117A (zh) | 2011-05-18 |
CN102067117B (zh) | 2014-08-13 |
US8271867B2 (en) | 2012-09-18 |
US20110093770A1 (en) | 2011-04-21 |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
JP5377481B2 (ja) | テーブルの表示と操作のプログラム | |
CA2795183C (en) | Temporary formatting and charting of selected data | |
US11361035B2 (en) | Batch generation of links to documents based on document name and page content matching | |
EP2951723B1 (en) | A method for managing and selectively arranging sets of multiple documents and pages within documents | |
AU2022202569B2 (en) | Method of computerized presentation of a document set view for auditing information and managing sets of multiple documents and pages | |
US11182543B2 (en) | Method of computerized presentation of a legend of object symbols on a document | |
JP6918457B2 (ja) | ファイル管理システム、及び制御方法 | |
JP6939473B2 (ja) | 文書処理装置及びプログラム | |
JP2010157136A (ja) | 文書管理装置、文書管理システム、文書管理方法、及びそのプログラム。 | |
JP2002149296A (ja) | 情報端末装置及び連続実行プログラムを記録した記録媒体 | |
JP2008140330A (ja) | 画面作成装置及び画面作成プログラム | |
JP2016103247A (ja) | 情報処理装置、情報処理方法およびプログラム | |
JP2008181212A (ja) | 情報処理装置 |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
WWE | Wipo information: entry into national phase |
Ref document number: 200880129975.7 Country of ref document: CN |
|
121 | Ep: the epo has been informed by wipo that ep was designated in this application |
Ref document number: 08776719 Country of ref document: EP Kind code of ref document: A1 |
|
WWE | Wipo information: entry into national phase |
Ref document number: 2010517548 Country of ref document: JP |
|
WWE | Wipo information: entry into national phase |
Ref document number: 12996382 Country of ref document: US |
|
NENP | Non-entry into the national phase |
Ref country code: DE |
|
122 | Ep: pct application non-entry in european phase |
Ref document number: 08776719 Country of ref document: EP Kind code of ref document: A1 |