.

• What is interbase DB

  InterBase is a relational database management system (RDBMS) currently developed and marketed by Embarcadero Technologies. InterBase is distinguished from other RDBMSs by its small footprint, close to zero administration requirements, and multi-generational architecture.[1] InterBase runs on the Linux, Microsoft Windows, Mac OS X and Solaris operating systems.

• Technology

  In many respects, InterBase is quite conventional; it is a SQL-92-compliant relational database and supports standard interfaces such as JDBC, ODBC, and ADO.NET. However, certain technical features distinguish InterBase from other products.

• Environment and Support

  A full InterBase 2009 server installation requires around 40 MB on disk. This is significantly smaller than the client installation of many competing database servers. The server uses very little memory when idle. A minimum InterBase client install requires about 400 KB of disk space.

InterBase Software--originally known as Groton Database Systems--was born in Ann Harrison's spare room. Ann was the first junior programmer for the company and worked on nearly every component between version 0 and 3.3.[4]
Jim Starkey was working at DEC on their Datatrieve network database product when he came up with an idea for a system to manage concurrent changes by many users. The idea dramatically simplified the existing problems of locking which were proving to be a serious problem for the new relational database systems being developed at the time. He started working on the system at DEC, but at the time DEC had just started a relational database effort which lead to the Rdb/VMS product. When they found out about his project a turf war broke out (although the product was released as Rdb/ELN), and Starkey eventually decided to quit.
Although InterBase's implementation is much more similar to the system described by Reed in his MIT dissertation than any other database that existed at the time and Starkey knew Bernstein from his previous position at the Computer Corporation of America and later at DEC, Starkey has stated that he arrived at the idea of multiversion concurrency control independently.[5] In the same comment, Starkey says:

The inspiration for multi-generational concurrency control was a database system done by Prime that supported page level snapshots. The intention of the feature was to give a reader a consistent view of the database without blocking writers. The idea intrigued me as a very useful characteristic of a database system. He had heard that the local workstation vendor Apollo Computer was looking for a database offering on their Unix machines, and they agreed to fund development. With their encouragement he formed Groton Database Systems (named after the town, Groton, Massachusetts, where they were located) on Labor Day 1984 and started work on what would eventually be released as InterBase. In 1986 Apollo suffered a corporate shakeup and decided to exit the software business,[citation needed] but by this time the product was

At the end of 2002, Borland released InterBase version 7, featuring support for SMP, enhanced support for monitoring and control of the server by administrators, and more. Borland released InterBase 7.1 in June 2003, 7.5 in December 2004, and 7.5.1 on June 1, 2005.

In September 2006, Borland announced[9] the availability of InterBase 2007. Its new features include point in time recovery via journaling (which also allows recoverability without the performance penalty of synchronous writes), incremental backup, batch statement operations, new Unicode character encodings, and a new ODBC driver.

In September 2008, Embarcadero announced[10] the availability of InterBase 2009. Its new features include full Database Encryption, selective Column-level data encryption and over-the-wire encryption offering secure TCP/IP communication via SSL.

In September 2010, Embarcadero announced[11] the availability of InterBase XE. Its new features include a 64 bit client and server, improved security, improved scalability, support for dynamic SQL in stored procedures, and optimized performance of large objects with Stream methods. References

Install InterBase and Create a New Database  - December 22, 2000

The following text only applies to Biblioscape before version 5. 
InterBase, well known for its low-maintenance, enterprise-class relational database management system (RDMS), offers a powerful, reliable, easy-to-use solution for Biblioscape customers who needs Client/Server setup. Best of all, InterBase is the first commercial quality SQL database to become open source and it is completely free. The following tutorial shows you how to setup InterBase and create a new empty database. You can then convert your existing Biblioscape database in Paradox into InterBase with the DataPump utility.
1. Click here to download the latest release of InterBase at Borland Web site for free.
2. Unzip the downloaded file into an empty directory and run the setup.exe to install InterBase.
3. Once it is installed, click Windows status bar "Start | Programs | InterBase | IBConsole" to start InterBase console manager. First, you need to register the server. By default, you can login to the server as system administrator "SYSDBA" with password "masterkey". To register the local server, click menu command "Server | Register...". Select "Local Server". Enter "SYSDBA" as the user name and "masterkey" as the password. Click OK button to register. 

4. Once you registered local server, a Local Server icon will be shown on the left of the IBConsole. Next time when you start IBConsole, the local server icon will be shown, but you need to login to the server. Select the "Local Server" icon, then click right mouse button to show the popup menu. Click "Login" and enter the user name and password to login. 
 
Once you registered the local server, you can change the default password for the "SYSDBA" account. To do that, click menu command "Server | User Security...". You can also create new user. In this tutorial, we assume you will keep using the default "SYSDBA" account.

5. Now, you need to create a new empty database. On the IBConsole Window, click menu command "Database | Create Database...". Enter an alias. For example "biblioscape4_ib". Enter the full path name of your InterBase database to be created. For example "d:\temp7\biblioscape4_ib.gdb". In the "Options" section, select "1" as the "SQL Dialect". This is very important, otherwise, your Biblioscape database in Paradox won't be converted into InterBase successively. Click OK button to create the database. Now, you have created an InterBase database without any table. You can then use the DataPump utility to convert your default Biblioscape database in Paradox format into this InterBase database.
 

Certain operations are more difficult to implement in a multi-generational architecture, and hence perform slowly relative to a more traditional implementation. One example is the SQL COUNT verb. Even when an index is available on the column or columns included in the COUNT, all records must be visited in order to see if they are visible under the current transaction isolation.

Click here to download interbase database