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.

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