(Bruce Wallace) With the increasingly popular AJAX paradigm, a browser page can make requests for server data in the background while the user interface continues to be active in the foreground (hence the “asynchronous” in AJAX). However, the problem exists that these two activities are typically ac
Other News
Data Access Component and the Factory Design Pattern
(Waleed El Tamimi) Merely, every application today uses a relational database as its backend, applications used to be monolithic and structured, but with the need for more functionality and ease of use, applications became larger, more complex and harder to maintain, and the solution for rapid devel
Retrieve important user information using Windows Scripting Host
Just like VBA and VBScript, Windows Scripting Host (WSH) is a subset and extension of Visual Basic designed to provide access to various system and environment information available in a Windows environment. This download shows you how to apply WSH to the problem of retrieving user country and langu
Comparative Management Cost Study of Oracle Database 10g Release 2 and Microsoft SQL Server 2005
With this study Edison Group has validated the manageability advantage of using Oracle Database 10g over Microsoft SQL Server 2005. With Oracle Database 10g Release 2, DBAs can expect to reduce their daily workload, and businesses can reduce their cost of managing enterprise database systems. (R)
DataStage tip: using job parameters without losing your mind
(Vincent McBurney) A job parameter in the ETL environment is much like a parameter in other products, it lets you change the way your programs behave at run-time by tweaking or changing parameters to alter the way the job behaves. This constant changing can either ease your support burden or drive y
Optimizing Queries with Operators, Branching and Functions, continued
(Jon Stephens and Chad Russell) We are now going to look at a number of MySQL functions. Again, the focus here is on the central premise of this chapter: replacing programming logic with SQL logic is a key optimization skill, and it is almost always the best course of action to make the database per
XML Storage – Part 2
(Chris Eaton) In the last post I described the motivation for using a completely new storage engine within DB2 for storage and management of XML data. In this post I will describe the storage in a bit more detail along with the syntax for using an XML datatype.
PyQT: Handling Windows and Buttons
(A.P.Rajshekhar) In this article, you will continue to learn about the process of building a GUI in PyQT. Specifically, you will learn about QDialog and QPushButton, which handle windows and buttons, the building blocks of most GUIs.
Best Practices for Printer Management in the Oracle E-Business Suite
Managing printers within the Oracle E-Business Suite is challenging. In this paper, we will discuss tips and tricks to reduce printer setup and management effort and how to enable users to print Oracle output to any local or network printer. (R)
Monitor Your Database Servers with DTS, Part 1: Backup SLA Report
(Neeraj Nagpal) It is difficult to keep track of critical things like backup, space, and error logs in large environments. Different database management tools from third party vendors can help you monitor these but the tools are normally expensive. There is an inexpensive alternative. In this se