Essay on Storage Optimization

Submitted By harrissain8371
Words: 4076
Pages: 17
Open Document
An Oracle White Paper May 2011

Optimizing Storage in SAP with Oracle Database 11g Release 2

Optimizing Storage in SAP with Oracle Database 11g Release 2

Introduction ........................................................................................ 1 Optimizing Storage in SAP with Oracle Database 11g Release 2 ..... 2 Storage Efficiency .......................................................................... 2 Index Compression and Bitmap Indexes ........................................ 3 Oracle Advanced Compression ......................................................... 3 OLTP Table Compression.............................................................. 4 SecureFiles Compression and Deduplication ................................. 4 Backup Compression ..................................................................... 5 Network Compression.................................................................... 6 SAP Benefits with Advanced Compression .................................... 6 Implementation Overview for Compression in SAP Environments . 6 SAP R/3 and BW Tables -- Compression Results Examples ......... 7 Additional SAP Compression/Storage Capabilities ............................ 8 Deferred Segment Creation ........................................................... 8 Dictionary Only Add Column .......................................................... 8 Unicode Charactersets .................................................................. 9 Additional SAP Compression/Storage Benefits .............................. 9 Conclusion ....................................................................................... 10

Optimizing Storage in SAP with Oracle Database 11g Release 2

Introduction
Using actual customer data, Oracle Database 11g Release 2 compression and space optimizations reduced the overall size of SAP systems from 4.7 TB to 1.9 TB for R/3 (ECC6.0), from 1.4 TB to 0.5 TB for BW (7.0) and from 0.9 TB to 0.3 TB for CRM (7.0). As this customer data shows, the benefits from compression can be significant, yet some organizations still have uncertainty regarding the performance impact that compression may have on their systems. Oracle testing, using compression on a SAP R/3 (ECC 6.0) system under production load, has shown that Oracle’s revolutionary compression technology provided storage savings with no significant overhead in CPU consumption, required 60% less physical reads and produced a 10% better database cache rate. Exponential increases in data volumes in recent years have put enterprise IT infrastructures under severe pressure – from a cost, performance, scalability and manageability perspective. It has become imperative to employ more efficient ways of storing and managing data to meet the growing demands being placed on IT systems. Drastic increases in storage volumes are evident in all types of applications, however, enterprise applications have proven to be among the fastest growing applications. Businesses also have growing requirements to run applications and analytics faster and faster in spite of the growth in storage volumes. The capabilities provided by Oracle’s Advanced Compression Option (ACO) enables many customers to run the database in an in-memory mode by being able to fit the entire working set of the application in memory after 2x to 3x compression – giving applications a significant leap in performance. And given the growth experienced by today’s databases, operations like backups are increasingly seen as taking longer to perform – Oracle’s Advanced Compression Option can help make those operational tasks faster, thereby providing both storage efficiency + performance as benefits. Even prior to Oracle Database 11g Oracle had already been a world leader in storage efficiency for customer data – Oracle's database size is generally significantly smaller than other databases because of the key attributes of Oracle’s data representation on disk (see
Show More

Related Documents: Essay on Storage Optimization

Whitepaper: Network Performance and Wan Optimization

FEATURE BRIEF: RiOs – What’s New RIVERBED OPTIMIZATION SYSTEM (RiOS) — WHAT’S NEW NEW FEATURES & CAPABILITIES • Cost-effectively leverages and enhances hybrid networks to meet business demands • Delivers support for application-level visibility and reporting • Introduces industry-first optimizations for Microsoft and NetApp applications • Offers Steelhead CX 255 for branch offices — high-speed performance with enterprise-class WAN optimization ACCELERATION EVERYWHERE WITH ENHANCED IT CONTROL…

Words 1049 - Pages 5

Essay about Jerry: Logistics and E-logistics Zhang Weixi 1

New trend of E-logistics ZHANG Weixi1, WANG Jian-jun2, (1 academe of Economy and society at Nankai University, Tianjin, China 300071 2 School of Management, Dalian University of Technology, Dalian, 116024) Abstract: With the development of e-business and supply chain management, more and more logistic facilitators become the coordinators in the integrated supply chain. For overcoming the disconnection of information in the supply chain, the e-logistics based on information platform has appeared…

