Microsoft SQL Server OLAP Services supplies OLAP processing capabilities in opposition to heterogeneous OLE DB knowledge sources. It has efficient algorithms for defining and constructing multidimensional cubes that may be referenced by functions utilizing the OLE DB 2.zero OLAP extensions or the Microsoft ActiveX Data Objects Multidimensional extensions . However, response times are more probably to be slow for advert hoc queries to very giant goal databases, or queries that generate massive outcomes sets. Desktop OLAP Tools – Processing on PC or on mid-tier servers, not on knowledge servers.
