Neat Oracle Database 11g Release 2 Feature: Preprocessing External Tables
External tables enable users to access data in text files, immediately eliminating the need to load input text files to intermediate tables for processing—saving both time and storage space. Now, with Oracle Database 11g Release 2, intermediate processing of any kind—such as decompression of compressed input files—is eliminated, further saving time and storage, not to mention a change to the existing code.
But the power of inline preprocessing is not limited to decompression alone. It can be applied to any type of prior processing required, as long as it produces an output that can be parsed by the external table. The directory listing is just one small demonstration of this rich capability of preprocessing in external tables. You can also use it to massage datafiles to fit a specific format, append or augment data from multiple sources dynamically—without creating any intermediate storage—or even send an e-mail when a specific text file is accessed by an external table. What you can do with inline preprocessing is limited only by your imagination.
1 Comment | Filed in Links, Oracle | Tags: 11g, sqlBefore External Tables existed in the Oracle database, loading from flat files was done via SQL*Loader. One option that some used was to have a compressed text file and load it with SQL*Loader via a named pipe. This allowed one not to have to extract the file, which could be several times the size of the compressed file. As of 11.1.0.7, a similar feature is now available for External Tables (and will be in 10.2.0.5). This enhancement is a result of Bug 6522622 which is mentioned in the Bugs fixed in the 11.1.0.7 Patch Set note.
Conventional (NOAPPEND) parallel inserts available in Oracle DB 11g
Oracle 11g obviously has added the capability to perform a conventional, non-direct-path insert in parallel.
Greg Rahn:
Parallel conventional (NOAPPEND) insert was an 11g new feature, though it seems to have escaped the new features list in the docs. It was added to support cases where parallel insert as select was desired, but the restrictions associated with direct path inserts were not desired.Comments Off | Filed in Links, Oracle | Tags: 11g, sql
ODTUG KScope 11 and Database Content
Comments Off | Filed in Links, Oracle | Tags: kscope, odtugMy plan was to build the conference around the life cycle that a database developer works with. Since we weren’t cherry picking the content we couldn’t force anything on the schedule but the overall goal was to present topics, from beginner to expert, on Design, Coding, Maintenance and Best Practices. You can get more on what I mean by those topics at the site. I really believe we met that goal. You can also see the schedule now.
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
