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

Relation type data base system and its search and report method

A database and relational technology, applied in the direction of electrical digital data processing, special data processing applications, instruments, etc., can solve the problems of heavy development workload and poor scalability, and achieve the effect of less development work, flexibility and application

Inactive Publication Date: 2005-03-02
HUNDSUN TECH
View PDF0 Cites 60 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0013] When the system is applied to the data center, there are some defects: First, the main feature of the system is that it adopts a hard-coded form to meet the needs of a certain business, and realizes various query and report requirements through program codes, such as the definition of reports It is implemented by program code (the conditions and results of the report can be written in the program code), so the development workload is heavy; and the scalability is poor. If the definition of the report needs to be modified, it must be realized by modifying the program code and recompiling. Implementation suitable for specific business

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
  • Relation type data base system and its search and report method
  • Relation type data base system and its search and report method
  • Relation type data base system and its search and report method

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0055] The invention fully considers the characteristics of the data center, thereby better realizing the construction of the data center and the realization of query and report. From the perspective of data, there are two main characteristics of the data center: one is that the data is centralized, and the data comes from different business systems; the other is that the data remains in its original state without cleaning. Therefore, the present invention uses the data center to store centralized original data, and uses the metadata database to store the description for the original data, thereby separating the realization of the business from the query and the report, and only the data center and the metadata database will be triggered when modifying or adding new business data. The change of the data will not affect other nodes too much; in addition, the middleware server is used to realize the effective separation of the data center and the report server; the invention also...

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 relation-type data base system of the present invention includes data center for storing data object; metadata base for storing metadata; client sides; report server connected to the client sides; and intermediate server connected to the data center, the metadata base and the report server. The inquiry and report process includes the client side to input inquiry and report request, the report server to send metadata inquiry request, for the intermediate server to obtain metadata from the metadata base, for the report server to send metadata to the client side, for the client to input inquiring and report condition based on the metadata, for the report server to create command, for the intermediate server to execute the command in the data center and to return result to the report server, for the report server to store the result and return it to the client side, and for the client to show the result.

Description

technical field [0001] The invention relates to data storage and processing technology, in particular to a relational database system and its query and reporting methods. Background technique [0002] Database technology has been widely used in various management information systems and has become the basis of decision support systems and expert systems. Especially relational database system (RDBMS, Relation DataBase System) has been paid more and more attention. [0003] Relational database systems are based on the relational model of data, and store, process and manage database information according to custom relationships. Usually, a relational database contains a large amount of data information. However, in practical applications, not all data information is required, but some data information meeting certain conditions is required. At this time, qualified data information can be retrieved through query. In addition, the calculation, classification, summary and sortin...

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 HUNDSUN TECH
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