product overview
product features
what is a data warehouse?
why a data warehouse?
customizations
queries and reports
scalability
integration
tech talk



"This is by far the easiest and most intuitive database I have ever used. Having used other applications, ROI Solutions leaves those programs in the dust."

Charmeen H. Wing
Director of Development
The Wildlands Conservancy






HOME > PRODUCT > TECH TALK

You say you want a revolution?

What Is Revolution Online?
Revolution Online is a state-of-the-art web application accessible using all modern browser technologies. The front-end was built using industry standard J2EE Java, and the underlying database engine is Oracle 10g Enterprise Edition supplemented by a custom state-of-the-art Storage Area Network.

The Database Server
Each ROI database instance resides on our EMC Storage Area Network (EMC Clariion CX3-40 with over 50 terabytes of raw storage) on fully-redundant, mirrored Fibre Channel disks that are monitored 24 hours a day. Access is provided through dual web servers connected to redundant tier 1 ISP banded 3Mb T-1 data lines. This provides a fast, reliable, and direct connection to your database without network bottlenecks.

Due to their outstanding reputation and performance, we use Dell® Power Edge Servers -- each with an on-site, same-day service agreement and extended warranty. Each ROI Solutions server is configured with the latest Windows Server operating systems and its own redundant power supply and dedicated backup system. We don't believe in maintaining old equipment, so you can be sure your server will be kept up-to-date.

Web-Based Deployment
Web-based deployment means all you need to access your database is a standard personal computer (PC or Mac), internet access, and a web browser.  On PCs, we support both Firefox 1.5+ and Internet Explorer 6+ browsers. On Macintosh, we support Firefox 1.5+ and Safari browsers. We also support mobile browsing -- giving clients the ability to connect via their Blackberry, iPhone, Trio, or other handheld device.

Revolution Online secures all web-browser communication using SSL-encryption and the HTTPS protocol.  This means no one can intercept your transmissions or alter your data without authorization, so you don’t have to sacrifice security for convenience.

All of the hard number-crunching and heavy lifting is done on our end (on our servers), which means you don't need heavy-hitter (a.k.a. expensive, fully-configured) PCs on your end.  And no matter how big you grow, you won’t need to buy more memory to accommodate your organization’s success.

Security
Each client database resides in its own Oracle database instance, which sits behind two independent firewalls on its own dedicated LUNs (which itself is on the ROI EMC SAN behind a secure socket connection). End-user access to every database feature is controlled by security requirements that are defined by the client administrator. End-user login is encrypted and authenticated by Oracle Security established on the Oracle Application Server using an initial one-way SHA-5 encryption algorithm. Once authenticated, two-way DES3 encryption is established between the Application Server and the client database.  Revolution Online secures all of our web-browser communication using SSL-encryption using the HTTPS protocol so no one can intercept your transmissions or alter your data without authorization.

We've invested heavily in inner-office security and are proud of our three layers of office and network security. The server center is accessed solely through key cards, permitting only essential ROI personnel into the temperature-controlled environment.  The security system features full access logging for entry, and an additional independent alarm system that monitors site security and temperature controls 24/7.

PCI DSS Compliant
ROI Solutions is certified PCI DSS Compliant, which means that we conduct our business according to the Payment Card Industry Data Security Standard. All ROI Solutions policies, procedures and technical systems that process cardholder data are validated with the PCI Data Security Standard. The Trusted Commerce seal on our online application indicates that ROI Solutions protects card-holder and order information in accordance with all payment card industry best practices. In addition, ROI has employed the services of TrustWave to continually evaluate our internal processes and security standards.

Data Integrity & Audit Tracking
Revolution provides the utmost protection in data integrity at every level.  Wherever possible, we use system-level validation fields to ensure a high degree of integrity for the future. This involves drop-down menu items and extensive edit masking, as well as prompts for required fields based upon organizational business rules. In addition, our comprehensive audit-tracking system constantly maintains an historic record of every change made to any field -- including when the change was made, who made it, end-user login information, and an after-image of the tables changed. This sort of record is a key aspect of data integrity which provides complete accountability.

Backup
ROI has spent significant time and funds to ensure our backup procedures are exceptional. Client databases are backed up daily using EMC SnapView technology, where point-in-time snapshots are performed and stored offsite in a secure, fire-proof location. The entire server is backed up every night, and table dumps and exports are performed at several intervals throughout the day. Oracle Archival logging is set to continually provide archive logging on the database. ROI Solutions maintains a two-week rotating backup and a four-week retention offsite before rotating tapes, with an additional monthly backup retained for twelve months as a permanent archive.

Upgrades & Enhancements
In an effort to help our clients be as efficient as possible, ROI is committed to research and development in all aspects of our business. Part of our credo is to work with nothing but cutting-edge technology, and therefore all of our hardware and software is kept current at our expense.

Periodically, we make upgrades and enhancements to the Revolution Online database. Because of Revolution’s hosted environment, we don’t need to deploy multiple versions of our product that then have to be sent out to our clients. Instead, we handle all of the necessary upgrades and product deployment directly at our site. Programming, development, and testing are done after regular business hours in a non-production environment from both the backend and front-end perspectives. Once fully tested, the Revolution Online engine is updated in a matter of minutes and clients are able to realize the changes without leaving their chairs or reaching for their wallets.