|
Firebird (sometimes called FirebirdSQL) is a relational database management system offering many ANSI SQL-2003 features. It runs on Linux, Windows, and a variety of Unix platforms. Firebird was programmed and is maintained by the Firebird Project at SourceForge. It was forked from Borland's open source release of InterBase. Image File history File links No higher resolution available. ...
Software development is the translation of a user need or marketing goal into a software product. ...
A software release is the distribution, whether public or private, of an initial or new and upgraded version of a computer software product. ...
is the 316th day of the year (317th in leap years) in the Gregorian calendar. ...
Year 2006 (MMVI) was a common year starting on Sunday of the Gregorian calendar. ...
// An operating system (OS) is the software that manages the sharing of the resources of a computer. ...
A cross-platform (or platform independent) programming language, software application or hardware device works on more than one system platform (e. ...
Computer software can be organized into categories based on common function, type, or field of use. ...
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by Edgar F. Codd. ...
A software license is a legal agreement which may take the form of a proprietary or gratuitous license as well as a memorandum of contract between a producer and a user of computer software. ...
A website (alternatively, Web site or web site) is a collection of Web pages, images, videos and other digital assets that is hosted on one or several Web server(s), usually accessible via the Internet, cell phone or a LAN. A Web page is a document, typically written in HTML...
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ...
The American National Standards Institute or ANSI (pronounced an-see) is a nonprofit organization that oversees the development of standards for products, services, processes and systems in the United States. ...
SQL (IPA: or IPA: ), commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ...
This article is about operating systems that use the Linux kernel. ...
Windows redirects here. ...
Filiation of Unix and Unix-like systems Unix (officially trademarked as UNIX®) is a computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs including Ken Thompson, Dennis Ritchie and Douglas McIlroy. ...
SourceForge is a collaborative revision control and software development management system. ...
Borland Software Corporation is a software company headquartered in Austin, Texas. ...
Open source refers to projects that are open to the public and which draw on other projects that are freely available to the general public. ...
InterBase is a relational database management system (RDBMS) currently developed and marketed by Borland Software Corporation. ...
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 1.0. Both licences are modified versions of the Mozilla Public License 1.1. The software developer Borland was known for a short time as Inprise. ...
In computing, the Mozilla Public License (MPL) is an open source and free software license. ...
History
Development on the Firebird 2 codebase began with the porting of the Firebird 1.0.x C code to C++ and the first major code-cleaning. Firebird 1.5 is the first release of the Firebird 2 codebase. It is a significant milestone for the developers and the whole Firebird project, but it is not an end in itself. As Firebird 2.0 goes to release, major redevelopment continues toward the next point release on the journey to Firebird 2.x and Firebird 3.0 (code named Vulcan)
Other important information is found on Interbase History page
Firebird at 20 years, Recollection from Jim Starkey (how it all started):
- "September 4, 2004 is the 20th anniversary of what is now Firebird I quit my job at DEC in August, took a three day end-of-summer holiday, and began work on September 4, 1984 in my new career as a software entrepreneur. As best as I can reconstruct, the first two files were cpre.c and cpre.h (C preprocessor), later changed to gpre.c and gpre.h. The files were created on a loaner DEC Pro/350 a PDP-11 personal computer that went exactly nowhere, running XENIX. Gpre was my first C program, XENIX was my first experience with Unix, and the Pro/350 was my very last (but not lamented) experience with PDP-11s."
is the 247th day of the year (248th in leap years) in the Gregorian calendar. ...
Year 2004 (MMIV) was a leap year starting on Thursday of the Gregorian calendar. ...
The DEC logo Digital Equipment Corporation was a pioneering American company in the computer industry. ...
is the 247th day of the year (248th in leap years) in the Gregorian calendar. ...
This article is about the year. ...
The PDP-11 was a 16-bit minicomputer sold by Digital Equipment Corp. ...
Xenix was a version of the Unix operating system, licensed by Microsoft from AT&T in the late 1970s. ...
Xenix was a version of the Unix operating system, licensed by Microsoft from AT&T in the late 1970s. ...
Filiation of Unix and Unix-like systems Unix (officially trademarked as UNIX®) is a computer operating system originally developed in 1969 by a group of AT&T employees at Bell Labs including Ken Thompson, Dennis Ritchie and Douglas McIlroy. ...
The PDP-11 was a 16-bit minicomputer sold by Digital Equipment Corp. ...
Stable version changelog The current stable version is Firebird 2.0.2. This release represents a commitment by the project to develop and deliver ongoing improvements to this popular open source database engine.
Changes from previous version:
This release contains a large number of new features, including derived tables, support for Execute Block, increased table sizes, new improved index code (the 252-byte index length limit is no longer applicable), expression indices, numerous optimiser improvements, enhanced security features, support for on-line incremental backups along with numerous other improvements and bug fixes.
Full Release Notes are available in form of pdf document (right-click and choose Save As)
The current release represents a major upgrade to the engine, which has been developed by an independent team of voluntary developers from the InterBase source code that was released by Borland under the InterBase Public License v.1.0 on 25 July 2000. InterBase is a relational database management system (RDBMS) currently developed and marketed by Borland Software Corporation. ...
Source code (commonly just source or code) is any series of statements written in some human-readable computer programming language. ...
Borland Software Corporation is a software company headquartered in Austin, Texas. ...
is the 206th day of the year (207th in leap years) in the Gregorian calendar. ...
Year 2000 (MM) was a leap year starting on Saturday (link will display full 2000 Gregorian calendar). ...
Quick Start Guide for Firebird 2.0 The Firebird Documentation Subproject has published the Firebird 2.0 version of the Quick Start Guide. It is available on-line as a multi-page HTML document as well as in PDF format. Also, check the "Get to know Firebird in two minutes" document, available in more than 10 languages.
Mozilla Firefox name clash In April 2003, Mozilla Foundation decided to rename their web browser from Phoenix to Firebird. This decision caused concern within the Firebird database project due to the assumption that users would be confused by a database and web browser using the Firebird name. The dispute continued until the Mozilla developers issued a statement making clear that their software package was called "Mozilla Firebird", not "Firebird". The statement also said that the Mozilla Firebird name was a project codename. On February 9, 2004, Mozilla renamed its browser Mozilla Firefox, thus clearing up confusion. 2003 : January - February - March - April - May - June - July - August - September - October - November - December - → A timeline of events in the news for April 2003. ...
The Mountain View office shared by the Mozilla Foundation and the Mozilla Corporation The Mozilla Foundation (abbreviated MF or MoFo) is a non-profit organization that exists to support and provide leadership for the open source Mozilla project. ...
An example of a Web browser (Konqueror) A Web browser is a software application that enables a user to display and interact with text, images, and other information typically located on a Web page at a website on the World Wide Web or a local area network. ...
is the 40th day of the year in the Gregorian calendar. ...
Year 2004 (MMIV) was a leap year starting on Thursday of the Gregorian calendar. ...
Mozilla Firefox is a graphical web browser developed by the Mozilla Corporation, and a large community of external contributors. ...
See also Image File history File links Portal. ...
See DBMS for a shorter list of “typicalâ€, representative database management systems. ...
The following tables compare general and technical information for a number of relational database management systems. ...
Fyracle is a special version of the open source Firebird database which supports Oracle PL/SQL syntax, to ease porting of Oracle applications to open source. ...
External links - Firebird - Project website
- IBPhoenix - Firebird Portal
- FirebirdNews - Major source of Firebird related news
- FlameRobin - cross-platform Administration tool for Firebird, Open Source under MIT license
- Yaffil - ex-fork of Firebird 1.x, when its development was stalled. Now merged back to main stream.
| | | Concepts
Database • Database models • Database storage • Relational model • Distributed DBMS • ACID • Null
Relational database • Relational algebra • Relational calculus • Database normalization • Referential integrity • Relational DBMS
Primary key, Foreign key, Surrogate key, Superkey, Candidate key A database management system (DBMS) is computer software designed for the purpose of managing databases. ...
This article is about computing. ...
A data model is not just a way of structuring data: it also defines a set of operations that can be performed on the data. ...
Database tables/indexes are typically stored in memory or on hard disk in one of many forms, ordered/unordered Flat files, ISAM, Heaps, Hash buckets or B+ Trees. ...
The relational model for database management is a database model based on predicate logic and set theory. ...
According to Elmasri and Navathe (2004, p. ...
For other uses, see Acid (disambiguation). ...
The Greek lowercase omega (ω) character is historically used by academics to represent Null in relational databases. ...
A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ...
Relational algebra, an offshoot of first-order logic, is a set of relations closed under operators. ...
The relational calculus refers to the two calculi, the tuple calculus and the domain calculus, that are part of the relational model for databases and that provide a declarative way to specify database queries. ...
Database normalization is a design technique for structuring relational database tables. ...
An example of a database that has not enforced referential integrity. ...
A relational database management system (RDBMS) is a database management system (DBMS) that is based on the relational model as introduced by E. F. Codd. ...
In database design, a primary key is a value that can be used to identify a unique row in a table. ...
In the context of relational databases, a foreign key is a referential constraint between two tables[1]. The foreign key identifies a column or a set of columns in one (referencing) table that refers to a column or set of columns in another (referenced) table. ...
A surrogate key is a unique primary key generated by the relational database management system that is not derived from any data in the database and whose only significance is to act as the primary key. ...
A superkey is defined in the relational model as a set of attributes of a relation variable (relvar) for which it holds that in all relations assigned to that variable there are no two distinct tuples (rows) that have the same values for the attributes in this set. ...
In the relational model a candidate key of a relation variable (relvar) is a set of attributes of that relvar such that (1) at all times it holds in the relation assigned to that variable that there are no two distinct tuples with the same values for these attributes and...
| | Objects
Trigger • View • Table • Cursor • Log • Transaction • Index
Stored procedure • Partition A database trigger is procedural code that is automatically executed in response to certain events on a particular table in a database. ...
In database theory, a view is a virtual or logical table composed of the result set of a query. ...
In relational databases, SQL databases, and flat file databases, a table is a set of data elements (values) that is organized using a model of horizontal rows and vertical columns. ...
In database packages, the term cursor refers to a control structure for the successive traversal (and potential processing) of records in a result set as returned by a query. ...
In in the field of databases in computer science, a transaction log (also database log or binary log) is a history of actions executed by a database management system to guarantee ACID properties over crashes or hardware failures. ...
A database transaction is a unit of interaction with a database management system or similar system that is treated in a coherent and reliable way independent of other transactions that must be either entirely completed or aborted. ...
It has been suggested that Bitmap index be merged into this article or section. ...
A stored procedure is a subroutine available to applications accessing a relational database system. ...
A partition is a division of a logical database or its constituting elements into distinct independent parts. ...
| Topics in SQL
Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Begin work • Commit • Rollback • Truncate • Alter SQL (IPA: or IPA: ), commonly expanded as Structured Query Language, is a computer language designed for the retrieval and management of data in relational database management systems, database schema creation and modification, and database object access control management. ...
A SELECT statement in SQL returns a result set of records from one or more tables. ...
An SQL INSERT statement adds one or more records to a table in a relational database. ...
An UPDATE statement in SQL changes data in one or more records in a relational database management system. ...
Wikipedia does not have an article with this exact name. ...
It has been suggested that this article or section be merged into Data Manipulation Language. ...
A JOIN clause in SQL combines records from two tables in a relational database and results in a new (temporary) table, also called a joined table. Structured Query Language (SQL:2003) specifies two types of joins: inner and outer. ...
In SQL the UNION operator combines the results of two SQL queries into a single table of all matching rows. ...
A CREATE statement in SQL creates an object inside of a relational database management system (RDBMS). ...
A DROP statement in SQL removes an object from a relational database management system (RDBMS). ...
It has been suggested that this article or section be merged into Database transaction. ...
A COMMIT statement in SQL ends a transaction within a relational database management system (RDBMS) and makes all changes visible to other users. ...
In database technologies, a rollback is an operation which returns the database to some previous state. ...
The Truncate statement removes all the data from a table. ...
An ALTER statement in SQL changes the properties of an object inside of a relational database management system (RDBMS). ...
| | Implementations of database management systems | | Types of implementations
Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Object relational • Temporal • XML data stores A relational database is a database that conforms to the relational model, and refers to a databases data and schema (the databases structure of how that data is arranged). ...
A simple diagram depicting conversion of a CSV-format flat file database table into a relational database table. ...
A deductive database system is a database system which can make deductions (ie: infer additional rules or facts) based on rules and facts stored in the (deductive) database. ...
A dimensional database is one which, rather than representing data in multiple relations (as a relational database does), represents key data entities as different dimensions. ...
In a hierarchical data model, data are organized into a tree-like structure. ...
In an object oriented database, information is represented in the form of objects as used in Object-Oriented Programming. ...
An object-relational database (ORD) or object-relational database management system (ORDBMS) is a relational database management system that allows developers to integrate the database with their own custom data types and methods. ...
A temporal database is a database management system with built-in time aspects, e. ...
In Software engineering, an XML database is a data persistence software system that allows data to be imported, accessed and exported in the XML format. ...
| | Database products
Object-oriented (comparison) • Relational (comparison) The following is a list of object-oriented database management systems. ...
This article or section is not written in the formal tone expected of an encyclopedia article. ...
See DBMS for a shorter list of “typicalâ€, representative database management systems. ...
The following tables compare general and technical information for a number of relational database management systems. ...
| Components
Query language • Query optimizer • Query plan • ODBC • JDBC Query languages are computer languages used to make queries into databases and information systems. ...
The query optimizer is a component of database management system that is used to analyzes queries submitted to database server for execution, and then determines the optimal way to execute the query. ...
A query plan (or query execution plan) is an set of steps used to access information in a SQL relational database management system. ...
In computing, Open Database Connectivity (ODBC) provides a standard software API method for using database management systems (DBMS). ...
JDBC is an API for the Java programming language that defines how a client may access a database. ...
| |
Feeds |
Contact