(Payton Byrd) Many times we inherit databases that were not designed to be completely normalized. Often, columns will be added to a table to store a pre-calculated amount instead or two seperate tables will have redundant information, such as addresses or phone numbers. If you change any of the busi
Other News
Database feature overview: MySQL 5.0, SQL Server 2005 Express Edition, and Oracle 10g Express Edition beta
Last fall brought a bumper crop of free database solutions, with the release of MySQL 5.0, SQL Server 2005 Express Edition, and the beta version of Oracle 10g Express Edition. The Microsoft and Oracle offerings are geared more toward started implementations and learning environments, but MySQL has a
SQL Server 2000 Incremental Bulk Load Case Study
(Man Xiong and Sunil Agarwal) Incremental bulk load refers to loading data into a nonempty table. The key question during incremental bulk load is whether indexes should be dropped before bulk load. The answer depends on multiple factors. This paper attempts to answer this question through a cas
Java Tip 128: Create a quick-and-dirty XML parser
(Steven R. Brandt) XML is a popular data format for several reasons: it is human readable, self-describing, and portable. Unfortunately, many Java-based XML parsers are very large; for example, Sun Microsystems’ jaxp.jar and parser.jar libraries are 1.4 MB each. If you are running with limited memor
Oracle VP Draws Up Development Plans
John Wookey, senior vice president of application development at Oracle, is walking a fine line. He’s charged with building out Oracle’s next iterations of its E-Business, PeopleSoft Enterprise and JD Edwards EnterpriseOne suites, due next year. At the same time, he’s leading the development of Orac
JavaScript SOAP Client
(Matteo Casati) A lot of talking about AJAX is taking place here and there; AJAX is the acronym of “Asynchronous JavaScript and XML”, a technology based on XMLHttpRequest, which is now supported by all main browsers. The basic idea is quite simple – and not actually a breakthrough – but it allows up
Better Collation Rule Markup: a critique of Locale Definition Markup Language
(GrahamAsher) Unicode, Inc., administers and maintains the Common Locale Data Repository (CLDR), in which are stored XML files containing locale information, including collation tailorings, for many different locales. The format of the XML files is called Locale Data Markup Language (LDML).
Q&A: Making the jump to 64-bit SQL Server 2005
(Adam Machanic) Running SQL Server on a 64-bit platform has been an option to improve database performance and scalability for quite some time, but your configuration options were limited and not without problems. For one thing, SQL Server 2000 could only run on the expensive Itanium line of pro
DB2 UDB: Discover the power of SQL Stored Procedures
Stored procedures are a valuable tool for improving performance in distributed and networked environments. In addition, they can also be used to improve the flexibility and design of your applications. SQL Stored Procedures offer a procedure language that is comparable with stored procedure language
It takes a long time for the SQL Server service to start on a Windows Server 2003-based computer
Consider the following scenario. You are running Microsoft SQL Server 2000 Service Pack 1 (SP1), Microsoft SQL Server 2000 Service Pack 2 (SP2), or Microsoft SQL Server 2000 Service Pack 3 (SP3) on a Microsoft Windows Server 2003-based computer. You try to start the SQL Server service. In this scena