Eureka AIR delivers breakthrough ideas for toughest innovation challenges, trusted by R&D personnel around the world.

Database system and a method of data retrieval from the system

a database and system technology, applied in the field of database systems and data retrieval methods, can solve the problems of difficult for users to recognize all these facts and retrieve accurate information, and it is difficult for users to search the db system. to achieve the effect of easy search of the db system

Inactive Publication Date: 2005-04-07
NSSOL
View PDF4 Cites 20 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

The present invention provides a mechanism for easily searching a database system built by distributing one or more databases and one or more first servers for searching the databases. The mechanism allows the user to easily search for real data without needing to connect to the distributed databases and first servers. The metadata management means collects and manages metadata that pertain to real data stored in the databases, and the metadata retrieval means extracts metadata that matches a user's retrieval request. The system also allows the user to input a retrieval condition and transfer it to the first server as a retrieval request. The invention also provides a data retrieval method and a recording medium that records a computer program for implementing the invention. The technical effects of the invention include efficient search without the need for immediate connectivity to the distributed databases and servers, easy retrieval of real data from metadata, and the ability to search for real data by inputting a retrieval condition.

Problems solved by technology

When desired information is read out from such distributed DBs, it requires very much time and labor to search all servers that manage these DBs for required information.
More specifically, since the user does not know the location of information to be read out in the distributed DBs, he or she must access servers allocated in correspondence with these DBs in turn and must repeat search until he or she finds desired information.
It is impossible to retrieve required information from all the servers unless the user knows the locations (address information such as URL: Uniform Resource Locator) of all DB servers.
However, the distributed DB servers constantly register or delete data, and each DB server itself is constantly connected to or disconnected from the network.
Hence, it is very hard for the user to recognize all these facts and to retrieve accurate information.
However, the search engine can only retrieve the URL information of a DB server, but cannot search an RDBMS (relational DB management system) built in the server at that retrieved URL.
In this way, conventionally, upon acquiring desired data, when DBs that store various kinds of data are distributed, data retrieval requires much time and labor.
Furthermore, in the RDBMS, the maximum number of columns that can be held in one table is normally limited.
However, when such DB having a plurality of real tables A, B, and C is searched for given data, the following problem is posed.
Such processing prolongs the DB search time, and requires a more memory area of the computer that forms the system than required, resulting in low search performance.
However, since the number of columns is also limited on a view provided by an RDBMS as in a real table, a long view cannot be formed beyond the physical limitation.

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
  • Database system and a method of data retrieval from the system
  • Database system and a method of data retrieval from the system
  • Database system and a method of data retrieval from the system

Examples

Experimental program
Comparison scheme
Effect test

first embodiment

[0065]FIG. 2 is a schematic block diagram showing the arrangement of a database system according to the first embodiment, and FIG. 3 is a block diagram showing software and hardware images of the database search system.

[0066] Referring to FIG. 2, reference numeral 10 denotes a user terminal which is installed with a WWW (World Wide Web) browser 11, and which inputs a keyword for search, issues a retrieval request, displays a retrieval result, and so forth on the WWW browser 11. A search for a meta DB (to be described later) or for real data is designated on this WWW browser 11. The WWW browser 11 comprises a GUI module 11a and retrieval request transfer module 11b, as shown in FIG. 3, allows the user to make various operations for search using the GUI module 11a, and transfers a retrieval request signal using the retrieval request transfer module 11b.

[0067] Reference numeral 20 denotes a database (DB) which stores actual data. At least one DB 20 is present on the network. A platfo...

second embodiment

[0127] The second embodiment of the present invention will be described below with reference to the accompanying drawings.

[0128]FIG. 9 is a block diagram showing an example of the arrangement of a database system according to this embodiment. The database system of this embodiment shown in FIG. 9 can be used alone or may be combined with the first embodiment shown in FIG. 2.

[0129] The combination with the first embodiment can be implemented when the DB server 30 shown in FIG. 2 comprises functional blocks bounded by the one-dashed chain line in FIG. 9 other than the database 20. On the other hand, the DB server 30 in FIG. 2 may comprise only a search engine 60 and joined table generation means 65 shown in FIG. 9, and the meta DB server 40 may comprise a metadata management means 69 and metadata storage means 70 shown in FIG. 9.

[0130] When the database system of this embodiment is combined with the first embodiment, in metadata to be used, other joinable DB names (JOINABLE) are ad...

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

Since metadata pertaining to real data stored in at least one database (DB) are collected and managed at a single meta DB server, and metadata that match a retrieval request are extracted by search of the meta DB server, even when a plurality of DBs and DB servers for managing DBs are present on a network, all metadata that match the retrieval request can be extracted independently of which DBs metadata pertain to. Hence, all data that match a retrieval request can be obtained from a single server independently of the actual locations of the distributed DBs and DB servers.

Description

BACKGROUND OF THE INVENTION [0001] 1. Field of the Invention [0002] The present invention relates to a database system, data retrieval method, and storage medium and, more particularly, to a technique suitably used in a retrieval system that finds out desired data from a plurality of distributed databases. [0003] 2. Description of the Related Art [0004] As the performance of computers becomes higher in recent years, a large-scale computer such as a single main frame or the like has been replaced by a distributed system built by a plurality of workstations or personal computers in recent years. The distributed system makes development and maintenance of the system relatively easy. As an example of the distributed system, the so-called Internet is known. [0005] In the Internet, a plurality of computers are distributed worldwide as servers or clients, and construct a single, huge database (to be abbreviated as a DB hereinafter). Text information, image information, and the like are reg...

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(United States)
IPC IPC(8): G06F7/00G06F17/30
CPCG06F17/30864Y10S707/99931Y10S707/99945Y10S707/99936Y10S707/99933Y10S707/99943G06F16/951G06F16/907
Inventor KOJIMA, KAZUHITOYOSHIKURA, MITSURUUESUGI, HIROMOTO
Owner NSSOL
Who we serve
  • R&D Engineer
  • R&D Manager
  • IP Professional
Why Eureka
  • Industry Leading Data Capabilities
  • Powerful AI technology
  • Patent DNA Extraction
Social media
Eureka Blog
Learn More
PatSnap group products