Scott W. Ambler, Pramodkumar J. Sadalage, «Refactoring Databases: Evolutionary Database Design»Addison-Wesley Professional ISBN 0321293533 2006 Year CHM 3,36 Mb 384 Pages
“
Refactoring has proven its value in a wide range of development projects–helping software professionals improve system designs, maintainability, extensibility, and performance. Now, for the first time, leading agile methodologist Scott Ambler and renowned consultant Pramodkumar Sadalage introduce powerful refactoring techniques specifically designed for database systems.Ambler and Sadalage demonstrate how small changes to table structures, data, stored procedures, and triggers can significantly enhance virtually any database design–without changing semantics. You’ll learn how to evolve database schemas in step with source code–and become far more effective in projects relying on iterative, agile methodologies.This comprehensive guide and reference helps you overcome the practical obstacles to refactoring real-world databases by covering every fundamental concept underlying database refactoring. Using start-to-finish examples, the authors walk you through refactoring simple standalone database applications as well as sophisticated multi-application scenarios. You’ll master every task involved in refactoring database schemas, and discover best practices for deploying refactorings in even the most complex production environments. The second half of this book systematically covers five major categories of database refactorings. You’ll learn how to use refactoring to enhance database structure, data quality, and referential integrity; and how to refactor both architectures and methods. This book provides an extensive set of examples built with Oracle and Java and easily adaptable for other languages, such as C#, C++, or VB.NET, and other databases, such as DB2, SQL Server, MySQL, and Sybase.Using this book’s techniques and examples, you can reduce waste, rework, risk, and cost–and build database systems capable of evolving smoothly, far into the future.
http://rapidshare.de/files/36488027/SWAmbler.rar.html
http://depositfiles.com/files/312550
Monday, November 19, 2007
Backup & Recovery by W. Curtis Preston
Backup & Recovery by W. Curtis PrestonPublisher: O'Reilly Media (December 1, 2006) ISBN-10: 0596102461 CHM 3 Mb 760 pages
Packed with practical, freely-available backup and recovery solutions for Unix, Linux, Windows and Mac OS X systems -- as well as various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revised and expanded with over 75% new material. Backup & Recovery starts with a complete overview of backup philosophy and design, including the basic backup utilities of tar, dump, cpio, ntbackup, ditto, and rsync. It then explains several open source backup products that automate backups using those utilities, including AMANDA, Bacula, BackupPC, rdiff-backup, and rsnapshot. Backup & Recovery then explains how to perform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris, VMWare, & Windows systems using freely-available utilities. The book also provides overviews of the current state of the commercial backup software and hardware market, including overviews of CDP, Data De-duplication, D2D2T, and VTL technology. Finally, it covers how to automate the backups of DB2, Exchange, MySQL, Oracle, PostgreSQL, SQL-Server, and Sybase databases - without purchasing a commercial backup product to do so. For environments of all sizes and budgets, this unique book shows you how to ensure data protection without resorting to expensive commercial solutions. You will soon learn to:— Automate the backup of popular databases without a commercial utility — Perform bare metal recovery of any popular open systems platform, including your PC or laptop — Utilize valuable but often unknown open source backup products — Understand the state of commercial backup software, including explanations of CDP and data de-duplication software — Access the current state of backup hardware, including Virtual Tape Libraries (VTLs)
http://depositfiles.com/files/518466
http://rapidshare.com/files/11240581/OReilly.BR.rar
Packed with practical, freely-available backup and recovery solutions for Unix, Linux, Windows and Mac OS X systems -- as well as various databases -- this new guide is a complete overhaul of Unix Backup & Recovery by the same author, now revised and expanded with over 75% new material. Backup & Recovery starts with a complete overview of backup philosophy and design, including the basic backup utilities of tar, dump, cpio, ntbackup, ditto, and rsync. It then explains several open source backup products that automate backups using those utilities, including AMANDA, Bacula, BackupPC, rdiff-backup, and rsnapshot. Backup & Recovery then explains how to perform bare metal recovery of AIX, HP-UX, Linux, Mac OS, Solaris, VMWare, & Windows systems using freely-available utilities. The book also provides overviews of the current state of the commercial backup software and hardware market, including overviews of CDP, Data De-duplication, D2D2T, and VTL technology. Finally, it covers how to automate the backups of DB2, Exchange, MySQL, Oracle, PostgreSQL, SQL-Server, and Sybase databases - without purchasing a commercial backup product to do so. For environments of all sizes and budgets, this unique book shows you how to ensure data protection without resorting to expensive commercial solutions. You will soon learn to:— Automate the backup of popular databases without a commercial utility — Perform bare metal recovery of any popular open systems platform, including your PC or laptop — Utilize valuable but often unknown open source backup products — Understand the state of commercial backup software, including explanations of CDP and data de-duplication software — Access the current state of backup hardware, including Virtual Tape Libraries (VTLs)
http://depositfiles.com/files/518466
http://rapidshare.com/files/11240581/OReilly.BR.rar
Oracle 11i E-Business Suite From the Front Lines
http://www.megaupload.com/?d=15DJCA0P
Password=http://blueportal.org
Password=http://blueportal.org
Gavin Powell, «Beginning XML Databases»
Publisher: Wrox Press Nov 2006 ISBN: 0471791202 Pages: 490 Format: CHM Size: 22.1 MB
The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.You'll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.What you will learn from this bookThe platform independence capability that comes from using XML— including independence from database vendorsThe basics of XML, XSL, the XML DOM, and SQLXML datatypes and features in Oracle Database and SQL ServerHow to move data anywhere using XML (B2B)Ways to read XML documents using XQuery and navigate documents using XPathXML, the object data model, native XML databases, and industry applications of XMLWho this book is forThis book is for anyone—from novice to expert—who is interested in learning the details of XML and database technology as applied to both XML and relational database technology, working together.
http://fileho.com/download/f659a1341515/Wrox.Beginning.XML.Databases.ebook-Spy.chm.html
http://depositfiles.com/files/508573
http://rapidshare.com/files/10737931/0471791202.rar
The union of XML and relational databases creates a powerful tool with the ability to transfer information between two completely unrelated databases. With this book, veteran author Gavin Powell shows you how this confluence of two technologies can simplify your database work and provide a more standardized way to exchange data between multiple databases and web sites.You'll get an in-depth look at specific XML datatypes that are considered the most critical alliances between XML and a relational database. Plus, an introduction to the basics of SQL and numerous XML standards prove to be essential so that you can grasp database structure and comprehend how XML is used with the Oracle and SQL Server relational databases. Throughout the book, valuable exercises and a surfeit of step-by-step examples will help you get an overall understanding of the topics at hand.What you will learn from this bookThe platform independence capability that comes from using XML— including independence from database vendorsThe basics of XML, XSL, the XML DOM, and SQLXML datatypes and features in Oracle Database and SQL ServerHow to move data anywhere using XML (B2B)Ways to read XML documents using XQuery and navigate documents using XPathXML, the object data model, native XML databases, and industry applications of XMLWho this book is forThis book is for anyone—from novice to expert—who is interested in learning the details of XML and database technology as applied to both XML and relational database technology, working together.
http://fileho.com/download/f659a1341515/Wrox.Beginning.XML.Databases.ebook-Spy.chm.html
http://depositfiles.com/files/508573
http://rapidshare.com/files/10737931/0471791202.rar
Beginning PL/SQL: From Novice to Professional
Donald Bales , "Beginning PL/SQL: From Novice to Professional "Apress (August 24, 2007) ISBN: 1590598822 476 pages PDF 5,5 Mb
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.What you'll learnHow important SQL is in PL/SQLHow to use PL/SQL in both a relational and object-relational settingHow to create maintainable, modular, and reusable PL/SQL program unitsThe importance of testing as you go, and of building a permanent test plan for each moduleThe importance of building debugging capabilities into your code and building a permanent debug facility for each moduleThe importance of documenting as you go, and in the process building a permanent documentation set for your reusable modulesHow to apply modular PL/SQL to solve real-world problemsWho is this book for?Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
http://depositfiles.com/files/2175989
http://rapidshare.com/files/65486766/Beginning_PLSQL_From_Novice_to_Professional_with_SOURCE_CODE-1590598822.rar
Get started with PL/SQL, the built-in language that every Oracle developer and database administrator must know, in Beginning PL/SQL, a fast-paced and example-filled tutorial. Learn from author Don Bales' extensive experience to discover the most commonly used aspects of PL/SQL without wasting time with obscure and obsolete features. Author Don Bales takes his 20+ years of experience and a wealth of statistics he's gathered on PL/SQL usage over those years and applies the 80/20 rule -- cover what's most needed and used by PL/SQL professionals and avoid what's not necessary! The result is a book that covers all the key features of PL/SQL without wasting your time discussing esoteric and obsolete parts of the language. Learn what really matters, so that you can get to work feeling confident with what you know about PL/SQL.Discover the 20% of PL/SQL that gives you 80% of the bang--key topics covered include variables and datatypes, executing statements, working with cursors, real-world objects, debugging, testing, and more.Learn how to write production-level, object-oriented PL/SQL--you'll explore relational PL/SQL, but unlike most other books on the subject, Don Bales emphasizes the use of PL/SQL's object-oriented features as well.Work through real examples of using of PL/SQL--you'll learn PL/SQL by applying it to real-world business problems, not by heavy theory.What you'll learnHow important SQL is in PL/SQLHow to use PL/SQL in both a relational and object-relational settingHow to create maintainable, modular, and reusable PL/SQL program unitsThe importance of testing as you go, and of building a permanent test plan for each moduleThe importance of building debugging capabilities into your code and building a permanent debug facility for each moduleThe importance of documenting as you go, and in the process building a permanent documentation set for your reusable modulesHow to apply modular PL/SQL to solve real-world problemsWho is this book for?Anyone who wants to learn how to create stored procedures against an Oracle database using PL/SQL. Programmers developing applications to be deployed against an Oracle database will need PL/SQL to take full advantage of the power Oracle has to offer. Database administrators who wish to implement functionality exposed only via PL/SQL package interfaces will also find this book useful.
http://depositfiles.com/files/2175989
http://rapidshare.com/files/65486766/Beginning_PLSQL_From_Novice_to_Professional_with_SOURCE_CODE-1590598822.rar
Oracle9iR2 Data Warehousing
Oracle9iR2 Data WarehousingDigital Press ISBN: 1555582877 519 pages February 6, 2003 CHM 17 Mb"By using Oracle 9i, pre-summarizing data, and storing it in materialized views, reports that used to take 2 hours to run now complete in 2 minutes."
http://ebook.icefile.org/index.php?page=main&id=0c83a412&name=1555582877.rar
http://ebook.icefile.org/index.php?page=main&id=0c83a412&name=1555582877.rar
SQL Hacks [ILLUSTRATED]
SQL Hacks386 pages O'Reilly Media (November 2006) English 0596527993 2.0 MB
Book Description
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:* Wrangle data in the most efficient way possible* Aggregate and organize your data for meaningful and accurate reporting* Make the most of subqueries, joins, and unions* Stay on top of the performance of your queries and the server that runs them* Avoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.Why SQL Hacks?The term hacking has a bad reputation in the press. They use it to refer to people who break into systems or wreak havoc with computers as their weapon. Among people who write code, though, the term hack refers to a "quick-and-dirty" solution to a problem, or a clever way to get something done. And the term hacker is taken very much as a compliment, referring to someone as being creative, having the technical chops to get things done. The Hacks series is an attempt to reclaim the word, document the good ways people are hacking, and pass the hacker ethic of creative participation on to the uninitiated. Seeing how others approach systems and problems is often the quickest way to learn about a new technology. This book is a collection of 100 different hacks. Each hack involves a specific problem that you may have already seen before, but perhaps tackled in a way you wouldn't have considered. The hacks range from solving simple, everyday problems, all the way to tackling complex data processing scenarios. Each hack may concentrate on a particular scenario, but you should be able to adapt them to a wide range of problems specific to your own challenges. Some of these hacks will leave you thinking, "I guess that's one way to do it; thanks, but no thanks." However, we hope that most will make you say, "Wow...I didn't know SQL could do that." You should also be questioning the balance between SQL and your programming language. With a bit more understanding of SQL you can do more processing at the database, and as a result have less traffic between the database and your application. Nine times out of ten this approach is going to be faster and better. It's all about letting your program do the things it's good at, and letting the database do the things it's good at.
http://rapidshare.com/files/10771137/OReilly.SQL.Hacks.Nov.2006.rar
http://depositfiles.com/files/509858
http://ebook.icefile.org/index.php?page=main&id=0cd092155&name=0596527993.rar
Book Description
Whether you're running Access, MySQL, SQL Server, Oracle, or PostgreSQL, this book will help you push the limits of traditional SQL to squeeze data effectively from your database. The book offers 100 hacks -- unique tips and tools -- that bring you the knowledge of experts who apply what they know in the real world to help you take full advantage of the expressive power of SQL. You'll find practical techniques to address complex data manipulation problems. Learn how to:* Wrangle data in the most efficient way possible* Aggregate and organize your data for meaningful and accurate reporting* Make the most of subqueries, joins, and unions* Stay on top of the performance of your queries and the server that runs them* Avoid common SQL security pitfalls, including the dreaded SQL injection attackLet SQL Hacks serve as your toolbox for digging up and manipulating data. If you love to tinker and optimize, SQL is the perfect technology and SQL Hacks is the must-have book for you.Why SQL Hacks?The term hacking has a bad reputation in the press. They use it to refer to people who break into systems or wreak havoc with computers as their weapon. Among people who write code, though, the term hack refers to a "quick-and-dirty" solution to a problem, or a clever way to get something done. And the term hacker is taken very much as a compliment, referring to someone as being creative, having the technical chops to get things done. The Hacks series is an attempt to reclaim the word, document the good ways people are hacking, and pass the hacker ethic of creative participation on to the uninitiated. Seeing how others approach systems and problems is often the quickest way to learn about a new technology. This book is a collection of 100 different hacks. Each hack involves a specific problem that you may have already seen before, but perhaps tackled in a way you wouldn't have considered. The hacks range from solving simple, everyday problems, all the way to tackling complex data processing scenarios. Each hack may concentrate on a particular scenario, but you should be able to adapt them to a wide range of problems specific to your own challenges. Some of these hacks will leave you thinking, "I guess that's one way to do it; thanks, but no thanks." However, we hope that most will make you say, "Wow...I didn't know SQL could do that." You should also be questioning the balance between SQL and your programming language. With a bit more understanding of SQL you can do more processing at the database, and as a result have less traffic between the database and your application. Nine times out of ten this approach is going to be faster and better. It's all about letting your program do the things it's good at, and letting the database do the things it's good at.
http://rapidshare.com/files/10771137/OReilly.SQL.Hacks.Nov.2006.rar
http://depositfiles.com/files/509858
http://ebook.icefile.org/index.php?page=main&id=0cd092155&name=0596527993.rar
Subscribe to:
Posts (Atom)
