TWI385543B - Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format - Google Patents

Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format Download PDF

Info

Publication number
TWI385543B
TWI385543B TW98116337A TW98116337A TWI385543B TW I385543 B TWI385543 B TW I385543B TW 98116337 A TW98116337 A TW 98116337A TW 98116337 A TW98116337 A TW 98116337A TW I385543 B TWI385543 B TW I385543B
Authority
TW
Taiwan
Prior art keywords
data
intermediary
data object
format
module
Prior art date
Application number
TW98116337A
Other languages
Chinese (zh)
Other versions
TW201042470A (en
Original Assignee
Chunghwa Telecom Co Ltd
Priority date (The priority date 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 date listed.)
Filing date
Publication date
Application filed by Chunghwa Telecom Co Ltd filed Critical Chunghwa Telecom Co Ltd
Priority to TW98116337A priority Critical patent/TWI385543B/en
Publication of TW201042470A publication Critical patent/TW201042470A/en
Application granted granted Critical
Publication of TWI385543B publication Critical patent/TWI385543B/en

Links

Description

以目錄服務格式建立中介資料的資料同步系統與方法Data synchronization system and method for establishing intermediary data in directory service format

本發明係關於一種資料同步中介資料建立與轉換之系統及方法,特別為一種異質資料儲存體之間的資料等化為比對資料、並識別資料差異特性的系統及方法。The invention relates to a system and method for establishing and converting data synchronization intermediary data, in particular to a system and method for comparing data between heterogeneous data storages into comparative data and identifying different characteristics of the data.

目前政府、企業、及各組織團體電子化的發展,使組織內外建置的資訊系統與平台日漸增多,各資訊系統與平台使用不同型式的資料庫、目錄、檔案等儲存體來儲存重要資訊,而由於組織內部、跨組織電子化服務整合並提升更多元範疇服務已成為必然趨勢,資訊平台間組織、人員等共通資料的資料同步需求也受重視。就宏觀來看,資料同步應建立比對用中介資料,透過中介資料與來源目的資料間差異進行處理,使資料同步系統或程式以良善的中介資料管理並轉換為各平台所需之同步資料,並將同步資料儲存於各資料儲存體以供應擴充應用。但就實務上而言,各平台間同步有不同服務模式、不同資料處理規則、不同作業系統環境、以及建置於不同資料儲存體之上,其同步來源端、目的端之間同步時比對資料轉化與建立無可依循方法,建置人員甚至常不重視中介資料建立,直接建立再利用性低且擴充困難的程式程序進行資料來源間的比對異動,因此,良善的中介資料建立與轉換系統即成為組織間異質資料同步系統或方法迫切需要的關鍵。At present, the development of electronicization of government, enterprises and various organizations has led to an increase in the number of information systems and platforms built within and outside the organization. Information systems and platforms use different types of databases, catalogues, archives and other storage to store important information. As the integration of internal and inter-organizational electronic services and the promotion of more meta-category services have become an inevitable trend, the information synchronization needs of common information such as organizations and personnel of information platforms are also valued. On the macro level, data synchronization should establish comparative mediation data, and handle the differences between the mediation data and the source data, so that the data synchronization system or program can be managed and converted into the synchronization data required by each platform. And store the synchronized data in each data storage to supply the extended application. However, in practice, each platform synchronizes with different service modes, different data processing rules, different operating system environments, and built on different data storages. When the synchronization source and destination are synchronized, the comparison is made. There is no way to follow the data conversion and establishment. The construction personnel often do not pay much attention to the establishment of intermediary data, and directly establish a program with low reusability and difficulty in expansion to compare the data sources. Therefore, the establishment of good intermediary data The conversion system is the key to the urgent need for a heterogeneous data synchronization system or method between organizations.

不同的資料儲存體,由於資料定義方式、儲存方式與取出方式等模式皆不相同,因此中間如何定義一資料儲存體中的資料,經由處理後存放於另一資料儲存體中,很難以一統一的規則描述;這類資料同步需求,一般常以設計者自行推演所構建的程式來處理,或透過中介層建立中介資料處理:Different data storages are different in terms of data definition, storage method and retrieval method. Therefore, how to define the data in a data storage medium and store it in another data storage is difficult to be unified. Rule description; such data synchronization requirements are usually handled by the designer's own derivation of the built program, or through the intermediary layer to establish intermediary data processing:

一、自行推演所構建的程式做資訊同步程序:其程序間不含中介資料或僅有少量自行定義的中介物件,這些程式除建置品質難以管控外,又常因如客戶表達不清、專業領域不熟悉、溝通認知差異等非技術性問題遺漏應描述的項目或屬性,更使得已缺乏共通性的程式更彈性不足、難以擴充與再利用。1. The program built by the self-derivation program is used to synchronize the program: the program does not contain mediation data or only a small number of self-defined mediation objects. These programs are difficult to control except for the quality of the built-in products. Non-technical problems such as unfamiliar areas, communication differences, and other missing items should describe the items or attributes that should be described, and make the programs that lack commonality more flexible, difficult to expand and reuse.

二、XML自訂中介處理或DSML資料交換標準:有建立資料交換中介資料的程序,常以自訂描述的XML或符合目錄交換標準的DSML來制訂中介資料或資料交換檔,自訂描述的XML受限於開發者觀點難以普遍參照,而DSML則處理與描述複雜不易建構。Second, XML custom intermediary processing or DSML data exchange standards: There are procedures for establishing data exchange intermediary materials, often with custom description of XML or DSML in accordance with the directory exchange standard to develop intermediary data or data exchange files, custom description of XML Limited to the developer's point of view is difficult to universally refer to, while DSML is complex and difficult to construct.

三、資料庫作為中介資料儲存轉換處理:即令以資料庫作為中介資料處理,其表格、欄位等定義皆由設計者自行決定,因此亦有受限於開發者觀點難以普遍參照的缺點,且針對若來源、目的為目錄服務伺服器的資料同步,目前無標準作法唯有實施許多轉換方有可能將資料庫作為中介資料處理程序。3. The database is used as an intermediary data storage conversion process: the database is treated as an intermediary data, and the definitions of tables and fields are determined by the designer. Therefore, there are also disadvantages that are difficult to be widely referenced by the developer's point of view. For the data synchronization of the source and destination directory server, there is currently no standard practice. It is possible to implement the database as an intermediary data processing program.

因此,需要一種異質資料同步時中介資料建立與轉換的方法,用以解決異質資料儲存體如目錄服務、資料庫與檔案等,其間相互資料同步時中介資料比對處理的問題。目錄服務標準以物件來描述資料,使得資料若需擴充時可以利用物件繼承概念予以擴充,而對資料異動透過物件方式處理易於新增、修改、刪除,管理嚴謹且複雜度低,且目錄服務對於組織、人員、網路使用者等常需共用的資料,有多樣物件類別描述,各類別、屬性描述完整且又符合國際標準;且若能建立中介資料物件,即能透過查詢介面觀測中介資料物件內容值,在資料同步作業完成前可預先修正,避免錯誤資料寫入資料儲存體,強化同步作業的管理。本系統即以目錄服務標準的資料描述格式建立中介資料物件,設計資料同步時中介資料建立與資料轉換系統。Therefore, there is a need for a method for establishing and converting intermediate data when heterogeneous data is synchronized, which is used to solve the problem of heterogeneous data storage such as directory services, databases and archives, and the intermediate data is processed during the synchronization of mutual data. The directory service standard describes the data by object, so that if the data needs to be expanded, it can be expanded by the concept of object inheritance, and the data transfer through the object processing is easy to add, modify, delete, manage strict and low complexity, and the directory service is Organizations, personnel, Internet users, etc. often need to share information, there are a variety of object descriptions, each category, attribute description is complete and in line with international standards; and if an intermediary data object can be established, the intermediary information object can be observed through the query interface The content value can be pre-corrected before the data synchronization job is completed, to prevent the error data from being written into the data storage, and to strengthen the management of the synchronization operation. The system establishes an intermediary data object in the data description format of the directory service standard, and establishes an intermediary data creation and data conversion system when the data is synchronized.

由此可見,上述習用方式仍有諸多不足,實非一良善之設計,而亟待加以改良。It can be seen that there are still many shortcomings in the above-mentioned methods of use. It is not a good design and needs to be improved.

本案發明人鑑於上述習用方式所衍生的各項缺點,乃亟思加以改良創新,並經多年苦心孤詣潛心研究後,終於成功研發完成本件以目錄服務格式建立中介資料的資料同步系統與方法。In view of the shortcomings derived from the above-mentioned conventional methods, the inventor of the present invention has improved and innovated, and after years of painstaking research, he finally succeeded in researching and developing the data synchronization system and method for establishing intermediary materials in the directory service format.

本發明之目的即在於提供一種以符合目錄服務資料格式的中介資料物件,來處理異質資料同步的系統;其可對不同之資料儲存體,建立中介資料物件與需異動之資訊差異,此差異資訊不限於儲存於特定資料儲存體,可為檔案、資料庫或目錄,使同步軟體、程式等任何需進行資料同步之程序可取得異動資料資訊,並完成同步作業。The object of the present invention is to provide a system for processing heterogeneous data synchronization by using an intermediary data object conforming to the directory service data format; it can establish an information difference between the intermediary data object and the transaction to be changed for different data storage bodies. It is not limited to being stored in a specific data storage, but can be a file, a database or a directory, so that any program that needs to synchronize data, such as synchronization software and programs, can obtain the information of the transaction and complete the synchronization operation.

本發明之次一目的係在於提供一種異質資料同步中介資料轉換的系統及方法,以目錄服務資料格式建立資料同步專用的中介資料物件,此中介資料物件不限於儲存於特定資料儲存體,可為檔案、資料庫或目錄,使由一資料儲存體取得異動資料資訊後,其可依據不同的來源連結將等化的中介資料進行轉換,將資料寫入至另一資料儲存體上。The second object of the present invention is to provide a system and method for data conversion of heterogeneous data synchronization mediation, and to establish an intermediary data object dedicated to data synchronization in a directory service data format, the mediation data object is not limited to being stored in a specific data storage, Archives, databases or catalogues enable a data repository to obtain transactional information, which can be converted according to different sources and converted into intermediate data.

達成上述目的之資料同步中介資料與轉換的系統,係建置一資料同步伺服器來轉換各資料來源伺服器資料成中介資料物件,並於處理後產生資料異動資訊物件,作為寫入資料目的伺服器之依據。其中該「轉換中介資料物件同步伺服器」包括有:一資料連結與物件轉換模組,用於連結各來源、目的資料伺服器,並將資料轉換為中介資料格式的資料物件;一個中介資料轉換模組,提供中介資料物件格式給資料連結模組參照,並依設定將各資料物件轉換、內容運算、將需同步的資料物件等化為中介資料物件;一個差異資料異動模組,將資料連結模組轉換的資料物件內容值異動成與中介資料物件相同,並標示需進行異動的資料物件;一資料輸出模組,將需異動的資料物件,依目的資料伺服器的資料型態,將資料異動至目的資料伺服器;一中介資料物件設定模組,用於以目錄服務格式設定與儲存資料同步中介資料物件資訊;一查詢中介資料查詢介面,用於方便查詢中介資料當前內容值;一資料物件儲存庫,用於儲存各連結資料伺服器的連結資料物件、中介資料物件、以及作為異動處理用途的差異資料物件。The system for synchronizing the mediation and conversion of data for the above purposes is to establish a data synchronization server to convert the data of each source server into an intermediary data object, and generate a data transaction object after processing as a server for writing data. The basis of the device. The "conversion mediation data object synchronization server" includes: a data link and object conversion module for linking each source and destination data server, and converting the data into an information file in an intermediary data format; an intermediary data conversion The module provides an intermediary data object format for reference to the data link module, and converts each data object, content calculation, and the data object to be synchronized into an intermediary data object according to the setting; a difference data transaction module connects the data The content value of the data object converted by the module is the same as the mediation data object, and indicates the data object that needs to be changed. A data output module will change the data object according to the data type of the destination data server. Transaction-to-destination data server; an intermediary data object setting module for synchronizing and storing data in the directory service format to synchronize mediation object information; a query intermediary data query interface for conveniently querying the current content value of the mediation data; Object repository for storing linked data of each linked data server Intermediary data objects, as well as differences in the use of data objects as the transaction processing.

本發明還提供有一種用於異質資料同步的中介資料建立與轉換方法,其步驟包括:The invention also provides a method for establishing and converting mediation data for heterogeneous data synchronization, the steps of which include:

步驟1:依目錄服務格式設定中介資料物件格式,包含物件類別、屬性與同步識別鍵設定;Step 1: Set the mediation data object format according to the directory service format, including object category, attribute and synchronization identification key setting;

步驟2:資料同步伺服器與來源、目的資料伺服器連接後,參考中介資料物件格式設定,轉換資料來源儲存體之資料為同於中介資料物件格式之連結資料物件;Step 2: After the data synchronization server is connected with the source and destination data servers, refer to the mediation data object format setting, and convert the data source storage object to the linked data object in the same format as the intermediary data object;

步驟3:檢查連結資料物件是否有對應的中介資料物件存在並予新增,以及檢查代表同一資料物件多個連結資料物件,將這些連結資料物件對應至同一已存在的中介資料物件;Step 3: Check whether the linked data object has the corresponding intermediary data object and add it, and check the multiple linked data objects representing the same data object, and map the linked data objects to the same existing intermediary data object;

步驟4:處理連結資料物件與中介資料物件的差異資料,並將最終結果存放於中介資料物件,且一致化所有連結資料物件的內含值,內容有異動的連結資料物件並予以標示;Step 4: Process the difference data between the linked data object and the intermediary data object, and store the final result in the intermediary data object, and unify the embedded value of all the linked data objects, and the content of the linked data object is marked and marked;

步驟5:資料同步伺服器與目的資料伺服器連接後,呼叫符合資料目的儲存體型態之轉入程式,包括文字格式、XML格式、資料庫格式、目錄資料物件格式,將有異動的連結資料物件透過轉入程式把異動資料更新至目的伺服器上的資料目的儲存體。Step 5: After the data synchronization server is connected with the destination data server, the transfer program conforming to the data storage type of the data destination, including the text format, the XML format, the database format, the catalogue data object format, and the linked data will be changed. The object is updated by the transfer program to the data destination storage object on the destination server.

當多個異質資料儲存體欲qqf相互同步資料時,先建立中介資料可易於識別各來源差異並方便管理,本方法以目錄服務資料格式描述中介資料規格並建立中介同步物件,等化各來源資料連結成中介同步物件資料,且對資料標示其為需新增、需修改、需刪除三種特性,供其他外部資料同步系統或資料同步程式識別來源、目的資料之差異,以完成多方異質資料儲存體之同步。When multiple heterogeneous data storage entities want qqf to synchronize data with each other, first establish intermediary data to easily identify differences and facilitate management. This method describes the intermediate data specifications in the directory service data format and establishes an intermediary synchronization object to equalize the source data. Linked into an intermediary synchronization object data, and the data is marked as need to be added, need to be modified, need to delete three characteristics, for other external data synchronization system or data synchronization program to identify the source and destination data differences to complete the multi-party heterogeneous data storage Synchronization.

請參閱圖一所示,為本發明以目錄服務格式建立中介資料的資料同步系統之系統實施之網路環境示意圖,主要包括:Please refer to FIG. 1 , which is a schematic diagram of a network environment of a system for implementing a data synchronization system for establishing an intermediary data in a directory service format according to the present invention, which mainly includes:

一電腦網路1,係為供電腦以實體連線、無線或混合傳輸媒體連線的方式相互傳輸資料之通信實施,可包含多個網路節點,對熟習此技藝者而言,其中可包括多種網路管理裝置,如無線網路存取點(Access point)、集線器(hub)、橋接器(bridge)、路由器(router)、交換器(switch)或其他用以處理網路通訊之裝置,並為來源資料伺服器2、轉換中介資料物件同步伺服器3、目的資料伺服器4相互連接之媒介;A computer network 1 is a communication implementation for transmitting data to and from a computer in a physical connection, wireless or hybrid transmission medium connection, and may include multiple network nodes, which may be included by those skilled in the art, which may include Multiple network management devices, such as wireless access points, hubs, bridges, routers, switches, or other devices used to handle network communications. And is a medium for connecting the source data server 2, the conversion intermediary data object synchronization server 3, and the destination data server 4;

一來源資料伺服器2,係有一個或一個以上來源資料儲存體,並透過電腦網路1將來源資料傳至轉換中介資料物件同步伺服器3以進行轉換,其中來源資料伺服器2接收之來源資料,其資料儲存體之格式可為資料庫、目錄服務或檔案;The source data server 2 has one or more source data storage bodies, and transmits the source data to the conversion intermediary data object synchronization server 3 through the computer network 1 for conversion, wherein the source data server 2 receives the source. Information, the format of which may be a database, a directory service or a file;

一轉換中介資料物件同步伺服器3,係透過電腦網路1接收來源資料伺服器2傳輸資料,用以將來源資料轉換為中介資料,並紀錄物件異動資訊,並將其處理後把異動資料依目的伺服器資料伺服器對資料儲存型態透過電腦網路1寫入資料目的伺服器;A conversion intermediary data object synchronization server 3 receives data from the source data server 2 through the computer network 1 to convert the source data into intermediary data, and records the object transaction information, and processes the transaction data according to the transaction data. The destination server data server writes a data destination server to the data storage type through the computer network 1;

一目的資料伺服器4,係透過電腦網路1接收轉換中介資料物件同步伺服器3所轉換之異動資料,並轉換成一個或一個以上目的資料儲存體,其資料儲存體之格式可為資料庫、目錄服務或檔案,使各資料儲存體之資料同步。The data server 4 of the destination receives the transaction data converted by the conversion intermediary data object synchronization server 3 through the computer network 1, and converts the data into one or more destination data storages, and the data storage body can be in the format of the data library. , directory service or file to synchronize the data of each data store.

請參閱圖二所示,為本發明以目錄服務格式建立中介資料的資料同步系統之中介資料物件同步伺服器架構圖,主要包括:Please refer to FIG. 2, which is an architecture diagram of an intermediary data object synchronization server of a data synchronization system for establishing an intermediary data in a directory service format according to the present invention, which mainly includes:

一中介資料物件設定介面31,係針對資料物件格式提供介面,使中介資料物件設定模組32以符合目錄服務描述物件格式;An intermediary data object setting interface 31 provides an interface for the data object format, so that the intermediary data object setting module 32 conforms to the directory service description object format;

一中介資料物件設定模組32,係將中介資料物件設定介面31所輸入的資料,以符合目錄服務描述物件格式,以設定同步用中介資料物件格式,制訂完成的物件格式規範提供資料連結與物件轉換模組33、中介資料轉換模組34、以及差異資料異動模組35作為轉換資料物件之參照;An intermediary data object setting module 32 is configured to match the data input by the intermediary data object setting interface 31 to conform to the directory service description object format, to set the synchronization intermediary data object format, and formulate the completed object format specification to provide data link and object. The conversion module 33, the mediation data conversion module 34, and the difference data transaction module 35 are used as reference for converting the data object;

一資料連結與物件轉換模組33,係可以連結資料來源伺服器群組,亦即可連結多個資料來源伺服器,針對不同資料來源的資料儲存體型式,對應中介資料物件設定模組32的物件格式規範,將資料轉換成資料物件,並將資料物件歸類於連結資料物件,儲存於資料物件儲存庫37連結區;例如:資料來源為檔案者,以指定分隔符號將每筆資料解析,依物件格式規範將每筆資料轉成一資料物件,物件有多項屬性儲存每筆資料內容值,再將每筆資料物件儲存於連結資料物件的儲存庫;資料來源為目錄服務者,根據每筆資料的物件類別與屬性值,依物件格式規範將每筆資料轉成一資料物件,來源物件屬性值複製至轉換後的資料物件屬性欄位,並將每筆資料物件儲存於連結資料物件的儲存庫;資料來源為資料庫者,每一資料表(Table)對應物件格式規範的物件名稱,每一資料表欄位對應物件格式規範的屬性,將每一筆資料(Record)轉成資料物件,並將每筆資料物件儲存於連結資料物件的儲存庫;A data link and object conversion module 33 can be connected to a data source server group, or can be connected to multiple data source servers, and corresponding to the media data object setting module 32 for data source types of different data sources. The object format specification converts the data into data objects and classifies the data objects into the linked data objects and stores them in the link area of the data object storage 37; for example, the data source is the filer, and each data is parsed by a specified separator. According to the object format specification, each data is converted into a data object. The object has multiple attributes to store each data content value, and then each data object is stored in a repository of linked data objects; the data source is a directory server, according to each The object category and attribute value of the data, according to the object format specification, each data is converted into a data object, the source object attribute value is copied to the converted data object attribute field, and each data object is stored in the storage of the linked data object. Library; the source of the data is the database, and each data table (Table) corresponds to the object name of the object format specification, each A data sheet field corresponds to the attribute of the object format specification, and each data (Record) is converted into a data object, and each data object is stored in a repository of the linked data object;

一中介資料轉換模組34,其作用在於建立中介資料物件與識別差異資料;當此模組接到來自資料連結與物件轉換模組33的連結資料物件後,先至資料物件儲存庫37中介區找尋其中介資料物件是否存在,若無則參考中介資料物件設定模組32,轉換一份中介資料物件至資料物件儲存庫37的中介區;若接到連結資料物件時發現中介資料物件已存在於資料物件儲存庫37中介區,則依中介資料物件設定模組32的同步鍵值優先權,更新資料物件儲存庫37的中介資料物件,並將連結資料物件是否需異動資訊記錄下來,送至差異資料異動模組35;An intermediary data conversion module 34, the role of which is to establish an intermediary data object and identify the difference data; when the module receives the linked data object from the data link and object conversion module 33, first to the data object repository 37 intermediary area Looking for the existence of the information object, if not, refer to the intermediary data object setting module 32, and convert an intermediary data object to the intermediary area of the data object storage 37; if the connected data object is found, the intermediary data object is already present. The information object storage 37 intermediate area, according to the priority value of the synchronization key value of the intermediary data item setting module 32, the intermediate data object of the data object storage 37 is updated, and whether the linked information object needs to be recorded is sent to the difference. Data transaction module 35;

一差異資料異動模組35,係參考中介資料物件設定模組32的物件格式規範,並收到來自中介資料轉換模組34的需異動資料物件的資訊後,將異動處理資料物件儲存庫37內所有連結資料物件與中介資料物件一致化,並將需異動的資料物件抄錄至資料物件儲存庫37的輸出區,使資料輸出模組36可藉由差異資料異動模組35取得輸出資料物件資訊;A difference data transaction module 35 refers to the object format specification of the mediation data object setting module 32, and receives the information of the transaction data item from the mediation data conversion module 34, and then processes the data object storage library 37. All the linked data objects are consistent with the mediation data objects, and the data items to be changed are copied to the output area of the data object storage 37, so that the data output module 36 can obtain the output data information by the difference data transaction module 35;

一資料輸出模組36,係藉由差異資料異動模組35取得輸出資料物件資訊,資料輸出模組36內含將資料物件轉換為文字檔案、XML檔案、資料庫、目錄四種格式的功能處理,以將輸出資料物件轉為目的資料伺服器群組104裡不同型態資料儲存體可接收之資料格式。A data output module 36 obtains output data object information by using the difference data transaction module 35. The data output module 36 includes function processing for converting the data object into a text file, an XML file, a data library, and a directory. To convert the output data object into a data format that can be received by different types of data storage groups in the destination data server group 104.

一資料物件儲存庫37,係供資料連結與物件轉換模組33儲存資料物件歸類於連結資料物件,供中介資料轉換模組34找尋其中介資料物件是否存在,供差異資料異動模組35將異動的資料物件抄錄至資料物件儲存庫37,及提供中介資料查詢介面38查詢所儲存的資料物件,且該資料物件儲存庫37儲存有來源、中介、輸出三種處理的資料物件,亦可儲存中介資料物件設定模組32制訂完成的物件格式規範與資料同步處理時需存資料,實施儲存體可為資料庫、檔案、目錄三種型式;A data object storage 37 is provided for the data link and the object conversion module 33 to store the data object and categorize the data object for the intermediary data conversion module 34 to find out whether the data object exists therein, and the difference data transaction module 35 The transaction data object is copied to the data object repository 37, and the intermediary data query interface 38 is provided to query the stored data object, and the data object storage 37 stores the source, the intermediary, and the output data, and can also store the mediation. The data object setting module 32 needs to store data when the finished object format specification and the data synchronization processing are completed, and the implementation storage body can be three types of data files, files, and directories;

一中介資料查詢介面38,係提供查詢介面用以查詢資料物件儲存庫37所儲存的資料物件,包含每一筆連結資料物件、中介資料物件、異動輸出資料物件之對應,可便於以查詢資料物件狀態監督資料同步狀態,且資料物件儲存庫37可實施於關聯資料庫、檔案、目錄任一者。An intermediary data query interface 38 is provided with a query interface for querying the data objects stored in the data object repository 37, including the correspondence of each of the linked data objects, the intermediary data objects, and the transaction output data objects, so that the status of the data objects can be easily queried. The data synchronization status is supervised, and the data object repository 37 can be implemented in any of the associated databases, files, and directories.

請參閱圖三所示,為本發明以目錄服務格式建立中介資料的資料同步方法之以目錄服務物件描述設定中介資料物件格式子系統之軟體架構圖,當中介資料物件設定介面31進行制訂中介資料格式物件時,將引動中介資料物件設定模組32,該中介資料物件設定模組32包括有:Please refer to FIG. 3, which is a software synchronization method for establishing an intermediary data in a directory service format according to the present invention. The software structure diagram of the intermediary data object format subsystem is set by the directory service object description, and the intermediary data object setting interface 31 is used to formulate the intermediary information. When the object is formatted, the mediation data object setting module 32 is motivated, and the mediation data object setting module 32 includes:

一目錄服務物件描述樣式庫321,其中目錄服務物件描述樣式庫321內存有完整的目錄服務描述之資料物件式樣,並供中介物件名稱建立模組322取得物件類別與屬性;a directory service object description style library 321, wherein the directory service object description style library 321 stores a complete directory service description data item style, and the intermediary object name creation module 322 obtains the object category and attributes;

一中介物件名稱建立模組322,係可以取得目錄服務物件描述樣式庫321的物件類別與屬性,並予命名以建立中介資料物件規範,例如:當中介資料物件設定介面31欲設定「政府組織」資料物件,介面引動中介物件名稱建立模組322去取得目錄服務物件描述樣式庫321裡組織(Organization)物件類別,此物件類別並依目錄服務標準包含相關如機關名稱等屬性物件提供引用,取出的物件類別可予以自行命名為「政府組織」資料物件,再執行後續物件格式規範設定作業,當中介物件名稱建立模組322完成資料物件命名,則將屬性物件傳入屬性名稱建立模組323;An intermediary object name creation module 322 can obtain the object category and attribute of the directory service object description style library 321 and name it to establish an intermediary data object specification, for example, when the intermediary data object setting interface 31 wants to set up "government organization" The data object, the interface priming the object name creation module 322 to obtain the organization object category in the directory service object description style library 321 , and the object category includes a reference to the attribute object such as the organization name according to the directory service standard, and the extracted item is taken out. The object category can be named as "Government Organization" data object, and then the subsequent object format specification setting operation is performed. When the intermediary object name creation module 322 completes the data object naming, the attribute object is transferred to the attribute name creation module 323;

一屬性名稱建立模組323,係引用中介物件名稱建立模組322傳入的屬性物件,分別命名以建立多個屬性之格式規範;An attribute name creation module 323 refers to the attribute object passed by the intermediary object name creation module 322, and is respectively named to establish a format specification of multiple attributes;

一同步鍵值設定模組324,係引用中介物件名稱建立模組322傳入的屬性物件,並於多個屬性建立之時,指定一個屬性、或多個屬性為同步用識別鍵,並設定該識別鍵資料物件屬性之優先權,此鍵值可為屬性儲存值或多屬性經程式處理計算後之值;資料物件儲存庫37內所有資料物件可透過同步識別鍵所含鍵值,判斷不同資料物件為需要同步的資料物件,並為中介資料物件之屬性決定填入值;A synchronization key value setting module 324 refers to the attribute object passed by the mediation object name creation module 322, and when a plurality of attributes are established, specifies an attribute or multiple attributes as synchronization identification keys, and sets the The priority of the key data object attribute is identified, and the key value can be the value calculated by the attribute storage value or the multi-attribute processed by the program; all the data objects in the data object repository 37 can determine different data by using the key value of the synchronous identification key. The object is a data item that needs to be synchronized, and the value of the attribute of the intermediary data item is determined;

一擴充屬性名稱建立模組325,係引用中介物件名稱建立模組322傳入的屬性物件,並針對制訂目錄服務標準之外的擴充屬性物件格式;An extended attribute name creation module 325 refers to the attribute object passed by the intermediary object name creation module 322, and is configured for an extended attribute object format other than the directory service standard;

一中介資料物件格式儲存模組326,係為最終資料物件格式規範之儲存處理,將屬性名稱建立模組323、同步鍵值設定模組324、擴充屬性名稱建立模組325物件格式規範儲存於資料物件儲存庫37,但不限於資料物件儲存庫37,亦可獨立儲存於中介資料物件設定模組32之資料儲存體,可實施於關聯資料庫、檔案、目錄任一者,並提供給中介資料轉換模組34。An intermediary data object format storage module 326 is a storage process of the final data object format specification, and the attribute name creation module 323, the synchronization key value setting module 324, and the extended attribute name creation module 325 object format specification are stored in the data. The object repository 37, but not limited to the data object repository 37, may be independently stored in the data storage body of the intermediary data object setting module 32, and may be implemented in any associated database, file, directory, and provided to the intermediary material. Conversion module 34.

請參閱圖四所示,係為本發明以目錄服務格式建立中介資料的資料同步方法之流程圖,步驟包括:Please refer to FIG. 4, which is a flowchart of a data synchronization method for establishing an intermediary data in a directory service format according to the present invention, and the steps include:

步驟1:依據資料連結與物件轉換模組33的功能,連結資料來源儲存體並判斷資料類型(401);Step 1: According to the function of the data link and the object conversion module 33, the data source storage body is connected and the data type is determined (401);

步驟2:透過資料連結與物件轉換模組33的功能,將連結資料庫(402)、連接目錄(403)、連接XML檔案(404)三種不同資料儲存類型之資料傳入,對應中介資料物件設定模組對物件格式規範之設定(405),將資料轉換成連結資料物件(406);Step 2: Through the function of the data link and the object conversion module 33, the data of the three different data storage types of the linked database (402), the connection directory (403), and the connection XML file (404) are transmitted, and the corresponding intermediary data object is set. The module sets the object format specification (405), and converts the data into the linked data object (406);

步驟3:連結資料物件資料建立後,判斷中介資料物件是否存在(407);若資料物件儲存庫37中,中介資料物件不存在,則建立中介資料物件(408);如果存在,則需以同步鍵值設定模組324所設定的同步鍵值與優先權設定資訊,決定資料物件儲存庫37中該中介資料物件之屬性值(409),並將連結資料物件是否需異動資訊記錄下來,送至差異資料異動模組35;Step 3: After the data of the linked object object is established, it is judged whether the intermediary data object exists (407); if the mediation data object 37 does not exist in the data object repository 37, an intermediary data object is created (408); if it exists, it needs to be synchronized The synchronization key value and the priority setting information set by the key value setting module 324 determine the attribute value (409) of the mediation data object in the data object storage 37, and record whether the linked data object needs to be changed and sent to Difference data transaction module 35;

步驟4:收到來自中介資料轉換模組34需異動資料物件之資訊後,差異資料異動模組35會執行異動處理,更新資料物件儲存庫37內所儲存的連結資料物件,使其內容值與中介資料物件的內容值一致,並將需異動的資料物件抄錄至資料物件儲存庫37的輸出區(410);Step 4: After receiving the information of the transaction data item from the mediation data conversion module 34, the difference data transaction module 35 performs the transaction processing, and updates the linked data object stored in the data object storage 37 to make the content value and The content value of the mediation data object is consistent, and the data object to be changed is copied to the output area of the data object repository 37 (410);

步驟5:資料輸出模組36取得需要異動的輸出資料物件資訊後,將這些資料物件依目的端資料伺服器的資料儲存型態,轉換成目的端資料伺服器可接受之異動資料(411);Step 5: After the data output module 36 obtains the output data object information that needs to be changed, the data object is converted into the data storage type acceptable by the destination data server according to the data storage type of the destination data server (411);

步驟6:最後將異動資料送入介接的目的資料伺服器,完成資料同步(412)。Step 6: Finally, the transaction data is sent to the interface destination data server to complete the data synchronization (412).

其中該判斷與連結來源資料儲存體格式步驟更包括:The step of judging and linking the source data storage format includes:

步驟1:判斷資料儲存體型式,連上來源資料儲存體,由連接設定取得對儲存體伺服器之連線與儲存型式;Step 1: Determine the data storage type, connect the source data storage, and obtain the connection and storage type of the storage server by the connection setting;

步驟2:連結資料庫,係由伺服器網址、帳號、密碼等資訊,以連上來源資料庫;Step 2: Link the database, which is connected to the source database by the server URL, account number, password, etc.

步驟3:連結檔案,係由伺服器網址、檔案目錄、存取帳號、密碼等資訊,以連上來源檔案;Step 3: Link the file, which is connected to the source file by the server URL, file directory, access account, password, etc.

步驟4:連結目錄,係由伺服器網址、傳輸埠(port)、連結根結點(RDN)、存取帳號、密碼等資訊,以連上來源目錄。Step 4: Link the directory, which is connected to the source directory by the server URL, port, root node (RDN), access account, password, and so on.

其中該中介資料物件設定步驟更包括:The intermediary data object setting step further includes:

步驟1:取得目錄服務資料物件格式樣式,由描述符合目錄服務標準的樣式庫中,取出物件格式樣本;Step 1: Obtain the catalog service data object format style, and extract the object format sample from the style library that describes the catalog service standard;

步驟2:建立資料物件名稱,依取得樣本建立資料物件格式,並予以命名;Step 2: Establish the name of the data object, establish the data object format according to the obtained sample, and name it;

步驟3:建立屬性名稱:相依新建立資料物件,依取得樣本建立屬性並予以命名;Step 3: Create an attribute name: Dependently create a new data object, create an attribute according to the obtained sample and name it;

步驟4:建立擴充屬性名稱,相依新建立資料物件,建立樣本無相對描述之自訂屬性,並予以命名;Step 4: Create an extended attribute name, create a new data object, and create a custom attribute with no relative description of the sample, and name it;

步驟5:設定同步鍵值,以一個屬性或多個屬性計算處理,作為識別需同步資料物件之對應;Step 5: setting the synchronization key value, and calculating the processing by one attribute or multiple attributes, as the correspondence of identifying the data objects to be synchronized;

步驟6:存取中介資料物件設定,所完成之設定儲存於資料儲存體,資料儲存體可為資料庫、檔案、目錄,所儲存設定並可提供讀取。Step 6: Access the mediation data object settings, and the completed settings are stored in the data storage body. The data storage body can be a database, a file, a directory, and the stored settings can be read and provided.

其中該中介資料轉換模組步驟更包括:The intermediary data conversion module step further includes:

步驟1:判斷中介資料物件存在,於資料物件儲存庫搜尋中介資料是否存在;Step 1: Determine the existence of the intermediary data object, and search for the existence of the intermediary data in the data object repository;

步驟2:建立中介資料,若中介資料物件不存在,則建立中介資料物件;Step 2: Establish intermediary data, and if the intermediary data object does not exist, establish an intermediary data object;

步驟3:比對資料物件,每一個新轉換的資料物件,與中介物件資料以同步鍵值做比對;Step 3: Compare the data objects, and each newly converted data object is compared with the mediation object data by a synchronous key value;

步驟4:更新中介資料物件內容值,以同步鍵值優先順序,更新中介資料物件內容值,並記錄差異的資料物件。Step 4: Update the mediation data object content value, synchronize the key value priority order, update the mediation data object content value, and record the difference data object.

本發明所提供之以目錄服務格式建立中介資料的資料同步系統與方法,與其他習用技術相互比較時,更具備下列優點:The data synchronization system and method for establishing intermediary data in the directory service format provided by the present invention have the following advantages when compared with other conventional technologies:

1.本發明可減低不同的資訊系統間資料同步上的開發時程,將不同的資料儲存體以一致化的中介資料物件轉換,使各系統之間更易於整合。1. The invention can reduce the development time of data synchronization between different information systems, and convert different data storage objects into uniform mediation data objects, so that the systems can be more easily integrated.

2.本發明提出之中介資料物件轉換以完成異質資料同步的系統與方法,結合目錄服務標準,以物件化管理中介資料與同步處理,使資料同步程序更具效益與標準化。2. The system and method for the conversion of mediation data objects proposed by the present invention to complete heterogeneous data synchronization, combined with the catalogue service standard, to manage the intermediate data and the synchronous processing by object, so that the data synchronization program is more effective and standardized.

3.本發明提出之系統與方法富有彈性,可支援不同系統的資料儲存體;且除本身為資料同步系統外,也可支援與其他不同資料同步系統或程式界接。3. The system and method proposed by the present invention are flexible and can support data storage systems of different systems; and in addition to being a data synchronization system, it can also support synchronization with other data synchronization systems or programs.

上列詳細說明係針對本發明之一可行實施例之具體說明,惟該實施例並非用以限制本發明之專利範圍,凡未脫離本發明技藝精神所為之等效實施或變更,均應包含於本案之專利範圍中。The detailed description of the preferred embodiments of the present invention is intended to be limited to the scope of the invention, and is not intended to limit the scope of the invention. The patent scope of this case.

綜上所述,本案不但在技術思想上確屬創新,並能較習用物品增進上述多項功效,應已充分符合新穎性及進步性之法定發明專利要件,爰依法提出申請,懇請 貴局核准本件發明專利申請案,以勵發明,至感德便。To sum up, this case is not only innovative in terms of technical thinking, but also able to enhance the above-mentioned multiple functions compared with conventional articles. It should fully comply with the statutory invention patent requirements of novelty and progressiveness, and apply in accordance with the law. I urge you to approve this article. Invention patent application, in order to invent invention, to the sense of virtue.

1...電腦網路1. . . Computer network

2...來源資料伺服器群組2. . . Source data server group

3...轉換中介資料物件同步伺服器3. . . Conversion mediation data object synchronization server

4...目的資料伺服器群組4. . . Destination data server group

31...中介資料物件設定介面31. . . Intermediary data object setting interface

32...中介資料物件設定模組32. . . Intermediary data object setting module

33...資料連結與物件轉換模組33. . . Data link and object conversion module

34...中介資料轉換模組34. . . Intermediary data conversion module

35...差異資料異動模組35. . . Difference data transaction module

36...資料輸出模組36. . . Data output module

37...資料物件儲存庫37. . . Data object repository

38...中介資料查詢介面38. . . Intermediary data query interface

321...目錄服務物件描述樣式庫321. . . Directory service object description style library

322...中介物件名稱建立模組322. . . Intermediary object name creation module

323...屬性名稱建立模組323. . . Attribute name creation module

324...同步鍵值設定模組324. . . Sync key setting module

325...擴充屬性名稱建立模組325. . . Extended attribute name creation module

326...中介資料物件格式儲存模組326. . . Intermediary data object format storage module

圖一為本發明以目錄服務格式建立中介資料的資料同步系統之系統實施之網路環境示意圖;1 is a schematic diagram of a network environment of a system for implementing a data synchronization system for establishing intermediary data in a directory service format;

圖二為本發明以目錄服務格式建立中介資料的資料同步系統之中介資料物件同步伺服器架構圖;2 is a schematic diagram of an intermediary data object synchronization server of a data synchronization system for establishing intermediary data in a directory service format according to the present invention;

圖三為本發明以目錄服務格式建立中介資料的資料同步方法之以目錄服務物件描述設定中介資料物件格式子系統之軟體架構圖;以及FIG. 3 is a software structure diagram of a data synchronization method for establishing an intermediary data in a directory service format according to the present invention;

圖四為本發明以目錄服務格式建立中介資料的資料同步方法之流程圖。FIG. 4 is a flow chart of a data synchronization method for establishing intermediary data in a directory service format according to the present invention.

1...電腦網路1. . . Computer network

2...來源資料伺服器群組2. . . Source data server group

3...轉換中介資料物件同步伺服器3. . . Conversion mediation data object synchronization server

4...目的資料伺服器群組4. . . Destination data server group

Claims (9)

一種以目錄服務格式建立中介資料的資料同步系統,主要包括:一電腦網路,係為來源資料伺服器、轉換中介資料物件同步伺服器、目的資料伺服器相互連接之媒介;一來源資料伺服器,係有一個或一個以上來源資料儲存體,並透過電腦網路將來源資料傳至轉換中介資料物件同步伺服器以進行轉換;一轉換中介資料物件同步伺服器,係透過電腦網路接收來源資料伺服器傳輸資料,用以將來源資料轉換為中介資料,並紀錄物件異動資訊,並將其處理後把異動資料依目的伺服器資料伺服器對資料儲存型態透過電腦網路寫入資料目的伺服器;一目的資料伺服器,係透過電腦網路接收轉換中介資料物件同步伺服器所轉換之異動資料,並轉換成一個或一個以上目的資料儲存體,使各資料儲存體之資料同步。A data synchronization system for establishing intermediary data in a directory service format, comprising: a computer network, which is a medium for connecting a source data server, a conversion intermediary data object synchronization server, and a destination data server; a source data server , having one or more source data storages, and transferring the source data to the conversion intermediary data object synchronization server through the computer network for conversion; a conversion intermediary data object synchronization server receives the source data through the computer network The server transmits data to convert the source data into intermediary data, and records the object transaction information, and processes the transaction data according to the destination server data server to write the data storage type through the computer network. A destination data server receives the transaction data converted by the conversion intermediary data object synchronization server through the computer network, and converts the data into one or more destination data storages to synchronize the data of each data storage body. 如申請專利範圍第1項所述之以目錄服務格式建立中介資料的資料同步系統,其中該資料儲存體之格式可為資料庫、目錄服務或檔案。A data synchronization system for creating intermediary data in a directory service format as described in claim 1 of the patent application, wherein the data storage format may be a database, a directory service or a file. 如申請專利範圍第1項所述之以目錄服務格式建立中介資料的資料同步系統,其中該轉換中介資料物件同步伺服器有一目錄服務資料格式樣式庫的中介資料格式設定,其目錄服務資料格式樣式庫可提供符合目錄服務物件描述標準之同步用中介資料格式設定,中介資料格式設定包括有中介物件名稱建立模組、屬性名稱建立模組、同步鍵值設定模組、擴充屬性名稱建立模組、中介資料物件格式儲存模組、以及目錄服務物件描述樣式庫,設定結果儲存於資料庫、目錄、檔案三種儲存體。For example, the data synchronization system for establishing intermediary data in the directory service format according to the first application of the patent scope, wherein the conversion intermediary data object synchronization server has an intermediary data format setting of the directory service data format style library, and the directory service data format style thereof. The library can provide synchronization mediation data format setting according to the catalog service object description standard, and the mediation data format setting includes an intermediary object name creation module, an attribute name creation module, a synchronization key value setting module, an extended attribute name creation module, The intermediary data object format storage module and the directory service object description style library, and the setting results are stored in three storages of a database, a directory, and a file. 如申請專利範圍第1項所述之以目錄服務格式建立中介資料的資料同步系統,其中該中介資料物件同步伺服器主要包括有:一中介資料物件設定模組,係以符合目錄服務描述物件格式,設定同步用中介資料物件格式,並將制訂完成的物件格式規範提供資料連結與物件轉換模組、中介資料轉換模組、以及差異資料異動模組作為同步過程轉換資料物件之參考;一資料連結與物件轉換模組,係可以連結資料來源伺服器群組,亦即可連結多個資料來源伺服器,針對不同資料來源的資料儲存體型式,對應中介資料物件設定模組的物件格式規範,將資料轉換成資料物件,並將資料物件歸類於連結資料物件,儲存於資料物件儲存庫連結區;一中介資料轉換模組,係建立中介資料物件與識別差異資料,當此模組接到來自資料連結與物件轉換模組的連結資料物件後,先至資料物件儲存庫中介區找尋其中介資料物件是否存在,若無則參考中介資料物件設定模組,轉換一份中介資料物件至資料物件儲存庫的中介區;若接到連結資料物件時發現中介資料物件已存在於資料物件儲存庫中介區,則依中介資料物件設定模組的同步鍵值優先權,更新資料物件儲存庫的中介資料物件,並將連結資料物件是否需異動資訊記錄下來,送至差異資料異動模組;一差異資料異動模組,係參考中介資料物件設定模組32的物件格式規範,並收到來自中介資料轉換模組的需異動資料物件的資訊後,將異動處理資料物件儲存庫內所有連結資料物件與中介資料物件一致化,並將需異動的資料物件抄錄至資料物件儲存庫的輸出區,使資料輸出模組可藉由差異資料異動模組取得輸出資料物件資訊;一資料輸出模組,係藉由差異資料異動模組取得輸出資料物件資訊,資料輸出模組內含將資料物件轉換為文字檔案、XML檔案、資料庫、目錄四種格式,以將輸出資料物件轉為目的資料伺服器群組裡不同型態資料儲存體可接收之資料格式;一資料物件儲存庫,係供資料連結與物件轉換模組儲存資料物件歸類於連結資料物件,供中介資料轉換模組找尋其中介資料物件是否存在,供差異資料異動模組將異動的資料物件抄錄至資料物件儲存庫,及提供中介資料查詢介面查詢所儲存的資料物件,且該資料物件儲存庫儲存有來源、中介、輸出三種處理的資料物件,亦可儲存中介資料物件設定模組制訂完成的物件格式規範與資料同步處理時需存資料,實施儲存體可為資料庫、檔案、目錄三種型式;一中介資料查詢介面,係提供查詢介面用以查詢資料物件儲存庫所儲存的資料物件,包含每一筆連結資料物件、中介資料物件、異動輸出資料物件之對應,可便於以查詢資料物件狀態監督資料同步狀態。For example, the data synchronization system for creating intermediary data in the directory service format according to the first application of the patent scope, wherein the intermediary data object synchronization server mainly comprises: an intermediary data object setting module, which conforms to the directory service description object format. , setting the format of the mediation data object for synchronization, and providing the data link and object conversion module, the mediation data conversion module, and the difference data transaction module as the reference for the synchronization process conversion data object; And the object conversion module, which can connect to the data source server group, or connect multiple data source servers, and the data storage type for different data sources, corresponding to the object format specification of the intermediary data object setting module, The data is converted into data objects, and the data objects are classified into the linked data objects and stored in the data object storage link area; an intermediary data conversion module is to establish an intermediary data object and identify the difference data, when the module receives the data from After the data link and the object conversion module are linked to the data object, To the data object storage intermediary area to find out whether the information object exists. If not, refer to the intermediary data object setting module, convert an intermediary data object to the intermediary area of the data object storage; if the connection data object is found, find the intermediary The data object already exists in the mediation area of the data object storage, and the priority value of the synchronization key value of the module is set according to the intermediary data object, and the intermediary data object of the data object storage is updated, and whether the data of the linked data object needs to be recorded is recorded. To the difference data transaction module; a difference data transaction module refers to the object format specification of the intermediary data object setting module 32, and receives the information of the transaction data item from the intermediary data conversion module, and then processes the data All the linked data objects in the object repository are consistent with the mediation data objects, and the data objects that need to be changed are copied to the output area of the data object storage, so that the data output module can obtain the output data information through the difference data transaction module. a data output module that obtains output by a differential data transaction module Material information, the data output module contains four types of data objects, such as text files, XML files, data files, and directories, to convert the output data objects into different types of data storage groups in the destination data server group. The format of the data received; a data repository for the data link and the object conversion module to store the data objects in the linked data object for the intermediary data conversion module to find out whether the data object exists or not, for the difference data transaction module Copying the changed data object to the data object repository and providing the intermediary data query interface to query the stored data object, and the data object storage library stores the source, the intermediary, and the output of the processed data object, and can also store the intermediary data object. The document format specification and data synchronization processing are required to be stored in the module. The storage object can be in the form of a database, a file or a directory. An intermediary data query interface is provided with a query interface for querying the data repository. Stored data items, including each linked data item, intermediary information The correspondence between the object and the output data object can facilitate the monitoring of the data synchronization status by querying the status of the data object. 一種以目錄服務格式建立中介資料的資料同步方法,步驟包括:步驟1:判斷與連結來源資料儲存體格式,連結資料來源儲存體並判斷資料類型;步驟2:對應中介資料物件設定與轉換為連結資料物件,將資料儲存體傳入,對應中介資料物件設定模組對物件格式規範之設定,將資料轉換成連結資料物件;步驟3:等化中介資料物件,連結資料物件資料建立後,若中介資料物件不存在,則建立中介資料物件;如果存在,則需以所設定的同步鍵值與優先權設定資訊,決定中介資料物件之值,並記錄物件異動資訊;步驟4:異動連結資料物件,執行異動處理,更新連結資料物件,使其內容值與中介資料物件的內容值一致,並將需異動的資料輸出;步驟5:轉換資料物件為輸出資料,將需要異動的輸出資料物件依目的端資料伺服器的資料儲存型態,轉換成目的端資料伺服器可接受之異動資料;步驟6:寫入目的資料儲存體,異動資料送入介接的目的資料伺服器,完成資料同步。A data synchronization method for establishing intermediary data in a directory service format, the steps comprising: Step 1: determining and linking the source data storage format, linking the data source storage body and determining the data type; Step 2: setting and converting the corresponding intermediary data object to the link The data object, the data storage body is introduced, the corresponding media data object setting module sets the object format specification, and converts the data into the linked data object; Step 3: equalize the intermediary data object, and after the data object is established, if the mediation is established If the data object does not exist, an intermediary data object is created; if it exists, the information of the intermediate data object is determined by the set synchronization key value and priority setting information, and the object transaction information is recorded; Step 4: the transaction data item is changed. Perform transaction processing, update the linked data object, make its content value consistent with the content value of the intermediary data object, and output the data to be changed; Step 5: Convert the data object to the output data, and the output data object that needs to be changed depends on the destination end Data storage type of the data server, converted to the destination Acceptable material server movement information; Step 6: write object data storage member, movement of the object data into the data server interfacing, data synchronization is completed. 如申請專利範圍第5項所述之以目錄服務格式建立中介資料的資料同步方法,其中該步驟2資料儲存體係可為資料庫、目錄、檔案不同資料儲存類型。For example, the data synchronization method for establishing intermediary data in the directory service format as described in item 5 of the patent application scope, wherein the data storage system of the step 2 may be a different data storage type of the database, the directory, and the file. 如申請專利範圍第5項所述之以目錄服務格式建立中介資料的資料同步方法,其中該判斷與連結來源資料儲存體格式步驟更包括:步驟1:判斷資料儲存體型式,連上來源資料儲存體,由連接設定取得對儲存體伺服器之連線與儲存型式步驟2:連結資料庫,係由伺服器網址、帳號、密碼等資訊,以連上來源資料庫;步驟3:連結檔案,係由伺服器網址、檔案目錄、存取帳號、密碼等資訊,以連上來源檔案;步驟4:連結目錄:係由伺服器網址、傳輸埠(port)、連結根結點(RDN)、存取帳號、密碼等資訊,以連上來源目錄。For example, the data synchronization method for establishing intermediary data in the directory service format as described in claim 5, wherein the determining and linking source data storage format steps further comprises: Step 1: determining the data storage type, and connecting the source data storage Body, connect and store the storage server by connection setting Step 2: Link the database, which is the server URL, account number, password and other information to connect to the source database; Step 3: Link the file, the system Information such as server URL, file directory, access account, password, etc., to connect to the source file; Step 4: Link directory: server URL, port, root node (RDN), access Account, password and other information to connect to the source directory. 如申請專利範圍第5項所述之以目錄服務格式建立中介資料的資料同步方法,其中該中介資料物件設定步驟更包括:步驟1:取得目錄服務資料物件格式樣式,由描述符合目錄服務標準的樣式庫中,取出物件格式樣本;步驟2:建立資料物件名稱,依取得樣本建立資料物件格式,並予以命名;步驟3:建立屬性名稱:相依新建立資料物件,依取得樣本建立屬性並予以命名;步驟4:建立擴充屬性名稱,相依新建立資料物件,建立樣本無相對描述之自訂屬性,並予以命名;步驟5:設定同步鍵值,以一個屬性或多個屬性計算處理,作為識別需同步資料物件之對應;步驟6:存取中介資料物件設定,所完成之設定儲存於資料儲存體,資料儲存體可為資料庫、檔案、目錄,所儲存設定並可提供讀取。The data synchronization method for establishing an intermediary data in a directory service format as described in claim 5, wherein the intermediary data object setting step further comprises: step 1: obtaining a directory service data object format style, and the description conforms to the directory service standard. In the style library, take out the object format sample; Step 2: Create the data object name, create the data object format according to the obtained sample, and name it; Step 3: Create the attribute name: Dependently create the new data object, create the attribute according to the obtained sample and name it. Step 4: Create an extended attribute name, follow the newly created data object, create a custom attribute with no relative description of the sample, and name it; Step 5: Set the synchronization key value, calculate and process with one attribute or multiple attributes, as identification needs Synchronize the correspondence of the data objects; Step 6: Access the mediation data object settings, and the completed settings are stored in the data storage body, and the data storage body can be a database, a file, a directory, and the stored settings can be read and provided. 如申請專利範圍第5項所述之以目錄服務格式建立中介資料的資料同步方法,其中該中介資料轉換模組步驟更包括:步驟1:判斷中介資料物件存在,於資料物件儲存庫搜尋中介資料是否存在;步驟2:建立中介資料,若中介資料物件不存在,則建立中介資料物件;步驟3:比對資料物件,每一個新轉換的資料物件,與中介物件資料以同步鍵值做比對;步驟4:更新中介資料物件內容值,以同步鍵值優先順序,更新中介資料物件內容值,並記錄差異的資料物件。For example, the data synchronization method for establishing intermediary data in the directory service format as described in claim 5, wherein the intermediary data conversion module step further comprises: step 1: determining the existence of the intermediary data object, and searching for the intermediary data in the data object storage database. Whether it exists; Step 2: Establish intermediary data, if the intermediary data object does not exist, then establish an intermediary data object; Step 3: Compare the data object, each newly converted data object, and the intermediary object data are compared with the synchronization key value Step 4: Update the mediation data object content value, synchronize the key value priority order, update the mediation data object content value, and record the difference data object.
TW98116337A 2009-05-18 2009-05-18 Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format TWI385543B (en)

Priority Applications (1)

Application Number Priority Date Filing Date Title
TW98116337A TWI385543B (en) 2009-05-18 2009-05-18 Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
TW98116337A TWI385543B (en) 2009-05-18 2009-05-18 Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format

Publications (2)

Publication Number Publication Date
TW201042470A TW201042470A (en) 2010-12-01
TWI385543B true TWI385543B (en) 2013-02-11

Family

ID=45000554

Family Applications (1)

Application Number Title Priority Date Filing Date
TW98116337A TWI385543B (en) 2009-05-18 2009-05-18 Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format

Country Status (1)

Country Link
TW (1) TWI385543B (en)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI556189B (en) * 2014-09-09 2016-11-01 中華電信股份有限公司 Methodology of common data manipulation and transformation within customers for telecom operators

Families Citing this family (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI613556B (en) * 2013-01-28 2018-02-01 通用儀器公司 Selective data synchronization and transfer to remote distributed database servers
TWI502373B (en) * 2014-01-09 2015-10-01 Data exchange management system and method
CN110990466B (en) * 2018-09-29 2023-04-07 北京国双科技有限公司 Data synchronization method and device

Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070260752A1 (en) * 2006-04-21 2007-11-08 Samsung Electronics Co., Ltd. Method of synchronizing multiple content directory services, and content directory service devices and a system thereof
TW200812324A (en) * 2006-08-31 2008-03-01 Chunghwa Telecom Co Ltd Synchronous service architecture using directory services markup language as directory service data exchange

Patent Citations (2)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US20070260752A1 (en) * 2006-04-21 2007-11-08 Samsung Electronics Co., Ltd. Method of synchronizing multiple content directory services, and content directory service devices and a system thereof
TW200812324A (en) * 2006-08-31 2008-03-01 Chunghwa Telecom Co Ltd Synchronous service architecture using directory services markup language as directory service data exchange

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
TWI556189B (en) * 2014-09-09 2016-11-01 中華電信股份有限公司 Methodology of common data manipulation and transformation within customers for telecom operators

Also Published As

Publication number Publication date
TW201042470A (en) 2010-12-01

Similar Documents

Publication Publication Date Title
US10740319B2 (en) Graph-based data models for partitioned data
CN111259006B (en) Universal distributed heterogeneous data integrated physical aggregation, organization, release and service method and system
CN106227800B (en) Storage method and management system for highly-associated big data
JP4816281B2 (en) Document use management system, document management server and program thereof
RU2377646C2 (en) Systems and methods for providing synchronisation services for information blocks, managed by hardware/software interface system
WO2018036324A1 (en) Smart city information sharing method and device
US20080201338A1 (en) Rest for entities
US7376658B1 (en) Managing cross-store relationships to data objects
US20080201234A1 (en) Live entities internet store service
US20040225670A1 (en) Relational directory
US20050065977A1 (en) Configuration of a directory system
US7523141B2 (en) Synchronization operations involving entity identifiers
CN111881223B (en) Data management method, device, system and storage medium
WO2008069125A1 (en) Data management device
US8380787B2 (en) Federation of master data management systems
KR20060080581A (en) Systems and methods for interfacing application programs with an item-based storage platform
CN103631924B (en) A kind of application process and system of distributive database platform
CN111680041B (en) Safety high-efficiency access method for heterogeneous data
JP2000163303A (en) Directory data converting method, storage medium stored with directory data converting program, and directory converting server
US11150996B2 (en) Method for optimizing index, master database node and subscriber database node
CN104091228A (en) Systems for resource management, resource registering, resource inquiry and resource semantic corpus management of internet of things
TWI385543B (en) Data Synchronization System and Method for Establishing Mediation Data in Directory Service Format
CN104050225A (en) View variants in database schema mapping
US20080294673A1 (en) Data transfer and storage based on meta-data
CN102760164A (en) Method for exchanging data between relation database management system and XML (Extensive Makeup Language) database management system

Legal Events

Date Code Title Description
MM4A Annulment or lapse of patent due to non-payment of fees