Rechercher une page de manuel
nosql
Langue: en
Version: May 2009 (ubuntu - 24/10/10)
Section: 1 (Commandes utilisateur)
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>
Contenus ©2006-2024 Benjamin Poulain
Design ©2006-2024 Maxime Vantorre