Monday May 04, 2015

Oracle Database 12c as a JSON Document Store

Today we are enabling developers to build applications in a new way against the Oracle Database: developers can build document-centric applications directly against an Oracle Database.

Popularized by "NoSQL Document Stores", these applications store data as documents (typically encoded as JSON) rather than normalized relational tables, and retrieve and query data using simple API's focused on accessing entire documents rather than relying on SQL. The appeal of a document model is that it is a natural fit for many application developers -- the 'documents' stored in the database closely correspond to objects in the applications, and the API's used to access documents are more natural for application developers than SQL-based API's. The other benefit attributed to a document model is that the document-based applications are 'schema-less'; that is, the developers do not need to keep a database schema synchronized with their application objects, and new attributes and fields can be easily added by the developers without the involvement of a database administrator.

The foundation for this new capability was laid in Oracle Database 12.1.0.2, which provides supports for storing, indexing and querying JSON documents in the database. But the picture is completed with the release of Oracle REST Data Services 3.0 -- which delivers now document-centric API's for accessing JSON documents.

Oracle Database now provides the same developer experience as NoSQL Document Stores with simple document-centric storage and access methods -- but Oracle does much more:
ACID transactions over JSON documents

  • Full SQL access to JSON documents, providing scalable reporting and analytics for document-store applications as well as simple integration between JSON documents, relational data, and other data types.
  • And, of course, with JSON documents fully embedded in the Oracle Database, document-store applications can also realize all of the benefits of Oracle Database's enterprise-level availability, scalability security, and manageability.

For more information, please see:

Wednesday Apr 22, 2015

REPRIVE: Oracle OpenWorld 2015 Call for Proposals is Open

DEADLINE Extended to 5/6!

Cloud, DBaaS, Big Data, Consolidation, In-Memory, App Development, Upgrades, Coolest Features

Calling all DBAs, Developers, Architects, Database Experts! Conference attendees want to hear it straight from you!

Don’t wait—proposals must be submitted soon!




Thursday Apr 02, 2015

Oracle Database 12c Now Certified By SAP!

With database innovation being at the heart of the real-time enterprise, our partners are recognizing the importance of moving to the latest version of Oracle Database.

All SAP products based on SAP NetWeaver 7.x, including SAP Business Suite 7, are now certified and supported on Oracle Database 12c. SAP customers can now use Oracle Database 12c, Grid Infrastructure 12c, Real Application Clusters 12c, Advanced Compression, Active Data Guard Far Sync, ACFS on Exadata, online Partition capabilities and more. SAP also certified Exadata X5 in January.

“The recent certification of Oracle Database 12c by SAP is a testament to Oracle and SAP's ongoing commitment to our mutual customers,” said Andy Mendelsohn, executive vice president, Database Server Technologies, Oracle.  “Oracle Database 12c features numerous important innovations that help customers fulfill the most demanding online transaction processing (OLTP), data warehousing, and big data requirements and remains the reliable, secure, and high performance choice for SAP customers.”

Industry Analysts Concur

@holgermu

MyPOV - The fact that @SAP certified @Oracle #12c on a practical V1 (usually V2) is a sign of demand and quality of 12c. #DBsMatter

 

@TonyBaer 

I've been getting pinged about this all day scn.sap.com/community/orac… Evidently SAP ain't waiting for v2 of Oracle 12c DBMS to certify its apps

Learn More

Read more about Oracle Database 12c for SAP and learn why it’s the #1 database of choice for SAP application deployments.


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!


Tuesday Feb 10, 2015

Are you ready for cloud computing?

How do you database?

In-Memory? Multitenant? Security? Big Data? HA?

At our March 18, 2015 Oracle Database Innovation Forum, you’ll discover the benefits of mission critical performance, availability, data security, and lower cost savings with the world's most innovative database, Oracle Database 12c.

Register today to join Tom Kyte, Maria Colgan and other Oracle Database 12c product gurus!