Words 1643 - Pages 7

Nt1330 Unit 3 Project

Determination of the type of racking system, the length of the rows, number of sections in each row, number of crates in each section, and the height of the racking system has a significant affect on the order picking process. b) Storage Assignment: The arrangement of products in the storage locations defines the path of order picking process. If the products have been strategically stored in the warehouse, the order picking travel distance can be significantly reduced saving time and money. c)…

Words 659 - Pages 3

Efcient Big Data Processing In Hadoop Mapreduce

magnitude. In this tutorial we teach such techniques. First, we will briefly familiarize the audience with Hadoop MapReduce and motivate its use for big data processing. Then, we will focus on different data management techniques, going from job optimization to physical data organization like data layouts and indexes. Throughout this tutorial, we will highlight the similarities and differences between Hadoop MapReduce and Parallel DBMS. Furthermore, we will point out unresolved research problems…

Words 1765 - Pages 8

University of Maryland DOTS Selects StorTrends to Support its High-Demand Virtual Environment Essay

High Performance Storage Serves as the Core of the University?s Transportation Services Virtualized Infrastructure NORCROSS, GA, November 04, 2014 /PressReleasePing/ – StorTrends® today announced that the University of Maryland’s Department of Transportation Services (DOTS) has selected StorTrends high-performance storage arrays to be the core of its newly implemented virtual infrastructure. With StorTrends, the university’s DOTS organization is able to achieve ultra-high storage performance, true…

Words 837 - Pages 4

Stortrends To Optimize Storage Operations For The High Demand Data Center

Industry Leader Selects StorTrends to Optimize Storage Operations for its High Demand Data Center Supporting Major Fast-Food Restaurants RTI Uses StorTrends to Protect Critical Business Assets and Provide Superior Service for Some of the Largest Fast-Food Restaurants in the World NORCROSS, GA, September 9, 2014 /PressReleasePing/ –StorTrends® today announced that RTI, Inc. has deployed StorTrends high performance storage appliances to optimize storage operations for its high demand data center…

Words 703 - Pages 3

Public Systems Modeling: Systematic Identification And Evaluation Of Public Policy Alternatives

Public Systems Modeling: Systematic identification and evaluation of public policy alternatives. We use mathematical models to do this. Two main types of mathematical models: Optimization: Finding the best of many alternatives. Addressing ‘What should be’ questions.) Simulation: Finding the impacts of alternative assumptions (Addressing ‘What if’ questions.) Mathematical models: Consists of decision variables (unknowns) and parameters in equations and inequalities that together define a system. Example…

Words 545 - Pages 3

Paccu Hospital Simulation Paper

increasingly dynamic due to the complexity of patient flows and the variation in patient treatment time. The Post Anesthesia Care Unit (PACU) is a unit that treats a variety of patient types with varying treatment phases and times. The bed capacity optimization at PACU is important to balance the patient needs and the operational cost. In this research, we utilized two approaches to optimize the bed capacity at the PACU in a US community hospital. First, we used a Lean approach (Takt time and Standard…

Words 1360 - Pages 6

Questions On Database Design

19, 2014 Sandra Graca Database systems are designed to allow developers to create a database, fill it with information and be able to call up that information and change it as necessary. This also allows the user not to worry about data storage and retrieval. Some of the other aspects to database systems are: “User access and security management systems provide appropriate data access to multiple users while protecting sensitive data. Data backup to ensure consistent availability of data…

Words 561 - Pages 3

Proposal Of Online Business Expansion: Creative Deliverables Group (CDG)

include: Project Dashboard, Pay button that links to a secured page, Project Status details, and Design Approval features. Meticuosity was chosen because it’s ability to create customized websites with E-Commerce pages, Website Hosting Search Engine Optimization, Online Advertising and Social Media Consulting. This will be a one stop shop that will make it easier for this small business to manage its online presence. The Payment Gateway will be with First Data. First Data is a partner with Meticuousity…

Words 738 - Pages 3