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
SQL Server 2008 Transact-SQL Recipes: A Problem-Solution Approach
Apress | ISBN: 1590599802 | July 23, 2008 | 872 pages | PDF | 4.8MB
Product Description
SQL Server 2008 Transact–SQL Recipes: A Problem–Solution Approach is an example–based guide to the Transact–SQL language that is at the core of SQL Server 2008. Learn to create databases, insert and update data, generate reports, secure your data, and more. Author Joseph Sack takes common Transact–SQL tasks and breaks them down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.
* Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
* Current: Newly updated for SQL Server 2008.
* Comprehensive: Covers 30 different Transact–SQL problem domains.
What you’ll learn
* Create databases, tables, and indexes.
* Query and manipulate data.
* Store and manage XML inside the database.
* Move business logic into the database.
* Encrypt data and capture changes for compliance purposes.
* Implement Full–Text Search.
* Interface with Service Broker.
* And more!
Who is this book for?
Developers who use Microsoft SQL Server 2008 as their back–end database. Database administrators who create, manage, and secure those databases.
mirror
Robin Dewson, Julian Skinner, “Pro SQL Server 2005 Assemblies”
Apress | 2008 | ISBN: 1590595661 | 296 pages | PDF | 1,7 MB
Pro SQL Server 2005 Assemblies</i> provides a detailed and example-driven tutorial on how to build and use .NET assemblies. The authors focus on building assemblies in C#, but also provide the equivalent VB .NET code in the supplied code download.
Assemblies are not a complete replacement for T-SQL stored procedures and triggers; rather, they’re enhancements, to be used at the right place and right time. This book examines the ins and outs of assemblies&emdash;when they should and should not be used, what you can do with them, and how you can get the most out of them.
Grant Fritchey, Sajal Dam, “SQL Server 2008 Query Performance Tuning Distilled (Expert’s Voice in SQL Server)”
Apress | 2009 | ISBN: 1430219025 | 600 pages | PDF | 8,75 MB
SQL Server 2008 Query Performance Tuning Distilled presents a direct trouble–shooting methodology for identifying poorly performing stored procedures and queries, isolating the causes of that poor performance, and fixing the underlying problems. Each chapter is dedicated to one of the top causes of poorly performing queries and shows methods for identifying and dealing with the problems in that chapter’s domain. Emphasis is always put upon or placed upon practical methods that you can put to immediate use in your day–to–day work. SQL Server 2008 functionality, tips, and tricks are emphasized in each subject area.
Emphasizes the practical. Does not bury readers in theory.
Gives readers practical techniques to immediately apply in their daily work.
Dedicates a chapter to each of the most common, performance–related problem areas.
What you’ll learn
Identify and fix poorly performing queries that are hurting your business.
Read query execution plans and identify bottlenecks in performance.
Record system performance metrics for trend analysis.
Learn to design databases and write Transact–SQL code to avoid common problems.
Understand what an index is, what it does, and how to build one.
Use industry accepted best practices and understand how to develop your own to arrive at optimal database performance.
MySQL (2nd Edition) (Developer’s Library)
Publisher: Sams | ISBN: 0735712123 | edition 2003 | CHM | 1248 pages | 1,9 mb
| “ |
The unexpected pleasure of reading books about databases is that they are often written by authors with highly organized minds. Paul DuBois and his editors at New Riders have assembled MySQL with a clarity and lucidity that inspires confidence in the subject matter: a (nearly) freely redistributable SQL-interpreting database client/server primarily geared for Unix systems but maintained for Windows platforms as well. What isn’t “free” about MySQL (the application) is its server’s commercial use; all clients and noncommercial server use are free. DuBois’s tome isn’t free either, but its list price is modest in light of its value and the value of its namesake.
The volume is superbly organized into 12 chapters and 10 appendices and contains a concise table of contents and a comprehensive 50-page index. It is peppered with references to the online HTML documentation that comes with the source and binary distributions (which are available and easy to install in stable rpm and tar releases.)
The first third of MySQL is an excellent instruction tool for database newbies; the second third is a detailed reference for MySQL developers; and the last third consists of clearly annotated appendices, including C, Perl (but not Python), and PHP interfaces.
Perhaps as an indication of the collective will of the developers of MySQL, DuBois does not separate Windows 95/98/NT design or development specifics from its main discussions. Platform-independent design is a goal, not a reality, and users will have to rely on newsgroups and mailing lists for details. Moreover, security issues are addressed in a mere 18 pages, a large part of which is devoted to standard Unix file and network-access permissions. Next to nothing is mentioned about defense against common hacking strategies, the use of secure shell interfaces, or access encryption.
Although it is nearly 800 pages in length, DuBois’s book is thankfully not encyclopedic. It is a valuable précis of the MySQL database, and its easy-to-skim look and feel will make it an excellent browse for database experts who want to know what is and is not possible within MySQL, the application. |
” |
Depositfiles
Megaupload
七月 14th, 2009 in
Database/SQL | tags:
mysql |
No Comments
