Appendix B Instruction Summary

The table below gives a condensed overview of the operations defined in each of the modules.


aggr.avg aggr.count_no_nil aggr.min aggr.size
aggr.cardinality aggr.histogram aggr.prod aggr.sum
aggr.count aggr.max aggr.product

alarm.alarm alarm.epoch alarm.time
alarm.ctime alarm.prelude alarm.timers
alarm.epilogue alarm.sleep alarm.usec

algebra.antijoin algebra.joinPath algebra.project algebra.sortTH
algebra.antiuselect algebra.kdifference algebra.rangesplit algebra.sortTail
algebra.bandjoin algebra.kintersect algebra.reuse algebra.split
algebra.copy algebra.kunion algebra.revert algebra.ssort
algebra.crossproduct algebra.kunique algebra.sample algebra.ssort_rev
algebra.difference algebra.leftfetchjoin algebra.sunion
algebra.exist algebra.leftjoin algebra.sdifference algebra.sunique
algebra.fetch algebra.like algebra.select algebra.thetajoin
algebra.fetchjoin algebra.markH algebra.selectH algebra.thetaselect
algebra.find algebra.markT algebra.selectNotNil algebra.thetauselect
algebra.fragment algebra.mark_grp algebra.semijoin algebra.topN
algebra.groupby algebra.materialize algebra.sintersect algebra.tunique
algebra.hashjoin algebra.merge algebra.slice algebra.uhashsplit
algebra.hashsplit algebra.mergejoin algebra.sort algebra.union
algebra.indexjoin algebra.number algebra.sortHT algebra.unique
algebra.intersect algebra.outerjoin algebra.sortReverse algebra.urangesplit
algebra.join algebra.position algebra.sortReverseTail

array.grid array.product array.project

bat.append bat.getSpaceUsed bat.isaSet bat.setColumn
bat.attach bat.getStorageSize bat.load bat.setGarbage
bat.delete bat.getTail bat.mirror bat.setHash
bat.densebat bat.getTailType bat.new bat.setHot
bat.flush bat.hasAppendMode bat.newIterator bat.setKey
bat.getAccess bat.hasMoreElements bat.order bat.setMemoryAdvise
bat.getAlpha bat.hasReadMode bat.orderReverse bat.setMemoryMap
bat.getCapacity bat.hasWriteMode bat.pack bat.setName
bat.getDelta bat.info bat.partition bat.setPersistent
bat.getDiskSize bat.inplace bat.reduce bat.setReadMode
bat.getHead bat.insert bat.replace bat.setRole
bat.getHeadType bat.isCached bat.reverse bat.setSet
bat.getHeat bat.isPersistent bat.revert bat.setSorted
bat.getMemorySize bat.isSorted bat.save bat.setTransient
bat.getName bat.isSortedReverse bat.setAccess bat.setWriteMode
bat.getRole bat.isSynced bat.setAppendMode bat.unload
bat.getSequenceBase bat.isTransient bat.setBase bat.unpack
bat.getSize bat.isaKey bat.setCold

batcalc.!= batcalc.< batcalc.bte batcalc.lng
batcalc.% batcalc.<= batcalc.chr batcalc.not
batcalc.* batcalc.== batcalc.dbl batcalc.oid
batcalc.+ batcalc.> batcalc.flt batcalc.or
batcalc.++ batcalc.>= batcalc.ifthen batcalc.sht
batcalc.- batcalc.abs batcalc.ifthenelse batcalc.str
batcalc.– batcalc.and batcalc.int batcalc.wrd
batcalc./ batcalc.bit batcalc.isnil batcalc.xor

batcolor.blue batcolor.green batcolor.red batcolor.value
batcolor.cb batcolor.hsv batcolor.rgb
batcolor.color batcolor.hue batcolor.saturation
batcolor.cr batcolor.luminance batcolor.str

