V2020.06

Version 2020.06 of dbSQWare has just been released!
With a great novelty …
The ability to access a selection of the most common jobs, defined for all DBMSs and to consult, in 1 click, the associated help and examples of the use of scripts.
Access to the wiki is also available directly from the list of these jobs.
A plus for our users who will gain time and agility.

Not to mention that dbSQWare is the only DBMS management and maintenance software capable of homogeneously managing 11 types of heterogeneous database engines.

SQWareWeb DEMO

The 2020 version of dbSQWare offers a new graphical interface to its users.
Completely redesigned and updated, it is now much more fluid and intuitive.
You can consult it on our demo site and choose your connection profile by following the instructions in the tooltip (i).
Then, all you have to do is navigate …

Demo on: http://webdba.dbsqware.com

NOVELTIES

The version 2020.01 of dbSQWare which has just been released, presents many new features.
Completely redesigned, the software now offers a much lighter, fluid and intuitive graphical interface.
Many features have been added, such as:
– the choice of navigation language
– cvs, pdf and excel exports on filtered and sorted data from reporting tables
– management of access rights on menus
– asynchronous feedback of indicators
– encryption and decryption of connection files
Without forgetting that dbSQWare is the only DBMS management and maintenance software, capable of managing in a homogeneous way, 11 different types of database engines, thus offering to its users, a similar approach and vision, whatever the DBMS concerned.

VERSION 2020.01

We are very happy to announce the release of the new version 2020.01 of our software, dbSQWare.
Expected by our users, this version offers a new web interface, UX / UI Design, which makes navigation much more fluid and intuitive.
There are also many new features such as asynchronous indicator feedback, encryption / decryption of connection files, management of menu rights, …
All the changes are available on the “Release Notes” page, “Technical” section of our website.

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.