Tuesday Aug 11, 2015

Oracle Database In-Memory Ease of Use and Instant Analytics Empowers SAP Customers

Oracle recently announced that Oracle Database 12c and Oracle Database In-Memory were now certified and supported by SAP for use with SAP Solutions. Our ongoing collaboration with SAP ensures the latest Oracle Database technology is always available to our joint customers.

The common need for instant analytics is pervasive, whether it’s a business running SAP applications with SAP BusinessObjects or an individual user searching for available tee times or hotel rooms. When we press the <ENTER> or <Search> key, we expect information instantly. With Oracle Database In-Memory, both IT and their end users can access analytics instantly. Below are two use cases illustrating how customers benefit from the speed and ease of adoption of Oracle Database In-Memory

Engineered for Ease of Adoption:

Oracle Database In-Memory is designed with ease of adoption in mind. No application changes or migration of data is required.

Swiss insurance leader, Die Mobiliar, chose the Oracle Database to be the strategic database after a series of mergers and acquisition. Important in the database decision were the impressive performance improvements that Oracle Database In-Memory offered to existing applications and the fact that no changes or fine-tuning were required to achieve these performance benefits. For example, one report that was running in 200 to 300 seconds now runs in just 1 second. The enabler for this is Oracle Database In-Memory’s unique dual-format architecture that allows for fast analytics together with high-performance OLTP. Data is processed at a rate of billions of rows per second rather than millions and allows analytics to run directly in OLTP databases to help provide reports in seconds rather than the traditional days or week’s manual efforts. Read more about Die Mobiliar use of Oracle Database In-Memory.

Designed for Speed & Cost Savings:

Shanghai Customs is a government agency for the General Administration of Customs in China. It oversees the surveillance and control of imports and exports through the Shanghai Free Trade Zone (SHFTZ). Shanghai Customs experienced rapid growth in SHFTZ’s customs activities due to the significant increase in re-export and off-shore trade and the expansion of customs duties and business rules. In response, they have used Oracle Database 12c, Oracle Database In-Memory, and Oracle TimesTen In-Memory Database to build a new customs-surveillance and control-information platform that ensures efficient logistics operations and supports future trade growth.

Oracle Database In-Memory’s dual-format architecture enables customers to automatically route OLTP transactions to the traditional row format and OLAP queries to Oracle’s new in-memory column format, expanding memory capacity and improving query performance. This approach helps to eliminate the need to copy analytical data out of the OLTP environment into a data warehouse thereby reducing system complexity and storage costs.

Oracle Times-Ten In-Memory Database further adds to speed and cost savings. By storing transactional and analytical data in Oracle Database 12c and managing this data with Oracle Database In-Memory and Oracle Times-Ten In-Memory Database in the application tier, customers can gain microsecond response times to accelerate data processing and achieve microseconds response times. Read more to see how Shanghai Customs Processes Clearance 43x Faster, Improves Declaration-Services Efficiency and Reduces Costs with Oracle In-Memory Database.

Stay tuned for more examples of customer use cases for Database In-Memory.

Thursday May 07, 2015

Why customers choose Oracle Cloud solutions for PaaS

On April 29th, Oracle Senior Vice President Shawn Price moderated a panel discussion where customers described their experience with Oracle Cloud solutions for SaaS, PaaS and IaaS. The PaaS customer panel included seven global customers from a variety of industries that described use cases for extending SaaS with PaaS, easily moving development and test environments to the cloud, and how to leverage the Internet of Things (IOT) with Big Data and Advanced Analytics. Many described their move to the cloud as the main driver to innovate faster to meet business demands with shrinking IT budgets.

Watch the PaaS Customer Panel to learn how JDSU, mFrontiers, Valdosta State University, Austrialian Financial Group, NetCompany, Surdell and Partners, and Knextech use Oracle Cloud Solutions for PaaS to combine agility, innovation and availability in the cloud.

Monday Mar 23, 2015

Oracle Database Innovation Forum FAQ

Just in case you missed it- Watch the Forum On-Demand!

The Oracle Database Innovation Forum that was broadcast on March 18th and is now available on-demand. Once you registered, stay as long as you like or return at your convenience to watch another session or replay one that's really made an impact. The forum, featuring Oracle Database guru Tom Kyte, was followed by Oracle Database Innovation experts and customers sharing best practices and the reasons why they chose Oracle Database 12c. The Forum keynote and following sessions provide a little something for everyone - from DBaaS and Multitenant and private clouds - to Big Data, Database In-Memory and Data Warehousing best practices. Sessions on Database Management and Advanced Security, High Availability, Storage Optimization and even best practices for upgrading to Oracle Database 12c are offered.

