oracle database 12c plug into the cloud e-book...oracle database 12c plug into the cloud chapter 2:...

Oracle Database 12c Plug into the Cloud


Table of Contents

2

8

16

20

26

30

Table of Contents

Chapter 1: Innovation

Chapter 2: Powering the Real-Time Enterprise

Chapter 3: Database Consolidation

Chapter 4: Database Storage Optimization

Chapter 5: Defense-in-Depth Security

Chapter 6: Maximum Availability

36

42

46

48

52

54

Chapter 7: Data Warehousing and Big Data

Chapter 8: Rapid Time to Value

Chapter 9: Database Management

Chapter 10: Hardware and Software Engineered Together

Chapter 11: Conclusion

Resources

1



A Revolution in Data ManagementData is now a critical differentiator in nearly every industry.Organizations on the leading edge of data management are ableto achieve greater profitability and compete more effectively. Tostay ahead, you need a database management system that willaccommodate relentless growth, support increasingly fasterdecision-making, and deliver breakthroughs in performance,security, availability, and manageability.

Enter Oracle Database 12c, the next generation of the world’smost popular database. It’s built on a new multitenantarchitecture that enables the deployment of database clouds. Asingle multitenant container can host and manage hundreds ofpluggable databases to dramatically reduce costs and simplifyadministration. Oracle Database 12c also includes in-memorydata processing capabilities delivering breakthrough analyticalperformance to power the real-time enterprise.

A Breakthrough in Database ConsolidationAccording to Research Vice President Carl Olofson of IDC,Oracle’s new pluggable database architecture not only enablesmultiple databases to be managed as a group, but it also formsthe basis for database resource virtualization—a key element ofcloud deployments. “Significantly, this feature may beimplemented with no change to application code or existing SQLqueries or reports,” he says.1

“Oracle Database userscan take heart in knowingthat the technology towhich they are committed is developingaggressively in the right direction.”Carl W. Olofson, Research Vice President, IDC

Read the Report

2

Video: “It’s one shot:unplug it, plug it insomeplace else.”

James Lui, Senior OracleApplications DBA, Aramark

Watch the Video (1:23)

