[go: up one dir, main page]

WO1999009492A1 - Technique informatisee de compilation de rapport - Google Patents

Technique informatisee de compilation de rapport Download PDF

Info

Publication number
WO1999009492A1
WO1999009492A1 PCT/AU1998/000649 AU9800649W WO9909492A1 WO 1999009492 A1 WO1999009492 A1 WO 1999009492A1 AU 9800649 W AU9800649 W AU 9800649W WO 9909492 A1 WO9909492 A1 WO 9909492A1
Authority
WO
WIPO (PCT)
Prior art keywords
template information
report
template
information
database
Prior art date
Application number
PCT/AU1998/000649
Other languages
English (en)
Inventor
Brian Keith Oliver
Original Assignee
Cleverworx Inc.
Priority date (The priority date is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the date listed.)
Filing date
Publication date
Application filed by Cleverworx Inc. filed Critical Cleverworx Inc.
Priority to EP98938528A priority Critical patent/EP1005678A1/fr
Priority to JP2000510086A priority patent/JP2001516084A/ja
Priority to AU87210/98A priority patent/AU8721098A/en
Publication of WO1999009492A1 publication Critical patent/WO1999009492A1/fr

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING OR CALCULATING; 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/28—Databases characterised by their database models, e.g. relational or object models
    • G06F16/284—Relational databases

