Databases Tuning a slow PostgreSQL Function By Shraddha Tambe Tuning a slow PostgreSQL Function Make data easy with Helical Insight. Helical Insight is the world's best open source business intelligence tool. The problem I faced: I had a postgreSQL function which was getting executed from a BI Report. It...
Business Intelligence Getting Started with Mongo DB By Shraddha Tambe Installation & Startup: Download MongoDB installer for windows platform from http://www.mongodb.org/downloads and run. This simply extracts the binaries to your program files. #Create DBPATH and log libraries: Allocate a folder in your system that can be used for holding the...
Business Intelligence Pentaho 5.0.1 CE integration with MySQL 5.0.1 CE (Windows or Linux family) By Nikhilesh Pentaho 5.0.1 CE integration with MySQL 5.0.1 CE (Windows or Linux ) Parts Creating databases Modifying configuration files Stopping HSQL db start up Creating databases Command to execute the scripting files mysql>source D:\ biserver-ce\data\mysql5\create_jcr_mysql.sql Similarly execute the remaining .sql files(i.e,...