WO1991009368A1 - Procede et appareil de stockage, de transmission et de recuperation de donnees graphiques et tabulaires - Google Patents

Procede et appareil de stockage, de transmission et de recuperation de donnees graphiques et tabulaires Download PDF

Info

Publication number
WO1991009368A1
WO1991009368A1 PCT/US1990/007334 US9007334W WO9109368A1 WO 1991009368 A1 WO1991009368 A1 WO 1991009368A1 US 9007334 W US9007334 W US 9007334W WO 9109368 A1 WO9109368 A1 WO 9109368A1
Authority
WO
WIPO (PCT)
Prior art keywords
local
database
data
graphical
query
Prior art date
Application number
PCT/US1990/007334
Other languages
English (en)
Inventor
A. Martin Rozmanith
Anthony I. Rozmanith
Gabor F. Fulop
Neil Berenson
Egon Stephen Fabian
Ted R. Trilling
Original Assignee
Araco
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
Priority claimed from US07/450,606 external-priority patent/US5179652A/en
Priority claimed from US07/544,826 external-priority patent/US5185857A/en
Application filed by Araco filed Critical Araco
Publication of WO1991009368A1 publication Critical patent/WO1991009368A1/fr

Links

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
    • 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/242—Query formulation
    • G06F16/2428—Query predicate definition using graphical user interfaces, including menus and forms
    • H—ELECTRICITY
    • H04—ELECTRIC COMMUNICATION TECHNIQUE
    • H04L—TRANSMISSION OF DIGITAL INFORMATION, e.g. TELEGRAPHIC COMMUNICATION
    • H04L67/00—Network arrangements or protocols for supporting network services or applications
    • H04L67/50—Network services
    • H04L67/56—Provisioning of proxy services
    • H04L67/567—Integrating service provisioning from a plurality of service providers