Definitions

  • This invention relates to a computerised method of compiling a report from user defined template information.
  • This invention has particular application to such method whereby on-screen editing can occur during generation of the report created by the selection of stored template information.
  • the editable report is assembled onscreen in one segment of a split window while the selected, editable and selectable template information for the report appears in another segment of a split window.
  • the report and the selected and selectable template information appear simultaneously at opposite sides of the screen.
  • This invention aims to alleviate at least one of the above disadvantages, and in one aspect, aims to provide means for making report generation tasks more efficient.
  • a computer includes a machine of the general type as outlined in Fig. 6.
  • a computer optionally includes one or more selection devices being keyboard input or pointing devices, a plurality of display devices, mass storage means, printing means, network communication means, an input/output controller, main memory and a plurality of central processors and possibly associated cache memory, connected by a communication mechanism or bus of some description.
  • this invention in one aspect resides broadly in a method enabling the compilation of an report from stored template information, the method including: establishing a template database for storing user defined template information; providing presentation means for displaying stored template information whereby all or a portion of the template information may be selected for inclusion in a compiled repor ; establishing a report database to store reports generated by the assembly of all or portions of selected template information whereby each report may include a user defined set or sub-set of template information from the template database, and enabling the display of template information as well as one or more reports assembled from selected template information.
  • the template information may be pre-defined information but preferably the template information is user defined information and more preferably editable user defined information. It is also preferred that the display is enabled whereby simultaneous display of template information as well as one or more reports assembled from selected template information is provided and most preferably on a single screen and suitably having the template information displayed in one side of a split-window and the compiled report of the corresponding selected template information in the other side of a split-window. In addition it is preferred that the display of template information is searchable view of template information.
  • the method includes :- providing editing means for editing the template information and/or assembled reports; establishing an association between the template and report databases whereby: changes made to template information automatically update the corresponding unedited template information in assembled reports stored in the report database, and/or changes made to report information in the report database do not affect the corresponding template information in the template database.
  • a user selects a template information element for inclusion in a report, a corresponding element appears as a report information element in the report. Provided this corresponding report information remains unedited in the report, subsequent editing of the template information element will be reflected in the unedited corresponding report information element. Conversely subsequent editing of the report information element does not change the template information element.
  • a preferred method of associating template information contained within a report and stored in the report database, with the corresponding template information stored in the template database is to:- provide the template information as a structured set of information; uniquely identifying each element of the template information set stored in the template database, and storing only the corresponding template information identification in each compiled report stored in the report database.
  • One preferred method of associating template and report information is to use conventional database "foreign" keys as outlined in Fig. 8. By using this method of association, changes made to the report database do not effect the template information, as only foreign key references are stored in the report database and not actual template information.
  • any changes made to the template information may automatically be reflected in the report database as the report database foreign keys refer to the template information.
  • the method may also include: - establishing abbreviation means for abbreviating user defined template information, and providing display customisation means whereby a user may choose to display either the template information or the abbreviated template information to minimise the amount of on-screen template information displayed. This enables more selectable template information elements from the template database to be simultaneously displayed for incorporation in full in the compiled report or reports.
  • the method further includes : providing associating means for associating user defined operational attributes with template information such that weightings may be attached as user-defined attributes to each template information, to allow the automatic generation of assessments score or grade or the like, along with the detailed report.
  • An efficient means for associating operational attributes to template information is to use conventional database technology to add an additional field or column of information to the template information database to store the appropriate operational attribute, as is the case with the weightings attribute in Fig 2, or by adding a BLOB (binary large object field) to store multiple operational attributes.
  • BLOB binary large object field
  • the method includes constraining means for constraining the use of template information in a report based on previously selected information elements for the report.
  • the template information to be constrained is user defined.
  • Fig. 11 illustrates the result of constraining the available template information caused by the selection. This application of the constraints corresponds to the data in the "Constraint List" column of the Response Template Information Element Table of Fig. 2.
  • Constraints are beneficial, for example, when conducting surveys containing gender specific template information. Only the template information relevant to the gender selected will be displayed for inclusion in a compiled report .
  • the above method includes a provision that allows an end-user to define and store the order in which template information will be presented for possible selection.
  • This template information is illustrated by the "Scroll to ID" column in the Response Template Information Element table in Fig . 2.
  • an end-user may simply indicate the next appropriate template information element displayed upon selection of some other previous template information. This allows for the "automatic scrolling" of template information to improve the efficiency of using the template information to compile editable reports. It also means an end-user does not have to use the standard scrolling mechanism to advance to the next selectable template information element.
  • the above method of compiling reports also provides a means of exporting and communicating reports in user specified formats.
  • the template information could be a variety of media formats, including but not limited to text, print graphical, sound, animation or video. This may simply be achieved by sending the contents of the report split window or report database to one or more devices capable of producing the end- user required format .
  • a user may compile one or more reports each of which comprises a compilation of template information.
  • Each compiled report may be displayed, played and/or edited as required. Any portion of template information in each of the reports may be changed automatically by making the desired change to the corresponding template information.
  • An assessor using the above method may add, modify or remove particular template information in the template information database and have, if desired, all corresponding template information in previously compiled reports automatically updated without the need to individually select previously compiled reports to be updated. These additions, modifications or deletions to template information may take place before, during and after compilation of the reports.
  • template and report databases may be realised as conventional databases or flat file structures or the like, this may not necessarily be the most efficient method of implementation.
  • template and/or report databases is realised as databases, hereinafter referred to ALPHA databases and being of the type described in our co-pending Australian patent application No. PCT ⁇ AU 98 ⁇ 00162.
  • this invention resides broadly in a method enabling the compilation of a report from stored template information, the method including: establishing a template database for storing user defined template information; providing presentation means for displaying stored template information at one side of a split window whereby all or a portion of the template information may be selected for inclusion in a compiled report, and providing managing means for simultaneously and selectively displaying all or portions of the stored template information at one side of a split window and the report or reports being assembled by selection of template information in the other side of said split window.
  • the method includes: - establishing a report database to store reports generated by the assembly of all or portions of selected template information whereby each report may include a user defined set or sub-set of template information from the template database; providing editing means for editing the template information and/or assembled reports; establishing an association between the template and report databases whereby: changes made to template information automatically update the corresponding unedited template information in assembled reports stored in the report database, and/or changes made to report information in the report database do not affect the corresponding template information in the template database.
  • this invention resides broadly in a method enabling the compilation of an editable report from stored editable template information, the method including: establishing a template database for storing user defined template information; providing selection means for displaying a searchable view of stored template information whereby all or a portion of the selected template information may be selected for inclusion in a compiled report, and establishing a report by the compilation of all or a portion of selected template information.
  • FIG. 1 is an overview of a typical embodiment of this invention
  • FIG. 1A illustrates a further split screen illustrating the expanded display of a report from abbreviated template information
  • FIG. 2 is an example of a template information database
  • FIG. 3 is an illustration of a template information and compiled report split window
  • FIG. 4 is an algorithm to display the template information database in a split window
  • FIG. 5 illustrates a computer
  • FIG. 6 specifies the characteristics of a computer
  • FIG. 7 is an algorithm to display a compiled report constructed by selected template information
  • FIG. 8 is an example of a report database
  • FIG. 9 is an example template information "on selection" algorithm
  • FIG. 10 is an example algorithm to "constrain" template information on selection
  • FIG. 11 illustrates the result of constraining template information
  • FIG. 12 is an example template information "on un- selection" algorithm
  • FIG. 13 is an example algorithm to "de-constrain" template information after un-selection
  • FIG. 14 is an example algorithm to calculate a report score
  • FIG. 15 illustrates an interface to modify template information properties ( a ) ;
  • FIG. 16 illustrates an interface to modify template information properties (b);
  • FIG. 17 illustrates an interface to modify template information properties (c).
  • FIG. 18 illustrates an application user interface as an embodiment this invention.
  • template information #1.1, Fig. 2 and Fig. 3 is stored in a template information database #1.2 and Fig. 2 and is retrieved and displayed according to the algorithm in Fig. 4 in a template window #1.3 and Fig. 3 for selection #3.1 by an end-user using a computer and selection device Figs. 5 and 6 to be included in a compiled report #3.2, Fig. 1A displayed according to the algorithm in Fig. 7 in a report window #1.4 and Fig. 3 and stored in a report database #1.5 and Fig. 8 as report records #1.6 and Figs. 8.
  • the selection algorithm in Fig. 9 is performed along with the constraining algorithm in Fig. 10, Fig. 11 detailing the result of the constraint algorithm.
  • the autoscroll algorithm is also performed when a user selects a template information element. This algorithm uses the value in the "Scroll to ID" column of the Response Template Information Element Table in Fig. 2 to determine the next template information element to display and then uses this new template information element as the "first" value when applying the algorithm in Fig. 4.
  • a template information score #15.1 may be entered using the windows detailed in Figs. 15, 16 and 17 and stored as in Fig. 2.
  • Abbreviated Template Information, Default Template Information Selection, Detailed Template Information and Template Information Constraints may be maintained by the end-user as in #15.2, #15.3, #16.1 and Fig. 17 respectively and stored in the template information database as in Fig 2.
  • Fig. 17.1 details the currently constrained Template Information and Fig. 17.2 details the template information that may be constrained.
  • Fig. 18 outlines an application using a typical embodiment of this invention, detailing a structure of related template information elements #18.1, the tools to create new template information #18.2 and an assessment window #18.3, containing the selectable template information window and the compile report window.
  • Example Scenario Assume an assessor is required to assess, score, grade and give feedback for a number of student assessments. During the assessment process, the assessor often recognises that many students make either similar mistakes or require similar feedback comments on their assignments. Rather than having to write the same or similar comments multiple times, the assessor may:
  • a report is built up in the report split window 1.2 which may be later printed, faxed or emailed to the student as feedback on their assignment.
  • This invention provides particular benefit in simplifying the process of creating reports where the content of the reports can be specified as template information as the content of the report is simply selected from template information, rather than being newly created for each report.
  • This invention makes template information visible and directly accessible to the user so that selection of the appropriate template information for each report is an efficient process.
  • This invention provides a mechanism for standardization of the content of reports that are created by many different individuals. For example, where a large number of student assignments have to be marked, and these assignments are distributed among several teachers, this invention provides standardization of the criteria used to assess the students by making the same template information available to all assessors. This invention can be used to make specialist expert knowledge available to people who would not ordinarily possess this knowledge. For example, a professor may make detailed assessment criteria available as template information, and this template information may then be used by less knowledgeable staff in the assessment of student assignments .
  • a system implementing this invention allows the user of the system to see the report being constructed and to edit this report, as the user is working. In many other systems display and editing of compiled reports does not occur simultaneously with the construction of the report.
  • this invention allows additions, modifications and deletions to template information to be automatically applied to report information, this invention allows the template information to be improved over time without the need to regenerate existing reports. As a result this invention is particularly useful in industries where the content and structure of information to be collected, stored, compiled, processed and reported upon is not completely known or fixed when established.

