Learn why and how Oracle BerkeleyDB can bring NoSQL benefits to your application
Comments Off | Filed in Links, Oracle | Tags: BerkeleyDB, nosqlBerkeley DB undoubtedly qualifies as a robust and scalable NoSQL key-value store; the use of Berkeley DB as the underlying storage for Amazon’s Dynamo, Project Voldemort, MemcacheDB, and GenieDB is further evidence supporting this claim. There has been a little bit of FUD around Berkeley DB performance, especially in the wake of couple of comparative benchmarks published online:
http://www.dmo.ca/blog/benchmarking-hash-databases-on-large-data/
http://stackoverflow.com/questions/601348/berkeleydb-vs-tokyo-cabinet
However, there are many live systems that prove Berkeley DB’s strengths. Many of these systems, through careful tuning and application coding improvements, have achieved excellent scalability, throughput, and reliability results. Following the lead of those systems, Berkeley DB can certainly be used as a scalable NoSQL solution.
Working with Microsoft Office 2007 (OOXML) files using Oracle PL/SQL
I have written a package for working with OOXML documents. It’s called OOXML_UTIL_PKG and you can download it as part of (you guessed it) the Alexandria utility library for PL/SQL.Comments Off | Filed in Links, Oracle | Tags: microsoft, pl/sql
Join factorization, a new Oracle DB 11gR2 feature
Hong Su from Inside the Oracle Optimizer:
The Join Factorization transformation was introduced in Oracle 11g Release 2 and applies to UNION ALL queries. Join factorization is a cost-based transformation. It can factorize common computations from branches in a UNION ALL query which can lead to huge performance improvement.
Yet another reason to upgrade to 11gR2.
Comments Off | Filed in Links, Oracle | Tags: performance, sqlOracle Exadata Resource Kit
Featuring:
- 3-D Demo: Oracle Exadata
- Gartner Executive Video: Opportunities and Challenges for Managing Data and Lowering IT Costs
- IDC Report: Exadata Exceeds Expectations
- White Paper: A Technical Overview of the Oracle Exadata Database Machine
- Customer case studies, videos, podcasts and more
via Exadata Partner Community – EMEA.
Comments Off | Filed in Links, Oracle | Tags: exadataERP Software Financial Roundup for Q4 2011
Comments Off | Filed in Links, Oracle | Tags: erp, sap
- The ERP market has regained strength, but we’re seeing a growing disparity between the big ERP players and the mid-tier players.
- As small and mid-size businesses return to the market in 2011, leading mid-tier players can regain momentum; others will flounder.
- There is growing momentum behind cloud-based ERP, which will benefit NetSuite, as well as those traditional ERP companies that adapt.
Oracle’s VMware support policy like Jekyll and Hyde
Organizations that have run Oracle Database and applications for years on top of VMware’s virtualization technology said they have had little to no problem getting Oracle Support to work with them on issues.Comments Off | Filed in Links, Oracle | Tags: vmware
How To Manually Install XML DB On Oracle 11g
Due to Oracle Bug 9818995, if catqm.sql is used then not all installation steps are performed by this script… This document explains the full set of steps that need to be taken in order to perform a complete and working Oracle XML DB installation.Comments Off | Filed in Links, Oracle, Tips | Tags: 11g, xml
Project Guide for Oracle RAC Implementation
This article is a guide for defining, designing, and delivering a successful Oracle RAC project. It details the steps required to reduce risks and increase your chances of a successful implementation. In addition, it highlights many major pitfalls you may encounter during your Oracle RAC project and offers suggestions on how to avoid them.
Even though it was published in 2006, the steps listed in this guide still apply to many Oracle projects today.
Comments Off | Filed in Links, Oracle | Tags: guide, project, racCreate an Excel file with PL/SQL
For this project I took an Apex-plugin I have written, (IR) Report to Excel (xlsx), and turned it into a PL/SQL package. With this package it’s very easy to create an Excel 2007 file with only a few lines of PL/SQL code.Comments Off | Filed in Links, Oracle | Tags: excel, pl/sql
4 interesting things you may have missed on Feb 18, 2011
-
It's a wiki, like Wikipedia. all of the information you see on the site is freely editable by any logged-in user. Anyone can contribute to articles, add new code, edit articles, you name it. This site is by the community, for the community. Content is moderated by the community and our own panel of database experts, all with a high level of expertise and passion in their field.
-
VARCHAR is an ANSI standard data type but Oracle's implementation of the VARCHAR data type violates the ANSI standard by considering the empty string to be NULL (Oracle's implementation predates the ANSI standard). Oracle has stated that the semantics of the VARCHAR data type may change in the future with respect to how the empty string is treated. If and when that happens, the semantics of the VARCHAR2 data type will remain the same. Using the VARCHAR2 data type is safer because you don't have to worry that some future version of Oracle will break your code by causing empty strings to no longer be considered NULL.
-
Thursday, the National Telecommunications and Information Administration (NTIA) released The National Broadband map, a staggeringly powerful free tool that gives anyone access to census-level data about broadband connectivity in the United States.
-
In the past 5 years many specialized DBMSs have been introduced, as well as database systems with new storage schemes. These can be categorized by the type of the applied technology. This article explains the four most popular types of database systems currently used by top corporations like Yahoo, Facebook, Google, Misrosoft, Amazon, etc.
