Other News

Community

Smarter Data Warehouses

by Joy Mundy – Few queries and reports perform any calculation fancier than summing or counting, with the occasional ratio thrown in for excitement. Query and reporting tool vendors have done an excellent job of making the simple things easy. They do a nice job of providing functionality that is mis

Community

eData Usage Analyzer

From SQL Power Tools – The demand for global access to corporate information from eCommerce and data warehousing applications will be ever increasing in the years 2000+. Data and application usage patterns exposed by the eData Usage Analyzer reveal how end-users interact with data. The eData Usag

Community

DIDL: Packaging Digital Content

In this article we detail the reasons for undertaking the development of a digital packaging standard and describe in depth a package manifest scheme that potentially addresses the enumerated needs. In doing so, we show how such a scheme effectively disassociates the notion of content item from indi

Community

Practical SQL: The Sequel

From SQL-Server-Performance.com – This book is really interesting, and a bit different from most of the SQL language "how-to" books that I have read in the past. In fact, the book is somewhat hard to describe. Essentially, the book teaches you how to code SQL for the "real world". No

Community

Return of the BLOB

When you're designing and programming databases, images and audio or video clips probably aren't among the first things that you consider storing. However, today's databases often need to store employee photos, product pictures, and the like. Even the ability to play on-demand video clip

Community

XML Through the Wall

by Daniel Nehren – The problem of connecting client-server applications through a firewall has been haunting programmers for a long time. Most of the time, a corporate firewall opens the fewest ports possible. Normally, the only port you will have available is port 80—the one used for the Web.