|
January , 2005
In
This Issue
|
|
All articles have been reprinted with the written consent of their respective authors. | ||||||||||||||||
|
||||||||||||||||
|
Procedure to Identify SQL Statement Assume the following scenario: The p roduction database is in India. One user is accessing an application from the US. The query he used to execute everyday in 2/3 seconds, is now taking more than a hour since this morning. You, as a DBA, can not get a screenshot of that user's machine. The user is unable to tell you which application he is running, or which SQL query is creating the problem. Solution: From V$SESSION, you can use his machine name to find his session ID (sid). Using that sid, you can use the attached procedure to pull out the SQL statement. Click here
for the script. |
||||||||||||||||
|
||||||||||||||||
|
Data Loading with External Tables This paper shows how Oracle 9i’s new External Tables can significantly improve data loading time for large amounts of data. This paper can be used by Database Administrators, Application Developers, and Project Leaders. Currently, I am working on a project that needs to load a large number of rows on a daily basis. Many on this project want to write an application that performs this load. I am of the opinion that one would be better served to use Oracle’s tools specifically designed to load large amounts of data, rather than write our own application. This paper was written to show the differences between an application loading data from a file compared to Oracle’s built in tools to accomplish the same thing. As we will see, the applications to load the data do not compare to the speed of Oracle’s utilities.
Click here
for the paper. | ||||||||||||||||
|
||||||||||||||||
|
Transparent Encryption and Separation of Duties for Enterprise Databases
Security is becoming one of the most urgent challenges in database research and industry, and there has also been increasing interest in the problem of building accurate data mining models over aggregate data, while protecting privacy at the level of individual records. Instead of building walls around servers or hard drives, a protective layer of encryption is provided around specific sensitive data-items or objects. This prevents outside attacks as well as infiltration from within the server itself. This also allows the security administrator to define which data stored in databases are sensitive and thereby focusing the protection only on the sensitive data, which in turn minimizes the delays or burdens on the system that may occur from other bulk encryption methods. Encryption can provide strong security for data at rest, but developing a database encryption strategy must take many factors into consideration. This paper presents a practical implementation of field level encryption in enterprise database systems, based on research and practical experience from many years of commercial use of cryptography in database security. We use the key concepts of security dictionary, type transparent cryptography and propose solutions on how to transparently store and search encrypted database fields. In this paper we will outline the different strategies for encrypting stored data so you can make the decision that is best to use in each different situation, for each individual field in your database to be able to practically handle different security and operating requirements. Application code and database schemas are sensitive to changes in the data type and data length. The papers presents a policy driven solution that allows transparent data level encryption that does not change the data field type or length. We focus on how to integrate modern cryptography technology into a relational database management system to solve some major security problems.
Click here
for the article. |
||||||||||||||||
|
||||||||||||||||
|
Bulk Bind Operations
Bulk bind operations help to improve the performance of PL/SQL operations.
Oracle 10g introduces two new types of functionality for bulk binds,
including:
Click Here to read more on bulk bind operations. |
||||||||||||||||
|
||||||||||||||||
|
As the winner of the 2004 Microsoft Global ISV of the Year award, we'd like to make you aware of some exciting free training opportunities! Starting in January 2005, Microsoft will deliver a fast-paced week of training with at least 15 free WebCasts and, following, at least 1 WebCast per week focusing on specific developer topics for SQL Server 2005. Go to http://msdn.microsoft.com/SQL/2005Webcasts for all the details.
Everyone who attends a WebCast will receive a copy of the SQL Server 2005 Beta 2 Resource Kit and the Beta 3 Resource Kit when it ships. Also, the first 1500 people that watch 5 or more WebCasts will also receive a special, limited edition SQL Server 2005 WebCast T-shirt. Additionally, all WebCast viewers will be entered into a competition to win an XBOX, one for each day of the week. (see
http://msdn.microsoft.com/SQL/WebcastRules.aspx) | ||||||||||||||||
|
||||||||||||||||
|
Procedural Programming in MySQL - Part 1
This paper looks at the new stored procedure support available in the latest version of MySQL. The document describes how to create functions and procedures, add and use variables, pass parameters in and out, and use the select into command to expand on the basic functions available in MySQL. Part 2 will follow shortly and contain more advanced features such as conditional logic, loops, cursors and exception processing.
Click Here for the paper | ||||||||||||||||
|
||||||||||||||||
In a large project, there may be many people who have some role in the creation and approval of project deliverables. Sometimes this is pretty straightforward, such as one person writing a document and one person approving it. In other cases, there may be many people who have a hand in the creation and others that need to have varying levels of approval.
Click here
for more information | ||||||||||||||||
|
||||||||||||||||
|
Free Webcasts
| ||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
||||||||||||||||
|
Interactive Crossword
Puzzle: Board Games
|
||||||||||||||||
|
||||||||||||||||
|
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 |
||||||||||||||||
