(Aradhana Puri) Oracle Portal, part of Oracle Fusion Middleware, is a Web-based tool for building, deploying, and maintaining self-service and integrated enterprise portals. It also provides services that enable you to perform configuration and administrative tasks. To perform most configuration and
Author: SSWUG Research
Integrate DB2 Express-C into service-oriented applications using ActiveGrid LAMP Studio
(Wendy M. Schott) The recent release of IBM DB2 Express-C is another strong endorsement for LAMP (Linux, Apache, MySQL, Perl/PHP/Python) as a compelling, lightweight enterprise application platform. Enterprise developers today are increasingly using LAMP to integrate Web services and databases on th
TechTip: Speed Up Your UDF Performance
(Kent Milligan) SQL user-defined functions (UDFs) have been available since OS/400 V4R4. UDFs provide a great tool for allowing you to easily perform a business calculation as an SQL query, processing a set of rows in your database. If you want an explanation of how to implement UDFs, take a loo
Understanding Generic Classes
(Tod Golding) Many developers will view themselves primarily as consumers of generics. However, as you get more comfortable with generics, you’re likely to find yourself introducing your own generic classes and frameworks. Before you can make that leap, though, you’ll need to get comfortable with al
Implementing a Data Access Layer in C#
(Joydip Kanjilal) A Data Access Layer is an important layer in the architecture of any software. This layer is responsible for communicating with the underlying database. Making this layer provider independent can ensure multi database support with ease. This article discusses implementation of a
Using a Template Processor Class in PHP 5
(Alejandro Gervasio) Welcome to part two of the series “Separating logic from presentation.” Comprised of three articles, this series walks you through the development of an extensible template processor in PHP 5, which you might find quite useful for separating the logic of your PHP applications fr
Applying Project Management to Your Data Integration Project
(Cheryl Strait and John Volpe) Managers can use project management tools and techniques to successfully initiate and manage efforts associated with implementing or maturing their data integration and data warehousing capabilities.
Content Manager Implementation and Migration Cookbook
(Wei-Dong Zhu, Jorge A. Andres, Kenneth S. Christensen, Chun Liu and Glenn Dreves) This IBM Redbook deals with IBM DB2 Content Manager implementation and migration. It is aimed at architects, designers, developers, and system administrators of Content Manager systems. (pdf)
Rolling Back Layers of Automatic Undo Management
(Steve Callan) Probably the number one database administration headache in pre-9i versions of Oracle concerns the “ORA-01555 snapshot too old” error. Let’s move forward to Oracle 10g and configure a database to use automatic undo management (AUM). Your initialization file (pfile or spfile) has the a
Why Oracle Works the Way it Does (5) – Basic Memory Structures
(Dratz) If we had to rely on pure disk I/O for everything we did in Oracle, not only would our hard disks stay very hot, but we wouldn’t be able to scale or perform as smoothly as we’d like to.
