Database Solutions A step-by-step guide to building databases 2nd edition

Database Solutions:A Step-by-Step Guide to Building Databases by Thomas Connolly & Carolyn Begg
Book Description
Series: Database Solutions | Publication Date: December 23, 1999
Do you carry the world on your shoulders? Does every request for a new business system from senior management land on your desk? Are you responsible for designing and creating the databases that keep your business running? Would you like to make the design and build process smoother, quicker and more reliable?


Database Solutions A step-by-step guide to building databases 2nd edition

Read more...

pdf lectures on dbms by iit madras professor

about the author:-

Prof. P.Sreenivasa Kumar
Department of Computer Science & Engineering , IIT Madras.

Syllabus:
PDF


Lectures Topics
Lecture 1 Introduction to database Systems
Lecture 2 Entity Relationship Model
Lecture 3 Relational Model
Lecture 3.1 Tuple Relational Calculus
Lecture 4 The SQL Standard
Lecture 5 File Organizing and Indexing
Lecture 6 Database design and Normal forms
these are high quality notes for steady reference from the professors of iit madras, most prestigious technical institution in india.

pdf lectures on dbms by iit madras professor

Read more...

Hands-On Database

Hands-On Database uses a scenario-based approach that shows readers how to build a database by providing them with the context of a running case throughout each step of the process

Hands-On Database

Read more...

Microsoft SQL Server 2012 Pocket Consultant

Portable and precise, this pocket-sized guide delivers ready answers for the day-to-day administration of SQL Server. Zero in on core support and maintenance tasks using quick-reference tables, instructions, and lists. You’ll get the focused information you need to save time and get the job done—whether at your desk or in the field!

Get fast facts to:

• Manage SQL Server services and clients
• Configure, manage, and tune servers
• Implement policy-based management
• Administer security and access
• Monitor server activity and tune performance
• Automate maintenance
• Perform backups and recovery

Microsoft SQL Server 2012 Pocket Consultant

Read more...

PeopleSoft for the Oracle DBA

PeopleSoft for the Oracle DBA, Second Edition stands on the boundary between the PeopleSoft application and the Oracle database. This new edition of David Kurtz’s book is freshly revised, showing how to tame the beast and manage Oracle successfully in a PeopleSoft environment.

You’ll learn about PeopleSoft’s Internet architecture and its use of Oracle’s Tuxedo Application Server. You’ll find full coverage of key database issues such as indexing, connectivity, and tablespace usage as they apply to PeopleSoft. Kurtz also provides some of the best advice and information to be found anywhere on managing and troubleshooting performance issues in a PeopleSoft environment. The solid coverage of performance troubleshooting is enough by itself to make PeopleSoft for the Oracle DBA a must-have book for any Oracle Database administrator working in support of a PeopleSoft environment.

Explains PeopleSoft’s technical architecture as it relates to Oracle Database
Demonstrates how to instrument and measure the performance of PeopleSoft
Provides techniques to troubleshoot and resolve performance problems

What you’ll learn

Understand PeopleSoft’s technical architecture and the structure of a PeopleSoft database
Measure performance of the various tiers in the application
Pinpoint and resolve performance problems within the code
Configure server processes for optimal performance
Monitor and manage your PeopleSoft installation using Oracle Enterprise Manager
Take full advantage of the PeopleTools Performance Monitor that is new in version 8.44

Who this book is for
PeopleSoft for the Oracle DBA is written for database administrators charged with supporting a PeopleSoft system, and especially those administrators responsible for troubleshooting and resolving PeopleSoft performance issues. PeopleSoft for the Oracle DBA also appeals to PeopleSoft administrators and developers who desire a better understanding of how PeopleSoft functions in an Oracle Database environment.

PeopleSoft for the Oracle DBA, 2nd Edition

Read more...

Expert Indexing in Oracle Database 11g

Expert Indexing in Oracle Database 11g is about the one database structure at the heart of almost all performance concerns: the index. Database system performance is one of the top concerns in information technology today. Administrators struggle to keep up with the explosion of access and activity driven by the proliferation of computing into everything from phones to tablets to PCs in our increasingly connected world. At the heart of any good-performing database lies a sound indexing strategy that makes appropriate use of indexing, and especially of the vendor-specific indexing features on offer.

