database.sarang.net
UserID
Passwd
Database
DBMS
MySQL
PostgreSQL
ㆍFirebird
Oracle
Informix
Sybase
MS-SQL
DB2
Cache
CUBRID
LDAP
ALTIBASE
Tibero
DB 문서들
스터디
Community
공지사항
자유게시판
구인|구직
DSN 갤러리
도움주신분들
Admin
운영게시판
최근게시물
Firebird News 155 게시물 읽기
 News | Q&A | Columns | Tutorials | Devel | Files | Links
No. 155
[2008-04-18] Firebird 2.1 is Released
작성자
이창민(prosper)
작성일
2008-05-12 14:01
조회수
5,417



Firebird 2.1 is a full version release that builds on the architectural changes introduced in the V.2.0 series. Thanks to all who have field-tested the Alphas and Betas during 2007 and the first quarter of 2008 we have a release that is bright with new features and improvements, including the long-awaited global temporary tables, a catalogue of new run-time monitoring mechanisms, database triggers and the injection of dozens of internal functions into the SQL language set.

New in V.2.1

Database Triggers User-defined PSQL modules that can be designed to fire in various connection-level and transaction-level events.
Global Temporary Tables SQL standards-compliant global temporary tables have been implemented. These pre-defined tables are instantiated on request for connection-specific or transaction-specific use with non-persistent data, which the Firebird engine stores in temporary files.
Common Table Expressions (CTEs) Standards-compliant common table expressions, which make dynamic recursive queries possible.
RETURNING Clause Optional RETURNING clause for all singleton operations, update, insert and delete operations.
UPDATE OR INSERT Statement New UPDATE OR INSERT for MERGE functionality: now you can write a statement that is capable of performing either an update to an existing record or an insert, depending on whether the targeted record exists.
LIST() function A new aggregate function LIST() retrieves all of the SOMETHINGs in a group and aggregates them into a comma-separated list.
New Built-in Functions Dozens of built-in functions replacing many of the UDFs from the Firebird-distributed UDF libraries.
Text BLOBs Can Masquerade as Long VARCHARs At various levels of evaluation, the engine now treats text BLOBs that are within the 32,765-byte size limit as though they were varchars. String functions like cast, lower, upper, trim and substring will work with these BLOBs, as well as concatenation and assignment to string types.
Define PSQL Variables and Arguments using Domains PSQL local variables and input and output arguments for stored procedures can now be declared using domains in lieu of canonical data types.
COLLATE in PSQL Collations can now be applied to PSQL variables and arguments.
Windows Security to Authenticate Users Windows "Trusted User" security can be applied for authenticating Firebird users on a Windows server platform host.
CREATE COLLATION Command The DDL command CREATE COLLATION has been introduced for implementing a collation, obviating the need to use the script for it.
Unicode Collations Anywhere Two new Unicode collations can be applied to any character set using a new mechanism.
New Platform Ports Ports to Windows 2003 64-bit (AMD64 and Intel EM64T) Classic, Superserver and Embedded models; PowerPC, 32-bit and 64-bit Intel Classic and SS ports for MacOSX.
Database Monitoring via SQL Run-time database snapshot monitoring (transactions, tables, etc.) via SQL over some new virtualized system tables. Included in the set of tables is one named MON$DATABASE that provides a lot of the database header information that could not be obtained previously via SQL: such details as the on-disk structure (ODS) version, SQL dialect, sweep interval, OIT and OAT and so on. It is possible to use the information from the monitoring tables to cancel a rogue query.
Remote Interface The remote protocol has been slightly improved to perform better in slow networks once drivers are updated to utilise the changes. Testing showed that API round trips were reduced by about 50 percent, resulting in about 40 per cent fewer TCP round trips.

[Top]
No.
제목
작성자
작성일
조회
164[2008-07-16] Firebird 2.1.1 is Released
이창민
2008-11-20
6699
163[2008-07-12] Firebird 2.5 Alpha 1 is Ready to Test
이창민
2008-11-20
5807
156[2008-04-28] Firebird 2.0.4 is Released
이창민
2008-05-12
5650
155[2008-04-18] Firebird 2.1 is Released
이창민
2008-05-12
5417
153[2007-10-26] Firebird v.2.0.3 is Released
이창민
2008-01-20
5618
152[2007-12-12] Firebird 1.5.5 is Released
이창민
2008-01-20
5377
147FireBird Security Hole
이창민
2007-10-09
5626
Valid XHTML 1.0!
All about the DATABASE... Copyleft 1999-2019 DSN, All rights reserved.
작업시간: 0.069초, 이곳 서비스는
	PostgreSQL v11.5로 자료를 관리합니다