MICROSOFT SQL SERVER
The Database is Designed With the Following Features and Standards.
Highly Normalized database with easy to understand table names and field names. This database is easy to understand should your IT department want to make use of some third-party reporting tool like Crystal Reports.
Extensive use of indexes, foreign keys and referential integrity.
The multi-user aspects of R.I.M.S. are supported by a mechanism called semaphore record locking that is built into the database. This ensures data integrity and avoids collisions with two users working on the same record at the same time.
WEB SITE FEATURES
The web site requires hosting on an IIS server and is written using C# .NET.
The web site is integrated directly with the main R.I.M.S. database so all updates are in real-time. You change the inventory level or order status and your customer can see it directly. For security concerns the web site could be configured to use a replicated sub-set of the main R.I.M.S. database.
We also make extensive use of a third party development tool set call DevExpress. This gives us a much richer browser experience without a lot of time invested in developing robust user interface. DevExpress excels at robust user interface within the browser and we take full advantage of this.
The web site has been tested for all four major browsers – Internet Explorer, FireFox, Safari and Chrome. We have no recommendation or preference as to a specific browser.
R.I.M.S. has been tested and works with Microsoft’s Remote Desktop (a.k.a. Terminal Server), Citrix and VMWare. All of these work well with our products and we don’t have a preference.
Cloud Hosting is a viable option for our solution and there are a myriad of hosting options and solutions in the marketplace.
We use Windows Authentication to gain access to the system. Once in the system every user account can be setup to only have access to specific features, functions, reports, etc.