Explain fundamentals of Data ware housing & OLAP?
Answers were Sorted based on User's Feedback
Answer / kamal
OLAP
>Online Analytical Processing (OLAP) is a popular and
powerful data analytical method.
>It explores the complex data structure and presents the
information
OLAP functionality is:
• Multidimensional -- OLAP services provide a wide
variety of possible views or a multidimensional conceptual
view of the data by supporting a dimensional aggregation
path or hierarchies and/or multiple hierarchies.
• Easy to understand -- The data mart designed for
OLAP analysis should handle any business logic and
statistical analysis that is relevant to the application
and the developer, while at the same time, keeps it easy
enough for the target user.
• Interactive -- OLAP helps the user combine business
information through comparative,. The users are allowed to
define new ad hoc calculations as part of the analysis and
can report on the data in any desired way.
• Fast -- OLAP services are usually implemented in a
multi-user client/server mode and offer consistently rapid
responses to queries, regardless of database size and
complexity.
Is This Answer Correct ? | 9 Yes | 1 No |
Answer / radhakrishnan vaithilingam
Dw:historical data for related application and this is
support to decision making system.
Eg: sales manager check the total sale details for all
loaction. every location using seperate database. so we
need to merge all data in one database.
- we can use star schema or snowflake shema
OLAP : online analtical processing.
Is This Answer Correct ? | 2 Yes | 0 No |
hi i am having .mdf file and .ldf file ..how can i get the all table in my .mdf..plz give solution
Does dbcc checkdb requires db to be in single_user mode? : sql server database administration
Which operator do you use to return all of the rows from one query except rows are returned in a second query?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What are various limitations of the views?
Can anybody explain me cold backup and hot backup?
How to convert a table data in XML format in sql server?
What is the stored procedure?
Explain external key management in sql server 2008
How to count rows with the count(*) function in ms sql server?
What are the options which must be set to allow the usage of optimistic models?
what are different types of backups available in sql server? : Sql server database administration