Forum FAQ

During the forum, we received so many great questions that I'll share only a few with you here. The questions we get most often concern licensing database options and comparing Enterprise Edition and Standard Edition features and option availability. A great resource to help you  understand the Oracle Database options can be found in this 'family' white paper

Here are three questions we received about Oracle Multitenant:

Q: How does a Multitenant architecture differ from a traditional SQLSERVER instance based architecture?

A: In that Microsoft SQL Server supports multiple "databases" within a single server, while Oracle Multitenant supports multiple Pluggable Databases (PDBs) within a single Container Database (CDB), there is a superficial similarity between the two. There are some important differences, however, Microsoft SQL Server users are defined at server level, so there's imperfect namespace isolation, which makes it less suitable for Database as a Service (DBaaS). SQL Server Databases are difficult to move between servers. By contrast the pluggable portability of Pluggable Databases (PDBs) allows for a great range of flexibility.

Q: We are already using OVM for consolidation - what does Multitenant give us over that?

A: OVM is good for infrastructure consolidation. Multitentant is specifically designed for databsase consolidation - much higher consolidation density, simpler management as you can now manage many databases as one. You could still use MT for further consolidation benefits on top of OVM.

Q: Do you have any guidance regarding capacity/resource sizing of multitenant database?

A: This is highly dependent on the loads being consolidated. The savings are proportional to the numbers of databases consolidated. Rough rules of thumb for minimal savings are about 1.5GB per database and maybe 1/3 core for databases under load. On top of that, you might expect greater savings because of the ability to share "peaks and troughs" in load. In terms of storage, snapshot clones facilitate huge savings in storage and IOPS. Don't forget the operational savings because of the ability to manage many databases as one.

Three questions we received about Oracle Database In-Memory:

Q: How is In-Memory enabled?

A: Database In-Memory is enabled by setting the initialization parameter inmemory_size > 0.

Q: Does Oracle Database 12c using in-memory capabilities by default, or does the DBA need to configure?

A: Oracle Database 12c does not enable Database In-Memory by default. To enable Oracle Database In-Memory the inmemory_size initialization parameter must be set to a value greater than zero. You then need to alter one or more tables, partitions, sub-partitions or materialized veiws to be populated into the IM column store. The Oracle optimizer can then transparently make use of the IM column store.

Q: Does Database In-memory have a hardware dependency like some specific quality of RAM?

A: No, Database In-Memory can run on any hardware platform supported for Oracle Database 12c. You do have to have enough memory to support the In-Memory column store in addition to the other components in the SGA though.

Three questions about Automatic Data Optimization:

Q: Are indexes automatically maintained during the ILM compression (alter table move partition update indexes)?

A: Yes, indexes are automatically maintained when applying a compression policy.

Q: Why not always compress to the highest level that saves I/O?

A: You make the decision based on the type of data. Archive data, that is accessed less frequently, should be compressed at the highest rate. Read more about Oracle Automatic Data Optimization

Q: Is Automatic Data Optimization available on all servers or only on Oracle Exadata?

A: ADO is what can be achieved with a combination of database storage optimization technologies used on any hardware. Of course we optimize engineered systems for the Oracle Database so we think there are some great advantages over commodity hardware infrastructures that you build yourself.

Here's the complete FAQ.

Friday Mar 06, 2015

Tap into Tom Kyte's Expertise at the Oracle Database Innovation Online Forum

As if having Tom Kyte kick off the Oracle Database Innovation Forum online March 18th weren't enough, there are ten additional reasons for you to attend. Oracle Database experts and customers will talk about Database as a Service and Oracle Multitenant in public and private cloud deployments, Big Data, Oracle Database In-Memory and data warehousing best practices, Database Security, High Availability, Storage Optimization and best practices for upgrading and managing Oracle Database 12c.

Tom Kyte will provide a closer look at the innovations and top reasons customers are moving to Oracle Database 12c.  Attend the Oracle Database Innovation Online Forum - March 18.

Image result for tom kyteRegister today!

Monday Jul 28, 2014

Oracle Multitenant in Minutes Workshop

Oracle Database 12c give you the ability to plug into a multitenant architecture that combines ease, power, and flexibility. This workshop is your opportunity to learn how Oracle Multitenant will enable your organization to simplify database consolidation, manage many databases as one, and enable your organization to adopt private a Database-as-a-Service (DBaaS) model.

Join Oracle Experts in a city near you for this half-day event for database administrators, system administrators and other IT professionals where we'll dive deeper into Oracle Multitenant option along with some hands on exercises and demonstrations.

