TW567422B - System and method for effectively transferring heterogegeous data between incompatible computers - Google Patents
System and method for effectively transferring heterogegeous data between incompatible computers Download PDFInfo
- Publication number
- TW567422B TW567422B TW91104483A TW91104483A TW567422B TW 567422 B TW567422 B TW 567422B TW 91104483 A TW91104483 A TW 91104483A TW 91104483 A TW91104483 A TW 91104483A TW 567422 B TW567422 B TW 567422B
- Authority
- TW
- Taiwan
- Prior art keywords
- data
- file
- computer
- format
- type
- Prior art date
Links
Landscapes
- Information Retrieval, Db Structures And Fs Structures Therefor (AREA)
Abstract
Description
567422 五、發明說明(1) 一、發明所屬之拮街镇域 方法,特別地,該 間有效率地轉換異 本發明係關於一種資料轉換系統及 資料轉換系統及方法係在不相容電腦之 質資料。 了 先前技術 ' Ί 隨著資訊技術的演進以及網路技| 管理的需求已不再侷限於僅僅是將資^紐,達,對於資料 存好的資料進一步可以進行更廣泛的運用子起來而已。儲 v文用,例如,接供仏 資料倉儲系統(Datawarehouse)、資料超市系統、° 資料採擷(Data Mining)、決策主管資訊系 ^Executive Information System)、Web版遠程報表與動 f寶I報表、行銷企劃人員即興式查詢(Ad-hoc Query)、多管 道服務傳遞系統(M u 11 i - C h a η n e 1 )以及與C R Μ前端系統敫人 (CT I, Sales Force Automation)等系統運用 v 然而,上述可取得運用的資料必須為現行電腦系、统甚 至是開放式平台(Open platform)所能讀取。亦即,過時 的(Legacy)電腦系統内所儲存的資料,例如IBM的大型主 機(Main frame),必須經過轉換為現行電腦系統沐 u尸汁能判讀 之資料,才能運作為上述各種先進的資料應用。 3 由於早期對於電腦的需求多為運用來儲存大量的次 料,因此,採用大型電腦的多為金融業以及郵政ί 貝 乘。隨著 將資料轉換至開放式平台的趨勢,現今資料轉換已成 融業以及儲存有大量僅為過時大型主機可讀取的& ”'金 貝料之業 567422567422 V. Description of the invention (1) I. The method of street township to which the invention belongs, in particular, the efficient conversion between the present invention is related to a data conversion system and the data conversion system and method are in the quality of incompatible computers data. The previous technology '资讯 With the evolution of information technology and network technology | management needs are no longer limited to merely tying up assets and data, and the stored data can be used more widely. For storage, for example, data warehouse system (Datawarehouse), data supermarket system, data mining (° Data Mining), decision-making information system (Executive Information System), Web version of remote reports and mobile reports, Marketing planners use Ad-hoc Query, multi-channel service delivery system (M u 11 i-C ha η ne 1), and system integration with CR Μ front-end system (CT I, Sales Force Automation) and other systems. However, the above-mentioned accessible data must be readable by current computer systems, systems, and even Open platforms. That is, the data stored in the outdated (Legacy) computer system, such as the IBM mainframe, must be converted into data that can be interpreted by the current computer system, in order to operate as the above-mentioned various advanced data. application. 3 Since the demand for computers in the early days was mostly used to store a large amount of data, the large computers were mostly used by the financial industry and postal services. With the trend of converting data to open platforms, today's data conversion has become a financial industry and stores a large number of & "'Jinbei materials industry' which is only readable by outdated mainframes 567422
者的繁重工作。 一般電腦系統對於檔案結構的安排, 資料 資料 且, 型態 料檔 料項 4. 所儲 程式 後於 程式 而 , 轉換 耗費 載入Hard work. The arrangement of the general computer system for the structure of the file, the data, and the type of the file. Item 4. The stored program is after the program, and the conversion costs loading.
資料項目做排列,若該資 士 3的:貝料項目即為該資料庫的資料攔位 項目内之資料皆具有-個別的資料 的描述檔,於描述檔内存有對其所對應之資料檔之次 目的定義、對應資料項目的資料型態以及資料‘: 關於過時電腦系統(例如一主機)内所儲存之資料^ 就以往的作法,係先由人工對該主機所存之描述檔内 存的資訊做語意分析。接著,於主機内撰寫一支轉換 (業界通稱為主機程式)將資料檔先轉換為中繼檔。隨 目的電腦系統内撰寫一支轉換程式(業界通稱為末端 )將中Μ槽轉換為目標電腦可讀取的資料槽。然 還需要载入程序的協助,才能順利地將資料檔從主機 至目標電腦。若是有3 0 0個資料檔欲做轉換,即需要 時間撰寫3 0 0支主機程式、3 0 0支末端程式以及3〇 〇支 程序’才能順利地將3 0 0個資料檔做轉換。明顯地, 現行將大型主機内的資料轉換至開放式平台的作法,不但 要耗費大量種式人員的人力,而且需耗費大型主機的運算 資源’影響到大型主機原有需執行的工作。 再以建構資料倉儲系統為例,依照過去經驗,資料倉 儲系統建置有三分之二之時程,在處理資料的轉換上。因 此’若能縮短資料轉換的時程,即可大幅縮短資料倉儲的 567422 _ 五、發明說明(3) 建置時程。需 開玫式平台間 2換異質資料 就先前技術而 料來源電腦大 产欵率。 ;h 因此,本 :4方】丨块,特別地 在不相容電腦 、將過時的電腦 成高欵率、低 料的其他應 rr7\ < ?資 二、楚明内容 本發明之 地轉換異質資 電腦系統中之 降低資料轉換 用〇 強調的是,不僅僅是對於在過時大型主機與 的資料轉換,凡是於兩不相容的電腦系統間 ’皆會有高效率地轉換資料的需求。然而, 其以人工做語意分析的作法以及耗掉資 量運作資源的作法,明顯地會降低資料轉換 Ί - V;i.? '.、 發明之一目的係在提供一種資料轉換系統及 ’本發明所提供資料轉換系統及方法係用以 之間’以極高的效率轉換異質資料,尤其是 系統内之資料轉換至開放式平台。藉此,達 成本的資料轉換工作,以利後續對轉換 用。 〇 ^ 目的即在提供一種於不相容電腦之間有致率 料之系統及方法。藉由本發明,可以將過時 資料有效率、快速地轉至開放式平台上,Ζ 成本,利於後續對已轉換之資料的其他瘫 根據本發明之第一較佳具體實施例,一種資料轉換方 法係提供來將一資料檔從一第,電腦轉換至一第二電腦。 該資料槽包含依據複數個項目做排列之資料,安置於兮… 數個項目中每一個項目内之資料係具有一個別的第—資3 型態以及一個別的第一資料格式。所有的第一資料型熊/以 567422 正 五、發明說明(4) 及所有的第一 該第二電腦所 且描述該複數 第一資料格式 第一電腦與該 轉換的規則。 _ 一電腦處擷 ^亥产述檔内所 余语意分析, 含該複數個項 中繼資料格式 攀型態係為該 ^型態中之一 之每一個中繼 s亥複數個第一 擇性地 格式’ 資料格 該第二 修改該 進而修 式,並 參照檔 態以及 態係為 態中之 資料型 資料型 資料型 為該第二電腦 資料格 能判讀 個項目 。一預 第二電 根據本 取該描 之所有 進而產 目之定 。該複 第二電 個第一 資料格 資料格 複數個 改成為 且產生 係包含 該複數 式係為 〇 —描 之定義 定參考 腦之間 發明之 述檔。 第一資 生一第 義、複 數個中 腦可判 資料型 式係為 式中之 中繼資 複數個 一第二 該第一 述檔係 以及相 檔係事 各類資 較佳具 接著, 料型態 一參照 數個中 繼資料讀,並 態。該 電腦可 儲存於 對應的 先提供 料型態 體實施 根據該 以及所 檔。該 繼資料 型態中 且對應 複數個 判讀, 該第一 第一資 ,並且 及各類 例,首 預定參 有第一 第一參 型態以 之每一 該複數 中繼資 該第二電腦可判讀, 一個第一資料格式。 複數個 該複數 個第二 該第二電腦可 一個第一資料 之 可判讀,並且 個第一資料格式。最後 料型態 第二資 參照檔 個項目 資料格 判讀, 型態, 對應該 ,根據 以及該 料型態 以置換 之定義 式,其 並且對 每一個 複數個 該第二 以及複 該第一 、該複 中,每 應該複 電鵰内並 料梨態與 定義於該 ^科格式先,, 考槽,_ 資料袼式 照槽係包 及複數個 個中繼資 個第一資 料格式中 並且對應 隨後,選 中繼資料 數個第二 參照檔。 數個第二 一個第二 數個第~ 第二資料格式係 第一資料格式中 參照檔,將該資The data items are arranged. If the Citizen's 3: Shell material item is the data in the database, the items in the data block items have-individual data description files, and the corresponding data files are stored in the description files. Definition of secondary purpose, data type of corresponding data items, and data ': Regarding the data stored in outdated computer systems (such as a host) ^ In the past, the information in the memory of the profile stored by the host was manually first Do a semantic analysis. Then, write a conversion (commonly known as the host program) in the host to convert the data file into an intermediate file first. A conversion program (commonly known as the end of the industry) is written in the target computer system to convert the medium M slot into a data slot that can be read by the target computer. However, the assistance of the loading process is required to successfully transfer the data files from the host to the target computer. If there are 300 data files to be converted, it will take time to write 300 host programs, 300 end programs, and 300 programs' in order to successfully convert 300 data files. Obviously, the current method of converting data in the mainframe to an open platform not only consumes the manpower of a large number of personnel, but also consumes the computing resources of the mainframe, which affects the work that the mainframe needs to perform. Taking the construction of a data storage system as an example, according to past experience, the data storage system has been set up two-thirds of the time to process data conversion. Therefore, ’if you can shorten the time of data conversion, you can greatly reduce the time of data storage 567422 _ 5. Description of the invention (3) The time of establishment. Need to open the rose platform between 2 to exchange heterogeneous data. According to the previous technology, the source computer has a large output rate. ; h Therefore, this: 4 party] block, especially in incompatible computers, the outdated computer into a high rate, low expectations of other applications rr7 \ < Second, Chuming content of the present invention conversion The reduction of data conversion in heterogeneous computer systems emphasizes that it is not only for data conversion between outdated mainframes and computers, but also for the efficient conversion of data between two incompatible computer systems. However, its method of manual semantic analysis and the consumption of resources to operate resources will obviously reduce the data conversion.-V; i.? '., One of the objects of the invention is to provide a data conversion system and' this The data conversion system and method provided by the invention is used to convert heterogeneous data with high efficiency, especially the data in the system is converted to an open platform. In this way, the cost of data conversion is achieved to facilitate subsequent conversion. ○ ^ The purpose is to provide a system and method with accurate information between incompatible computers. With the present invention, outdated data can be efficiently and quickly transferred to an open platform. The cost of Z is beneficial to other paralysis of the converted data. According to the first preferred embodiment of the present invention, a data conversion method is Provided to convert a data file from a first computer to a second computer. The data slot contains data arranged according to a plurality of items, and is arranged in Xi ... The data in each item of the several items has a different type of asset-type 3 and a different first data format. All the first data type bears / 567422 positive V. Invention Description (4) and all the first and second computers describe the plural first data format The first computer and the rules for the conversion. _ A computer extracts the remaining semantic analysis in the ^ Hai production report, including the plurality of items. The metadata format is one of each of the ^ H types. The local format 'data cell should be modified secondly and further, and referring to the file type and the data type in the state system, the data type data type can read an item for the second computer data cell. The first and second orders are based on all the descriptions of this description and then the production goals. The second electric data grid, the first data grid, and the plural data grids are changed to and generated. The complex number is 0. The definition of the drawing refers to the description of the invention between the brain. The first Shisei first meaning, a plurality of midbrain judgeable data types are the relay resources in the formula, the second one, the first profile, and the related files are better. Then, the material type One reads several metadata and reads them in parallel. The computer can be stored in the corresponding pre-supplied material type according to the as well as the file. In the following data type, and corresponding to a plurality of interpretations, the first first data, and various examples, the first computer is scheduled to participate in each of the plurality of relay data, and the second computer may Interpretation, a primary data format. The plurality of the plurality of second and the second computer can be interpreted by one of the first data and the first data format. In the end, the material type of the second material is read by referring to the project data grid of the file, type, corresponding, according to the definition of the material type and the substitution type, and for each of the plurality of the second and the first, the In the middle of the restoration, each element should be included in the data structure and defined in the format. The first, the test slot, the _ data type photo slot system package and a plurality of relay data in the first data format and correspond to the following. , Select a number of second reference files for metadata. The number one second, the number two, and the second data format are the reference files in the first data format.
第10頁 567422 五、發明說明(5)Page 10 567422 V. Description of the invention (5)
料檔内之資料從該第一電 第二電腦内該資料檔之所轉換至該第二電腦,致使於該 目、每一個,目所應的=換=資料係依照該複數個項 料格式做排列。 一貝料型態以及對應的第二資The data in the material file is converted from the data file in the first computer to the second computer, so that the item = each item in the item = exchange = the data is in accordance with the item format Do the arrangement. One shell material type and corresponding second capital
關於本發明之優點與精神可 所附圖式得到進一步的瞭解。 ^ II 以藉由以下的發明詳述及 四、宽羞本發明之目的即在提 #換異質資料之系統及方ς。=於不相容電腦之間效率地 f之資料有效率、快速地轉藉此’可以將過時電腦系統 轉換成本,利於後續的庫 開放式平台上,以降低資料 佳具體實施例,來詳細解:將精由本發明之數個較 架構以及其運作流程。W ^本發明之資料轉換系統的 資料轉換 係分別與 及一第二 結,用以 3 0處。該 資料檔係 位。安置 個別的第 如第一圖所示 根據本發明之第 系統1〇之架構係描㈣ y =施例的 -Μ - W m ^ ^ °亥貝科轉換系統1 〇 弟電恥2 0 (亦即原儲存資料檔之來源電電細3 0 (亦即資料檔欲轉換目的之目標電腦)連 將一資料檔從該第一電腦2 〇處轉換至該第二電腦 資料檔包含依據複數個項目做排列之資料。若該 為一資料庫,上述的項目即為該資料庫的資料攔 於該複數個項目中每一個項目内之資料係具有一 一資料型態(例如,單字元資料塑態、雙字元資 料型態或其他特殊的數字資料型態等)以及一個別的資料The advantages and spirit of the present invention can be further understood with reference to the drawings. ^ II through the following detailed description of the invention and four, forgiveness The purpose of the present invention is to provide #change heterogeneous data systems and methods. = Efficient and fast transfer of data between incompatible computers. This can convert outdated computer systems to costs, which is conducive to subsequent library open platforms to reduce data. : It will refine the several architectures of the present invention and their operating processes. W ^ The data conversion system of the data conversion system of the present invention is respectively connected with and a second node for 30 locations. The data file system. The structure of the first system 10 according to the present invention as shown in the first figure is described as follows: y = -M-W m ^ ^ of the embodiment 亥 Hebeko conversion system 1 〇 brother electric shame 2 0 (also That is, the source data file of the original stored data file 30 (ie, the target computer for which the data file is to be converted) and a data file from the first computer 20 to the second computer. The data file contains a number of items based on If it is a database, the above items are the data of the database. The data in each of the multiple items are stored in a data type (for example, single-character data, Double-character data type or other special numeric data type, etc.) and one other data
567422 五、發明說明(6) 格式(例如,小數點位數或貨幣種類等)。需、、主音的是,所 有的第=資料型態以及所有的第一資料格式係;該第〆電 腦2 0可判讀,但是不為該第二電腦3 〇所能判讀。〆描述檔 (Description file)係健存於該第一電腦並且描述該 複數個項目之定義以及相對應的第一資料型態與第一資料 £式。二預定參考槽(Ref erence f丨le)係事先提供,並且 疼義於該第一電腦20與該第二電腦3 0之間各類資料型態及 务類資料袼式轉換的規則。 於具體實施例中,該第一資料型態包含選自由 貝料型態、New H〇st c〇de資料型態、叩資料型 態及Comp-3資料型態所組成之一群組當中之一個資料型 瀹。於一具體實施例中,該第二電腦3〇係為一開放式平台 (Open platform),例如,Micr〇s〇f_ NT平台。 ^ 如第一圖所示,該資料轉換系統10包含一輸入模組 1卜一語意分析模組12、一參照檔儲存模組14、一編輯模 組1 6以及一為料轉換模組J 8。該輸入模組1丨係用以從該第 一電腦2 0處擷取該描述檔及該資料槽。 該語意分析模組1 2儲存該預定參考檔,並且從輸入模 組1 1處接收該描述檔。該語意分析模組丨2係用以根據該預 定參考檔,對該描述檔内之所有第一資料型態以及所有第 一資料格式做語意分析(Parsing),進而產生一第一參照 檔(Metadata)。該第一參照檔係包含該複數個項目之定 義、複數個中繼資料型態以及複數個中繼資料格式。需注 意的是,該複數個中繼資料型態中之每一個中繼資料型態567422 V. Description of the invention (6) Format (for example, the number of decimal places or the type of currency, etc.). It is necessary that the main voice is all the data types and all the first data format systems; the second computer 20 can be interpreted, but not the second computer 300. 〆Description file is stored in the first computer and describes the definition of the plurality of items and the corresponding first data type and first data type. The two predetermined reference slots are provided in advance and embody the rules for the conversion of various types of data and service data between the first computer 20 and the second computer 30. In a specific embodiment, the first data type includes a group selected from the group consisting of a shell material type, a New Host data type, a tritium data type, and a Comp-3 data type. A data type. In a specific embodiment, the second computer 30 is an Open platform, such as the MicrOSf_ NT platform. ^ As shown in the first figure, the data conversion system 10 includes an input module 1 and a semantic analysis module 12, a reference file storage module 14, an editing module 16 and a material conversion module J 8 . The input module 1 is used to retrieve the description file and the data slot from the first computer 20. The semantic analysis module 12 stores the predetermined reference file, and receives the description file from the input module 11. The semantic analysis module 2 is used to perform a parsing on all the first data types and all the first data formats in the description file according to the predetermined reference file, and then generate a first reference file (Metadata ). The first reference file includes a definition of the plurality of items, a plurality of metadata types, and a plurality of metadata formats. It should be noted that each of the plurality of metadata types
第12頁 567422Page 12 567422
係為該 態中之 一個中 複數個 存模組 先前技 統係自 f的方式 第二電腦3 0可判讀,並 一個第一資料型態 該 且對 複數 ti 師以人 L in 寫於該 除了先 縮短整 繼資料 第一資 1 4係用 術,根 動對描 進行。 工方式 第一電 前技術 體資料 格式係為該 料格式中之 以儲存該第 據本發明之 述檔内之資 單就此點, 對描述槽做 腦内執行的 所需大量的 轉換的時程 第二電腦 一個第一 一參 資料 訊做 就已 語意 轉換 程式 照檔 轉換 語意 免除 分析 程式 工程 應钱稷數個 個中繼資料 3 0可判讀, 資料格式。 。需強調的 系統1 0中之 分析,而非 先前技術需 ’以及由程 。明顯地, 師人力,並 第一 格式 並且 該參 是, 語意 傳統 由程 式工 此種 且大 資料塑 中之每 對應該 照檔儲 不同於 分析系 以人工 式工程 程師撰 作法免 巾备度地It is one of a plurality of storage modules in the state. The previous system is a way of f. The second computer 3 0 can read it, and a first data type should be written to the plural ti. First shorten the continuity data of the first fund of the 14 series of operations, and start the description. The working method of the first electrical technical data format is to store the information in the document according to the present invention in this material format. At this point, the time course of the large number of conversions performed in the brain for the description tank is described. The second computer is one of the first reference data, and the semantic conversion program is converted according to the file. The semantic exemption analysis program works. It should be able to interpret several metadata 30. The data format. . The analysis in the system 10 needs to be emphasized, rather than the previous technology needs and the process. Obviously, the manpower is the first form and the reference is that each pair of semantic traditions, such as programmers, and big data should be stored according to the file, unlike the analysis system, which is written by a manual engineer. Ground
々隨後,該編輯模組16從該參照檔儲存模組14處擷取該 第-參照檔。該編輯模組i 6係用以選擇性地修改該複: 中繼資料型態以及該複數個中繼資料格式,進而修改 複數個第二資料型態以及複數個第二資料格式,並且產: 一第二參照樓儲存至該參照檔儲存模組14内,以置換該= 一參照槽。第二參照檔係包含該複數個項目之定義、該〃 數個第二資料型態以及該複數個第二資料格式。需注音设 是,該複數個第二資料型態中之每一個第二資料型態^ = «亥第一電腦3 〇可判讀,並且對應該複數個項目中之一個項 二忒歿數個第二資料格式中之每一個第二資料格式係為 I第二電腦30可判讀,並且對應該複數個項目中之—個項々 Subsequently, the editing module 16 retrieves the first-reference file from the reference file storage module 14. The editing module i 6 is used to selectively modify the plurality of metadata types and the plurality of metadata formats, and then modify the plurality of second data types and the plurality of second data formats, and produce: A second reference building is stored in the reference file storage module 14 to replace the reference slot. The second reference file contains the definitions of the plurality of items, the plurality of second data types, and the plurality of second data formats. It is necessary to note that each of the plurality of second data types is a second data type ^ = «Hai First Computer 3 〇 can be interpreted, and corresponding to one of the plurality of items two to several first Each of the two data formats is a second data format that is readable by the second computer 30 and corresponds to one of a plurality of items
第13頁 567422 五、發明說明(8)Page 13 567422 V. Description of the invention (8)
% 亦 態 於 者 輯 -結 輯 fjL 料 第 會 於實際應用中,該編輯模組1 6係由一管理者 即,將中繼資料型態及中繼資料格式修改成第 及第二資料格式之功能權限係提供給該管理者 一具體實施例中,該資料轉換系統1 Q進一步包 介面162,如第一圖所示。該操作者介面2係 模組1 6。該資料轉換系統1 〇並且與一操作端電 ’該管理者即可透過該操作端電腦4 〇連結至該 1 6 2對該編輯模組1 6操作。 u該資料轉換模組1 8從該輸入模組丨丨處接收該 且從.遠參照檔儲存模組1 4處擷取該第二參照檔 換模組1 8係用以根據該第二參照檔,將該資料 從遠第一電腦2 〇轉換至該第二電腦3 〇,致使於 3 0内該資料槽之所轉換的資料係依照該複數個 個項目所對應的第二資料型態以及每一個項目 二資料格式做排列。 一般在將過時電腦内之資料轉換至現行的電 考ΐ對資料項目做一重新規劃。為了在進行資 所操作。 二資料型 。因此, 含一操作 連接該編 腦4 0連 操作者介 資料檔, 。該資料 檔内之資 該第二電 項目、每 所對應的 腦時,多 料轉換之 月^即做好資料攔位的重新規劃,以提升整體資料轉換的 效率。因此,於另一較佳具體實施例中,該編輯模組1 6進 一步選擇性對該複數個項目做增加、刪減、分割或合併, f且對該被增加、刪減、分割或合併之項目所對應的第二 資料,態及第二資料格式一併地相對應之修訂。亦即,提 供對資料項目做增加、刪減、分割或是合併的功能權限給 管理者。% Also in the series of editors-compilation fjL materials will be used in practice. The editing module 16 is modified by a manager, that is, the metadata type and metadata format are modified into the first and second data formats. The functional authority is provided to the manager in a specific embodiment. The data conversion system 1 Q further includes an interface 162, as shown in the first figure. The operator interface 2 is a module 16. The data conversion system 10 is electrically connected to an operation terminal, and the manager can connect to the 16 through the operation terminal computer 4 to operate the editing module 16. u The data conversion module 18 receives this from the input module 丨 丨 and retrieves the second reference conversion module 18 from the remote reference file storage module 14 to use the second reference File, the data is converted from the far first computer 20 to the second computer 30, so that the converted data of the data slot in 30 is in accordance with the second data type corresponding to the plurality of items and Each item is arranged in two data formats. Generally, the data in the outdated computer is converted to the current e-test, and the data items are re-planned. In order to carry out capital operations. Two data types. Therefore, there is an operation to connect the editor 40 to the operator to refer to the data file,. The data in the data file For the second electricity project, every corresponding brain hour, the month of multiple data conversions is to re-plan the data block to improve the overall data conversion efficiency. Therefore, in another preferred embodiment, the editing module 16 further selectively adds, deletes, divides, or merges the plurality of items, and f adds, deletes, divides, or merges the plurality of items. Amendments corresponding to the second data, status and second data format corresponding to the project. That is, it provides administrators with the functional authority to add, delete, divide or merge data items.
第14頁Page 14
567422 本 λ. I: t 五、發明說明(9) 以下將詳 轉換系統10所 流程係用以將 至該第二電腦 項目做排列之 各資料係具有 麵以及所有的 I為該第二電 -2 〇旅立描述 塑態與.第/資 義ί於該第一電 j類資料格式轉 ] 請參照第 输處2 0擷取該 ~ 隨後執行 内之所有第一 發明之第 料轉換處 從圖一中 次強調, 置於該複 述根據本 執行的資 一資料檔 30。需再 資料,安 一個別的第一資料型態。 一較佳具體實施例之資料 。該資料轉換處理 該第一電腦2 0轉換 檔包含依據複數個 項目内 資料型 讀,但 理流程 所示之 該資料 數個項 目中每一個 所有的第一 第一資料格式係為該第一 腦3 0所能判讀。一 該複數個項目之定 料格式。 腦2 0與該第二電腦 換的規則。 二圖所示 描述槽。 步驟S 5 2 資料型態 描述檔 義以及 一預定參考檔係 3 0之間 電腦2 0可判 係儲存於該 相對應的第 事先提供, 各類資料型 第一電 一資料 並且定 態及各 首先執行步驟S 5 0,從該第一電 根據該預定參考檔,對該描述檔 以及所有第一資料格式做語意分 析,進而產生一第一參照檔。該第一參照檔係包含該複數 個項目之疋義、複數個中繼資料型態以及複數個中繼資料 格式。需注意的是,該複數個中繼資料型態中之每一個中 繼貝=型恕係為該第二電腦3 〇可判讀,並且對應該複數個 =二貝料,態中之一個第一資料型態。該複數個中繼資料 二:Ϊ之每一個中繼資料格式係為該第二電腦3 0可判讀, ^該複數個第—資料格式令之一個第一資料格式。 者執行步驟S 5 4 ’選擇性地修改該複數個中繼資料567422 This λ. I: t V. Description of the invention (9) The following is a detailed description of the conversion process of the system 10. Each data used to arrange the second computer item has a surface and all I are the second electrical- 2 〇 Lu Li describes the plastic state and the first / information of the first electrical j-type data format] Please refer to the second input section 20 to retrieve the ~ first conversion of all the first inventions in the subsequent implementation from Figure 1 emphasizes again and again that the data file 30 placed in the recap according to this implementation is provided. Need to re-document, install another type of first data. Information on a preferred embodiment. The data conversion processing of the first computer 20 conversion file includes reading according to the data types in the plurality of items, but all the first first data formats of each of the plurality of items of the data shown in the logic flow are the first brain Interpretable by 30. -The ordering format of the plurality of items. Brain 20 exchanges rules with this second computer. The two figures show the grooves. Step S 5 2 The description of the data type description file and a predetermined reference file between computer 30 and computer 20 can be stored in the corresponding first-provided, various types of data, first data and first-stated data First, step S50 is performed. From the first power, a semantic analysis is performed on the description file and all the first data formats according to the predetermined reference file, and then a first reference file is generated. The first reference file contains the meaning of the plurality of items, the plurality of metadata types, and the plurality of metadata formats. It should be noted that each of the plurality of types of meta data types can be interpreted by the second computer 3 0, and corresponding to a plurality of data types, one of the data types is first. Data type. The plurality of meta data 2: each of the meta data formats is readable by the second computer 30, ^ the plural data format order is a first data format. Perform step S 5 4 ′ to selectively modify the plurality of metadata
第15頁 567422 五、發明說明(10) 型態以及該複數個中繼資料格式,進而修改 二資料型態以及複數個第二資料格式,並且產:,數個第 照樓以置換該第一參照槽。該第二參照槽係;】ς = 個第二資料型態以及該複數 正 I格式。需注意的是,該複數個第二資料型態中之每一二 寫重;資第腦3°可判讀’並且對應·數 第一貝枓型悲中之一個第一資料型態。 次 备#格式中之每一個第二資料格式係為 Μ 第一貝 .:½,並且對應該複數個第一資料格Κ第二電腦30可判 犬。 貝竹裕式中之一個第一資料格 /β. 予' rf f · m最後執行步驟S56,根據該第二參照檀,將該資料標 _之資料從該第一電腦20轉換至該第二電腦3〇,致使於該 f 一電腦30内该資料檔之所轉換的資料係依照該複數個項 目、每一個項目所對應的第二資料型態以及每一個項目所 對應的第二資料格式做排列。 此外,對於一些大型主機,例如! BM的大型主機,其 對檔案結構的安排,會有一主資料褚(Main data file)包 含多個次資料槽(Sub-data file)的情況。尤有甚者,上 述多個次資料槽之間存有次擋層級(Sub-f i le level )的階 層關係,例如,一 DL/1檔(主資料槽)經解構 (Destructure)會有多個VSA_ (次資&檔)產生,並且該 多個VSAM檔之間存有一階層關係。本發明之第二較佳具體 實施例之目的即在於將上述包含多個次資料檔的主資料檔 有效率地轉換至一現行電腦内。Page 15 567422 V. Description of the invention (10) type and the plurality of metadata formats, and further modify the two data types and the plurality of second data formats, and produce: several first photos to replace the first Reference slot. The second reference slot system;] ς = a second data type and the complex positive I format. It should be noted that each of the plurality of second data types has a weight of 2; the first data type can be interpreted at 3 ° and corresponds to one of the first data types of the first data type. Each of the second data formats in the time ## format is M first frame.: ½, and the second computer 30 can judge dogs corresponding to a plurality of first data cells. One of the first data cells in the Pei-Yu formula / β. I 'rf f · m finally executes step S56, according to the second reference frame, the data of the data target_ is converted from the first computer 20 to the second Computer 30, so that the converted data of the data file in the computer f30 is made according to the plurality of items, the second data type corresponding to each item, and the second data format corresponding to each item arrangement. Also, for some mainframes, for example! For the mainframe of BM, the arrangement of the file structure may include a case where a main data file includes multiple sub-data files. In particular, there is a hierarchical relationship of the sub-file level between the multiple sub-data slots, for example, how many DL / 1 files (main data slots) are destructured VSA_ (secondary & files) are generated, and there is a hierarchical relationship between the multiple VSAM files. The object of the second preferred embodiment of the present invention is to efficiently convert the above-mentioned primary data file containing a plurality of secondary data files into an existing computer.
567422 五、發明說明(11) 根據本發明 基本架構與根據 系統1 0之架構相 由第一圖所揭示 之第二較佳具體 及其間的運作。 根據本發明 係分別與一第一 之第二較佳具體實施例之資料轉換系統之 本發明之第一較佳具體實施例的資料轉換 同,請參照第一圖所示。因此,以下將藉 的資料轉換系統1 0,來詳細說根據本發明 實施例的資料轉換系統之各個功能模組以 之第二較佳具體實施例 電腦2 0以及一第二電腦 主t料檔從該第一電腦2 0處轉換至 並且該 個項目 個項目 Q〇 A t \ It料檔包含多個 次資料檔, 含依據複數 置於該複數 個次資料槽係包 Η固次資料檔内安 料係具有一個別的第一資料型態以及 式。需注意的是 料格式係為該第一電腦2 0可 該第 多個 做排 之資料轉換系統1 〇 3 0連結,用以將一 二電腦3 0處。該主 次資料檔中之每一 列之資料。於每一 中,每一個項目内之資 所有的第一資料型態 所能判讀。一描述檔係儲存 定義以及相 參考檔係事 腦3 0之間各 該複數個項目之 料格式。一預定 腦2 0與該第二電 換的規則。 於一具體實 EBCDIC資料型態 態及Comp-3資料 態。於一具體實 判讀, 於該第 對應的 先提供 類資料 但是 一電 第一 ,並 型態 個別的 以及所 不為$亥 腦2 0内 資料型 且定義 及各類 第一資料格 有的第一資 第二電腦3 0 ,並且描述 態與第 於該第 資料格 一資 一電 式轉 施例中,該第一資料型態包含選自由 、New Host Code資料型態、Comp資料型 型態所組成之一群組當中之一個資料型 施例中,該第二電腦3 0係為一開放式平台567422 V. Description of the invention (11) The second preferred embodiment disclosed in the first figure and the operation between the basic architecture according to the present invention and the architecture according to the system 10 are shown in the first figure. According to the present invention, the data conversion system of the first preferred embodiment of the present invention is the same as that of the data conversion system of the first second preferred embodiment. Please refer to the first figure. Therefore, in the following, the data conversion system 10 will be borrowed to describe in detail the functional modules of the data conversion system according to the embodiment of the present invention. The second preferred embodiment is the computer 20 and a second computer main file. Switched from the first computer 20 to the project and the project Q〇A t \ It data file contains multiple secondary data files, including a plurality of secondary data slots based on a plurality of secondary data slots, including fixed secondary data files The safety material system has another first data type and type. It should be noted that the data format is that the first computer 20 can connect to the multiple data conversion system 1030, which is used to connect one or two computers to 30 locations. Each row of data in the primary and secondary data files. In each of the projects, all the first data types in the project can be read. A description file is a storage definition and a reference file is a file format of each of the plurality of items in the brain 30. A predetermined rule for brain 20 and the second exchange. In a concrete EBCDIC data type and Comp-3 data type. Based on a specific actual interpretation, the first corresponding data is provided in the first corresponding but the first is the first, and the type is individual and not the data type and definition in $ 海 脑 2 0 and some of the first data types. A second computer 3 0, and the description mode and the first data type in the first data grid in the embodiment, the first data type includes a type selected from the, New Host Code data type, Comp data type In a data-based embodiment of the group, the second computer 30 is an open platform.
第17頁Page 17
Vi 修 567422 五、發明說明(12) (Open platform)’ 例如,jficrosof t的 N T平台。 如第一圖所示,該資料轉換系統丨〇包含一輸入模組 1 1、一語意分析模組1 2、一參照檔儲存模組丨4、一編輯模 沮1 6以及一資料轉換模組! 8。該輸入模組丨丨係用以從該第 一電腦2 0處擷取該描述檔及該主資料檔。 該語意分析模組12儲存該預定參考檔,並且從輸入模 =11處接收該描述檔。該語意分析模組丨2係用以根據該預 疋參f槽’對该描述檔所儲存對應每一個次資料檔之所有 第一資料型態以及所有第一資料格式做語意分析,進而產 生第·參照檔。該第一參照檔係包含每一個次資料檔之 ΐ數個!員目的定義、每一個次資料檔所對應的複數個中繼 ήt型態以及複數個中繼資料格式,其中每一個中繼資料 瀵:f為該第二電腦30可判讀,並且對應該個次資料檔之 資料型態中之一個第-資料型態、,每-個中繼 二二二1係為这第二電腦3 0可判讀,並且對應該個次資料 弟 貝枓格式中之一個第一資料格式。該參照 杬儲2模組U係用以儲存該第一參照檔。 第一 =f 1忒編輯模組16從該參照檔儲存模組14處擷取該 侗;i Γ檐。該編輯模組16係用以選擇性地修改對應每一 3 ,、隹榷之複數個中繼資料型態以及複數個中繼資料格 ^格々而修改成為複數個第二資料型態以及複數個第二資 料格式,祐日姦a ^ 1 4内,以詈拖 一第二參照槽回存至該參照樓儲存模組 資料標之複數:固】:參照標。第二參照權係包含每一個次 复數個員目的定義、每一個次資料檔所對應的複Vi repair 567422 V. Description of the invention (12) (Open platform) ’For example, the N T platform of jficrosof t. As shown in the first figure, the data conversion system includes an input module 1 1, a semantic analysis module 1 2, a reference file storage module 4, an editing module 16, and a data conversion module. !! 8. The input module is used to retrieve the description file and the master data file from the first computer 20. The semantic analysis module 12 stores the predetermined reference file, and receives the description file from the input module = 11. The semantic analysis module 丨 2 is used to perform semantic analysis on all first data types and all first data formats stored in the profile corresponding to each secondary data file according to the pre-reference parameter f slot, thereby generating a first Reference file. The first reference file contains the number of each secondary data file! The purpose of the job, the multiple metadata types corresponding to each secondary data file, and the multiple metadata formats, each of which contains metadata瀵: f is the first data type that can be read by the second computer 30, and corresponds to one of the data types of the secondary data file. Each relay 2221 is the second computer 3 0. It can be interpreted and corresponds to one of the secondary data formats. The reference storage 2 module U is used to store the first reference file. The first = f 1 忒 editing module 16 retrieves the 侗; i Γ eaves from the reference file storage module 14. The editing module 16 is used to selectively modify the corresponding multiple metadata types and the multiple metadata cells and grids corresponding to each 3, and modify them into multiple secondary data types and complex numbers. In the second data format, you can drag a second reference slot to save the data in the reference building to the reference building within a ^ 1 4 a plural number: solid]: reference target. The second reference system includes each time, multiple job definitions, and corresponding data for each time.
567422 — 五、發明說明(13) 數個第二貢料型態以及複數個第二資料格式,其 應該個次 型態,每 且對應該 資料格 所操作。 二資料型 。因此, 含一操作 連接該編 腦4 0連 操作者介 第二資料型態係為該第二電腦3 〇可判讀,並且對 二貝料檔之複數個第一資料型態中之一個第一資料 一個第二資料格式係為該第二電腦3 〇可判讀,並 ,次資料檔之複數個第一資料格式中之一個第一 ° 於實際應用中’該編輯模組16係由一管理者 亦即,將t繼資料型態及中繼資料格式修改成第 #及第二貢料格式之功能權限係提供給該管理者 具體實施例中,該資料轉換系統丨〇進一步包 者介面162,如第一圖所示。該操作者介面162係 _模組^6。該資料轉換系統1〇並且與一操作端電 結,孩官理者即可透過該操作端電腦4 〇連結至該 面1 6 2對該編輯模組1 6操作。 於另一車父佳具體實施例中,該編輯模組丨6進一步選擇 性地將每一個次資料檔之複數個項目做增加、刪減、分割 或合併,並且對戎被増加、刪減、分割或合併之項目所對 應的第二資料型·m資料格式—併地做相對應之修 訂。亦即,提供對資料項目做增加、刪減、分割或是合併 的功能權限給管理者。 最後肩貝料轉換模組1 8從該輸入模組i 1處接收該主 資料檔,並且從該參照檔儲存模組14處擷取該第二參照 U資料t換模組18係用以根據該第二參照檔,將該主 貝料檔内之貝枓從該第一電腦20轉換至該第二電腦30,致567422 — V. Description of the invention (13) Several secondary data types and multiple secondary data formats should be sub-types, each corresponding to the data cell operation. Two data types. Therefore, the second data type including an operation connection to the brain 40 and the operator's introduction of the second data type is readable by the second computer 30, and one of the plurality of first data types of the second shell material file is first. A second data format of the data is readable by the second computer, and one of the plurality of first data formats of the secondary data file is first. In practical applications, the editing module 16 is managed by an administrator. That is, the functional authority of modifying the following data type and metadata format to ## and the second data format is provided to the manager. In a specific embodiment, the data conversion system further includes a user interface 162, As shown in the first figure. The operator interface 162 is a _module ^ 6. The data conversion system 10 is connected to an operation terminal, and the child manager can connect to the surface 16 through the operation terminal computer 40 to operate the editing module 16. In another Chevrolet specific embodiment, the editing module 6 further selectively adds, deletes, divides, or merges multiple items of each secondary data file, and adds, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, deletes, or deletes multiple items of each secondary data file. The second data type · m data format corresponding to the divided or merged items—and correspondingly amended. That is, it provides administrators with the functional authority to add, delete, divide or merge data items. Finally, the shoulder-shell material conversion module 18 receives the master data file from the input module i 1, and retrieves the second reference U data from the reference file storage module 14. The change module 18 is used according to The second reference file converts the shellfish in the main shell material file from the first computer 20 to the second computer 30, so that
第19頁 567422 五、發明說明(14) 使於該第二電 料檔中每一個 個項目、每一 目所對應的第 如之前所 二讀的安排',在該 ;係。因 :間係存有一階 二參照檔皆存 圣資料檔所 ή ‘委. 腦3 0内已 次資料檔 個項目所 二資料格 述,若干 主資料檔 於 轉換的 内之資 對應的 式做排 大型主 之多個 具體實 该描述 關係。 個次資 ,該主 VSAM 檔 多個資 施例中 之間的 層關係 多個次 可以對 發明之 料轉換 檔從圖 再次強 檔中之 主資料檔所 料係依照個 第二資料型 列。 機對該主資 次資料檔之 施例中,該 檔、該第一 經該資料轉 料槽之間同 資料檔係為 包含的多個次資 次資料檔之複數 態以及每一個項 料檔之檔案結構 間存有〜階層關 多個次資料檔之 參照檔以及該第 換模組1 8所轉換 樣存有該階層關 一 DL/1檔,並且 此,於另' 較佳 層關係。 有該階層 包含的多 實施例中 槽係為一 改存於該 佳具體實 次資料檔 動後之階 所包含的 ,管理者 具體 R係 每一個次資料 午者 性 as 換 層 層 轉 流 換 資 為 ,於 地對 檔係 之主 關係 關係 以 換系 程係 至該 料檔 提供更 另一較 該多個 存有變 資料檔 。亦即 對變動 下將詳 統1 0所 用以將 第二電 ,該多 、調整。 述根據本 執行的資 —主資料 腦3 〇。需 個次資料 料檔之間的階層關係給管理 ,該編輯模組1 6進一步選擇 1¾層關係做變動。該第二參 ’經该資料轉換模組1 8所轉 資料檔之間存有變動後之階 該多個次資料檔彼此間的階 第二較佳具體實施例之資料 處理流程。該資料轉換處理 一中所示之該第一電腦2 〇轉 °周’ 5亥主資料檔包含多個次 母個次資料檔係包含依據Page 19 567422 V. Description of the invention (14) The second reading arrangement corresponding to each item and each item in the second electronic file is here. Because: there is a first-level second reference file that stores all the data files in the sacred data file, and the data description of the second data file in the brain 30, and some master data files are converted in the corresponding format A number of large-scale masters specifically implement this description relationship. The secondary data, the layer relationship between the multiple VAM files in the multiple embodiments, multiple times can be used to transform the material of the invention, and the main data file in the secondary file is again based on a second data type. In the embodiment of the main secondary data file by the machine, the file, the same data file between the first data transfer tank and the secondary data file are plural states of each secondary data file and each item data file. Among the file structures, there are ~ reference files of multiple levels of hierarchical data files, and the sample converted by the first module 18 contains a DL / 1 file of the hierarchical levels, and in this case, the relationship is better in another layer. In the multiple embodiments included in this hierarchy, the slot system is included in a stage that is modified and stored in the specific real-time data file, and the manager's specific R is the nature of each secondary data. For the main relationship between the local and the file system, the system can be changed to the material file to provide another file than the multiple stored data files. That is to say, the changes will be detailed in the system 10, which will be used to adjust the second power. This paper describes the resources that are implemented in accordance with this master data. Need to manage the hierarchical relationship between the data files. The editing module 16 further selects 1¾ layer relationships to change. The second parameter ′ has a changed stage between the data files transferred by the data conversion module 18, and the stages of the multiple secondary data files are related to each other. The data processing flow of the second preferred embodiment. The data conversion process shown in the first computer is 20 rpm. The week ’s primary data file contains multiple primary and secondary secondary data files.
第20頁 567422 五、發明說明(15) _^ 複 複 數個項目做排列之資料,於每一 數個項目中每一個項目内之二料檔内安置於該 料型態以及一個別的第一資料格’、/、有一個別的第一資 以及所有的第-資料格式係為該;m第-〒料型態 為該第二電腦30所能判讀。一 ρ 尚20可判讀’但不 20並且描述每一個次資料權之J二二=錯存於該第一電腦 應的第一資料型態與第一資料^個f目的定義以及相對 提供,並且定義於該第-電腦20:該第預③參考檔係事先 資料型態及各類資料格式轉換的0規;:弟-電腦3〇之間各類 «,"4 請.參照第三圖所示,首弈抽—本碰 月^處20掏取該描述檔。 執仃乂驟S60,從該第一電 所健步:二根據該預定參考構,對該描述播 有的第-資料格式做語音分β斤:=—資料型態以及所 讀第一參照矜将勺八—析,進而產生一第一參照檔。 義、每-;固:資ϋ:::次資料檔之複數個項目的定 數個中繼資料格1r ^1 ,複數個中繼資料型態以及複 二電腦30可判讀",並雍每一個中繼資料型態係為該第 料型態中之一個楚ΐ i應該個次資料檔之複數個第一資 該第二電腦30可刹一貝料型態,每一個中繼資料格式係為 〜資料格式中之,Γ楚並且對應該個次資料檔之複數個第 八〒之一個第—資料格式。 檔之複I Ϊ ΐ Γί S’,擇性地修改對應每-個次資料 修改成為複數i;:及複數個中繼資料格式,進而 第一貝枓型態以及複數個第二資料格式,Page 20 567422 V. Description of the invention (15) _ ^ A plurality of items are arranged in the data, and the two types of materials in each of the items are placed in the material type and one other first. The data cell ', /' has an individual first asset and all the first data formats are for this; the m-th data type is readable by the second computer 30. A ρ still 20 can be interpreted 'but not 20 and describe each secondary data right J = 22 = the first data type and the first data that are misstored in the first computer should be defined and provided relative to each other, and Defined in this computer-20: This reference ③ reference file is the 0 rule for the conversion of the type of data in advance and the format of various types of data; As shown, the first game draw-this month ^ at 20 to get the description file. Perform step S60, and take a step from the first power station: Second, according to the predetermined reference structure, make a voice analysis of the first-data format that the description broadcasts. Β =: data type and the first reference read. Spoon eight-analysis, which in turn generates a first reference file. Meaning, each-; solid: asset ::: fixed number of metadata cells 1r ^ 1 of multiple items of the secondary data file, multiple metadata types and multiple computers 30 can read ", and Yong Each metadata type is one of the first data types. I should have multiple first data files. The second computer 30 can use one data type. Each metadata format It is one of the ~ data formats, and it corresponds to one of the first eighth data files of the multiple data files. File complex I Ϊ ΐ Γί S ’, selectively modify the corresponding data every time to modify the plural i ;: and multiple metadata formats, and then the first type and multiple second data formats,
第21頁 567422 五、發明說明(16) ίίΐϊ二第二參照檔。該第二參照檔係包含每一個次資 徊二-1极固^目的定義 '每一個次資料檔所對應的複數 第二、貝料f態以及複數個第二資料格式,其中,每一個 ΐ +1 i料里心係為該第二電腦3 〇可判讀’並且對應該個次 斗標數個第一資料型態中之一個第一資料型態,每 『個第一 ^料格式係為該第二電腦3 〇可判讀,並且對應該 僻次資料檔之複數個第一資料格式中之一個第一資料格 式。 、Page 21 567422 V. Description of the invention (16) ί ΐϊ Second reference file. The second reference file contains a definition of each secondary data, which is a -1 pole. The purpose of each secondary data file is a plurality of second data formats, a plurality of second data formats, and a plurality of second data formats. +1 i is the first data type of the second computer 3 0, which can be interpreted by the second computer, and corresponds to one of the first data types of each of the first and second data types. The second computer 30 can read and correspond to one of the first data formats of the plurality of first data formats. ,
l.L - 最後執行步騍S66,根據該第二參照檔,將該主資料 檔内之資料從該第一電腦20轉換至該第二電腦30,致使於 料f,二1電腦3 0内已轉換的主資料檔所包含的多個次資料檔 f每一個次資料檔内之資料係依照個次資料檔之複數個項 ^ 、每一個項目所對應的第二資料型態以及每一個項目所 鉍應的第二資料格式做排列。 經應用本發明將資料有效率的轉換後,更有利於後續 的應用。如第四圖所示,該第二電腦3 〇係一資料倉儲系統 的範例,連接該資料倉儲系統3 0之後續應用伺服器或工作 站之範例包含第四圖中所示的資料採擷工作站3 2 1、中間 層(Middle tier)伺服器3 2 2、CRM前端伺服器3 2 3、 OLAP(On—line analytical processing)伺月艮器 324、 A d - h 〇 c Q u e r y報告產生工作站3 2 5以及EIS(Execution i n s t r u c t i ο n s e t s )工作站3 2 6等。以利現行對開放式平台 上之資料的詳加運用,例如,資料採擷(Data Mining)、 決策主管資訊系統(Executive Information System)、lL-finally execute step S66, and according to the second reference file, the data in the master data file is converted from the first computer 20 to the second computer 30, so that the material f, the two computers 30 have been converted The primary data file contains multiple secondary data files. The data in each secondary data file is based on the multiple items in the secondary data file ^, the second data type corresponding to each item, and the bismuth in each item. The second data format should be arranged. After applying the present invention to efficiently convert data, it is more beneficial to subsequent applications. As shown in the fourth figure, the second computer 30 is an example of a data warehouse system. An example of a subsequent application server or workstation connected to the data warehouse system 30 includes the data acquisition workstation 3 2 shown in the fourth diagram. 1. Middle tier server 3 2 2. CRM front-end server 3 2 3. OLAP (Online analytical processing) server 324, A d-h 〇c Q uery report generation workstation 3 2 5 And EIS (Execution instructi ο nsets) workstations 3 2 6 and so on. In order to facilitate the detailed application of the data on the open platform, such as Data Mining, Executive Information System,
第22頁 567422 五、發明說明(17)Page 22 567422 V. Description of the invention (17)
Web版遠程報表與動態報表、行銷企劃人員即興式查詢 (Ad- hoc Query)、多管道服務傳遞系統(Mult i-Channel ) 以及與 CRM前端系統整合(CTI,Sales Force Automatin、 等等運用。 10 』 *丹二人強調,先則技術於不相谷地腦系統間轉換資 ,必須分別於兩不相容的電腦系統上撰寫轉換程式貝 ^地,轉換的過程複雜、處理能量小,並且會耗掉 辦換資料檔之原電腦系統的運算能量。相形之下, = 發明轉換資料檔,轉換過程簡單、處理能量大,7 嚷根據本發明之資料轉換系統内處理,不會耗掉儲 f ^料檔之原電腦系統的運算能量。 ·子欲轉 手色 為更加突顯先前技術與採用本發明所需成太^ S|相當大的落差,以下將藉由金融業於費存 。:1平台間轉換資料的實例詳加解說。 序將兩種作法對所需撰寫的程式以較 =3,力經費以及維護人力之估ί上出/ )、 2用先則技術與應用本發明所花費轉換 错以比較 本。由第—表所列出的數據,、砧=以及人力成 換’與先前技術比較,免看:應用本發明 人力的而求,可以大幅卢 ’、’耘式工程師大量 ί地縮短轉換時程。由:更力本,並且可以大幅 地,本發明所提供之資料轉換明的實用性。明顯 ϊ: 卜j f _ β 步性’完全符合專利申請要件差=極具新類性及進 麦依專利法提出申請,懇Web version of remote reports and dynamic reports, marketing planners' ad-hoc query, multi-channel service delivery system (Mult i-Channel), and integration with CRM front-end systems (CTI, Sales Force Automatin, etc.) 10 "Dan emphasized that the conversion technology between the inferior brain system and the first technology must be written on two incompatible computer systems. The conversion process is complicated, the processing energy is small, and it consumes a lot of energy. The computational energy of the original computer system to change the data file. By contrast, = the invention converts the data file, the conversion process is simple, the processing energy is large, 7 处理 the data conversion system according to the present invention is processed in the system and does not consume storage f ^ The computing energy of the original computer system of the material file. · The desire to change hands is to highlight the gap between the previous technology and the adoption of the present invention. It is a considerable gap. The following will be financed by the financial industry .: 1 platform An example of converting data will be explained in detail. Preface compares the two methods to the required writing program with a cost of 3 and an estimate of the cost of maintenance and manpower. (2) The use of prior technology and the application of the present invention Wrong to compare this conversion fee. According to the data listed in the first table, compared with the prior art, the anvil = and manpower conversion are compared with the previous technology, and it is unnecessary to look at it: the application of the manpower of the present invention can greatly reduce the conversion time by a large number of engineers. . Reason: more effort, and can greatly improve the practicality of the information provided by the present invention. Obvious ϊ: bu j f _ β Stepping ’fully meets the requirements of patent application Poor = very new and advanced
567422 五、發明說明(18) 請詳查並賜准本案專利,以保障發明人之權益。 藉由以上較佳具體實施例之詳述,係希望能更加清楚 描述本發明之特徵與精神,而並非以上述所揭露的較佳具 體實施例來對本發明之範疇加以限制。相反地,其目的是 希望能涵蓋各種改變及具相等性的安排於本發明所欲申請 之專利範圍的範疇内。因此,本發明所申讀之專利範圍的 II疇應該根據上述的說明作最寬廣的解釋,以致使其涵蓋 暴翁有可能的改變以及具相等性的安排。567422 V. Description of the invention (18) Please check and grant the patent in this case in order to protect the rights of the inventor. With the above detailed description of the preferred embodiments, it is hoped that the features and spirit of the present invention may be more clearly described, rather than limiting the scope of the present invention with the preferred specific embodiments disclosed above. On the contrary, it is intended to cover various changes and equivalent arrangements within the scope of the patents to be applied for in the present invention. Therefore, the II domain of the patent scope of the present invention should be interpreted in the broadest sense according to the above description, so that it covers the possible changes and equivalent arrangements of the tyrant.
567422 圖式簡單說明 五、圖示簡單說明 第一圖係示意地揭示根據本發明之第一較佳具體實施 例的資料轉換系統1 0。 第二圖係為揭示根據本發明之第一較佳具體實施例之 資料轉換處理流程。 第三圖係為揭示根據本發明之第一較佳具體實施例之 凟料轉換處理流程。 /' |/· 第四圖係繪示應用本發明將資料轉換後之後續應用的 範例。 I If 、圖示標號說明 4提之 10 資 料 轉 換 系 統 12 語 意 分 析 模 組 16 編 輯 模 組 18 資 料 轉 換 模 組 30 第 二 電 腦 321- -326 應 用 伺 服 器 或 工 S50- -S56 資 料 轉 換 流 程 之 S60- -S66 : :資 料 轉 換 流 程 之 作站 步驟 步驟 11 輸 入 模 組 14 參 昭 檔 儲 存模組 162 操 作 介 面 20 第 一 電 腦 40 操 作 端 電 腦 容 是 否 浓:567422 Brief description of diagrams 5. Brief description of diagrams The first diagram schematically illustrates a data conversion system 10 according to a first preferred embodiment of the present invention. The second figure is a data conversion processing flow according to the first preferred embodiment of the present invention. The third figure is a flowchart for explaining the conversion process of the material according to the first preferred embodiment of the present invention. / '| / · The fourth figure shows an example of subsequent applications after data is converted by applying the present invention. I If 、 Illustration of label description 4 mentioned 10 Data conversion system 12 Semantic analysis module 16 Editing module 18 Data conversion module 30 Second computer 321-232 Application server or S50-S56 S60 of data conversion process --S66:: Steps in the step of data conversion process Step 11 Input module 14 Reference file storage module 162 Operation interface 20 First computer 40 Operator terminal computer capacity is rich:
II
iEiE
第25頁Page 25
Claims (1)
Priority Applications (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW91104483A TW567422B (en) | 2002-03-11 | 2002-03-11 | System and method for effectively transferring heterogegeous data between incompatible computers |
Applications Claiming Priority (1)
Application Number | Priority Date | Filing Date | Title |
---|---|---|---|
TW91104483A TW567422B (en) | 2002-03-11 | 2002-03-11 | System and method for effectively transferring heterogegeous data between incompatible computers |
Publications (1)
Publication Number | Publication Date |
---|---|
TW567422B true TW567422B (en) | 2003-12-21 |
Family
ID=32502532
Family Applications (1)
Application Number | Title | Priority Date | Filing Date |
---|---|---|---|
TW91104483A TW567422B (en) | 2002-03-11 | 2002-03-11 | System and method for effectively transferring heterogegeous data between incompatible computers |
Country Status (1)
Country | Link |
---|---|
TW (1) | TW567422B (en) |
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7583664B2 (en) | 2004-12-28 | 2009-09-01 | Michael Ho | Techniques for transmitting and receiving traffic over advanced switching compatible switch fabrics |
TWI384373B (en) * | 2008-12-15 | 2013-02-01 | Syscom Comp Engineering Co | Message-oriented routing system |
-
2002
- 2002-03-11 TW TW91104483A patent/TW567422B/en not_active IP Right Cessation
Cited By (2)
Publication number | Priority date | Publication date | Assignee | Title |
---|---|---|---|---|
US7583664B2 (en) | 2004-12-28 | 2009-09-01 | Michael Ho | Techniques for transmitting and receiving traffic over advanced switching compatible switch fabrics |
TWI384373B (en) * | 2008-12-15 | 2013-02-01 | Syscom Comp Engineering Co | Message-oriented routing system |
Similar Documents
Publication | Publication Date | Title |
---|---|---|
CN107402976B (en) | Power grid multi-source data fusion method and system based on multi-element heterogeneous model | |
CN103309904A (en) | Method and device for generating data warehouse ETL (Extraction, Transformation and Loading) codes | |
JP2002297883A (en) | Knowledge information control method, knowledge information generating method, knowledge information using method, and knowledge information managing device | |
CN114416855A (en) | Visualization platform and method based on electric power big data | |
CN112651218A (en) | Automatic generation method and management method of bidding document, medium and computer | |
CN106447550A (en) | MySQL based real estate sales management system | |
CN109902117A (en) | Operation system analysis method and device | |
CN106528898A (en) | Method and device for converting data of non-relational database into relational database | |
CN104731606A (en) | System and method based on identification grasping technology to achieve enterprise application integration management | |
CN114218218A (en) | Data processing method, device and equipment based on data warehouse and storage medium | |
CN108363782A (en) | A kind of data cleaning method and Data clean system | |
CN111382149A (en) | Financial data analysis system and method | |
CN112214453A (en) | Large-scale industrial data compression storage method, system and medium | |
Habich et al. | BPEL DT—data-aware extension for data-intensive service applications | |
TW567422B (en) | System and method for effectively transferring heterogegeous data between incompatible computers | |
Baliyan et al. | Towards software engineering paradigm for software as a service | |
Duan | Analysis of ERP enterprise management information system based on cloud computing mode | |
CN107505852B (en) | Method for constructing cloud manufacturing service description file containing simulation information | |
CN113515515B (en) | Method, device, equipment and medium for fusing customer data and power grid equipment data | |
CN114817226A (en) | Government data processing method and device | |
CN115914379B (en) | Data exchange device and data exchange system | |
Akila et al. | Onotology-based service discovery for intelligent Big Data analytics | |
CN108959449A (en) | A method of it is mapped based on visio batch configuration infa | |
Tang | Construction and Application of Big Data Marketing System of Tourism Economy Based on Hadoop Framework | |
Liu et al. | Research on Enterprise Financial Management System Based on Big Data Hadoop |
Legal Events
Date | Code | Title | Description |
---|---|---|---|
GD4A | Issue of patent certificate for granted invention patent | ||
MM4A | Annulment or lapse of patent due to non-payment of fees |