starbase - starbase data tables introduction.
DESCRIPTION
starbase is a set of filter programs and an ascii table format for UNIX.
The ascii database concepts are outlined in the book Unix Relational
Database Management by Manis, Schaffer and Jorgensen. This implimentation
has been written at the Smithsonian Astrophysical Observatory and
contains may extensions for use with scientific and astrophysical data sets.
Introduction Pages
- starbase.1
- starbase data tables introduction (this page).
- starbase.3
- starbase data table C library.
- starbase.5
- starbase data table file format.
- tablefun.3
- starbase data table included functions.
- features.0
- starbase data table features and extensions.
Row Programs
- table
- a program for manipulating starbase data tables.
- row
- select rows from a starbase data table.
- select
- select rows from a starbase data table.
- compute
- compute new values for starbase data table columns.
- validate
- validate the rows of a table.
Column Programs
- column
- project columns from a starbase data table.
- project
- project columns from a starbase data table.
- justify
- justify columns of a starbase data table.
- trim
- trim columns of an starbase data table.
Searching, Sorting and Indexing
- search
- quickly search an indexed starbase data table.
- index
- index a starbase data table for fast access using the search command.
- sorttable
- sort a starbase data table by specified columns.
- jointable
- join two starbase data tables on matching key columns.
- pastetable
- join N table by row number.
- cprodtable
- create the cartesian product of N tables.
- intertable
- intersect two starbase data tables.
- diffrtable
- subtract to starbase data tables.
- uniontable
- produce the union of two starbase data tables.
Header and File Formating
- headoff
- remove the header from a starbase data table.
- header
- print the header from a starbase data table.
- headline
- print the headline from a starbase data table.
- dashline
- print the dashline from a starbase data table.
- tabletolist
- convert a starbase data table to /rdb list format.
- listtotable
- convert an /rdb list format file to a starbase data table.
- fixtotable
- convert a fixed column ascii table into a starbase data table.
- fldtotable
- convert a field column ascii table into a starbase data table.
- prec
- format columns of a table to specified precision.
File Substitution
- grestable
- table driven general regular expression substitution.
- tabletosed
- convert a table to sed substitutions.
- trantable
- table driven token substitution.
- tabletom4
- convert a table to m4 substitutions.
Astronomical Programs
- fk45
- convert ra, dec columns from fk4 to fk5.
- fk54
- convert ra, dec columns from fk5 to fk4.
- precess
- precess coordinates
- radecbox
- select an ra, dec box from a catalog table.
- radeccirc
- select an ra, dec circle from a catalog table.
Associated Programs and Documentation
- headtable
- use the head utility on a starbase data table.
- tailtable
- use the tail utility on a starbase data table.
- wctable
- use the wc utility on a starbase data table..
- randtable
- pick random rows from a starbase data table.
- calc
- a command line calculator.
- reckon
- execute a block of awk program statements.
- tawk
- awk language extensions implimented at SAO.
- slalink
- a tawk extension for inclusion of the Star
Link astrometry libraries.
- mawk
- an implimentation of the awk programming language by
Mike Brennan (brennanboeing.com).