TAILIEUCHUNG - Oracle Essbase 9 Implementation Guide- P77

Oracle Essbase 9 Implementation Guide- P77:Essbase is a multidimensional database management system. The name Essbase stands for Extended Spread Sheet dataBASE. Using the custom add-in provides the end-user with near seamless compatibility in the Microsoft Excel spreadsheet program. | 10 Essbase Analytics Option Welcome to the exciting world of Essbase Analytics known as the Aggregate Storage Option ASO . In the first nine chapters of this book we have taken you from being a competent IT professional that is an Essbase novice to that same competent IT professional who is now a capable Essbase programmer administrator as well. All along this journey we ve been using the Block Storage Option BSO database architecture. We have presented all of the instructions teachings and examples based on the BSO in Essbase. All of the efficient methods of processing performance tuning and database design have been geared towards using the BSO. In fact prior to Essbase version your only option was the use of the BSO architecture for building Essbase applications. Well now you re ready to take everything one step further. You see the BSO architecture used by Essbase is the original database architecture as the behind the scenes method of data storage in an Essbase database. Remember we have already discussed that the block construction can be conceptually compared to a Rubik s Cube for how the data is stored in the cells of a data block like the cells of color on a Rubik s Cube. The ASO method is entirely different. Let s learn all about the ASO which is now also used to store data in an Essbase database. We will learn exactly what ASO is how it works and when to use ASO instead of BSO. We will explain the use of the special industry standard multidimensional data query language known as MDX that is employed by Essbase and is particularly effective with ASO. Finally we ll go over the pros and cons of ASO and BSO. Download at Essbase Analytics Option What is ASO ASO is Essbase s alternative to the sometimes cumbersome BSO method of storing data in an Essbase database. In fact it is BSO that is exactly what makes Essbase a superior OLAP analytical tool but it is also the BSO that can occasionally be a detriment to the level of system performance .

TỪ KHÓA LIÊN QUAN
TAILIEUCHUNG - Chia sẻ tài liệu không giới hạn
Địa chỉ : 444 Hoang Hoa Tham, Hanoi, Viet Nam
Website : tailieuchung.com
Email : tailieuchung20@gmail.com
Tailieuchung.com là thư viện tài liệu trực tuyến, nơi chia sẽ trao đổi hàng triệu tài liệu như luận văn đồ án, sách, giáo trình, đề thi.
Chúng tôi không chịu trách nhiệm liên quan đến các vấn đề bản quyền nội dung tài liệu được thành viên tự nguyện đăng tải lên, nếu phát hiện thấy tài liệu xấu hoặc tài liệu có bản quyền xin hãy email cho chúng tôi.
Đã phát hiện trình chặn quảng cáo AdBlock
Trang web này phụ thuộc vào doanh thu từ số lần hiển thị quảng cáo để tồn tại. Vui lòng tắt trình chặn quảng cáo của bạn hoặc tạm dừng tính năng chặn quảng cáo cho trang web này.