The Definitive Guide to SQLite
Apress | ISBN 1590596730 | 2006 Year | 464 Pages | PDF | English | 5.7 Mb
The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database.
| “ |
Book Description
Traditional relational databases and embedded databases both have shortcomings that can leave a developer perplexed. So for many people, the solution resides in SQLite, an open source embeddable database with an amazingly small footprint (less than 250 kilobytes). SQLite packs a powerful array of features and can handle databases as large as 2 terabytes. It offers a flexible set of datatypes and the ability to perform transactions, and it is supported by languages like C, PHP, Perl, and Python. And because SQLite’s databases are completely file based, privileges are granted at the operating system level, allowing for easy and fast user management.
The Definitive Guide to SQLite is the first book to devote complete coverage to the latest version of this powerful database. It offers you a thorough overview of SQLite capabilities and APIs, while remaining cognizant of newcomers who may be making their first foray into a database environment with SQLite. This book serves as both a first-time tutorial and future reference guide.
You’ll learn about SQLite extensions available for C, Java, Perl, PHP, Python, Ruby, and Tcl.
The book thoroughly covers SQLite internals to help you take full advantage of its features while minimally impacting resource consumption.
Author Mike Owens is the original creator of Pysqlite, the popular Python extension for SQLite.
About the Author
Mike Owens is the IT director for a major real estate firm in Fort Worth, Texas, where he’s charged with the development and management of the company’s core systems. His prior experience includes time spent at Oak Ridge National Laboratory as a process design engineer, and at Nova Information Systems as a C++ programmer. He is the original creator of Pysqlite, the Python extension for SQLite. Mike earned his bachelor’s degree in chemical engineering from the University of Tennessee in Knoxville. |
” |
Source: http://www.amazon.com/exec/obidos/tg/detail/-/1590596730/
Download: http://rapidshare.com/files/1468469/05.2006.rar
七月 14th, 2009 in
Database/SQL | tags:
sqlite |
No Comments
Pro SQL Server 2005 Integration Services
Apress | December 19, 2007 | ISBN:1590598970 | 548 pages | PDF | 11 Mb
SQL Server Integration Services is groundbreaking. It exists for both the DBA and the developer, as well as that new role SSIS has created between the two–the data artisan.
Pro SQL Server 2005 Integration Services contains everything you could ever hope to know about this exciting new development from Microsoft: developer insight, Microsoft group manager–level access, personal experience of using the technology in the real-world, and fine-grained analysis. If you want to rapidly gain knowledge and context from your data, Microsoft’s latest and greatest interpretation of Enterprise Application Integration, SQL Server Integration Services, is for you. As part of the extensive SQL Server suite, Integration Services is a more serious and expandable interpretation of the integration paradigm than previously available. At once both simple to use yet incredibly complex, it goes far beyond being a reimagining and reengineering of DTS, and it’s all presented in a familiar Visual Studio context. It’s Agile, it’s service-oriented, it’s everything to everyone.
Written for the developer, the DBA, and the data artisan, Pro SQL Server 2005 Integration Services will show you how to develop and deploy enterprise SSIS solutions in multibillion-item environments. It’s everything SSIS, explained for everyone!
What you’ll learn
Understand how to develop and deploy SSIS solutions that will perform in multibillion-item environments from an author who has been there and done it.
Build bespoke custom components tailored to your project’s exact requirements.
Create perfomant and scalable solutions with an eye to future requirements and upgrades.
Who is this book for?
This book is for anyone working with SQL Server who has an interest in the Integration Services technology. Deep experience of SQL Server 2005 is not expected, however, you should be comfortable with fundamental techniques.
About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard-won solutions to problems you will face in your professional programming career.
Download :
Sujoy Paul “Pro SQL Server 2008 Replication”
Apress | English | 2009-06-15 | ISBN: 143021807X | 936 pages | PDF | 47,7 MB
Pro SQL Server 2008 Replication is for MS database developers and administrators who want to learn about the different types of replication and those best suited to SQL Server 2008. This book will also cover advanced topics like replication with heterogeneous databases, backup and recovery of replicated databases, database mirroring with replication, log shipping with replication, troubleshooting, plus optimization and tuning. Tools like tablediff, SQLCMD, DTA, SQL Profiler, and Replication Monitor will be discussed to demonstrate the different techniques used in monitoring, administering, and troubleshooting replication.
? Examines the detailed configuration and the internal workings of the different replication types using real–life scenarios
? Covers replication with database mirroring and troubleshooting
? Discusses replication administration using different tools
What you’ll learn
? Configure hierarchical replication: snapshot, transactional and merge, and heterogeneous replication using real–life scenarios.
? Gain insight into the internal workings of the different replication types.
? Master the usage of different tools like tablediff, SQLCMD, DTA, and Replication Monitor in administering replication.
? Perform administration tasks such as backup and recovery, and manage replication with other high–availability techniques like database mirroring and log shipping.
? Conduct optimization and tuning of replicated databases.
? Develop troubleshooting techniques.
Who is this book for?
This book is a comprehensive guide for experienced users of SQL Server as well as new users. It also aims at familiarizing the current users of SQL Server 2005 with the new features of replication should they upgrade to SQL Server 2008. This book will delve into the basics of replication like the publisher–subscriber model, the different replication types (such as snapshot, transactional, merge, and heterogeneous), the corresponding architecture, implementation, and administration. Database administration tasks like backup and recovery, managing replication with high–availability techniques like database mirroring, log shipping with replication, optimization of replicated databases, and troubleshooting techniques will also be discussed. This book will benefit primarily novice and intermediate users by introducing replication and the different processes and then building on the basics to develop and address the advanced features of replication. This is a must–have companion book that will help you in developing, administering and mastering the intricacies of replication.
About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
Brian Paulen, “Pro SQL Server 2008 Analytics: Delivering Sales and Marketing Dashboards”
Apress | 2009 | ISBN: 1430219289 | 300 pages | PDF | 12 MB
Pro SQL Server 2008 Analytics provides everything you need to know to develop sophisticated and visually appealing sales and marketing dashboards using SQL Server 2008 and to integrate those dashboards with SharePoint, PerformancePoint, and other key Microsoft technologies.
The book begins by addressing the many misconceptions that surround the use of Key Performance Indicators (KPIs) and giving a brief overview of the business intelligence (BI) and reporting tools that can be combined on the Microsoft platform to help you generate the results that you need.
The focus of the book is to help you implement a successful business intelligence project of your own. The text discusses many of the required project planning components, provides overviews and examples associated with Microsoft’s BI tools, and gives detailed examples of successful dashboard implementations.
What you’ll learn
The key functional and technical components of a successful report/dashboard implementation
What Microsoft tools are provided both within and without SQL Server 2008 to help you achieve an integrated solution
How to determine whether your performance indicators are correct for your business and how to roll them out to your organization in an effective way
Pro Oracle Spatial for Oracle Database 11g (Expert’s Voice in Oracle)
Publisher: Apress | ISBN: 1590598997 | edition 2007 | PDF | 787 pages | 16,1 mb
| “ |
Pro Oracle Spatial for Oracle Database 11g shows how to take advantage of Oracle Databases built–in feature set for working with location–based data. A great deal of the information used in business today is associated with location in some way, and analysis of that data is becoming ever more important in todays mobile and highly connected world. In Pro Oracle Spatial for Oracle Database 11g, authors Ravi Kothuri and Albert Godfrind address
* The special nature of spatial data and its role in professional and consumer applications
* Issues in spatial data management such as modeling, storing, accessing, and analyzing spatial data
* The Oracle Spatial solution and the integration of spatial data into enterprise databases
* How spatial information is used to understand business and support decisions, to manage customer relations, and to better serve private and corporate users
When you read Pro Oracle Spatial for Oracle Database 11g, you’re learning from the very best. Ravi Kothuri is a key member of Oracle’s Spatial development team. Albert Godfrind consults widely with Oracle clients on the implementation of Oracle Spatial, develops training courses, and presents frequently at conferences. Together they have crafted a technically sound and authoritative fountain of information on working with spatial data in the Oracle database.
What you’ll learn
Pro Oracle Spatial for Oracle Database 11g delivers in helping you fully understand Oracles spatial data feature set. In reading the book, you’ll learn
* About new Oracle Spatial features in Oracle Database 11g, including support for the European Petroleum Standards Group (EPSG) data model, the ability to publish to Google Earth, integration with Google Maps, and much more
* The use of Oracles built-in SDO_GEOMETRY data type for storing location–based data
* How to geocode your data, beginning with postal addresses and ending with SDO_GEOMETRY objects that enable future analysis as well as forming the foundation of working with spatial data within Oracle
* How to create and display maps to help you visualize and analyze your geocoded data
* About network modeling, which is useful in computing routes, travel distances, and proximity based upon travel time
* How to optimize analysis of your spatial data by creating spatial indexes and custom operators
Who is this book for?
Pro Oracle Spatial for Oracle Database 11g is aimed at software developers who wish to develop applications using Oracles extensive and strong support for working with spatial, or geocoded, data.
About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career. |
” |
download
mirror
mirror
mirror
七月 14th, 2009 in
Database/SQL | tags:
oracle |
No Comments