1IDC Insights Report, “Oracle Announces GA for Oracle Database 12c,”(July 2013, IDC #242093). 3



A New Level of Performance in AnalyticsEnterprises are always looking to make business decisions morequickly to drive higher profits and maintain a competitiveadvantage. Oracle’s new Oracle Database In-Memory columnstore accelerates database queries and enables businesses tomake better and faster decisions. Oracle’s unique approachspeeds up analytics, data warehousing, and reporting workloadswith almost no effort. Existing applications automatically andtransparently take advantage of in-memory processing withoutrequiring any changes and without losing any existing OracleDatabase capabilities. Oracle Database 12c enables a new levelof business performance for accelerating operations, quicklydiscovering new growth opportunities, improving the customerexperience, and making smarter business decisions.

Reinventing Database ProtectionEnterprises never want to lose vital business data; however, theycan’t spare the time to back up data for multiple critical

applications. Oracle’s Zero Data Loss Recovery Appliance(Recovery Appliance) is the industry’s first engineered systemdesigned specifically to protect Oracle databases.

It addresses the biggest enterprise data protection challenges,delivering unparalleled availability, efficiency, scalability, andmanageability. The Recovery Appliance captures real-time redoblocks to eliminate data loss and enable full database recovery,while minimizing the impact of backups on production systems.This massively scalable appliance can protect thousands ofdatabases while enabling IT to manage the entire data protectionlifecycle—from data creation to tape archives—from a singleinterface. Experience unparalleled database protection todaywith the Zero Data Loss Recovery Appliance.

A New Standard for the Database IndustryWith Oracle Database 12c, modern computing paradigms suchas database as a service (DBaaS) and big data aren’t just

Video: Oracle CEO LarryEllison Introduces OracleDatabase In-Memory.


4

Webcast: Zero Data LossRecovery Appliance.

Watch the OverviewWebcast (8:50)

5



academic concepts—they are a natural part of everydaybusiness. Oracle Database 12c features more than 500innovations that help customers fulfill the most demanding onlinetransaction processing (OLTP), data warehousing, and big datarequirements. Other innovations include the new Automatic DataOptimization and Heat Map features in Oracle AdvancedCompression that enable administrators to create and applyinformation lifecycle management (ILM) policies based on theusage patterns of their user’s data to enable automaticcompression and storage tiering. Together, they help reducestorage costs and improve application performance. In addition,major enhancements in availability, security, and support for bigdata make Oracle Database 12c the ideal platform for private andpublic cloud deployments.

Read on to learn why early adopters of Oracle’s new databasemanagement system are so enthusiastic. Or dive into the detailsby downloading the Oracle app from the Apple App Store on yourmobile device and launching Oracle’s AR scanner app to bringthe image to the right to life.

Embrace New Technology with Oracle Database 12c

Plug into a cloud-based architecture with a fast, scalable,reliable, and secure database platform.

Lower the cost and risk of database consolidation.

Deliver enterprise-class performance, availability, security,and analysis for big data.

6



100x Faster Decision-MakingBusinesses must compete in today’s high-speed, always-onworld where customers are more demanding than ever. Withrelational databases powering the most mission-criticalapplications in enterprises today, database performance directlyinfluences the quality of business decision-making. Businessstakeholders need the ability to model scenarios quickly basedon up-to-date information to make decisions in the momentinstead of after the fact.

Oracle Database In-Memory transparently accelerates analyticsby orders of magnitude while simultaneously speeding uptransactions in mixed-workload systems. Leveraging SIMD vectorinstruction processing available in modern CPUs, OracleDatabase In-Memory is able to execute queries in parallel directlyfrom RAM at blazing speeds compared to traditional disk-based

methods. This enables database users to get immediateanswers to business questions that previously took hours withoutthe need to restrict functionality or accept compromises,complexity, and risk.

Data Sheet: Oracle Database In-Memory:Powering the Real-Time Enterprise.

Read the Data Sheet

Analytics Based on Up-to-Date TransactionsOracle Database In-Memory seamlessly extends existing Oracledatabases with a new high-speed in-memory column formatwhile preserving the existing row format on disk. The dual-formatarchitecture of Oracle Database In-Memory represents databasetables simultaneously in both formats. Reporting and analyticsworkloads automatically use the in-memory column format onthe production database while transactional workloads use thetraditional row format. By ensuring that both formats staytransactionally consistent, business stakeholders now have theability to run queries against the most recent and up-to-datetransactions.

8 9



Faster Mixed-Workload TransactionsEnterprises are increasingly consolidating databases into mixed-workload environments that both run analytical queries andprocess OLTP transactions. To accelerate mixed-workloadreporting, it is common to create dozens of analytic indexes onimportant tables. With the blazing speed of Oracle DatabaseIn-Memory, the manual effort and storage cost needed to buildanalytic indexes can now be eliminated.

By virtue of eliminating analytic index overhead, OLTP operationshave much less burden when processing transactions. Thus, byadopting an in-memory column store for faster analyticalprocessing, enterprises receive the benefit of acceleratingtransaction processing as well.

Implementation as Easy as Flipping on a SwitchAs an option of the industry-leading Oracle Database, OracleDatabase In-Memory can be implemented on any existing OracleDatabase system as easily as flipping a switch. As an option ofOracle Database, Oracle Database In-Memory offers a numberof benefits. First, database objects need not fit entirely inmemory. Oracle Database allows the use of mixed storage tiersfor balancing optimal performance with cost-efficiency. OracleDatabase In-Memory simply enables a new database-aware tierof storage for the database administrator to control.

With Oracle Database In-Memory, your databases can grow toany size while keeping costs low by transparently blendingmemory with flash and disk.

Second, all of Oracle Database’s industry-leading datamanagement, availability, and security features remain fully inoperation. This means any existing Oracle Database–compatibleapplication automatically and transparently benefits fromcolumnar in-memory processing without additional programmingor application changes. Database administrators and applicationdevelopers need not rewrite, rebuild, or migrate theirapplications.

10 11



In-Memory Fault ToleranceAs enterprises run mission-critical applications on OracleDatabase, fault tolerance of performance characteristics arecritical as well. Server failures can potentially cause degradationof performance while new server memory stores are populatedwith relevant data and queries are served from disk. OracleDatabase In-Memory’s fault tolerance feature eliminates the riskof this degradation by optionally mirroring data across the serversof a cluster. Just as storage subsystems stripe and mirror dataacross disks to achieve high performance and high availability,Oracle Database In-Memory distributes and duplicatesin-memory data across the servers of a cluster. If a server fails,queries transparently start using redundant copies of the datastored in the memory of surviving servers. Oracle DatabaseIn-Memory fault tolerance ensures that aggressive SLAs arenever compromised.

Simplified ManagementBeyond ease of implementation, Oracle Database In-Memorydramatically simplifies the operational tasks of a databaseadministrator. Complex data integration, tuning, and index-building operations are eliminated. Oracle Enterprise Manageralso makes it easy to monitor and measure the benefits ofin-memory columns. Database administrator productivity issignificantly enhanced with Oracle Database In-Memory.

Likewise, the elimination of separate copies of productiondatabases in siloed data marts enables significant capital costreduction and higher asset utilization. Server and storagehardware can be consolidated as data is loaded into the existingmemory of production systems. By eliminating time-consumingadministrative overhead and reducing capital costs, databaseprofessionals have the opportunity to provide radically better andmore-efficient service to their enterprises.

Smarter Decisions in Real TimeIT organizations have the opportunity to transform theirbusinesses and change a long-held view of analytics as anadjunct activity to business operations. Enterprises have aunique opportunity to merge business operations with businessanalytics into an environment of continuously optimized andinformation-powered business processes. As businessexecutives have less luxury to wait for information or prescribe

12

Video: Industry ExpertsDiscuss Oracle DatabaseIn-Memory.


13



their information requirements ahead of their needs, OracleDatabase In-Memory enables decision-makers to get answers asfast as they can ask questions. The real-time responsivenessenabled by Oracle Database In-Memory delivers insights in themoment instead of after the fact.

The ability to easily combine real-time data analysis withreal-time transaction processing enables organizations tobecome real-time enterprises. Oracle Database In-Memorypowers the real-time enterprise, unleashing new levels ofcompetitiveness and profitability by enabling them to makedata-driven decisions, respond instantly to customer demands,and continuously optimize key processes.

14

Video: Oracle ApplicationsExecutives Discuss OracleDatabase In-MemoryBenefits.


15



Maximize UtilizationConsolidation allows organizations to maximize IT resources andminimize idle compute cycles. This in turn lowers costs becausefewer resources are required to achieve the same outcomes.According to a 2013 survey of 160 organizations conducted bythe Independent Oracle Users Group (IOUG), 36 percent ofrespondents said they are either planning to consolidate or havealready consolidated their critical-business application onto acommon database platform.

With the introduction of new multitenant capabilities, OracleDatabase 12c is the world’s first database optimized for databaseconsolidation. Until now, most database management systemscould only run one database at a time. In order to run multipledatabases on a single server, IT pros often had to provision andmaintain multiple instances—one for each database. Althoughthis architecture ensured strong security and separation of data,it required excessive overhead.

Oracle Multitenant offers all the benefits of managing manydatabases as one, yet retains the isolation and resource control

"The upgrade to Oracle Database 12cand the multitenant capabilities havegiven us a huge amount of benefits.We’ve been able to massively decrease ourhardware budget by about 75 percent. Ourconsolidation ratio on [Oracle] Database [12c] isabout five times what we were looking atpreviously. We’ve been able to significantly reducethe time, effort, and, therefore, cost associatedwith standing up new environments and makingclones for existing customer environments."James Anthony, Technology Director, e-DBA

of separate databases. The multitenant container architectureenables customers to set up one cloud environment with up to250 pluggable databases in each container database.

16

Video: e-DBA AchievesDBaaS with OracleMultitenant.

James Anthony, TechnologyDirector, e-DBA


17



Deliver Database as a ServiceDatabase as a service (DBaaS) is a cloud paradigm that enablesusers to request database environments via a self-service portal.Oracle Database 12c provides a new architecture to simplifyDBaaS environments. Oracle’s flagship enterprise managementsolution, Oracle Enterprise Manager 12c, automatesadministrative tasks such as provisioning databases, meteringusage, and troubleshooting issues. Together, these solutionsprovide a self-service portal that allows users to requestdatabase capacity and perform management operations—withouttying up IT resources.

The DBaaS model can help standardize hardware and software,simplify technical support, and give users the autonomy toprovision database resources on their own. Meteringconsumption provides visibility into actual usage so that peopleonly pay for what they use—instead of paying up front for morecapacity than they might otherwise need. With DBaaS, ITdepartments can increase agility, minimize costs, and reducerisk.

Consolidate and Compress Database Workloads at aHigher Density Than Ever Before

Increase DBA productivity dramatically by managingmany databases as one.

Implement a multitenant architecture with noapplication changes.

Reduce system resources up to 6x while maintainingfull data isolation.

Start the journey to DBaaS and cloud computing.

White Paper: Delivering Database as aService (DBaaS) using Oracle EnterpriseManager 12c.

Read the White Paper

18 19



Information Lifecycle Management BreakthroughsFor most organizations, data volume doubles every two to threeyears, making storage one of the costliest elements of today’s ITbudgets. This increase in data volume also makes it more difficultto maintain performance requirements. That’s why forward-looking IT organizations are adopting advanced databasetechnologies that automate compression and storage tiering toscale with the growth of data volume while also improvingdatabase performance.

For example, Oracle Database 12c supports advancedinformation lifecycle management (ILM) capabilities thatautomatically compress and store data according to businessand performance needs. The Heat Map and Automatic DataOptimization features in Oracle Advanced Compression worktogether to automatically compress and move data based ondata usage. These technologies enable users to reduce theirstorage footprint across tiers of storage while improvingdatabase performance. Heat Map provides detailed insights intohow data is being accessed. Automatic Data Optimization usesthis information to automate compression and storage tieringaccording to user-defined policies.

Many IT organizations implement storage tiering by deployingdata on different tiers of storage so that less-accessed (“colder”)data is migrated away from the costliest and fastest storage—stillavailable, but at slower speeds—the effect on the overallapplication performance is minimized, due to the rarity ofaccessing colder data.

20 21



But even with the right storage and compression capabilities,deciding which data should reside where and when to migratedata from one tier to another remains a serious challenge. OracleDatabase 12c addresses this challenge with features thatautomatically discover data access patterns and uses theinformation to automatically optimize how data is organized.

Oracle Advanced CompressionOracle Advanced Compression can compress all types ofdata—including relational (table) data, unstructured (file) data,network data, and backup data. This unique technologysignificantly reduces the storage footprint while improvingperformance across the entire IT infrastructure—without requiringany changes to your applications.

Podcast: Listen to Satish Zalavadia, seniordatabase administrator at Bank of America,describe how Oracle Advanced Compressionand the SecureFiles feature in OracleDatabase help the bank accommodategrowth by reducing database storage andimproving query performance by 80 percent.

Listen to the Podcast

Oracle Hybrid Columnar CompressionOracle Hybrid Columnar Compression, used in many of Oracle’sengineered systems, saves storage space and acceleratesperformance by utilizing a combination of row and columnarcompression formats. For example, Oracle ZFS StorageAppliance and Oracle’s Pillar Axiom storage systems use OracleHybrid Columnar Compression to enable tighter integration withOracle Database. Oracle Advanced Compression and OracleHybrid Columnar Compression can be used together to ensureall database data can be managed cost-effectively with typicalcompression ratios from 3x to 15x.

22

See how much you cansave with Oracle Database12c compressiontechnologies.

23



Maximize Database Storage Efficiency withAutomatic Data Optimization

Maximize storage utilization, reduce costs, andimprove performance automatically.

Automate storage compression and storage tieringwith the Heat Map and Automatic Data Optimizationfeatures in Oracle Database 12c.

Reduce storage requirements by 50 percent or morewhile improving query performance.

Oracle Advanced Compression AdvisorOracle Advanced Compression Advisor is a free tool includedwith Oracle Database that provides you with an estimate of thecompression ratio you’ll realize when you use Oracle AdvancedCompression. Oracle Advanced Compression Advisor analyzessample data you provide to estimate the actual results you’ll seewhen you use OLTP table compression in your environment.

24



Respond Decisively to ThreatsInsecure database configurations can make corporate datasusceptible to intrusion. Attacks can come from many places,including socially engineered e-mails, legitimate user credentials,and SQL injections designed to modify or extract sensitiveinformation from corporate databases.

It’s not just external thieves and malcontents you need to worryabout. The 2013 IOUG Enterprise Data Security Survey foundthat the #1 risk to organizations, for the second year in a row, ishuman error. Internal system administrators and DBAs are anever-present security risk based on their ability to accesssensitive information and configure systems, modify databases,and grant privileges to others. In some cases, importantproduction data moves through dev/test environments where anydeveloper can see it.

The stakes have never been higher: security and data breachesrepresent billions of dollars in lost business. They often requiretedious and expensive remediation and can cause irreparabledamage to your corporate reputation, eroding customer confidence.

Adopt a Comprehensive Defense-in-Depth StrategyOracle Database 12c was designed with security foremost inmind. It enforces a multilayered security strategy that includespreventive, detective, and administrative controls. Newcapabilities such as privilege analysis, conditional auditing, realapplication security, data redaction, mandatory realms, andintegration with Oracle Multitenant make Oracle Database 12cthe most secure database in Oracle history. And simplified setupprocedures let you take advantage of advanced technologies forencryption, auditing, and access control—without impacting yourbusiness operations.

SquareTwo Financial has a defense-in-depth strategy thatincludes Oracle Audit Vault and Database Firewall, OracleAdvanced Security with transparent data encryption, and OracleData Masking Pack. This multifaceted approach protects data atrest, during testing and development, and during productionactivity.

26

Is your data secure? TakeOracle's Enterprise DataSecurity Assessment tofind out.

27



Enable a Defense-in-Depth Strategy forMaximum Security

Protect your mission-critical business informationinternally and externally with new features such asData Redaction in Oracle Advanced Security.

Ensure regulatory compliance while protectingagainst threats and ensuring privacy.

Take advantage of advanced technologies forencryption, auditing, and access control.

Video: “Since weimplemented Oracle DataMasking Pack we wentfrom a 15-day refresh timeto a 15-hour refresh timeon our 3 TB databaseenvironment.”

J.T. Gaietto, Manager ofInformation Security,SquareTwo Financial


28



Database technology is fundamental to business operations.Whether it’s booking orders or predicting equipment failures,enterprises rely on up-to-the-second information to make sounddecisions. A single outage can have devastating consequences,potentially causing millions of dollars in losses and irreparabledamage to a company’s reputation. The growth in mission-criticalinformation is further driving the need for highly availabledatabase solutions to ensure continuous access to applicationsduring any unplanned or planned outage.

Oracle Database high-availability (HA) technologies, collectivelyreferred to as Oracle Maximum Availability Architecture, providecomplete resiliency against all types of outages—fromcomponent failures to natural disasters. Industry-leading OracleHA technology such as Oracle Real Application Clusters (OracleRAC) provides the highest levels of server HA while OracleActive Data Guard protects data and applications againstsitewide outages. Oracle GoldenGate lets you perform a varietyof planned activities online, including upgrades, databaseconsolidation, and cross-platform migrations.

Eliminate the Trade-Off Between Performanceand Availability

New capabilities in Oracle Database 12c help businesses delivereven higher levels of availability and data protection for criticaldatabases—enabling zero data loss and zero downtime.

Replicating data synchronously to a standby site is the bestprotection against data loss in the event of a primary site outage.However, this usually means slower database performance,especially when your primary and standby sites are on differentsides of the continent—or on different continents altogether.Oracle eliminates this trade-off between performance and dataprotection with the new Far Sync Instance feature in OracleActive Data Guard. Far Sync Instance lets you maintain asynchronized standby database at any location without worryingabout performance degradation. Not only can you eliminate anysingle point of failure, but you can also ensure zero-data-loss

30

Video Series: Ashish Ray:Maximum Availability withOracle Database 12c.

Ashish Ray, Vice Presidentof Product Management,Database, and ExadataHigh Availability, Oracle

Watch the Videos (9:26)

31



replication across any distance while optimizing databaseperformance.

Enable Application ContinuityHave you tried to order merchandise online, only to have ascreen time out on you or display a message asking you toresubmit your information? This means that a failure hasoccurred while the transaction was in progress, preventing it fromcompleting. Imagine what happens to your business whenhundreds or thousands of transactions are either lost orduplicated. The new Application Continuity feature in OracleDatabase 12c protects applications and minimizes userdisruption by automatically replaying “in-flight” transactions afteran outage has occurred. It enables continuous service andeffectively masks the outage from your end users andapplications.

Deliver Intelligent Workload BalancingOrganizations with geographically dispersed data centers oftenhave a hard time optimizing workloads for performance andavailability. Resources are often underutilized and service levelsmay not be met consistently. The new Global Data Servicesfeature in Oracle Database 12c enables you to simplifymanageability and better utilize replicated databases for disasterprotection or distributed HA. Global Data Services intelligently

balances workloads so you can make better use of your globaldatabase resources. It automatically fails over services acrossreplicated databases for higher availability and directs userconnections to the database that best optimizes service.

Eliminate Data Loss and Backup OverheadExponential data growth, shrinking backup windows, unexpectedoutages, and data loss continue to plague database backup andrecovery operations, consuming production resources andincreasing IT complexity. Oracle’s Zero Data Loss RecoveryAppliance (Recovery Appliance) is a revolutionary newengineered system specifically designed to protect Oracledatabases. It delivers zero to sub-second data loss protectionwith minimal impact on your production database servers andusers. It also provides incremental backups that eliminatebackup windows and enable you to restore databases to anypoint in time. The Recovery Appliance scales to protect all yourdatabases—up to thousands—while offering end-to-endmanagement from a single interface.

32

Oracle MaximumAvailability Architecture(MAA)

Expand View

33



See Chapter 10, “Hardware and Software Engineered Together,”for more information on Oracle’s Zero Data Loss RecoveryAppliance.

Optimize Your HA Architecture with OracleEngineered SystemsOracle’s Maximum Availability Architecture (MAA) technologiescan be deployed on any server and storage platform running onany operating system. For optimal performance, scalability, andavailability, Oracle offers engineered systems specificallydesigned for Oracle Database and include many built-in MAAcapabilities. For example, Oracle Database Appliance combinesredundant server, storage, and networking resources within acompact enclosure that’s ideal for simplified, cost-effective OracleRAC deployment and management in midsize environments. Atthe other end of the spectrum, Oracle Exadata DatabaseMachine is engineered to be deployed rapidly and deliver theperformance, scalability, and availability required for the largestmission-critical Oracle databases.

Guarantee Uptime with Oracle MaximumAvailability Architecture

Achieve the highest availability at the lowest cost.

Deliver application continuity in the event ofany outage.

Implement zero-data-loss protection across anydistance without compromising performance.

Eliminate idle redundancy with the simplicity of anOracle-integrated HA solution.

Eliminate data loss exposure without impactingproduction environments.

See Chapter 10, “Hardware and Software Engineered Together,”for more information on Oracle Database Appliance and OracleExadata Database Machine.

Infographic: Zero DataLoss Recovery Appliance.

View the Infographic

34

Take the Oracle MaximumAvailability ArchitectureAssessment andUnderstand YourHigh-AvailabilityReadiness and Risks.

35



Database technology is also the foundation for enterprise datawarehousing systems that enable businesses to make fast andhigh-quality, data-driven decisions. In the era of big data,information is now being generated much more quickly than itcan be consumed. Meanwhile, leveraging information to makecomplete business decisions is becoming ever more critical toenterprises. All of these factors increase demand forcomprehensive data warehousing and big data solutions.

Oracle provides the industry’s leading data warehousing platformfor delivering business insights across a wide range of activities,from optimizing customer experiences to increasing operationalefficiency. Oracle’s high-performance and optimized solutionsprovide in-database advanced analytics and enhanced data setsfrom big data to drive increased innovation, profitability, andcompetitive advantage.

Better and Faster Decision-MakingQuickly discovering meaningful insight from high volumes ofinformation is a key challenge faced by organizations. OracleDatabase In-Memory enables better and faster businessdecision-making by accelerating database performance withoutrequiring changes to existing applications. Oracle DatabaseIn-Memory introduces a new compressed columnar format thatenables any subset of a database, including an individual tableor partition, to be loaded in-memory and queried instantly. Anyapplication that runs on Oracle Database 12c can automaticallyand transparently take advantage of faster query processingwhile retaining all the functionality of Oracle Database 12c.

Oracle simplifies the deployment of high-performance datawarehousing systems with Oracle Exadata—an engineeredsystem with unique performance optimizations for enablingbetter and faster decision-making. Oracle Exadata Smart Scantechnology accelerates queries by looking for data only where it’smost likely to be found. This makes nearly every query go fasterby cutting out unnecessary work. Oracle Exadata Smart FlashCache technology automatically moves data to faster storagetiers to optimize query performance. By intelligently cachingdata, it replaces magnetic disk operations with lower-latency,solid-state memory operations.

See Chapter 10, “Hardware and Software Engineered Together,”for more information on Oracle Exadata.

36 37



Maximum Analytical Return on DataHigher volumes of data generally translate into higher-qualityanalysis. Using Oracle’s information lifecycle managementtechnologies—such as advanced compression andpartitioning—data warehouses can be easily scaled to handlegreater volumes of data without compromising queryperformance. Automated segmentation of data by usage enableshot data to be migrated to high-performance storage, while colddata can be actively archived to lower-cost media. By intelligentlyleveraging information lifecycle management technologies,businesses can multiply the benefits of higher data volumeswithout multiplying the cost.

Data warehouse consolidation is often constrained by the need tomove data to alternative systems for analytics. Using Oraclein-database analytics, business analysts can perform statisticalanalysis, data mining, and geospatial analysis without moving

data out of the database. Analytical tools include data-miningalgorithms, native SQL functions for basic statistical activities,and integration with statistical programming languages like R.Because these techniques are applied directly within thedatabase, the costs and latencies associated with datamovement are entirely eliminated.

Automated information lifecycle management and in-databaseanalytics enable business analysts to achieve faster time toinsight and higher analytical return on data. Meanwhile, thecapital expense and management footprint for IT is simpler andmore efficient.

Enhance Relational Data Sets with Nonrelational DataMuch of the growth in data volumes comes from unstructuredand semistructured data sources like mobile devices, socialmedia, and sensors. To generate business value from big data,unstructured and semistructured data must be captured,

Video: Wm MorrisonSupermarkets PlcImproves Performance onExadata.

Jonathan Walsh, MISManager, William Morrison


38

Video: dunnhumbyIncreases CustomerLoyalty with Big Data.

Chris Wones, Director ofData Solutions, dunnhumby


39



filtered, analyzed, and organized from different sources. Then,data must be transformed and integrated with existing data setsand processes. Oracle Big Data Appliance and Oracle Big DataConnectors dramatically simplify the process of enhancingenterprise data sets with big data. Oracle’s big data solutionsinclude unique optimizations to accelerate Apache Hadoopprocessing and protect data from unauthorized access. UsingOracle’s big data solutions, enterprises can build an enterprisebig data management system that enables all data to becaptured and analyzed quickly, efficiently, and securely.

Video: Customers Discussthe Benefits of Oracle BigData Management.

Syed Rafice, SolutionArchitect, BAE SystemsDetica


40



Trouble-Free Migrations and UpgradesOracle provides multiple methods for upgrading or migrating yourexisting database assets to Oracle Database 12c. Advanceddeployment tools reduce downtime and minimize manual effort.All customers have a choice of upgrade paths and tools, andtechnology such as Oracle GoldenGate and Oracle Data Pumpmake it quick and easy to migrate data.

Whether you upgrade to Oracle Multitenant or stick with thetraditional architecture, upgrading your existing Oracle Databaseis a straightforward process. As InfoWorld reports, anadministrator can install a new copy of Oracle Database andthen, in a single operation, switch all the pointers to that newcopy on the root database—“...an operation that should take onlya few seconds.”

Article: “Upgrading the database software is1,000 times faster, because you are justupdating the metadata.”

Read the InfoWorld Article

Minimize MaintenanceConsolidation with Oracle Database 12c results in fewerdatabases to manage. The benefits permeate throughout thedata center: fewer patches and upgrades, fewer backups, andfewer standby databases to worry about. Oracle Multitenant isparticularly easy to manage because all the routine maintenanceactivities take place at the container level.

The Value of Oracle ServiceOracle Service can help you install and configure OracleDatabase 12c so you can get your database assets onlinequickly—and ensure optimal deployments and upgrades in the

Video: Oracle SeniorDirector Rod Swongerexplains how you canensure a successfulupgrade to OracleDatabase 12c, withminimal risk to youroperation.

Roy Swonger, SeniorDeveloper of SoftwareDevelopment, Oracle


42 43



Accelerate Deployments and Upgrades

Automate routine administrative tasks.

Simplify database consolidation.

Enable database as a service.

Reduce transformational risks with Oracle RealApplication Testing.

future. From refining your deployment strategy to ongoingsupport and education, Oracle Service helps you get the mostfrom your Oracle investments.

Complete support essentials: Enjoy 24/7 coverage forhardware and software to keep your Oracle systems reliable,available, and secure.

Migration and upgrade services: Accelerate adoption ofOracle Database with automated tools and product expertise.

Installation, configuration, and monitoring services: Learnbest practices for deploying, configuring, and monitoringOracle Database to achieve maximum availability.

Training: Give your staff the essential skills and expertisethey need to take full advantage of Oracle Database.

44


Chapter 9: Database Management

Innovations in database management took a leap forward withthe latest release of Oracle Database 12c and Oracle EnterpriseManager 12c. Together, they form one of the industry’s leadingdatabase management solutions—transforming the way youmanage your database.

Oracle Enterprise Manager 12c streamlines all aspects ofdatabase management, from testing and consolidation planningto lifecycle and quality-of-service management.

Boost Service Quality, Lower Risk

Manage application service levels from a singlepane of glass.

Accelerate DBaaS provisioning through aself-service environment.

Maximize quality with real-time proactiveperformance management.

Enforce compliance across the entireinformation lifecycle.

Managing Database as a ServiceDatabase as a service (DBaaS) architectures offer a variety ofbenefits to help you improve your operations and move morequickly to the cloud. Using Oracle Multitenant and OracleEnterprise Manager 12c ensures that you make the most ofthose benefits. Whether it’s accelerated provisioning orautomated consolidation, Oracle Enterprise Manager 12c speedsup the process of deploying DBaaS solutions.

Industry-Leading Database Self-ManageabilityOracle Enterprise Manager 12c is the only management solutionto offer complete support for Oracle Database 12c right out of thebox. Whether you want to take advantage of data redactioncapabilities or leverage the Heat Map feature, it’s all availablethrough Oracle Enterprise Manager 12c.

Video: Oracle SeniorDirector Jagan Athreyatalks about the nextevolution in databasemanagement.

Jagan Athreya, SeniorDirector of ProductManagement, Oracle


46 47



Why Oracle engineered systems?Oracle engineered systems simplify IT operations and lower yourcosts with extreme performance—accelerated deployments,high-speed processing, and lightning-fast analytics.

Extreme performance is about taking advantage of newopportunities, discovering new areas of efficiency, and enablinginnovation to deliver the kind of results and businessperformance that simply weren’t possible—until now.

Oracle Big Data Appliance: The Solution for Big Data

Oracle Exadata Database Machine: The FastestDatabase Machine for Data Warehousing and OnlineTransaction ProcessingOracle Exadata Database Machine is the first and only databasemachine that provides extreme performance for both datawarehousing and online transaction processing (OLTP)applications, and is an ideal platform for consolidating databaseworkloads in the cloud and in the data center.

With Oracle Big Data Appliance, extreme performance meansquickly getting real business value from your big data—rapidlyprovisioning a single system that’s scalable, highly available, andoptimized to transform massive amounts of data into usableinformation.

Video: Oracle EngineeredSystems Simplify IT byDelivering Hardware andSoftware Engineered toWork Together.


48

Video: Procter & GambleDrives 30x PerformanceGains with Exadata.

Procter & Gamblecompleted specific point-of-sale data queries up to30x faster, reducing IT costswith 15x the datacompression.


49



Oracle Database Appliance: Simply AmazingThe benefits of Oracle engineered systems aren’t limited to largeenterprises. With Oracle Database Appliance, midsizebusinesses—as well as department-level organizations—candramatically reduce the time, risk, and costs usually associatedwith deploying a high-availability database or solution in a box.You can deploy Oracle Database Appliance in a single operationbecause Oracle has completely automated the setup foryou—including all configurations for the clustered database.

Analyst Report: Time Savings and Ease ofDeployment Comparison Study: OracleDatabase Appliance vs. Microsoft SQLServer.Research by ORC International found thatDBAs could save 835 hours in the first year ofsystem implementation and 669 hours insubsequent years.

Read the Analyst Report

Zero Data Loss Recovery Appliance

Say NO to Data Loss and Data Protection Overhead

Today’s solutions for protecting business data are unable to meetall the needs of mission-critical databases. They fail to ensurethat data won’t be lost, that end users won’t be impacted, andthat deployments will be scalable yet centralized. Oracle’s ZeroData Loss Recovery Appliance (Recovery Appliance), theindustry’s first engineered system for database protection,addresses these challenges head-on. Designed to maximizeprotection for Oracle databases, the Recovery Applianceeliminates data loss without affecting production systems or endusers. The Recovery Appliance is built on a massively scalable,cloud-based architecture that lets you protect and centrallymanage all your databases enterprisewide.

"Enterprises need to protect vital datafor their critical business applications inreal time without the downtime or data

loss often experienced when using traditional approaches," saidLaura Dubois, Program Vice President for IDC's Storagepractice. "The Zero Data Loss Recovery Appliance meets thisdemand with a simple, yet powerful solution that easily scales toprotect databases enterprise-wide and meet ever-stringentrecovery point objectives."

Video: InfoSys DiscussesBenefits of Oracle Big DataAppliance.

Rajeev Nayar, AVP, InfoSysWatch the Video (1:50)

50 51


Chapter 11: Conclusion

More Than 35 Years of Continuous DatabaseInnovationOracle Database is the world’s #1 enterprise database—enablingmore than 300,000 customers to improve operational agility andpower the real-time enterprise. Oracle Database plugs into thecloud, accelerating the performance of applications, ensuringmaximum availability and optimized storage management, andconsolidating the management of hundreds of databases as one.

Over the years, Oracle has established a track record ofdelivering breakthrough advances in performance, scalability,high availability, data optimization, data security, and ease ofmanagement to support the most demanding OLTP, data

warehousing, and big data customer requirements. Priorreleases of Oracle Database have always been developed withcustomers’ IT and business requirements in mind, and thatphilosophy continues with Oracle Database 12c.

Plug into the Cloud by Downloading Oracle Database12c TodayIn the Oracle Database family of products, there’s an edition,option, or engineered system to fit all business needs, providingthe necessary foundation to successfully deliver moreinformation with a higher quality of service, and to efficientlymanage change within the environment to deliver better value.We invite you to learn more by downloading Oracle Database12c and experiencing it yourself.

Video: Oracle Powers 30Years of DatabaseInnovation.


52 53


Resources

Video: Andy MendelsohnTalks About Oracle Database12c Multitenant (0:25)

Video: Plug into the Cloudwith Oracle Database 12c(55:02)

White Paper: Plug into theCloud with Oracle Database12c

Video: How to Cut IT CostsWhile Improving Performance(1:58)

Webcast: Plug intoConsolidation

Infographic: OracleMultitenant

White Paper: Automatic DataOptimization with OracleDatabase 12c

Webcast: Oracle Database12c Storage Optimization

Innovation

Consolidation

Storage Management

Case Study: CSX ImprovesData Compression by 7x,Reduces Database StorageRequirements by 21%

White Paper: MaximizeAvailability with OracleDatabase 12c

Webcast Series: Plug intoMaximum Availability withOracle Database 12c

Website: Oracle DatabaseBackup Logging RecoveryAppliance

Video: Shedding Light onSecurity with OracleDatabase 12c (1:49)

Video: ComprehensiveSecurity with OracleDatabase 12c (5:11)

Webcast: Plug into Defense-in-Depth with OracleDatabase 12c

White Paper: Security andCompliance with OracleDatabase 12c

Website: Enterprise DataSecurity Assessment

Customer Success Story

Maximum Availability

Database Security

54 55


Resources

Video: T-Mobile Protects 35Million Subscribers withOracle Database Security(1:54)

Video: Diamond ResortsAddress Sarbanes-Oxley withOracle Audit Vault andDatabase Firewall (2:45)

Video: SquareTwo EnablesDevelopment Efficiency andCompliance with Oracle(2:29)

Video: TransUnion InteractiveUses Oracle DatabaseFirewall for Compliance(1:58)

Video: Customers Discussthe Benefits of Oracle BigData Management (0:57)

White Paper: OracleDatabase 12c for DataWarehousing and Big Data

Video: Upgrading to OracleDatabase 12c (8:30)

White Paper: Upgrading toOracle Database 12c

Report: Upgrading to OracleDatabase 12c

Featured Customer Videos

Data Warehousing and Big Data

Faster Deployment

Video: DatabaseManageability with OracleDatabase 12c (8:45)

Webcast: Managing OracleDatabase 12c with OracleEnterprise Manager 12c

White Paper: Manageabilitywith Oracle Database 12c

Website: Overview of OraclePremium Support

E-Book: Oracle PremierSupport: Get Ahead. StayAhead.

Video: Access OracleDatabase 12c Innovation withPremier Support (9:29)

Data Sheet: Oracle MigrationFactory

Data Sheet: Oracle DatabaseUpgrade Services

Video: Faster Migration forLess Cost with OracleMigration Factory (1:30)

Database Management

Services

Support Essentials

Migration and Upgrade Services

56 57


Resources

Website: Advanced CustomerServices Overview

Website: Oracle Database12c Training

E-Book: Oracle Exadata—Engineered for YourDatabase

Website: Your Guide toEngineered Systems

Brochure: Oracle DatabaseAppliance: A Fast, Powerful,and Affordable Solution-in-a-Box System

Data Sheet: Zero Data LossRecovery Appliance

Installation, Configuration, and Monitoring Services

Oracle Engineered Systems

Oracle Exadata

Oracle Big Data Appliance

Oracle Database Appliance

Zero Data Loss Recovery Appliance

Facebook LinkedIn

Twitter Google+

YouTube Blog

Website: Oracle Database12c Customer Videos andHighlights

Social Media

Summary

58 59


Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Oracle andJava are registered trademarks of Oracle and/or its affiliates. Other names maybe trademarks of their respective owners. Intel and Intel Xeon are trademarks orregistered trademarks of Intel Corporation. All SPARC trademarks are usedunder license and are trademarks or registered trademarks of SPARCInternational, Inc. AMD, Opteron, the AMD logo, and the AMD Opteron logo aretrademarks or registered trademarks of Advanced Micro Devices. UNIX is aregistered trademark of The Open Group.

oracle database 12c plug into the cloud e-book...oracle database 12c plug into the cloud chapter 2:...

Documents