Leaflet

Download a Free Trial at www.embarcadero.com
Corporate Headquarters | Embarcadero Technologies | 100 California Street, 12th Floor | San Francisco, CA 94111 | www.embarcadero.com | [e-mail]
© 2010 Embarcadero Technologies, Inc. Embarcadero, the Embarcadero Technologies logos, and all other Embarcadero Technologies product or service names are trademarks or registered trademarks of Embarcadero Technologies, Inc.
All other trademarks are property of their respective owners. INTBXE/DS/2010/09/10
InterBase XE (10.0):
• 32 MB RAM
• 20/35 MB hard disk space for compact/
full install
• CD-ROM drive
Processor:
• Microsoft
®
Windows
®
and Linux:
Intel
®
x86
• Sun Solaris
™
: SPARC
• Macintosh: Intel
Windows:
• Microsoft
®
Windows Vista
™
(requires administrator rights)
• Microsoft
®
Windows Server
®
2008 R2
(64-bit)
• Microsoft
®
Windows
®
XP (SP3)
• Microsoft
®
Windows 7
(32-bit and 64-bit)
Macintosh:
• Mac OS
®
X 10.5
• Mac OS
®
X 10.6
System Requirements
ER/Studio Portal
™
InterBase
®
XE
Feature Description
New! Stronger password protection with
SHA-1 cryptographic hash function
InterBase XE supports passwords up to 32 bytes long. Enables more robust authentication for InterBase databases and compliance
with password requirements from the Payment Card Industry – Data Security Standard (PCI-DSS) and other security requirements.
New! Support for Dynamic SQL in
Stored Procedures
Now you can leverage a very exible and powerful tool from within Stored Procedures. With InterBase XE, you can use
dynamic SQL to accomplish tasks such as adding where clauses to a search based on what fields are filled out on a form
or to create tables with varying names from Stored Procedures with Execute Statement
New! Support for increase buffer caches
for improved performance
Improved scalability and performance with the ability to congure up to 75M pages on 64-bit systems to improve performance
on large data sets.
New! Optimized performance of large
objects with Stream methods
Simpler, faster and standard compliant access to BLOB data types.
New! Improved scalability with the
ability to handle 8 times more data.
Handle up to 8 times more data in InterBase XE with 40-bit record IDs
New! 64-bit native binary application Ability to leverage the 64-bit capabilities and scalability of underlying systems. Fully compatible with 32-bit InterBase applications.
New! Table-Specic Blocking Factors Increases storage capacity of large tables while reducing memory requirements for run-time retrieval
New! Larger index key segment size Now larger column data can use this for both single-byte character sets and multi-byte (such as UTF8) columns.
New! Support for larger external les InterBase XE now supports external les >4GB
Over-the-Wire (OTW) Encryption Encrypts the data as well as any other communications (commands, etc.) between servers and clients New
Database and Column-Level Encryption Encrypts a database and/or individual columns in a database New
To-Go Edition Is a small, portable version of the Desktop Edition. Target applications for the To-Go Edition include small devices and
public kiosks, as well as Value Added Reseller (VAR) and OEM applications that were built using InterBase. New
Built-in SMP Support Gives you high performance on multiple CPU systems including multi-core CPUs
Journaling with Write Ahead Logging
(WAL)
Improves VLDB management, OLTP performance, and facilitates disaster recovery. Only available with Server Edition.
Journal Archiving Provides disaster recovery in the event a database becomes unavailable due to hardware or software failures that may make the
primary database permanently inaccessible. Only available with Server Edition.
Point-in-Time-Recovery Allows journal based recovery based on timestamp for greater recovery exibility. Only available with Server Edition.
Incremental Backup Backup databases between maintenance sessions
Batch Updates Allow you to send a group of SQL statements, reducing the network trafc, resulting in improved performance, especially in
LAN and WAN environments
Blob/Text SQL Syntax Enhancements Supports use of BLOBs and VARCHAR data interchangeably, even in stored procedures
Extended International Character Support Supports character sets via Unicode UCS-2 and UTF-8
Concurrent Running Enables multiple instances of InterBase® to run on the same machine simultaneously for application isolation and load balancing
Global Temporary Tables Allows you to implement the functionality of SQL global temporary tables to signicantly ease application development
Embedded Database User Authentication Enables isolated user authentication for unrelated applications
Support for the SQL99 SAVEPOINT
portability
Supports Windows®, Linux, and Java™, with complete database portability
Performance Monitoring Includes an enhanced, more intuitive IBConsole user interface. Only available with Server Edition.
Multigenerational Architecture Enables unparalleled concurrency between readers and writers
Native Multi-Threaded Server Provides background garbage collection and multi-user page buffer management
Active Database functions for extensible
query support
Includes modular triggers and event alerts, user-dened functions for extensible query support
Stored Procedures Encapsulates business logic on server for reduced network traffic
Linux:
• Red Hat Enterprise Linux 5
• SuSE Linux 10 and 11
Solaris
™
:
• Sun
™
Solaris 10
JDBC
™
:
• JDK
™
1.2, 1.3, 1.4, J2SE
™
5, Java
™
SE 6,
JDBC Type 4 Driver (this applies to Server
Edition and Desktop Edition)