|
| |
|
EBooks » Database
 Grant Allen “Beginning DB2: From Novice to Professional" Apress | 2008-08-11 | ISBN: 159059942X | 544 pages | PDF | 9,95 MB IBM’s DB2 Express Edition is one of the most capable of the free database platforms available in today’s marketplace. In Beginning DB2, author Grant Allen gets you started using DB2 Express Edition for web sites, desktop applications, and more. The author covers the basics of DB2 for developers and database administrators, shows you how to manage data in both XML and relational form, and includes numerous code examples so that you are never in doubt as to how things work. In this book, you’ll find A friendly introduction to DB2 Express Edition, an industrial–strength, relational database from IBM Dozens of examples so that you are never in doubt as to how things work Coverage of important language interfaces, such as from PHP, Ruby, C#, Python, and more Aimed at developers who want a robust database to back their applications What you’ll learn Install and manage DB2 Express Edition on Linux and Windows. Manage IML data seamlessly using IBM’s pureXML storage engine. Connect DB2 databases to web and desktop applications via languages such as PHP, Ruby, C#, Python, and more. Protect your data with a sound backup and restore strategy. Design and manage database schemas and security within the database. Know when and why to upgrade to more powerful editions of DB2. Who is this book for? Application developers, including web application developers, looking for a robust, zero–cost database to back their applications. Database administrators looking to get up to speed quickly with DB2.  Christian Antognini “Troubleshooting Oracle Performance"
