Unlock instant, AI-driven research and patent intelligence for your innovation.

A method and system for displaying multi-table associated data based on a relational database

A technology of linked data and database, applied in relational database, database model, visual data mining and other directions, can solve the problem of unable to display promotion information

Active Publication Date: 2018-07-06
XINYIZHAN INSURANCE AGENT CO LTD
View PDF5 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

Using this as the background data, the front end of QlikView cannot display the correct promotional information

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
  • A method and system for displaying multi-table associated data based on a relational database
  • A method and system for displaying multi-table associated data based on a relational database
  • A method and system for displaying multi-table associated data based on a relational database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0035] The embodiments of the present invention will be described in detail below in conjunction with the accompanying drawings and examples. The described embodiments are only examples, and changes based on the technical essence of the present invention or equivalent changes still fall within the protection scope of the present invention.

[0036] refer to figure 1 As shown, the process of the embodiment of the present invention is as follows:

[0037] Step 11. integrate promotion, order information, generate promotion information table promotion_info and insurance policy order information table policy_order_info in the oracle database, filter the detailed data of order_id=150914310611 as an embodiment, namely Table 1, Table 2; Wherein, Table 1, Table 2 The order_id field has duplicate values;

[0038] Step 12. Summarize the detailed table without changing the content of the order_id field. Table 1 does not need to be summarized. Table 2 retains the order_id information, ...

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 provides a multilist associated data exhibition method based on a relational database. According to the method, a QlikView report serves as a front-end exhibition tool of multilist associated data of the relational database, no connection operation is conducted to all detail reports containing foreign keys with the same names, the detail reports containing the foreign keys with the same names are used as to-be-associated background data and loaded into the QlikView, and finally multilist associated data exhibition is conducted by means of the QlikView field relatedness. On the premise that the to-be-associated foreign key content is not changed, all the detail reports are aggregated in advance and then used as the background data to be loaded. Meanwhile, content association is conducted to all the reports with fields with the same names through the QlikView, and correct aggregated data can be obtained.

Description

technical field [0001] The invention relates to the fields of business intelligence and public opinion analysis, and proposes a processing method for redundant records generated by multi-table connections of relational databases. Specifically, it relates to a method and device for presenting multi-table associated data based on a relational database. Background technique [0002] With the rapid development of the Internet economy, more and more users tend to consume through e-commerce platforms. Correspondingly, based on the data information generated by the e-commerce platform, the field of business intelligence has begun to emerge. The key to business intelligence is to extract and clean useful data from different operational information to ensure the correctness of the data, and then obtain a global view of enterprise data through the process of extraction, conversion and loading, and use appropriate query analysis tools on this basis Perform analytical processing, pres...

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 Patents(China)
IPC IPC(8): G06F17/30
CPCG06F16/2282G06F16/26G06F16/284
Inventor 王旻毅郝亮徐丽萍
Owner XINYIZHAN INSURANCE AGENT CO LTD