The dbSQWare team wishes you a Happy New YEAR 2023!
May it allow you to accomplish all your professional and personal projects.
For our part, we will continue to do our utmost to satisfy our customers and respond to DBMS management and maintenance issues.
Because facilitating the daily lives of DBA teams and their CIOs will remain our priority once again this year!
The dbSQWare team wishes you a Merry CHRISTMAS 2022!
Very happy holiday season.
See you next year!
As the end of the year approaches, we would like to thank you, dear users, for your trust and loyalty!
dbSQWare has just celebrated its 15th anniversary and has therefore been installed by some of our historical customers.
THANK YOU for your interest, your involvement and your solicitation!
dbSQWare is a multi-DBMS operating and maintenance software that supports 12 types of database engines which are among the most widespread and most used.
Supported versions have a range of 30 years, from the early 90s for some DBMS (Oracle 7, SQL Server 6.5) until today.
dbSQWare supports 9 RDBMS (Relational Database Management System):
– Oracle, most popular on UNIX/Linux
– SQLServer, developed by Microsoft and mainly deployed on Windows
– Teradata, a historical RDBMS with colossal storage capacities
– Sybase, acquired by SAP and former market leader
– DB2 LUW, the distributed system version of the Mainframe engine
– Ingres, dating from the 80s and in Open Source since 2004
– MySQL, the most popular Open Source RDBMS
– MariaDB, a fork of MySQL
– PostgreSQL, the most advanced Open Source RDBMS
and 3 NoSQL:
– Cassandra and her column-oriented organization
– MongoDB, the most popular NoSQL, with a document-oriented organization
– Adabas Linux version, accessible by the natural language.
Despite the diversity of these database engines and their heterogeneity, dbSQWare makes it possible to have a common approach via a centralized and homogeneous exploitation.
The TECHShow 2022 is today and it’s happening at the Aix-en-Provence Congress Center.
Michel Payan and Séverine Payan are waiting for you on the dbSQWare stand to present our multi-DBMS operating and maintenance software.
A good day in perspective, made of meetings and exchanges, multiple and varied.
Good event to all!
A statistic (on a table, a column / a set of columns or on an index) provides information on:
– the table (number of lines, average size of a line, number of blocks/page, density),
– the distribution of values for the column(s) (number of distinct values, number of duplicates, existence of null values, histogram of distribution of values),
– the composition of the index (depth, number of blocks, cluster ratio).
These statistics are used by the database optimizer to study the different execution plans that can be used for a query.
The optimizer (based on costs / CBO) chooses the best execution plan (least expensive) from the data calculated from these statistics on, in particular, the number of rows and blocks of data to be shuffled at each stage of these plans (access strategies).
Statistics are essential for the proper calculation of query execution plans. It is therefore essential that they are up to date to take into account changes to the data and therefore to the indexes, columns and tables.
Thanks to update statistics, the optimizer has reliable data to choose the best performing execution plan to serve data to applications.
Initially implemented exclusively in the Paris region, our software dbSQWare has since made its way.
It’s thanks to our users: their trust, loyalty and high standards.
The software is constantly evolving to meet customer needs.
This year, 6 patches have completed and enriched the 2022 version of dbSQWare.
The 7th will be released in a few days while waiting for the 2023 version…
Welcome to Alban Vassallo, our new database administrator!
Alban joined dbSQWare yesterday.
We are very happy with his arrival in the team.
An optimized database improves query performance, reduces processing times and reduces resource consumption (CPU, RAM, Storage, etc.). This is why it is essential to maintain an efficient organization of databases.
Hence the need for reorganization when this is not the case.
This task consists of physically reorganizing indexes and/or tables with the aim of optimizing the use of disk space and improving access to data (through their organization), recovering unused disk space, left by deleted records and/or data updates.
The operation to be carried out depends on the degree of dispersion of the index (or table) information in the database (called fragmentation):
– compaction (REORGANIZE or COMPACT) is often necessary for fragmentation between 10 and 30%
– beyond that, a reconstruction (REBUILD) must be carried out.
A “side effect” of rebuilding a table is rebuilding all of its indexes.
In any case, a successful database is a database that is monitored and maintained.
If you want to discover the dbSQWare software and learn more about its major functionalities in terms of DBMS operation and maintenance (backup, restoration, copying of environments, reorganization, update statistics, etc.), all you need to do is to participate in a Discovery webinar.
Led by our sales team, it will allow you to discuss in complete confidentiality the management of your database engines, your expectations and the problems encountered.
To register, go to the “Webinar” tab on our website (fr).