Few databases fully exploit the wealth of data access mechanisms provided by Oracle. Expert Indexing in Oracle Database 11g helps by bringing together information indexing and how to use it into one, convenient and blissfully short volume that you can read quickly and have at your fingertips for reference. Learn the different types of indices available and when each is best applied. Recognize when queries aren’t using indices as you intend. Manage your indexing for maximum performance. Let Expert Indexing in Oracle Database 11g be your guide to deep mastery of the most fundamental performance optimization structure in Oracle Database.

Explains how indices work, how they help, and how they hinder
Demystifies the various index choices
Describes the database administration chores associated with indices

What you’ll learn

Create an overall indexing strategy to guide your decisions
Choose the correct indexing mechanisms for your applications
Manage and maintain indices to avoid degradation and preserve efficiency
Take better advantage of underused index types such as index-organized tables
Choose the appropriate columns to index, with confidence
Blend partitioning and materialized views into your indexing strategy

Who this book is for
Expert Indexing in Oracle Database 11g is for all levels of database administrators and application developers who are struggling with the database performance and scalability challenge. Any database administrator involved with indexing, which is any database administrator period, will appreciate the wealth of advice packed into this gem of a book.

Expert Indexing in Oracle Database 11g

Read more...

Two Minute SQL Server Stumpers

Whether you're practicing for an exam or interview, or just wanting to see who's got the biggest SQL Server brain in your office, this book is perfect. Containing 100 SQL Server Central Questions of the Day, this book is a great way to test yourself or increase your knowledge Editorial Review Challenge you in a variety of ways about the different aspects of SQL Server. Some of the questions are arcane, some very common, but you'll learn something and the wide range of questions will help you get your mind agile and ready for some quick thinking. This version is a compilation of SQL Server 2005 and SQL Server 2008 questions, to bring you up to date on the latest version of SQL Server. So read on, in order, randomly, just start going through them, but do yourself a favor and think about each before turning the page. Challenge yourself and see how well you do. sql server dba, mirosoft sql server 2008, inside sql server kalen.

Two Minute SQL Server Stumpers

Read more...

Mining of Massive Datasets

The popularity of the Web and Internet commerce provides many extremely large datasets from which information can be gleaned by data mining. This book focuses on practical algorithms that have been used to solve key problems in data mining and which can be used on even the largest datasets. It begins with a discussion of the map-reduce framework, an important tool for parallelizing algorithms automatically. The authors explain the tricks of locality-sensitive hashing and stream processing algorithms for mining data that arrives too fast for exhaustive processing. The PageRank idea and related tricks for organizing the Web are covered next. Other chapters cover the problems of finding frequent itemsets and clustering. The final chapters cover two applications: recommendation systems and Web advertising, each vital in e-commerce. Written by two authorities in database and Web technologies, this book is essential reading for students and practitioners alike.

Mining of Massive Datasets

Read more...

How to Stop Oracle from Fragmenting

In this paper, we provided an overview of the various kinds of fragmentation which can occur in Oracle and the techniques to avoid, detect and rectify them. We discussed common policies which can be deployed to avoid fragmentation for most of the cases. Though fragmentation is not necessarily always avoidable the authors believe that this subject has been overly exposed and the time spent on this matter could probably be well spent otherwise. We encourage Oracle DBAs to further refine this document with their own policies and techniques. We would also like to thank Jonathan Klein, Franco Putzolu, Alex Tsukerman and Richard Sarwal amongst others for kindly taking the time to review this document and helping making it accurate and hopefully complete.

How to Stop Oracle from Fragmenting

Read more...

Data Mining Concepts and Techniques Third Edition Morgan Kaufmann Series 2011

The increasing volume of data in modern business and science calls for more complex and sophisticated tools. Although advances in data mining technology have made extensive data collection much easier, it’s still always evolving and there is a constant need for new techniques and tools that can help us transform this data into useful information and knowledge.

Data Mining Concepts and Techniques Third Edition Morgan Kaufmann Series 2011
or
Data Mining Concepts and Techniques Third Edition Morgan Kaufmann Series 2011

Read more...