Wednesday Feb 04, 2015

Five best practices for PaaS [Platform as a Service]


In the Fall of 2014, ComputerWorld published a report detailing the results from a survey conducted with 300 IT executives and practitioners worldwide. The questions ranged from type of applications being run on the cloud now and in the future, support for mission-critical apps, the challenges faced from an interoperability perspective, and more. The results highlighted some critical insights from these experts which for certain topics were surprisingly significantly aligned. Calling this phenomena [this alignment] the wisdom of the crowd, we bet that as the industry moves forward with the cloud initiative, IT leaders worldwide are increasingly adopting these practices, driving these to become best practices. Hence our attempt at culling these and putting these within an infographic, so its easily available at a birds eye view level to IT practitioners undertaking their cloud journey right now.

Check out this infographic

For further details, refer to the the ComputerWorld Survey report


Wednesday Jan 14, 2015

Coming Feb 11, 2015 Oracle Technology Network (OTN) Virtual Technology Summit: Free Hands-On Learning with Oracle and Community Experts

Learn to master Oracle Database 12c to meet today’s IT challenges from Oracle ACEs and Oracle Product Experts.

Database Developers can explore two tracks in this session:

  • Database upgrade strategies and techniques
  • New tools, APEX 5.0, new capabilities of current tools, PL/SQL tricks and tips and JSON for enterprise application development
Register now and serve your spot today! 

Friday Dec 19, 2014

Oracle Maximum Availability Architecture Blog

Check out the Maximum Availability Architecture blog for the latest on Oracle Database high availability and data protection offerings, best practices and technology strategy. Oracle Maximum Availability Architecture (MAA) enables organizations to address all types of unplanned and planned outages - from component failures to region-wide disasters to planned maintenance, upgrades and migrations. These blog postings are created and maintained by members of Oracle’s Maximum Availability Architecture team within Oracle’s Server Technology Development group and the Oracle Database HA product marketing team. The MAA team interacts with Oracle’s customers around the world on various critical high availability (HA) initiatives. Our goal is to enrich the Oracle ecosystem with an interesting, informative and interactive conversation around Oracle MAA.

Recent updates to the MAA blog include the following topics:

Maximum Availability Architecture

Data Protection

High Availability

Please refer to the MAA website on OTN - http://www.oracle.com/goto/maa, for the latest collection of best practices for Oracle MAA.

Tuesday Dec 09, 2014

How Do You Database?

No matter what your solution need, we've got you covered with continuous innovation!

So HOW do you database?

  • Multitenant to consolidate?
  • Implement Database as a Server to provision standardized database environment?
  • Keep your business online 24x7 with high availability?
  • Safeguard to ensure privacy and compliance via top-notch security?
  • Access to all your information with big data?

Check out the #1 product in the market - Oracle Database 12c - today!

#1

Thursday Dec 04, 2014

You + #C15LV = Love.

Tell IOUG why you love COLLABORATE 15 & Get Your Chance to Win One of Three Free Registrations!

Enter by 12/12

Good Luck! 

Monday Nov 10, 2014

Turbocharge Your PL/SQL Code

Get ready to boost the performance of your multi-row SQL statements executed from within a PL/SQL!

ODTUG is hosting a Nov 13th webcast with Oracle architect and PL/SQL guru, Steven Feuerstein. 

Plan to join Steven to discover how FORALL and BULK COLLECT features can turbocharge your code for optimal performance gains.

Register today!



Wednesday Oct 22, 2014

Up you database skill level!

Learn Oracle with the new Oracle Database 12c Release 1 training series.

Tuesday Oct 21, 2014

October Database Insider Newsletter

October Edition of the Database Insider Newsletter is now available.

Highlights include:

NEWS

Oracle Executives Ellison and Mendelsohn Talk About Database Innovations at Oracle OpenWorld 2014

