AxleBase

The future by design.

summary

description

applications

home page

documentation

inquiries

policy letter

queued

caution



Advanced Technology

In A Database Manager







Change Log
( Please scroll down. )
tests

limitations

change log

demonstrators

date protocol

syslink protocol

nomenclature

research


                               

Some changes may not be shown. (My mistakes are sometimes too dumb to admit.)

These are new system releases, but call them service packs if that makes you feel warm and fuzzy.

____________________________________________________________________



Change Log

( Upgrades, Changes, and Fixes )


release ______ ________________description________________
coming new Unique indices now support tables of any size.
Uniqueness now transcends segment boundaries.
fix Abstracted SysLink interface broken by protocol update.
new Optional ordinality added to "Alter Table Add Column".
10901 new For distributed applications.
Additional interface abstraction to simplify the host.
AxleBase can process the entire syslink comm interface
allowing the host to handle only the low level sockets.
( Other interfaces are still in place. )
new More optional commands for query control.
new Encapslated and simplified query control commands.
new AlterInstance command increases portability.
AxleBase no longer queries the O.S. for computer and login info.
change Increased the load capacity of both demonstrators.
change All variable names are changed to seepp community conventions.
But interfaces are unchanged.
misc. Other miscellaneous upgrades and improvements.
10701 bug fix Multiple design flaws in multi-column indices.
change Increased speed of multi-column indexed queries.
new Expanded fault tolerance to client query connection loss.
10401 change Simplified the creation of virtual tables.
change Simplified the maintenance of virtual concatenated tables.
bug fix Several bug fixes of virtual concatenated table updates.
new Removed size limit of table concatenations.
new Included virtual tables in the standard management reports.
new Enabled the SQL row clause for concatenated tables.
10101 new A secondary interface abstracts the entire primary interface into a single command that simplifies building server hosts for axsys nodes.
change Streamlined the startup and shutdown of AxleBase.
Shutdown command is now optional.
00801 new Timestamp column with time zone and temporal environment.
change OpenDomain: Optional create parameter to protect existing objects.
new ShowRowsChanged command in the data Vector.
misc. Other miscellaneous improvements, fixes, and completions.
00701 new Version 2. New storage architecture model.
change Continued axsys stabilization.
new Update mechanism for very large distributed tables.
new Optional compressed storage of very large tables.
new Row-level locks for improved concurrency.
new Indexing of variable width tables.
change SQL row clause redesigned and rebuilt.
new Update commit or rollback for very large distributed tables.
new Transaction recovery for very large distributed tables.
new Selectable deep encryption levels.
new OpenDomain command replaces ActivateDomain.
change Virtual table having a text file source cannot be updated.
change Expanded purge control for very large distributed tables.
misc. Other miscellaneous improvements and fixes.
91101 new Index of the numeric column type.
misc. Various upgrades and fixes.
91001 new Distributed database manager object passed initial tests.
new Authenticate command is operational.
new AxHandle demonstrator has an axsys editor.
new AxHandle demonstrator has an axsys controller.
new Axsys node configuration has data return deferment.
misc. Various upgrades and fixes to app, protocols, and demonstrator.
90909 new Indexing of normal sized OLTP tables is improved.
change Import blank into numeric column becomes zero instead of error.
change Import blank into boolean column becomes null instead of error.
change Purge requires an exclusive database lock except for an axsys.
change Drop database requires an exclusive database lock.
change Drop domain requires an exclusive domain lock.
new RestoreBackup command.
change Index creation failure rolls back the changes.
change SetVectorReturnProtocol replaces SetReturnProtocol.
new SetVectorColumnSeparator sets a temporary value.
change Safety feature: Map exhaustion will stop segment creation.
change Emptying a table will not remove empty segments.
misc. Various upgrades and fixes to app, protocols, and demonstrator.
90801 change Sort speed is much faster.
change Sort size limit is many times bigger.
90701 new The return protocol of each dataset can be set.
new Serial column-data type.
90601 new Database connection limit is operational.
new SQL tester. Allows testing SQL before executing.
new Discretionary temporary lock command.
new Persisted lock attributes.
new ShowLocks command.
change Redesign of internal lock handlers.
90501 change Rebuilt concatenation virtualizer for speed and reliability.
90404 new Row clause may be used in an update.
new Row terminators may be changed at the table level.
change Change column type, separator, and row terminator together.
change Total rebuild of SQL join mechanisms.
change Improved socket handling in demonstrator apps.
90303 new AlterAxsysNode command.
change Purge command given optional axsys node controls.
change Purge size increased to the AxleBase limit.
change Backup command given optional axsys node controls.
change Backup improved and size increased to the AxleBase limit.
change Create Index command given optional axsys node controls.
90202 change AlterAxsys command resembles SQL commands.
change Axsys node's computer & login accept wildcard chrs.
new ShowAxsysNode command.
new Axsys floating or free node class.
new CommProtocol, authenticate, and encrypt in node configuration.
new Encrypt command and Decrypt command.
new Encrypted datasets, non-standard returns, and deferred returns.
new ShowAttributes command for the staged data return.
new ReturnDataset command.
change DeferReturn works for non-standard returns (html, soap, etc.).
90105 new Table concatenation, external and internal, into a virtual table.
change Errors include "complete with reservations" for some operations.
81226 change Simplified the CreateVirtualTable command.
new Default column values.
new Virtualization of an external AxleBase table.
change Improved TableCheck and NetworkScan utilities.
change Upgraded the axsys object.
80913 new Distributed database manager. Introduction.
new Demonstration database server host.
change The share command has been simplified.
80808 change Import mechanism was redesigned and rebuilt.
80720 new Where clause recognizes compound parenthetical conditions.
change Improved data validation in SQL updates.
new The connection limit configuration is functional.
new Name-alias in the table attributes. (Not the SQL alias.)
80623 new Date functions.
change Purge is redesigned and rebuilt for speed and reliability.
change Faster index creation for tables over a billion rows.
change Redesign and rebuild of the query mechanism.
change Large table smear maps are expanded and improved.
new Table check command for large table management.
change Arrayed inserts can interact with smear maps.
change Inserts will now backfill VLT segments after purges.
new Self joins are implemented.
new Integer datatype.
70701 new Version 1.0 released.
new Security sub-system is operational.
new Independent security turn on in each domain and each database.
new Database purge now includes system tables.
70401 new IsDate function.
new IsTime function.
new Index command allows segment range specs.
70304 demo Demo app hung at midnight in large table builds.
change The showConnectorId is replaced by the showInstanceId.
new Unique identifiers are assigned to instances, domain connections, database connections, and un-named vectors.
new Validation of mapped locations.
70201 new Enabled SQL row clause for deletes.
change Increased the write concurrency.
70101 change Gave both interface objects more intuitive names.
change Added single level where clause parenthetical grouping. (CoreReader needs this now. Multi-level later.)
61107 new SQL "BETWEEN" and "IN" queries.
60901 new SQL row clause is applied to individual tables.
new SQL segment clause is applied to individual tables.
60810 change Broke through 15 petabyte limit to 20 quintillion rows.
60101 change Row clause recognizes table segmentation.
new Insert with sub-select supports segmentation.
new Segment clause in SQL query.
50111 new The original soundex query algorithm.
(Courtesy of the American taxpayer.)
new Separated real and virtual columns.
41201 new CreateVirtualTable command.
41101 new Non-standard returns. XML, HTML, etc.
new SQL insert from select clause.
30701 start Initial public release of the AxleBase database manager.
                               


Copyright 2003 - 2012 John Ragan

Web site maintained with Notepad and command line FTP.