MISSION

I put on my flying superhero outfit to the rescue of the DBMS!!

Thanks to my superpowers drawn from dbSQWare:
💻 I assist database administrators in their daily DBMS management and maintenance tasks.
⏳ I save them time.
👓 I provide them with a complete view of DBMS and associated tasks.
🐙 I make them more agile.

CANDLEMAS

Today is Candlemas!
The opportunity for pancake lovers to share a good moment of conviviality with colleagues, friends or family!

Enjoy yourself!!

CIP General Meeting

This evening will be held the Annual General Meeting of the CIP – Club Informatique Provence Méditerranée.
Meet at 6 p.m. at the TheCamp innovation center in Aix-en-Provence.
As a member of the office, our president, Michel Payan will be present.

Happy meeting to all participants!

TECHSHOW 2022

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!

DBMS: Update Statistics

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.

GEOGRAPHICAL DISTRIBUTION

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 ALBAN

Welcome to Alban Vassallo, our new database administrator!

Alban joined dbSQWare yesterday.
We are very happy with his arrival in the team.

DBMS: Reorganize

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.

WELCOME

Welcome to Julien Cornand and Ewan Ducouet who started their new alternation yesterday!
Both are in Bachelor 3. Julien is training as a system and network administrator from CESI and Ewan is training as a computer and information systems expert from AIX YNOV CAMPUS.
We are delighted to welcome them to our team.

We also wish a good continuation to 2 of our work-study students, who after a year of apprenticeship at dbSQWare, are leaving for new horizons: Agnès Nagamany, on the international trade side and Ruben Ruiz, on the cybersecurity side.

Good way to all!

CIP FESTIVE EVENING 2022

This evening, Festive Evening of the Club Informatique Provence Méditerranée – CIP, at the TheCamp innovation center, in Aix-en-Provence.

dbSQWare will participate with great pleasure in this annual event, expected by all.
Theme of the evening: “Summer Party”… Atmosphere assured!

Congratulations to the members of the CIP for the organization and good evening to all the participants!