Search
Open Source Databases
 

SRA offers comprehensive end-to-end solutions on database technologies. It serves as a one stop shop for services in open source databases such as PostgreSQL, MySQL, Ingres to include implementation, migration, integration and support.It also has good experience in connected technologies such as ODBC, JDBC. Our open source database services include

Postgre SQl Database services

Postgre SQL auditing, consulting, architecture and design
Database configuration, deployment and implementation
Postgres based application design, development and enhancements
Migration from proprietary databases to Postgre SQL databases
PostgreSQl training and certification
PostgreSQL : System administration, performance tuning and optimization services

Open Source Database services:

Enterprise database design and architecture
Database Integration
Database performance tuning and optimization
Database migrations and conversion
Database HA & clustering
Database systems testing
Remote / Onsite database administration

Key features of Postgre SQL:

ANSI-SQL 99-Standard compliant
Interfaces for TCL, Perl, C, C++, PHP,ODBC, JDBC, Embedded SQL in C, Python, Ruby
GUI administration tool: pgAdmin, pgAccess, phpPgAdmin
Rules, Triggers, Union, Intersect, EXCEPT queries, Replication
Procedural languages PL/pg SQL, PL/Perl, PL/Python, PL/Tcl and others
Fully ACID compliant, serializable transactions
Unicode and locale support
Cross-database compatibility functions
Loadable extensions offering full text search, XML and GIS
SSL support and Kerberos authentication
Hot stand by, replication
Inheritance, sequences outer joins, sub selects, referential integrity, views

Advantages:

Good support: SRA provides comprehensive support and maintenance on PostgreSQL. In addition Postgres has a large and vibrant community of professionals who are available to assist and help. SRA also promotes and works closely with the Postgres community.
Cross Platform: PostgreSQL is available for a broad range of Unix flavors as well as Linux and also runs smoothly on Windows platform
Suitable for high volume environments: Postgres utilizes multiple row data storage strategies called MVCC (multi version concurrency control) which enables it to become very responsive in high volume environments
Stable & Reliable: PostgreSQL is a very reliable and robust database with rare occurrence of crashes
Extensible: Postgres is the leading Open Source database available under the flexible and open BSD license. The software can be freely customized, modified and extended.