Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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 |
Post New Answer View All Answers
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
Do you know the isolation level that sql server support?
How to generate create view script on an existing view?
Does index speed up select statements?
What is the difference RDBMS and Graph Database?
What are the differences between having and where clause.
When you should use a low fill factor?
What is extent? Types of extents?
What is a mutating table error and how can you get around it?
Why do we backup Active Directory ?
you notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it? : Sql server administration
What is difference between views and tables?
What are the 3 types of schema?
What is the cartesian product of the table?
Can sql servers linked to other servers like oracle?
