The deployment of our solution across a number of servers using Ingres .NET has meant that we can protect the database server behind a highly secure firewall and deploy the front end solutions on a normal web server.
Whilst our server up-time is in the > 99%, we still have to reboot the DBMS periodically to allow us to archive the log file. The ability to reset the log file without stopping the DBMS would be helpful for us. We have created our own error management/reporting process within our database procedures. Unfortunately, if there is a database error, such as a duplicate key, the default action is to abort. This means that our information is generally lost. An option to not abort on failure would be great. Of course, this only really occurs in testing.
PeerSpot’s crowdsourced user review platform helps technology decision-makers around the world to better connect with peers and other independent experts who provide advice without vendor bias.
Our users have ranked these solutions according to their valuable features, and discuss which features they like most and why.
You can read user reviews for the Top 5 Data Warehouse Tools to help you d...