200949747 九、發明說明： 【發明所屬之技術領域】 本發明係關於-種行動電話業務資料庫系統架構，特別是—種矛I 構化查詢語言（sqw她dQueiyLanguage)及配合資料庫^用結 以達到快 構的資料庫，可縮短對行動電話客戶各種使用行為之分析時程，所架 速支援行銷用途的目的。 【先前技術】 0 目前習用的諸庫是未經整理之獻資觸結，因此目前習用之' 庫架構無法應付行銷研究的即時分析行為，而賴研究賴崎料=料 合以下特性，⑴主題導向⑺具整合性⑴具長期性及⑷具= 性，於是在使用制之資料庫架構則會存在下觸題： 1.習用之麟庫在建置時，需著重在系統流程的順暢性及儲存*門 的最佳化’在資料庫_上必須以正規化的方式建構，而行= 究則必須符合主題導向之特色，若使用習用之資料庫進行行銷研 究，則無法快速整合出相關主«料，而延長行銷研究之分析行 程 〇 2. 習用之資料庫在使用時，必須記錄各種不同的應耗統的每一步 驟的詳細資料’而賴研究則必賴合具整合性讀色若使用 習用之資料庫進行行銷研究，則會呈現未經整合之資料，對行銷 研究分析人“言’便撕林足以制。 餐用資料庫主要疋為了記錄日常性的資料狀態而設計，資料量 3. 200949747 : :子個月，其餘則以備份方式處理，而行銷研究則必夕頁 付合具長雛H若使m之資料庫進行侧研究，則無 法耳传長期之研究資料，而導齡析結果之可效度降低的情況產 生。 4 白用之貝料庫記錄日常性龍，㈣時常變動及更新，而行銷研 m 特色，細f狀爾進行行_ 究，會因其資料變_雜高之因素，而導致無法形成—有系統 之資料整理與轉，目此在進行賴研究上，並不適合使用習用 之資料庫。 而亟待 由此可見上述習用方式仍有諸多缺失，實非—良善之設計， 加以改良。 本案發明人餘上«財搞衍生的各顿點，乃純加以改良創 業務 新’並經多年苦㈣棘心研究後，終於成功研發完成本件行動電話 資料庫系統架構》 【發明内容】 發明之目的即在於提供—種行動電話業射料輕統架構，係該本 貝慨蝴細嫩嫩冑她梅_俺件為核心， :為建叙方㈣胸者爾魅_㈣⑽關主題資 ^從行鱗向觀料庫帽取、整合錢，進行败錢_為推出行 動行麟方案的參考及佐證依據。 本發明之次-目的即在於提供-種行動電轉務諸庫祕架構，係 200949747 該本資料«統賴聽合各應㈣_資料庫資料，純整合及建立分 析架構，通常以整合過的資料型態呈現，以便利分析人員執行相關分析^ 業。 本發明之另―目的即在於提供—種行動電話業務資料料統架構，係 .該本資料庫系統架構，為了執行長期趨勢的分析，常須保留〗至μ年的歷 .史資料’通常以月為單位進行資料建置，能夠提供研究資料之完整性，此 :與習用之資料庫為曰常性的資料有很大的差異。 麝 本發明之又一目的即在於提供一種行動電話業務資料庫系統架構，係 該本資料料統架構則是由擴充制之資料庫，並從中萃取詩，經過整 理、規劃、建構而成的-個有系統的f料庫的子集合，通常作為長期性分 析用的歷史性資料，亦只有内部相關人員可以定期性的修改資料結構但 頻率不會太π ’且行銷導向型資料並不允許使用者去做更新的動作，所以 其資料是較少有變動。 可達成上述發明目的之摘電話祕資料庫祕架構，係_ sql結 癱構化查詢語言及資料倉儲系統，建構一行銷導向型資料庫的資料架構及内 •容。主要著重於以最短科間、最有雜的方式，滿足行銷分析者對於行 -動電話行銷資訊的需求；本架構根據行動電話用戶的合約資料庫並結合 交換機的通話明細（CDR)，包括行動電話的語音通話量、簡訊（_)通 信量及數據通信量；將行動電話用戶在不同時段，分辨出各時段的使用次 數’使用類別’使用時間及使用金額等，以月為單位進行整合及歸類；使 行銷分析者能快速取得上述資料相關的平均值或最大及最小值等統計量， 200949747 以便進行即時的行鱗研纽_ ; 該行動電話行銷導向型資料庫系統架構以快 人員有關行動電話使用行為及客戶區隔為主要訴求供行鎖分析 通話明細中’對客戶的雜進行 '，了㈣不同型態的 務族群等不同的客戶區隔，藉此、雜說型、高度上網族群、商 方案及產品組合。 τ貞可提出符合各種客戶區隔的行銷 【實施方式】 中所知，本發本發明仃動業務f料庫系統架構之資料庫架構圖 、本發明仃動電話業務資料庫系統架構主要包括： 1單位建置之貝費型㈣料庫丨，如月租型資費資料庫11 · 二客戶的資料及使用行為建置之資料庫2，包含基本屬性資料庫21 24 語音行賴庫22、簡訊行編庫23及數據行為資料庫 ❹ —月租型謝料庫11 ’係該資料庫之細_方式，乃依行銷之 特性需求而規劃以時間時（本發明以月為單位）作為資料庫之建置架構‘ 百先依客戶之龍型態建置1袓《費資料庫η，主要包含每個客戶（但 排除預付卡型_戶，因其屬轉雜㈣不錢巾）之每個月的資費方案 及每月資費轉換過程資訊，如新増歷加轉犯加降取現有抑現有 祀等資費轉換過程資訊；接續將每则客戶的㈣及使用行為，各建置為 基本屬性雜庫2卜語音行騎料庫22、_亍為f料庫23及數據行為 資料庫24，並將基本屬性資料庫21設置為各客戶的核心，介接每個客戶在 200949747 每個月之。。音行為資料庫22/簡訊行為資料庫 同時點的使用行為。 23/數據行為資料庫24 在不 一基本屬性資卿21，制f料庫之f㈣構至少包含 及服務t，訊，租期提供行銷分析人員_動門號客戶賴且期 誠度分析，而服務中心則可被指^責關懷客戶的執行單位.B的忠 一語音行騎料庫22，健資料料各《每㈣語音行為分析，對 % 客戶整體、各_、各時段之姆語音聽量妨整合並分類，該資 分類内容主要包括： 1) 將客戶细騎音行雜合並分網外/國際/市話/加 值，並個別整合時間/次數/受話對象數/使用金額等統計量； 2) 將客戶使用的數據行為整合並分類成早上/中午/下午/晚上^菜 夜，並個別整合時間/次數/受話對象數/使用金額等統計量； 3) 將客戶使用的數據行為整合並分類成平日/假日，並個別整合時間 /次數/受話對象數/使用金額等統計量。 一簡訊行為資料庫23，係該資料庫顯示各門號每月的簡訊行為，對客 戶整體、各類別、各時段之相對簡訊通信量進行整合並分類，該資料庫分 類内容主要包括： 1) 將客戶使用的簡訊行為整合並分類成網内/網外/國際/市話/加 值’並個別整合時間/次數/受話對象數等統計量； 2) 將客戶使用的數據行為整合並分類成早上/中午/下午/晚上/深 夜，並個別整合時間/次數/受話對象數等統計量； 200949747 3)將客戶使用的數據行為整合並分類成平日/假日，並個別整合次 數/受話對象數/使用金額等統計。 一數據行為資料庫24，係該資料庫為各門號每月的數據行為，對客戶 整體、各時段之相對數騎信量進行整合並分類，該f料庫分類内容主要 包括： 1) 將客戶使用的數據行為整合並分類成早上/中午/下午/晚上/深 夜’並個別整合時間/上傳量/下載量/使用金額等統計量； # 2) 將客戶使用的數據行為整合並分類成平日/假日，並個別整合時 間/上傳量/下載量/使用金額等統計量。 本發明係為-擴充型龍倉儲线，應用观結構化錢語言及整合 資料倉儲内各個應耗統的資料，建構行動電話行銷導向型資料庫系統架 構及内容；在行動電話資料庫线架射，資料庫中存放的是比較長期的 歷史貝料（-般至少在-年以上）；且存放在資料料的龍，通常會包含 一個可辨識行動電話用戶的10值（合約代碼）及—個時心素（通常以月 為單位），以利資料的統計、分析或不同時間點的比較。 本發明所提供之行動電話業務請庫系統架構與其他習用技術相互 比較時，更具備下列優點： 1.本發明之行動電話業務資料庫系五 朱構係可快速擷取出行銷分析 人員所須之行銷資料，可大幅提高 的行銷分析品質。 ㈣九請效率，並提供較佳 2.本發明之行動電話業務資料庫系 朱構，係可篩選出符合行銷方案 200949747 訊的=客戶名單’比起以往隨機取得的客戶名單，在c施或簡 本，、的機制下，命中率將高出以往，故可大幅降低行銷及人事成 °確保賴方案執行之正確性及迅速性，進而提高公司營 收’其經濟效益非常明顯。 、^ ㈣係針對本㈣之-可行實酬之具體說明，惟該實施例 、、非用X限制本發明之專利制，凡未脫離本發明技藝精神所為之等效實 施或變更，均應包含於本案之專利範财。 ”’’丁'上所述’本案不但在技術思想上確屬創新，並能較習用物品增進上 述夕項功效’應以充分符合新穎性及進步性之法定發明專财件，爰依法 提出申凊’懇請貴局核准本件發明專利申請案，以勵發明，至感德便。 【圖式簡單說明】 圖一為本發明之行動電話業務資料庫系統架構之資料庫架構圖。 【主要元件符號說明】 1 以時間單位建置之資費型態資料庫 11 月租型資費資料庫 2 以客戶的資料及使用行為建置之資料庫 21 基本屬性資料庫 22 語音行為資料庫 23 簡訊行為資料庫 24 數據行為資料庫 11200949747 IX. Description of the invention: [Technical field of invention] The present invention relates to a system architecture of a mobile phone service database, in particular, a spear-structured query language (sqw her dQueiyLanguage) and a matching database Achieving a fast-track database can shorten the analysis of the various usage behaviors of mobile phone customers and support the purpose of marketing. [Prior Art] 0 The current libraries are unconsolidated and donated, so the current 'library structure' cannot cope with the real-time analysis behavior of marketing research, and Lai research Laiqi material = the following characteristics, (1) theme Orientation (7) is integrated (1) with long-term and (4) with =, so there is a problem under the use of the database structure: 1. When using the library, it is necessary to focus on the smoothness of the system flow and The optimization of storage *doors must be constructed in a formalized manner in the database, and the line = research must be consistent with the theme-oriented characteristics. If the library is used for marketing research, the relevant masters cannot be quickly integrated. «Materials, and the analysis of the extended marketing research 〇2. When using the database, the detailed information of each step of the various consuming systems must be recorded', and the research must rely on integrated reading. Using the used database for marketing research, there will be unintegrated information. For the marketing research analysts, “the words” will be enough to make the system. The meal database is mainly used to record the daily data. The design, the amount of data 3. 200949747 : : Sub-month, the rest is handled by backup, and the marketing research is necessary to pay for the long-term H. If the database of m is studied side by side, it cannot be passed on for a long time. The research data, and the result of the decrease in the validity of the results of the lead-in analysis. 4 The white-use shell library records the daily dragon, (4) changes and updates from time to time, and the marketing research m features, fine f-like behavior. Due to the fact that its data has become a factor of high, it can not be formed - systematic data is sorted and transferred. It is not suitable for the use of the database in the research. Therefore, it is still necessary to see the above-mentioned methods. Many of the shortcomings, the real non-good design, to improve. The inventor of the case left the "financial derivative of the various points, is purely improved to create a new business" and after years of pains (four) thorny research, finally successfully developed this article Mobile Phone Database System Architecture [Invention] The purpose of the invention is to provide a light-weight architecture for the mobile phone industry, which is the core of the book, the beauty of the book, and the core of the book. (4) The chest of the enchantment _ (four) (10) off the subject matter ^ from the line scale to the observation of the library cap to take, integrate the money, carry out the loss of money _ for the introduction of the action line Lin program reference and supporting evidence. The second objective of the present invention is to provide - The structure of the mobile power transfer system is 200949747. This information is based on the data of the organization. It is purely integrated and the analysis structure is established. It is usually presented in an integrated data format to facilitate the analysis of relevant personnel. The other purpose of the present invention is to provide a mobile phone service data system architecture. The database system architecture, in order to perform long-term trend analysis, often has to retain the history of the year to μ. The data 'is usually built on a monthly basis, which can provide the integrity of the research data. This is very different from the conventional database. It is another object of the present invention to provide a kind of information. The mobile phone service database system architecture is based on the database of the expansion system, and extracts the poems from it, after sorting, planning and constructing - a systematic f library Sub-collections, usually used as historical data for long-term analysis, only internal personnel can periodically modify the data structure but the frequency is not too π 'and the marketing-oriented data does not allow users to do the update action, so Its information is subject to change. The secret structure of the phone secret database can be achieved by the above-mentioned inventions. The system structure and data storage system are constructed, and the data structure and internal content of the sales-oriented database are constructed. The main focus is on meeting the market analyst's demand for line-to-line telemarketing information in the shortest and most complex way; this architecture is based on the mobile phone user's contract database combined with the switch's call detail (CDR), including actions. Telephone voice volume, newsletter (_) traffic and data traffic; mobile phone users at different time periods, distinguishing the number of uses of each time period 'use category' usage time and usage amount, etc., and integrating on a monthly basis Classification; enable marketing analysts to quickly obtain the average or maximum and minimum statistics related to the above data, 200949747 for immediate on-line research and development _; The mobile phone marketing-oriented database system architecture is fast Mobile phone usage behavior and customer segmentation are the main demands for the bank lock analysis. In the call details, the 'customer's miscellaneous' is made. (4) Different types of different groups of customers, such as different types of customers, , business plan and product portfolio.贞 贞 贞 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合 符合1 unit built-in shell-type (four) material library, such as monthly rent-type tariff database 11 · 2 customer data and usage behavior database 2, including basic attribute database 21 24 voice line library 22, newsletter line Library 23 and data behavior database ❹ - monthly rent type thank you library 11 ' is the details of the database _ way, according to the characteristics of marketing needs and planning time (the month of the invention) as a database The structure of the 'first-to-first-year customer-based dragon type construction 1 袓 "fee database η, mainly including each customer (but exclude prepaid card type _ household, because it is a miscellaneous (four) no money towel) every month Information on the tariff plan and the monthly tariff conversion process, such as the information on the conversion process of the new 増 calendar plus the transfer and the reduction of the current 祀 祀 ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; ; Bu voice line riding library 22 _ Right foot to 23 f material library and behavioral data repository 24, and the basic properties of the database 21 to the core of each customer, each customer interfacing of each month at 200 949 747. . Sound Behavior Database 22/SMS Behavior Database Simultaneous point usage behavior. 23/Data Behavior Database 24 In the case of a basic attribute, the F(4) structure of the f-repository contains at least the service t, and the rental period provides the marketing analysts The service center can be accused of caring for the customer's execution unit. B's Zhongyi voice line riding library 22, health data materials, each (four) voice behavior analysis, for the total customer, each _, each time of the voice listening It may be integrated and classified. The content of the taxonomy mainly includes: 1) Statistic of the customer's fine-sounding, mixed-in-network/international/local/value-added, and individual integration time/number/receipt number/usage amount 2) Consolidate and classify the data behaviors used by customers into morning/noon/afternoon/evening nights, and integrate statistics such as time/number of times/number of recipients/usage amount; 3) Integrate data behaviors used by customers And classified into weekdays/holidays, and individual integration time/number of times/number of recipients/usage amount and other statistics. A newsletter behavior database 23 is a database that displays the monthly newsletter behavior of each door number, and integrates and classifies the relative newsletter traffic of the customer as a whole, each category, and each time period. The database content includes: 1) Consolidate and classify the SMS behaviors used by customers into intranet/offline/international/local/value added and individually integrate statistics such as time/number of times/received objects; 2) Consolidate and classify data behaviors used by customers into Morning/noon/afternoon/evening/late night, and individual integration time/number/receiver number statistics; 200949747 3) Consolidate and classify data behaviors used by customers into weekdays/holidays, and individual integration times/received objects/ Use statistics such as amount. A data behavior database 24 is a monthly data behavior of each door number, and integrates and classifies the relative number of riding signals of the customer as a whole and each time period. The content of the f-category mainly includes: 1) The data behaviors used by customers are integrated and categorized into morning/noon/afternoon/evening/late nights and individual integration time/upload/downloads/usage amounts; #2) Consolidate and classify data behaviors used by customers into weekdays / Holidays, and individual integration time / upload / download / usage amount and other statistics. The invention is an extended Longcang storage line, which applies the structured money language and integrates various data in the data storage to construct the structure and content of the mobile phone marketing-oriented database system; The database stores relatively long-term historical material (--at least at least -years); and the dragon stored in the data material usually contains a 10-value (contract code) and a identifiable mobile phone user. Time factor (usually in months) to facilitate statistics, analysis, or comparisons at different points in time. When the mobile phone service library system architecture provided by the present invention is compared with other conventional technologies, the following advantages are obtained: 1. The mobile phone service database of the present invention is capable of quickly extracting the information required by the marketing analyst. Marketing materials can greatly improve the quality of marketing analysis. (4) Nine efficiency, and provide better 2. The mobile phone service database of the present invention is a framework of the customer list that can be selected according to the marketing plan 200949747* than the list of customers randomly obtained in the past. Under the simplified mechanism, the hit rate will be higher than in the past, so it can greatly reduce the marketing and personnel to ensure the correctness and rapidity of the implementation of the program, and thus improve the company's revenue 'its economic benefits are very obvious. And (4) for the specific description of the feasible and remuneration of this (4), except that the embodiment and the non-use X limit the patent system of the present invention, and the equivalent implementation or modification without departing from the spirit of the invention shall include Patent in this case. "''Ding' said that 'this case is not only innovative in terms of technical thinking, but also can improve the above-mentioned effects of the above items in terms of the use of articles.' It should be based on the statutory inventions that fully meet the novelty and progressiveness.凊 'Please ask your office to approve the invention patent application, in order to invent the invention, to the sense of convenience. [Simplified illustration] Figure 1 is the database structure diagram of the mobile phone business database system architecture of the present invention. Description] 1 The tariff type database built in time unit 11 monthly rent tariff database 2 The database built with the customer's data and usage behavior 21 Basic attribute database 22 Voice behavior database 23 SMS behavior database 24 Data Behavior Database 11