Advanced Database Manager

Power by Design




Select A Section

home

public service

database mgr.

data access

data modeler

site notes

Currently In This Section

AxleBase









Executive Summary
( Please Scroll Down )

Section Pages

summary
description

design limits

notable tests

shortcomings

nomenclature

operation


                                                       

This is a legally copyrighted work,
so none of it can,
legally or honorably,
be copied, used, or claimed by anyone other than the owner.

__________________________________________________
__________________________________________________

An Executive Brief Covering AxleBase

__________________________________________________
__________________________________________________
Contents Of This Document

Brief
. . . . . . . Introduction
. . . . . . . Data Size
. . . . . . . Speed
. . . . . . . Type
. . . . . . . Cost
. . . . . . . Distributed Storage
. . . . . . . Super-System
. . . . . . . Security
. . . . . . . Error Handling
. . . . . . . Special Query Language
. . . . . . . Special Operating System
. . . . . . . Middleware
. . . . . . . VPN Servers
. . . . . . . Special Network
. . . . . . . Simplicity
. . . . . . . Embeddable
. . . . . . . Data Protection
. . . . . . . Operation Manual
. . . . . . . Demonstration And Test Systems
. . . . . . . Operating Systems
 
Administrative Notes
 

AxleBase Copyright 2003 - 2022 John E. Ragan.




__________________________________________________
__________________________________________________

AxleBase
Brief



AxleBase is a computer system that stores and manages data ; a database manager.

He was the world’s first manager of very large stores, and can store and query greater quantities than any other system in the world. He is a world-wide technology leader.

