From Seo Wiki - Search Engine Optimization and Programming Languages

Jump to: navigation, search
File:Rasdaman rasdaman-logo.png
Developer(s) Rasdaman Team
Stable release 8.1.0/ August 13, 2009; 4175 day(s) ago
8.0.0/ April 23, 2009; 4287 day(s) ago
Written in Java
Operating system Unix
License GPL license


Rasdaman is an array database management system (ADBMS).[1] It is released under a GPL license and is thus free software. It offers an array query language, rasql, for declarative retrieval and manipulation on multi-dimensional arrays of unlimited size.


Product name

The name "rasdaman" is an acronym standing for "raster data manager" indicating its focus on raster, i.e, array data.




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:

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.


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

Database administration front-ends

Open source


The primary front-end for PostgreSQL is the psql 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.


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


Many informal performance studies of PostgreSQL have been done[2] 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.[3] 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.[2]

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.[4]

Prominent users


As of 2008 PostgreSQL has received the following awards[5]:

  • 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 Product of the Year, Database Tool

See also



External links

About rasdaman


Performance tuning documentation

Personal tools

Served in 0.928 secs.