Access full-length Oracle OpenWorld 2014 keynotes featuring Executive Chairman and Chief Technology Officer Larry Ellison and Executive Vice President of Server Technologies Andy Mendelsohn, who discuss the latest capabilities and future directions of Oracle Database solutions.
Read More


Oracle Reinvents Database Protection with Zero Data Loss Recovery Appliance

During his opening keynote at Oracle OpenWorld 2014, Oracle Executive Chairman and Chief Technology Officer Larry Ellison announced the general availability of Oracle’s Zero Data Loss Recovery Appliance, the world's first and only engineered system designed specifically for database protection. This massively scalable appliance delivers unparalleled data protection, efficiency, and scalability.
Read More

Enjoy!

Monday Sep 29, 2014

Oracle Reinvents Database Protection with Zero Data Loss Recovery Appliance

Reinventing Database Protection

During his opening keynote at Oracle OpenWorld 2014, Oracle Executive Chairman and Chief Technology Officer Larry Ellison announced the general availability of Oracle’s Zero Data Loss Recovery Appliance, the world's first and only engineered system designed specifically for Oracle Database protection. This massively scalable appliance delivers unparalleled data protection, efficiency, and scalability.

Unparalleled Data Protection

Visit the Oracle.com Main Landing Page

Read the Enhanced Press Release

Watch Sr. Vice President Juan Loaiza's Webcast

Read the story, featuring an interview with Ashish Ray, VP of Product Management

Oracle's Zero Data Loss Recovery Appliance (Recovery Appliance) is the first appliance ever to deliver zero data loss protection for critical Oracle Databases. When using today’s solutions to restore a database, businesses typically lose all data generated since the last backup—often hours to days of critical data.
The Recovery Appliance dramatically reduces the impact of backups on production servers and networks, virtually eliminating the need for lengthy backup windows. The cloud-scale architecture enables a single Recovery Appliance to manage the data protection requirements of thousands of databases, avoiding the cost and complexity of disparate backup systems. 

Zero Data Loss Recovery Appliance infographic

View the Infographic

Key Messages:

  • Eliminates data loss: Unique database integration enables continuous transport of redo data to the appliance, providing real-time protection for the most recent transactions so that databases can be restored without data loss.
  • Eliminates production impact: Backup algorithms integrated into Oracle Database send only changed data to the appliance, minimizing production database impact, I/O traffic, and network load. All expensive backup processing is offloaded to the Appliance.
  • Offloads tape archival: The Recovery Appliance can directly archive database backups to low-cost tape storage, offloading production database servers. Archival operations can run both day and night to improve tape drive utilization.
  • Enables restore to any point in time: The database change data stored on the Appliance can be used to create virtual full database copies at any desired point in time.
  • Delivers cloud-scale protection: A single Recovery Appliance can serve the data protection requirements of thousands of databases in a data center or region. Capacity expands seamlessly to petabytes of storage, with no downtime.
  • Protects data from disasters: The Recovery Appliance can replicate data in real time to a remote Recovery Appliance or to Oracle Database Backup Cloud Service to protect business data from site outages. Database blocks are continuously validated to eliminate data corruption at any stage of transmission or processing.

Want to learn more?

What else is happening at Oracle OpenWorld 2014 that includes the Zero Data Loss Recovery Appliance? Check out the following sessions:

  • Monday, Sept. 29:  2:45 - 3:30 (CON7684) - Moscone South - 307

Oracle Zero Data Loss Recovery Appliance: A New Era in Data Protection

  • Tuesday, Sept. 30:  3:45 - 4:30 (CON7686) - Moscone South - 305

Oracle Zero Data Loss Recovery Appliance: Deployment Best Practices 

And don't forget to see the Zero Data Loss Recovery Appliance in action. Visit the Engineered Systems Showcase at Moscone Center North and take a tour with one of our product experts.


About





Search

Categories
Archives
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
      
Today