Thursday Oct 31, 2013

Engineering as a Service

Oracle Exadata Database Machine is known for great compute performance, and over the past few years, it has also become known as a great platform for any type of Oracle Database workload, from data warehousing to online transaction processing (OLTP). But now organizations are turning to Oracle Exadata for business efficiencies and private cloud solutions—for consolidation and database as a service (DBaaS).

University of Minnesota

For an inside look at how DBaaS is working in the real world, it’s worth checking into the University of Minnesota’s database hotel.  With more than 50,000 students, the University of Minnesota in Minneapolis is one of the largest universities in the United States. The university’s centralized IT group not only has to support all those students but also must provide support and services to more than 40 departments and colleges within the university.

They have two Exadata Database Machine X2-2 half-rack systems from Oracle, with four database nodes each and roughly 30 terabytes of usable disk space for each of the Oracle Exadata systems. The university is using Oracle Real Application Clusters (Oracle RAC) for high availability and the Data Guard feature of Oracle Database, Enterprise Edition, for disaster recovery capabilities. The deployment has been live in production since May 2011.

Overhead Door

When it comes to overhead, revolving, sliding, or other specialty residential and commercial doors, Overhead Door is the worldwide leader. But when they needed to open doors with their customers through a better, faster, and more agile IT infrastructure, Overhead Door turned to Oracle and Oracle Exadata.

Oracle Exadata Database Machine plays an important part in Overhead Door’s IT and business strategy. The organization has two Exadata Database Machine X2-2s deployed, one in production and one in development and testing

Read the full Oracle Magazine article Engineering as a Service

Tuesday Oct 22, 2013

Top Questions and Answers for Pluging into Oracle Database as a Service

On Monday, October 21st we hosted an online forum that shared a comprehensive path to help your organization design, deploy, and deliver a Database as a Service cloud.

If you missed the online forum, you can watch it on demand by registering here.

We received numerous questions.  Below are highlights of the most informative:

DBaaS requires a lengthy and careful design efforts. What is the minimum requirements of setting up a scaled-down environment and test it out?

You should have an OEM 12c environment for DBaaS administration and then a target database deployment platform that has the key characteristics of what your production environment will look like. This could be a single server or it could be a small pool of hosts if your production DBaaS will be larger and you want to test a more robust / real world configuration with Zones and Pools or DR capabilities for example.

How does this benefit companies having their own data center?

This allows companies to transform their internal IT to a service delivery model for the database. The benefits to the company are significant cost savings, improved business agility and reduced risk. The benefits to the consumers (internal) of services if much fast provisioning, and response to change in business requirements.

From a deployment perspective, is DBaaS's job solely DBA's job?

The best deployment model enables the DBA (or end-user) to control the entire process. All resources required to deploy the service are pre-provisioned, and there are no external dependencies (on network, storage, sysadmins teams). The service is created either via a self-service portal or by the DBA.

The purpose of self service seems to be that the end user does not rely on the DBA. I just need to give him a template. He decides how much AMM he needs. Why shall I set it one by one. That doesn't seem to be the purpose of self service.

Most customers we have worked with define a standardized service catalog, with a few (2 to 5) different classes of service. For each of these classes, there is a pre-defined deployment template, and the user has the ability to select from some pre-defined service sizes. The administrator only has to create this catalog once. Each user then simply selects from the options offered in the catalog. 

Looking at DBaaS service definition, it seems to be no different from a service definition provided by a well defined DBA team. Why do you attribute it to DBaaS?

There are a couple of perspectives. First, some organizations might already be operating with a high level of standardization and a higher level of maturity from an ITIL or Service Management perspective. Their journey to DBaaS could be shorter and their Service Definition will evolve less but they still might need to add capabilities such as Self Service and Metering/Chargeback. Other organizations are still operating in highly siloed environments with little automation and their formal Service Definition (if they have one) will be a lot less mature today. Therefore their future state DBaaS will look a lot different from their current state, as will their Service Definition.

How database as a service impact or help with "Click to Compute" or deploying "Database in cloud infrastructure"

DBaaS enables Click to Compute. Oracle DBaaS can be implemented using three architecture models: Oracle Multitenant 12c, native consolidation using Oracle Database and consolidation using virtualization in infrastructure cloud. As Deploy session showed, you get higher consolidating density and efficiency using Multitenant and higher isolation using infrastructure cloud. Depending upon your business needs, DBaaS can be implemented using any of these models.

