Database - Page [8] - Free Ebooks Portal BluePortal.org

[1] [2] [3] [4] [5] [6] [7] [Page 8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] ... [ Last ]

» Data Mining With SQL Server 2005

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.

cover

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.

» MySQL Reference Manual

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.

[1] [2] [3] [4] [5] [6] [7] [Page 8] [9] [10] [11] [12] [13] [14] [15] [16] [17] [18] ... [ Last ]