Based on high data expertise and experience,
support migration in cloud environment

More and more companies are replacing existing DBMS with open source DBMS to reduce the cost of IT infrastructure.
This data migration takes place in a variety of open source environments as well as heterogeneous cloud environments,
which requires high understanding and experience of data.
en-core provides successful services for heterogeneous DBMS data migration through many years of
data consulting experience, experts, and specialized data solutions.

Stable implementation support through optimization of
migration targets with professional consulting

DATAWARE has products that correspond to
each component of the data quality management framework

• 01

  Systematic execution process through
  optimization of migration target Considering the schedule of the project,
  the first data migration is required to complete quickly
  in order to meet the test schedule during the application stage.

• 02

  Efficient migration through impact analysis solution
  and operational solutions Impact analysis solution AP# extracts unused tables and
  queries through to effectively optimize the scope of the migration.
  SQL# supports a efficient data migration by automatically converting
  a certain part queries into open source DBMS compatible queries.

• 03

  Support stable implementation through specialized consulting services. SQL experts, who have participated numerous data consulting projects in various industries,
  provide a query optimization for the target DBMS and support a stable service implementation, collaborating with developers.

Based on accumulated methodology and solution

Enterprise system cloud transformation, Oracle to postgreSQL successful transition

• CompanyD Company
• ProjectConversion project
• Term2018.12~2019.07

• Goal

  This was a project that converts the service of doopedia into a cloud environment, which aims to reduce the costs and improve the system performance, effectively utilize system resources, and improve the operating environment. Successful transition from Oracle to PostgreSQL

• Objectives
  1. 1

     This project aims for the cloud conversion of the entire system of doopedia, including cloud conversion of PC/Mobile website, application of PaaS service, application of DevOps environment, and architecture design that conforms to doosan security policy

  2. 2

     A successful migration from Oracle to PostgreSQL

  3. 3

     Application of data migration solution ETT# to save the cost and time

• Technologies

  ▪  On-premise DB (As-Is) : Oracle 10g , cloud DB (To-Be) : Azure database for PostgreSQL (version 10)
  ▪  Target conversion queries
  >> 590 tables, 228 indexes, 240 sequences, 64 functions, 25 procedures and 8 triggers
  >> Inline queries in the doopedia codes: IBATIS XML(134 files and 2661 queries), JSP (18 font-end inline queries)
  >> Queries registered in the doopedia search engine (49 queries and reporting queries) ▪  Query conversion period : Early January 2019.01 - mid-February 2019
  ▪  Query conversion process
  [Convert query XML files] -> [Extract converted queries] -> [Correct the query errors] -> [Deliver updated XML files]
  [<<<<<<<<<<<<<<<<<<<<< use SQL# >>>>>>>>>>>>>>>>>>>>>>>>] ▪  Data migration :
  >> Total elapsed time for migration : 7 hours
  >> Migration solution : combination of ETT# and Ora2pg (Open source tool)

• Architecture