You'll experience first-hand how this database innovation allows you to save time and effort by accomplishing a number of tasks in just minutes. It also simplifies the way in which your organization can achieve high availability and protection against data loss. Oracle Multitenant works seamlessly with Oracle Real Application Clusters, Active Data Guard, and Golden Gate. Together they can deliver Oracle Maximum Availability Architecture best practices that provide the high availability required for consolidating business-critical databases or implementing a multitenant architecture for public or private clouds.

Register for an Oracle Multitenant Workshop in city near you today.

Tuesday Jul 22, 2014

Database In-Memory is Generally Available

Oracle Database 12c’s newest patch release, including Oracle Database In-Memory is generally available today.  Upgrade to Oracle Database 12c today to plug into the cloud and power the real-time enterprise![Read More]

Wednesday May 14, 2014

Join Oracle Database Storage Experts and Verizon Wireless on May 21 at IOUG Storage Event

IOUG will host an Oracle Database Storage Event on May 21, 2014 from 9am-1pm Pacific Time.

Oracle experts and Verizon Wireless will share Oracle Database Storage best practices and real life experiences. You will learn:

• How to increase Oracle Database performance and storage efficiency
• Why you should consider Oracle ZFS Storage Appliance ZS3 Series in Oracle Database Environments
• Details on Verizon's real-life success with an Oracle on Oracle implementation

More details can be found here. Don't forget to register!

Thursday Apr 17, 2014

Compression Advisor estimates compression ratio possible with Oracle Advanced Compression

What if you could estimate the compression ratio in your database environment to see how much Oracle Advanced Compression can reduce your storage footprint before you consider adding more storage?

If the biggest challenge facing your organization is managing data growth cost effectively, you'll need a better strategy for managing your database storage environment that doesn't involve throwing more storage hardware or administration at the problem.

With Compression Advisor, a FREE database tool from Oracle, you can use your real data to estimate the compression results you could realize when you deploy Oracle Advanced Compression Option in your database environment.

Find instructions for using Compression Advisor when you watch this quick overview about Oracle Advanced Compression. The Compression Advisor Package DBMS_COMPRESSION is included with Oracle Database 12c.

Monday Apr 14, 2014

Business Opportunities with Oracle In-Database Analytics

Data-driven organizations across all industries adopt data warehousing and big data solutions to enable fast, high quality analytical decision-making.  Data scientists and other specialized analytical knowledge workers are getting a lot of buzz in the industry due to the increasing popularity of advanced analytical methods like data mining and geospatial analysis. Oracle helps data-driven organizations simplify and accelerate the delivery of advanced analytics through its industry-leading data warehousing and big data solutions by embedding analytical capabilities in the Oracle Database platform. In-database analytics enables advanced analysis against large datasets with little or no movement of data from one system to another. Whether revenue growth, cost savings, or risk mitigation, Oracle in-database analytics simplifies and accelerates the delivery of advanced analytics for data-driven organizations.  Read more here.[Read More]

Friday Apr 11, 2014

How do you manage data growth in your Oracle Environment?

In many organizations today, the amount of additional storage hardware purchased each year in response to data growth shows no sign of slowing down. Regulatory requirements have changed how and why organizations are required to store more information for longer periods of time. Simply adding more storage isn't a cost effective approach against real world budget restrictions or when its impact on user response times and application performance takes a nose dive.

Nearly 40% of the respondents from a recent IOUG survey indicate that reducing costs was their primary reason behind implementing a tiered storage approach in their Oracle Database environment. But even with the right storage and compression capabilities, deciding which data should reside where and when to migrate data from one storage tier to another remains a real world challenge.

Forward-looking IT organizations are adopting advanced strategies for managing data growth using innovative database technologies that automate compression and storage tiering while improving database performance.

Oracle Database 12c provides new features and options that optimize database storage and work together to help you implement an Information Lifecycle Management (ILM) solution in order to  manage data growth cost effectively and comply with new regulatory requirements for data retention and protection.

Register for an IOUG Webcast on Tuesday April 15th, to hear Kevin Jerigan from Oracle describe Oracle Database 12c Storage Optimization features and Oracle Intelligent Storage Protocol.

Friday Mar 28, 2014

How to migrate from Microsoft SQL Server to an Oracle Database 12c centralized environment with ODP.NET

Recently the Federal Tax Service of Russia migrated from their Microsoft SQL Server environment to an Oracle Database 12c centralized environment with the help of ODP.NET.

