(Arup Nanda) New features for more efficiently managing materialized views, Query Rewrite, Transportable Tablespace, and table partitions make your data warehouse an even more powerful, and less resource-intensive, asset.
Tag: Oracle
Query to Find Second Saturday
(Chacravarthi Ramasami) This tip was submitted for use with Oracle8i. This query gives the second saturday of each month for the present year.
Linux is optimal OS for grid computing, says Oracle
(Ee Sze Tan) Linux is the optimal operating system for grid computing and is set to drive the cost of enterprise computing down.
Best Practices for Consolidation of Oracle on Linux Deployments
There are many reasons to deploy Oracle on Linux. The more important ones are the flexibility and non-proprietary characteristics of Linux. But the key advantage is that the entire server side code stack from the OS to the application layer is supported by Oracle. Using the best practices Oracle
Securing Linux Production Systems
(Werner Puschitz) This article is a practical step-by-step guide for securing Linux production systems. It discusses basic Linux security requirements for systems that need to pass various audits and more in an enterprise environment. If you have been assigned to come up with a corporate Linux Secur
Oracle Multicore Licensing Ignores Market Reality
(John Pallatto) Opinion: Oracle may eventually find that its stubborn adherence to per-core software licensing becomes a competitive liability at a time when the industry is moving away from even per-processor terms.
Transforming XML with XSLT (Sample Chapter)
(Steve Muench) We’ve used XSLT stylesheets in previous chapters to transform database-driven XML into HTML pages, XML datagrams of a particular vocabulary, SQL scripts, emails, and so on. If you’re a developer trying to harness your database information to maximum advantage on the Web, you’ll find
Managing State in Service-Oriented Architecture
(Mark M. Davydov) One of the most common misconceptions about Web services is that they are appropriate only for supporting synchronous request/response SOAP (Simple Object Access Protocol)-based interactions. One of the main reasons for this misperception is that many Web services are implemented u
ODM BLAST: Sequence Homology Search in the RDBMS
(Susie Stephens, Jake Y. Chen and Shiby Thomas) Performing sequence homology searches against DNA or protein sequence databases is an essential bioinformatics task. Past research efforts have been primarily concerned with the development of sensitive and fast sequence homology search algorithms ou
Who Are You?
(George Demarest) Everyone on the security team at Oracle wears a trench coat and a fedora, just like everyone in disaster protection wears a HAZMAT suit. So it was easy to identify Mary Ann Davidson, Oracle’s chief security officer, as I went to interview her for this piece.
