Maintenance and Security Center

4D now has an integrated Maintenance and Security Center that allows easily performing important operations such as database checks, backups, and optimization.

These operations, which are grouped by function, are available to database administrators (and perhaps users) using a single dialog box.

Total information

This area contains important information about your application (type and version), files (structure and data), and the user license.

Basic information about each table of the database is also available here (name, number of records, number of fields) as well as the size and use percentage of disk files.

Analyze activity

This feature allows you to view operations performed on the database (creation, editing, and deletion of records) and perform a rollback when applicable to correct, for example, a user error.

Follow the backup procedure

You can keep an eye on programmed backups and, if necessary, use a backup should something go awry.

Verify database integrity at any time

You can verify the physical and logical integrity of your database. It is possible to verify the totality of the application and/or data (data + index).

You can also verify the content of a selection of tables or an index. This is particularly useful when working with tables that can contain tens of millions of records!

Once the check is complete, a “report” file is generated in HTML; this file details each of the operations and checks performed.

Compact data easily and efficiently

Compacting data can be useful in cases where the data file has been modified a lot, or when deleting a large number of records, or even certain tables or fields. In this case, compacting data is a great way to increase performance and free up disk space.

Compacting data is easy to do. Simply click “Compact records and index” to get started. 4D takes over and closes the database, compacts the current data file after performing a backup. Like with verification, a “report” file is generated.

Make repairs peacefully

This built-in tool helps you repair your data and application when your database is damaged for any reason. The damaged structure or data are archived before any attempt to repair is made.

During the repair procedure, a report detailing any problems encountered is generated.