As we all know, BI is extension of data warehousing. The data warehouse is basis for BI solutions. First Questions comes in our mind why do we need a data warehouse ?
Following are the key reason for need of the data warehouse:
All information in one place
All history available
Easy to understand
Clear and uniform definitions
Standardized data
Quick access
However, [...]
Developing Business Intelligence solution for the organization is a process of turning data into information. It is not the typical product that you can implement and make operational. The key component of this process is consolidating the data from various sources and implementing the data warehouse. BI is an extension of the data warehousing. It is [...]
We all live in data age. As we all know, the biggest challenge in the industry is a flood of data. The flood of the data is from many sources.
Social Media, One of the website of in social media produces about the 10 billions data per day.
One of the biggest stock exchange produced one [...]
Installation of mysql server/client on CENT OS(Linux)
Prerequisites
download latest mysql rpm for client/server(community) from below address.
http://www.mysql.com/downloads/mysql/
Select the platform , Generic Linux
Select package of 32 bit/64 bit as per your requirement.
Installation Steps
Step# 1 : login with root user(OS) , via ssh/putty
Step# 2 : check previous version of mysql is installed [...]
Oracle Application Express (APEX) is innovative web application development tool for Oracle Database. Apex provides the browser based rapid application tool for the faster development. With the APEX , we can develop the professional mid and large scale web application. APEX is “no cost” standard component with all editions of the Oracle Database. Any [...]
Business Intelligence provides the single fact for all the data of organizations. It helps business to get the correct information for each business like What is the sell of products in peak season ? Is your business meeting the bench mark? How many customers in your organization are satisfied with your services?
All such [...]
The Sales Force Automation (SFA) solutions authorize salespersons with all the required details where they need it most. SPEC INDIA SFA has designed features that help pick up sales channel effectiveness and usefulness, Sales manager can become more efficient and more effective, sales opportunity approaching, sales quotes and, product pricing, new order entry, and shipped [...]
RDBMS have been available for more than 30 years. A relational database is a group of tables ,indexes, constraints and relationships are defined between them. RDBMS are queried using SQL, and result produced from queries that access data from one or more tables. Multiple tables, indexes being accessed in a single query are “joined” together, [...]
When considering indexes never be afraid of not indexing. On the contrary, do not always assume that an existing index should exist, simply because it does exist.
When considering use of unusual indexes such as clusters, bitmaps, and hashing be aware of their applications. The only index type amenable to data changes is a BTree index. [...]
Errors from stored procedures are reported via return codes and the RAISERROR command. RAISERROR doesn’t exit from the procedure, it simply returns the specified error message and sets the @@ERROR automatic variable. You can pass your own error message to RAISERROR to return, or you can reference a predefined error number/message combo in the sysmessages [...]
