Product Overview
The Recital 9 Database Server provides a complete
open solution to universal data connectivity between Windows, Linux,
Unix and OpenVMS, clients and servers. The Recital 9 Database Server
is a platform, language and data source independent solution that
defines and delivers technologies for building client/server and
internet-based database solutions that seek to maximize the business
advantage from the data and information distributed throughout an
organization.
Recital 9 Database
Server Components
- Recital Enterprise Studio IDE
(Optional additional purchase)
- Recital Universal Client Drivers
- Recital Universal Application Server
- Recital Universal Database Drivers
From version Recital 9.1 onwards, Recital Database
Server application developers can benefit from the use of the Recital
Enterprise Studio IDE. Recital Enterprise Studio is a common application
development workbench used to develop, debug, and deploy Recital
9 Terminal, Graphical, Web and Database Server applications across
multiple platforms including Windows, Linux and UNIX. Please click
here for a tour of the Recital Enterprise
Studio Database Administrator.
The Recital 9 Database Server Architecture
The Recital 9 Database Server is implemented as an n-tier client/server architecture comprised of Universal Client Drivers, a Universal Data and Application Server, and Universal Database Drivers which include an ODBC server, a JDBC server, and an ADO server.
Universal Client Drivers
- Universal .NET Data Provider
- Universal ODBC Driver
- Universal JDBC Driver
Universal Data and Application Server
- Database and language independent Data and Application server that includes a complete SQL compliant database engine with Visual FoxPro 8.x SQL compatibility.
- Server-side languages supported for writing stored procedures, triggers and user defined functions include:
- Recital
- Visual FoxPro
- FoxPro
- Clipper
- User defined 3GL functions and classes in
DLL's (shared libraries on Linux/UNIX)
Universal Database Drivers
- Available for many leading SQL databases including:
- Recital
- Oracle
- Ingres
- PostgreSQL
- MySQL
- Microsoft SQL Server
- Universal ODBC server provides server side support for any ODBC data sources
- Universal JDBC server provides server side support for any JDBC data sources
- Universal ADO server provides server side support for any ADO data sources
Features And Benefits
Choose your favorite development tools
The Recital 9 Database Server provides high-performance access to a variety of data and information sources on multiple platforms that works with practically any tool or language, leveraging the technical skills developers already have. The technologies that the Recital 9 Database Server supports enable organizations to create easy-to-maintain solutions and use their choice of best-of-breed tools, languages and data sources on the client, middle-tier, or server.
Broad cross-platform support
The Recital 9 Database Server runs on Windows, Linux, Unix and OpenVMS servers with complete cross-server connectivity for accessing data across diverse platforms.
Integrate
The Recital 9 Database Server does not require expensive and time-consuming movement of all corporate data into a single data store, nor does it require commitment to a single vendor's products.
An open solution
The Recital 9 Database Server is based on open industry specifications with broad industry support and works with all major established database products, as well as its own high performance database engine.
Evolutionary
The Recital 9 Database Server is an evolutionary step from standard interfaces such as .NET Managed Data Providers, Open Database Connectivity (ODBC), Java Database Connectivity (JDBC), and ADO, and it significantly extends the functionality of these well-known and well-tested technologies.
ANSI compliant SQL
The Recital 9 Database Server has a complete ANSI compliant SQL engine that works with Recital, Visual FoxPro, FoxPro, FoxBASE, Clipper, CISAM, and RMS data.
Visual FoxPro 8.0 compatible database server
The Recital 9 Database Server also includes a complete Visual FoxPro
8.0 compatible SQL engine that works with Recital, Visual FoxPro,
FoxPro, FoxBASE, Clipper, CISAM, and RMS data. The Visual FoxPro
8.0 compatible SQL engine also provides complete support for writing
server-side stored procedures in Visual FoxPro.
Provides Enterprise Data and Legacy Application connectivity
The Recital 9 Database Server provides connectivity to relational and non-relational data sources, transaction systems, and legacy applications through native drivers across all major computing platforms.
Integrated XML support
The Recital 9 Database Server provides integrated XML language support providing Microsoft ADO.NET XML compatible data import and export that works with Recital, Visual FoxPro, FoxPro, FoxBASE, Clipper, CISAM, and RMS data. You can import and export data across platforms using XML.
Very Large Database support
The Recital 9 Database Server supports Very Large Databases (tables larger than 2GB) up to 2^63 bytes. Archiving large amounts of data in Recital 9 has never been easier.
Easy to Install and Administer
The Recital 9 Database Server is easy to install supporting multiple standard client drivers that have been proven and tested to provide instant productivity.
Universal .NET access to all major databases -- residing anywhere
The Recital Universal .NET Data Provider is a managed provider built with 100% managed code, delivering robust, secure, high-performance data connectivity to all leading SQL databases as well as many non-SQL data sources through the use of our own SQL engine that sits on top of these data sources. In addition, using our Universal ODBC Server, JDBC Server or ADO Server, you will be able to connect to virtually any database from the .NET environment.
World class customer support
Should you ever need help getting the most out of our products, our technical support team is available by email, phone or fax to answer your technical questions about our products. We'll provide the kind of support you'll need during development and afterwards.
The Recital 9 Database Server is a high performance architecture
We know from experience that performance is of paramount concern
to developers and users of data access technologies. The Recital
9 Database Server consequently has been designed with performance
as its number one goal.
Write server-side business logic in Visual FoxPro
Included with the Recital 9 Database Server, is full support for server-side stored procedures, business logic, and triggers written in Recital, Visual FoxPro, FoxPro, and Clipper.
Open and extensible
Developers can extend the power of the Recital 9 Database Server engine by writing custom 3GL function libraries that use the Recital/API.
Navigational and SQL Data Access
The Recital 9 Database Server engine provides navigational access to databases as well as SQL data access. Navigational data access is invaluable when application performance is critical.
Local Cursor Engine
Easily manipulate data interactively and programmatically.
Active Data Dictionary
Create persistent relationships between tables, stored procedures, events, triggers, rules, and default values.
Database Events
Control user actions with code that executes when a database is opened, closed, or modified.
Built-in Batch-Processing Capabilities
Quickly and directly manipulate large amounts of data in corporate transaction-processing solutions.
Universal .NET Data Provider
Provide access to any Recital 9 managed data from other clients built with Microsoft Visual Studio .NET.
Structured Error Handling
Control and encapsulate error handling in code using TRY...CATCH...FINALLY structure, escalate exceptions using THROW, and manage using Exception objects.
Local and Remote Views
Build applications based on queries that return filtered data for increased performance. Take remote data offline for added power.
Key Features
 |
