Pro Active Record helps you take advantage of the full power of your database engine from within your Ruby programs and Rails applications. ActiveRecord, part of the magic that makes the Rails framework so powerful and easy to use, is the model element of Rail's model/view/controller framework. It's an object-relational mapping library enabling you to interact with databases from both Ruby and Rails applications.

Рассмотрена система безопасности Web-серверов и типичные ошибки, совершаемые Web-разработчиками при написании сценариев на языках PHP, ASP и Perl. Приведены примеры взлома реальных Web-сайтов, имеющих уязвимости. В теории и на практике рассмотрены распространенные хакерские атаки: DoS, Include, SQL-инъекции, межсайтовый скриптинг, обход аутентификации и др.
Описаны основные приемы зашиты от атак и рекомендации по написанию безопасного программного кода.

“

Aimed at programmers who are familiar with Visual Basic and who have been exposed to Oracle, this instructional text covers the popular Oracle/Visual Basic client/server combination from beginning to end. The book opens with a lengthy discussion of the unique architecture of Oracle. The author presents the basics of Oracle's components, database administration processes, and database design issues. By the end of this first part, the reader comes away with a solid understanding of Oracle. The second part adequately covers queries and store procedures and introduces the reader to Oracle's PL/SQL. Oracle Programming wraps up with a section on advanced Oracle techniques that includes Oracle Objects for OLE--otherwise known as OO4O. Generous but concise code examples, smart sidebars on real-world implementation, and plenty of architectural diagrams round out this book. --Stephen Plain

”

The rapidly increasing volume of information contained in relational databases places a strain on databases, performance, and maintainability: DBAs are under greater pressure than ever to optimize database structure for system performance and administration. Physical Database Design discusses the concept of how physical structures of databases affect performance, including specific examples, guidelines, and best and worst practices for a variety of DBMSs and configurations. Something as simple as improving the table index design has a profound impact on performance. Every form of relational database, such as Online Transaction Processing (OLTP), Enterprise Resource Management (ERP), Data Mining (DM), or Management Resource Planning (MRP), can be improved using the methods provided in the book.

Add seamless, interactive, user-controlled delivery to your Flash applications. This book builds upon your understanding of basic ActionScript (AS) syntax with the foundational skills that you need to use XML in Flash applications and AS2 or AS3 to migrate your existing applications. Beginning with an introduction to XML, XML parsing methods, and a short introduction to AS2 you learn how to create a universal XML load/onload Class as well as a universal XHTML parser.

* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
* The authors then describe the development processes for building dimensions and cubes from various data sources
* Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
* Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
* The authors then describe the development processes for building dimensions and cubes from various data sources
* Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
* Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

* Written by the lead developers of Analysis Services at Microsoft, this book begins with an overview showing how Analysis Services and MDX can be used to build data warehouses and multidimensional databases
* The authors then describe the development processes for building dimensions and cubes from various data sources
* Demonstrating a variety of techniques in real-world scenarios, the book shows how MDX can be used to query databases to provide sophisticated analysis of business problems
* Finally, the book explains how Analysis Services can be used with other components of SQL Server, including DTS, data mining, and Report Services, to provide comprehensive, end-to-end solutions

“

Get up-and-running on PostgreSQL quickly using this hands-on guide. Filled with real-world examples, PostgreSQL 8 for Windows offers you practical, step-by-step details on installing, configuring, and using PostgreSQL 8--the full-featured, open-source database management system--on Windows platforms. You'll learn to administer, secure, and tune your database and use SQL. You'll also discover how to interface Microsoft Access, Microsoft .NET, Visual C++, and Java with the PostgreSQL database.

”

While building on the skills you already have, Expert SQL Server 2005 Development will help you become an even better developer by focusing on best practices and demonstrating how to design high-performance, maintainable database applications. This book starts by reintroducing the database as a integral part of the software development ecosystem. You'll learn how to think about SQL Server development as you would any other software development. For example, there's no reason you can't architect and test database routines just as you would architect and test application code. And nothing should stop you from implementing the types of exception handling and security rules that are considered so important in other tiers, even if they are usually ignored in the database. You'll learn how to apply development methodologies like these to produce high-quality encryption and SQLCLR solutions. Furthermore, you'll discover how to exploit a variety of tools that SQL Server offers in order to properly use dynamic SQL and to improve concurrency in your applications. Finally, you'll become well versed in implementing spatial and temporal database designs, as well as approaching graph and hierarchy problems.

Pro SQL Server 2005 Service Broker, by Klaus Aschenbrenner, an international expert on Service Broker, explains why Microsoft introduced Service Broker and describes its big advantages over prior message technologies.