11 DBMS SUPPORTED

Here is a small overview of the 11 types of database engines supported by dbSQWare.

The RDBMS (Relational database management system):
– Oracle is the most popular on UNIX / Linux.
– DB2 LUW is the version of the distributed system of the Mainframe engine.
– SQLServer, developed by Microsoft, is mainly deployed on Windows.
– Teradata is a historic RDBMS with colossal storage capacities.
– Sybase, acquired by SAP, is the former market leader.
– Ingres, dating from the 80s, has been Open Source since 2004.
– MySQL is the most popular Open Source RDBMS
– and PostgreSQL, the most advanced Open Source RDBMS.

The NoSQL:
– Cassandra has a column-oriented organization.
– MongoDB, which is a document-oriented organization, is the most popular.
– The version of Adabas Linux is accessible by natural language.

SQL / NoSQL

Relational databases are manipulated with SQL (Structured Query Language), while NoSQL databases (Not Only SQL) are characterized by a logic of non-relational data representation and do not (or rarely) offer query interface in SQL.
Some differences :
– Structure: In a relational database, the data schema (tables, keys, procedures, …) must be designed to be able to manipulate data. With NoSQL, data can be added anywhere and at any time (in most cases).
– SQL normalization / NoSQL denormalization: In SQL, the data are not duplicated and are linked together by foreign keys. In NoSQL, they can be duplicated and copied into several different records.
– Join: SQL queries allow the JOIN clause. NoSQL generally has no joins.
– Scalability: Following an increase in load, relational side, it is often chosen to increase the size of the server rather than putting clusters on the instances. With NoSQL, data organization allows partitioning and scaling up of the database on current deployed hardware.
Their common point: dbSQWare!

V2019.05

The 2019.05 version of dbSQWare has just been released!
With 2 new features:
– for Sybase: the addition of tracing of changes on structures (tables, columns and indexes) and the ability to compare the structures of two schemas;
– for MariaDB: the integration of the MariaBackup backup system.

For more information, all changes are available on the “Release Notes” page of our website (“Technical” tab).

UX/UI DESIGN

Relooking sessions for our software thanks to UX / UI Design’s mission, from atrioom company (Service Design / UX Strategy).
Developments are underway to modify our platform and soon offer our users a smoother and more ergonomic navigation.
A big thank you and congratulations to the designers: Aurélien Beguet, Alexis Sadowski and Marie Vacher for their listening, their involvement and their creativity!

TIBERO

dbSQWare is the only software in France, able to exploit and maintain, in a completely homogeneous way, 11 types of database engines (R & NoSQL).
But we will not stop there!
A 12th engine will soon be coming in … This is Tibero, a relational database management system developed by the South Korean publisher TmaxSoft and designed to support complex and large-scale systems.

FEATURES

I’m still talking about our dbSQWare software, but do you know the main features it offers for DBMS operation and maintenance?
Here is a recap:
Copy environments – Backup and restore – Reorganization – Update Statistics – Dashboard / Vision 360 ° – Customization
Very flexible, dbSQWare adapts to all companies, whatever their size and activity.

DBMS

dbSQWare is an operating and maintenance software for DBMS.

– “But by the way, what is a DBMS?”
To put it simply, a database is a set of files in which data are stored.
A Database Management System (DBMS) is system software designed to create and manage databases.
It allows to read, write, modify, sort or restore the information of the database, according to the requests made by the user.
Existing DBMS are many, varied and most of the time, of different design.

– “And dbSQWare, in all this ?”
dbSQWare is used to operate, in a homogeneous and uniform way, all the DBMS installed on a computer park.

With dbSQWare, the user manages all of his DBMS with one tool.