Apress | 2008-06-23 | ISBN: 1590599179 | 616 pages | PDF | 6,55 MB
What do you do when your database application isn’t running fast enough? You troubleshoot, of course. Finding the slow part of an application is often the easy part of the battle. It’s finding a solution that’s difficult. Troubleshooting Oracle Performance helps by providing a systematic approach to addressing the underlying causes of poor database application performance.
Written for developers by an application developer who has learned by doing
Gives a systematic approach to solving database application performance problems
Helps you plan for performance as you would for any other application requirement
What you’ll learn
See how to treat and plan for performance as a basic application requirement.
Identify performance problems using a systematic and repeatable approach.
Configure your query optimizer to meet your application performance goals.
Optimize table accesses, joins, and physical table layout.
Read and recognize inefficient SQL execution plans.
Reduce inefficiencies from too much procedural code.
Who is this book for?
For application developers and database administrators involved in troubleshooting performance problems of Oracle-based applications  Your in-depth guide to using the new Microsoft data mining standard to solve today's business problems Concealed inside your data warehouse and data marts is a wealth of valuable information just waiting to be discovered. All you need are the right tools to extract that information and put it to use. Serving as your expert guide, this book shows you how to create and implement data mining applications that will find the hidden patterns from your historical datasets. The authors explore the core concepts of data mining as well as the latest trends. They then reveal the best practices in the field, utilizing the innovative features of SQL Server 2005 so that you can begin building your own successful data mining projects. You'll learn: - The principal concepts of data mining
- How to work with the data mining algorithms included in SQL Server data mining
- How to use DMX-the data mining query language
- The XML for Analysis API
- The architecture of the SQL Server 2005 data mining component
- How to extend the SQL Server 2005 data mining platform by plugging in your own algorithms
- How to implement a data mining project using SQL Server Integration Services
- How to mine an OLAP cube
- How to build an online retail site with cross-selling features
- How to access SQL Server 2005 data mining features programmaticall
About the Authors. Credits. Foreword. Chapter 1: Introduction to Data Mining. Chapter 2: OLE DB for Data Mining. Chapter 3: Using SQL Server Data Mining. Chapter 4: Microsoft Naïve Bayes. Chapter 5: Microsoft Decision Trees. Chapter 6: Microsoft Time Series. Chapter 7: Microsoft Clustering. Chapter 8: Microsoft Sequence Clustering. Chapter 9: Microsoft Association Rules. Chapter 10: Microsoft Neural Network. Chapter 11: Mining OLAP Cubes. Chapter 12: Data Mining with SQL Server Integration Services. Chapter 13: SQL Server Data Mining Architecture. Chapter 14: Programming SQL Server Data Mining. Chapter 15: Implementing a Web Cross-Selling Application. Chapter 16: Advanced Forecasting Using Microsoft Excel. Chapter 17: Extending SQL Server Data Mining. Chapter 18: Conclusion and Additional Resources. Appendix A: Importing Datasets. Appendix B: Supported VBA and Excel Functions. Index. 
Author(s) : Paul Nielsen
Publisher : Wiley
Year : Nov 2006
ISBN 10 : 0764542567
ISBN 13 : 9780764542565
Language : English
Pages : 1293
File type : PDF
Size : 14.9 MB (book + source code)
Like all books in the Bible series, you can expect to find both hands-on tutorials and real-world practical applications, as well as reference and background information that provides a context for what you are learning. However, to cover every minute detail of every command of this very complex product would consume thousands of pages, so it is the second goal of this book to provide a concise yet comprehensive guide to SQL Server 2005 based on the information I have found most useful in my experience as a database developer, consultant, and instructor. By the time you have completed the SQL Server 2005 Bible, you will be well prepared to develop and manage your SQL Server 2005 database.
Whether you are a database developer or a database administrator, whether you are just starting out, have one year of experience or five, this book contains material that will be useful to you. This book is written so that you can learn from my experience and the experience of the co-authors. Each chapter begins with the assumption that you’ve never seen the topic before, and then progresses through the subject, presenting the information that makes a difference.
 Author(s) : Adam Machanic, Hugo Kornelis, Lara Rubbelke Publisher : Apress Year : May 2007 ISBN-10 : 159059729X ISBN-13 : 9781590597293 Language : English Pages : 445 File type : PDF Size : 5.8 MB (book + source code) This book, at its core, is all about building your own set of tools from which you can draw inspiration as you work with SQL Server. I try to explain not only the hows of each concept described herein, but also the whys. And in many examples throughout the book, I attempt to delve into the process I took for finding what I feel is the optimal solution. My goal is to share with you how I think through problems. Whether or not you find my approach to be directly usable, my hope is that you can harness it as a means by which to tune your own development methodology. This book is arranged into three logical sections. The first four chapters deal with software development methodologies as they apply to SQL Server. The next three chapters get into advanced features specific to SQL Server. And the final four chapters are more architecturally focused, delving into specific design and implementation issues around some of the more difficult topics I’ve encountered in past projects. The primary purpose of this book is to bring Microsoft SQL Server developers back into the software development fold. These pages stress rigorous testing, well-thought-out architectures, and careful attention to interdependencies. Proper consideration of these areas is the hallmark of an expert software developer—and database professionals, as the core members of any software development team, simply cannot afford to lack this expertise.  Author(s) : Dan Wood, Chris Leiter, Paul Turley Publisher : Wrox Year : Nov 2006 ISBN 10 : 0470047046 ISBN 13 : 9780470047040 Language : English Pages : 574 File type : PDF Size : 4.6 MB This book, as the title suggests, is all about database administration. But what is database administration? Database administrators are more and more often being called upon to perform duties that are not strictly �administrative� in nature. Along with typical administrative duties such as backups, database maintenance, and user management, database administrators are increasingly being asked to perform tasks such as building complex data transformations for data import, building distributed data solutions, and, with the release of SQL Server 2005, maintaining the security and integrity of the database while enabling the integration of managed code into the database engine. This book lays the foundation by covering in detail the most common database administrative tasks. It also introduces you to many of the more advanced areas that enterprise database administrators need to be familiar with. Read these pages carefully, and apply what you learn. From here, move on to more complex jobs and tasks. The opportunities for talented and hard-working database administrators are virtually unlimited. Our primary audience is IT professionals (both developers and administrators) who have found themselves responsible for the management and maintenance of a SQL Server 2005 database. You may have been responsible for a SQL Server 2000 database and were just getting used to that when your company decided to move to SQL Server 2005. The new features and new tool set can be intimidating.  Author(s) : Michael "Monty" Widenius, David Axmark, MySQL AB Publisher : O'Reilly Year : Jun 2002 ISBN 10: 0596002653 ISBN 13: 9780596002657 Language : English Pages : 814 File type : PDF Size : 2.5 MB This highly regarded and comprehensive reference manual comes directly from the members of the MySQL team. The book covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. No serious MySQL user should be without this book. MySQL is the most popular SQL database in the open source community and is used almost universally by web sites running on open source systems. As powerful and flexible as it is lightweight and efficient, MySQL packs a large feature set into a very small and fast engine that now runs on more than 500,000 servers. This renowned online manual that has supported MySQL administrators and database developers for years is now available in paperback format. This book is an exact reproduction of the MySQL Reference Manual from the MySQL development team's Web site, minus some non-technical appendices. This version covers MySQL 4.0. Many sophisticated topics appear in this comprehensive manual, ranging from the hitches you may run into when first installing MySQL to internals that will help you tune your queries. MySQL Reference Manual contains all the comprehensive reference material one would expect for building the product, running administrative utilities, and using various API as well as MySQL's rich version of SQL.  Author(s) : Sikha Bagui, Richard Earp Publisher : Auerbach Year : Jun 2003 ISBN 10 : 0849315484 ISBN 13 : 9780849315480 Language : English Pages : 264 File type : PDF Size : 3 MB Entity-relationship (E-R) diagrams are time-tested models for database development well-known for their usefulness in mapping out clear database designs. Also commonly known is how difficult it is to master them. With this comprehensive guide, database designers and developers can quickly learn all the ins and outs of E-R diagramming to become expert database designers. Because E-R diagrams are so fundamental to database design, this book is also an indispensable text for teaching computer science students the basics of database development. Database Design Using Entity-Relationship Diagrams clarifies E-R diagramming by defining it in terms of requirements (end user requests) and specifications (designer feedback to those requests). The book explains how open communication between designers and end users is critical to developing usable, easy-to-understand E-R diagrams that model both requirements and specifications. The authors explain, in an intuitive, informal manner, how to develop an E-R diagram, how to map it to a database, and how the resulting database can be tested. This definitive guide is a basic component for any database course, and is also an invaluable reference that database professionals can use throughout their careers. This book is intended to be used by database practitioners and students for data modeling. It is also intended to be used as a supplemental text in database courses, systems analysis and design courses, and other courses that design and implement databases. Many present-day database and systems analysis and design books limit their coverage of data modeling. This book not only increases the exposure to data modeling concepts, but also presents a detailed, step-by-step approach to designing an ER diagram and developing the relational database from it.  Author(s) : Paul Wilton and John W. Colby Publisher : Wrox Year : Mar 2005 ISBN 10 : 0764577328 ISBN 13 : 9780764577321 Language : English Pages : 528 File type : PDF Size : 3.6 MB (book + source code) This book starts right from the basics with databases and SQL. Prior database or SQL knowledge is not necessary, as this book covers everything from database design to creating your first database and understanding how the SQL language is used with databases. If you have some previous experience with databases and SQL, then you�ll have a head start and you may want to just skim Chapter 1. You�ll need to follow its instructions for creating the book�s example database, as this is used for all the examples throughout the book. This book will look at Structured Query Language, or SQL as it�s usually abbreviated. SQL works with a database to create the database and to insert and extract data. Therefore, it�s essential to understand the theory and concepts behind database systems. Hence, this book also covers database theory and database design, so that you�re equipped to create an effective database. The SQL code in this book reflects the modern SQL standards set by organizations such as the American National Standards Institute (ANSI) and the International Standards Organization (ISO). However, while standards are great, what�s available for practical use is what really counts. This book, then, concentrates on the sort of SQL supported by most modern database systems. You should that find most of the code runs with little or no modification on most database systems released within the last six or seven years.  Author(s) : Arie Jones, Ryan K. Stephens, Ronald R. Plew, Robert F. Garrett, Alex Kriegel Publisher : Wrox Year : Apr 2005 ISBN 10 : 0764569015 ISBN 13 : 9780764569012 Language : English Pages : 790 File type : PDF Size : 2.7 MB This book is a complete SQL functions reference for all of the major RDBMS vendors in today�s market. The SQL implementations covered in this book include ANSI SQL, Oracle, Microsoft SQL Server, Sybase, IBM Universal Database (UDB) DB2, MySQL, and PostgreSQL. As a SQL programmer, you will find that there is a growing need to effectively use SQL functions, yet there are few resources to serve as an aid. You will also encounter the need to cross-reference different SQL implementations, at times having to integrate data between, say, Oracle and SQL Server. Migrations of data from one implementation to another is also very common in data warehousing environments, and as organizations make the commitment to go with another vendor�s relational database management system (RDBMS) to better support evolving business needs. This book is the necessary tool to facilitate expedient function referencing, cross-referencing between implementations, creating userdefined functions (UDFs), and providing tips and examples for applying the use of functions to real-world data-retrieval situations. This book is for the SQL programmer, and any software developer who has a need to effectively retrieve data from a relational database, or to integrate applications with RDBMS implementations. Database administrators and other database users will also discover great value. This book is for readers of all levels, and has been organized in an easy-to-understand format that allows quick search and reference. This book is packed with realistic examples, allowing the reader to immediately apply SQL functions concepts to the job at hand. Although the intent of this book is not to teach you SQL, the introductory chapters we have provided serve as an introduction to the world of SQL, explaining basic SQL concepts and describing how to use SQL to query a database, either with or without the use of functions. The trailing chapters of this book show numerous applications of SQL functions in the modern database world. |
| |
|
