dbSQWareTM Presentation
 

- Introduction

 

dbSQWareTM is designed for DBA to facilitate the daily operation of all databases to which they are responsible for:

  • dbSQWareTM provides a common unified socle for a number of RDBMS of the market: Oracle, Sybase, SQL Server, MySQL, DB2, PostgreSQL and Ingres. This base can quickly accommodate other types of databases with the flexibility of its design.
  • The product also offers a vision of inventory and capacity planning for those less expert, through a web interface.


dbSQWareTM currently represents several months of design, development and testing. Version v2.0 was released in September 2011 that is mature and stable in production. The product is intended (for his party scripts) to Unix / Linux only because it is essentially written in shell ksh and sql. The web part, for its part, is written in PHP, Ajax and Flash Open. New in v2.0 is to qualify for 80% of the functionality of the tool for instances hosted on windows.

 

- Overall fonctionality

 

  • Management repositories of DBMS park (CMDB) in a database
  • Current and advanced operations on DBMS Oracle, Sybase, MsSql, MySQL, DB2, PostgreSQL and Ingres:
            • Backup
            • Restorations
            • Reorganizations
            • Statistics
            • ...
  • Collection of indicators and capacity planning with recovery in a database. Check these indicators (collection, volumes, backups, ...) and send alert mails
  • Central management of instances (access, scripts execution and automatic controls, ...)
  • GUI website for restitution of the indicators in tables and graphs

  

- Homogeneity

 

In use:

  • Use consistent, regardless of the DBMS
  • Easy adaptation by configuration files
  • Only one version of the tool across the park
  • The scripts adapt to the version of the DBMS managed

 

In the development and evolution:

  • Design consistent for all DBMS
  • Normalization of code (names, functions, structures, parsing of arguments, ...)
  • Behavior modification by overloading bookstores
  • Set of standard libraries can be integrated into custom scripts

 

- Tool structure

 

dbSQWareTM is composed of four interconnected modules:

- SQWareProductionTM

 

Is the operating module in local (or remotely for 80% of the functionality). It allows to manage the operation at large for RDBMS:

  • Backup
  • Restorations
  • Statistics
  • Ascents alerts
  • Encapsulation execution jobs
  • Execution of unix commands in parallel
  • ...

This module also collects a number of indicators that are inserted on the repository database SQWareRepositoryTM. This module consists of one part per DBMS managed. There is no "core" part, each type of DBMS is independent but the scripts are all written by the same standard of development (argument parsing, online help, send mail on error, recovery indicators in SQWareRepository, ...).

 

- SQWareRepositoryTM

 

Is the management module of the repository and indicators database. It allows to manage the repository and the indicators stored in databases (the database depending of the type of DBMS managed). This module consists of one part per DBMS managed. There is no "core" part, each type of DBMS is independent but all plugins have the same type of MCD.

 

- SQWareCentralTM

 

Is the central module of the tool. It can manage the whole park from this point:

  • Centralized collection of indicators
  • Deployment of SQWareProduction modules by rsync
  • Management of "full-text search" in the repositories
  • Easy connection via ssh to different instances of the park ...
  • ...

This module is based inter alia on the repository database, SQWareRepositoryTM. It is composed of a "core" part common to all managed RDBMS and a specific plugin for each DBMS (Oracle, Sybase, SQL Server, MySQL, DB2, PostgreSQL and Ingres).

 

- SQWareWebTM

 

Is the web module for graphic indicators. It works with Apache 2 and is written in PHP 5.2, AJAX and Open-Flash. It allows for the presentation of indicators and capacity planning as:

  • Graphics (flash)
  • Tables (with sorting and formatting locally on the browser)
  • Exports Excel
  • ...

It is based entirely on data contained in the repository database SQWareRepositoryTM. Refunds are made in much the same way regardless of the DBMS (the specific near it), which makes it more enjoyable and easier navigation. This module is composed of a "core" part common to all managed RDBMS (template engine, display graphs, tables, ...) and a specific plugin for each DBMS (Oracle, Sybase, SQL Server, MySQL, DB2, PostgreSQL and Ingres).

 

General architecture diagram dbSQWareTM (when the SQWareProductionTM module is locally installed) :

 

General_dbSQWare

 

 

 

 

 

dbSQWare

    A single operating tool for
all your databases :

            Oracle, Sybase, SQL-Server, MySQL, DB2-LUW,
            PostgreSQL, MongoDB, ...       
              More...

 

OctopusDBA 2011-2018 © All rights reserved - Legal mentions - Propulsed by Joomla!