Landscapes

  • Engineering & Computer Science (AREA)
  • Databases & Information Systems (AREA)
  • Theoretical Computer Science (AREA)
  • Data Mining & Analysis (AREA)
  • Physics & Mathematics (AREA)
  • General Engineering & Computer Science (AREA)
  • General Physics & Mathematics (AREA)
  • Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
  • Management, Administration, Business Operations System, And Electronic Commerce (AREA)

Abstract

Cette technique permettant de compiler un rapport à partir d'informations mémorisées de modèle consiste à constituer une base de données de modèles permettant le stockage des informations de modèle définies par l'utilisateur, à mettre en place un moyen de présentation permettant d'afficher ces informations dont la totalité ou une partie peut être retenue aux fins d'une insertion dans un rapport compilé, à constituer une base de données de rapports permettant le stockage de rapports produits par l'assemblage de la totalité ou des parties des informations de modèle sélectionnée, chaque rapport pouvant comporter un ensemble ou un sous-ensemble, défini par l'utilisateur, des informations de modèle provenant de la base de données de modèles et à procéder à l'affichage des informations de modèle ainsi qu'à celui d'un ou de plusieurs rapports issus de l'assemblage des informations de modèles sélectionnées.
PCT/AU1998/000649 1997-08-15 1998-08-14 Technique informatisee de compilation de rapport WO1999009492A1 (fr)

