|
May, 2007
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
|||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
How to Setup HSODBC (Oracle9i on Solaris) to MySQL on Linux by Jeff Hunter This article provides step by step instructions for installing and configuring
Oracle's Heterogeneous Services (Oracle9i Release 2) to connect from an Oracle9i
database running on Sun Solaris to MySQL running on a remote Linux machine. This article is divided into the following sections:
Click here for the
article.
|
|
Understanding XML Your company is probably already using it. It’s time to figure out how to manage it. Back in the early 1980s, when I worked as a systems engineer in an IBM branch office, I didn’t use a word processor to create letters, reports, and other items of business documentation (the personal computer was quite new at the time); instead, I used an IBM product called the Document Composition Facility (DCF), which ran on a mainframe server under the Virtual Machine (VM) operating system. More specifically, I used a text formatter, called SCRIPT, that was a component of DCF. Sitting at a “dumb terminal” (the term “thin client” was not yet in vogue), I would enter the text of my document and insert “tags” into the file to control the appearance of the printed document.
Click here
for the article.
Opening the Door to XML DB2 9 offers significant new support for XML, which Java application developers can begin to use with minimal effort. That's because DB2 9 enables programmers to query, insert, update, and delete XML data — as well as traditional SQL data — using familiar JDBC statements and industry-standard query languages. In this article, I'll show you detailed examples of how to use Java to build applications that use DB2's "pureXML" technology, which allows XML to be stored and queried in its inherent hierarchical format.
Click here
for the article.
|
|
Analysis Services 2005 Delivers New Features -- Start to Finish MSAS 2005 introduces Unified Dimensional Model (UDM) – a concept that attempts to use MSAS for reporting as well as analytics. Traditional analytics lack flexibility but they provide faster response time than traditional reports. Traditional reports are flexible, but usually take a long time to generate. Let me elaborate on this idea and show you how it applies to different versions of Analysis Services. Dimensions built with OLAP Services 7.0 or Analysis Services 2000 aggregate data in hierarchical fashion. For example, typical date and time dimensions would show you a breakdown of sales by year, quarter, month, day and perhaps hour. Similarly, a customer's geographical dimension levels would include country, state, county, city, postal code and individual customer name. That type of hierarchical analysis performs very well, but what happens if you want to include some items on the report that don't easily roll up to other levels? For example, customer phone number or email address attributes can't be easily rolled up into this hierarchy and can't be easily reported through such a hierarchical structure. Click here to see the article.
In A Nutshell
Interested in learning more tips and techniques for SQL Server? "In A Nutshell"
is what you are looking for. Kevin Kline,
author of O'Reilly's "SQL in a Nutshell" and "Transact-SQL Programming" and President of The Professional Association for SQL Server,
offers tips, techniques and much more. Updated numerous times a week,
there is always valuable material to be had!
Click
here
to see what Kevin is up to in the SQL Server world.
|
| Understanding the MySQL Falcon Transaction Storage Engine – Part 2 The first thing to understand about transactions and Falcon is that the engine takes a multi-generational approach to managing both transactions and concurrency. This means that the engine keeps multiple iterations/generations of rows available in memory to ensure the highest possible levels of uninterrupted data access. Falcon supports ACID-level transactional operations, which are handled in memory via the record cache. Once in-process transactions are committed, the operations are flushed to the Falcon Log for asynchronous application to the database files. The only exceptions to this rule are new BLOBs, which are immediately applied to the database files. Click here to see this article.
|
|
Outsourcing of project work is more common today than ever. However, even though you outsource the work, you cannot completely outsource your obligation to make sure the project is progressing smoothly. If all goes well with the outsourcer, you do not have much work to do. Unfortunately, in many instances, the outsourcing vendor does not perform against expectations. If that happens, you want to know about it as soon as possible. Click here for more information on managing outsourced projects.
|
| Webcasts
|
|
|
|
Interactive Crossword
Puzzle: "Flags of the World"
|
|
We love getting white papers, tips, articles, and code examples/archives from our readers around the world. Send your submission to newsletter@quest-pipelines.com. If your article is published, it will be mailed to over 28,000 subscribers. Our mission at Quest Software - RevealNet Labs is to anticipate the daily responsibilities and challenges faced by database professionals. Our products help thousands of people solve problems and implement solutions every day. This newsletter is designed to help facilitate the sharing of information among database professionals. About the Newsletter This newsletter is distributed to Quest Software - RevealNet Labs customers, prospects and friends who have subscribed to it from our website. If you would like to unsubscribe, please visit http://qlist01.quest.com/UnsubMailingList/
Do you know someone who would like to receive the Pipeline Newsletter? If so, click here!
Past Issues of the Pipeline Newsletter | |||||||||||||||||||||||||||||||||||||||||||||||||||
Refer a Friend!
