This chapter describes Blackfish SQL features.
Blackfish™ SQL is a high-performance, small-footprint, transactional database. Blackfish SQL was originally implemented as an all-Java database called JDataStore. This is now called Blackfish SQL for Java. Blackfish SQL was then ported from Java to C#. The C# implementation is called Blackfish SQL for Windows.
The design and implementation of Blackfish SQL emphasizes database performance, scalability, ease of use, and a strong adherence to industry standards. Blackfish SQL capabilities include the following:
Blackfish SQL is the name of the product, its tools, and of the file format. Within RAD Studio, there are assemblies that include classes that start with DataStore.
Blackfish SQL for Windows and Blackfish SQL for Java are compatible, though some restrictions apply. The database file format is binary-compatible between the two. The database clients and servers are interchangeable. Windows clients can connect to Java servers and Java clients can connect to Windows servers. However, because the Blackfish SQL for Windows implementation is more recent, some Blackfish SQL for Java features are not yet supported for the Windows version.
For additional information about Blackfish SQL compatibility, see System Architecture.
Blackfish SQL for Windows provides the following database drivers:
For instructions on using these drivers, see Establishing Connections.
The Blackfish SQL API may be used in Delphi and C++ programs with the DBXClient DBX4 driver. .NET applications can use the API with the ADO.NET Provider. In RAD Studio the API is in the Borland.Data.DataStore and Borland.Data.MetaData namespaces.
The administrative capabilities listed below are not yet supported in DataExplorer for Blackfish SQL for Windows. Use SQL commands or Blackfish SQL built-in DB_ADMIN stored procedures to complete these tasks.
Two classes are available, DB_ADMIN and DB_UTIL. These methods can be called from SQL using the CALL statement. They can be called without creating a METHOD alias, because the Blackfish SQL dialect recognizes methods in DB_ADMIN as built-in methods.
DB_ADMIN is a group of stored procedures for performing a variety of database administration tasks. Some of the capabilities include:
For more information, see the Stored Procedures Reference.
DB_UTIL is a set of SQL stored procedures for performing numeric, string and date/time operations on data stored in database tables. These procedures include such functions as:
For more information, see the Stored Procedures Reference.
Blackfish SQL includes an ADO.NET implementation. This is similar to the AdoDbx Client, which is also an ADO.NET implementation.
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
|
What do you think about this topic? Send feedback!
|