Products

Scalability

Database and Process Load

Safari graphic small

Note: For information relevant for Safari Suite Enterprise, click here or choose from the Products menu at right.

Database/Application Scalability

Data storage scalability is a function of database design and database server performance. The EnSite Safari Suite® application accommodates data storage scalability with a carefully designed and developed data model combined with the robust platform of Microsoft® SQL Server on the back end. The EnSite Safari Suite® database design is normalized (a process that eliminates redundancy, organizes data efficiently, reduces the potential for anomalies during data operations and improves data consistency) and properly indexed, with internal primary keys on all tables, appropriate foreign key relationships, and logical and appropriate database object naming conventions followed. Storage scalability is limited only by the limits of hardware and the Microsoft® SQL Server platform, which is very robust. There is no practical limit to the number of customer/account records which can be stored in the application. Internal testing has been performed on databases hosting over 1.5 million accounts, with no significant degradation in application performance encountered.

The Microsoft® SQL Server platform provides integrated connection pooling on the server side to further enhance concurrent user scalability. The result of this design is fast data retrieval for the user, without significant degradation in performance when adding concurrent users.

Processing Load Scalability

The EnSite Safari Suite® application supports high-volume batch processing for many functions related to data interfaces (EDI, Non-EDI, etc.) and mass calculation routines (Invoice processing, Forecasting, etc.). The application components used in these processes were designed for large-scale application in mass market environments. The design of these components employs the use of limited datasets featuring indexed data retrieval methods, precompiled stored procedures, elimination of table views, and other high-performance database retrieval methodologies. Server-side processing is utilized for data-intensive tasks to leverage the power of the database server.

EnSite Safari Suite® Scheduler

The EnSite Safari Suite® application can be used in concert with the EnSite Safari Suite® Scheduler component to allow unattended execution of any batch processes, such as data imports/exports and other batch functions. This component allows administrative definition of one-time or recurring processing schedules, priorities, and processing parameters. The component runs as a Microsoft® Windows® Service application, either on a dedicated application server or a database server, and functions as a virtual user of the application, automating tasks continuously and around the clock. The EnSite Safari Suite® Scheduler component accesses EnSite Safari Suite® application business objects directly on the server for high-performance processing.

Products

Details

Related

All Content Copyright © 2008 EnSite Incorporated. And Respective Rights Holders. All Rights Reserved.