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

Visual inquiry method for spatial database

A query method and database technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve problems such as difficult to manipulate database systems

Inactive Publication Date: 2009-09-16
JIANGSU UNIV
View PDF0 Cites 2 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

And these users who are not familiar with the database programming language, it is difficult to operate the work of a database system alone.

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Visual inquiry method for spatial database
  • Visual inquiry method for spatial database
  • Visual inquiry method for spatial database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment 1

[0038] A visual query method, the method includes the following steps:

[0039] 1) Create a card, which is represented by card name, image, type and parameters, such as figure 1 shown. There are three types of cards: user-defined cards representing entities, system-defined cards representing spatial relationships, and system-defined cards representing query operations.

[0040] 2) Establish card base, grammar base and knowledge base with the card as the basic unit.

[0041] The card library is used to store the above cards; the card library C consists of two subsets: C=C u ∪C s

[0042] Here C u ={Card object |Card=(X m , X i ,OBJECT,X p )∈C}, that is, the card representing the entity defined by the user.

[0043] Cs={Card system |Card=(X m , X i , PROCESS, X p )∈C}, that is, a card defined by the system that represents a spatial relationship or a query operation.

[0044] The grammar library is a collection of the grammars of the computer card query language us...

Embodiment 2

[0076] In this embodiment, the user wants to understand the oil well situation in the "DETALLE-DR-COSS" project, and the visualization query program is as follows:

[0077] Clear the existing CQL instructions in the buffer and wait for the user to input new query instructions.

[0078] The user finds the "Oil Well" card in the physical card area of ​​the card library and selects the card. The user queries all information about the "Oil Well" without giving parameter values. Then, the user selects the "Oil Well" card to activate and put it into the BOX 1 . "Oil Well" card added to BOX 1 in, such as Figure 6 shown.

[0079] Then, define the query scope, that is, where to query for "oil well". The user searches for the object card "PROJECT" in the card library, selects it, adds the parameter "DETALLE-DR-COSS", activates the "PROJECT" card, and places it in the BOX 2 in, such as Figure 7 shown.

[0080] When defining the query mode, the user searches for a suitable operat...

Embodiment 3

[0089] In this embodiment the user wants to know which oil wells and villages are in the project DETALLE-DR-COSS. The difference from the above example is that the compiled visual query program is: put the operation card "INSIDE_OF" in the BOX 3 ; in BOX 1 Place two entity object cards "OIL_WELL" and "POPULATION" in; at the same time, in BOX 2 Place the abstract object card "PROJECT" in , and give it the parameter "proj_name=DETALLE_DR_COSS".

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The invention relates to a visual inquiry method for a spatial database, and aims to provide an inquiry method with strong universality, high visual degree and convenient operation. The method comprises the following steps: establishing cards which are expressed by card names, images, types and parameters and comprise three types, namely a card defined by a user and presenting an entity, a card defined by a system and presenting a spatial relation, and a card defined by the system and presenting research operation; establishing a card base, a grammar set and a knowledge base set; displaying the cards of three types in the card base by a card menu respectively; programming a card search program by using a card search language programmer consisting of a search machine and the cards, namely a program for inquiring object information in the spatial database; performing the inquiry program; and outputting inquiry results.

Description

technical field [0001] The invention applies the visualization method to the query interface of the spatial database system, thereby making it convenient for non-computer professionals to query GIS and other application databases. It belongs to the interdisciplinary technical field of computer graphics and database science. Background technique [0002] As database applications have penetrated into various fields of society, many non-computer professional users, such as a GIS system user is often a civil engineer, and most of them have not received programming training in SQL language. And these users who are not familiar with the database programming language can hardly manipulate the work of a database system alone. In order to effectively solve this problem, visualization technology can be used as a major auxiliary means, especially using visual language to manipulate database systems or query database information. [0003] Scientific computing visualization is a new ed...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F17/30
Inventor 鞠时光金华
Owner JIANGSU UNIV
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Patsnap Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Patsnap Eureka Blog
Learn More
PatSnap group products