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.

Author(s) : Geoff Ingram
Publisher : Wiley
Year : Sep 2002
ISBN 10 : 0471224367
ISBN 13 : 9780471224365
Language : English
Pages : 720
File type : PDF
Size : 2.6 MB (book + source code)

The purpose of this book is to help organizations deploy Oracle8i and Oracle9i (including Release 2) systems that meet the key end-user requirements of performance and availability at the same time. The ability to deliver on these twin requirements requires a holistic approach to the design and build of the end-to-end Oracle system, and this holistic approach is at the heart of this book. Too often, insufficient emphasis is given to components that are not related to the server. For example, consider a scenario where an Oracle end-user application uses a local configuration file (tnsnames.ora) to locate an Oracle database.

If the database relocates to a new server one weekend, and the configuration file change is overlooked, end users won’t be able to connect on Monday morning. The database may as well be down. From the end-user perspective, it is. In the worst case, the outage could affect the organization’s bottom line. Appropriate network configuration, based on a centralized naming service, is a critical success factor for delivering availability. A similar emphasis is required on all aspects of the Oracle configuration, from initial installation to production support, in order to meet performance and availability requirements.

This book is divided into six parts, which are intended to cover subjects in the order you might address them when setting up an Oracle configuration from scratch. In order to get the most out of the book, the best approach is to read it from cover to cover in sequential order. The detail is important, and a lack of attention to detail in all relevant areas of the technology is based on personal experience significant reason why Oracle systems don’t meet end-user performance and availability requirements.

This book is intended for both DBAs and developers of all levels. In many ways, the term advanced in the Oracle world is something of a misnomer. The scope of what Oracle provides is very extensive: There’s a lot to know, but most of it is not especially complex. Anyone who understands Oracle fundamentals can understand and benefit from the contents of this book and Oracle’s own Concepts Guide is a great place to start. The challenge comes in deploying systems based on techniques that work from the many techniques available. This book sets out to provide a fast track to deploying systems with performance and availability built in.

TABLE OF CONTENT:
Chapter 01 - Evolution of Decision Support Systems
Chapter 02 - The Data Warehouse Environment
Chapter 03 - The Data Warehouse and Design
Chapter 04 - Granularity in the Data Warehouse
Chapter 05 - The Data Warehouse and Technology
Chapter 06 - The Distributed Data Warehouse
Chapter 07 - Executive Information Systems and the Data Warehouse
Chapter 08 - External/Unstructured Data and the Data Warehouse
Chapter 09 - Migration to the Architected Environment
Chapter 10 - The Data Warehouse and the Web
Chapter 11 - ERP and the Data Warehouse
Chapter 12 - Data Warehouse Design Review Checklist


Link 1
Link 2
Link 3

password:
ganelon

Author(s) : PAOLO GIUDICI
Publisher : Wiley
Year : Aug 2003
ISBN 10 : 047084678X
ISBN 13 : 9780470846780
Language : English
Pages : 376
File type : PDF
Size : 3 MB (book + source code)

Data mining can be defined as the process of selection, exploration and modelling of large databases, in order to discover models and patterns. The increasing availability of data in the current information society has led to the need for valid tools for its modelling and analysis. Data mining and applied statistical methods are the appropriate tools to extract such knowledge from data. Applications occur in many different fields, including statistics, computer science, machine learning, economics, marketing and finance.

This book is the first to describe applied data mining methods in a consistent statistical framework, and then show how they can be applied in practice. All the methods described are either computational, or of a statistical modelling nature. Complex probabilistic models and mathematical tools are not used, so the book is accessible to a wide audience of students and industry professionals. The second half of the book consists of nine case studies, taken from the author's own work in industry, that demonstrate how the methods described can be applied to real problems.

It is a valuable resource for advanced undergraduate and graduate students of applied statistics, data mining, computer science and economics, as well as for professionals working in industry on projects involving large volumes of data - such as in marketing or financial risk management.

Author(s) : John Poole, Dan Chang, Douglas Tolbert, David Mellor
Publisher : Wiley
Year : Nov 2001
ISBN 10 : 0471200522
ISBN 13 : 9780471200529
Language : English
Pages : 208
File type : PDF
Size : 1.2 MB

The world of meta data began with simple listings that came from early compilers. From that humble origin came directories, then data dictionaries, then repositories and sophisticated end-user tools. The Internet came along and opened up the doors of computing into venues never before imagined, and meta data grew once again.

The time has come for consumers to step forward and specify a standard for meta data semantics and exchange. This book is an important step toward that goal. It will be a lodestone for future products and collaborative efforts across the corporate information factory.

The Common Warehouse Metamodel (CWM) is the new OMG standard that makes the sharing of data seamless. The CWM standard development team provides developers with a complete overview of what CWM is and how it works.

After acquainting readers with the CWM architecture and how each CWM component fits into existing database and data warehouse architectures, the authors provide expert guidance on how to plan for, implement, and deploy CWM technologies. Companion Web site features updates on CWM technologies, descriptions of tools, and links to vendor sites.