|
|
|
|
Ansett Case
Study ANSETT: At
Ansett our solution stores and tracks in its databases in excess of 45 million items stored
for archival purposes. The vast
majority of these are airline tickets, but there are also over five million
accounts payable items and similar numbers of other accounting items.
The client is currently expanding from 350 concurrent users to
approximately 3000 users who will have direct access into the database of images
and stored mainframe report items. Ansett
already has more database index records (i.e. magnetic pointers to objects on
potentially off-line media) than most companies would ever have over any
reasonable period or achieves, yet Ansett are only just now upgrading to the
Enterprise version of WINopticä,
which proves the volume of items that could be handled by just the medium scale WINopticä application (though we of course recommend the very
scalable SQL server WINopticä Enterprise version be used for sizeable projects). Ansett
achieved the management of 500 platters of stored information using just the
Microsoft Access version of WINopticä, though this database engine required various
types of documents (e.g. the airline ticket database) to be split into a number
of databases, with just a year’s data stored in each database.
This would be the equivalent of having a separate database for each
calendar year or two of any normal-sized corporate accounting system, which
would still not cause any problems, as one is typically knowledgeable of the
year at the commencement of a search. Naturally,
the highly scalable SQL Server version of WINopticä does not require databases to be broken into even
few year periods, but in the event a client wishes to so break up a database, it
allows queries to span databases. Even at the level of storage of Ansett, we are getting an indexing rate of 1300 transactions per second using the SQL server enterprise version of WINopticä running on a contemporary specification PC as the NT server. One of Australia’s largest credit unions has put away every transaction for every customer for almost a decade (individually indexed) using our now very old DOS version (DOSoptic) and refuses to upgrade to any Windows version as the DOS version still handles all the archive queries without fault |
|
Send mail to administrator@harrisons.net.au with
questions or comments about this web site.
|