User:Pebau/Rasdaman

--- UNDER WORK, NOT FOR RELEASE YET ---

Rasdaman (an acronym for raster data manager) is an array database management system (ADBMS). Its name emphasizes the relationship between raster operations and aray representations. It offers an array query language, rasql, for declarative retrieval and manipulation on multi-dimensional arrays of unlimited size. It is free software released under a GNU General Public License (GPL).

Functions
Functions allow blocks of code to be executed by the server. Although these blocks can be written in SQL, the lack of basic programming operations which existed prior to version 8.4, such as branching and looping, has driven the adoption of other languages inside of functions. Some of the languages can even execute inside of triggers. Functions in PostgreSQL can be written in the following languages:


 * A built-in language called PL/pgSQL resembles Oracle's procedural language PL/SQL.
 * Scripting languages are supported through PL/Lua, PL/LOLCODE, PL/Perl, plPHP, PL/Python, PL/Ruby, PL/sh, PL/Tcl and PL/Scheme.
 * Compiled languages C, C++, or Java (via PL/Java).
 * The statistical language R through PL/R.

PostgreSQL supports row-returning functions, where the output of the function is a set of values which can be treated much like a table within queries.

Functions can be defined to execute with the privileges of either the caller or the user who defined the function. Functions are sometimes referred to as stored procedures, although there is a slight technical distinction between the two.

Indexes
PostgreSQL includes built-in support for B+ tree, hash, GiST and GiN indexes. In addition, user-defined index methods can be created, although this is quite an involved process. Indexes in PostgreSQL also support the following features:

Other features

 * Referential integrity constraints including foreign key constraints, column constraints, and row checks

psql
The primary front-end for PostgreSQL is the  command-line program, which can be used to enter SQL queries directly, or execute them from a file. In addition, psql provides a number of meta-commands and various shell-like features to facilitate writing scripts and automating a wide variety of tasks; for example tab completion of object names and SQL syntax.

Proprietary
A number of companies offer proprietary tools for PostgreSQL. They often consist of a universal core that is adapted for various specific database products. These tools mostly share the administration features with the open source tools but offer improvements in data modeling, im/exporting or reporting. Among them are Navicat, SQL Maestro as well as pure data modeling tools like DeZign for Databases or ModelRight.


 * See also: Comparison of database tools

Benchmarks
Many informal performance studies of PostgreSQL have been done but the first industry-standard and peer-validated benchmark was completed in June 2007 using the Sun Java System Application Server (proprietary version of GlassFish) 9.0 Platform Edition, UltraSPARC T1 based Sun Fire server and Postgres 8.2. This result of 778.14 SPECjAppServer2004 JOPS@Standard compares favourably with the 874 JOPS@Standard with Oracle 10 on an Itanium based HP-UX system.

In August 2007, Sun submitted an improved benchmark score of 813.73 SPECjAppServer2004 JOPS@Standard. With the system under test at a reduced price, the price/performance improved from $US 84.98/JOPS to $US 70.57/JOPS.

Awards
PostgreSQL has received the following awards :
 * 1999 LinuxWorld Editor's Choice Award for Best Database
 * 2000 Linux Journal Editors' Choice Awards for Best Database
 * 2002 Linux New Media Editors Choice Award for Best Database
 * 2003 Linux Journal Editors' Choice Awards for Best Database
 * 2004 Linux New Media Award For Best Database
 * 2004 Linux Journal Editors' Choice Awards for Best Database
 * 2004 ArsTechnica Best Server Application Award
 * 2005 Linux Journal Editors' Choice Awards for Best Database
 * 2006 Linux Journal Editors' Choice Awards for Best Database
 * 2008 Developer.com Product of the Year, Database Tool

About rasdaman

 * Planet PostgreSQL, blog aggregator
 * Database Journal articles on PostgreSQL
 * Linux Productivity Magazine: a complete issue on PostgreSQL
 * PostgreSQL Guide
 * a rebuttal to the FUD (fear, uncertainty, and doubt) surrounding much of the criticism against PostgreSQL.
 * PostgreSQL gotchas, documented but counterintuitive behavior
 * Test_PGC, Example embedded SQL/C program for PostgreSQL showing database operations and SQLSTATE testing.
 * LinuxChix PostgreSQL Course on Moodle
 * Test_PGC, Example embedded SQL/C program for PostgreSQL showing database operations and SQLSTATE testing.
 * LinuxChix PostgreSQL Course on Moodle

Documentation

 * PostgreSQL FAQ (Frequently Asked Questions)
 * PostgreSQL Website
 * PostgreSQL Wiki
 * PostgreSQL Documentation

Performance tuning documentation
 * PostgreSQL Performance Tuning

 Category:Free database management systems