(Micah Dubinko) I switched to Mac OS X two PowerBooks ago and haven’t looked back. Steve Jobs-era Apple has a consistent record of shipping beautiful pieces of both hardware and software. Increasingly, Apple is exerting broad influence outside of the company itself. This week’s column examines some
Other News
Beyond Monitoring – Measuring the effectiveness of a Data Warehouse – I
(Soumendra Mohanty) Successful measurement is the key to warehouse quality and effectiveness. In Part-1 of this article, the author discusses different types of metrics that help assess whether a data warehouse meets user requirements.
Learning PHP, Part 2
(Tyler Anderson and Nicholas Chase) This tutorial is Part 2 of a three-part series that takes you from the most basic PHP script to working with databases and streaming from the file system by documenting the building of a document workflow system. Here, documents are uploaded by users and stored in
Build an Embedded Array Language in Java
(Greg Travis) It’s really not surprising that the first “killer app” in the world of personal computing was the spreadsheet. After all, a table filled with numbers is one of the simplest and most useful metaphors for displaying and analyzing data.
Class and Object Diagrams (Chapter Excerpt)
(Kendall Scott) This article will teach you about UML structural diagrams, used to help you keep track of the structure of your models.
The TextData column is empty when you use SQL Profiler to capture SQL Server traces in SQL Server 2000
In Microsoft SQL Server 2000, when you use SQL Profiler to capture SQL Server traces, you may notice that the TextData column is empty for the following events: • SP:StmtStarting • SP:StmtCompleted • SQL:StmtStarting • SQL:StmtCompleted
Efficient Space Management
(Aradhana Puri) Oracle Database 10g provides a variety of features for managing the space usage of a tablespace. These features include the monitoring of tablespace usage, the ability to suspend transactions that require more space and successfully resume them when the space is available, and a data
Introduction to the Unified Dimensional Model (UDM)
(Paul Sanders) This paper provides an introduction to the Unified Dimensional Model (UDM), including the basic end-user model, and a brief overview of the architecture and security models.
Adoption of LAMP Stack Improves Performance and Lowers TCO for Web and Data Warehouse Applications
The paper will illustrate how MySQL can help lower financial services organizations? total cost of ownership (TCO) in deploying an open software stack while allowing them to expand existing businesses, develop new products, and comply with an ever-growing number of regulatory and statutory requireme
SQL and Database Design for web development – Chapter IV
(Sérgio Fontes) In this series of articles I want to analyze and describe database and query development for web solutions, as development technology we will use SQL and Microsoft SQL Server 2000 as the database engine. After making a small trip on the SQL basics we are read to take a look on T-SQL