The Federal Tax Ministry of Russia is a national government agency located in Moscow. It operates nine regional offices that oversee major taxpayers with a wide network of local offices that employ 140,000 people.The ministry is in the process of migrating from Microsoft SQL Server to Oracle Database 12c technology and Exadata. Its goal is to centralize all fiscal data access, improve performance, and reduce storage costs, while continuing to keep its investment in a Microsoft .NET infrastructure.

Oracle Database 12c makes developing and deploying Oracle on Windows and .NET easier, faster, and more cost-effectiveBy using Oracle’s .NET components (ODP.NET), the tax ministry can adopt new Oracle Database 12c features for their .NET applications. The migration to Oracle so far is meeting their goal for centralized data access and provides 20x better performance with a tenfold reduction in storage costs.

Listen to this Database Insider Podcast Interview for more details about their migration from Microsoft SQL Server to Oracle Database 12c.

Friday Mar 21, 2014

Need best practices for deploying JD Edwards EnterpriseOne on Oracle Database Appliance?

What do you get when you combine the advantages of Oracle Database Appliance with JD Edwards EnterpriseOne?

You get an ERP solution-in-a-box running on a complete Oracle technology stack that delivers high availability database and application services, efficiently utilizes system resources, provides performance advantages associated with Oracle’s Engineered Systems, and takes advantage of capacity-on-demand licensing for multiple workloads by leveraging Oracle VM hard partitioning.

This best practices white paper explains how to deploying JD Edwards EnterpriseOne on Oracle Database Appliance

Oracle Database Appliance is a simple, reliable, and affordable Engineered System from Oracle. It saves you time and money by simplifying deployment, maintenance, and support of high availability database solutions. Oracle Database Appliance Virtualized Platform, based on Oracle VM, enables customers to quickly deploy both database and application workloads in a single virtualized appliance platform.

Through virtualization, the benefits of simplifying deployment, maintenance, and support of high availability database solutions are extended to the application tier to provide customers a comprehensive solution-in-a-box

WP: Solution-in-a-box: Best practices for deploying JD Edwards EnterpriseOne on Oracle Database Appliance

Thursday Mar 13, 2014

Tom Kyte writes about Oracle Database 12c Multitenant Option in Oracle Magazine

In the March issue of Oracle Magazine, Tom Kyte discusses Oracle Database 12c Multitenant option with Patrick Wheeler, Oracle Sr. Director of Product Management.

This exchange between two Oracle Experts explains how Oracle Multitenant option can save customers capital expenses by consolidating more applications per server and reducing operating expenses. 

Companies face enormous pressure to consolidate - to reduce floor space, power costs, and license costs and at the same time to realize the benefits of cloud computing and cloud-based agility, including rapid, low-cost self-service provisioning and delivery of standardized services. Its no longer a question of whether to consolidate but how to consolidate.

Oracle Multitenant is a new option for Oracle Database 12c that provides a multitenant architecture for consolidating databases and simplifying operations in the cloud.

You'll find more articles on Oracle Database 12c written by Tom Kyte in past issues of Oracle Magazine.

Friday Mar 07, 2014

Data warehousing leaders gather in Nice, France to discuss best practices

Data warehousing and big data is hotter than ever and Oracle’s Data Warehouse Global Leaders recently gathered in Nice, France to discuss recent data warehousing trends in their respective companies.  Read more here to learn about some of the best practices and success stories shared.   For more information about the Data Warehouse Global Leaders program, check out: http://www.oracle.com/technetwork/database/bi-datawarehousing/oracle-dw-global-leaders-brochure-345526.pdf[Read More]

Friday Feb 28, 2014

Database as a Service Minnesota Style

This is a great story that's worth repeating of how the University of Minnesota began offering database as a service a few years ago as a way of providing database services to the University’s colleges, departments, and administrative offices.

In typical Minnesota style, the University of Minnesota was way out in front of the DBaaS trend. The school's database sprawl was becoming more difficult to maintain and manage with 215 databases running on 40 servers, and requiring the equivalent of four to five full-time DBAs to manage it all.

The University's IT team decided to consolidate and centralize databases on two Oracle Exadata Database Machines -one for production workloads and the other for testing and development, reducing the number of databases from 215 to 25, and servers from 40 to 8. 

As part of the consolidation initiative, the University began offering DBaaS to support their business applications on campus which included Oracle PeopleSoft for HR, financial management, administration-and Web sites. When new business needs arise at the University, they can satisfy the requirements almost immediately with database as a service, rather than go through a time consuming database acquisition and deployment process one project at a time.

As an early adoptor if DBaaS, the University is evaluating Oracle Database 12c as the potential next step with its multitenant architecture and pluggable databases, making it even easier to offer database services.



« October 2015