CN106484894A - A kind of multilist associated data exhibiting method based on relevant database and system - Google Patents
A kind of multilist associated data exhibiting method based on relevant database and system Download PDFInfo
- Publication number
- CN106484894A CN106484894A CN201610915632.XA CN201610915632A CN106484894A CN 106484894 A CN106484894 A CN 106484894A CN 201610915632 A CN201610915632 A CN 201610915632A CN 106484894 A CN106484894 A CN 106484894A
- Authority
- CN
- China
- Prior art keywords
- module
- data
- qlikview
- col
- multilist
- Prior art date
- Legal status (The legal status is an assumption and is not a legal conclusion. Google has not performed a legal analysis and makes no representation as to the accuracy of the status listed.)
- Granted
Links
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/26—Visual data mining; Browsing structured data
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/22—Indexing; Data structures therefor; Storage structures
- G06F16/2282—Tablespace storage structures; Management thereof
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
- G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
- G06F16/28—Databases characterised by their database models, e.g. relational or object models
- G06F16/284—Relational databases
Landscapes
- Engineering & Computer Science (AREA)
- Databases & Information Systems (AREA)
- Theoretical Computer Science (AREA)
- Data Mining & Analysis (AREA)
- Physics & Mathematics (AREA)
- General Engineering & Computer Science (AREA)
- General Physics & Mathematics (AREA)
- Software Systems (AREA)
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
A kind of multilist associated data exhibiting method based on relevant database, means are represented as the front end of the multilist associated data of relevant database using QlikView form, the each detail list comprising external key of the same name is not attached operate, but they are loaded into QlikView as back-end data to be associated, finally carry out multilist associated data by QlikView field relatedness and represent.By each detail list on the premise of not changing external key content to be associated, collect in advance, be re-used as back-end data and be loaded into；Now, QlikView will carry out relevance to each table of same file-name field, can get correct cohersive and integrated data.
Description
Technical field
The present invention relates to business intelligence, the analysis of public opinion field, produce redundant recording for relevant database multi-table join
Situation propose a kind of processing method.In particular to a kind of multilist associated data side of representing based on relevant database
Method and device.
Background technology
With the fast development of internet economy, increasing user tends to be disappeared by e-commerce platform
Take.Correspondingly, the data message being produced based on electric business platform, business intelligence field starts to show up prominently.The key of business intelligence
Be to extract useful data being cleared up from different operation informations, to ensure data correctness, then pass through to extract, conversion and
Loading process, obtains the global view of a business data, is analyzed using suitable query analysis instrument on this basis
Process, knowledge is presented to manager, provide for decision making process and support.The main flow relational data that business intelligence field is adopted
There are Oracle, DB2, Microsoft SQL Server, Microsoft Access, MySQL etc. in storehouse, and the front end being adopted represents
Instrument has QlikView, Tableau etc..
A new station safety net is domestic B2C the Internet insurance industry pioneer, and it is unexpected that its insurance products covers traffic/synthesis
Dangerous, domestic/overseas travelling danger, health insurance, group danger, family property insurance, shipping danger, financing danger, vehicle insurance, life insurance, product blame danger etc.
10 insurance kinds, the platform that places an order includes PC end, touch screen end, mobile phone A PP end, has formed stable customer group and ecosphere, deep tool analysis
It is worth.Thus the present invention relies on a new station safety net demonstration implementation result.
In oracle database, if Table A external key col_fk and table B external key col_fk all comprises repetition values, by Table A and B
When connecting by external key col_fk, no matter adopt left outside connection, the right side is outer to be connected or interior connection, all can produce redundant recording.To existing
Problem with the presence of technology is exemplified below：
Table 1 sales promotion information table promotion_info, external key order_id comprise repetition values
| cal_number | activity_id | activity_name | order_id | order_plat |
| 20150914 | 2408 | Place an order and send integration | 150914310611 | Official website |
| 20150914 | 2571 | Integration deduction cash | 150914310611 | Official website |
| 20150914 | 2979 | Place an order to stand and subtract 8% | 150914310611 | Official website |
Table 2 sequence information table policy_order_info, external key order_id comprise repetition values
The Query Result (only listing part field) that table 3 comprises redundant recording
Table 4 20150914 cohersive and integrated data (only lists part field), and several indexs all are repeated to add up
| cal_number | price | cut_amt | pts_amt | points |
| 20150914 | 306.00 | 24.48 | 7.80 | 258 |
Table 1 records advertising campaign effective date, movable ID, activity name, order ID and the platform that places an order.1 order in table 1
Take part in 3 kinds of advertising campaigns.
Table 2 records declaration form ID, product IDs, the declaration form amount of money, discount amount, the integration deduction amount of money, integration, insurance kind, order ID.
In table 2,1 order comprises 7 declaration forms, and every declaration form corresponds to 1 section of insurance products.
Now, no matter left join, right join, inner join are adopted, by table 1, table 2 passes through order_id word
Section connects, and all can return 21 Query Results comprising redundant recording, such as table 3, and each policy_id has more 2 redundant recordings.
If 20150914 same day data are collected based on table 3, the accumulative declaration form amount of money, discount amount, integration deduction can be repeated
The amount of money, the index such as integration, such as table 4.As back-end data, QlikView front end just cannot show correct sales promotion information.
The present invention prepares back-end data by oracle database, represents means using QlikView form as front end, carries
Go out a kind of multilist associated data exhibiting method based on relevant database and device.
Content of the invention
The present invention seeks to, overcome existing QlikView form as front end represent during means more have the inquiry of redundant recording
Result；The present invention prepares back-end data by oracle database, represents means using QlikView form as front end, proposes one
Plant the multilist associated data exhibiting method based on relevant database and device.
Technical solution of the present invention：A kind of multilist associated data exhibiting method based on relevant database and system, with
QlikView form represents means as the front end of the multilist associated data of relevant database, (all has to comprising external key of the same name
Repetition values) each detail list be not attached operating, but they are loaded into QlikView as back-end data to be associated,
Carry out multilist associated data by QlikView field relatedness eventually to represent.
It should be noted that in order to mitigate QlikView field association burden, each detail list is treated not changing by the present invention
On the premise of association external key content, collect in advance, be re-used as back-end data and be loaded into；Now, QlikView is by same file-name field
Each table carries out relevance, can get correct cohersive and integrated data.
Step is as follows：
Step 1. integrates out the backstage detail list comprising external key col_fk of the same name in oracle database；
Step 11. integrates out the detail list 1 comprising col_fk, remembers Table A, and wherein col_fk has repetition values；
Step 12. integrates out the detail list 2 comprising col_fk, remembers that table B, wherein col_fk have repetition values；
Step 2., on the premise of not changing col_fk content, detail list is collected；
Step 21. retains col_fk content, and Table A is collected, and remembers table C；
Step 22. retains col_fk content, and table B is collected, and remembers table D；
By table C, table D is loaded into QlikView front end as back-end data it is ensured that table C, table D external key to be associated col_ for step 3.
Fk title is consistent, and QlikView will carry out relevance to each table comprising same file-name field；
Step 4. designs QlikView module, and by table C, table D Data Integration can collect to the varigrained overall situation for one
View, represents just data.
Equally, multiple detail lists pass through that QlikView is interrelated also to be retained external key content to be associated and converge each table in advance
Always, it is re-used as back-end data and is loaded into QlikView, finally carry out multilist associated data by QlikView field relatedness and represent.
Beneficial outcomes of the present invention are as follows：Multilist external key (the comprising repetition values) related question representing for business intelligence data
One kind concisely reliable solution is provided, finally can generate one and can collect to varigrained global view, just represent
Exact figures evidence.The present invention prepares back-end data by oracle database, represents means using QlikView form as front end,
QlikView will carry out relevance to each table of same file-name field, can get correct cohersive and integrated data.
Brief description
Fig. 1 is multilist associated data exhibiting method flow chart；
Fig. 2 is multilist associated data demonstration device structural representation.
Specific embodiment
Below in conjunction with drawings and Examples, it is specifically described embodiment of the present invention.Described embodiment is merely illustrative, base
In the substantive change made of the technology of the present invention or equivalent variations, still fall within the scope of the present invention.
Refering to shown in Fig. 1, embodiment of the present invention flow process is as follows：
Step 11. integrates sales promotion, sequence information, generates sales promotion information table promotion_info in oracle database
And declaration form sequence information table policy_order_info, the detailed data conduct of screening order_id=150914310611
Embodiment, i.e. table 1, table 2；Wherein, table 1, the order_id field of table 2 all has repetition values；
Step 12., on the premise of not changing order_id field contents, detail list is collected.Table 1 need not collect, table 2
Retain order_id information, with product IDs as dimension, each policy_id is collected for declaration form number, and the corresponding amount of money that adds up, generate
Table 5；
By table 1, table 5 is loaded into QlikView front end as back-end data it is ensured that table 1, the order_id word of table 5 for step 13.
Name section is consistent；
Step 14. designs module, generates by QlikView field relatedness and can collect to varigrained global view,
Represent just data, such as table 6, table 7, table 8 etc., is the data collecting according to different demands.
The data that table 5 is collected by table 2
Table 6 QlikView front end 20150914 cohersive and integrated data (only listing part field)
| cal_number | price | cut_amt | pts_amt | points |
| 20150914 | 102.00 | 7.71 | 2.60 | 86 |
Table 7 QlikView front end places an order and send integration summary of activity data (only listing part field)
Table 8 QlikView front end home journey insurance cohersive and integrated data (only listing part field)
Refering to shown in Fig. 2, embodiment of the present invention apparatus structure is as follows：
Module 1:Data source unit, the new station safety net detail transaction record of this module stores, including product information, order
Information, promotional offer information etc., provide data for subsequent module.
Module 2:Data pre-processing unit, this module integrates out each detail comprising external key of the same name in oracle database
Table, and under the premise of retaining foreign key information, each detail list is collected.
Module 3:QlikView data loading unit, Oracle back-end data is loaded into QlikView front end by this module, carries
Fashionable guarantee each summary sheet external key to be associated title is consistent.
Module 4:QlikView data display unit, this module is generated using QlikView field relatedness and can collect to not
The global view of one-size, each input selecting module of arranging in pairs or groups, multi-angle represents just data；
Module 41:Date selection module, this module can be according to day, week, the moon, season, year any switching laws, selected different time
Scope；
Module 42:Activity selecting module, this module can select reward voucher, full subtract, discount, integration deduction, many multiplicatrixs grade
The advertising campaign of type；
Module 43:Insurance kind selecting module, this module can select the insurance products of the insurance kinds such as family property insurance, financing danger, vehicle insurance；
Module 44:Place an order platform selecting module, and this module can select the modes that place an order such as PC end, touch screen end, mobile phone A PP end.
Those of ordinary skill in the art should be understood：The foregoing is only the specific embodiment of the present invention, and
It is not used in the restriction present invention, all any modification, equivalent substitution and improvement within the spirit and principles in the present invention, done etc., all
Should be included within protection scope of the present invention.
Claims (5)
1. a kind of multilist associated data exhibiting method based on relevant database, is characterized in that using QlikView form as pass
It is that the front end of the multilist associated data of type data base represents means, each detail list comprising external key of the same name is not attached grasp
Make, but they are loaded into QlikView as back-end data to be associated, finally carry out by QlikView field relatedness
Multilist associated data represents.
2. multilist associated data exhibiting method according to claim 1, is characterized in that waiting to close not changing by each detail list
On the premise of connection external key content, collect in advance, be re-used as back-end data and be loaded into；Now, QlikView will be each to same file-name field
Table carries out relevance, can get correct cohersive and integrated data.
3. multilist associated data exhibiting method according to claim 2, is characterized in that step is as follows：
Step 1. integrates out the backstage detail list comprising external key col_fk of the same name in oracle database；
Step 11. integrates out the detail list 1 comprising col_fk, remembers Table A, and wherein col_fk has repetition values；
Step 12. integrates out the detail list 2 comprising col_fk, remembers that table B, wherein col_fk have repetition values；
Step 2., on the premise of not changing col_fk content, detail list is collected；
Step 21. retains col_fk content, and Table A is collected, and remembers table C；
Step 22. retains col_fk content, and table B is collected, and remembers table D；
By table C, table D is loaded into QlikView front end as back-end data it is ensured that table C, table D external key to be associated col_fk name for step 3.
Claim consistent, QlikView will carry out relevance to each table comprising same file-name field；
Step 4. designs QlikView module, and by table C, table D Data Integration can collect to varigrained global view for one,
Represent just data.
4. multilist associated data exhibiting method according to claim 2, is characterized in that multiple detail lists pass through QlikView
Interrelated also retain external key content to be associated each table collected in advance, be re-used as back-end data and be loaded into QlikView, finally borrow
Help QlikView field relatedness to carry out multilist associated data to represent.
5. the multilist associated data exhibiting method composition based on relevant database according to one of claim 1-4 is
System, is characterized in that, including module 1-4, the structure of module 1-4 is as follows with function：
Module 1:Data source unit, the new station safety net detail transaction record of this module stores, including product information, order is believed
Breath, promotional offer information etc., provide data for subsequent module；
Module 2:Data pre-processing unit, this module integrates out each detail list comprising external key of the same name in oracle database,
And under the premise of retaining foreign key information, each detail list is collected；
Module 3:QlikView data loading unit, Oracle back-end data is loaded into QlikView front end by this module, during loading
Ensure that each summary sheet external key to be associated title is consistent；
Module 4:QlikView data display unit, this module includes submodule 41-44；Using the life of QlikView field relatedness
One-tenth can collect to varigrained global view, each input selecting module of arranging in pairs or groups, and multi-angle represents just data；
Module 41:Date selection module, this module can be according to day, week, the moon, season, year any switching laws, selected different time model
Enclose；
Module 42:Activity selecting module, this module can select reward voucher, full subtract, discount, integration deduction, many multiplicatrixs grade type
Advertising campaign；
Module 43:Insurance kind selecting module, this module can select the insurance products of the insurance kinds such as family property insurance, financing danger, vehicle insurance；
Module 44:Place an order platform selecting module, mode that this module can select PC end, touch screen end, mobile phone A PP end place an order.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610915632.XA CN106484894B (en) | 2016-10-20 | 2016-10-20 | A kind of multilist associated data based on relevant database shows method and system |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201610915632.XA CN106484894B (en) | 2016-10-20 | 2016-10-20 | A kind of multilist associated data based on relevant database shows method and system |
Publications (2)
| Publication Number | Publication Date |
|---|---|
| CN106484894A true CN106484894A (en) | 2017-03-08 |
| CN106484894B CN106484894B (en) | 2018-07-06 |
Family
ID=58270305
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201610915632.XA Active CN106484894B (en) | 2016-10-20 | 2016-10-20 | A kind of multilist associated data based on relevant database shows method and system |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN106484894B (en) |
Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060149705A1 (en) * | 2005-01-04 | 2006-07-06 | International Business Machines Corporation | Methods, systems, and computer program products for relating data in healthcare databases |
| CN101359324A (en) * | 2007-08-02 | 2009-02-04 | 上海宝信软件股份有限公司 | Data access method of oracle relational database based on procedure call interface |
| US20130275476A1 (en) * | 2012-04-12 | 2013-10-17 | International Business Machines Corporation | Managing record location lookup caching in a relational database |
| US20140108467A1 (en) * | 2012-10-15 | 2014-04-17 | Qliktech International Ab | Methods And Systems For Data Management |
| EP2846269A1 (en) * | 2013-09-10 | 2015-03-11 | Value Lab S.r.l. | Connector for a BI (Business Intelligence) platform |
-
2016
- 2016-10-20 CN CN201610915632.XA patent/CN106484894B/en active Active
Patent Citations (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| US20060149705A1 (en) * | 2005-01-04 | 2006-07-06 | International Business Machines Corporation | Methods, systems, and computer program products for relating data in healthcare databases |
| CN101359324A (en) * | 2007-08-02 | 2009-02-04 | 上海宝信软件股份有限公司 | Data access method of oracle relational database based on procedure call interface |
| US20130275476A1 (en) * | 2012-04-12 | 2013-10-17 | International Business Machines Corporation | Managing record location lookup caching in a relational database |
| US20140108467A1 (en) * | 2012-10-15 | 2014-04-17 | Qliktech International Ab | Methods And Systems For Data Management |
| EP2846269A1 (en) * | 2013-09-10 | 2015-03-11 | Value Lab S.r.l. | Connector for a BI (Business Intelligence) platform |
Also Published As
| Publication number | Publication date |
|---|---|
| CN106484894B (en) | 2018-07-06 |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| US8412820B2 (en) | Referred internet traffic analysis system and method | |
| US11868411B1 (en) | Techniques for compiling and presenting query results | |
| Mou et al. | Understanding the topics of export cross-border e-commerce consumers feedback: an LDA approach | |
| Wang et al. | Database submission—market dynamics and user-generated content about tablet computers | |
| WO2022006135A1 (en) | Artificial intelligence for keyword recommendation | |
| Arthur | Studying the UK job market during the COVID-19 crisis with online job ads | |
| Feld et al. | Peer reviewed: how to conduct store observations of tobacco marketing and products | |
| Ebrahimi et al. | A customer loyalty model for e-commerce recommendation systems | |
| CN111538733A (en) | Multidimensional data comprehensive analysis system and analysis method thereof | |
| Giabbanelli et al. | Feasibility and framing of interventions based on public support: leveraging text analytics for policymakers | |
| CN101276450A (en) | Information processing device, information processing method and information processing program | |
| Pedersen et al. | Locating medical and recreational cannabis outlets for research purposes: online methods and observational study | |
| Schulze et al. | Digital dashboards visualizing public health data: a systematic review | |
| CN103425705B (en) | The acquisition methods and device and searching method and device of a kind of negative keyword | |
| US8751309B2 (en) | Targeted communication between promoters and consumers | |
| US20090144222A1 (en) | Chart generator for searching research data | |
| US10140578B1 (en) | System and method for managing social-based questions and answers | |
| CN112507241A (en) | Vehicle type recommendation method, system, medium and electronic device for obtaining vehicle type recommendation list | |
| CN106484894B (en) | A kind of multilist associated data based on relevant database shows method and system | |
| JP6320353B2 (en) | Digital marketing system | |
| US20090144243A1 (en) | User interface for searching research data | |
| US20090144317A1 (en) | Data search markup language for searching research data | |
| Pesch | Usage Factor for Journals: A New Measure for Scholarly Impact: Edited by Oliver Pesch | |
| CA2708415C (en) | Referred internet traffic analysis system and method | |
| Shokoohyar et al. | Impact of COVID-19 outbreak and vaccination on ride-sharing services: a social media analysis |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| C06 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| GR01 | Patent grant | ||
| GR01 | Patent grant |