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

Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system

a data warehouse and query processing technology, applied in database management systems, data processing applications, instruments, etc., can solve the problems of high cost of processing those many queries, reduce the dependency of query processing on the network, reduce the load of each server, and shorten the response time

Inactive Publication Date: 2006-11-09
NISHIZAWA ITARU +3
View PDF21 Cites 24 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Benefits of technology

This approach reduces server load, query processing time, network load, storage capacity, and updating costs, while improving the hit ratio of replicas and enabling efficient data sharing among clients, thus enhancing the overall efficiency of data warehouse systems in distributed environments.

Problems solved by technology

To achieve this third object, query processings in the server are avoided especially to prevent the server from an increase of the load to be caused by accesses from many clients and management of a mass of data, which result in high costs for processing those many queries.

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
  • Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system
  • Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system
  • Data warehouse system and query processing method used in the system, and data collecting method and apparatus for the method, and charging method and apparatus in the system

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0043]FIG. 1 shows a preferred embodiment of a data warehouse system in accordance with the present invention. Clients 103 and 104 are connected to a data collector 1 (101) via an infra-network 128.

[0044] The intra-network 128 may be a local area network (LAN) connected through the Ethernet, optical fibers, and an FDDI. The clients 103 and 104 may be any computer systems such as personal computers including the Hitachi FLOPA, and Hitachi 3050 creative work stations. The data collector 1 includes a client management unit 105 which groups and manages a plurality of clients and accepts replica creation requests and queries from the clients and transfers replica creation requests to a replica creation request analysis unit 106 and queries to a query analysis unit 109; a replica creation request analysis unit 106 which decides whether to create a replica actually in response to a replica creation request from a client, then transfers the replica description, which is information related...

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

In order to realize a practical data warehouse system with the use of a network in a distributed environment, for example, data collectors for creating / managing each replica of server data for clients shown in FIG. 1 are connected to a network. A data collector holds a data request condition given from a user via a client and negotiates with a server which supplies data according to such resources as a storage unit, a CPU, etc., usable by the data collector, thereby the range and quality of the data for which a replica is to be created can be adjusted. For query processing, a part or the whole of a query from a client is processed with the use of a replica created in the data collector. Queries which cannot be processed with any replica in the data collector are transferred to the server. Because a replica created in the data collector can be used to process a query from a client in such a way, the server load can be reduced.

Description

[0001] The present application is a continuation of application Ser. No. 09 / 435,034, filed Nov. 9, 1999, the contents of which are incorporated herein by reference.BACKGROUND OF THE INVENTION [0002] The present invention relates to a data warehouse system of the type used in a distributed network computing environment (hereafter, to be referred to as a distributed environment) and a method for processing queries in the system; as well as, a method and an apparatus for collecting data for the query processings, and a method and an apparatus for charging each of the queries. [0003] Now that lower cost computing systems have become widespread, highly reliable software programs have been developed for those systems, and more efficient social systems have been in demand to cope with such systems and programs, various types of information can be used on-line. For example, various business data including sales information of shops, products management information, and customers' informatio...

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): G06F17/30G06F12/00G06F15/00
CPCG06F17/30433Y10S707/99952G06F17/30575G06F17/30557G06F16/27G06F16/25G06F16/24524
Inventor NISHIZAWA, ITARUFUJIWARA, SHINJIUSHIJIMA, KAZUTOMOINOHARA, SHIGEKAZU
Owner NISHIZAWA ITARU
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

Browse by: Latest US Patents, China's latest patents, Technical Efficacy Thesaurus, Application Domain, Technology Topic, Popular Technical Reports.

© 2024 PatSnap. All rights reserved.Legal|Privacy policy|Modern Slavery Act Transparency Statement|Sitemap|About US| Contact US: help@patsnap.com