WO2011053268A1 - Interface modulaire pour la conversion d'une base de données - Google Patents

Interface modulaire pour la conversion d'une base de données Download PDF

Info

Publication number
WO2011053268A1
WO2011053268A1 PCT/US2009/005844 US2009005844W WO2011053268A1 WO 2011053268 A1 WO2011053268 A1 WO 2011053268A1 US 2009005844 W US2009005844 W US 2009005844W WO 2011053268 A1 WO2011053268 A1 WO 2011053268A1
Authority
WO
WIPO (PCT)
Prior art keywords
database
data
client
software
conversion
Prior art date
Application number
PCT/US2009/005844
Other languages
English (en)
Inventor
Werner Mok
Original Assignee
Werner Mok
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 Werner Mok filed Critical Werner Mok
Priority to EP09850943.3A priority Critical patent/EP2494465A4/fr
Priority to PCT/US2009/005844 priority patent/WO2011053268A1/fr
Priority to CN2009801622038A priority patent/CN102713888A/zh
Publication of WO2011053268A1 publication Critical patent/WO2011053268A1/fr

Links

Classifications

    • G—PHYSICS
    • G06—COMPUTING; CALCULATING OR COUNTING
    • G06F—ELECTRIC DIGITAL DATA PROCESSING
    • G06F16/00—Information retrieval; Database structures therefor; File system structures therefor
    • G06F16/20—Information retrieval; Database structures therefor; File system structures therefor of structured data, e.g. relational data
    • G06F16/25—Integrating or interfacing systems involving database management systems
    • G06F16/258—Data format conversion from or to a database

