Database

We are impressed with EnterpriseDB Postgres Plus Advanced Server as you can dramatically reduce the database license and maintenance costs that you pay for proprietary software.

Data is one of the most important assets to organisations, and with increasing data demands, your ability to sort, access and utilise data becomes central to success. However, within times of economic uncertainly, it is not good enough to merely have an infrastructure that can meet your data requirements. You need one which can also get the job done under increasing budgetary constraints.

This is where Postgres Plus Advanced Server from EnterpriseDB can help. If Oracle, or another vendor, is tying you down, and if meeting your organisations increasing database demands is costing too much, then migrating to Postgres Plus Advanced Server is a very  economically viable solution.

Why you should break free

Breaking away from Oracle’s, or other vendors, shackles offers you organisational leverage.

Oracle users 

Unlike Oracle, Postgres Plus Advanced Server is offered on a subscription basis with no licensing fee. So you’re not trapped into Oracle’s long-term relationships. Nor are you a slave to Oracle’s licensing fee increases. More importantly, Postgres Plus Advanced Server’s significantly cheaper high performance OLTP can dramatically reduce your TCO by over 80% per year compared to Oracle.

Migrating from Oracle doesn’t necessarily mean replacing the Oracle infrastructure that you have already invested so much in. Postgres Plus Advanced Server offers four migration levels: With its Oracle compatibility features, you can get a taste of freedom and experience the immediate cost savings associated with simply deploying new LOB applications to Postgres Plus Advanced Server. Then you may be interested in the significantly greater cost savings of using Postgres Plus Advanced Server as a replication server to Oracle, which requires no additional Oracle licence! Alternatively, you can experience even greater saving by migrating your non-mission critical applications to Postgres Plus Advanced Server; before finally benefiting from the dramatic cost savings of migrating your mission critical applications.

Migrating from Oracle also doesn’t mean new training costs. Postgres Plus Advanced Server features a robust framework of integrated tools and procedures which are near identical to Oracle’s DB. So once you’re free, you can hit the ground running by leveraging your existing Oracle knowledge and skills.

Act now. Take a migration assessment 

Arrange a Migration Assessment, and within days you’ll find out the best strategy that’s most beneficial to your organisation and Oracle environment. A fixed cost schema analysed pricing strategy provides a low cost high impact service, that eliminates the guesswork in your migration budgeting process. So you will know the exact cost of migration, and how much you will save.

For every organisation there is a migration strategy that fits and significantly consolidates your DB costs. Our  migration experts will examine your environment and help you plan and make decisions within days not weeks or months. So you can start making savings sooner.

Postgres Plus Advanced Server - An Enterprise Database at Open-Source Economics.

PostgreSQL is a powerful, Open-Source object-relational database system.

It has won praise from its users and industry recognition, including the Linux New Media Award for Best Database System and five times winner of the The Linux Journal Editors' Choice Award for best DBMS. A pedigree that  matches that of LinuxIT and we are happy to recommend this proven technology.

PostgreSQL has more than 15 year's of active development and a proven architecture that has earned it a strong reputation for reliability, data integrity, and correctness. It runs on all major operating systems, including Linux, UNIX (AIX, BSD, HP-UX, SGI IRIX, Mac OS X, Solaris, Tru64), and Windows.

It is fully ACID compliant, has full support for foreign keys, joins, views, triggers, and stored procedures (in multiple languages). It includes most SQL data types, including INTEGER, NUMERIC, BOOLEAN, CHAR, VARCHAR, DATE, INTERVAL, and TIMESTAMP. It also supports storage of binary large objects, including pictures, sounds, or video. It has native programming interfaces for C/C++, Java, .Net, Perl, Python, Ruby, Tcl, ODBC, among others..

An enterprise class database, PostgreSQL also boasts sophisticated features such as Multi-Version Concurrency Control (MVCC), point in time recovery, tablespaces, asynchronous replication, nested transactions (savepoints), online/hot back-ups, a sophisticated query planner/optimiser, and write ahead logging for fault tolerance.