batmmath.acos batmmath.cos batmmath.fmod batmmath.sinh
batmmath.asin batmmath.cosh batmmath.log batmmath.sqrt
batmmath.atan batmmath.exp batmmath.log10 batmmath.tan
batmmath.atan2 batmmath.fabs batmmath.pow batmmath.tanh
batmmath.ceil batmmath.floor batmmath.sin

batmtime.day batmtime.milliseconds batmtime.year
batmtime.hours batmtime.month batmtime.seconds

batstr.chrAt batstr.ltrim batstr.search batstr.toLower
batstr.endsWith batstr.nbytes batstr.startsWith batstr.toUpper
batstr.length batstr.r_search batstr.string batstr.trim
batstr.like batstr.replace batstr.substitute batstr.unicodeAt
batstr.like_uselect batstr.rtrim batstr.substring

bbp.bind bbp.getDiskSpace bbp.getObjects bbp.prelude
bbp.close bbp.getHeadType bbp.getPageSize bbp.release
bbp.commit bbp.getHeat bbp.getRNames bbp.releaseAll
bbp.deposit bbp.getKind bbp.getRefCount bbp.take
bbp.destroy bbp.getLRefCount bbp.getStatus bbp.toString
bbp.discard bbp.getLocation bbp.getTailType
bbp.getCount bbp.getName bbp.iterator
bbp.getDirty bbp.getNames bbp.open

blob.blob blob.prelude blob.tostring
blob.nitems blob.toblob

box.close box.discard box.open box.take
box.deposit box.getBoxNames box.release box.toString
box.destroy box.iterator box.releaseAll

bpm.adapt bpm.fold bpm.mapNxt bpm.prelude
bpm.addPartition bpm.garbage bpm.mapPrv bpm.rangePartition
bpm.close bpm.getDimension bpm.mapThghDbl bpm.rangePartitionSort
bpm.count bpm.getNames bpm.mapThghLng bpm.replace
bpm.delete bpm.getNumberOfPartitions bpm.saveCatalog
bpm.deposit bpm.hasMoreElements bpm.mapTlowDbl bpm.select
bpm.derivePartition bpm.hashPartition bpm.mapTlowLng bpm.sortPartitions
bpm.destroy bpm.hashPartitions bpm.new bpm.sortTail
bpm.discard bpm.insert bpm.newIterator bpm.splitquant
bpm.dump bpm.mapAlias bpm.open bpm.take
bpm.emptySet bpm.mapBid bpm.partition bpm.unfold
bpm.epilogue bpm.mapName bpm.pieces

bstream.create bstream.destroy bstream.read

calc.!= calc.abs calc.ifthenelse calc.not
calc.% calc.and calc.inet calc.oid
calc.* calc.bat calc.int calc.or
calc.+ calc.between calc.inv calc.ptr
calc.- calc.bit calc.isnil calc.setoid
calc./ calc.blob calc.isnotnil calc.sht
calc.< calc.bte calc.length calc.sign
calc.<< calc.chr calc.lng calc.sizeof
calc.<= calc.date calc.max calc.sqladd
calc.= calc.daytime calc.max_no_nil calc.sqlblob
calc.== calc.dbl calc.min calc.str
calc.> calc.flt calc.min_no_nil calc.timestamp
calc.>= calc.getBAT calc.newoid calc.void
calc.>> calc.getBATidentifier calc.wrd

clients.addScenario clients.getId clients.getScenario clients.removeUser
clients.addUser clients.getInfo clients.getTime clients.setHistory
clients.changePassword clients.getUsername clients.setListing
clients.changeUsername clients.getUsers clients.setPassword
clients.checkPermission clients.quit clients.setScenario
clients.exit clients.getLastCommand clients.shutdown
clients.getActions clients.getLogins clients.removeScenario

cluster.column cluster.map cluster.table
cluster.key cluster.new

color.blue color.green color.red color.value
color.cb color.hsv color.rgb color.ycc
color.color color.hue color.saturation
color.cr color.luminance color.str

const.close const.epiloque const.prelude const.take
const.deposit const.hasMoreElements const.toString
const.destroy const.newIterator const.release
const.discard const.open const.releaseAll

constraints.emptySet

