JDeveloper provides wizards that help users create OLAP objects, including crosstabs, tables, graphs, calculations, and queries. The definitions of these OLAP objects are stored in XML files that can be copied to the BI Beans Catalog. End users can then access these objects in the Catalog through a

(Lewis R Cunningham) Today I want to talk about collections in Oracle. I’ll explain what they are and give some examples on using them. On with the show.

(Aradhana Puri) Oracle Database 10g introduced Automatic Database Diagnostic Monitor (ADDM), which enables the database to self-analyze its performance. The database can identify potential bottlenecks and fix them automatically or recommend a solution to an administrator. To make solutions or re

(Renee Boucher Ferguson) In its quest to become the dominant enterprise software maker, Oracle Corp. acquired two retail-based software developers this summer—Retek Inc. and ProfitLogic. At its OpenWorld conference in San Francisco, the company took the next step in its vertical plan by announci

(Jagadish Chaterjee) This article mainly concentrates on connecting to an Oracle database using ASP.NET in several possible ways, and finally focuses on ODP.NET and its advantages.

(Sean Carey) Web services and service-oriented architecture (SOA) allow business processes to be easily extended through interaction with other business processes and applications. BPEL processes define this interaction through partner links, which define the interface (messages and operations), tra

This technical white paper will discuss ways for rapid Oracle data unload, extract from large production tables into portable format and load / import this data back into the database. (pdf)

(Jim Czuprynski) The previous article in this series reviewed Oracle 10g’s enhancements to analytical functions, including the use of partitioned outer joins to “densify” data within multiple dimensions. As that article promised, I will now delve into the new MODEL clause that grants any Oracle deve

(Charles Babcock) Users of some PeopleSoft and J.D. Edwards applications will have a direct upgrade path to Oracle’s future Fusion applications instead of having to upgrade to non-Fusion releases of Oracle applications first, according to John Wookey, Oracle senior VP for applications.

(David C. Knox) This chapter looks at securing database schemas by limiting their privileges, providing good password support, restricting access using multiple defenses, and securing the network channels to and from the database. These steps represent many of the best practices used by organiza