dbrvstatdiff – evaluate statistical differences between two random variables Synopsis dbrvstatdiff [-f format] [-c ConfRating] [-h HypothesizedDifference] m1c sd1c n1c m2c sd2c n2cOR dbrvstatdiff [-f format] [-c ConfRating] m1c n1c m2c n2cDescriptionProduce statistics on the difference of sets of random variables. If a hypothesized difference is given (with "-h"), to does a Student’s t-test. Random…
dbrowuniq – eliminate adjacent rows with duplicate fields, maybe counting Synopsisdbrowuniq [-cFLB] [uniquifying fields…] DescriptionEliminate adjacent rows with duplicate fields, perhaps counting them. Roughly equivalent to the Unix uniq command, but optionally only operating on the specified fields. By default, all columns must be unique. If column names are specified, only those columns must be…
dbroweval – evaluate code for each row of a fsdb file Synopsis dbroweval [-f CodeFile] code [code…]DescriptionEvaluate code for each row of the data. Typical actions are things like reformatting and other data transformations. Code can include embedded column names preceded by underscores; these result in the value of that column for the current row….
dbrowenumerate – enumerate rows, starting from zero Synopsisdbrowenumerate DescriptionAdd a new column “count”, incremented for each row of data, starting with zero. Use dbrowaccumulate for control over initial value or increment; this module is just a wrapper around that. Options-N or –new-name N Name the new column N. Defaults to "count". This module also supports…
dbrowdiff – compute row-by-row differences of some column Synopsisdbrowdiff [-B|-I] column DescriptionFor a given column, compute the differences between each row of the table. Differences are output to two new columns, "absdiff" and "pctdiff". Differences are either relative to the previous column (incremental mode), or relative to the first row (baseline mode), the default. Options-B…
dbrowcount – count the number of rows in an Fsdb stream Synopsisdbrowcount DescriptionCount the number of rows and write out a new fsdb file with one column (n) and one value: the number of rows. This program is a strict subset of dbcolstats. Although there are other ways to get a count of rows ("dbcolstats",…
dbrowaccumulate – compute a running sum of a column Synopsisdbrowaccumulate [-C increment_constant] [-I initial_value] [-c increment_column] [-N new_column_name] DescriptionCompute a running sum over a column of data, or of a constant incremented per row, perhaps to generate a cumulative distribution. What to accumulate is specified by "-c" or "-C". The new column is named by…
dbrow – select rows from an Fsdb file based on arbitrary conditions Synopsisdbrow [-vw] CONDITION [CONDITION…] DescriptionSelect rows for which all CONDITIONS are true. Conditions are specified as Perl code, in which column names are be embedded, preceded by underscores. Options-v Invert the selection, picking rows where at least one condition does not match. This…
dbrecolize – DEPRICATED, now use dbfilealter
dbprobe – database response time and availability information Synopsisdbprobe.pl [delay] DescriptionThe dbprobe utility is used by pmdadbping(1) to measure response time from a database. A given query is executed on the database at the requested interval (delay, which defaults to 60 seconds). This response time measure can be exported via the Performance Co-Pilot framework for…
dbpmda – debugger for Performance Co-Pilot PMDAs Synopsisdbpmda [-efi] [-n pmnsfile] [-q timeout] [-U username] Descriptiondbpmda is an interactive interface to the interactions between a Performance Metric Domain Agent (PMDA(3)) and the Performance Metric Collector Daemon (pmcd(1)). This allows PMDAs to be attached, initialized and exercised to test for correctness. dbpmda interactively prompts the user…
dbmultistats – run dbcolstats over each group of inputs identified by some key Synopsis$0 [-dm] [-c ConfidencePercent] [-f FormatForm] [-q NumberOfQuartiles] -k KeyField ValueField DescriptionThe input table is grouped by KeyField, then we compute a separate set of column statistics on ValueField for each group with a unique key. Assumptions and requirements are the same…
dbmerge2 – merge exactly two inputs in sorted order based on the the specified columns Synopsis dbmerge2 –input A.fsdb –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…]or cat A.fsdb | dbmerge2 –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…] DescriptionMerge exactly two sorted input files, producing one sorted result. Inputs can both be specified with "–input", or one can come from…
dbmerge – merge all inputs in sorted order based on the the specified columns Synopsis dbmerge –input A.fsdb –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…]or cat A.fsdb | dbmerge –input – –input B.fsdb [-T TemporaryDirectory] [-nNrR] column [column…] or dbmerge [-T TemporaryDirectory] [-nNrR] column [column…] –inputs A.fsdb [B.fsdb …] DescriptionMerge all provided, pre-sorted input files, producing one sorted result. Inputs can both be specified with…
dbmapreduce – reduce all input rows with the same key Synopsis dbmapreduce [-dMS] [-k KeyField] [-f CodeFile] [-C Filtercode] [–] [ReduceCommand [ReduceArguments…]]DescriptionGroup input data by KeyField, then apply a function (the “reducer”) to each group. The reduce function can be an external program given by ReduceCommand and ReduceArguments, or an Perl subroutine given in CodeFile…
dblistize – DEPRICATED, now use dbfilealter
dblatex – convert DocBook to LaTeX, DVI, PostScript, and PDF Synopsis dblatex [options] {file | -}DescriptionThis manual page briefly documents the dblatex command. For more details read the PDF manual; see below. dblatex is a program that transforms your SGML/XML DocBook documents to DVI, PostScript or PDF by translating them into pure LaTeX as a first…
dbjoin – join two tables on common columns Synopsis dbjoin [-Sid] –input table1.fsdb –input table2.fsdb [-nNrR] column [column…]OR cat table1.fsdb | dbjoin [-Sid] –input table2.fsdb [-nNrR] column [column…]DescriptionDoes a natural, inner join on TABLE1 and TABLE2 the specified columns. With the "-a" option, or with "-t outer" it will do a natural, full outer join….
dbiproxy – A proxy server for the DBD::Proxy driver Synopsis dbiproxy <options> –localport=<port>DescriptionThis tool is just a front end for the DBI::ProxyServer package. All it does is picking options from the command line and calling DBI::ProxyServer::main(). See DBI::ProxyServer for details. Available options include: –chroot=dir (UNIX only) After doing a bind(), change root directory to the…
dbiprof – command-line client for DBI::ProfileData SynopsisSee a report of the ten queries with the longest total runtime in the profile dump file prof1.out: dbiprof prof1.outSee the top 10 most frequently run queries in the profile file dbi.prof (the default): dbiprof –sort countSee the same report with 15 entries: dbiprof –sort count –number 15DescriptionThis tool…