|
March , 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Creating CSV Files from Tables This script is a low cost utility for creating a CSV file from an Oracle Table. It creates a compressed CSV file, the DDL needed to create the table and a sample SQL*Loader control file. It handles most character, number and date datatypes and can easily be modified if needed. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Compressed Composites (Oracle 10g Compression) Explained If you've an interest in the OLAP Option and you've read some of my recent articles on the new features in Oracle 10g OLAP, you've probably seen a feature called "compression" mentioned. In this DBAZine article I described compression as "a novel form of cube compression, which promises to both enhance query performance (by retrieving fewer blocks of data for a given logical amount of data) and drastically reduce batch loading and aggregation times, saving disk space on the way. Compression in Oracle 10g OLAP is more about improving performance and scalability than saving disk space (although that’s a nice side effect). The net result of this is that, in a given batch window, Oracle 10g OLAP can now load and aggregate more data than before, and for a given amount of disk, can store more information than before. This, plus big advances in scalability internally around areas such as very big composites, makes Oracle 10g OLAP potentially a very effective platform when building particularly large cubes." So how does this compression feature actually work?
Click here
for the paper. | ||||||||||||||||
|
||||||||||||||||
|
Crossing Over/ Breaking the DB2 Platform Barrier The popularity of DB2 UDB running on distributed platforms continues to grow. The sudden growth and popularity of DB2 on distributed platforms has resulted in a shortage of experienced non-mainframe DB2 DBAs. IT departments today have to deal with tightening budgets and shrinking staffs. The luxury of being a single platform DBA is becoming a thing of the past. Many DB2 mainframe DBAs find themselves supporting DB2 on these distributed platforms, resulting in a huge learning curve. It is essential for the DB2 DBA of the new millennium to be well versed on running DB2 on multiple platforms.
This white paper is geared toward any DB2 DBA responsible for having to support DB2 on multiple platforms, whether you’re an OS/390 DBA
with little or no knowledge of UNIX/NT or a UNIX DBA with little or no knowledge of OS/390. It will cover some of the basic terminology for the
different platforms, and how they differ, as well as the key architectural differences and administrative issues.
Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Translating Procedural Statements Between Oracle and SQL Server This white paper is intended to give you a QUICK but thorough overview of the issues you may encounter when translating procedural code, such as stored procedures oruser-defined functions, between Oracle’s PL/SQL and Microsoft SQL Server’s Transact-SQL procedural extensions to the ANSI SQL standard. The document should be equally useful for SQL Server DBAs and developers who need to become familiar with PL/SQL, as for Oracle DBAs and developers who want to get up to speed quickly on Transact-SQL.
Click Here for the paper. | ||||||||||||||||
|
||||||||||||||||
When you are building the network diagram, you will find that all of the activities in the work breakdown structure are related to at least one other activity. In many cases, the relationships will involve more than two activities. The most common precedence relationship is when one activity cannot start until another activity has finished. This is referred to as a Finish-to-Start relationship. However, there are four ways that one or more activities can be related to another one. Click here for more information on precedence relationships. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "3"
|
||||||||||||||||
|
||||||||||||||||
|
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/ Subscribe a Friend! Do you know someone who would like to receive the Pipeline Newsletter? If so, please enter their email address in the box below and click SUBMIT.
Past Issues of the Pipeline Newsletter |
||||||||||||||||
