Consulting
We present the optimal database operation strategy based on 20 years of accumulated consulting experience and various cases.
Providing a variety of specialized data consulting services
Data Modeling
When data is well stored and matured, it becomes an ocean of wisdom beyond information, but when it is not managed well, it becomes rotten and difficult to dispose of. The beginning of the journey to the ocean of wisdom is data modeling. Data modeling selects a subject area based on intimacy, similarity, and usability between data, reflects requirements in the current work, and verifies stability and improves completeness through the stages of concept, logic, and physical data models. Finally, we provide all of Openmade Consulting's knowledge and capabilities until completion by creating a table in DBMS.
Data Standardization
Data standardization is expressed as domain integrity in information engineering, and only after the introduction of the IT meta system was the foundation for properly maintaining domain integrity established. In order to ensure data quality, standardizing terms and codes is not optional but essential. Openmade consultants support content maintenance and process stabilization so that standardization can be stably established.
SQL Tunning
SQL Tuning is a process of increasing DBMS availability and optimizing SQL performance through various methods such as DBMS resource optimization, SQL Access Path analysis, index optimization, and changing Join method to optimize the performance of SQL executed in DBMS. Openmade Consulting supports high-quality tuning services. Using OpenPOP, you can systematically manage the entire SQL tuning process by storing it in a repository.
Tuning Proces
Process
Physical Data Model
Tuning
DB Parameter
Tuning
DB Access Efficiency
Tuning
System Resource
Tuning
DB Management Policy Tuning
Physical Data
Model Review
DB Parameter
Tuning
DB Access
Efficiency Tuning
System Resource
Tuning
DB Management
Policy Tuning
Physical Data Model Analysis
Memory Management
Optimizer Parameter
Index Analysis & SQL Tuning
Batch Program Tuning
Top SQL Tuning
CPU, Memory, Disk I/O Tuning
DB Operation Policy Tuning
-
Analysis of Data Type and Length Suitability
-
Review of Index Design and Efficiency
-
Analysis of Table/Index Storage Parameters
-
Auto/Manual Memory Management Strategy
-
SGA & PGA Utilization Tuning
-
Optimizer Parameter Tuning
-
Parallel Parameter Tuning
-
Improve Access via Index Rebuilds & SQL Tuning
-
Performance Boost via Set-based Processing
-
Focus on High-Resource SQL (CPU/IO)
-
Identifying bottlenecks via Wait Event analysis
-
Optimizing key system parameters
-
Analyzing Hot Blocks/Files and distributing I/O
-
Normalization/Denormalization Review
-
Efficient History Management
-
Table Partitioning Strategy
Data Migration
Corporate data is converted into data in environments such as next-generation, advanced, system integration, data maintenance, and heterogeneous conversion. Since the results of data conversion affect data quality, understanding of the business and specialized knowledge of the DBMS environment are required. For stable data conversion, the quality of data conversion is guaranteed through data analysis, mapping, conversion, verification, and result reporting based on a systematic transfer strategy and understanding of the business.
Analysis
-
Environment & Scope Assessment
-
AS-IS & TO-BE Analysis
-
Data Migration Requirements Analysis
Design
-
Data Mapping Definition
-
Mapping Rule Definition
-
Code Mapping
-
Validation Rule Definition
-
Migration Planning
-
igration Dev Environment Setup
Implementation
-
Migration Program Development
-
Migration Testing
-
Validation Program Development
-
Validation Testing
-
Migration Scenario Creation
-
Migration Infrastructure Setup
Test
-
Migration Scenario Testing
-
Data Cleansing
-
Bulk Data Mapping Refinement
-
Migration Program Refinement
-
Validation Program Refinement
-
Migration & Validation Test Reporting
Cut-Over
-
Production Cut-over
-
Final Migration & Validation Report
-
Stabilization Support
DB Admin
DBMS is one of the most important equipment in a company. Providing stable services by improving the performance, stability, and availability of DBMS is essential for business processing and service provision. In order to secure the stability of DBMS, we provide systematic and stable DBMS management services through professional DB Admin from the SI project stage of introducing and applying the system.
DBMS Standardization
Standardization Policy
Development Guidelines
Deliverable Management
Security Management
DBMS Design
Physical Design
Schema Management
Connectivity Configuration
Backup & Recovery
Performance Management
Test Environment Support
DBMS Operations
System Performance Monitoring
DB Diagnostics & Optimization
DB Log Analysis
Capacity Planning
Troubleshooting
Stable DBMS Operations
Data Preparation
In the era of big data, data flowing into companies in both structured and unstructured forms are managed as information in a form that companies can analyze through preprocessing processes such as collection, quality assessment, purification, integration, conversion, and exploration. We provide the accumulated know-how of Openmade Consulting.
Process
Details
Description
Collection
Structured Data
Internal business data
Unstructured Data - Text, image, audio, video, documents, social data, etc.
Collecting structured and unstructured data from internal & external sources
Quality Assessment
Accuracy, Completeness, Consistency, Timeliness
Evaluating data quality to prevent distortion in analysis
Cleansing
Removing Errors, Omissions, Anomalies
Removing outlier data to maintain accuracy, completeness, and consistency
Integration
Data Format, Data Structure
Integrating different formats and structures for consistent data processing
Transformation
Standardization, normalization, encoding, dimension reduction, text processing, time-series conversion, etc
Transforming data into a format suitable for analysis
Exploration
Basic statistics, visualization, correlation analysis, pattern discovery, feature selection, outlier detection, etc
Gaining insights into data by understanding its characteristics and structure to build a suitable model
Data Governance
Data governance supports data governance consulting to systematically manage security, quality, availability, and accessibility through policies and procedures during the data life cycle by forming an organization that oversees data management policies so that data can be utilized in accordance with business goals.