nosql

Langue: en

Autres versions - même langue

Version: Oct 2003 (debian - 07/07/09)

Section: 1 (Commandes utilisateur)

NAME

NoSQL - Relational Database Management System

SYNOPSIS

command arguments...

INTRODUCTION

This manual page briefly documents NoSQL 2.4.7. It was written for the Debian GNU/Linux distribution (but may be used by others), because the original program does not have a manual page. Instead it contains documentation in HTML format.

NoSQL is a fast, portable, relational database management system without arbitrary limits other than memory and processor speed.

NoSQL uses the 'operator/stream' DBMS paradigm described in "Unix Review", March, 1991, page 24, entitled "A 4GL Language". The operators are Unix filters, in other words, they read tables or lists from stdin and write output (also tables or lists) to stdout. They are typically connected by pipes to do staged processing.

The operators work with relational data in ASCII files. The fields in each row are separated by a 'TAB' char and the row is terminated with a 'NEWLINE' char. The first row (the header) contains the names for each column preceded by the ASCII character SOH (0x01). Subsequent rows (the body) contain the data values.

DESCRIPTION

The commands are stored in command -h. The following table lists a short overview of the NoSQL commands: (Tables are NoSQL tables, unless explicitly mentioned otherwise)

addcolumn append new empty column(s)
addrow append a new empty record
column select column(s) from table
compute apply AWK to table data, using column names
ctime convert values of a column from seconds since epoch into a C date
depend assess functional dependency between two table columns
edittable edit a table in list or row format
filter run standard utilities on a table
gregorian convert selected date columns from Julian to Gregorian calendar
index create an index file for the given columns
islist check for list correctness
istable check for table correctness
jointable join two sorted tables on a common field
julian convert selected date columns from Gregorian to Julian calendar
keysearch display records where first field begins with a given string
listtotable convert list into table
maketable build a valid table header from a table cross-reference file
nblparser NoSQL Brokering Language (NBL) interpreter
number insert a unique record identifier into a table
prtable experimental table formatter for character displays
random pick one or more records at random from a table
rdbtotable converts an /rdb table into NoSQL format
rename rename a table column
repair repair a broken table
rmcolumn remove selected columns from a table
row select rows matching a given AWK expression using column names
search fast-search of an indexed table
sorttable sort a table on one or more columns
soundex computes soundex codes for specified columns
subtotal compute subtotals on selected table columns
tabletocsv convert a table into CSV (comma-separated values) format
tabletolist convert from table to list format
tabletordb convert a table into /rdb format
tmptable temporary table creator
total sum up selected table columns
union concatenates multiple tables
unique makes a table unique on the key field
update insert/update/delete rows according to an edit table
viewtable comfortable table viewer
xreftable cross-reference a table

SEE ALSO

awk(1), perl(1), rcs(1), lockfile(1).

AUTHOR

Carlo Strozzi <carlos@linux.it>.
Manual page by David Frey <dfrey@debian.org>