It supports international character sets, multi-byte character encodings, Unicode, and it is locale-aware for sorting, case-sensitivity, and formatting. It is highly scalable both in the sheer quantity of data it can manage and in the number of concurrent users it can accommodate.

There are active PostgreSQL systems in production environments that manage in excess of 4 terabytes of data.

We support IBM DB2. The DB2 Enterprise Server Edition is a relational model database server that runs on UNIX (namely AIX), Linux, IBM (formerly OS/400),z/OS and Windows servers.

DB2 is optimised to deliver industry-leading performance across multiple workloads, while lowering administration, storage, development, and server costs.

• Advanced Access Control
• Autonomics
• Data Compression
• Geodetic Data Management
• High Availability Disaster Recover

• Performance Optimization
• Security
• SQL Skin

It also powers the different IBM InfoSphere Warehouse editions.

A great all round and proven performer, like LinuxIT, we recommend DB2.

The popular MySQL is an Open-Source relational database management system (RDBMS) based on SQL (Structured Query Language). It is available for many platforms – Unix, Linux or Windows.

As the leaders in Open – Source technology across the UK we recommend MySQL , which is available in these editions:

• MySQL Classic Edition is the ideal embedded database for ISVs, OEMs and VARs developing read-intensive applications using the MyISAM storage engine. It is proven as a high performance and zero administration database.

• Lower TCO - MySQL enables you to minimize your database TCO.
• Ease of Use - MySQL is famous for "15 minutes to success" from download to install.
• Low Administration - MySQL is easy to administer, enabling DBAs to manage more servers.
• Supports over 20 platforms and operating systems including Linux, Unix, Mac and Windows so you have ultimate flexibility in development and deployment options.

Please note that MySQL Classic Edition is only available to ISVs, OEMs and VARs to license as an embedded database.

When you need additional capabilities it is easy to upgrade to MySQL Standard Edition, MySQL Enterprise Edition or MySQL Cluster Carrier Grade Edition.

• MySQL Standard Edition enables you to deliver high-performance and scalable Online Transaction Processing (OLTP) applications. It provides the ease of use that has made MySQL famous along with industrial strength performance and reliability.

MySQL Standard Edition includes InnoDB, making it a fully integrated transaction-safe, ACID compliant database. In addition, MySQL Replication allows you to deliver high performance and scalable applications.

• Lower TCO - MySQL enables you to minimize your database TCO.
• Reliability, Performance & Ease of Use - MySQL is proven as the world's most popular Open-Source database.
• Database Development, Design and Administration - MySQL Workbench provides an integrated development, design and administration environment to make developers and DBAs more productive.

When you need additional capabilities it is easy to upgrade to MySQL Enterprise Edition or MySQL Cluster Carrier Grade Edition.

• MySQL Enterprise Edition enables you to deliver high performance, scalable Online Transaction Processing (OLTP) database applications. It is a fully integrated transaction-safe, ACID compliant database. It includes full commit, rollback, crash recovery and row level locking capabilities. Database Partitioning allows you to improve performance and management of very large database environments.

We can provide both the technology and a range of services to meet your MySQL requirements.

We support the Oracle database platform as we like this solution. Not only because it’s the market leader but because of its flexibility and comprehensive feature set.    

The current Oracle Database Release Enterprise Edition delivers industry leading performance, scalability, security and reliability on a choice of Clustered or single-servers running Windows, Linux and UNIX. It can easily manage the most demanding transaction processing, business intelligence, and content management applications.

It comes with a wide range of options to help grow your business and meet users performance, security and availability service level expectations.

Benefits include:

• Protection from server failure, site failure, human error, and reduces planned downtime.
• Securing data and enabling compliance with unique row-level security, fine-grained auditing, transparent data encryption, and total recall of data.
• High-performance data warehousing, online analytic processing, and data mining.
• Easy management of entire lifecycle of information for the largest of databases.