...
Chemwatch uses relational Oracle database. The data size is currently slightly over 0.5 Tb. It holds information on 300k reviewed and indexed chemicals (so called Chemwatch Golds) as well as on over 2 million other materials. The database is responsible for system state and process processes millions of transactions per day. Its structure is optimized for performance and consistency. No duplicate information is stored; relations are built and resolved instead. This helped us to come up with a design schema capable to cope with high server side load generated by many clients (3500 active accounts with many users working under those).
...
The data layer is represented by Oracle 11g 12c database hosted in Amazon cloud (RDS extra large node). It holds all the data required for effective management of chemicals against different regulations used in different countries. All available performance and statistic tools are enabled on RDS to help us monitor database 24x7 and act on any deviation from the normal patterns.
...
Web based clients are developed using .NET 4.0 Framework and work efficiently under different browsers such as: Internet Explorer 8.0 through latest, Mozilla FireFox 3.6 through latest, Google Chrome 14 through latest,Microsoft Edge and Safari S5.
SmartCobra SmartSuite for the iPhone and Android is created using mobile development frameworks.
...
Both Business layer and Front end run on IIS7.5 under Windows 2008 Server Datacenter Edition. Amazon is responsible for keeping those up to date and installing all the required security updates.You can learn more about WebService by watching video presentation:http://www.chemwatch.net/marketing/presentations/webServ/video.
Integration capabilities
Web Service API 2.0 enables clients to create live data or document links to other application using:
...
Any modern programming language has means to send and receive web requests (HTTP/HTTPS). This is all that is required to build connectivity to Chemwatch Web API 2.0.
...
Amazon cloud allows us to provide the high end level of data safety and disaster recovery. A separate instance of the database is maintained up to date with Master-Slave synchronization schema in a different geographical region. We can use that second instance at any time to recover data. Amazon cloud also enables us to quickly scale the system to cope with increased load at runtime. A tailored balancing mechanism is used to enhance server capabilities automatically when required. All the critical updates are installed by Amazon timely, maintaining the system in its current state and decreasing any risks associated with security vulnerabilities.
...
The server infrastructure which serves all clients consists of two application servers, both of which are located in two separate physical data centers in California, United States.
One server remains dormant and is only activated when there is either a traffic surge or the active server hardware is being overwhelmed.
Both application servers are pointing to a master Oracle database. This Master is synchronized one way to a low spec active Oracle database located in Tokyo. In addition to this database, there will be a dormant application server that can be activated should the need arise.
Based on our tests, California and Tokyo provide the best connection to the rest of the world including Europe and Australia.
Data Security
In the Cloud solution, user data stored is available only to the user and Chemwatch IT (to provide the support). Other customer customers cannot get an access to the other client’s information as it is protected by security login and password. To make sure no outside person can get hold of the user data we established a “white list” of IP addresses allowed to connect databases directly. In order to secure traffic we can enable enforce SSL (MD5) /TLS (SHA-1) secure connection between Chemwatch and the client. Additionally we implement TLS secure connection on our server, so customer may use the power of SHA-1 hashing key to secure the traffic.
...
.