(Joab Jackson) Extensible markup language consulting firm Starbourne Communications Design is tackling a job that agency XML advocates have long lobbied for, but have never gotten the funding to execute: building a central registry of federal XML schemas.
Other News
Managing content in an employee workplace, Part 11: Set up a file plan in IBM DB2 Records Manager
(Therese Sroujian) Learn how to set up a file plan for record retention and management in IBM DB2 Records Manager in this eleventh article in the series about managing content in an employee workplace. The series describes a scenario about employees who collaborate to author, review, and publish res
2005: A SOX Auditor’s Odyssey
(Alex Woodie) The year 2005 is shaping up to be a banner year for auditors performing Sarbanes-Oxley Act audits and, perhaps, for sales of software that helps companies comply with the new regulations. While it appears many companies are choosing to use manual processes to meet their first SOX deadl
Some ‘Hints’ for Mastering SQL Tuning
(Raghu Donepudi)
Generic Code to Execute Stored Procedures
(Sriram Surapureddy) You can execute a single stored procedure or batch of stored procedures using collections. You can execute any stored procedure with a different number of parameters and data types. Whenever there is any change in stored procedure, you just need to add or delete parameters in th
Data Definition Language, Part 2
(Paul Dubois) The SELECT statement retrieves the information contained in your databases. You can also ask MySQL to show you information about your databases, such as database and table names or information about the columns or indexes in a table.
Generating Realistic and Non-Random Sample Data
(Mark Frawley) Have you ever needed to populate a database with realistic, but generated (as opposed to actual) data, in volumes that demand automation? Such a need arises in many circumstances, such as: –Stress-testing on new applications where historical data does not yet exist. –Data Scrub
Database Benchmarking
(Steve Callan) If you have seen advertising literature from major database system vendors, invariably you have seen statements about how that database performed against other systems (benchmark results). All of the major vendors support and participate in benchmarking tests because, to some degr
Making the Most of Java’s Metadata
(Jason Hunter) The recent release of J2SE 5.0 (also known by its codename “Tiger”) introduced numerous Java language changes designed to make programming in Java more expressive, developer-friendly, and safe. I covered many of Java’s new features in a September 2003 article entitled “Big Changes Com
SQL Server Contention: Diagnosing and Resolving Blocking Problems
As we develop SQL Server applications with more and more concurrent users, there is inevitable contention as users compete for data resources. They are either forced to wait for each other or face the risk of reading inconsistent data due to in-progress changes. This trade-off between correctnes