Section 1: user commands and tools
NAME dbcolscorrelate – find the coefficient of correlation over columns SYNOPSIS dbcolscorrelate column1 column2 [column3…] DESCRIPTION Compute the coefficient of correlation over two (or more) columns. The output is one line of correlations. With exactly two columns, a new column correlation is created. With more than two columns, correlations are computed for each pairwise combination…
NAME dbcolrename – change the names of columns in a fsdb schema SYNOPSIS dbcolrename OldName1 NewName1 [OldName2 NewName2] … DESCRIPTION Dbcolrename changes the names of columns in a fsdb schema, mapping OldName1 to NewName1, and so on for multiple pairs of column names. Note that it is valid to do “overlapping” renames like "dbcolrename a…
NAME dbcolpercentile – compute percentiles or ranks for an existing column SYNOPSIS dbcolpercentile [-rplhS] column DESCRIPTION Compute a percentile of a column of numbers. The new column will be called percentile or rank. Non-numeric records are handled as in other programs. If the data is pre-sorted and only a rank is requested, no extra storage…
NAME dbcolneaten – pretty-print columns of Fsdb data (assuming a monospaced font) SYNOPSIS dbcolneaten [-E] [field_settings] DESCRIPTION dbcolneaten arranges that the Fsdb data appears in neat columns if you view it with a monospaced font. To do this, it pads out each field with spaces to line up the next field. Field settings are of…
NAME dbcolmovingstats – compute moving statistics over a window of a column of data SYNOPSIS dbcolmovingstats [-am] [-w window-width] [-e EmptyValue] column DESCRIPTION Compute moving statistics over a COLUMN of data. Records containing non-numeric data are considered null do not contribute to the stats (optionally they are treated as zeros with "-a"). Currently we compute…
NAME dbcolmerge – merge multiple columns into one SYNOPSIS dbcolmerge [-C ElementSeparator] [columns…] DESCRIPTION For each row, merge multiple columns down to a single column, joining elements with ElementSeparator (defaults to a single underscore). OPTIONS -C S or –element-separator S Specify the separator used to join columns. (Defaults to a single underscore.) -e E or…
NAME dbcolize – DEPRICATED, now use dbfilealter Index
NAME dbcolhisto – compute a histogram over a column of Fsdb data SYNOPSIS dbcolhisto [-ag] [-W BucketWidth] [-S BucketStart] [-E BucketEnd] [-N NumberOfBuckets] column DESCRIPTION This program computes a histogram over a column of data. Records containing non-numeric data are considered null do not contribute to the stats (optionally they are treated as zeros). Defaults…
NAME dbcoldefine – define the columns of a plain text file to make it an Fsdb file SYNOPSIS dbcoldefine [-F x] [column…] DESCRIPTION This program writes a new header before the data with the specified column names. It does not do any validation of the data contents; it is up to the user to verify…
NAME dbcolcreate – create new columns SYNOPSIS dbcolcreate NewColumn1 [NewColumn2] or dbcolcreate -e DefaultValue NewColumnWithDefault DESCRIPTION Create columns "NewColumn1", etc. with an optional "DefaultValue". OPTIONS -e EmptyValue or –empty Specify the value newly created columns get. -f or –first Put all new columns as the first columns of each row. By default, they go at…
NAME dbcolcopylast – create new columns that are copies of prior columns SYNOPSIS dbcolcopylast[-e EMPTY][column…] DESCRIPTION For each COLUMN, create a new column copylast_COLUMN that is the last value for that column—that is, the value of that column from the row before. OPTIONS -e EmptyValue or –empty Specify the value newly created columns get. This…
NAME dbcol – select columns from an Fsdb file SYNOPSIS dbcol [-v] [-e -] [column…] DESCRIPTION Select one or more columns from the input database. If a value is given for empty columns with the -e option, then any named columns which don’t exist will be created. Otherwise, non-existent columns are an error. Note: a…
NAME dbclient – lightweight SSH client SYNOPSIS dbclient [flag arguments] [-p port] [-i id] [-L l:h:p] [-R l:h:p] [-l user] host [more flags] [command] dbclient [args] [user1]@host1[^port1],[user2]@host2[^port2],… DESCRIPTION dbclient is a small SSH client OPTIONS command A command to run on the remote host. This will normally be run by the remote host using the…
NAME db5.3_verify – Verifies the structure databases SYNOPSIS db5.3_verify [-NoqV] [-h home] [-P password] file … DESCRIPTION The db5.3_verify utility verifies the structure of one or more files and the databases they contain. OPTIONS -h Specify a home directory for the database environment; by default, the current working directory is used. -o Skip the database…
NAME db5.3_upgrade – Upgrade the Berkeley DB version to the current release version. SYNOPSIS db5.3_upgrade [-NsVv] [-h home] [-P password] file … DESCRIPTION The db5.3_upgrade utility upgrades the Berkeley DB version of one or more files and the databases they contain to the current release version. OPTIONS -h Specify a home directory for the database…
NAME db_tuner – analyze and tune btree database SYNOPSIS db_tuner [-c cachesize] -d file [-h home] [-s database] [-v] DESCRIPTION The db_tuner utility analyzes the data in a btree database, and suggests a page size that is likely to deliver optimal operation. OPTIONS -c cachesize Specify a value of the cachesize, otherwise, the default value…
NAME db_to_html_table – convert db to an HTML table SYNOPSIS db_to_html_table [-g N] <source.fsdb >dest.html DESCRIPTION Covert an existing dbtable to an HTML table. The output is a fragment of an HTML page; we assume the user fills in the rest (head and body, etc.). Input is fsdb format. Output is HTML code (not fsdb),…
NAME db_to_csv – convert fsdb to the comma-separated-value file-format SYNOPSIS db_to_csv [-C] DESCRIPTION Covert an existing fsdb file to comma-separated value format. Input is fsdb format. Output is CSV-format plain text (not fsdb). OPTIONS -C or <–omit-comments> Also strip all comments. This module also supports the standard fsdb options: -d Enable debugging output. -i or…
NAME db5.3_stat – Display statistics for Berkeley DB environments SYNOPSIS db5.3_stat -d file [-fN] [-h home] [-P password] [-s database] db5.3_stat [-cEelmNrtVZ] [-C Aclop] [-h home] [-L A] [-M A] [-R A] [-P password] DESCRIPTION The db5.3_stat utility displays statistics for Berkeley DB environments. OPTIONS -C Display internal information about the locking subsystem. (The output…
NAME db_replicate – Provide replication services SYNOPSIS db_replicate [-MVv] [-h home] [-L file] [-P password] [-T num-threads] [-t secs] DESCRIPTION The db_replicate utility is a daemon process that provides replication/HA services on a transactional environment. This utility enables you to upgrade an existing Transactional Data Store application to an HA application with minor modifications. OPTIONS…