crackers.DeleteMap crackers.dselect crackers.getCrackerBAT
crackers.InsertAVLIndex crackers.getMap crackers.materializeHead
crackers.activeCacheConsciousCrackHashJoin crackers.getTotalStorage
crackers.alignJoin crackers.extendCrackerBAT crackers.pmaddReference
crackers.alignedJoin crackers.extendCrackerMap crackers.pmclearReferences
crackers.bandJoin crackers.fmaddReference crackers.pmjoinselect
crackers.buildAVLIndex crackers.hselect crackers.pmmaxTail
crackers.cacheConsciousCrackHashJoin crackers.insert crackers.pmproject
crackers.cacheConsciousCrackHashJoinAlignOnly crackers.insertionsBForce
crackers.crackHashJoin crackers.insertionsBOnNeed
crackers.crackJoin crackers.fmclearReferences crackers.pmselect
crackers.crackOrdered crackers.insertionsBOnNeedGradually
crackers.crackOrdered_validate crackers.insertionsBOnNeedGraduallyRipple
crackers.crackUnordered_validate crackers.insertionsForget
crackers.deleteAVL crackers.fmcreateMap crackers.insertionsPartiallyForget
crackers.deletionsOnNeed crackers.joinselect crackers.pmtselect
crackers.deletionsOnNeedGradually crackers.joinuselect crackers.positionproject
crackers.deletionsOnNeedGraduallyRipple crackers.mapCount crackers.printAVLTree_int
crackers.djoinselect crackers.fmremoveMap crackers.markedproject
crackers.dproject crackers.fullAlignment crackers.printCrackerBAT

date.!= date.<= date.> date.date
date.< date.== date.>= date.isnil

daytime.!= daytime.<= daytime.> daytime.isnil
daytime.< daytime.== daytime.>=

factories.getArrival factories.getDeparture factories.shutdown
factories.getCaller factories.getOwners factories.getPlants

group.avg group.max group.prelude group.size
group.count group.min group.refine group.sum
group.derive group.new group.refine_reverse group.variance

identifier.identifier identifier.prelude

inet.!= inet.> inet.host inet.new
inet.< inet.>= inet.hostmask inet.setmasklen
inet.<< inet.>> inet.isnil inet.text
inet.<<= inet.>>= inet.masklen
inet.<= inet.abbrev inet.netmask
inet.= inet.broadcast inet.network

inspect.equalType inspect.getComment inspect.getSignature inspect.getStatistics
inspect.getAddress inspect.getDefinition inspect.getType
inspect.getAddresses inspect.getEnvironment inspect.getTypeIndex
inspect.getAtomNames inspect.getFunction inspect.getSignatures
inspect.getAtomSizes inspect.getKind inspect.getSize inspect.getTypeName
inspect.getAtomSuper inspect.getModule inspect.getSource inspect.getWelcome

io.data io.import io.prompt io.stdout
io.export io.print io.stderr io.table
io.ftable io.printf io.stdin

language.assert language.newRange language.setIOTrace language.source
language.assertSpace language.nextElement language.setMemoryTrace
language.call language.raise language.setThreadTrace
language.dataflow language.register language.setTimerTrace

lock.create lock.set lock.try
lock.destroy lock.tostr lock.unset

mal.multiplex

manual.completion manual.help manual.search manual.summary
manual.createXML manual.index manual.section

mapi.bind mapi.fetch_field_array mapi.query_array
mapi.connect mapi.fetch_line mapi.listen_ssl mapi.query_handle
mapi.connect_ssl mapi.fetch_reset mapi.lookup mapi.reconnect
mapi.destroy mapi.fetch_row mapi.malclient mapi.resume
mapi.disconnect mapi.finish mapi.next_result mapi.rpc
mapi.error mapi.getError mapi.ping mapi.setAlias
mapi.explain mapi.get_field_count mapi.prepare mapi.stop
mapi.fetch_all_rows mapi.get_row_count mapi.put mapi.suspend
mapi.fetch_field mapi.listen mapi.query mapi.trace

