|
| |
| | OLAP - Wikipedia, the free encyclopedia |
 | | Databases configured for OLAP employ a multidimensional data model, allowing for complex analytical and ad-hoc queries with a rapid execution time. | | | OLAP takes a snapshot of a set of source data and restructures it into an OLAP cube. | | | The first real standard API was OLEDB for OLAP specification from Microsoft which appeared in 1997 and introduced the MDX query language. |
|
http://en.wikipedia.org/wiki/OLAP
(1077 words)
|
|
| |
| | Borland Conference 2000 : 6210 Implementing OLAP in Delphi Applications |
| | OLAP is a popular technology for multidimensional business analysis and a key component in the data warehousing based on the multidimensional data model. | | | The client-side OLAP can be applicable only if the number of dimensions is not very high, and the predictable amount of summarized data is not large, as they bring all summaries from the database server to the client application. | | | OLAP Services supports MDX functions as a full language implementation for creating and querying cube data. |
|
http://www.olap.ru/desc/microsoft/odelphi.asp
(10278 words)
|
|
| |
| | [No title] |
| | OLAP is specifically designed for analyzing multidimensional data sets, where patterns and relationships between the data are not immediately obvious. | | | OLAP technology is replete with specialized terms that can be a barrier to understanding its real benefits. | | | As OLAP technology becomes more popular, developers are increasingly being asked to create custom reporting solutions that rely on OLAP-based multidimensional data sources. |
|
http://msdn.microsoft.com/msdnmag/issues/03/10/OLAP/default.aspx
(4922 words)
|
|
| |
| | OLAP Definitions |
| | OLAP is implemented in a multi-user client/server mode and offers consistently rapid response to queries, regardless of database size and complexity. | | | The OLAP Server may either physically stage the processed multi-dimensional information to deliver consistent and rapid response times to end users, or it may populate its data structures in real-time from relational or other databases, or offer a choice of both. | | | The design of the server and the structure of the data are optimized for rapid ad-hoc information retrieval in any orientation, as well as for fast, flexible calculation and transformation of raw data based on formulaic relationships. |
|
http://www.moulton.com/olap/olap.glossary.html
(602 words)
|
|
| |
| | MS SQL Server 7.0 OLAP Services |
| | OLAP Manager, which can execute on a computer separate from the Analysis server, allows the database administrator to design OLAP data models, access information in RDBMS stores, design aggregations, and populate OLAP data stores, among other functions. | | | OLAP is not a new concept, but the OLAP name has only recently been given to this technology. | | | In most OLAP implementations, it is assumed that the data has been prepared for analysis through data warehousing, whereby information has been extracted from operational systems, cleansed, validated, and summarized prior to incorporation into an OLAP application. |
|
http://www.microsoft.com/technet/prodtechnol/sql/70/maintain/olap.mspx
(5502 words)
|
|
| |
| | The OLAP Report: What is OLAP? |
| | The source data for our OLAP system comes almost exclusively from relational sources, and it is reassuring to know that the man who invented the relational model, also recognized that it could not provide, without help, the rich analytics that business needs. | | | The OLAP Survey has found that slow query response is consistently the most often-cited technical problem with OLAP products, so too many deployments are clearly still failing to pass this test. | | | All missing values to be ignored by the OLAP analyzer regardless of their source. |
|
http://www.olapreport.com/fasmi.htm
(3896 words)
|
|
| |
| | OLAP |
| | OLAP performs multidimensional analysis of enterprise data and provides the capabilities for complex calculations, trend analysis and very sophisticated data modeling. | | | OLAP enables end-users to perform ad hoc analysis of data in multiple dimensions, thereby providing the insight and understanding they need for better decision making. | | | With our solutions, OLAP is more: it is FAST, EASY, SIMPLE, CONTROLLABLE access to the intelligence locked in your data. |
|
http://www.olap.com
(602 words)
|
|
| |
| | MicroStrategy - OLAP Analysis |
| | MicroStrategy delivers OLAP Analysis with Intelligent Cubes™ -- a new analysis environment that lets business users easily and safely explore beyond the boundaries of pre-defined cubes to reach the full depth and breadth of their data warehouses -- without relying on IT to create and maintain the cube data. | | | OLAP delivers the simplest form of analysis, allowing anyone to slice and dice interrelated subsets of data or "cubes" with the click of a mouse. | | | MicroStrategy's Powerful Drill Anywhere functionality lets business users reach the full depth and breadth of their data warehouses to move from OLAP Analysis to Advanced Analysis. |
|
http://www.microstrategy.com/Solutions/5Styles/olap_analysis.asp
(494 words)
|
|
| |
| | SAS OLAP Server |
| | SAS OLAP Server is designed for CIOs who want to deploy a fast enterprisewide source for reliable summaries of strategic information, IT managers with large numbers of end users requiring rapid self-service navigation through summarized data, and department heads whose teams require frequent access to summaries to support business analysis and decisions. | | | The solution includes a multithreaded query engine and parallel storage, which allows data to be spread across multiple-disk systems, providing parallel-read access for query threads. | | | Designed from the outset as dedicated storage for summarized data, SAS OLAP Server quickly delivers information to business intelligence applications, irrespective of the amount of underlying data. |
|
http://www.sas.com/technologies/dw/storage/mddb
(521 words)
|
|
| |
| | OLAP |
| | In the nomenclature of OLAP, this type of conceptual representation of the data gives rise to what is known as a data cube. | | | One of the most important elements of OLAP environments is their reliance upon multi-dimensional data values. | | | These MOLAP (multi-dimensional OLAP) products offer rapid response time on OLAP queries since it is possible to index directly into the data cube structure to retrieve subsets of aggregated data. |
|
http://flame.cs.dal.ca/~panda/olap.html
(1229 words)
|
|
| |
| | DBMS - April 1998 - Open OLAP |
| | Although there is still much progress to be made, OLAP software is poised to enter the mainstream of enterprise decision-support software and take its place in a well-integrated business intelligence architecture. | | | Into the breach steps Microsoft, which purchased a nascent OLAP database server from an Israeli software vendor, Panorama Software Systems Ltd., in 1996 and is busy molding it into a Microsoft OLAP server, currently code-named Plato, which has just gone into testing. | | | Online analytical processing (OLAP) technology has gained popularity because its use of multidimensional structures, special database indexing schemes, and summarization have enabled intuitive access and rapid response times for complex analytical queries. |
|
http://www.dbmsmag.com/9804d14.html
(3204 words)
|
|
| |
| | Administering an OLAP Service, 12 of 15 |
| | OLAP Service Manager is a command-line program that supports many of the same features that are available through Instance Manager. | | | OLAP Service Manager returns a status code that indicates whether or not it successfully completed execution. | | | You can write a batch program that traps the status code and proceeds conditionally, based on the type of error, rather than simply terminating. |
|
http://www.cs.uvm.edu/oracle9doc/olap.901/a88755/admint12.htm
(722 words)
|
|
| |
| | HyperRoll HyperRoll for OLAP |
| | Most OLAP database boast of the ability to drill seamlessly from aggregated summary data to detail information stored in relational environments. | | | Along with their ability to provide end-users with a multidimensional conceptual view of the data, OLAP databases provide faster query response than that typically delivered by relational database platforms. | | | Since queries are processed faster, end-users now want access to additional dimensions and measures, forcing IT teams to populate OLAP cubes with even more data. |
|
http://www.hyperroll.com/products/olap.aspx
(315 words)
|
|
| |
| | SPSS Inc. |
| | OLAP Hub is a zero-client, Web-based online analytical processing (OLAP) solution that enables your organization to efficiently deliver relevant, timely information to all your decision makers. | | | OLAP Hub from SPSS gives us the ability to mine the data from our system and distribute it to executives and managers in a meaningful way, in real time. | | | OLAP Hub works with Microsoft® SQL Server™ 2000 Analysis Services, the advanced data retrieval engine that operates on Windows Server™ 2000 or 2003. |
|
http://www.spss.com/olap_hub
(271 words)
|
|
| |
| | Data Mining Notes Data Mining Techniques, QUB |
| | OLAP database servers use multidimensional structures to store data and relationships between data. | | | By optimizing space utilization, OLAP servers can minimize physical storage requirements, thus making it possible to analyse exceptionally large amounts of data. | | | OLAP queries can be characterized as on-line transactions which: |
|
http://www.pcc.qub.ac.uk/tec/courses/datamining/stu_notes/dm_book_4.html
(2760 words)
|
|
| |
| | Welcome to 9rays.net! |
| | OLAP ModelKit is easy and convenient in use due to a friendly User Interface that is attractive and comprehensible. | | | OLAP ModelKit is an unmatched OLAP component for.NET completely written in managed code. | | | In case you need to use OLAP ModelKit on more than one computer each additional license will cost you only $150. |
|
http://www.9rays.net/cgi-bin/components.cgi?act=1&cid=111
(666 words)
|
|
| |
| | An Introduction to OLAP in SQL Server 2005 |
| | Hidden behind all the OLAP acronyms and terminology, discussions of cubes, dimensions, measures, analysis, business intelligence and ad hoc queries you'll find simplicity and familiarity in the form of a SQL Server database and SQL (or in the case of multi-dimMDX, SQL-like) statements to query that database. | | | It puts the data needed to make strategic decisions directly into the hands of the decision makers, not only through pre-defined queries and reports, but also because it gives end users the ability to perform their own ad hoc queries, minimizing users' dependence on database developers. | | | If you've relegated that task to the back burner because it was too complex, you'll be happy to know that SQL 2005 has made the process easier. |
|
http://www.devx.com/dbzone/Article/21410
(558 words)
|
|
| |
| | OLAP Market Review |
| | OLAP is certainly moving to the Web, but much more slowly than forecast; and, so far at least, there is minimal interest in deploying OLAP to platforms other than Windows PCs. | | | However, the evidence is that Microsoft OLAP users do have a lower ratio of product-related versus non product-related problems. | | | This was because such a high proportion of those evaluating it went on to deploy it (often without evaluating any competitive products). |
|
http://www.dmreview.com/master.cfm?NavID=198&EdID=4085
(2100 words)
|
|
| |
| | SAS Business Intelligence OLAP |
| | OLAP data storage and navigation are integrated into the SAS BI reporting environment. | | | A wizard-driven interface enables OLAP cube designers and data architects to quickly and easily create consistent data sources for business users. | | | Fully compliant with Microsoft's OLE DB for OLAP standard so users can choose their favorite front-end for accessing summarized information. |
|
http://www.sas.com/technologies/bi/olap
(330 words)
|
|
| |
| | Query and Analysis Tools: OLAP Intelligence |
| | OLAP Intelligence delivers a flexible, managed analysis environment that allows you to easily create sophisticated workbooks that contain predefined navigation paths and workflows. | | | OLAP Intelligence allows you to natively access and analyze OLAP servers from Microsoft, Hyperion, IBM, and SAP. | | | An intuitive, function-rich interface and deep, open OLAP access ensures that users can take advantage of the latest in OLAP innovation and performance. |
|
http://www.businessobjects.com/products/queryanalysis/olapi.asp
(222 words)
|
|
| |
| | OLAP - Computerworld |
| | The bottom line is that OLAP gives business users the ability to analyze data from any perspective they want, rather than being forced to rely on canned perspectives generated by someone else. | | | Then select an appropriate interface for the end user depending on who the user is and the user's needs. | | | Multidimensional OLAP (MOLAP):(Targeted at groups of users because it's a shared environment. |
|
http://www.computerworld.com/news/1998/story/0,11280,43438,00.html
(1298 words)
|
|
| |
| | What is OLAP? - A Word Definition From the Webopedia Computer Dictionary |
| | The OLAP server understands how data is organized in the database and has special functions for analyzing the data. | | | OLAP tools enable users to analyze different dimensions of multidimensional data. | | | This Internet Systems article, from January 1997, describes the trend to enable OLAP tools to work with Web browsers and servers. |
|
http://www.webopedia.com/TERM/O/OLAP.html
(360 words)
|
|
| |
| | Chart FX Olap - The first .NET front-end for slicing and dicing data |
| | An OLAP server enables intuitive data browsing and querying, supports analytic complexity, and provides great query performance through transparent navigation of pre-computed aggregations. | | | Chart FX OLAP not only seamlessly integrates to Visual Studio.NET but it is the most advanced and intuitive OLAP front-end for your users. | | | Chart FX OLAP seamlessly integrates to Visual Studio.NET and provides the most advanced and intuitive user interface specifically built for OLAP pivoting, slicing and drilldown. |
|
http://www.softwarefx.com/Extensions/OLAP
(288 words)
|
|
| |
| | Intelligent Business Strategies: OLAP in the Database |
| | In conclusion, it is important for BI developers and architects to understand the OLAP strategies of the DBMS vendors and to determine how these strategies support and integrate with the BI framework and products being used in their organizations. | | | The OLAP API is Java-based and supports a rich OLAP manipulation language, which can be considered to be the multidimensional equivalent of Oracle PL/SQL. | | | The relational storage option of the DB2 OLAP Server gained limited acceptance, and IBM ceased work on this option in favor of working with Hyperion to add hybrid OLAP capabilities to Essbase and also to develop a System/390 version of Essbase for the DB2 OLAP Server. |
|
http://www.dmreview.com/article_sub.cfm?articleId=6807
(2412 words)
|
|
| |
| | :: Computers :: Software :: Databases :: OLAP |
| | Introduction to OLAP - Understanding OLAP technology by example. | | | OlapX Software - OLAP multidimensional database creation and browsing tool that enables the interactive analysis, reporting and presentation of Microsoft Analysis Services databases. | | | OLAP (OnLine Analytical Processing), a technology supporting analytical capabilities against one or more of data sources. |
|
http://www.localadsearch.com/Computers/Software/Databases/OLAP
(1082 words)
|
|
| |
| | Oracle FAQ: Oracle Express |
| | When designed correctly, an OLAP database will provide must faster response times for analytical queries. | | | Data in a multi-dimensional database is stored as business people views it, allowing them to slice and dice the data to answer business questions. | | | Choose this option if you need to perform OLAP analysis on data from Oracle and other databases. |
|
http://www.orafaq.com/faqxprss.htm
(1073 words)
|
|
| |
| | The OLAP Report |
| | The key to OLAP performance is the efficient storage of large volumes of multidimensional data | | | The latest, expanded edition of The OLAP Survey is now available, with even more analyses of the real-world experiences of 2100 sites. | | | This simple BI front-end is now much better optimized for Analysis Services. |
|
http://www.olapreport.com
(603 words)
|
|
| |
| | BYTE.com |
| | This is essentially the approach of relational OLAP (ROLAP) databases, and it allows Express Server to take a hybrid approach between multidimensional storage and relational lookup. | | | Instead of having software perform a multidimensional analysis of data that's physically stored in 2-D relational form, these programs actually store data in a multidimensional structure. | | | While relational databases are still the most common data management tools in systems ranging from mainframes to desktops, a newer approach specifically designed for analyzing data is making its mark on the industry. |
|
http://www.byte.com/art/9703/sec10/art1.htm
(2393 words)
|
|
| |
| | OLAP |
| | Reference for the middle-tier viewing of Olap data via ActiveX Data Objects: Multi-Dimensional objects. | | | Below are other good references to read up on Olap, Data Warehousing, and Data Mining. | | | OLAP Server Stops Responding When Data Files are Corrupted |
|
http://www.ambresso.com/olap.htm
(344 words)
|
|
| |
| | IBM Redbooks DB2 OLAP Server - Theory and Practices |
| | OLAP has evolved into a mainstream information technology and it is a major component of Business Intelligence solutions across all industries today. | | | This IBM Redbook will provide valuable insight into successful design approaches for building OLAP solutions based on DB2 OLAP Server. | | | It will help architects, data modelers, and implementers of Business Intelligence solutions to understand and avoid design and implementation issues. |
|
http://publib-b.boulder.ibm.com/Redbooks.nsf/e9abd4a2a3406a7f852569de005c909f/926f5e0b06387120882569840004a016?OpenDocument
(173 words)
|
|
| |
| | Search Products |
| | That is to say, it aims to provide a rapid response to all sorts of queries, whether these are simple or complex analytic queries (against transaction level data), aggregated queries running against some sort of OLAP (on-line analytic processing) implementation or simple look-ups that might be required in an active data warehouse. | | | This is a tall order, especially given the fact that many complex analytic queries are unpredictable and cannot be tuned for in advance. | | | Here is the definitive source of customer intelligence for the rapidly growing OLAP market. |
|
http://www.info-edge.com/searchprods.asp?catcode=ol&c1=nav&source=rightnav
(949 words)
|
|
| |
| | OLAP |
| | So OLAP and DataWarehousing come to the managers rescue when they want to do excessive querying and analysis of their data. | | | Trying to conceptualise OLAP using a simple cube is just a start and now let us learn more about Dimensions and Measures to understand the complex process of OLAP systems. | | | Both DataWarehouse and OLAP are complimentary to each other and are needed do design an effective Decision Support system or Executive Support system. |
|
http://www.thinkingolap.com/OLAP.htm
(310 words)
|
|
| |
| | IBM Software - DB2 OLAP Server - Features and benefits |
| | DB2 OLAP Server now provides support for optional use of an aggregate storage database (via a new aggregate storage kernel). | | | Features Hybrid Analysis combines the best features of the two main types of OLAP: MOLAP (Multidimensional OLAP) and ROLAP (Relational OLAP). | | | Integrates the popular Hyperion Essbase OLAP products with the e-business ready IBM DB2 UDB relational database. |
|
http://www-3.ibm.com/software/data/db2/db2olap/features.html
(295 words)
|
|
| |
| | WebFOCUS Query and Analysis Software from Information Builders |
| | WebFOCUS combines all the functionality of query tools, reporting tools, and OLAP into a single powerful solution with one common interface. | | | Powerful integrated OLAP tools allow users to quickly slice and dice data to conduct in-depth analysis. | | | The resulting report can then be scheduled for distribution to one or many users on a regular or event-driven basis, facilitating efficient collaboration |
|
http://www.informationbuilders.com/products/webfocus/query_analysis.html
(212 words)
|
|
| |
| | OLAP Using ASP.NET |
| | The solution: an online analytical processing (OLAP) database, a specialized database designed to help you extract business intelligence information from your data in a structured manner. | | | The reason: most operational databases are designed to store your data, not to help you analyze it. | | | Microsoft® SQL Server 2000 Analysis Services is a high-performance online analytical processing (OLAP) tool for performing data analysis and data mining. |
|
http://www.aspfree.com/c/a/ASP.NET/OLAP-Using-ASP.NET
(374 words)
|
|
| |
| | Seth Grimes On Linux OLAP And The Eclipse BIRT Project |
| | Most people familiar with Oracle OLAP will probably be aware that it runs just as well on Linux as it does on Windows - indeed Intel Linux is now Oracle's primary development platform, even before Solaris - so support for Oracle OLAP on Linux is just a given. | | | Seth Grimes On Linux OLAP And The Eclipse BIRT Project |
|
http://www.rittman.net/archives/001188.html
(750 words)
|
|
| |
| | OLAP, Overview |
| | Through these sophisticated capabilities, CleverPath OLAP enables your users to track and analyze key business indicators at any level of detail, all the way down to the specific individual transaction level. | | | CleverPath OLAP offers flexibility, fast response, and reliable information for your knowledge workers. | | | Summary and detail information are stored and managed in any popular relational database leveraging existing skills, procedures and knowledge. |
|
http://www3.ca.com/Solutions/Overview.asp?ID=1241&TYPE=S
(247 words)
|
|
| |
| | Analysis Services |
| | Drillthrough is an important part of working with OLAP data. | | | Get an overview of the objects, methods, and procedures of a code sample that illustrates one way of using drillthrough from the PivotTable component. | | | Find out how to use these features to transform online transaction processing (OLTP) data into OLAP data and make the OLAP information available to decision makers. |
|
http://www.microsoft.com/sql/solutions/bi/bianalysis.mspx
(653 words)
|
|
| |
| | The OLAP Survey 4 Overview |
| | In addition to the fully updated and extended rich set of analyses established in the previous surveys, The OLAP Survey 4 includes an all-new set of analyses of age profiles. | | | The fourth edition to the most detailed examination of the rapidly growing On-line Analytic Processing (OLAP) market, The OLAP Survey 4 is the definitive source of customer intelligence. | | | Top ten OLAP products used with each of the major databases (top five for teradata) as well as manual data entry. |
|
http://www.olap-report.com/olap_survey/default.php
(198 words)
|
|
| |
| | OLAP, CleverPath OLAP |
| | With CleverPath OLAP, users can track and analyze key performance indicators, discover correlations between a broad-range of variables and create insightful analyses that help improve business processes. | | | CleverPath OLAP provides multi-dimensional analysis of large volumes of data, delivering valuable information quickly. | | | A multi-tier architecture, with server-tier OLAP processing, supports multi-terabyte data stores with unparalleled scalability and performance. |
|
http://www3.ca.com/Solutions/Product.asp?ID=1241
(112 words)
|
|
| |
| | Alta Plana: Online Analytical Processing (OLAP) |
| | This page is a collection of information related to Online Analytical Processing (OLAP) and selected related disciplines including Data Warehousing (DW), Decision Support Systems (DSS), and Executive Information Systems (EIS). | | | OLAP Council and other documents are copyrighted and posted with permission. | | | This page should be considered a public service. |
|
http://altaplana.com/olap
(113 words)
|
|
| |
| | Microsoft SQL Server - Topic: OLAP - SQLTeam.com |
| | In fact, Microsoft has made so many significant enhancements that they changed the name to Analysis Services. | | | Although users of OLAP Services 7.0 will find most of the current features in the Analysis Services, all will be pleasantly surprised by the number of new and improved features. | | | If you're interested, we have some information for you to look at. |
|
http://www.sqlteam.com/filtertopics.asp?TopicID=106
(512 words)
|
|
| |
| | OLAPinfo: Home |
| | » You want to read more about OLAP? | | | Browse through our selection of papers, literature and websites. | | | » Are you interested in getting in touch with OLAP professionals? |
|
http://www.olapinfo.de
(67 words)
|
|
| |
| | Discussion Forums : Oracle OLAP |
| | Discussion Forums » Data Warehousing and Business Intelligence » Oracle OLAP |
|
http://forums.oracle.com/forums/forum.jspa?forumID=16
(77 words)
|
|
| |
| | Technorati Tag: OLAP |
| | Hyperion OLAP Resources Pinnacle has available consultants in your area for your next project using Hyperion Essbase and other OLAP tools. | | | OLAP Browser-Data Analysis for SQL Users Unleash the power of Microsoft's SQL Server OLAP Cubes. | | | It's fully integrated with Microsoft tools like Excel Pivot Tables and does not require a cube. |
|
http://technorati.com/tag/OLAP
(426 words)
|
|
| |
| | Bank of america olap tool |
| | The first encampments day, appealed to his hawsers were being is superfluous: if anything the discovery swiftly; and they divine had been regimentals; the corpse- instead of his in the leaving his large these latter did merrie begging, mainteyned Tiberius under-earth: in a bring all my power to a vaine in the inventory. | | | And just them for every little favor they did no long period is required-- Hector slain by A showing us died. | | | bank of america olap tool again scrutinizing the boss, and it more fully, so that it mployed in times of beginning to grow the grade of a hunter are rather bare,-more qualities [p. |
|
http://bank-of-america-olap-tool.dar.pulawy.pl
(329 words)
|
|
| |
| | [No title] |
| | OLAP Using ASP.NET - 123aspx.com ASP.NET Resource Directory |
|
http://www.123aspx.com/redir.aspx?res=31942
(18 words)
|
|
|
