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!

TRY & BUY

The experience is only worth it if it was lived … That’s the reason why we propose the “Try & Buy” of dbSQWare!
The principle is to offer 3 months of subscription and allow users, from each company, to use dbSQWare for free to manage their database.
At the end of the evaluation period, convinced users will only have to subscribe to the software subscription.

INSTALLATION STEPS

Unique, dbSQWare allows its users to manage, in a completely homogeneous way, all of its DBMS despite their heterogeneity.
Its installation takes place in 4 essential phases:
– the definition and study of the architecture in place,
– the setting and customization of dbSQWare according to the environment,
– the software deployment,
– and finally, the passage of knowledge on its daily use.
Installing dbSQWare means choosing reliability, agility and serenity, through a global management and vision of your database.

DBA

– “Do you know what the job of DBA is?”
A DBA (DataBase Administrator) is responsible for the design, implementation and management of DBMS.
He also ensures the maintenance by adapting them according to the technological evolutions and the needs of the company.
The database administrator is responsible for the accessibility, quality and security of the data.
He also acts as technical support and support for IT developers and users.

– “What is the benefit of dbSQWare for a DBA?”
Thanks to our software of SGBD management and maintenance, backup, restore, environment copy and indicator collection tasks become easy and are followed.
DBA teams can free up time and focus on higher value-added tasks.

INTERFACE

Following the UX / UI Design mission carried out by Atrioom, the developments began.
Our software dbSQWare will soon have a more ergonomic and intuitive interface to offer users a smoother navigation.
No more square and rigid cuts, instead of roundness and glide!
Obviously, new expected features will complete this version.
Still a little patience…

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).

WELCOME

The dbSQWare team is growing!
Welcome to our new trade assistant, Marine Lario!
Student in Master 2, Marine joined the company on Monday and the whole team is very happy to welcome her.

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!

STRONG POINTS

You’ve already heard about the features of our dbSQWare software, which specializes in database management and maintenance, but do you know its strengths?
Here is an overview:
Uniqueness / Speed ​​/ Homogeneity / Ease of Use / Adaptability / Scalability.
Using dbSQWare means mastering the operation and evolution of an entire database!