How to Build Better Data Warehousing and Business Intelligence

The processing capacity of the Oracle Exadata Database Machine means fewer physical structures and better Data Warehousing and Business Intelligence.

No, the Oracle Exadata Database Machine is not the infinite machine that will make integration, computation, and aggregation all on-demand functions. But the Oracle Exadata Database Machine helps us to start thinking about simplifying some of the processing and gyrations we have to do to build and deliver an efficient data warehouse solution. With Oracle Exadata, we can more quickly read the data we need to satisfy our queries. Without Oracle Exadata, we need to build separate structures—such as materialized views—in our data warehouses to boost performance. With Oracle Exadata, we don’t need to build as many physical structures, freeing up more time for using the data instead of processing it.

In general terms, there are two reasons for building additional data structures, or even databases, above an integrated data warehouse. The first is to make the data easier to consume by our end users and their reporting and analytic applications. To get better usability and to focus our analytic applications, we create a new subset of our data in snapshots or data marts to support a specific analytic or reporting application, and that subset is just another physical projection, or movement, of the same data. With Oracle Exadata, however, we create fewer physical projections and can create more logical projections of the data in our BI tool of choice in our integrated data warehouse for the same purpose.

Data Warehousing and Business Intelligence

Continue reading How to Build Better Data Warehousing and Business Intelligence


Driving Down the High Cost of Storage

Does it seem like only yesterday that you made a sizable investment in a storage area network (SAN), only to find that it already needs to be significantly upgraded or even replaced? With data size and complexity increasing all the time, and with SANs remaining the technology of choice for data center storage, it’s not surprising that legacy investments in storage infrastructure are failing to keep up. What’s needed is a storage infrastructure that can handle increasingly insistent data storage demands in order to deliver IT and business value both now and far into the future.

That’s an impossible challenge for traditional approaches to SAN storage, which were simply not designed to keep pace with data growth. It may be possible to add capacity to legacy systems to support critical applications, but this often comes at the expense of performance. Adding both capacity and performance generally requires frequent new hardware investments. The cost to acquire, deploy,maintain, and inevitably replace that hardware—not to mention the cost to expand the data center to accommodate it—ultimately becomes simply intolerable from a business standpoint.

Oracle’s Pillar Axiom 600 storage system is an alternative to traditional SAN storage. It shortens time to value and continues to deliver value over the long term by speeding application deployment and facilitating rapid access to data. It represents a fundamentally different approach: Storage adapts dynamically to changing application requirements from the start, scales to accommodate growing performance and capacity demands over time, and simplifies the storage infrastructure to keep ongoing administrative requirements to a minimum.

Eliminate Costly, Inefficient Data Silos

Traditional storage solutions typically address different applications’ data needs by having dedicated storage for each application, resulting in a multitude of silos of data.These have to be deployed and maintained separately in order to meet performance requirements, which slows time to value and also minimizes that value, because capacity is used inefficiently.Pillar Axiom 600, by comparison, is implemented as a single consolidated SAN storage platform that meets the storage needs of multiple applications simultaneously. It’s designed to be fast and simple to deploy, speeding time to value. And the value it achieves is greater than what traditional solutions can deliver because of its unique quality of service (QoS) capability, which dynamically and automatically allocates storage resources to applications based on their importance to the business.Pillar Axiom 600’s QoS capability allows rapid, efficient allocation of storage, with minimal administrative overhead.

It also automatically detects changes in application priorities and responds accordingly, making it possible to meet performance requirements without sacrificing utilization. Integrate with Oracle Software and Mixed Application Environments Reap the Benefits of Hardware and Software Engineered to Work Together The economic benefits of application-aware storage are available to any data center environment, regardless of the associated software stack. But the benefits are even greater in Oracle software environments, because the storage is engineered for Oracle software, with a number of unique integration points that are available only when Oracles torage is deployed with Oracle software. For example, Oracle Database includes a high-efficiency data compression feature—hybrid columnar compression—that only works with storage developed by Oracle, including Pillar Axiom 600 storage systems.

The ability to leverage hybrid columnar compression, integration with Oracle VM, andother unique benefits of the Oracle software environment further speed the time to value for Pillar Axiom 600, as well as lowering business risk for companies that deploy it with Oracle applications.

For more information on Pillar Axiom 600, call +1.800.ORACLE1 to speak to an Oracle representative or visit
OUTSIDE NORTH AMERICA Visit to find the phone number for your local Oracle office.


ZFS Storage Appliance

Oracle ZFS Storage Appliance, based on an innovative storage architecture, delivers leading performance, management simplicity, and unparalleled efficiency to reduce storage sprawl, complexity, and cost. As only Oracle can co-engineer hardware and software together, Oracle ZFS Storage Appliance offers unique Oracle Database integration within a robust storage platform that complements the extreme performance of Oracle engineered systems, Oracle’s SPARC and Sun x86 servers, and Oracle Solaris.

ZFS Storage Appliance and Virtualization
ZFS Storage Appliance and Virtualization

Continue reading ZFS Storage Appliance


Report: Cost/Benefit of Enterprise Warehouse Solutions

In-depth Comparison of IBM Smart Analytics System 7700,
Teradata Active Enterprise Data Warehouse and
Oracle Exadata Database Machine.

