RAD Studio 10.4 est disponible dès maintenant! En savoir plus…

Deep discounts available on InterBase 2020 for OEM or VARs – Contacter le
service des ventes

En quête de Rabais ? Visitez notre page Offres spéciales

Renouvelez votre licence d'Update Subscription maintenant En savoir plus…

InterBase Fonctionnalités

Une base de données SQL ultrarapide, extensible et intégrable dotée de fonctions avancées de sécurité, de restauration sur sinistre et de synchronisation du changement

ou demander une démonstration de produit

Base de données SQL

SQL Language/Unicode

InterBase est une base de données compatible avec les standards SQL. A partir de SQL92, toutes les fonctionnalités ajoutées à InterBase respectent strictement les normes de l'industrie. Grâce à la prise en charge d'Unicode, InterBase est une solution idéale pour tous les jeux de caractères, c’est pourquoi elle est si largement déployée dans le monde entier.

InterBase offers a range of SQL language features including multiple join and unicode.

Transactions and Multigenerational Architectures

When making a change in InterBase, you must first start a transaction. A transaction can be connected using multiple options, allowing for either a live view or a snapshot view of the data. This ability to have multiple view types of the data is thanks to InterBase’s being built using a multigenerational architecture.

Having a multigenerational architecture is exceptionally powerful when it comes to reporting. Having the ability to connect with a consistent snapshot of the database ensures that you are always comparing like for like. Equally important, the multigenerational architecture also ensures that readers don’t block writers from making changes, increasing database scalability, and also enabling other key features like online backup and Change Views.

Alertes événementielles

Finding out something is changed in a central database is a typical concern of developers. InterBase Events enable a live time alert to connected clients that something has changed. Alerts are sent immediately after the transaction making the change is committed. This saves on CPU-intensive database polling, thus increasing database scalability. When run alongside Change Views, Events allow for the fastest way to fetch data changes by collecting just the delta of what has changed from the server, additionally reducing network traffic and associated costs.

Change Views

The award-winning Change Views is a patent-pending feature of InterBase that allows developers to identify what has changed in the database. Working with Change Views is simple; running the same SQL statement in subsequent transactions will return only the delta. This makes fetching and identifying changed data very simple.

Change Views works with the multigenerational architecture of InterBase to speed up applications and lower network traffic and costs by finally allowing briefcase data to become always relevant, removing the need to fetch the same data time and time again.

Lire le livre blanc consacré à Change Views

Managed Fields Definitions/Domains

InterBase domains allow you to define a specific field type (e.g., VarChar(20)/Integer, etc.) and define properties for that field (e.g., Can it be null? or can it define a range of values that can be passed in?). Using InterBase domains allows you to easily manage the same field type across your database. This simplifies adding the same type of field everywhere, and as it is defined once, so you can easily update the field type across the database if requirements ever change.

Procédures enregistrées

InterBase stored procedures allow you to compile server-side functions into your database engine that enables easily updatable business logic that clients can call. This could be to ship an order or add a new customer—the options are endless. You can also run select statements against stored procedures to return a custom layout of data. You can even build SQL statements inside your stored procedures to run, based on data passed in or fetched.

Déclencheurs

Les déclencheurs sont une puissante fonctionnalité offrant une large gamme de modes d'utilisation. Ils peuvent notamment être utilisés dans les contextes suivants:

  • To make correlated updates - for example, to keep a log file of changes to a database or table.
  • Pour appliquer des restrictions, de sorte que seules les données valides sont entrées dans les tables.
  • Automatic transformation of data - for example, to automatically convert text input to uppercase.
  • Pour notifier les changements de la base de données aux applications à l'aide d'alertes événementielles.
  • Pour effectuer des mises à jour en cascade d'intégrité du référentiel.

Générateurs

Generators allow you to fetch sequential numbers that are typically used for primary keys within InterBase. Generators work across database transactions, and InterBase will not assign a duplicate key. InterBase generators allow you to enable the database to be responsible for the production of key values centrally in the database.

Exceptions personnalisées

InterBase allows you to build database logic to manage the data being passed in. Working alongside stored procedures and triggers that happen before the data is updated, you can raise a custom exception from the server if bad data is passed in.