How exactly is the DBaaS different from the traditional db? Storage/OS/DB all together to 'transparently' provide service to applications? Will there be across-databases access by application/user.

Some key differences are: 1) The services run on a shared platform. 2) The services can be rapidly provisioned (< 15 minutes). 3) The services are dynamic and can be relocated, grown, shrunk as needed to meet business needs without disruption and rapidly. 4) The user is able to provision the services directly from a standardized service catalog..

With 24x7x365 databases its difficult to find off peak hrs to do basic admin tasks such as gathering stats, running backups, batch jobs. How does pluggable database handle this and different needs/patching downtime of apps databases might be serving?

You can gather stats in Oracle Multitenant the same way you had been in regular databases. Regarding patching/upgrading, Oracle Multitenant makes patch/upgrade very efficient in that you can pre-provision a new version/patched multitenant db in a different ORACLE_HOME and then unplug a PDB from its CDB and plug it into the newer/patched CDB in seconds. 

Thanks for all the great questions!  If you'd like to learn more and missed the online forum, you can watch it on demand here.

Wednesday Oct 16, 2013

Oracle Database Insider Newsletter

Keep up to date on what is happening for Oracle Database.  Our newsletter has the lastest news, technical tips, upcoming events in the industry, customer success stories and much more. 

Our October issue recaps Oracle Database at Oracle OpenWorld 2013 as well as all the buzz on Oracle Database 12c.

Monday Oct 14, 2013

Register for the Oct 21st Database as a Service Forum

Register NowRegister Now

Join us for this online forum.

Monday, October 21, 2013
9 a.m.–12 p.m PT /
12 p.m.–3 p.m. ET

Enterprise IT is under increasing pressure to deliver better services to the business faster, at lower cost, and with higher quality of service. Now, there’s a new page in the CIO playbook—delivering enterprise database as a service (DBaaS).

Join this online forum to hear from analysts and experts on how companies are beginning to transform with DBaaS, and learn the prescriptive steps your organization can take to design, deploy, and deliver DBaaS today.

Event Highlights:

Keynote: “Hear from the Experts”
Hear innovators from leading organizations discuss how private cloud DBaaS is transforming the way IT departments work. The discussion encompasses a broad range of deployments including DBaaS in private clouds, community clouds and in cloud service provider portfolios.

Session 1: “Design: Increase Agility”
Discover how to design and architect a database as a service environment that will shift your organization from administering a heterogeneous set of silos to an agile and flexible database cloud.

Session 2: “Deploy: Improve Service Levels”
Get educated on how Oracle offers a complete solution for deploying a database as a service that delivers on a broad range of requirements such as simplified database consolidation, mission-critical deployments, and extreme scalability.

Session 3: “Deliver: Faster Service Provisioning, Lower Costs”
Learn how Oracle Enterprise Manager 12c provides the right tools to get you started and guides you through the entire lifecycle of managing DBaaS from planning to self-service to metering and chargeback and on-going operations management.

Closing Session: “The DBAs Speak Out”
Hear Michelle Malcher, president of the Independent Oracle Users Group, discuss the increasing importance of database as a service.

Register now for the forum.

Wednesday Oct 09, 2013

Oracle Multitenant Self-Service

Oracle Database 12c Multitenant Applications

Multitenant Self-Service Provisioning - BETA

The Oracle Multitenant Self-Service Provisioning system provides an interface to Oracle Database 12c Multitenant and allows for the self-service provisioning of Pluggable Databases (PDBs). Its primary goal is to encourage learning about PDBs in development / test environments. It is an easy and productive way to allow DBAs and Developers the opportunity to familiarize themselves and gain hands-on experience with powerful PDB features including create, clone, plug, and unplug.

Download it today!

Tuesday Oct 01, 2013

Wellcome Trust Sanger Institute describes how Oracle Database 12c features ease managability of multi-terabyte database systems

I had the pleasure of speaking with Karen Ambrose, Principle Database Administrator of Wellcome Trust Sanger Institute last week at Oracle Open World. She described for me how the Institute's green initiative and data growth predictions have them researching ways to automate their data archiving processes. Listen to the interview and learn how Oracle Database 12c Storage Optimization features with Heat Map and Automatic Data Optimization ease the manageability of multi-terabyte database systems, enhance storage usability, and reduce the time and effort spent enhancing performance.



  • Oracle
« October 2013 »