Month: December 2014

How to install MongoDB on RHEL/Centos/Fedora Server

Posted on by Jay

Introduction to MongoDB:-

MongoDB is an open source schema less database system which provides a document-oriented data model. The prime concern was that MySQL is written using SQL queries, while MongoDB is focused on BSON (Binary JSON). It is a cross-platform NoSQL database. It is table based relational database structure in favor of json like documents with dynamic schemas, making the integration of data in certain types of applications easier and faster. MongoDB is free and open-source software.

So let’s see the steps to install mongoDB on RHEL/Centos or Fedora Server.

How-to-install-MongoDB-on-RHELCentos-Fedora-Server

Installation procedure:-

Step: 1  System Login as root user. We are checking system OS type and system bit type.

 # uname –a
   # cat /etc/issue

Step: 2  Now we are creating a yum repo file .like /etc/yum.repos.d/mongodb.repo

# vi /etc/yum.repos.d/mongodb.repo

For we are using as 64 bit System:

[mongodb]
name=mongodb Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/x86_64
gpgcheck=0
enabled=1

For we are using as 32 bit System:

[mongodb]
name=mongodb Repository
baseurl=http://downloads-distro.mongodb.org/repo/redhat/os/i686
gpgcheck=0
enabled=1

Step:3  Now we install MongoDB client and server using Yum

       # yum install mongo mongo-server

Step:4  Now we can configure and basic setting in MongoDB Database Server

       # vi /etc/mongod.conf
       logpath=/var/log/mongo/mongod.log
       port=27017
       dbpath=/var/lib/mongo

Step:5  Start MongoDB Server

       # /etc/init.d/mongod start

Step:6  Start MongoDB Server on system boot time

       # chkconfig mongod on

Step:7  Test MongoDB server

# mongo
   	> use test
   	switched to db test
  	> db.test.find()
 	> db.test.save({sd: 1})
	> db.test.find()
  	{ "_id" : ObjectId("4b9ef53c4f450969bb35a1a9"), "sd" : 1 }
   > db.test.update( {sd: 1}, {sd: 5})
   > db.test.find()
 	{ "_id" : ObjectId("4b9ef53c4f450969bb35a1a9"), "sd" : 5 }

 

Conclusion:-

MongoDB has an official driver for a variety of popular programming languages and development environments.

We at Andolasoft having vast expertise on implementing MongoDB database as backend in several cutting edge applications. We have developed many apps like OrangeGigs, SQUADZ  by using MongoDB as backend.

You can also see: How to Import csv configuration file to device’s SQLite db

Hope it will be helpful for you. I’d love to hear about your thoughts on this.
Thank you for your Interest.

Top 5 Reasons: Why You need Business Intelligence

Posted on by Jay

In general, each organization needs Business Intelligence (BI) at some point. For example, when a retail company is started – there was no scope for ERP with minimal business transactions having few employees on the roll.

As the business picked up, I wanted to find answers to some obvious questions like “What is the sales trend over a given period?”, “Which commodity is having more demand during festive seasons?”, “What is rate of growth year-wise?” etc.

Having said that, even the tiniest organizations need some kind of analyzed data, graphical display adds value.

BI – A need for Any Sized Company:

Be it mid-sized or smaller companies (SMBs), they do have same need as the big companies do for using BI.

It is required for better visibility of the business performance followed by corrective decisions. In summary, the intelligence reports are equally important for irrespective of the company size.

Challenges:

The truth is, most SMBs usually use the Excel spreadsheet as a tool for analysis. Every day they enter the data and prepare the report manually.

Several reports created by various employees very often without any real coordination resulting in-appropriate intelligent output.

So, when management asks a simple question like, “What is the percent of growth rate compared to that in last financial year?” and the answers don’t match. In addition to that, it will take longer to deliver the reports.

With time the company increases, with increase in employees, and thereby hike in transactions, it becomes too much to be handled for analysis.

The need for BI is necessitated.

Business-Intelligence-Tool

Solutions:

To meet the challenges to get an accurate intelligence output, the KPI (Key-Performance-Indicators) & key metrics need to be well defined for the business.

These are to be supported by data warehouse and BI reporting tools.

For example, as a retail vendor, we need to analyze our business pipeline over the period of the entire year.

We could get the fact that the most favorable period is December-January and the most slowdown period is March-April.

Based on this intelligence report we plan our purchasing strategy and can minimize the losses.

So, for this purpose we did not opt for any expensive software rather we built our own BI Tool with open source components and interfaces of latest trend.

So, we can agree that, in order for prosperity & growth of your organizations, you must consider to have BI in place so that the performance can be measured and appropriate decisions can be taken based on the gaps found.

Conclusion:

5 reasons to invest in Business Intelligence today

  1. Measure Business Performance
  2. Analyzing Gaps
  3. Appropriate decision making
  4. Minimize loss of revenue
  5. Achieve consistent growth

If you are really interested to boost your business, Andolasoft is committed to provide the high-performance business intelligence through reporting, monitoring and consultation.

Read also : How Business Intelligence can help Direct Sale Organization

It would be a great pleasure for me, if you contributed your informative idea on this post.

Thank you for your involvement.