CN107784520A - A kind of airline's marketing data integration system and method - Google Patents
A kind of airline's marketing data integration system and method Download PDFInfo
- Publication number
- CN107784520A CN107784520A CN201710963622.8A CN201710963622A CN107784520A CN 107784520 A CN107784520 A CN 107784520A CN 201710963622 A CN201710963622 A CN 201710963622A CN 107784520 A CN107784520 A CN 107784520A
- Authority
- CN
- China
- Prior art keywords
- data
- aviation
- mark
- marketing
- airline
- 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.)
- Pending
Links
- 230000010354 integration Effects 0.000 title claims abstract description 32
- 238000000034 method Methods 0.000 title claims abstract description 21
- 238000004519 manufacturing process Methods 0.000 claims abstract description 33
- 238000013499 data model Methods 0.000 claims abstract description 9
- 238000000605 extraction Methods 0.000 claims abstract description 5
- 230000019771 cognition Effects 0.000 claims description 12
- 238000002372 labelling Methods 0.000 claims description 7
- 230000002452 interceptive effect Effects 0.000 claims description 6
- 238000007726 management method Methods 0.000 claims description 6
- 238000005065 mining Methods 0.000 claims description 6
- 238000013179 statistical model Methods 0.000 claims description 6
- 238000010586 diagram Methods 0.000 description 17
- 238000004458 analytical method Methods 0.000 description 9
- 238000012216 screening Methods 0.000 description 5
- 239000000203 mixture Substances 0.000 description 4
- 230000008569 process Effects 0.000 description 4
- 238000012800 visualization Methods 0.000 description 4
- BYACHAOCSIPLCM-UHFFFAOYSA-N 2-[2-[bis(2-hydroxyethyl)amino]ethyl-(2-hydroxyethyl)amino]ethanol Chemical group OCCN(CCO)CCN(CCO)CCO BYACHAOCSIPLCM-UHFFFAOYSA-N 0.000 description 3
- 230000008859 change Effects 0.000 description 3
- 238000007405 data analysis Methods 0.000 description 3
- 238000011161 development Methods 0.000 description 3
- 238000005516 engineering process Methods 0.000 description 3
- 239000000284 extract Substances 0.000 description 3
- 230000006872 improvement Effects 0.000 description 3
- 230000009471 action Effects 0.000 description 2
- 230000000739 chaotic effect Effects 0.000 description 2
- 230000009286 beneficial effect Effects 0.000 description 1
- 238000004364 calculation method Methods 0.000 description 1
- 238000004140 cleaning Methods 0.000 description 1
- 238000012790 confirmation Methods 0.000 description 1
- 238000010276 construction Methods 0.000 description 1
- 238000005520 cutting process Methods 0.000 description 1
- 238000007418 data mining Methods 0.000 description 1
- 230000003247 decreasing effect Effects 0.000 description 1
- 230000007812 deficiency Effects 0.000 description 1
- 238000013461 design Methods 0.000 description 1
- 238000009826 distribution Methods 0.000 description 1
- 230000009977 dual effect Effects 0.000 description 1
- 238000011156 evaluation Methods 0.000 description 1
- 239000011295 pitch Substances 0.000 description 1
- 230000007704 transition Effects 0.000 description 1
- 230000000007 visual effect Effects 0.000 description 1
Classifications
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q30/00—Commerce
- G06Q30/02—Marketing; Price estimation or determination; Fundraising
- G06Q30/0201—Market modelling; Market analysis; Collecting market 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/24—Querying
- G06F16/245—Query processing
- G06F16/2458—Special types of queries, e.g. statistical queries, fuzzy queries or distributed queries
- G06F16/2465—Query processing support for facilitating data mining operations in structured databases
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06Q—INFORMATION AND COMMUNICATION TECHNOLOGY [ICT] SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES; SYSTEMS OR METHODS SPECIALLY ADAPTED FOR ADMINISTRATIVE, COMMERCIAL, FINANCIAL, MANAGERIAL OR SUPERVISORY PURPOSES, NOT OTHERWISE PROVIDED FOR
- G06Q50/00—Information and communication technology [ICT] specially adapted for implementation of business processes of specific business sectors, e.g. utilities or tourism
- G06Q50/40—Business processes related to the transportation industry
-
- G—PHYSICS
- G06—COMPUTING; CALCULATING OR COUNTING
- G06F—ELECTRIC DIGITAL DATA PROCESSING
- G06F2216/00—Indexing scheme relating to additional aspects of information retrieval not explicitly covered by G06F16/00 and subgroups
- G06F2216/03—Data mining
Landscapes
- Engineering & Computer Science (AREA)
- Business, Economics & Management (AREA)
- Theoretical Computer Science (AREA)
- Physics & Mathematics (AREA)
- Strategic Management (AREA)
- Accounting & Taxation (AREA)
- Development Economics (AREA)
- Finance (AREA)
- General Physics & Mathematics (AREA)
- Economics (AREA)
- Entrepreneurship & Innovation (AREA)
- Data Mining & Analysis (AREA)
- General Business, Economics & Management (AREA)
- Databases & Information Systems (AREA)
- Marketing (AREA)
- Probability & Statistics with Applications (AREA)
- Fuzzy Systems (AREA)
- Mathematical Physics (AREA)
- Management, Administration, Business Operations System, And Electronic Commerce (AREA)
- Software Systems (AREA)
- Computational Linguistics (AREA)
- General Engineering & Computer Science (AREA)
- Health & Medical Sciences (AREA)
- General Health & Medical Sciences (AREA)
- Human Resources & Organizations (AREA)
- Primary Health Care (AREA)
- Tourism & Hospitality (AREA)
- Game Theory and Decision Science (AREA)
Abstract
The present invention relates to a kind of airline's marketing data integration system and method, including：Aviation marketing mark module, for establishing basic data, includes validating that client, channel, the bottom data relation of product；Aviation marketing data Integrated Models, the business core index for mark module extraction multi-data source of being marketed according to aviation, establish the Data Integration model that can be used for supporting application layer；Aviation marketing data views module, on the basis of aviation marketing data Integrated Models, provided in application and meet service logic and be easy and fast to read show view, bottom data model is used for actual production work.Technical scheme provided by the invention solves multi-source data access hardly possible, sees the problems such as number is difficult, data bore is unified difficult, each level personnel of aviation marketing domain are helped quickly to judge the mass of foundation of data, the core index performance of itself, and the relevant issues seen clearly module and be quickly found out product, client, channel in marketing established by this model.
Description
Technical field
The present invention relates to marketing data integration technology, and in particular to a kind of airline's marketing data integration system and side
Method.
Background technology
Aircraft industry is always maintained at growing at top speed, and airline is in transport power input, it is more powerful to be shown in the developing of course line
Power.In recent years, as the new aircraft of a large amount of inputs of airline is runed.The severity aggravation of market competition.
The marketing of air ticket turns into the important process content of airline.
In air ticket marketing domain, be broadly divided at present airline oneself sale direct selling channel and agent sale
Distribution channel.With procuratorial technological progress, airline sells directly to households in sale of ticket field and is in weak tendency.To change this office
Face, airline is also in ceaselessly upgrade technique, it is established that oneself advanced sale of ticket system.
Increasingly refined in the sale in future, in the case of being increasingly inclined to technological means online sales.Airline pair
The data analysis of air ticket marketing increases attention dynamics.And under the scene of data analysis, what is faced is past high speed development band
The sequelae come：Multisystem is simultaneously deposited, and data source header is more, and quality is uneven.Data silo phenomenon is serious, and data deficiency is effectively controlled
Reason, various analysis templates are simultaneously deposited, and various analysis reports are at random.Need to take a significant amount of time energy for decision-making and disappear to understand
Change the content of data analysis, cause that the efficiency of decision-making is low, cost is high.
The content of the invention
In view of the shortcomings of the prior art, it is an object of the invention to provide a kind of airline's marketing data integration system and side
Method, the foundation of marketing data Integrated Models in the present invention solve that multi-source data access is difficult, seeing number, difficult, data bore unifies difficulty etc.
Problem, each level personnel of aviation marketing domain are helped quickly to judge the mass of foundation of data, the core index of itself is completed
Situation, and the relevant issues seen clearly module and be quickly found out product, client, channel in marketing established by this model.
The purpose of the present invention is realized using following technical proposals：
The present invention provides a kind of airline's marketing data integration system, and it is theed improvement is that, including：
Aviation marketing mark module, for establishing basic data, include validating that client, channel, the bottom data of product close
System；
Aviation marketing data Integrated Models, being marketed according to aviation, (multi-data source refers to mark module extraction multi-data source
In aviation business process, data caused by different production IT systems corresponding to different business, such as sale of ticket business are corresponding
Sale of ticket system caused by the original account data of sale of ticket.Initial data has all detailed indexs that business needs,
But classification and arrangement not Jing Guo index, it not can be directly used for analyzing, the action of extraction is based on entering initial data
Row classification and arrangement, while only extract business core index.) business core index, establish can be used for support application layer number
According to Integrated Models；
Aviation marketing data views module, on the basis of aviation marketing data Integrated Models, being provided in application
Meet service logic and be easy and fast to read show view, aviation marketing data Integrated Models is used for actual production work
Make.
Further, the aviation marketing mark module includes：
Air passenger labeling submodule, identification (this is associated for generating air passenger mark, including by multi-data source
What the operations such as the index for having logical relation being identified by different system is combined, duplicate removal were formed, be by data
Storehouse aspect is associated what is realized in systems, it can be understood as system carries.Citing：Such as name of passenger, in sale of ticket system
All exist in system, airport check-in system, the meaning of mark is to determine that the name of passenger of two systems can be done just by algorithm
True association) go out some passenger and confirm the mark of its uniqueness；
Aeronautical product labeling submodule, produced for generating aeronautical product mark, including to multi-data source association identification
The division of product least unit, there is provided the least unit and unique mark of aeronautical product；
Aviation Sales Channel labeling submodule, associated for generating aviation Sales Channel mark, including by multi-data source
Identify the corresponding relation between unit of drawing a bill, ticket system number, check drawer, ticket-buyer, least unit distinguish to check drawer and
Ticket-buyer, there is provided check drawer identifies and ticket-buyer's mark；
Submodule is associated, for air passenger to be identified, aeronautical product identifies and aviation Sales Channel mark is associated
(these three marks are to establish corresponding relation by one group of original index to generate in itself first, original corresponding to three marks
In index, comprising this index of leg, 3 marks herein are connected to become by leg index by marketing mark, this battalion
It is least unit to sell mark), generate the leg with time marking in corresponding mark.
Further, the air passenger is identified as：Name+type of credential+passport NO.+mobile device number+access IP
Address；
The aeronautical product is identified as：Auditing system production number+air ticket production number+other business voucher production number+products
Price；
Aviation Sales Channel is identified as：World boat association certification coding+seat reservation system work account+perfect instrument type+card
Piece number code+name.
Further, the aviation marketing data Integrated Models include：
Aircraft index of correlation, time, international boat association industry data, check-in index, reservation record index, customer account management system
System, clearing Origin And Destination data and air ticket clearing index.
Further, the aviation marketing data views module includes：
Identify view submodule, for show airline business indicator discrimination establish to data (including client know
(formula is not that the leg with product identification is removed for rate (formula is the leg with customer ID divided by total leg number), product identification rate
Using total leg number), channel discrimination (formula is the leg with channel mark divided by total leg number), marketing mark discrimination it is (public
Formula is the leg with marketing mark divided by total leg number), it is the multi-source characteristic based on integral data in itself to establish identification module
Determine, under different analysis dimensions and screening conditions, data discrimination has very big difference, therefore is confirmed by identifying view
The quality of data of integral index, it is a very important step to carry out availability assessment.) availability the assessment page；The operation
Index discrimination includes client's discrimination, product identification rate, channel discrimination and marketing mark discrimination；
View submodule is recognized, for the data (trip of core index Xiang Zhi airlines to airline's core index item
The defeated core index item of passenger traffic, this is a series of indexs based on the production and operation index of airline, including flight seat
Digit, flight number of passengers, flight passenger income, flight passenger pre-capita consumption, saloon passenger number, business class passenger people
Number, flight membership etc..In the case where judging integral data quality, cognition view submodule is set up based on operational indicator
Cognition module, help business quickly to recognize the index performance under the conditions of certain by cognition module.The calculating of index is this
Issue evidence/base data * 100, when can further speed up business by index and checking, to the cognition speed for situation of marketing.) tracking
The interactive interface with index is established, helps user quickly to recognize in specified time scope, the scope of business and the completion of business
State；
See clearly view submodule, for according to establish client, channel, product Back ground Information establish statistical model to excavate
The potential value of data.
The present invention also provides a kind of airline's marketing data integration method, and it is theed improvement is that, including：
Basic data is established, includes validating that client, channel, the bottom data relation of product；
The business core index of multi-data source is extracted according to aviation marketing mark module, establishes and can be used for supporting application layer
Data Integration model；
On the basis of aviation marketing data Integrated Models, meet service logic in application offer and be easy and fast to read
Show view, bottom data model is used for actual production work.
Further, it is described to establish basic data, client, channel, the bottom data relation of product are included validating that, including：
Air passenger mark is generated, including some passenger is identified by multi-data source association and confirms that its is unique
The mark of property；
Aeronautical product mark is generated, including the division that identification carries out product least unit is associated to multi-data source, there is provided boat
The least unit and unique mark of empty product；
Aviation Sales Channel mark is generated, including unit of drawing a bill, ticket system number are identified by multi-data source association, gone out
Corresponding relation between ticket people, ticket-buyer, least unit are distinguished and arrive check drawer and ticket-buyer, there is provided check drawer identifies and ticket-buyer
Mark；
Air passenger is identified, aeronautical product mark and aviation Sales Channel mark are associated, generate in corresponding mark
Leg with time marking.
Further, the air passenger is identified as：Name+type of credential+passport NO.+mobile device number+access IP
Address；
The aeronautical product is identified as：Auditing system production number+air ticket production number+other business voucher production number+products
Price；
Aviation Sales Channel is identified as：World boat association certification coding+seat reservation system work account+perfect instrument type+card
Piece number code+name.
Further, the aviation marketing data Integrated Models include：
Aircraft index of correlation, time, international boat association industry data, check-in index, reservation record index, customer account management system
System, clearing Origin And Destination data and air ticket clearing index.
Further, it is described on the basis of aviation marketing data Integrated Models, provided in application and meet service logic
And be easy and fast to read shows view, bottom data model is used for actual production work, including：
Show that the business indicator discrimination of airline establishes the assessment page to availability of data；
Interactive interface with index is established to the data tracking of airline's core index item, helps user quickly to recognize
In specified time scope, the scope of business and business completion status；
According to establish client, channel, product Back ground Information establish statistical model come the potential value of mining data.
Compared with immediate prior art, the beneficial effect that technical scheme provided by the invention reaches is：
Data with existing of this model based on airline is carried out, and data are completed from be incorporated into should by scientific modeling
Overall process, avoid airline because data bore disunity, define it is unintelligible caused by business it is chaotic, pass through simultaneously
Data mining can be that important supporting role is played in the marketing of airline to precision transition, avoid airline from voluntarily exploring
Produce substantial amounts of exploration cost.
Brief description of the drawings
In order to illustrate more clearly about the embodiment of the present invention or technical scheme of the prior art, below will be to embodiment or existing
There is the required accompanying drawing used in technology description to be briefly described, it should be apparent that, drawings in the following description are only this
Some embodiments of invention, for those of ordinary skill in the art, on the premise of not paying creative work, can be with
Other accompanying drawings are obtained according to these accompanying drawings.
Fig. 1 is air passenger mark module schematic diagram；
Fig. 2 is aeronautical product mark module schematic diagram；
Fig. 3 is aviation Sales Channel mark module schematic diagram；
Fig. 4 is aviation marketing mark schematic diagram；
Fig. 5 is aviation marketing data Integrated Models schematic diagram；
Fig. 6 is identification view interface schematic diagram, wherein：(a) it is voyage, (b) takes in for frequent flight passenger, and (c) is direct selling channel
Income, (d) take in for two cabins, and (e) is big connection journey income, and (f) takes in for big customer, and (g) identifies for the age, and (h) knows for sex
Not, (i) identifies to be international；
Fig. 7 is cognition view interface schematic diagram, wherein：(a) for this year course line, (b) be this year flight, (c) be this year with
Last year passenger-kilometer number contrasts, and (d) is income income in this year, and (e) takes in for two cabins, and (f) is connection journey income, and (g) receives to sell directly to households
Enter, (h) takes in for frequent flight passenger, and (i) takes in for Protocol Client；
Fig. 8 is to see clearly view interface schematic diagram, wherein：(a) it is overall passenger's primary attribute, (b) is gender analysis, (c)
For Analysis of age, (d) analyzes for native place；
Fig. 9 is a point group model division schematic diagram.
Embodiment
To make the object, technical solutions and advantages of the present invention clearer, technical scheme will be carried out below
Detailed description.Obviously, described embodiment is only part of the embodiment of the present invention, rather than whole embodiments.Base
Embodiment in the present invention, those of ordinary skill in the art are resulting on the premise of creative work is not made to be owned
Other embodiment, belong to the scope that the present invention is protected.
The present invention relates to term be explained as follows：
The quality of data：Refer to the ratio between the data available and dirty data generated after data acquisition and parsing.
Index index：(index radix ÷ indexs contrast phase radix) × 100
Transport power：The ability of transporting passengers.Usual airline is surveyed with the seating capacity that aircraft is put into flying distance
Calculate.
It is available for seat-kilometer：Reflect the index of transport flight passenger traffic carrying capacity；Calculation formula is：It is available for seat * boat pitches
From.
Embodiment one,
The present invention provides a kind of airline's marketing data integration system, is divided into：Aviation marketing mark module, aviation marketing
Data Integration model, aviation marketing data views module three parts composition.Market to identify by aviation and establish basis, confirm visitor
Family, channel, the bottom data relation of product；The connection of core business index is carried out by aviation marketing data Integrated Models, is led to
The dual connection of direct relation and indirect relation is crossed, completes the construction of overall aviation marketing data Integrated Models.Pass through model, energy
Most of business demand is covered, and changes business and constantly puies forward demand, Data duplication association, to repeat inquiry, bore chaotic
Present situation；By aviation marketing data view, provided on the basis of aviation marketing data Integrated Models in application and meet business
Logic and be easy and fast to read show view, bottom data model is used for actual production work, avoid data model
Stay in form and can not support to produce.
(1) aviation marketing mark module：
Establish air passenger mark, aeronautical product mark, aviation Sales Channel and identify three block identifications, referred to afterwards by core
Mark leg identifies to form aviation marketing mark to associate three groups.This model relies primarily on multi-data source integral data warehouse and carried out in fact
Existing, dependence type database is associated.Multi-data source is referred in aviation business process, different raw corresponding to different business
Produce data caused by IT system, such as original of sale of ticket caused by sale of ticket system corresponding to sale of ticket business
Account data.Initial data has all detailed indexs that business needs, but does not have the classification and arrangement Jing Guo index, and can not
Analysis is directly used in, the action of extraction is based on that initial data is classified and arranged, while only extracts business core index.
Air passenger mark module schematic diagram is as shown in Figure 1.
Air passenger is identified by multi-data source association and identifies some passenger and confirm the mark of its uniqueness
Know.Fig. 1 illustrates the primary information resource of passenger's mark and forms the relational model of passenger's mark.Because airline is used for
The production system of business with having more set systems supports according to passenger ticket buying and the difference for seizing the opportunity flow, therefore between each system typing trip
There is data deviation in row information, air passenger identifies the different information for cleaning same passenger between each system, makes same
Passenger is scattered in the Data Integrations of different production systems to same passenger.Most of airline has oneself
Book tickets marketing system, check-in confirmation system, membership management system, and the model is based on airline's Major Systems design.
Aeronautical product is identified by the division that multiple data origin carries out product least unit, has realized the mark to product
Know.Aeronautical product mark is as shown in Figure 2.Fig. 2 illustrates the primary information resource of product identification and the composition mould of product identification
Type.Product approval system of the main information of aeronautical product mark inside airline, it will be produced when product examination ＆ approval pass through
Production code member.There is the examination ＆ approval of other service products in airline in addition to air ticket, therefore has the examination ＆ approval of air ticket product and other products letter
Two class sources of breath examination ＆ approval.In addition to source is examined, it is also necessary to used by ticket information, other business voucher information to obtain product
Information, to set up the corresponding relation of aviation marketing examination ＆ approval and sale.The foundation identified by aeronautical product, it have found aviation production
The least unit and unique designation of product, basis is established for Product evaluation.
Aviation Sales Channel mark module schematic diagram is as shown in Figure 3.
Aviation Sales Channel is identified by multi-data source association and identifies unit of drawing a bill, ticket system number, check drawer, purchase
Corresponding relation between ticket people, least unit are distinguished to check drawer, ticket-buyer to realize the mark of channel.Upper figure illustrates channel
The composition model of the primary information resource of mark channel mark.According to selling directly to households and distributing, the information source cutting of channel is
Sell directly to households and distribute.Ticket-buyer refers to the true client for paying air ticket money simultaneously.Check drawer refers to carries out behavior of drawing a bill for ticket-buyer
It is personal.Ticket-buyer and check drawer there may be a variety of relations, therefore channel mark is actual two groups of marks, check drawer's mark and purchase
Ticket people identifies.
Aviation marketing mark schematic diagram is as shown in Figure 4.
Aviation marketing mark is associated again on the basis of three classes mark, and core index is the band time in corresponding mark
The leg of mark.Top illustrates the composition model of aviation marketing mark.The mark built by the key element connected in three marketing
Know and be used for bottom data, airline's marketing mark finds product, passenger, channel three set up the least unit of relation.
This is just avoided bore and the disunity of definition from the bottom, and premise is created for Data Integration model.
(2) aviation marketing data Integrated Models
Aviation marketing data Integrated Models are on the premise of possessing marketing mark, by referring to the business core of multi-data source
Target extracts, it is established that available for the Data Integration model for supporting foreground application layer.The model comes from aviation by each data and sought
The direct relation and indirect relation that pin mark is established are associated.Final realize can cover most of business demands, but unlikely
In the bottom data model for excessively consuming resource, being mainly characterized by of the model finds optimal shape in business demand and data volume
State, it is that basis is established in the application of application layer, the primary structure of the model is as shown in Figure 5.
This model relies primarily on relevant database realization, to be associated on the basis of possessing data warehouse, otherwise
Will be to needing to realize that the data source integrated carries out structuring arrangement and merged to store.Production system can not be directly acted on, it is no
Greatly burden can be then produced to production system, influences to produce.Such as：Own website will be caused by acting on the own website of airline
Performance is decreased obviously, and causes passenger ticket buying to go wrong.
(3) aviation marketing data view
Aviation marketing data view is mainly used in that Data Integration model is presented, and it is daily underlying model data is used for
In marketing work.It is broadly divided into four parts：Identification view, recognize view, see clearly view.This part is in Data Integration model
It is present on the basis of data warehouse or correspondence database, by visualization tool, such as TABLEAU, POWERBI instrument is carried out
View is developed, and the result of bottom data is made dynamic and visual interface by view exploitation.
By showing, the business indicator discrimination of core can use identification view to set up to data for airline
Property the assessment page, and the page by screening washer can high flexible inquire about.Identify view interface schematic diagram such as Fig. 6 (a)-(i)
It is shown.Including client's discrimination, (formula is that the leg with customer ID is removed to the business indicator discrimination of core for airline
Using total leg number), product identification rate (formula is the leg with product identification divided by total leg number), (formula is channel discrimination
Leg with channel mark divided by total leg number), marketing mark discrimination (formula be band marketing identify leg divided by total leg
Number), it is that the multi-source characteristic based on integral data in itself determines to establish identification module, different analysis dimensions and screening conditions
Under, data discrimination has very big difference, therefore confirms the quality of data of integral index by identifying view, carries out availability
Assessment is a very important step.
Cognition view sets up a set of interactive interface with index by the data tracking of airline's core index item,
User can be helped quickly to recognize in specified time scope and the scope of business, the completion status of business.Recognize view interface schematic diagram
As shown in Fig. 7 (a)-(i).The core index item of core index Xiang Zhi airlines passenger transport, this is the life with airline
Produce a series of indexs based on operation indicator, including airline seat number, flight number of passengers, flight passenger income, flight trip
Objective pre-capita consumption, saloon passenger number, business class number of passengers, flight membership etc..Judging integral data quality
In the case of, cognition view submodule sets up the cognition module based on operational indicator, helps business quickly to recognize by cognition module
Know the index performance under the conditions of certain.The calculating of index is current period data/base data * 100, can further be added by index
When fast business is checked, to the cognition speed for situation of marketing.
See clearly view by establish client, channel, product Back ground Information and establish statistical model come the latent of mining data
It is being worth.Method carries out a point group by sixteen rules, grouping result is entered afterwards to establish Pareto diagram to marketing mark first
Row is disassembled, and disassembles client's dimension, channel peacekeeping product dimension respectively.A point group is carried out to these three dimensions respectively again.Grouping method is still
It is so Pareto diagram.The main purpose of this Part Development is the core value of mining data, and has one to can be used for producing
Actual model carries out business support.Complete marketing mark and related three dimensions divide group identification after.Pass through screening
Device can make identification and cognition interface carry out data syn-chronization by freely choosing the method for mark, so as to show that business can manage quickly
The analysis of the crowd of solution.Back ground Information analysis is as shown in Fig. 8 (a)-(d).
Group model is divided to divide schematic diagram as shown in figure 9, having chosen index and the calculating of X-Y axles first by visualization tool
Mode, figure then is produced by calculating, then the method by drawing boost line by various dimensions to figure carries out a point group, to dividing
Group's result carries out forming label and is put into screening washer.
Marketing labeling algorithm model is done by airline's bottom data warehouse or database, then has the basis of label
On carry out Data Integration again.Visualization view is made by front end visualization tool after the completion of integration.The use of this model can make
Carried out with the mode of iterative development, without being once fully completed, progress that can stage by stage step by step is with corresponding different airlines
Different data Environment controls.
Embodiment two,
The present invention also provides a kind of airline's marketing data integration method, and it is theed improvement is that, including：
Basic data is established, includes validating that client, channel, the bottom data relation of product；
The business core index of multi-data source is extracted according to aviation marketing mark module, establishes and can be used for supporting application layer
Data Integration model；
On the basis of aviation marketing data Integrated Models, meet service logic in application offer and be easy and fast to read
Show view, bottom data model is used for actual production work.
Further, it is described to establish basic data, client, channel, the bottom data relation of product are included validating that, including：
Air passenger mark is generated, including some passenger is identified by multi-data source association and confirms that its is unique
The mark of property；
Aeronautical product mark is generated, including the division that identification carries out product least unit is associated to multi-data source, there is provided boat
The least unit and unique mark of empty product；
Aviation Sales Channel mark is generated, including unit of drawing a bill, ticket system number are identified by multi-data source association, gone out
Corresponding relation between ticket people, ticket-buyer, least unit are distinguished and arrive check drawer and ticket-buyer, there is provided check drawer identifies and ticket-buyer
Mark；
Air passenger is identified, aeronautical product mark and aviation Sales Channel mark are associated, generate in corresponding mark
Leg with time marking.
Further, the air passenger is identified as：Name+type of credential+passport NO.+mobile device number+access IP
Address；
The aeronautical product is identified as：Auditing system production number+air ticket production number+other business voucher production number+products
Price；
Aviation Sales Channel is identified as：World boat association certification coding+seat reservation system work account+perfect instrument type+card
Piece number code+name.
Further, the aviation marketing data Integrated Models include：
Aircraft index of correlation, time, international boat association industry data, check-in index, reservation record index, customer account management system
System, clearing Origin And Destination data and air ticket clearing index.
Further, it is described on the basis of aviation marketing data Integrated Models, provided in application and meet service logic
And be easy and fast to read shows view, bottom data model is used for actual production work, including：
Show that the business indicator discrimination of airline establishes the assessment page to availability of data；
Interactive interface with index is established to the data tracking of airline's core index item, helps user quickly to recognize
In specified time scope, the scope of business and business completion status；
According to establish client, channel, product Back ground Information establish statistical model come the potential value of mining data.
The present invention solves multi-source data access hardly possible, sees the problems such as number is difficult, data bore is unified difficult, helps aviation marketing domain
Each level personnel can quickly judge the mass of foundation of data, the core index performance of itself, and built by this model
Vertical module of seeing clearly is quickly found out product, client, the relevant issues of channel in marketing.
The foregoing is only a specific embodiment of the invention, but protection scope of the present invention is not limited thereto, any
Those familiar with the art the invention discloses technical scope in, change or replacement can be readily occurred in, should all be contained
Cover within protection scope of the present invention.Therefore, protection scope of the present invention should be based on the protection scope of the described claims.
Claims (10)
- A kind of 1. airline's marketing data integration system, it is characterised in that including：Aviation marketing mark module, for establishing basic data, includes validating that client, channel, the bottom data relation of product；Aviation marketing data Integrated Models, the business core index for mark module extraction multi-data source of being marketed according to aviation, are established Available for the Data Integration model for supporting application layer；Aviation marketing data views module, on the basis of aviation marketing data Integrated Models, providing and meeting in application Service logic and be easy and fast to read show view, aviation marketing data Integrated Models is used for actual production work.
- 2. airline's marketing data integration system as claimed in claim 1, it is characterised in that the aviation marketing mark mould Block includes：Air passenger labeling submodule, some is identified for generating air passenger mark, including by multi-data source association Passenger and the mark for confirming its uniqueness；Aeronautical product labeling submodule, for generating aeronautical product mark, including identification is associated to multi-data source and carries out product most The division of subsection, there is provided the least unit and unique mark of aeronautical product；Aviation Sales Channel labeling submodule, for generating aviation Sales Channel mark, including associated and identified by multi-data source The corresponding relation drawn a bill between unit, ticket system number, check drawer, ticket-buyer, least unit are distinguished and arrive check drawer and booking People, there is provided check drawer identifies and ticket-buyer's mark；Submodule is associated, for air passenger to be identified, aeronautical product identifies and aviation Sales Channel mark is associated, and generates Leg with time marking in corresponding mark.
- 3. airline's marketing data integration system as claimed in claim 2, it is characterised in that the air passenger mark For：Name+type of credential+passport NO.+mobile device number+access IP address；The aeronautical product is identified as：Auditing system production number+air ticket production number+other business voucher production number+product prices；Aviation Sales Channel is identified as：World boat association certification coding+seat reservation system work account+perfect instrument type+certificate number Code+name.
- 4. airline's marketing data integration system as claimed in claim 3, it is characterised in that the aviation marketing data is whole Matched moulds type includes：Aircraft index of correlation, time, international boat association industry data, check-in index, reservation record index, client management system, knot Count and a little settle accounts index with endpoint data and air ticket.
- 5. airline's marketing data integration system as claimed in claim 4, it is characterised in that the aviation marketing data regards Module includes：View submodule is identified, for showing that the business indicator discrimination of airline establishes the assessment page to availability of data Face；The business indicator discrimination includes client's discrimination, product identification rate, channel discrimination and marketing mark discrimination；View submodule is recognized, for establishing the interactive interface with index to the data tracking of airline's core index item, User is helped quickly to recognize in specified time scope, the scope of business and the completion status of business；See clearly view submodule, for according to establish client, channel, product Back ground Information establish statistical model come mining data Potential value.
- A kind of 6. airline's marketing data integration method, it is characterised in that including：Basic data is established, includes validating that client, channel, the bottom data relation of product；The business core index of multi-data source is extracted according to aviation marketing mark module, establishes the data that can be used for supporting application layer Integrated Models；On the basis of aviation marketing data Integrated Models, the exhibition for meeting service logic and being easy and fast to read is provided in application Existing view, enables bottom data model to be used for actual production work.
- 7. airline's marketing data integration method as claimed in claim 6, it is characterised in that it is described to establish basic data, Client, channel, the bottom data relation of product are included validating that, including：Air passenger mark is generated, including some passenger is identified by multi-data source association and confirms its uniqueness Mark；Aeronautical product mark is generated, including the division that identification carries out product least unit is associated to multi-data source, there is provided aviation is produced The least unit and unique mark of product；Aviation Sales Channel mark is generated, including unit of drawing a bill, ticket system number are identified by multi-data source association, drawn a bill Corresponding relation between people, ticket-buyer, least unit are distinguished and arrive check drawer and ticket-buyer, there is provided check drawer identifies and ticket-buyer's mark Know；Air passenger is identified, aeronautical product mark and aviation Sales Channel mark are associated, when generating band in corresponding mark Between the leg that identifies.
- 8. airline's marketing data integration method as claimed in claim 7, it is characterised in that the air passenger mark For：Name+type of credential+passport NO.+mobile device number+access IP address；The aeronautical product is identified as：Auditing system production number+air ticket production number+other business voucher production number+product prices；Aviation Sales Channel is identified as：World boat association certification coding+seat reservation system work account+perfect instrument type+certificate number Code+name.
- 9. airline's marketing data integration method as claimed in claim 8, it is characterised in that the aviation marketing data is whole Matched moulds type includes：Aircraft index of correlation, time, international boat association industry data, check-in index, reservation record index, client management system, knot Count and a little settle accounts index with endpoint data and air ticket.
- 10. airline's marketing data integration method as claimed in claim 9, it is characterised in that described in aviation marketing number On the basis of Integrated Models, application provide meet service logic and be easy and fast to read show view, make bottom number Actual production work can be used for according to model, including：Show that the business indicator discrimination of airline establishes the assessment page to availability of data；Interactive interface with index is established to the data tracking of airline's core index item, helping user, quickly cognition is specified In time range, the scope of business and business completion status；According to establish client, channel, product Back ground Information establish statistical model come the potential value of mining data.
Priority Applications (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710963622.8A CN107784520A (en) | 2017-10-16 | 2017-10-16 | A kind of airline's marketing data integration system and method |
Applications Claiming Priority (1)
| Application Number | Priority Date | Filing Date | Title |
|---|---|---|---|
| CN201710963622.8A CN107784520A (en) | 2017-10-16 | 2017-10-16 | A kind of airline's marketing data integration system and method |
Publications (1)
| Publication Number | Publication Date |
|---|---|
| CN107784520A true CN107784520A (en) | 2018-03-09 |
Family
ID=61433817
Family Applications (1)
| Application Number | Title | Priority Date | Filing Date |
|---|---|---|---|
| CN201710963622.8A Pending CN107784520A (en) | 2017-10-16 | 2017-10-16 | A kind of airline's marketing data integration system and method |
Country Status (1)
| Country | Link |
|---|---|
| CN (1) | CN107784520A (en) |
Cited By (5)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110751575A (en) * | 2019-10-21 | 2020-02-04 | 中国民航信息网络股份有限公司 | Method and device for processing civil aviation passenger service data |
| CN112182091A (en) * | 2020-12-03 | 2021-01-05 | 光大科技有限公司 | Multi-source data integration method, system, storage medium and electronic device |
| CN113327027A (en) * | 2021-05-26 | 2021-08-31 | 深圳证券通信有限公司 | Digital operation management method |
| CN113674027A (en) * | 2021-08-24 | 2021-11-19 | 广州市中航服商务管理有限公司 | Machine ticket data analysis method and device |
| CN114153903A (en) * | 2022-02-07 | 2022-03-08 | 中国民航信息网络股份有限公司 | Data display method and related system |
Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102542351A (en) * | 2011-12-31 | 2012-07-04 | 深圳中兴网信科技有限公司 | Hotel database establishing method and hotel automatic-booking method |
| CN105718261A (en) * | 2015-01-16 | 2016-06-29 | 贾志东 | Functional member and functional member tree based target product generation method and system |
| US20160224997A1 (en) * | 2015-01-30 | 2016-08-04 | Bank Of America Corporation | Total spend item level affinity identification system |
| CN106157066A (en) * | 2015-03-23 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Mapping relations processing method, system and information processing platform equipment |
| CN107169792A (en) * | 2017-05-05 | 2017-09-15 | 魏震宇 | A kind of commodity flaking method |
| CN107203910A (en) * | 2017-05-27 | 2017-09-26 | 科技谷（厦门）信息技术有限公司 | A kind of big data intelligent accurate marketing system |
| CN107239486A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of data characteristics storehouse method for building up and system |
-
2017
- 2017-10-16 CN CN201710963622.8A patent/CN107784520A/en active Pending
Patent Citations (7)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN102542351A (en) * | 2011-12-31 | 2012-07-04 | 深圳中兴网信科技有限公司 | Hotel database establishing method and hotel automatic-booking method |
| CN105718261A (en) * | 2015-01-16 | 2016-06-29 | 贾志东 | Functional member and functional member tree based target product generation method and system |
| US20160224997A1 (en) * | 2015-01-30 | 2016-08-04 | Bank Of America Corporation | Total spend item level affinity identification system |
| CN106157066A (en) * | 2015-03-23 | 2016-11-23 | 阿里巴巴集团控股有限公司 | Mapping relations processing method, system and information processing platform equipment |
| CN107239486A (en) * | 2017-04-19 | 2017-10-10 | 中国建设银行股份有限公司 | A kind of data characteristics storehouse method for building up and system |
| CN107169792A (en) * | 2017-05-05 | 2017-09-15 | 魏震宇 | A kind of commodity flaking method |
| CN107203910A (en) * | 2017-05-27 | 2017-09-26 | 科技谷（厦门）信息技术有限公司 | A kind of big data intelligent accurate marketing system |
Non-Patent Citations (2)
| Title |
|---|
| 刘攀: "基于数据挖掘的航空公司客户价值建模", 《中国优秀硕士学位论文全文数据库 信息科学辑》 * |
| 董宇: "基于航空公司数据仓库系统的测试方法研究与实现", 《中国优秀硕士学位论文全文数据库 信息科学辑》 * |
Cited By (6)
| Publication number | Priority date | Publication date | Assignee | Title |
|---|---|---|---|---|
| CN110751575A (en) * | 2019-10-21 | 2020-02-04 | 中国民航信息网络股份有限公司 | Method and device for processing civil aviation passenger service data |
| CN112182091A (en) * | 2020-12-03 | 2021-01-05 | 光大科技有限公司 | Multi-source data integration method, system, storage medium and electronic device |
| CN112182091B (en) * | 2020-12-03 | 2021-04-27 | 光大科技有限公司 | Multi-source data integration method, system, storage medium and electronic device |
| CN113327027A (en) * | 2021-05-26 | 2021-08-31 | 深圳证券通信有限公司 | Digital operation management method |
| CN113674027A (en) * | 2021-08-24 | 2021-11-19 | 广州市中航服商务管理有限公司 | Machine ticket data analysis method and device |
| CN114153903A (en) * | 2022-02-07 | 2022-03-08 | 中国民航信息网络股份有限公司 | Data display method and related system |
Similar Documents
| Publication | Publication Date | Title |
|---|---|---|
| CN107784520A (en) | A kind of airline's marketing data integration system and method | |
| Ahani et al. | Revealing customers’ satisfaction and preferences through online review analysis: The case of Canary Islands hotels | |
| Urban et al. | Airline categorisation by applying the business model canvas and clustering algorithms | |
| Matsumoto | International air network structures and air traffic density of world cities | |
| Ma et al. | Development of a data-driven platform for transit performance measures using smart card and GPS data | |
| CN107527293A (en) | Group of cities space relationship Strength Analysis System based on statistical model | |
| CN105354689A (en) | Computer system based civil aviation team management method and system | |
| CN101636757A (en) | Deal identification system | |
| Wong et al. | Managing valuable Taiwanese airline passengers using knowledge discovery in database techniques | |
| Matsumoto et al. | The effects of new international airports and air-freight integrator's hubs on the mobility of cities in urban hierarchies: A case study in East and Southeast Asia | |
| CN113344758A (en) | Method and system for adjusting scale of service facility based on urban crowd digital portrait | |
| CN109754187A (en) | Project cost index classification and calculation of measured data governing system | |
| Arunyanart et al. | International location selection for production fragmentation | |
| Chen et al. | RFM Model and K‐Means Clustering Analysis of Transit Traveller Profiles: A Case Study | |
| ROȘU et al. | Evaluating issues and performance of a public transport network in a post-communist city using a quantitative spatial approach | |
| Mohamed et al. | Big data analytics in airlines: opportunities and challenges | |
| Chiang | Applying a new model of customer value on international air passengers' market in Taiwan | |
| CN108763349A (en) | Urban land use degree of mixing measuring method and system based on social media data | |
| Wu et al. | Chinese airline competitiveness evaluation based on extended binary relative evaluation (BRE) model | |
| Kim | Implementing a sustainable decision-making environment-cases for GIS, BIM, and big data utilization | |
| Wiltshire et al. | Air transport as a driver of sustainable development in Latin America and the Caribbean: challenges and policy proposals | |
| Babatunde et al. | A fuzzy multi-criteria approach for hosting-right selection: A case study of sport event | |
| Dessureault et al. | Data mining and activity based costing for equipment replacement decisions Part 1–establishing the information infrastructure | |
| Chiang | A new procedure of market segmentation for dynamic CRM systems: A case study of airlines in Taiwan | |
| Greig et al. | A data map of existing UK data sources related to regional trade |
Legal Events
| Date | Code | Title | Description |
|---|---|---|---|
| PB01 | Publication | ||
| PB01 | Publication | ||
| SE01 | Entry into force of request for substantive examination | ||
| SE01 | Entry into force of request for substantive examination | ||
| AD01 | Patent right deemed abandoned | ||
| AD01 | Patent right deemed abandoned |
Effective date of abandoning: 20211126 |