Linux Certif

Toute la documentation sur la certification Linux LPI

nosql

NAME

NoSQL - Relational Database Management System

SYNOPSIS

command arguments...

INTRODUCTION

This manual page briefly documents NoSQL 4.0.14. 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 /usr/lib/nosql Their help pages can be printed out with 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
awktable	filter table trough awk
column, notcolumn, project, getcolumn	select column(s) from table
compute	apply AWK to table data, using column names
csvtotable	convert a CSV file into a NoSQL table
ctime	convert values of a column from seconds since epoch into a C date
depend, deptable	assess functional dependency between two table columns
edittable	edit a table in list or row format
envtotable	Convert environment into NoSQL table
filter, filtertable	run standard utilities on a table
formtable	print a report from a NoSQL table
gregorian	convert selected date columns from Julian to Gregorian calendar
index, indextable	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
justify, prtable	experimental table formatter for character displays
keysearch	display records where first field begins with a given string
ldaptolist	turns LDAP entries into a NoSQL list
listtotable	convert list into table
maketable	build a valid table header from a table cross-reference file
nblparser	NoSQL Brokering Language An(NBL) interpreter
nltable	number lines in table
number	insert a unique record identifier into a table
random, rndtable	pick one or more records at random from a table
rdbtotable	converts an /rdb table into NoSQL format
rename, renamecol	rename a table column
repair, repairtable	repair a broken table
rmcolumn	remove selected columns from a table
rndtable	pick one or more records at random from a table
row, getrow, select	select rows matching a given AWK expression using column names
searchi, searchtable	fast-search of an indexed table
seektable	extract rows beginning at selected offsets from a NoSQL table
setnames	set new column names on the input 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, totaltable	sum up selected table columns
union, uniotable	concatenates multiple tables
unique	makes a table unique on the key field
update, updtable	insert/update/delete rows according to an edit table
viewtable	comfortable table viewer
xreftable, template	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>