Definitions

  • the present invention is related in general to
  • the present invention is directed to improved methods and apparatus for providing rapid retrieval and display of such information on any given node, within local area networks, and within wide area
  • a graphically oriented user interface for multi-distributed, interactive local use combined with coordination and distribution provided by an interactive host and/or network system would be a major advancement, and would greatly improve the efficiency of end users by providing them with a considerable advantage over users who do not implement such a system.
  • the system of the present invention makes feasible both single user and network implementation incorporating a GUI and GRDB in spite of the natural limitations posed by conventional telephone transmission lines.
  • the bulk of the required data typically twenty megabytes to over one gigabyte of graphics data
  • pictorial representations both stationary and animated
  • tabular data is stored locally.
  • the present invention provides an improved method and apparatus for the rapid search and co-display of graphics and tabular data for both local and distributed computer systems.
  • the apparatus and method of the present invention rapidly 5 selects and displays related graphical and textual information t: ) via a Graphical User Interface (GUI) from both a Graphical Relational Database (GRDB) and tabular database.
  • GUI Graphical User Interface
  • GRDB Graphical Relational Database
  • An operator enters a query or option request in which previously encoded and stored graphics elements are selected, 10 via a control program, from a local mass storage device and displayed with related textual information on a local display.
  • the remote host subsequently or simultaneously, processes the locally generated query. Incremental, additional or updated data at the remote host may then be rapidly accessed and 15 transmitted back from the host to the local user.
  • the present invention thus effectively creates two linked databases, both of which are necessary, updatable and/or expandable.
  • the database (or the majority of the database) is stored on-site so as to provide instantaneous graphics 20 responsive to the character based tabular data and/or commands which are easy to quickly transmit via conventional communication lines. Additional data or updated data is stored at the remote host and can be rapidly transmitted.
  • the present invention has numerous applications including the dissemination 25 or real estate information, medical image processing and data management, and the dissemination of architectural and business plans.
  • the present invention is particularly suited to be utilized in a system which incorporates a RVAD (i.e. a raster 30 vector attribute database) based display system in which one of the parameters of the search request is, for example, geographic data.
  • RVAD i.e. a raster 30 vector attribute database
  • the present invention may further incorporate state of the art optical character recognition (OCR) technology for database entry and system updatability. 35 It is therefore an object of the present invention to provide a system which incorporates a GUI for selecting updatable database options processed simultaneously or sequentially by a local computer and remote host computer.
  • OCR optical character recognition
  • the present invention is directed to an improved combination of components for a presentation and selection system used in applications such as real estate documentation, information and selection service, medical image retrieval and manipulation and the selection of medical records.
  • the invention combines computer hardware and software with an additional graphic oriented user interface, and combines - 5 - multiple large tabular and graphic databases and computer hosts and/or servers with a rapid, combined system search and display capability for selected and related data from at least two databases (i.e. one local and one located at the host or 5 server) .
  • Output generated by a query search and display request is displayed on a linked end-user computer such as a personal computer via a graphical user interface.
  • apparatus for displaying graphical and tabular data is disclosed.
  • the 10 invention comprises local computer means having CRT (or flat panel) display means and containing at least one application program.
  • the local computer means further contains a control program for facilitating the processing of a database query formulated at the local computer station.
  • the local computer has CRT (or flat panel) display means and containing at least one application program.
  • Communication means including a modem transmit the query to the host computer means for simultaneous or subsequent processing.
  • the host computer means contains a
  • control program which simultaneously processes the query and selects responsive graphical and tabular data.
  • the data transmitted by the host computer may supplement the data identified in the local database.
  • the host computer means transmits the selected data by 25 the transmission means to the local computer means wherein the data may be displayed on the CRT display means by said graphical
  • a graphical relational database means situated at both the local station and host stores graphical data and transmits graphical data responsive to the query directly to 30 the CRT display means in response to a command from said graphical user interface program.
  • the present invention further provides a method for controlling the transmission and/or retrieval of tabular and/or graphical data as recited in the following steps: formulating
  • a query relating to a database selection on a local computer locally processing and/or transmitting said selected query to a remote host computer; selecting graphical and tabular data using local computer and/or host responsive to said query; selecting a graphical presentation from a locally stored graphics database responsive to said query; and displaying said selected graphical and tabular presentation on a display associated with the local computer.
  • Figure 1 is a block diagram representation of the database selection and retrieval apparatus of the present invention.
  • Figures 2-3 are time sequence charts which illustrate the flow of the control programs of the local user station and area center.
  • Figure 4 is a block diagram illustrating the steps for a database search using an RVAD database.
  • FIG. 5 is a block diagram of the control program for the RVAD of the present invention.
  • Figure 6 is an illustration of a raster/vector space as actually shown on a CRT display.
  • Figure 7A illustrates the display of RVAD attributes on a CRT display.
  • Figure 7B illustrates a map of the state of Georgia from which the RVAD overlay map of Fulton County of Figure 6 was derived.
  • Figure 7C is an enhanced view of a multitasked RVAD based display system which illustrates interactive maps and tabular windows for the tri-state (Del., N.J. and PA) Philadelphia metropolitan area.
  • Figure 8 is a block diagram of a wide area network in accordance with the present invention linking several counties or an entire region.
  • Figure 9 is a block diagram of a national network in accordance with the present invention for linking up to four major regions via a public value added communications network.
  • Figure 10 is a block diagram of the national network of Figure 9 incorporating a dedicated private communications network.
  • Figure 11 illustrates a multiprocessing based system utilized in the present invention.
  • Figure 12 illustrates the use of the present invention in a global network which can be remotely accessed.
  • FIGS. 13A and 13B illustrate typical system-wide data traffic flow and in footnotes discuss related details and/or characteristics.
  • Figure 14A and 14B illustrate typical system-wide data storage allocation for a single application and in footnotes discuss related characteristics and/or details particularly suited to an updating and transaction oriented environment, such as the described real estate information service.
  • Figure 1 illustrates the basic embodiment of the present invention as utilized in both a single user and LAN/WAN (local area network/wide area network) configuration.
  • the system comprises a local station 10 and area service center 20 (with in respective hashed lined) linked by a conventional telephone link 15.
  • the local station 10 and area center 20 comprise elements of a linked database for one or more applications such as the selection of real estate information, medical image processing and the dissemination of architectural and structural designs.
  • the local user station 10 is located within a real estate brokerage company and the area center is located at a remote location.
  • the local station 10 is utilized to process database queries pertinent to real estate information such as housing prices, number of bedrooms, square footage and to display tabular, graphical and pictorial representations of the selected information.
  • the local user 10 station comprises a computerized system including a display device 12 having a graphic monochrome or high resolution color CRT or flat panel display 12.
  • Display device 12 displays information and selected tabular and graphics data pertinent to selected information to the operator.
  • the system 10 also includes a keyboard 14 and most preferably a mouse 14 which the operator may use to enter information, including both commands and data into the system via a graphical user interface (GUI) 16.
  • GUI graphical user interface
  • Microsoft Windows 3.X is the preferred GUI 16 for the present invention because it is the most widely accepted graphical user interface for the IBM PC compatible family of computers.
  • other comparable GUI programs may be used in the present invention. Examples of other currently available GUIIs are OS/2 PM (Presentation Manager), PM/X, CXI, Motif, DEC- Windows, and Open Loop.
  • the GUI 16 and system 10 are utilized in association with one or more application programs 23 (real estate in this example) which can be written in "C" or an object oriented programming language such as Actor.
  • the individual application program defines the search criteria.
  • the application program interfaces with the graphical user interface 16.
  • the local user system 10 is thus used to collect the information to be used for specifying the search criteria or modifying the database.
  • the user interface originates a function call to the control program to originate the query.
  • An external printer 18 provides hard copy output of real estate (or other application) data output selected by the operator.
  • the system may can also include an internal fax board which can be utilized to send facsimile transmissions and/or multi-media features 21.
  • the local user system 10 is utilized in association with a mass storage database residing on a storage medium such as a WORM (Write Once Read Many) drive 22 which stores encoded Graphics Relational Database GRDB and tabular records pertaining to individual real estate information within the database.
  • graphics refers exclusively to pictorial representations such as a raster image.
  • WORM 22 is preferably a large transparent mass storage device which supports random access to data stored on the device.
  • the present invention can utilize any magnetic, optical, CD, or magneto-optical mass storage system and/or plasma etched storage systems as the database storage means 22.
  • the mass storage device 22 may further comprise an optical tape storage system such as that manufactured by Creo products. One square millimeter of etched optical tape can hold store 100,000 bits of information.
  • the interface from the computer to the WORM 22 is preferably an SCSI (Small Computer Serial Interface) interface (not shown) , which is controlled by an intelligent interface attached to the computer bus.
  • SCSI interface supports a high data transfer rate of at least twice that of the "standard" ST506 interface used in typical fixed disk and other computer peripherals. Creation of the WORM for distribution to end users and for updates of the GRDB, allows optimized placement of data on the WORM so as to further speed and access to the data.
  • the microprocessor in the local user station with associated hardware and operating system includes a microprocessor 24 such as an Intel 80286, 80386, 80486, 80X86 or Motorola 68030, 68040 microprocessor or more powerful, that will typically operate under the DOS, UNIX or XENIX operating systems.
  • a RISC based CPU e.g. as produced by Sun Micro Systems may also be used. The latter two operating systems are multi-user and multi-tasking systems.
  • the system also includes communications software 25 and encryption system.
  • Modem 26 transmits commands via standard voice grade communications lines 15, to interconnect the area center 20, which stores the master tabular database and a host control program.
  • the local user system is utilized in association with a database engine 28 such as Wintrieve or DBVista III by Raima Corporation.
  • the database engine performs the database searching and saving functions based upon commands of the applications program and control program.
  • the area center 20 contains a host processor 31 which will typically contain an Intel 80486 or more powerful microprocessor operating under the Unix or Xenix multi-user, multitasking operating system.
  • the host computer of the Area Center 20 will service a number of applications (e.g. Real Estate, Medical Image Processing) and will be linked to one or more local user centers 10.
  • the area center 20 will contain a central control program 11 which serves to route query requests to one or more service package programs 33 residing within the area center computer.
  • Each service package application services a particular application, e.g.
  • the area center 20 contains a WORM 32 which stores a tabular and graphic database which is accessed by a area center database engine.
  • WORM 32 which stores a tabular and graphic database which is accessed by a area center database engine.
  • One or more local user stations can be connected to an Area Center via direct dial telephone link-up.
  • the system of the present invention includes control programs which reside at both the local user station 10 and area center 20.
  • the control program (CP) performs two major functions: table driven dispatching; and as a library of function calls which accommodate the operating system, database engine, communications system and applications program.
  • the user initiates transactions through the GUI. These transactions are dispatched through to an appropriate handler, i.e., the local database engine, graphical database, or a remote database via communications program 25.
  • an appropriate handler i.e., the local database engine, graphical database, or a remote database via communications program 25.
  • handler refers to a function or set of functions which perform a requested operation. Responses are returned to the GUI 16 for presentation to the user. All CP 11 actions originate with a transaction from the GUI 16 in the form of a function call to the CP 11.
  • the CP using application program 23 unique transaction tables, converts the transaction data to a format required by the DBE, and makes a function call to the DBE 28.
  • the DBE 28 performs the requested action(s) , and returns a response to the CP, which may be just a completion code or one or more messages. If the transaction requires further action, the control program initiates the additional transactions. Upon completion the CP converts the response to the format required by the GUI 16, and returns it to the GUI.
  • the processing of a transaction includes the following major steps: o converting application data formats to DBE formats o invoke handler o converting a handler response to application data format o return to application
  • a transaction-control table will contain references to determine the identity of the handler, the format of the parameters passed by the GUI to the CP, the format of the parameters required by the handler, as well as the format of handler responses and their disposition, as described below.
  • Each transaction passed to the control program shall include a transaction code.
  • the control program locates the code in a transaction-control database table. If not found, the control program will return to the application GUI with an error indication. If found, the control program will identify the handler to be used. It will then test whether or not the handler is currently available. If the handler is unavailable because it was not loaded, the control program will request the operating system to load it. If unavailability is due to a concurrent task not having been initiated (e.g., the WinTrieve ISAM engine in the MS-Windows environment) , the control program will request the operating system to start it. If the handler is still unavailable, the CP will report the error condition to the GUI.
  • a concurrent task not having been initiated e.g., the WinTrieve ISAM engine in the MS-Windows environment
  • a transaction-control table specifies the table describing the structure of the information passed by the GUI to the control program, the table describing the information required by the transaction handler, and the table specifying the correspondence between them.
  • the control program will build the data structures required by the handler according to these tables.
  • a transaction-control table will similarly specify the tables required to convert handler responses to the GUI format, permitting the CP to perform the reverse conversions as needed.
  • the transaction control table is unique for each application. It is sorted by transaction codes.
  • the table contains information describing the format of the parameters passed by the caller.
  • first-level table When the application is loaded, it will specify the name of the first-level table which enumerates the application data tables it utilizes. The contents of that database table will be loaded by the control program into its internal table- list.
  • Another first-level table, column-format will be coded as part of the database engine interface (i.e., a unique version may be needed for each database engine to be used with the CP) . It will enumerate the format of the columns to be read into column-description.
  • the second level table column-description will be shared by all applications available in the machine. It will describe the name and characteristics of each column of each table used by any of the applications.
  • Another category of control tables are used for interfacing to remote databases. All the information for each remote database access request will be assembled by the control program, under the control of these tables, to be passed to the communication program as a single message. These tables will control whether or not information will be translated from its local format to another format before transmission, and if so. - 13 - how. The tables will similarly control what, if any, translation is required before remote database responses are delivered to the application. The tables will similarly control what, if any, translation is required before remote database 5 responses are delivered to the application. The tables will also control how the response is to be broken into smaller units when required.
  • the local user system 10 of the present invention may also be utilized as a stand-alone 10 prototype which operates under DOS running under Microsoft I Windows version 3.0.
  • a preferred database engine on the stand-alone system is Wintrieve, and the application program will be written in object oriented Actor "C".
  • C object oriented Actor
  • records are initially generated. Once the list of records is generated, queries can be generated. The query searches all the records and presents the records which fit the field specifications of the query. The records previously saved to disk are then called up. 20
  • GUI will preferably incorporate a raster/vector/attribute graphic database (RVAD) used to obtain specific selection sets based upon data criteria such as geography.
  • RVAD is a method of overlaying a raster image, such as a map, visible to a person 25 viewing a computer screen, over a vector space (part of which is the screen viewed by the local user) .
  • the vectors may be •; displayed or may also be transparent.
  • the vector space is virtual, and the raster image is a "window" looking at a portion of the vector space which is composed of four elements; points, 30 lines, faces, and attributes. Each point, line, or face in the vector space can have multiple associated attributes.
  • the local user would select either vector points, lines or faces from the raster overlay on the vector space, such as a map on the screen. That is, the user selects a portion of
  • the vector space is preferably bit or overlay mapped in order to provide background images as shown in Figure 7C.
  • the selection may be an area, individual object, or a point on the screen. The area may be selected by clicking on a point, or "boxing" an area on the screen with a pointing device (mouse or digitizer) or the keyboard (arrow keys) . The selected area of the RVAD map can then be enlarged and/or manipulated.
  • the selected area would then define the user database query, with the control program using the locations within the selected for the host database selection criteria.
  • the RVAD can be implemented utilizing a vector and MVP card.
  • An MVP card is a processor device which is capable of masterizing images on a filing recorder at 2000 or 4000 lines of resolution. It is to be noted that the implementation of an RVAD based system can utilize "off-the-shelf" software such as CAD overlay ESP (Edit, Save, Plot) and DRAFIX CAD Overlay, a program which allows a raster image to serve as a template on the screen so that vector data can be traced over it. Terminal Emulators such as the EM320, 4010, and 4105 manufactured by Diversified Computer Systems are particularly suited for RVAD applications.
  • the RVAD vector space may cover several counties in, for example, the state of Georgia ( Figure 7B) .
  • Each of the counties contain a plurality of real estate information, each of which is identified by a point. In total, there may be up to 10,000 points within the total vector space of the county (not completely shown) .
  • a window 51 may cover a portion of one of the counties (Fulton County 48) of Georgia which contains, for example, 20 points. The potential home buyer or realtor would then select type in other desired options, criteria or attributes such as price (e.g. less than $200,000), size (e.g. four bedrooms) , etc.
  • the query and twenty points defined within the window of Figure 6 are processed via the real estate applications software situated at the local station.
  • Pursuant to the applications program residing in Act the local control program transmits the X-Y coordinates of the window to the database engine.
  • the application program may initially determines how many of the 20 homes defined by each point possess one or more of the desired attributes or criteria defined by the query.
  • the application program calls up the data.
  • the data will typically comprise information such as the address of the information, the asking price, and the age of the information.
  • Figures 2 and 3 illustrate the anatomy of a sample transaction utilizing both the local user station and the area center on RVAD input means and local and area control programs.
  • This sample transaction assumes that the user is interested in reviewing real estate related records at, for example, a real estate brokerage.
  • the user selects the geographic area of interest via the RVAD interface.
  • the application program builds and sends to the control program a geographic area retrieval request.
  • the control program passes the geographic area of retrieval request to the communications programs.
  • the control program then activates the database engine.
  • the communication software passes the geographic area retrieval request to the area center.
  • the control program passes geographic area retrieval request to the database engine.
  • the database engine starts up and initializes. It then retrieves and delivers to the control program the first matching record.
  • the area center verifies user authorization. It then builds a buffer of geographically matching records which are not in the local database.
  • the user selects a bedroom count via the graphical user interface.
  • the control program builds a buffer for local matches, buffers the first record and requests the next record.
  • the database engine retrieves the next geographic match. This process is repeated until all record matches which satisfy the geographic areas defined by the RVAD are located.
  • the user then activates the search via the application program.
  • the control program buffers the next record and delivers the first record to the application program.
  • the application program checks if the first record is a complete match (all criteria) and then displays the first match.
  • the database engine continues to retrieve the next geographic match. This process is repeated until all matches satisfying the requested criteria are identified and displayed. Referring to the lower portion of Figure 2, the application program will then make a determination as to whether a sufficient number of local matches were found.
  • the application program will then request area center matches. Initially, a request is passed from the application program to the communication system.
  • the control program builds a buffer area for records which are passed via the communications system to the area center.
  • the communication system then passes area center records to the local control program which buffers.
  • FIG. 3 illustrates a sample transaction from the standpoint of the area center.
  • the communication program passes the user access request to the control program residing in the area center.
  • the geographic area retrieval request is similarly forwarded to the area center control program.
  • the control program residing at the area center verifies the user authorization and passes a geographical area retrieval request and user ID to the specific service package.
  • the service package builds a buffer for matches and passes geographic area retrieval request to the database engine.
  • the database engine then retrieves and delivers to the service package the first matching record.
  • the service package checks if the record is known to the local user. It then buffers the next area center-only record and requests the next record. The database engine then retrieves and delivers to the service package the next matching record and the process is repeated. 5
  • the lower portion of Figure 3 illustrates the transmittal of records from the area center to the local user. Initially, the communication program passes a local user delivery request to the control program. The control program
  • the address pointer of the GRDB will be selected to conform to the limitations and operating system of the local system. For example, if the local system utilizes a monochrome
  • a further aspect of the system of the present invention and one which is particularly applicable to an RVAD based system is the facilitation of the entry of new data entries (e.g. graphic and/or tabular) to the system.
  • new data entries e.g. graphic and/or tabular
  • a real estate office would enter a new entry such as a real estate information containing the query criteria of location, asking price, size etc., and transmit to the area center via the communications system.
  • 35 area center 20 would place the new information on the vector space with respect-to previously entered entry points and then transmit back to the local user.
  • Other end users could periodically receive the new information, either through periodic updates (e.g. nightly, weekly) or updates could be periodically piggybacked during each query.
  • Two or more area centers may be linked in interactive operation thereby increasing the area and/or number of local stations serviced.
  • two clients may be interlinked via this system, further via at least one area server and preferably at least one other communications means such as fax, voice, etc.
  • a key feature of the invention is that there is no direct linkage between local user stations. Any local user station (i.e. peer) to local user station (peer) communication must go through an area center 20.
  • the system of the present invention can utilize optical character recognition (OCR) technology for data entry and. system updatability.
  • OCR optical character recognition
  • the present invention can utilize portable hand held OCR image scanners such as the AS-8000P and Image 72 and Image 256 painting scanners manufactured by A4SCAN. State of the art portable scanners such as the AS-8000P provide graphics resolutions up to 400 dpi.
  • the present invention can further utilize Desktop Scanner technology such as the Apple Scanner, Bell & Howell "Jetscan", and Xerox "Datacopy” line of scanners.
  • Modern medical practice requires a number of digital images. These include radioscopic X-ray, CAT (Computed Axial Tomography) Scan, NMR (Nuclear Magnetic Resonance) , and PET (Positron Emission Tomography) images.
  • numerous analog images are often acquired for diagnostic purposes. These include ordinary x-ray film, ultrasound displays and endoscopic images (which are often recorded on video tape) . Conversion of analog images to digital form is increasingly used. For example, DuPont has a method of scanning x-ray film and converting it to a high-resolution digital image. Conventional digital signal processing techniques can then be used on such images to enhance certain features by varying the contrast, removing background noise, etc.
  • the apparatus for the acquisition of high-resolution medical images is extremely expensive and only available at large medical centers. Thus, the images are not readily available to physicians in remote locations.
  • the diagnosis is often made at the medical center and a "single-slice" hard copy sent to the local physician.
  • the local physician currently has no opportunity to view cross-sections at will.
  • the physician's local database could be updated with an express delivery of the data (for example on magnetic and/or optical tape media) . He could then view the image in any way desired merely by sending commands to an area center located at a medical center (or at another location having a host and compatible software) for recalculation of the image ("reconstruction") . This would enable him to have the "look and feel" of working with the actual imaging system.
  • the availability of patient records to a number of medical practitioners is often necessary. This may be the case for a patient seeing various specialists. Alternatively, a patient who has moved sometimes needs portions of his medical record from a distant family physician.
  • the present invention is applicable to these cases, especially as it relates to graphical information.
  • a radiologist may follow the development of a tumor by having a graphics data base stored locally and updating over the phone any changes as new x-rays are taken.
  • Another example involves the monitoring by CAT scan and NMR of certain chemical deposits which have been correlated with Alzheimer's disease.
  • Doctor's notes may also be transferred in both graphical form (especially if they include sketches) as well as ASCII characters.
  • graphical images have the disadvantage that they cannot be readily text edited.
  • the system of the present invention can further be configured to utilize an image storage and retrieval system such as that manufactured by Recognition Equipment Corp.
  • the present invention could further utilize a sophisticated image processing system.
  • Such a system could utilize the Image Plus High Performance Transaction system which requires an IBM 3090 mainframe computer.
  • the IBM system captures 2400 documents per minute.
  • the use of image processing technology could be particularly applicable for medical database applications.
  • a key feature of the embodiments of Figures 1 and 8-10 is of multiprocessing (SLCMP) by the local and regional hosts.
  • Symmetric Loosely Coupled Multiprocessors SLCMPs
  • SLCMPs Symmetric Loosely Coupled Multiprocessors
  • the term multi ⁇ processing describes the ability of a computer system to utilize more than one Central Processing Unit (CPU) concurrently.
  • CPU Central Processing Unit
  • Unequally distributed co-processors associated with co-operating computers create assymetric multiprocessing.
  • Microprocessing is available on hardware configurations such as the Sequent and Convex "minicomputers", and the Compaq SystemPro. Operating systems which utilize multiple processors optimize input/output from the system, and permit the simultaneous use of more than one application on the system.
  • each computer will typically have its own peripherals (disks, LANs, terminals, etc.) along with a dedicated interprocessor communications channel (IPC) .
  • IPC interprocessor communications channel
  • SLCMP as applied in the present invention is that processing capacity can be added easily and system performance can scale proportionally to the capacity of the discrete components (i.e. the local and stations, local hosts 63 and regional host 64) .
  • a Compaq SystemPro could be used to control the processing for multiple databases simultaneously accessed by different hosts.
  • the SystemPro could simultaneously process for example, Real Estate and Medical applications emanating from different networks.
  • Figure 11 illustrates the use of multiprocessing in the present invention. As shown, two or more workstations connect to a local regional host. The existence of several CPUs on the host coupled with multiprocessing software permits the host/server to simultaneous process a plurality of queries.
  • Figures 8-10 illustrate further examples how the system of the present invention could be incorporated as part of a local, regional, national or continental network.
  • Figure 8 illustrates a host/server which would typically service a region such as Bucks County, PA. The host will service a plurality of system subscribers located within a single county for applications ranging from graphic real estate information to medical image processing. Users outside of the system can access the system via phone or modem.
  • Figure 9 illustrates a regional network (e.g. the Philadelphia Metropolitan Area) which links the hosts of several counties. The hosts may be linked by a fiber optic network capable of transmitting data at rates of up to 40,000 baud.
  • FIG. 10 illustrates a national network interlinked and supported by a nationwide value-added fiber-optic network such as Sprint or CompuServe.
  • Modems such as the PEP modem by Telebit Corporation.
  • This modem splits the bandwidth of voice grade telephone communications into 524 virtual circuits.
  • Intelligence within the modem dynamically contracts or expands the number of circuits used to communications between PEP modems based on the quality of the circuit.
  • the local computer or terminal attached to the modem maintains a constant interface speed with the modem and the connected modems arbitrate the line speed.
  • PEP technology also supports 32 bit error correction and compression of data and supports special protocols such as UUCP (for UNIX based computers) , Kermit and YMODEM file transfer protocols that take advantage of the modem based flow control for the transfer of binary data between computer systems.
  • a typical 9.6 Kbaud data circuit can support multiplexing of the circuit to support multiple connections across the same circuit.
  • Use of a multiplexer such as those produced by MultiTeck allows sharing of a single 9600 bps to 19,200 bps data line among several systems, thus increasing the output and economy of the system.
  • Sprint and other current communications vendors support various means for the sharing of public networks, and provide transmission speeds up to 40,000 baud.
  • Sprint has an X.25 network with connections to most cities within the United States and most major international cities. Data is collected in packets at high speeds (up to 9600 baud) and routed through the network to the remote address specified by the connection. Multiple computers attached to this network can exchange data based on unique addresses within the system.
  • This type of network is also supportable by CompuServe and other Value Added Network providers.
  • Figure 10 discloses a private national network that can consist of dial-up connections via high speed modems (e.g. Telebit T2500 or equivalent) .
  • This network can also utilize a combination of dial-up modems and dedicated data lines.
  • the addition of multiplexers in this configuration allows dedicated data lines to be split into multiple data lines to support multiple hosts or concurrent queries from a single host. This maximizes the greater bandwidth of the dedicated data connection and improves utilization of the data line.
  • a further benefit of the present invention manifests itself in it unexpected efficiency for linking national and/or continental networks containing in their regions a variety of circuit switching and/or packet switching technologies into an efficient international and/or inter-continental (i.e. global) network.
  • global network i.e. global
  • bulk WAN data expansion and/or update information can be provided by transported (non-electronically transmitted) system compatible and recombinable data storage means (M) for most local and regional purposes. All presently available switching and packeting technologies can co-exist in the networks of the present invention.
  • the greatly reduced long distance traffic flow particularly in combination with RVAD and/or PQA features of the present invention provides for practical and/or repeated re- switching and/or repacketing applicability.
  • This may also include cell-relay and/or frame relay packet switching combined with circuit switching.
  • a further aspect of the invention is the use of encoded VCR tape means such as that disclosed in co-pending VCR Based Presentation Selection Means for data storage.
  • the present invention has been described in the context of systems in which the end user will pose a query which will be processed yielding tabular and graphical data at a local workstation.
  • the present invention thus serves as a means to optimize system-wide data traffic flow and storage allocation.
  • Figures 13A, 13B and 14A, 14B illustrate said system-wide data traffic and storage allocation profiles for an intercontinentally linkable system with respect to said data profile parameter with some notable characteristics (e.g. there is no communication between local user (peer to peer stations) ) . Greater than sixty-seven percent of the data traffic (D) will flow between the local station and the area center.
  • M Media means
  • a final aspect of the present invention is the provision of a mechanism which facilitates the practical pre- storage of preselected presentation format (component(s) ) which may be shown on displays associated with local presentation means but which cannot themselves generate such output in real time operation.
  • preselected presentation format component(s)
  • three dimensional animated graphical presentation outputs incorporating "walk throughs” and "fly-bys" generated using, for example, a 386 or 486 host cannot be generated within a practical (egoleodline 48 hours) environment by a local station operating with a 286 AT processor.
  • Such output presentations can be usually generated at a particularly slow rate using a 386/486 Host.
  • a pre-defined, preprocessed, appropriately re-formatted e.g.
  • a local (e.g. AT) station can provide a practical real time "preprocessed query answer" (PQA) component with real time and/or zoom features (for a local workstation customer presentation.
  • PQA preprocessed query answer
  • An example of useful combination would be to use AutoCAD (from Autodesk) at a host server to create CAD (possibly with RVAD application) output under UNIX which can be predistributed to local databases, retrieved and manipulated under a simpler version of a compatible software program such as Autosketch (from Autodesk) .
  • a query structure system probably would subsequently select, from locally stored substantially pre-processed, predistributed query answer(s) (PQA) component(s) at least one animated and/or zoomed segment of a query answer upon an appropriate workstation query.
  • PQA predistributed query answer(s)
  • Pregenerated PQA's can be stored as interactive recombinable components, preferably for an 8086, 8088, 80286 or higher power local workstation and/or at least a dual window graphic multiprocessed output which can be stored in toto for searchable redisplay upon command in a database of relatively lower (end-user) power (end-user) local workstation, such as an IBM, PC, XT, AT, a low-end 386 based compatible and/or a comparable Motovola 6800 microprocessor chip (LPV) based unit with adequate local database storage capacity and retrieval gate speed.
  • the storing and/or retrieval of single and/or at least dual-window PQA's, particularly involving animation (e.g. including zoom) and/or color is a particularly important efficiency improving feature of this invention (e.g. using an IBM XT. AT. 0S2 or compatible ⁇ .
  • PQA's limited (e.g. Menu) choices are preferably presented for query selection to end-users increasing the use-probability of said PQA's and thereby the PQA utilization efficiencies of the system.
  • a relational database engine such as Ingres with SCO Open Desktop
  • a user interface is constructed from pre-defined forms such as SQLWindows produced by Gupta Technologies. This form would be used to Query the database (Query by Example) , and for display of the extracted information.
  • Pre-Designing the form is typical of RDBE applications, and a typical application would be designed with indexes on specific fields of the database tables to assure sub second (or 1-5 second) response times for the application. This would be possible in part to the fact that we are extracting in most cases, when using conventional dialable phone line query limitation data only, not working in a transaction based environment (such as an airline) where data would be entered as well as extracted.
  • PQA's will facilitate the indexing of output formats such that outputs can be standardized regardless of the written and/or spoken language (or its local versions) of the user, (e.g. Chinese, Japanese, Spanish, English, French, German or a Slavic) .
  • a preferred system would provide intelligent PQA capability (as a preferred upgrade option) for any portable unit from related LAN's upon hook-up in any other regional (e.g. diversified continent based WAN in English further in at least one more regionally dominant language and/or a local language.
  • Such service can be provided from regional "super" hosts and would be available as a location limited upgrade option to selected minimum 386 power W/S's.
  • Designing the workstation/PC application to take advantage of background processing using Windows or UNIX based software will improve the functionality of the application by supporting concurrent display of data to the end user while processing the transfer of graphic images into a disk or memory buffer.
  • This enhanced capability would require that the PC be configured with two to sixteen or higher megabytes of RAM to take advantage of background processing capabilities of Windows and other multitasking or background processing software.
  • An alternative for enhanced local service would incorporate network
  • NFS Network File System
  • the invention thus provides improved and expanded graphical and combined presentation capabilities within a time constraint (i.e. on line, overnight, 48 hour service) environment.
  • the PQA system by using the combination of a W/S query, a high capacity PQA host associated with a relative large (and preferably pre-processable) database for at least the most desired or probably anticipated query answer components and menus of getting the PQA's from the host to the W/S within the practically set operational (technical) standards.
  • An example of such a sequence of PQA's can be separate short, walk through segments of PQA's for several house models not yet built and stored in combination with changing other descriptive, financial and related community traffic pattern information for a large new development.
  • the updatable marketing information segment is advantageous by recombinable with the WORM graphics.

Abstract

Procédé et appareil de recherche rapide et d'affichage conjoint de données graphiques et tabulaires à la fois pour les systèmes d'ordinateur locaux (10) et pour les systèmes distribués (20). Ledit procédé choisit rapidement et affiche (12) des informations associées sous forme de graphiques et de texte grâce à une interface d'utilisateur graphique (GUI) à partir d'une base de données relationnelles graphiques (GRDB) et une base de données tabulaires importante. L'opérateur pose une question, et des éléments graphiques mémorisés et préalablement codés sont choisis grâce à un programme de contrôle dans une mémoire de masse (22) et affichées (12) avec les données de texte associées sur un affichage local (12). Ledit procédé permet une sélection et un affichage (12) intelligents des données graphiques basés sur une analyse effectuée par le système (10) des éléments ou images requis pour répondre à la question posé par l'opérateur, et de la manière dont lesdits éléments doivent être affichés (12) avec les données tabulaires (ou de texte) associées.
PCT/US1990/007334 1989-12-13 1990-12-13 Procede et appareil de stockage, de transmission et de recuperation de donnees graphiques et tabulaires WO1991009368A1 (fr)

Applications Claiming Priority (8)

Application Number Priority Date Filing Date Title
US450,606 1989-12-13
US07/450,606 US5179652A (en) 1989-12-13 1989-12-13 Method and apparatus for storing, transmitting and retrieving graphical and tabular data
US49411590A 1990-03-14 1990-03-14
US494,115 1990-03-14
US52171490A 1990-05-09 1990-05-09
US521,714 1990-05-09
US07/544,826 US5185857A (en) 1989-12-13 1990-06-27 Method and apparatus for multi-optional processing, storing, transmitting and retrieving graphical and tabular data in a mobile transportation distributable and/or networkable communications and/or data processing system
US544,826 1990-06-27

Publications (1)

Publication Number Publication Date
WO1991009368A1 true WO1991009368A1 (fr) 1991-06-27

Family

ID=27503980

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US1990/007334 WO1991009368A1 (fr) 1989-12-13 1990-12-13 Procede et appareil de stockage, de transmission et de recuperation de donnees graphiques et tabulaires

Country Status (4)

Country Link
EP (1) EP0506842A4 (fr)
AU (1) AU7157791A (fr)
CA (1) CA2071814A1 (fr)
WO (1) WO1991009368A1 (fr)

Cited By (6)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5325297A (en) * 1992-06-25 1994-06-28 System Of Multiple-Colored Images For Internationally Listed Estates, Inc. Computer implemented method and system for storing and retrieving textual data and compressed image data
EP0860784A2 (fr) * 1997-02-19 1998-08-26 Casio Computer Co., Ltd. Processeur d'informations pour recouvrement d'information de type conseil
EP0870252A1 (fr) * 1995-11-03 1998-10-14 Sterling Commerce Inc. Reseau a valeur ajoutee a methode d'acces multiples
US6615207B1 (en) * 1998-12-10 2003-09-02 International Business Machines Corporation Method of formulating and presenting search queries to a tabular database through a user-interactive computer display interface
US7797740B2 (en) 2006-01-06 2010-09-14 Nokia Corporation System and method for managing captured content
CN113656005A (zh) * 2021-06-29 2021-11-16 杭州华橙软件技术有限公司 应用组件库构建方法、应用组件配置方法及相关装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4723211A (en) * 1984-08-30 1988-02-02 International Business Machines Corp. Editing of a superblock data structure
US4739477A (en) * 1984-08-30 1988-04-19 International Business Machines Corp. Implicit creation of a superblock data structure
US4764867A (en) * 1986-06-03 1988-08-16 Banner Blue Software Incorporated Display system and method for constructing and editing a hierarchical arrangement of information
US4949248A (en) * 1988-07-15 1990-08-14 Caro Marshall A System for shared remote access of multiple application programs executing in one or more computers

Family Cites Families (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
JP2795857B2 (ja) * 1987-11-06 1998-09-10 ゼロックスコーポレーション ハイパーメディアシステムにおける埋め込まれたリファレンスを管理及び編集するためのサーバに基づいた設備

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US4723211A (en) * 1984-08-30 1988-02-02 International Business Machines Corp. Editing of a superblock data structure
US4739477A (en) * 1984-08-30 1988-04-19 International Business Machines Corp. Implicit creation of a superblock data structure
US4764867A (en) * 1986-06-03 1988-08-16 Banner Blue Software Incorporated Display system and method for constructing and editing a hierarchical arrangement of information
US4949248A (en) * 1988-07-15 1990-08-14 Caro Marshall A System for shared remote access of multiple application programs executing in one or more computers

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of EP0506842A4 *

Cited By (10)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5325297A (en) * 1992-06-25 1994-06-28 System Of Multiple-Colored Images For Internationally Listed Estates, Inc. Computer implemented method and system for storing and retrieving textual data and compressed image data
EP0870252A1 (fr) * 1995-11-03 1998-10-14 Sterling Commerce Inc. Reseau a valeur ajoutee a methode d'acces multiples
EP0870252A4 (fr) * 1995-11-03 1999-01-27 Sterling Commerce Inc Reseau a valeur ajoutee a methode d'acces multiples
EP0860784A2 (fr) * 1997-02-19 1998-08-26 Casio Computer Co., Ltd. Processeur d'informations pour recouvrement d'information de type conseil
EP0860784A3 (fr) * 1997-02-19 1998-11-25 Casio Computer Co., Ltd. Processeur d'informations pour recouvrement d'information de type conseil
US6026400A (en) * 1997-02-19 2000-02-15 Casio Computer Co., Ltd. Information processors which provide advice information, and recording mediums
US6615207B1 (en) * 1998-12-10 2003-09-02 International Business Machines Corporation Method of formulating and presenting search queries to a tabular database through a user-interactive computer display interface
US7797740B2 (en) 2006-01-06 2010-09-14 Nokia Corporation System and method for managing captured content
CN113656005A (zh) * 2021-06-29 2021-11-16 杭州华橙软件技术有限公司 应用组件库构建方法、应用组件配置方法及相关装置
CN113656005B (zh) * 2021-06-29 2023-11-24 杭州华橙软件技术有限公司 应用组件库构建方法、应用组件配置方法及相关装置

Also Published As

Publication number Publication date
CA2071814A1 (fr) 1991-06-14
EP0506842A4 (en) 1993-09-01
EP0506842A1 (fr) 1992-10-07
AU7157791A (en) 1991-07-18

Similar Documents

Publication Publication Date Title
US5185857A (en) Method and apparatus for multi-optional processing, storing, transmitting and retrieving graphical and tabular data in a mobile transportation distributable and/or networkable communications and/or data processing system
US5713019A (en) Iconic access to remote electronic monochrome raster data format document repository
US6157935A (en) Remote data access and management system
US5754242A (en) Data formatting system for processing multiple independent input data streams for high resolution screen displays
US7424679B1 (en) Patient data information system
JP2010172005A (ja) サーバ及び通信端末装置
CN109684435B (zh) 去专业化多源异构时空地理数据集成系统及方法
WO1991009368A1 (fr) Procede et appareil de stockage, de transmission et de recuperation de donnees graphiques et tabulaires
JP2003006198A (ja) 画像処理装置およびその方法、並びに、サーバ装置
US7340675B1 (en) System and method for creating web pages with word processing templates
US5465327A (en) Method and system for document administration utilizing iconic representations within a data processing system
JP2004038840A (ja) メモ画像管理装置、メモ画像管理システムおよびメモ画像管理方法
JPH09507595A (ja) 家庭用銀行業務システム
JP3609778B2 (ja) 双方向通信ネットワークによる医療情報提供・取得システム及び方法並びにコンピュータプログラム
JP2679972B2 (ja) 情報サービス処理方法
JPH08147445A (ja) 文書管理方法及びそれを実現する文書処理装置
GB2353615A (en) Selecting items such as data files
JPH0962687A (ja) 情報処理装置および情報提供システム
US20130218895A1 (en) Method and Apparatuses for Selectively Accessing Data Elements in a Data Library
JPH1022949A (ja) 文字放送情報の構成方法および文字放送情報ビューワー装置
Martinez et al. Remote consultation and diagnosis in medical imaging using a global PACS backbone network
JP2007087426A (ja) 通信端末装置
McGarty et al. Multimedia communications: architectural alternatives
Koval et al. MediLink: a wearable telemedicine system for emergency and mobile applications
Hahn The committee support system

Legal Events

Date Code Title Description
AK Designated states

Kind code of ref document: A1

Designated state(s): AU BR CA HU JP KR RO SU

AL Designated countries for regional patents

Kind code of ref document: A1

Designated state(s): AT BE CH DE DK ES FR GB GR IT LU NL SE

COP Corrected version of pamphlet

Free format text: PAGES 1/19-19/19,DRAWINGS,REPLACED BY NEW PAGES 1/21-21/21;DUE TO LATE TRANSMITTAL BY THE RECEIVING OFFICE

WWE Wipo information: entry into national phase

Ref document number: 2071814

Country of ref document: CA

WWE Wipo information: entry into national phase

Ref document number: 1991902355

Country of ref document: EP

WWP Wipo information: published in national office

Ref document number: 1991902355

Country of ref document: EP

WWW Wipo information: withdrawn in national office

Ref document number: 1991902355

Country of ref document: EP