Data warehousing has emerged as one of the IT world’s fastest growth areas. New deployments continue to accelerate, and numbers of applications and users within organizations continue to expand. Demand for high-quality, current information and for tools to interpret and exploit it shows no signs of abating. High
double-digit growth in data volumes has become the norm.

The business benefits of data warehouse applications are clearly recognized. But, increasingly, users are faced with escalating expenditure not only on data warehouse solutions, but also on underlying platforms. At a time of budgetary pressures, questions are raised about the most cost-effective means of realizing
information value.

This is particularly the case for special-purpose platforms offered by IBM (Smart Analytics System, Netezza TwinFin), Oracle (Exadata Database Machine), Teradata (Active Enterprise Data Warehouse) and smaller players. Architectures and technologies of these systems are often unfamiliar to organizations that deploy them. Techniques for measuring comparative performance and cost are rudimentary.

Challenges are compounded by several factors. One is that the performance of different architectures depends on the workloads they execute. Another is that data warehouse usage tends to evolve rapidly – organizations that deploy platforms for specific applications may soon find that they must deal with significantly different environments. A third is that vendor pricing may vary widely between customers.

This report sets some parameters for comparisons. To do this, it takes into account types of workload – in particular, a key distinction is drawn between complex mixed workloads and queries involving large sequential table scans – compares overall three-year as well as acquisition costs, and bases platform calculation on “street” pricing (i.e., discounted prices paid by users).

The report focuses on three platforms: IBM Smart Analytics System 7700, Oracle Exadata Database Machine and Teradata’s flagship Active Enterprise Data Warehouse (Active EDW) 6650. Results are based on input from 46 users of these systems and their recent predecessors, on other industry sources, as well as on research and analysis conducted by the International Technology Group (ITG).

Two sets of cost comparisons, based on performance and user data, are presented.

Continue reading Report: Cost/Benefit of Enterprise Warehouse Solutions


Oracle Big Data Appliance

The creation of data has always been part of the impact of information and communications technology. As the amount of data available for analysis continues to grow, the challenge is for organizations to find the technology that would give them the ability to disseminate, understand and ultimately benefit from the increasing volumes of data. Oracle has recently announced the release of what they consider a viable solution to handle the challenge of Big data. The Oracle Big Data Appliance consists of optimized hardware and several software products from Oracle Corporation .The Oracle Big Data Appliance in union with Oracle Exadata Database Machine and the Oracle Exalytics Business Intelligence Machine (Oracle Exalogic) is used for obtaining, consolidating and loading unstructured data into the Oracle Database 11g. The solution consists of an open source distribution of Apache Hadoop, Oracle NoSQL Database, Oracle Data Integrator with Application Adapter for Hadoop, Oracle Loader for Hadoop, an open source distribution of R, Oracle Linux, and Oracle Java Hotspot Virtual Machine.

Oracle announced the Oracle Big Data Appliance Mon, October 3 at Oracle OpenWorld 2011.

Continue reading Oracle Big Data Appliance


Storage and Data Costs Calculator

The average cost per gigabyte for flash, disk or tape storage can vary widely. By aligning the right type of storage media with your data tiers need, you can be much more cost effective when acquiring your storage.

Business managers must understand important cost distinctions when making decisions and exercising control based on different types of cost data. These cost distinctions help managers better appreciate the cost figures that accountants attach to products that are manufactured or purchased by the business.

Calculate your potential savings with Oracle’s flash, disk and tape approach.

Data Cost Calculator

Continue reading Storage and Data Costs Calculator


14 Best Enterprise Data Storage Webcasts

Here you go, this is the list of all webcasts Oracle is presenting about cost of data storage, enterprise data storage and Oracle’s private cloud appliance:

  • Improve Database Capacity Management with Oracle Storage and Hybrid Columnar Compression 
    Dave Krenik, Storage Solution Specialist and Mark Mulligan, Exadata Pillar Specialist discuss how Oracle’s hybrid columnar compression (HCC) feature – which is now supported on Oracle’s Sun ZFS Storage Appliance and Pillar Axiom 600 – can help customers better manage the lifecycle of data using in-database archiving for OLTP databases and data warehouses. Using Hybrid Columnar Compression in these environments, customers can achieve 3x to 5x reductions in their storage footprints, energy usage and cost by replacing existing EMC and NetApp SAN and NAS storage with Oracle storage solutions. Continue reading 14 Best Enterprise Data Storage Webcasts

Scaling Web Databases with MySQL Cluster – Guide

Why 9 of the top 10 most trafficked web sites are powered by MySQL?

MySQL Scalability with MySQL Cluster

User loads and data volumes are exploding – driven by increasing Internet penetration rates, social networking, high-speed mobile broadband connecting ever-smarter devices, new Machine to Machine (M2M) interactions, and more. MySQL Cluster allows users to overcome database challenges in the next generation web, cloud, and communications services while guaranteeing scalability, uptime and agility. MySQL Cluster is a technology providing shared-nothing clustering and auto-sharding for the MySQL database management system. It is designed to provide high availability and high throughput with low latency, while allowing for near linear scalability.

Alternatives to MySQL Scalability without MySQL Cluster

Continue reading Scaling Web Databases with MySQL Cluster – Guide