|
March, 2006
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Auditing in XML by Arup Nanda One of the cornerstones of the security infrastructure in Oracle Database is accountability—the ability to record who did what. Oracle Database 10g provides auditing to record the activities of users in the database. When the activities occur (for example, a user updates a certain table), the database records the facts in the audit trails, which can be in the database in a special table called AUD$ in the SYS schema or in special files in the operating system (OS). When stored in the database, audit trail data is protected by database backups, and it is easy for a DBA to query it by using standard SQL. However, with this data in the database, anyone with access to the SYS schema can potentially erase the audit trail after perpetrating a malicious update.
Click here
for the article. | ||||||||||||||||
|
||||||||||||||||
|
Firing Up The Hybrid Engine IBM's new hybrid DB2 puts the full power of a relational engine to work on a truly native XML store that sits side by side with DB2's relational data repository. Relational databases drive most businesses of any size today. Popular and important as these databases are, they're simply not a great match for semi-structured (and hierarchical) content represented in XML. Because enterprises have, in aggregate, trillions of dollars invested in relational data and relational database management systems (RDBMSs), simply replacing RDBMSs with a pure XML store isn't an option. Adding an XML-only database into the infrastructure adds yet another integration and complexity challenge.
Click here
for the article.
|
||||||||||||||||
|
||||||||||||||||
|
Outer Join Trouble Recently someone sent me a note about an issue with an outer join. I'd run into a similar situation before and thought that I'm sure others have as well, especially as more and more people move to outer ANSI style joins. For those of you still writing queries like this: select c.customerid, o.orderid from orders o, customers c where o.customerid = c.customerid you probably won't have this same type of problem, but those styles of queries are difficult to read, especially as you get 4 or 5 tables in there and implement any type of outer join. Click here for 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. | ||||||||||||||||
|
||||||||||||||||
|
What are the MySQL Privilege Tables? The privilege tables are used by the MySQL Privilege System to authenticate a user connecting from a given host, and to associate that user with privileges on a database such as select, insert, update, and delete. Additional functionality includes the ability to have an anonymous user and to grant privileges for MySQL-specific functions such as LOAD DATA INFILE and administrative operations. The privilege tables are core to MySQL in order to perform the functions of it's privilege system. The privilege tables are created by running the script mysql_install_db and created in a special database called mysql. The following is a brief overview of the privilege tables in the mysql database.
Click here for the article. | ||||||||||||||||
|
||||||||||||||||
There are different levels of estimating accuracy that are normally expected from the project manager (or project team) depending when the estimate is requested. When the project is first being proposed, for instance, your client may ask you for a high-level estimate of effort, cost and duration. The project is vague at this point and so the resulting estimate is going to be vague as well. In many cases, the estimate is only used for sizing purposes so that the originator has an understanding of whether the work will take 1000 hours or 100,000 hours. This estimate is a Rough Order of Magnitude (ROM) estimate and might be in the range of -25% to 75%. In other words, if the preliminary estimate of work was 1000 hours, you could propose the ROM estimate as 750-1750 hours. In fact, at this point, you might even be 100% off, or even higher.
Click
here for more information about accurate estimates. | ||||||||||||||||
|
||||||||||||||||
|
Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: "Name that Artist"
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