Cross-platform Visual FoxPro 8.0 compatible
SQL with local cursor engine including all SQLxxx() functions
|
|
Enhanced Visual FoxPro 8.0 language and function
compatibility |
|
Backwards compatible with earlier versions
of Recital, FoxPro 2.6, SCO FoxBASE, and Clipper |
|
ANSI SQL syntax compliant |
|
Navigational and SQL data access |
|
Active Data Dictionary |
|
Supports stored procedures, triggers and user-defined
functions written in Recital or Visual FoxPro |
|
Broad cross-platform support; Windows, Linux,
Unix, and OpenVMS |
|
Row level locking |
|
Low-level ISAM C API for high performance C/C++
embedded non-server database access |
|
ODBC compatible C API for C/C++ embedded non-server
database access |
|
Full text indexing and searching |
|
Complete support for SQL subqueries |
|
Extensible using dynamically loadable C function
and class libraries |
|
Flexible security system with column-level
protection |
|
Supports Very Large Databases
(tables larger than 2GB) up to 2^63 bytes |
System Requirements
Recital 9 Enterprise Studio Requirements:
- Microsoft® Windows® 2000/XP/2003/Vista
- Microsoft .NET 2.0 Framework
- Microsoft Visual J# 2.0 Redistributable Package
Recital 9 Database Server Client Driver Requirements:
- Universal .NET Data Provider requires the Microsoft .NET
1.1 (or above) Framework
- Universal JDBC Driver requires Microsoft JVM or Sun JVM
- Universal ODBC Driver available for Windows, UNIX and Linux
Recital 9 Database Server Requirements:
- HP PA-RISC HP-UX® 10.20 and above
- Sun® SPARC Solaris™ 8 and above
- HP Alpha OpenVMS 7.2-1 and above
- SCO® OpenServer 5.0.5 and above
- Microsoft® Windows® 2000 and above
- Sun® Intel® Solaris™ 10 and above
- IBM AIX® 4.3 and above
- Intel® Linux Redhat 7.2 and above
- Other Intel® Linux requires kernel >= 2.4
- HP Integrity OpenVMS 8.2-1 and above
- HP Intel® Itanium® HP-UX® 11.23 and above
- Intel® / AMD™ 64 bit Linux
Large File Support is available for Windows, Itanium HP-UX and
Linux. Linux Large File Support requires glibc >= 2.2 and an ext2 file system
|
