 | Firebird Relational DatabaseA cluster of databases through JDBC. |
| Download | |
Firebird Relational Database Ranking & Summary
Advertisement
Firebird Relational Database Tags
Firebird Relational Database Description
A cluster of databases through JDBC. Firebird is a relational database offering many ANSI SQL-99 features that runs on Linux, Windows, and a variety of Unix platforms.Firebird offers excellent concurrency, high performance, and powerful language support for stored procedures and triggers. Firebird Relational Database has been used in production systems and under a variety of names since 1981.Firebird is a commercially independent project of C and C++ programmers, technical advisors and supporters developing and enhancing a multi-platform relational database management system based on the source code released by Inprise Corp (now known as Borland Software Corp) on 25 July, 2000 under the InterBase Public License v.1.0.New code modules added to Firebird are licensed under the Initial Developer's Public License. (IDPL). The original modules released by Inprise are licensed under the InterBase Public License v.1.0. Both licences are modified versions of the Mozilla Public License v.1.1.Installing:In order to install the firebird version of IB 6.0 you will need to perform the following steps: 1. Get the required packages: Get the glibc update from RedHat, the one I used was from ftp://updates.redhat.com/7.0/i386/glibc-2.2-5.i386.rpm Get ncurses4 from ftp://carrier.ision.net/pub/ftp.redhat.com/i386/en/RedHat/RPMS/ncurses4-5.0-2.i386.rpm or another redhat mirror. Get Firebird from . Prepare the installation: Log in as root. Use a plain text console to do this and be sure that all Gnome desktops are closed. (One user reported that the Gnome desktop (apparently ICEwm) blocked port 3050. I could not reproduce this here, but it seems that it uses port numbers that aren't assigned in /etc/services for own purposes)3. Add localhost.localdomain to /etc/hosts.equiv: echo localhost.localdomain >>/etc/hosts.equiv4. Change to the directory where you have placed the downloaded packages.5. Install the glibc update: rpm --install --force glibc-2.2-5.i386.rpm6. Install libncurses.so.4: rpm --install --force ncurses4-5.0-2.i386.rpm7. Install Firebird: rpm --install --force FirebirdSS-0.9-1.i386.rpm8. Add /opt/interbase/bin to your path: You can either change /etc/profile or do export PATH=$PATH: /opt/interbase/bin or change the profiles in your users home directories9. Check that all went well: Read /opt/interbase/SYSDBA.password to get your SYSDBA password. gsec -display should display the list of known users (SYSDBA only after a fresh install) isql /opt/interbase/examples/employee.gdb SQL> SHOW TABLES; should display all tables from this database SQL>quit; What's New in This Release: · The primary goal for Firebird 2.5 was to establish the basics for a new threading architecture that is almost entirely common to the Superserver, Classic and Embedded models, taking in lower level synchronization and thread safety generally. · Although SQL enhancements are not a primary objective of this release, for the first time, user management becomes accessible through SQL CREATE/ALTER/DROP USER statements and syntaxes for ALTER VIEW and CREATE OR ALTER VIEW are implemented. PSQL improvements include the introduction of autonomous transactions and ability to query another database via EXECUTE STATEMENT. Administrative Enhancements: · System audit tracing and user trace sessions via the Services API, making it possible to monitor and analyse everything going on in a database in real time · New system role RDB$ADMIN in the ODS 11.2 database allows SYSDBA to transfer its privileges to another user on a per-database basis · More information in the monitoring tables · Asynchronous cancellation of connections · Capability for ordinary users to monitor any of their own attachments as well as CURRENT_CONNECTION Other SQL Language Additions and Enhancements: · Regular expression support using the SIMILAR TO predicate · ALTER COLUMN for computed columns · Autonomous transactions within a PSQL module (stored procedure, trigger or dynamically executable PSQL block) · Enhanced access to stored procedures in view definitions · Optional GRANTED BY or GRANTED AS for GRANT and REVOKE statements, enabling the grantor to be a user other than the CURRENT_USER (the default). · REVOKE ALL syntax to dispose of all privileges for a user or role at once · Support for WHERE SOME_COL = ? OR ? IS NULL predications · Removal of “reserved” status for all but a handful of keywords that are not reserved in the SQL standard Data-handling Enhancements: · New built-in functions for converting UUID CHAR(16) OCTETS strings to RFC4122-compliant format and vice versa · Ability to pass 32-bit and 64-bit integers as hexadecimal in numeric literal and X-prefixed binary string literal formats API Additions: · Statements now return an SQL-2003 standard 5-alphanumeric SQLSTATE completion code · New constant DSQL_unprepare available for use with isc_dsql_free_statement for efficient unpreparing of statements International Language Support: · Default COLLATE clause for CREATE DATABASE · Ability to change the default COLLATE for a used character set · GBAK restore switches FIX_FSS_DATA and FIX_FSS_METADATA to restore legacy databases with UNICODE_FSS data and/or metadata correctly without resorting to scripts and manual techniques · Accent-insensitive collation for Unicode
Firebird Relational Database Related Software