
IBM Licensed Programs: Database Accessories
524
iSeries Handbook
With DB2 OLAP Server for AS/400, choose data storage for the server as either:
• Relational database using a star schema data structure, for SQL access and system
management convenience
• Essbase integrated multidimensional storage for simplicity and performance
The relational database choice uses DB2, the industry-leading relational database to store
fact and dimension tables, to meet your business requirements.
Data in the DB2 OLAP server can be leveraged by Essbase-ready applications, and a large
variety of generic SQL access tools. Use SQL tools to easily join the star schema with
existing relational tables in the warehouse, analyze and product reports.
DB2 OLAP Server can be used for management, reporting, analysis, modeling, planning and
data warehousing applications. Graphical tools for database management and security. A
spreadsheet add-in provides desktop software to seamlessly merge data into a tightly
integrated OLAP client.
DB2 OLAP Server for AS/400 can access iSeries and AS/400e servers across all TCP/IP
networks connected to Windows and UNIX clients. It maintains and analyzes data stored in
the scalable DB2 Universal Database.
IBM DB2 OLAP Server for AS/400 – New with Version 7.1
Significant enhancements at 7.1 includes the support to:
• Create bigger cubes within a given batch window
• Choose storage options (multidimensional or relational) at the application level
• Analyze the next level of detail for data attributes
The DB2 OLAP Server for AS/400 licensed program provides a fast path to turn your
warehouse data into business insight. It is built for e-business with tools to help you quickly
deploy Web-based analytical applications.
DB2 OLAP Server for AS/400 Version 7.1 Add-on Programs
DB2 OLAP Server for AS/400 Tools Bundle Version 1.1 contains a copy of these tools:
• Currency Conversion: Converts financial data using any currency exchange rate
scenario. The Currency Conversion module allows modeling of the impact of
exchange rates and performs ad hoc conversions directly from a spreadsheet or
custom application.
• Application Programming Interface (API): Allows the use of standard tools to create
custom DB2 OLAP Server for AS/400 applications that take advantage of the powerful
data storage, retrieval, and analytical capabilities of DB2 OLAP Server for AS/400.
Содержание i Series
Страница 2: ......
Страница 3: ...IBM iSeries Handbook Version 5 Release 1 Document Number GA19 5486 21B 12 February 2002...
Страница 5: ...Table of Contents...
Страница 6: ...Table of Contents...
Страница 31: ...1 Introduction...
Страница 32: ...Introduction...
Страница 38: ...Introduction 8 iSeries Handbook...
Страница 39: ...9 Advanced Technology...
Страница 40: ...Advanced Technology...
Страница 68: ...iSeries Architecture Fundamental Strength of the iSeries 38 iSeries Handbook...
Страница 69: ...39 Workload and Performance...
Страница 70: ...Workload and Performance...
Страница 82: ...Workload and Performance 52 iSeries Handbook...
Страница 83: ...53 iSeries Direction...
Страница 84: ...iSeries Direction...
Страница 93: ...63 Server Summary...
Страница 94: ...Server Summary...
Страница 120: ...iSeries and AS 400e Servers 90 iSeries Handbook...
Страница 121: ...91 AS 400e Server 250...
Страница 122: ...AS 400e Server 250...
Страница 142: ...iSeries Model 250 Packages and AS 400e Server 250 112 iSeries Handbook...
Страница 143: ...113 iSeries Server 270...
Страница 144: ...iSeries Server 270...
Страница 162: ...iSeries Server 270 132 iSeries Handbook...
Страница 163: ...133 iSeries Dedicated Server for Domino...
Страница 164: ...iSeries Dedicated Server for Domino...
Страница 172: ...iSeries Dedicated Server for Domino 142 iSeries Handbook...
Страница 173: ...143 iSeries Server 820...
Страница 174: ...iSeries Server 820...
Страница 192: ...iSeries Model 820 162 iSeries Handbook...
Страница 193: ...163 iSeries Server 830...
Страница 194: ...iSeries Server 830...
Страница 211: ...181 iSeries Server 840...
Страница 212: ...iSeries Server 840...
Страница 232: ...iSeries Model 840 202 iSeries Handbook...
Страница 233: ...203 Upgrades to iSeries Server 8xx...
Страница 234: ...Upgrades to iSeries Server 8xx...
Страница 253: ...223 iSeries Server SB2...
Страница 254: ...iSeries Server SB2...
Страница 261: ...231 iSeries Server SB3...
Страница 262: ...iSeries Server SB3...
Страница 271: ...241 HSL and Towers...
Страница 272: ...HSL and Towers...
Страница 304: ...Towers and Racks 274 iSeries Handbook...
Страница 305: ...275 I O Processor...
Страница 306: ...I O Processor...
Страница 319: ...289 I O Adapter...
Страница 320: ...I O Adapter...
Страница 352: ...I O Adapters and Controllers 322 iSeries Handbook...
Страница 353: ...323 Internal Storage...
Страница 354: ...Internal Storage...
Страница 381: ...351 Removable Storage...
Страница 382: ...Removable Storage...
Страница 390: ...Removable Storage Media Devices 360 iSeries Handbook...
Страница 420: ...Externally Attached Automated Libraries 390 iSeries Handbook...
Страница 421: ...391 External Disk Storage...
Страница 422: ...External Disk Storage...
Страница 426: ...2105 Enterprise and Versatile Storage Servers 396 iSeries Handbook...
Страница 427: ...397 Peripherals...
Страница 428: ...Peripherals...
Страница 456: ...Peripherals 426 iSeries Handbook...
Страница 457: ...427 Customer Install Features...
Страница 458: ...Customer Install Features...
Страница 470: ...Customer Install Features CIF 440 iSeries Handbook...
Страница 471: ...441 OS 400...
Страница 472: ...OS 400...
Страница 544: ...Operating System 400 5722 SS1 514 iSeries Handbook...
Страница 550: ...Software Terms 520 iSeries Handbook...
Страница 551: ...521 Database...
Страница 552: ...Database...
Страница 575: ...545 TCP...
Страница 576: ...TCP...
Страница 595: ...565 WebSphere...
Страница 596: ...WebSphere...
Страница 627: ...597 Application Development...
Страница 628: ...Application Development...
Страница 661: ...631 Lotus...
Страница 662: ...Lotus...
Страница 689: ...659 Networking...
Страница 690: ...Networking...
Страница 727: ...697 System Management...
Страница 728: ...System Management...
Страница 754: ...IBM Licensed Programs System Management Products Services 724 iSeries Handbook...
Страница 755: ...725 Printing and Document Handling...
Страница 756: ...Printing and Document Handling...
Страница 772: ...IBM Licensed Programs Printing and Document Handling Products 742 iSeries Handbook...
Страница 773: ...743 Earlier Model Summary...
Страница 774: ...Earlier Model Summary...
Страница 831: ...801 Referenced Lists...
Страница 832: ...Referenced Lists...
Страница 863: ...833 Special Notices and Publications...
Страница 864: ...Special Notices and Publications...
Страница 877: ...847 Abbreviations...
Страница 878: ...Abbreviations...
Страница 884: ...854 iSeries Handbook...
Страница 885: ...855 Index...
Страница 886: ...Index...
Страница 904: ......
Страница 905: ...1 5 spine 1 5 1 998 789 1051 pages IBM iSeries Handbook Version 5 Release 1...
Страница 906: ......
Страница 907: ......