. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356 7.7.2. Management Statements in PSQL. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 577 13.2. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 615 14. Management Statements . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

will lose the ability to make effective use of database indexes and search facilities — and key management remains a major problem (more below). Chapter 3. The Problem 5 Chapter 4. The Solution There of the Access Layer Various database development libraries interrogate metadata, such as primary key, domain and similar structural information, in order to make development of client applications easier an encrypted file and cannot be accessed without the key. When you start the computer you have to mount the encrypted volume and supply the secret key before the data can be accessed. This additional,

. . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11.1.4. SQL Statements for User Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 402 11 by developers to communicate, through their applications, with the Firebird relational database management system. It has a long history. 1.1. Subject Matter The subject matter of this volume is wholly Keywords The primary construct in SQL is the statement. A statement defines what the database management system should do with a particular data or metadata object. More complex statements contain simpler

15 5. Server configuration and management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 18 5.1. User management . . . . . . . . . . . . . . . About this guide 3 Chapter 2. The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is permitted. The use of Firebird is governed Windows on Windows.) Chapter 4. Default disk locations 17 Chapter 5. Server configuration and management There are several things you should be aware of — and take care of — before you start using your

нескольких записей в подчиненную таблицу). CREATE TABLE my_table ( my_number integer not null primary key ) CREATE GENERATOR my_generator CREATE TRIGGER my_before_trigger FOR my_table BEFORE INSERT AS BEGIN reversed, URL compatible UUID) Parameters: cstring(22) dummy to allow Interbase to perform memory management Returns: cstring(22) **************************************************************/ DECLARE xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx format) Parameters: cstring(36) dummy to allow Interbase to perform memory management Returns: cstring(36) **************************************************************/ DECLARE

. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10 6. Limbo Transaction Management . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . database utility. • Shadow file handling. • Cache and buffer handling. • Transaction management. • Cache management. • Starting and stopping a database. • And much, much more … Chapter 1. Introduction buffers" Page buffers 4000 Chapter 5. Set Database Page Buffers 11 Chapter 6. Limbo Transaction Management Limbo transactions can occur when an application is updating two (or more) databases at the same

ключами шифрования. Шифрование является хорошим настолько, насколько хорош закрытый ключ (secret key), используемый для дешифрования. Оно может быть хуже, но не лучше. Существует несколько замечательных Возможно, шифрование и является сильным, но, если отсутствует хорошая система управления ключами (key management), то шифрование не достигнет желаемого эффекта. Это может лелеять в Вас веру в то, что Вы защищены

die von Entwicklern für die Kommunikation ihrer Anwendungen mit dem Firebird Relation Database Management System benötigt werden. 1.1. Thema Das Kernthema dieses Dokuments ist die vollständige Implementierung CUSTOMER VARCHAR(25) NOT NULL, CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... PRIMARY KEY (CUST_NO) ) 3.1.3. BIGINT BIGINT ist ein SQL:99-kompatibler 64-Bit-Integer-Datentyp, der nur in Dialect beschrieben. Beispiele mit Integer-Typen CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); INSERT INTO MYBIGINTS VALUES ( -236453287458723, 328832607832,

(PRIMARY KEY) ............................................................... 118 Ограничение уникальности (UNIQUE) ........................................................ 118 Внешний ключ (FOREIGN KEY) . NOT NULL, CONTACT_FIRST VARCHAR(15), CONTACT_LAST VARCHAR(20), ... Типы данных 31 PRIMARY KEY (CUST_NO) ); BIGINT BIGINT — это SQL-99-совместимый 64 битный Пример 2.1. Использование типа BIGINT CREATE TABLE WHOLELOTTARECORDS ( ID BIGINT NOT NULL PRIMARY KEY, DESCRIPTION VARCHAR(32) ); Шестнадцатеричный формат для целых чисел Начиная с Firebird 2.5

...... 14 Server configuration and management ................................................................................................... 15 User management: gsec ............................. Firebird 2.0 and 2.1 Quick Start 4 The Firebird licenses Firebird is a free, open-source database management system, but “free” does not mean that everything is per- mitted. The use of Firebird is governed tree within the buildroot.tar.gz archive that's packed inside the kit. Server configuration and management There are several things you should be aware of – and take care of – before you start using your