Priority Applications (3)

Application Number Priority Date Filing Date Title
EP98938528A EP1005678A1 (fr) 1997-08-15 1998-08-14 Technique informatisee de compilation de rapport
JP2000510086A JP2001516084A (ja) 1997-08-15 1998-08-14 コンピューターによるレポート作成方法
AU87210/98A AU8721098A (en) 1997-08-15 1998-08-14 A computerised method of compiling reports

Applications Claiming Priority (2)

Application Number Priority Date Filing Date Title
AUPO8636A AUPO863697A0 (en) 1997-08-15 1997-08-15 A computerised method of compiling reports
AUPO8636 1997-08-15

Publications (1)

Publication Number Publication Date
WO1999009492A1 true WO1999009492A1 (fr) 1999-02-25

Family

ID=3802923

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/AU1998/000649 WO1999009492A1 (fr) 1997-08-15 1998-08-14 Technique informatisee de compilation de rapport

Country Status (5)

Country Link
EP (1) EP1005678A1 (fr)
JP (1) JP2001516084A (fr)
CN (1) CN1270680A (fr)
AU (1) AUPO863697A0 (fr)
WO (1) WO1999009492A1 (fr)

Cited By (9)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6555354B2 (en) 1995-06-08 2003-04-29 Immunex Corporation TNF-α converting enzyme
US7315849B2 (en) 2000-02-28 2008-01-01 Hyperroll Israel, Ltd. Enterprise-wide data-warehouse with integrated data aggregation engine
US7392248B2 (en) 1999-08-04 2008-06-24 Hyperroll Israel, Ltd. Data aggregation server supporting rapid query response with sparse multi-dimensional data
US7640335B1 (en) * 2002-01-11 2009-12-29 Mcafee, Inc. User-configurable network analysis digest system and method
US8024650B2 (en) * 2006-03-31 2011-09-20 Microsoft Corporation Drilling on elements in arbitrary ad-hoc reports
CN102799599A (zh) * 2011-05-27 2012-11-28 富士通株式会社 用户生成媒体信息的处理方法及装置
CN103593456A (zh) * 2013-11-22 2014-02-19 中国技术交易所有限公司 表单自定义设计方法及装置
WO2020204374A3 (fr) * 2019-04-05 2020-12-03 오스템임플란트 주식회사 Procédé et dispositif pour fournir un rapport de chirurgie basé sur un modèle spécifique à l'utilisateur
US20240176948A1 (en) * 2013-03-15 2024-05-30 PowerNotes LLC Method & system for labeling and organizing data for summarizing and referencing content via a communication network

