(Lenka Vanek and Tom Chu) Upgrading hardware is usually painless, but upgrading databases…well, everyone has a horror story to tell. The primary concerns of a seasoned Oracle DBA are the success of the upgrade and the downtime that could result. Success being not only that the upgrade itself worked
Other News
The Face of Intelligence
(David Baum) Business intelligence (BI) applications traditionally have been the province of highly trained analysts responsible for financial reporting and analysis activities. No more. Today’s organizations are deriving more value from their BI investments by extending actionable information to ma
Protect your Metadata
(Kalen Delaney) Metadata is data about data. It not only describes the structure and meaning of your data, but also the structure and meaning of your applications and processes. In this article, I will discuss the concept of metadata visibility and focus on the visibility restrictions introduced in
Building With Blox: A Faster Route to Analytic Apps
(Nelson King) IBM DB2 Alphablox 8.3 is an incremental advancement of a product that lives between the possibility of enabling nonprogrammers to build online analytical processing applications and the vastly more difficult developer’s slog of building such programs from scratch. The key word is build
MySQL to adopt Firebird architecture
(mauriciolongo) Today it became generally known that MySQL has aquired a company called Netfrastructure. This company offers a product which is a reimplementation of the Firebird database architecture, combined with a web-based application server front end. It was designed by Jim Starkey in the late
Configure Informix Dynamic Server with WebSphere Application Server
(Anju Sudhakar) WebSphere Application Server (Application Server) is a high-performance transaction server that features an extremely scalable transaction engine capable of handling high-volume secure transactions and Web services. Application servers are middleware that handle application functions
Web clients fatten up with OpenLaszlo
(Joshua M. Woods) OpenLaszlo is a rich client application architecture that uses Macromedia Flash as a deployment vehicle. Declarative in design, OpenLaszlo relies upon JavaScript for logic and offers advantages over traditional Flash development, including an advanced UI constraints system, an obje
How Much Do Concurrent Updates Impact Query Performance in Oracle?
(Roger Schrag) Oracle has a strict read-consistency model coupled with high concurrency that sets it apart from other database products such as Microsoft’s SQL Server. You can update rows in a table while I query those very same rows. Your updates will not get lost, my query results will not be corr
Lock the Controls Down on a Page
The following blocks of code will provide you with a method of iterating through all the controls on a page and performing some change on the properties of the control. In this particular example, we wanted to provide a simple means of locking controls down to users who did not have edit permissions
Introduction to Excel XML
(Brian Jones) With the soon-to-be released next version of Microsoft Office (currently code-named “Office 12”), there will be new default file formats for Microsoft Word, PowerPoint, and Excel. These new formats, called the Microsoft Office Open XML Formats, will open up a whole new world to Office