COMP_DB
Oracle数据库性能优化 豆瓣
作者: 盖国强 人民邮电出版社 2005 - 6
本书面向实际应用,从多个角度出发,对Oracle优化中的很多关键问题进行了深入全面的探讨,涵盖了Oracle优化的各个技术层面,从内存优化、IO规划及优化,到SQL优化调整,以较为完整的体系阐述了Oracle的优化技术。
本书给出了大量取自实际工作现场的实例。在分析实例的过程中,兼顾深度与广度,不仅对实际问题的现象、产生原因和相关的原理进行了深入浅出的讲解,更主要的是,结合实际应用环境,提供了一系列解决问题的思路和方法,包括详细的操作步骤,具有很强的实战性和可操作性,满足面向实际应用的读者需求。
2008年6月1日 已读
Oracle 知识更新比较快,以前学的调优知识可能已经用不上了...不过经验还是一样的...
CHS COMP_DB DEV
PostgreSQL 数据库内核分析 豆瓣
作者: 彭智勇 / 彭煜玮 机械工业出版社华章公司 2012 - 1
PostgreSQL是目前广泛应用的开源数据库管理系统。本书从PostgreSQL数据库的源代码入手,深入分析了该数据库管理系统的底层实现细节,揭示了数据库运行的基本原理。本书的主要内容包括:PostgreSQL数据库的体系结构、 存储管理、索引机制、查询编译、查询执行、并发控制机制以及安全等。每个主题都引用了大量的数据结构、图表等进行说明,使读者对实现过程和机理一目了然。
本书适合从事数据库领域相关研究的技术人员、高等院校相关专业高年级本科生或研究生阅读,有助于读者进行数据库的高级开发、基于PostgreSQL定制满足需求的数据库系统,或者在数据库内核中实现并验证数据库新技术。
SQL反模式 豆瓣 Goodreads
SQL Antipatterns: Avoiding the Pitfalls of Database Programming
9.0 (6 个评分) 作者: [美] Bill Karwin 译者: 谭振林 / Push Chen 人民邮电出版社 2011 - 9
《SQL反模式》是一本广受好评的SQL图书。它介绍了如何避免在SQL的使用和开发中陷入一些常见却经常被忽略的误区。它通过讲述各种具体的案例,以及开发人员和使用人员在面对这些案例时经常采用的错误解决方案,来介绍如何识别、利用这些陷阱,以及面对问题时正确的解决手段。另外,《SQL反模式》还涉及了SQL的各级范式和针对它们的正确理解。
《SQL反模式》适合SQL数据库开发人员与管理人员阅读。
NoSQL精粹 豆瓣
NoSQL Distilled
8.8 (5 个评分) 作者: [美]Pramod J. Sadalage / [美]Martin Fowler 译者: 爱飞翔 机械工业出版社 2013 - 8
《NoSQL精粹》为考虑是否可以使用和如何使用NoSQL数据库的企业提供了可靠的决策依据。它由世界级软件开发大师和软件开发“教父”Martin Fowler与Jolt生产效率大奖图书作者Pramod J. Sadalage共同撰写。书中全方位比较了关系型数据库与NoSQL数据库的异同;分别以Riak、MongoDB、Cassandra和Neo4J为代表,详细讲解了键值数据库、文档数据库、列族数据库和图数据库这4大类NoSQL数据库的优劣势、用法和适用场合;深入探讨了实现NoSQL数据库系统的各种细节,以及与关系型数据库的混用。
全书分为两部分,共15章:第一部分(第1~7章)主要讲述NoSQL的核心概念。其中第1章解释了NoSQL发展迅速的原因;第2章描述了在NoSQL领域的三种主要的数据模型中如何体现“聚合”这一概念;第3章介绍了聚合的缺点;第4章描述了数据库如何在集群中分布数据;第5章论及了更新与读取操作对一致性的影响;第6章讨论了版本戳;第7章描述了适合用在NoSQL系统中的“映射-化简”操作。第二部分(第8~15章)讲述了如何实现NoSQL数据库系统。其中第8章~第11章每章各以一种NoSQL数据库为例,演示了如何实现第一部分介绍的概念;第12章解释了数据如何在强模式系统与无模式系统之间迁移;第13章着眼于混合持久化领域的趋势;第14章探讨了在混合持久化领域中会考虑到的其他一些技术;第15章提供了选择数据库时可以参考的一些建议。
SQLite权威指南 豆瓣
The Definitive Guide to SQLite
作者: Grant Allen / Mike Owens 译者: 杨谦 / 刘义宣 电子工业出版社 2012 - 1
这是一本关于sqlite 起源、特性、简介、使用、深度解析的书。
《sqlite权威指南(第二版)》首先从 sqlite 最初起源、特性、设计理念、实际应用讲解开始,逐步深入、全面地介绍了在各个平台如何使用sqlite。接着,介绍sqlite 的一般sql 和高级功能的sql,采取举例说明,使得本书内容生动有趣。然后,全面介绍了各种语言如何与sqlite 进行编程交互,重点介绍sqlite 原生语言c 语言中的api,使得使用者可以不管扩展sqlite 的功能。本书还介绍了目前火热的ios 和android 开发中如何使用sqlite,并给出实际例子。最后,介绍了sqlite 内部架构设计,使得读者可以深入理解sqlite,高级开发者可以进一步参与sqlite 开发或者开发自己的sqlite。
不管您是 sqlite 的初学者,还是sqlite 资深用户或者是对sql 语言和程序设计感兴趣的技术爱好者,都可以从本书汲取营养。
Understanding MySQL Internals 豆瓣
作者: Sasha Pachev O'Reilly Media 2007 - 4
Although MySQL's source code is open in the sense of being publicly available, it's essentially closed to you if you don't understand it. In this book, Sasha Pachev - a former member of the MySQL Development Team - provides a comprehensive tour of MySQL 5 that shows you how to figure out the inner workings of this powerful database. You'll go right to heart of the database to learn how data structures and convenience functions operate, how to add new storage engines and configuration options, and much more. The core of "Understanding MySQL Internals" begins with an Architecture Overview that provides a brief introduction of how the different components of MySQL work together. You then learn the steps for setting up a working compilable copy of the code that you can change and test at your pleasure. Other sections of the book cover: core server classes, structures, and API; the communication protocol between the client and the server; configuration variables, the controls of the server; includes a tutorial on how to add your own; thread-based request handling - understanding threads and how they are used in MySQL; an overview of MySQL storage engines; the storage engine interface for integrating third-party storage engines; the table lock manager; the parser and optimizer for improving MySQL's performance; integrating a transactional storage engine into MySQL; and the internals of replication. "Understanding MySQL Internals" provides unprecedented opportunities for developers, DBAs, database application programmers, IT departments, software vendors, and computer science students to learn about the inner workings of this enterprise-proven database. With this book, you will soon reach a new level of comprehension regarding database development that will enable you to accomplish your goals. It's your guide to discovering and improving a great database.
MySQL Stored Procedure Programming 豆瓣
作者: Guy Harrison / Steven Feuerstein O'Reilly Media 2006 - 4
The implementation of stored procedures in MySQL 5.0 a huge milestone - one that is expected to lead to widespread enterprise adoption of the already extremely popular MySQL database. If you are serious about building the web-based database applications of the future, you need to get up to speed quickly on how stored procedures work - and how to build them the right way. This book, destined to be the bible of stored procedure development, is a resource that no real MySQL programmer can afford to do without. In the decade since MySQL burst on the scene, it has become the dominant open source database, with capabilities and performance rivaling those of commercial RDBMS offerings like Oracle and SQL Server. Along with Linux and PHP, MySQL is at the heart of millions of applications. And now, with support for stored procedures, functions, and triggers in MySQL 5.0, MySQL offers the programming power needed for true enterprise use. MySQL's new procedural language has a straightforward syntax, making it easy to write simple programs. But it's not so easy to write secure, easily maintained, high-performance, and bug-free programs. Few in the MySQL world have substantial experience yet with stored procedures, but Guy Harrison and Steven Feuerstein have decades of combined expertise. In "MySQL Stored Procedure Programming", they put that hard-won experience to good use. Packed with code examples and covering everything from language basics to application building to advanced tuning and best practices, this highly readable book is the one-stop guide to MySQL development. It consists of four major sections: MySQL stored programming fundamentals - tutorial, basic statements, SQL in stored programs, and error handling; Building MySQL stored programs - transaction handling, built-in functions, stored functions, and triggers; MySQL stored programs in applications - using stored programs with PHP, Java, Perl, Python, and .NET (C# and VB.NET); and, Optimizing MySQL stored programs - security, basic and advanced SQL tuning, optimizing stored program code, and programming best practices. A companion web site contains many thousands of lines of code, that you can put to use immediately. Guy Harrison is Chief Architect of Database Solutions at Quest Software and a frequent speaker and writer on MySQL topics. Steven Feuerstein is the author of "Oracle PL/SQL Programming", the classic reference for Oracle stored programming for more than ten years. Both have decades of experience as database developers, and between them they have authored a dozen books.