DBMS : Restoration

– “Restoring a database, what does it consist of? »

To be able to restore a database, you must already have made a backup (full, incremental, log, hot or cold).
Then, restore consists of recovering the backed up files that make up the database.

A well-planned backup and restore strategy helps protect databases from data loss.
It is therefore essential to regularly check your strategy, restoring a set of backups to recover your database.
 

DBMS: Backups

– “By the way, what’s the point of making database backups? »

As its name suggests, a database is a structured collection of data. It consists of files in which the data is stored.
It is created and managed by a database management system (DBMS) which, among other things, allows data to be recorded, searched for, sorted and modified.

Data is at the heart of business activity. It is extremely valuable and its loss can be devastating when there is no copy.
This is why it is essential to make backups of the databases.

There are several types of backup:
– the “full backup”: all the files of a database are copied
– the “incremental backup”: only the blocks of files that have been modified since the last backup are copied
– the “log backup” (redo log, transaction log, wal or xlog): transaction log files are copied. These files are used to memorize all the modifications carried out on a database.

Backups can be made:
– cold: when the database is stopped
– or hot: when the database is active.

Once the backups have been made, it is then possible to recover the data if necessary.

And since trust does not exclude control, it is a good idea to check compliance with the backup policy on a daily basis across the entire database.

Healthcare Meetings 2021

The Healthcare Meetings trade fair starts today!

After a first dinner last night between top decision-makers and exhibitors, today is the launch of the Healthcare Meetings show in Cannes.
For 2 days, this unprecedented event will be punctuated by one-to-one prequalified meetings and numerous exchanges in the field of health.
Michel Payan and Séverine Payan from the dbSQWare team will be on stand K05, to present our software dedicated to the management and maintenance of DBMSs.

The ideal opportunity to discuss with them on database engines, their management and associated issues.

IT Decision Makers Dinner

Dinner for IT decision-makers (DSI, RSSI, CDO, CTO, etc.) organized by the Club Informatique Provence Méditerranée – CIP, this evening at the Novotel Avignon Nord.

Our CEO, Michel Payan, accompanied by Emmy PAYAN, will participate in this exceptional IT event and will represent dbSQWare, sponsor of the CIP.
The theme of the evening will be: The Factory of the Future.

Congratulations to the members of the CIP for the organization of this event and good dinner to all the participants!

HALLOWEEN

Trick or treat … In 2 days, it will be Halloween!

For the occasion, the dbSQWare team wishes you a happy party with family, friends or colleagues!

Incontournable CIP Avignon_10/2021

Tonight, afterwork “Incontournable Avignon” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan will represent dbSQWare, sponsor of the CIP, at this event which will take place at the Novotel Avignon Nord in Sorgues and whose theme will be: the modernization of the IS.

Good event to all participants!

BSPP & SDIS 13

The Paris Fire Brigade (BSPP) and the Bouches-du-Rhône Departmental Fire and Rescue Service (SDIS 13) have adopted dbSQWare.

With these 2 new collaborations, a new profession opens its doors to us: that of firefighters.
Responsible for the prevention, protection and fight against fire, firefighters also fulfill the missions of protection and rescue of people, prevention, protection and fight against accidents and disasters.

We are very happy that they have placed their trust in us and that our software can help them in their daily tasks of managing and maintaining their database.
Risk prevention, security and anticipation are part of the specific features of our software and the requirements that we share with them.

WELCOME TO YOU

We are very happy to welcome 3 new work-study students to the dbSQWare team.

On the business side, Agnès Nagamany who is in Bachelor 3 – Sales & Negotiation at Euridis Business School joined us on 20/09.
On the IT side, Ruben Ruiz and Thomas PAYAN who are both in Bachelor 3 – IT at AIX YNOV CAMPUS are starting their work-study programs today.

Welcome to all 3!

Incontournable CIP

Tonight, afterwork “Incontournable Nice” organized by the Club Informatique Provence Méditerranée – CIP.

Michel Payan and Matthieu Charton will represent dbSQWare, sponsor of the CIP, during this face-to-face event which will take place at the Aqueducts in Sophia Antipolis and whose theme will be: diversity in the digital world.

Good event to all participants!

IT & IT Security Meetings 2021

Tonight, the IT and IT Security Meetings will begin with a dinner between top decision makers and exhibitors.
The following 2 days will take place at the Palais des Festivals et des Congrès in Cannes. They will be punctuated by one-to-one meetings and discussions within the show.

Michel Payan and Séverine Payan from the dbSQWare team will be present, for this IT event, on stand A15.

The opportunity to discuss database engines, their management, their issues and to present our software dedicated to the management and maintenance of DBMS.