Oracle Corp. recently moved to stake a claim in the increasingly crowded enterprise business intelligence market with a new suite of tools and applications.
Author: SSWUG Research
DACBuilder – Data Access objects generation tool based on XML and XSL templates transformation
(Dan Radu) When I started working in database programming and complex business implementations, the need for a data access framework was definitive. I started to build my own classes that accessed data objects. Of course, starting from 0, the effort was bigger and I thought that a “general” data acc
Index maintenance of 10G
(yas) I have read at Eric S. Emrick’s blog about the redo behaviour seen when updating a primary key column Oracle takes some special steps to prevent unique key collisions that may temporarily occur during the update. You can read what it does at Eric’s post in detail. As Eric shows, it maintains t
Native XML Data Storage and Retrieval
(George Feinberg) The design and implementation trade-offs within a native XML database make a significant impact on the performance, scalability and features available to applications that use it. This article focuses on the granularity of stored XML documents and indexing as two of the most critic
Database Design (Sample Chapter)
(Michael Kofler) The first stage in any database application is the design of the database. The design will have a great influence on the efficiency of the application, the degree of simplicity or difficulty in programming and maintenance, and the flexibility in making changes in the design. Errors
Building the Infrastructure
(Michael L. Gonzales) Most business intelligence (BI) and data warehousing initiatives are planned from the top down. BI architects spend many hours on business requirements. Unfortunately, this careful planning is frequently undermined by a lack of attention to the foundation of any successful BI p
Pulling it All Together with IBM Rational Data Architect
(Justin Whitney) Problem: your company is going through yet another “process re-alignment” and you’ve been given the unenviable task of merging multiple databases into one Damn Big Mega System (DBMS). To make the project even more unappealing, your sales group has been using Informix, billing is in
Dynamic Generation of Word Document Report in ASP.NET with HTML
(Vishal Kumar Patil) Ever needed to generate Word documents from your ASP.NET applications? There are a couple of components which will help to generate Word documents, but using these components may have some overhead such as Component Registration, setting permissions, licenses, etc., Sometimes, i
There could be a ZPARM out there just waiting to ruin your V8 migration
(Willie Favero) I actually have my fingers crossed that this entry is one of those warnings that only affect a small handful of customers migrating to DB2 V8. I addressed this issue in a previous entry a few months ago. However, back then, this was just a few sentences in the middle of a whole lot o
PHPfest Tutorial: Oracle Database 10g Express Edition and Zend Core for Oracle
(Christopher Jones and Alison Holloway) Oracle Database XE is an entry-level, small footprint starter database. It is free to download, develop, and deploy, and you can freely distribute it with your applications. There are no database licencing costs!