Definitions

  • the preferred and alternative embodiments of the present invention provide a system and method for data conversion that utilizes resources already contained in the source database software, thus eliminating the need for third-party software intervention, to execute configured scripts.
  • the present invention is universal in its application, thereby being able to convert from any relational database to any other automatically.
  • Figure 1 is a network system that is capable of implementing the exemplary embodiments for data conversion
  • FIG. 2 is a functional network system diagram of the preferred and alternative embodiments
  • FIG. 3 is a flowchart of an embodiment of data conversion
  • Figure 4 is a block of computer components illustrating placement of the preferred protocol process module and applications as tools in a computer system
  • intellectual property data and information is converted into a strict format using a client's original DTS database package and without using further third-party conversion software or manual conversion steps.
  • FIG. 1 a computer network system capable of implementing the preferred and alternative embodiments is illustrated.
  • Users and servers connect to a broadband network 100, such as the public Internet, managed network lines, and/or a private wide area networks (WAN).
  • a broadband network 100 such as the public Internet, managed network lines, and/or a private wide area networks (WAN).
  • Each server and end-user can connect to the Internet 100 through a standard or high-speed network connection such as Ethernet LAN, cable modem, DSL ("Digital Subscriber Line”) or T1/T5 line.
  • a first specialized client database application server 104 handles and executes a first intellectual property (IP) management database application that accesses original client IP database 102.
  • a second specialized application server 106 handles and executes a second intellectual property (IP)
  • step 122 original client data from IP database 102 is accessed through software 110 and analyzed to determine location of and identify tables, records, fields, and indexes.
  • Database 102 is a relational database. Access to database 102 can be via network 100, directly through controller software 110, or a copy of database 102 on a computer-readable media.
  • a script template is created with data conversion agent 114 as an SQL script template comprising SQL SELECT statements that format and extract client data from database 102.
  • This template is modified 124 based on an analysis to fit client database 102 environment and retrieving critical data fields used in ASP database 108. This is performed in part by configuring the FROM portion of the SELECT statement, thereby configuring the table relationships or joins to pull all necessary fields from client data 102 that are necessary for database 108.
  • Data fields from original client data 102 must be mapped to custom data fields and tables in converted client database 108 that can be used by management software 120 on IP Application Provider Server 106.
  • databases used by IP application management software 120 contain specialized fields that are used in the patent and trademark industry, such as:
  • IP databases can include up to a hundred or more specific data fields as are known in the art. It is records in those fields and tables that must be converted between old client database 102 and new database 108. In modifying script 124, all code lookups and conversion logic can be built into the SELECT statement.
  • step 126 automation of the configured script is setup to execute on the claim database software DTS controller 112.
  • Data conversion agent 114 executes directly within DTS 112, which then connects directly with original client database 102. No other third-party software or conversion mechanism is needed to execute the SQL script against client database 102.
  • the modified script can bypass any client data source 102 format since the scripts will be executed directly against the client database (e.g., SQL server, Oracle, etc.).
  • Automation parameters 126 are setup in order save retrieved data from database 102 into ASP 106 batch report layout or format. SQL templates can be modified via any text editor and executed using any type of DTS package 112 without requiring additional software input from either client controller 110 or ASP data management software 120.
  • a test batch, or report of extracted client data 102 is generated 128 using the configured SQL script of agent 114.
  • step 130 if the test batch, 128, if the data mapping from the client data 102 does not match the target fields in database 108, then client data 102 fields are analyzed 132 against a rules database 116 via data conversion agent 114.
  • Rules database 116 contains text and data conversion rules to convert records such as "Patent" from client data 102 into a single character "P" that is used by ASP
  • rules 116 can be applied to recognize and convert the alpha-numeric date records into proper format.
  • DTS package 112 executes the SQL script 134 and produces a formatted batch report 118, which is a text file in the embodiment.
  • the configured script can be scheduled to run automatically 136 in DTS package 112 and to combine, encrypt, and e- mail out one or more batch files 118 to Application management software 112.
  • SQL is a universal computer language, therefore users of client software 110 can customize and perform setup and automation activities without needed much, if any, third-party assistance. This allows users of client database software 110 to take advantage of standard database tools in order to understand, configure, and execute the script. There are no version or maintenance issues with the embodiments and no interface to maintain in the method and system of the embodiments, since the scripts execute directly within DTS package 112, which is a typical module included within client database software 110. Further, the use of configured SQL scripts reduces the risk of data corruption in database conversions.
  • FIG. 4 is a block diagram 138 illustrating placement of an exemplary database manager application, such as application 110 or 120 and database 140, such as databases 102 or 108, as hardware tools in a computer system.
  • the diagram shows a computer system 146 with a processor unit (148) coupled to memory 152 by a bus structure 158. Although only one processor unit 148 is shown, in one embodiment, the computer system 146 may include more processor units in an expanded or distributed design.
  • the computer system includes data storage 140 in communication with the processor unit 148. The data storage unit is employed for retention of a collection of relational data 142.
  • a request manager 160 is provided in communication with the system 146. However, in one embodiment, the request manager may be on a remote system (not shown) that is in communication with the system 502 across a network. The request manager 160 monitors information associates with data 142 retained on the data storage 140. Upon detection of an event or execution, the request manager 160 generates a message and communicates the message to an integration manager 162. As with the request manager, the integration manager may be local to the system 146 or on a remote system (not shown) that is in communication with the system 146 across a network. The integration manager 162 is also in communication with the data 142 retained on the data storage 140.
  • the request manager 160 and the integration manager 162 each reside in memory 160 local to the computer system 514602.
  • each of the managers 160 and 162 may reside as hardware tools external to local memory 152, or may be implemented as a combination of hardware and software.
  • the managers 160 and 162 may be combined into a single functional item that incorporates the functionality of the separate items.
  • managers 160 and 162 may be collectively or individually distributed across a network and function as a unit. Accordingly, the managers 160 and 162 may be implemented as software tools, hardware tools, or a combination of software and hardware tools.
  • Embodiments within the scope of the present invention also include articles of manufacture comprising program storage means having encoded therein program code.
  • program storage means can be any available media which can be accessed by a general purpose or special purpose computer.
  • program storage means can include RAM, ROM, EEPROM, CD-ROM, or other optical disk storage, magnetic disk storage or other magnetic storage devices, or any other medium which can be used to store the desired program code means and which can be accessed by a general purpose or special purpose computer. Combinations of the above should also be included in the scope of the program storage means.
  • the medium can be an electronic, magnetic, optical,
  • Examples of a computer-readable medium include a semiconductor or solid state memory, magnetic tape, a removable computer diskette, random access memory (RAM), read-only memory (ROM), a rigid magnetic disk, and an optical disk.
  • Current examples of optical disks include compact disk B read only (CD-ROM), compact disk B read/write (CD-R W) and DVD.
  • a data processing system suitable for storing and/or executing program code will include at least one processor coupled directly or indirectly to memory elements through a system bus.
  • the memory elements can include local memory employed during actual execution of the program code, bulk storage, and cache memories which provide temporary storage of at least some program code in order to reduce the number of times code must be retrieved from bulk storage during execution.
  • I/O devices including but not limited to keyboards, displays, pointing devices, etc.
  • Network adapters may also be coupled to the system to enable the data processing system to become coupled to other data processing systems or remote printers or storage devices through intervening private or public networks.
  • the software implementation can take the form of a computer program product accessible from a computer-useable or computer-readable medium providing program code for use by or in connection with a computer or any instruction execution system.

Abstract

L'invention porte sur un système, un procédé et un équipement pour informations formatées et échange de données pour conversion universelle et modulaire de données d'une base de données relationnelle à une autre, tout en évitant un quelconque formatage sur la base de données source.
PCT/US2009/005844 2009-10-28 2009-10-28 Interface modulaire pour la conversion d'une base de données WO2011053268A1 (fr)

Priority Applications (3)

Application Number Priority Date Filing Date Title
EP09850943.3A EP2494465A4 (fr) 2009-10-28 2009-10-28 Interface modulaire pour la conversion d'une base de données
PCT/US2009/005844 WO2011053268A1 (fr) 2009-10-28 2009-10-28 Interface modulaire pour la conversion d'une base de données
CN2009801622038A CN102713888A (zh) 2009-10-28 2009-10-28 用于数据库转换的模块化接口

Applications Claiming Priority (1)

Application Number Priority Date Filing Date Title
PCT/US2009/005844 WO2011053268A1 (fr) 2009-10-28 2009-10-28 Interface modulaire pour la conversion d'une base de données

Publications (1)

Publication Number Publication Date
WO2011053268A1 true WO2011053268A1 (fr) 2011-05-05

Family

ID=43922367

Family Applications (1)

Application Number Title Priority Date Filing Date
PCT/US2009/005844 WO2011053268A1 (fr) 2009-10-28 2009-10-28 Interface modulaire pour la conversion d'une base de données

Country Status (3)

Country Link
EP (1) EP2494465A4 (fr)
CN (1) CN102713888A (fr)
WO (1) WO2011053268A1 (fr)

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2546110A (en) * 2016-01-11 2017-07-12 Healthera Ltd Data processing method and apparatus

Families Citing this family (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
CN105205117B (zh) * 2015-09-09 2019-03-05 郑州悉知信息科技股份有限公司 一种数据表迁移方法和装置

Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5666645A (en) * 1995-04-26 1997-09-09 News America Publications, Inc. Data management and distribution system and method for an electronic television program guide
KR20020054238A (ko) * 2000-12-27 2002-07-06 오길록 분산형 지리정보처리 컴포넌트 시스템 및 그 방법
KR100594635B1 (ko) * 2004-02-05 2006-06-30 학교법인 인하학원 Ａｓｐ서버와 클라이언트의 데이터베이스 연동 시스템 및방법
US20060149706A1 (en) 2005-01-05 2006-07-06 Microsoft Corporation System and method for transferring data and metadata between relational databases

Family Cites Families (3)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US7139766B2 (en) * 2001-12-17 2006-11-21 Business Objects, S.A. Universal drill-down system for coordinated presentation of items in different databases
US7805341B2 (en) * 2004-04-13 2010-09-28 Microsoft Corporation Extraction, transformation and loading designer module of a computerized financial system
US20060200753A1 (en) * 2005-03-07 2006-09-07 Rishi Bhatia System and method for providing data manipulation as a web service

Patent Citations (4)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
US5666645A (en) * 1995-04-26 1997-09-09 News America Publications, Inc. Data management and distribution system and method for an electronic television program guide
KR20020054238A (ko) * 2000-12-27 2002-07-06 오길록 분산형 지리정보처리 컴포넌트 시스템 및 그 방법
KR100594635B1 (ko) * 2004-02-05 2006-06-30 학교법인 인하학원 Ａｓｐ서버와 클라이언트의 데이터베이스 연동 시스템 및방법
US20060149706A1 (en) 2005-01-05 2006-07-06 Microsoft Corporation System and method for transferring data and metadata between relational databases

Non-Patent Citations (1)

* Cited by examiner, † Cited by third party
Title
See also references of EP2494465A4 *

Cited By (1)

* Cited by examiner, † Cited by third party
Publication number Priority date Publication date Assignee Title
GB2546110A (en) * 2016-01-11 2017-07-12 Healthera Ltd Data processing method and apparatus

Also Published As

Publication number Publication date
CN102713888A (zh) 2012-10-03
EP2494465A4 (fr) 2014-03-05
EP2494465A1 (fr) 2012-09-05

Similar Documents

Publication Publication Date Title
US8380645B2 (en) Method and system to enable inferencing for natural language queries of configuration management databases
US10545981B2 (en) Virtual repository management
US8495701B2 (en) Indexing of security policies
US9262248B2 (en) Log configuration of distributed applications
US7971231B2 (en) Configuration management database (CMDB) which establishes policy artifacts and automatic tagging of the same
US11048715B1 (en) Automated file acquisition, identification, extraction and transformation
US7797281B1 (en) Granular restore of data objects from a directory service
US20100205475A1 (en) Meta-data driven, service-oriented architecture (soa)-enabled, application independent interface gateway
US20110313981A1 (en) Data Privacy, Redaction and Integrity for Relational Databases
US9037525B2 (en) Correlating data from multiple business processes to a business process scenario
US8260813B2 (en) Flexible data archival using a model-driven approach
US8452808B2 (en) Automatic generation of virtual database schemas
US8417690B2 (en) Automatically avoiding unconstrained cartesian product joins
WO2011129943A1 (fr) Traitement de flux de travaux de structure de services de données
US20140059381A1 (en) Methods for testing odata services
US20130332421A1 (en) Defining Content Retention Rules Using a Domain-Specific Language
US20070073675A1 (en) Database query translation
WO2014178033A2 (fr) Modification de métadonnées associées à des images médicales électroniques
US7475090B2 (en) Method and apparatus for moving data from an extensible markup language format to normalized format
CN112912870A (zh) 租户标识符的转换
US20100106746A1 (en) Modular interface for database conversion
WO2011053268A1 (fr) Interface modulaire pour la conversion d'une base de données
US8621085B2 (en) Methods, systems, and computer program products for managing and utilizing connections between an application server and an enterprise information system based on a daytona architecture
CN112905617B (zh) 数据写入方法、服务器及计算机可读存储介质
KR20040077535A (ko) 선택된 객체에 관한 정보에 대한 요구를 생성하는 시스템및 방법

Legal Events

Date Code Title Description
WWE Wipo information: entry into national phase

Ref document number: 200980162203.8

Country of ref document: CN

121 Ep: the epo has been informed by wipo that ep was designated in this application

Ref document number: 09850943

Country of ref document: EP

Kind code of ref document: A1

NENP Non-entry into the national phase

Ref country code: DE

REEP Request for entry into the european phase

Ref document number: 2009850943

Country of ref document: EP

WWE Wipo information: entry into national phase

Ref document number: 2009850943

Country of ref document: EP