Families Citing this family (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20130191729A1 (en) * 2010-03-26 2013-07-25 Emd Millipore Corporation Method of Generating an Electronic Report
CN102063465A (zh) * 2010-11-18 2011-05-18 北京握奇数据系统有限公司 卡片个人化模板的定制方法和装置
RU2536390C2 (ru) * 2012-10-31 2014-12-20 Общество с ограниченной ответственностью "1С" Способ для автоматизированного создания отчетов
WO2017098793A1 (fr) * 2015-12-08 2017-06-15 株式会社島津製作所 Système de traitement de données pour analyseur, et programme de traitement de données pour analyseur
CN106897525A (zh) * 2017-02-28 2017-06-27 广州慧更思通信科技有限公司 一种能源互联网通信规划设计的智能化系统平台及方法
CN110008457A (zh) * 2019-04-08 2019-07-12 中钢集团马鞍山矿山研究院有限公司 一种安全评价报告自动编制系统

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5267155A (en) * 1989-10-16 1993-11-30 Medical Documenting Systems, Inc. Apparatus and method for computer-assisted document generation
WO1996034348A1 (fr) * 1995-04-27 1996-10-31 Michael Umen & Company, Inc. Systeme de production de document relatif a un medicament

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5267155A (en) * 1989-10-16 1993-11-30 Medical Documenting Systems, Inc. Apparatus and method for computer-assisted document generation
WO1996034348A1 (fr) * 1995-04-27 1996-10-31 Michael Umen & Company, Inc. Systeme de production de document relatif a un medicament

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US6555354B2 (en) 1995-06-08 2003-04-29 Immunex Corporation TNF-α converting enzyme
US7392248B2 (en) 1999-08-04 2008-06-24 Hyperroll Israel, Ltd. Data aggregation server supporting rapid query response with sparse multi-dimensional data
US7315849B2 (en) 2000-02-28 2008-01-01 Hyperroll Israel, Ltd. Enterprise-wide data-warehouse with integrated data aggregation engine
US7333982B2 (en) 2000-02-28 2008-02-19 Hyperroll Israel, Ltd. Information system having a mode of operation in which queries form one or more clients are serviced using aggregated data retrieved from a plurality of different types of data storage structures for improved query performance
US7640335B1 (en) * 2002-01-11 2009-12-29 Mcafee, Inc. User-configurable network analysis digest system and method
US8024650B2 (en) * 2006-03-31 2011-09-20 Microsoft Corporation Drilling on elements in arbitrary ad-hoc reports
CN102799599A (zh) * 2011-05-27 2012-11-28 富士通株式会社 用户生成媒体信息的处理方法及装置
US20240176948A1 (en) * 2013-03-15 2024-05-30 PowerNotes LLC Method & system for labeling and organizing data for summarizing and referencing content via a communication network
CN103593456A (zh) * 2013-11-22 2014-02-19 中国技术交易所有限公司 表单自定义设计方法及装置
WO2020204374A3 (fr) * 2019-04-05 2020-12-03 오스템임플란트 주식회사 Procédé et dispositif pour fournir un rapport de chirurgie basé sur un modèle spécifique à l'utilisateur

Also Published As

Publication number Publication date
EP1005678A1 (fr) 2000-06-07
JP2001516084A (ja) 2001-09-25
CN1270680A (zh) 2000-10-18
AUPO863697A0 (en) 1997-09-11

Similar Documents

Publication Publication Date Title
US5148366A (en) Computer-assisted documentation system for enhancing or replacing the process of dictating and transcribing
US7917842B2 (en) System for describing the overlaying of electronic data onto an electronic image
US6018617A (en) Test generating and formatting system
JP4981268B2 (ja) カラー化されたテンプレートプレビュー
US20020091728A1 (en) Multidimensional electronic spreadsheet system and method
EP1005678A1 (fr) Technique informatisee de compilation de rapport
US20050114160A1 (en) Method, apparatus and computer program code for automation of assessment using rubrics
JP2857968B2 (ja) 組織図作成装置及び方法
US6633859B1 (en) Knowledge system with distinct presentation and model structure
CN118485149B (zh) 基于组合阅读实现知识库与任务对象精准区分比对的方法
Assad et al. Project management using a microcomputer
JP2001222613A (ja) 商圏表示方法、商圏表示装置および媒体
Hussain et al. An Introduction to Frontier Analyst 4
Gruhn et al. A research perspective on computer-assisted office work
AU8721098A (en) A computerised method of compiling reports
US20070157087A1 (en) Method and system for automatically generating user interfaces for integration
Sutton A guide to making documents accessible to people who are blind or visually impaired
JP2006323177A (ja) 時間割生成装置、時間割生成方法及びプログラム
EP1130543A2 (fr) Système comparatif de dissémination d'informations basé sur des connaissances
GB2412832A (en) Status and progress monitoring system for computer based interviews
Kelly What users want from a tool for analyzing and documenting electronic questionnaires: the user requirements for the TADEQ project
AU725420B2 (en) A computerised method for dynamically creating, modifying, removing and maintaining information in a database
Mozgova et al. Formation of a Creative Environment for Decision-Making in Business Based on the Construction of Intelligence Maps Using Information Technology
Kelly What users want from a tool for analysing and documenting electronic questionnaires: the user requirements for the TADEQ project
Abdulezer Excel Best Practices for Business: Covers Excel 2003, 2002, and 2000

Legal Events

Date Code Title Description
WWE Wipo information: entry into national phase

Ref document number: 98809102.X

Country of ref document: CN

AK Designated states

Kind code of ref document: A1

Designated state(s): AL AM AT AU AZ BA BB BG BR BY CA CH CN CU CZ DE DK EE ES FI GB GE GH GM HR HU ID IL IS JP KE KG KP KR KZ LC LK LR LS LT LU LV MD MG MK MN MW MX NO NZ PL PT RO RU SD SE SG SI SK SL TJ TM TR TT UA UG US UZ VN YU ZW

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): GH GM KE LS MW SD SZ UG ZW AM AZ BY KG KZ MD RU TJ TM AT BE CH CY DE DK ES FI FR GB GR IE IT LU MC NL PT SE BF BJ CF CG CI CM GA GN GW ML MR NE SN TD TG

DFPE Request for preliminary examination filed prior to expiration of 19th month from priority date (pct application filed before 20040101)
121 Ep: the epo has been informed by wipo that ep was designated in this application
WWE Wipo information: entry into national phase

Ref document number: 87210/98

Country of ref document: AU

NENP Non-entry into the national phase

Ref country code: KR

WWE Wipo information: entry into national phase

Ref document number: 09485814

Country of ref document: US

WWE Wipo information: entry into national phase

Ref document number: 1998938528

Country of ref document: EP

WWP Wipo information: published in national office

Ref document number: 1998938528

Country of ref document: EP

REG Reference to national code

Ref country code: DE

Ref legal event code: 8642

WWW Wipo information: withdrawn in national office

Ref document number: 1998938528

Country of ref document: EP