( Some of AxleBase's advanced technologies are omitted from this document for brevity. More are on the "Technical Description" page. )




_____________________

* Data Size *

Objective:   Biggest.

A single table
can hold two million copies
of the biggest book library in the world; i.e.,

two million copies of the
entire Library Of Congress.

Limit per table is twenty quintillion bytes, twenty exabytes, 2x(10^19), or 20,000,000,000,000,000,000 bytes.

( Relax, it is not possible for a human to grasp that number. )

And each AxleBase database can hold many of those tables.

AxleBase capacity exceeds that of internet search engines and data warehouses. But unlike those, he is a full-featured relational database manager able to apply relational power to those large data stores.

AxleBase capacity is considered further in the theoretical science document. At this point, it appears that a single AxleBase table is comparable to the entire universe; i.e., an AxleBase table can hold a record of every star in the visible universe. See "Magnitude For Computer Scientists" on this web site.

( Theoretically, the AxleBase architecture will allow a large increase of the data limit, so if more is needed, see the "Conjecture" section of the Theory document.)

return to table of contents at the top




_____________________

* Speed *

Very fast.

The Google corporation was understandably proud of the speed of their Dremel database manager. But a comparison revealed that AxleBase was over four thousand times faster than the Google system.
    (See Performance Comparisons: Dremel on the performance page.)

return to table of contents at the top



_____________________

* Type *

Relational

That massive data is highly organized and controlled. His giant tables can be indexed, queried, and joined like ordinary tables.

( Tests of that ability and other tests are shown on the test page .)




_____________________

* Cost *

Objective:   Lowest.

AxleBase can run on standard desktop computers. One of his test machines was built in the last century and runs Windows 98.

Of course, he also runs on million-dollar servers.

return to table of contents at the top




_____________________

* Distributed Storage *

Objective:   Biggest on the cheapest.

AxleBase can manage networked computers as a single computer to store a large data table. He can even do that with ordinary desktop computers.

Although internally complex, his distributed operation requires little or no human supervision. Distribution can be local or continental. He is self-sufficient and needs no external middleware, foreign servers, or help from the operating system.

return to table of contents at the top




_____________________

* Super-System *

Objective:   Super-computer power.

When extraordinary power is needed, AxleBase can be configured as an axsys super-system that drives many computers simultaneously to deliver super-computer power from cheap desktop computers.

return to table of contents at the top




_____________________

* Security *

Objective:   Extreme.

His security sub-system has selectable ranges from
      standard server security up through
      multiple layers and optional extensions all the way to
      an internal VPN ( Virtual Private Network ),
      and even a secure audit trail can be turned on.

return to table of contents at the top




_____________________

* Error Handling *

Objective:   Extreme durability.

Designed to recover from errors in communication links, internal sub-systems, supporting software, hardware, and even some operating system errors. He offers no excuses.

return to table of contents at the top




_____________________

* Special Query Language *

Not needed !

AxleBase uses the industry-standard ANSI-92 SQL query language that is used by Oracle, MS SQL Server, etc. Even when the data is a giant table and he is configured into a super-system, he translates standard queries into his needs.

Standard SQL also allows programmers to build GUI front ends for ordinary users.

return to table of contents at the top




_____________________

* Special Operating System *

Not needed !

He handles all of his special needs internally.

return to table of contents at the top




_____________________

* Middleware *

Not needed !

He handles everything. He does not even use the operating system's VPN support or open source protocols.

( The reduction of cost and administrative complexity by internalizing technology complexity was a design objective. )

return to table of contents at the top




_____________________

* VPN Servers *

Not needed !

Not intended to compete with VPN specialists. But if the cost or complexity of a standard VPN is too much for you, AxleBase can create his own secure VPN server and tunnels.

return to table of contents at the top




_____________________

* Special Network *

Not needed !

He uses standard networks; local ethernet, internet, wireless, etc.

return to table of contents at the top




_____________________

* Simplicity *

A design objective.

He behaves like a standard database manager until the user wants more.

But even his advanced features are as simple as possible. For example, to distribute a large table, just give him a permission list of computers and storage locations and he will handle the rest.

return to table of contents at the top




_____________________

* Embeddable *

A design objective.

Built to be embedded, so any software can house the world’s most powerful database manager. He has an extensive and well-documented A.P.I. (application programming interface).

return to table of contents at the top




_____________________

* Data Protection *

The standard Backup and Restore commands and extensive advanced data protection features.

Automatic data monitors and automatic recovery can be turned on. Entire disks and entire computers can be restored instantly.

return to table of contents at the top




_____________________

* Operation Manual *

Yes

A hundred thousand words cover commands, operations, and techniques for executives, DBAs, database programmers, etc. See the "Operation Manual" document.
( 167,692 words as of 20230503. )

( Additionally, there are a quarter of a million words of programmer guidance inside the code, for a total of 427,129 words as of 20230503. Nearly a half million words. )

return to table of contents at the top




_____________________

* Demonstration And Test Systems *

Three :   AxHandle, Axon, and AxServer.

AxHandle :
      Axhandle is a database administration tool.
      It is also a stress tester.
      It creates test databases and runs test suites.
      SQL and commands can be run.
      A push-button can build very large test tables.
      AxleBase is embedded in it, and it can also be a
      remote client to the AxServer database server.

Axon :
      Axon is a remote point-and-click query tool.
      A form helps the user open a remote database.
      SQL query elements are selected with point-and-click.
      Tables and columns are selected with point-and-click.
      Axon uses those selections to build a standard SQL query.
      A button runs the query and displays the return.

AxServer :
      AxServer is a simple database server.
      AxleBase is embedded in it.
      Axon and AxHandle can query its databases.
      Has a GUI to monitor tests.
      Runs SysLink/ TCP/ IP through Windows sockets.

return to table of contents at the top




_____________________

* Operating Systems *

System :
      AxleBase was developed on Microsoft Windows 2000.

Data :
      AxleBase can manage his data on any operating system that can express a Windows file system; i.e., Linux, Windows, Unix, mainframes, etc.

return to table of contents at the top




__________________________________________________
__________________________________________________

AxleBase
Administrative Section



* Project Status *

2003 :   Begun.
2006 :   Operational.
              Improvements continued and
              attempts were made to sell it.
2015 :   Stopped.
              The project had surpassed all goals,
              and had given me years of fun and lessons,
              so research, development, and testing stopped
              when the lack of a market and and a lack of
              public interest became obvious.
2021 :   Project re-opened
( I make changes in the web site when an error is noticed in this massive, years-long project. AxleBase still serves my personal daily needs, so he is sometimes updated.)

The entire system is contained in a single DLL file.

AxleBase file Size:   835,584 bytes in 2021.
( That is not an error. All of the above features and far more are contained in that little DLL file.)

Code Comments:   The Seeper translator showed a quarter of a million comment words in the AxleBase code on 5 May 2014.

The testers and demonstrators :
      AxHandle - 23,862 lines of code and comments.
      AxServer -   6,417 lines of code and comments.
      Axon -       19,225 lines of code and comments.
      ( Reported by Seepper. )




* Personal Notes *

Research, concept, design, and coding are entirely mine. Books and internet were not consulted even for public knowledge such as indexing and encryption.

Research in very large database management was conceived and undertaken entirely by myself years before the "big data" craze.

return to table of contents at the top



__________________________________________________





                                                       



Web site and technology
Copyright 1999 - 2022 John Ragan

Web site is maintained with Notepad.
By intent, so don't bother me about it.