mat.hasMoreElements mat.new mat.pack
mat.info mat.newIterator mat.print

mdb.List mdb.getReason mdb.listMapi mdb.setMemoryTrace
mdb.collect mdb.getStackDepth mdb.modules mdb.setThread
mdb.dot mdb.getStackFrame mdb.setCatch mdb.setTimer
mdb.dump mdb.getStackTrace mdb.setCount mdb.setTrace
mdb.getContext mdb.grab mdb.setDebug mdb.start
mdb.getDebug mdb.inspect mdb.setFlow mdb.stop
mdb.getDefinition mdb.lifespan mdb.setIO mdb.var
mdb.getException mdb.list mdb.setMemory

mkey.bulk_rotate_xor_hash mkey.hash mkey.rotate

mmath.acos mmath.cot mmath.isnan mmath.sin
mmath.asin mmath.exp mmath.log mmath.sinh
mmath.atan mmath.fabs mmath.log10 mmath.sqrt
mmath.atan2 mmath.finite mmath.pi mmath.srand
mmath.ceil mmath.floor mmath.pow mmath.tan
mmath.cos mmath.fmod mmath.rand mmath.tanh
mmath.cosh mmath.isinf mmath.round

mtime.add mtime.dayname mtime.local_timezone mtime.start_dst
mtime.adddays mtime.daynum mtime.milliseconds mtime.str_to_date
mtime.addmonths mtime.dayofweek mtime.minutes mtime.time_add_sec_interval
mtime.addyears mtime.dayofyear mtime.month mtime.time_sub_sec_interval
mtime.compute mtime.daytime mtime.monthname mtime.time_synonyms
mtime.current_date mtime.diff mtime.monthnum mtime.timestamp
mtime.current_time mtime.dst mtime.msec mtime.timestamp_add_month_interval
mtime.current_timestamp mtime.msecs mtime.timestamp_add_sec_interval
mtime.date mtime.end_dst mtime.olddate mtime.timestamp_sub_month_interval
mtime.date_add_month_interval mtime.oldduration mtime.timestamp_sub_sec_interval
mtime.date_add_sec_interval mtime.prelude mtime.timezone
mtime.date_sub_sec_interval mtime.rule mtime.timezone_local
mtime.date_to_str mtime.epilogue mtime.seconds mtime.weekday
mtime.day mtime.hours mtime.setTimezone mtime.weekofyear


optimizer.accessmode optimizer.dumpQEP optimizer.joinselect optimizer.prelude
optimizer.accumulators optimizer.macro optimizer.pushranges
optimizer.aliases optimizer.emptySet optimizer.mergetable optimizer.recycle
optimizer.clrDebug optimizer.evaluate optimizer.mitosis optimizer.reduce
optimizer.coercions optimizer.factorize optimizer.multiplex optimizer.remap
optimizer.commonTerms optimizer.octopus optimizer.remoteQueries
optimizer.constants optimizer.garbageCollector optimizer.replicator
optimizer.costModel optimizer.heuristics optimizer.optimize optimizer.setDebug
optimizer.crack optimizer.history optimizer.orcam optimizer.showFlowGraph
optimizer.dataflow optimizer.inline optimizer.partitions optimizer.showPlan
optimizer.deadcode optimizer.joinPath optimizer.peephole optimizer.singleton

pcre.compile pcre.match pcre.prelude pcre.sql2pcre
pcre.index pcre.patindex pcre.replace pcre.uselect
pcre.like_uselect pcre.pcre_quote pcre.select

pqueue.dequeue_max pqueue.enqueue_min pqueue.topn_min
pqueue.dequeue_min pqueue.init pqueue.topreplace_max
pqueue.enqueue_max pqueue.topn_max pqueue.topreplace_min

profiler.activate profiler.getDiskReads profiler.noop
profiler.cleanup profiler.getDiskWrites profiler.openStream
profiler.closeStream profiler.getEvent profiler.getTrace profiler.reset
profiler.clrFilter profiler.getFootprint profiler.setAll
profiler.deactivate profiler.getMemory profiler.getUserTime profiler.setEndPoint
profiler.dumpTrace profiler.getSystemTime profiler.setFilter

