Postgres Plus^® Advanced Server v8.3 Rel. 2 Now Available!

• Infinite Cache. This high performance horizontal caching architecture expands using your existing affordable commodity server cache blades for a distributed cache whose compression feature allows putting entire databases into memory and requires no cache specific coding in your applications.

 


Download the Infinite Cache data sheet.

 

• DynaTune^® with Workload Profiling. During installation, DynaTune configures over 50 tuning parameters of the Postgres engine to your expected hardware and application utilization giving you out-of-the-box optimization. Then, after any hardware upgrades (e.g. memory expansion), DynaTune automatically re-calibrates the parameters to utilize the new configuration consistent with your usage profile.

 



 

• Asynchronous Pre-Fetch. Experience remarkable improvements to data warehouse, ETL (extract transform and load), and query intensive applications by fully optimizing RAID hardware usage for common indexes.
• Query Optimization Hints. There are over 15 hints for power programmers to use in coding their logic putting more control and performance enhancements directly in their hands.
• DRITA. Dynamic Runtime Instrumentation Tools Architecture. The DRITA features reveal internal processing statistics allowing fine grained tuning to eliminate processing bottlenecks and conflicts.
• Bulk Collect / Bulk Bind. These functions provide application developers advanced performance handling of data collections found in database systems costing many thousands of dollars more than Advanced Server.
• EDB*Loader. This bulk data loader outperforms the standard Postgres Copy command. It also allows for individual input failures that you can conveniently fix later without aborting the entire load.

Or you can run adjacent applications that dove-tail seamlessly with your mission critical databases without additional Oracle licenses. And you can use these same compatibility features to build new Postgres applications.

 
Advanced Server's compatibility features focus on five critical feature areas in every Oracle DBA's and Developer's skill set:

• SQL Extensions. Many critical SQL extensions you've come to rely on including decode(), the DUAL table, and ROWNUM are supported.
• PL/SQL Support. Advanced Server's procedural language runs Oracle triggers, stored procedures, packages, functions and more.
• Compatibility Tools and Utilities. The compatibility tooling includes: EDB*Plus, EDB*Loader, DBA Management Server, DBLinks, and Oracle Catalog Views, providing experienced DBAs and developers the familiar look, feel, and functionality they depend on.
• Application Compatibility. The programming framework includes support for 12+ programming languages and 12+ library interfaces including OCL(OCI support).
• Push Button Migration. Finally, the Advanced Server Migration Studio, literally provides you an easy push button low risk Oracle application migration path that converts schema, data, packages, triggers, stored procedures, and functions into a working Postgres based application.

For an in depth look at Postgres Plus Advanced Server's Oracle compatibility features refer to the white paper: Delivering Oracle Compatibility, or download the Oracle Compatibility Developer's Guide.

Migration Studio consolidates simultaneous browsing of multiple databases and migrates Oracle, MySQL^®, SQL Server^® and Sybase^® databases with push button simplicity.

Postgres Studio provides comprehensive database administration, query, and maintenance consoles.

 

 

DBA Management Server is a browser based monitoring, iQuery, and Job Scheduling environment that contains extensive reporting with HTML and PDF output.

DBA Monitoring Console provides inside views of CPU, Memory, Disk, and Cache utilization for gauging normal maintenance tasks as well as performance tuning.

GridSQL^® Monitoring Console is a single dashboard for managing high performance horizontally scaling reporting solutions.

Replication Console manages databases for publishing and subscribing between Postgres databases or Postgres and Oracle databases in mixed, economy oriented environments.

The Migration Studio can save a developer who is moving an Oracle application, hundreds of hours or application re-writing. The global debugging features integrated into Postgres Studio allow developers to set breakpoints in triggers called by multiple external applications for true application context debugging.

 

 

Other power packed features include: built-in packages for object oriented database programming, explicit transaction control, distributed queries, audit logging, support for over 12 programming languages including Oracle's PL/SQL and support for over 12 library interfaces.

PostGIS spatially enables the Postgres Plus server, allowing it to be used as a backend spatial database for geographic information systems (GIS), much like ESRI's SDE or the Oracle Database Spatial Extension. PostGIS follows the OpenGIS "Simple Features Specification for SQL" and has been certified as compliant with the "Types and Functions" profile.

For more information on Advanced Server's geospatial capabilities read the FortiusOne Case Study or see it in action at http://www.fortiusone.com.

GridSQL provides organizations with query intensive applications accessing large data sets, near linear scalability using cost effective commodity hardware. Application developers enjoy the benefit of high performance options for query management, and IT Managers save money on data warehousing hardware costs.

 

 

GridSQL includes intelligence to maximize parallel queries over multiple servers, delivering faster response times than can be achieved by single-node databases. The horizontal scaling architecture capable of accessing massive data sets, is transparent to the calling application. GridSQL parallelizes every query to efficiently use all available resources across multiple servers while maintaining a single view to the calling application.

For more information on GridSQL including an overview, architecture review, and FAQs visit the GridSQL project page.

For example, using a simple one step interface, Migration Studio will move the data and business logic for an entire Oracle application. The schema and constraints, data, triggers, stored procedures, packages, synonyms, and functions are all moved to Postgres.

 

 

In many cases, all that's required for your application to work is to re-point your connection from Oracle to Postgres. You can even customize your migrations with command line options.

Postgres Replication is a robust, trigger-based replication solution providing your system with high availability, scalability and the ability to offload tasks to other machines. Postgres Replication, fully integrated in Postgres Plus, provides a 'one master to many slaves' replication system with cascading replication support as well as graceful switchover and failover of failed nodes. Replication is used in creating highly available infrastructures, scaling systems across the globe, and offloading reporting loads from transaction systems improving their performance.

 

 

Postgres Replication gives DBAs a powerful tool to protect their organization's data, business transactions, and infrastructure performance, while maintaining system up time for round the clock access. For more information on Advanced Server replication see the High Availability White Paper.