DATABASE ARCHITECTURE

Maximizing Performance and High Availability while Reducing Cost

Currently, companies are developing software solutions forgetting how essential for high performance and availability architecture, potentially leading to future collapse. OneDB Solutions focuses on this point. We work so your company never stops, maintaining operational high performance.

On-Premise

Despite current trends towards cloud solutions, by this approach, business can achieve the same benefits. On-premise environment increases the power for maintenance and flexibility for tuning and performance enhancement.

Cloud and Hybrid

One of the most popular solutions right now is migrating to cloud architecture, it has been a good solution in terms of reducing costs. Depends on the company, a hybrid architecture can make the core databases more flexible in On-Premise while reducing cost in Cloud.

Architecture Services

High investment in hardware and technology are relevant, but enought to avoid your company stops. As less a high availability has been implemented in a cluster or similar solution for an automatic recovering.
Data warehouse development following Kimball methodology including all the dimensions and fact tables. Data stage and ETL in SSIS for better visualisation and maintenance.
Database architecture for reporting is relevant to increase the performance reducing troubleshooting in OLTP production environments.
A hybrid solution can work with On-Premiss and Cloud architectures, making possible high availability while geographic data distribution.

The most Recent Architecture Services

Projects (in Progress)

# Name Technology Description
1 Sales Consultant Tracking Data Mart Architecture for Tableau Data analysis for individual and manager sales comission.
2 Demand SQL 2016 with R Studio architecture Data analysis to find the demanding products
3 24x7 Database Administration SQL 2016 Enterprise version, real-time monitoring in Power BI Database administration and monitoring for all the environments.
3 V8 Car Monitoring OBDII reading and SQL Azure Cloud architecture Real-time data reading in OBDII storaging in Azure.

The most Recent Projects (completed)

# Name Technology Description
1 SQL 2016 Cluster SQL active x active MS Cluster Covering all the core databases and applications.
2 Report Server Logshipping for replication in SQL 2016 Redundant database for data warehouse loading and reporting.
3 SQL 2012 to 2016 Migration Always On, CLuster Migrated all the database servers.
4 SSRS Migration SQL 2008 and 2012 to 2016 Migrated to standard and enterprise environments.
5 SQL Instance Consolidation SQL 2005, 2008 and 2012 to 2016 Consolidated from multiple instances to an unified instance.
6 Generator MySQL, MS SQL Data conversion from MySQL to MSSQL from a legacy application.

Recent Success Article

Database Architecture in SQL Cluster

Reducing cost increasing high availability

`