recycle.dump recycle.getRetainPolicy recycle.reset
recycle.dumpQPat recycle.getReusePolicy recycle.setCachePolicy
recycle.epilogue recycle.log recycle.monitor recycle.setRetainPolicy
recycle.getCachePolicy recycle.prelude recycle.setReusePolicy

remote.connect remote.disconnect remote.get remote.put
remote.create remote.epilogue remote.getList remote.register
remote.destroy remote.exec remote.prelude

replicator.bind replicator.bind_dbat replicator.setMaster replicator.setVersion

sabaoth.epilogue sabaoth.getLocalConnectionPort sabaoth.marchScenario
sabaoth.getLocalConnectionHost sabaoth.marchConnection

scheduler.choice scheduler.drop scheduler.isolation scheduler.pick
scheduler.costPrediction scheduler.octopus scheduler.volumeCost

sema.create sema.destroy sema.down sema.up

sql.forgetPrevious sql.keepquery sql.queryId

sqlblob.sqlblob

statistics.close statistics.forceUpdate statistics.open
statistics.deposit statistics.getCount statistics.getObjects
statistics.destroy statistics.getHistogram statistics.prelude
statistics.discard statistics.getHotset statistics.getSize statistics.release
statistics.dump statistics.getMax statistics.hasMoreElements
statistics.epilogue statistics.getMin statistics.newIterator

status.batStatistics status.getThreads status.mem_cursize status.vm_maxsize
status.cpuStatistics status.ioStatistics status.mem_maxsize
status.getDatabases status.memStatistics status.vmStatistics
status.getPorts status.memUsage status.vm_cursize

str.+ str.length str.rtrim str.substitute
str.STRepilogue str.like str.search str.substring
str.STRprelude str.locate str.space str.suffix
str.ascii str.ltrim str.startsWith str.toLower
str.chrAt str.nbytes str.str str.toUpper
str.codeset str.prefix str.string str.trim
str.endsWith str.r_search str.stringleft str.unicode
str.iconv str.repeat str.stringlength str.unicodeAt
str.insert str.replace str.stringright

streams.blocked streams.openReadBytes streams.socketReadBytes
streams.close streams.openWrite streams.readStr streams.socketWrite
streams.flush streams.openWriteBytes streams.socketWriteBytes
streams.openRead streams.readInt streams.socketRead streams.writeInt

tablet.display tablet.lastPage tablet.setComplaints tablet.setProperties
tablet.dump tablet.load tablet.setDecimal tablet.setRowBracket
tablet.finish tablet.nextPage tablet.setDelimiter tablet.setStream
tablet.firstPage tablet.output tablet.setFormat tablet.setTableBracket
tablet.getPage tablet.page tablet.setName tablet.setTryAll
tablet.getPageCnt tablet.prevPage tablet.setNull tablet.setWidth
tablet.header tablet.setBracket tablet.setPivot
tablet.input tablet.setColumn tablet.setPosition

timestamp.!= timestamp.== timestamp.epoch
timestamp.< timestamp.> timestamp.isnil
timestamp.<= timestamp.>= timestamp.unix_epoch

timezone.str timezone.timestamp

transaction.abort transaction.clean transaction.delta transaction.subcommit
transaction.alpha transaction.commit transaction.prev transaction.sync

txtsim.editdistance txtsim.qgramnormalize txtsim.stringdiff
txtsim.editdistance2 txtsim.qgramselfjoin txtsim.soundex
txtsim.levenshtein txtsim.similarity txtsim.str2qgrams

unix.getenv unix.setenv

url.getAnchor url.getDomain url.getProtocol url.isaURL
url.getBasename url.getExtension url.getQuery url.new
url.getContent url.getFile url.getQueryArg url.url
url.getContext url.getHost url.getRobotURL
url.getDirectory url.getPort url.getUser

user.main

zrule.define