(Ivan Pepelnjak) In the Web 2.0 world, every idea or paradigm has to have a catchy name, and HIJAX (which gets lots of its gleam from the –JAX suffix) is no exception. It definitely sounds better than Progressive Enhancement when using Asynchronous JavaScript and XML, which is what HIJAX is all abou
Other News
Generating XForms applications using the National Information Exchange Model (NIEM)
(Dan McCreary) The National Information Exchange Model (NIEM) is a United States’ federal data standard for the exchange of XML data between federal, state, and local organizations. The NIEM provides a rich set of universal data elements that non-programmers can use to build semantically precise dat
Oracle: Synonyms’ Synonyms
(JP Vijaykumar) Understanding the characteristics of Oracle’s Synonyms and their object access priorities will help resolve related issues.
CTAS on a Table with Nested Tables
(Alex Nuijten) The other day one of my colleagues asked me if it is possible to create a copy of a table with all the content in it. He wanted to do some experiments with it and didn’t want to mess with the original table. A simple CTAS (Create Table As Select) didn’t work, because the table had a c
The importance of User Security and Auditing
(David Kelly) It often surprises me how much, or should I say little, attention is given to application security and data access requirements during new implementations. Large corporations tend to have an audit and/or compliance team scrutinizing a new implementation down to the lowest level, while
Performance Impact: Frequent Manual Checkpoints and Their I/O Behavior
(Linchi Shea) In my previous blog post on the performance impact of frequent manual checkpoints, I highlighted the performance peril of going overboard with manual checkpoints, and I suggested that a major contributing factor was the failure of frequent manual checkpoints to take advantage of the th
How much overhead is caused by on disk temporary tables
(Peter Zaitsev) As you might know while running GROUP BY and some other kinds of queries MySQL needs to create temporary tables, which can be created in memory, using MEMORY storage engine or can be created on disk as MYISAM tables. Which one will be used depends on the allowed tmp_table_size and al
Error message when you try to set a witness in a database mirroring session in SQL Server 2005
Consider the following scenario: • You have a database mirroring session in Microsoft SQL Server 2005. • The database mirroring session does not have a witness. • You set up a witness server. • On the principal server and on the witness server, you do not use DNS together with DHCP for n
Keep an eye on file system changes with VB.NET’s FileSystemWatcher
(Irina Medvinskaya) FileSystemWatcher is a component in Visual Studio .NET that allows you to respond to file system changes. It’s very handy whenever you need to perform a certain action in response to a file being updated and in numerous other situations.
Determining performance problems with DB2 Java applications
(Jason V. Ma and Ming-Pang Wei) One of the daily challenges facing application developers and database administrators is dealing with performance issues. While many performance issues lie with database servers, some are associated with the client application. This article brings insight into diagnos