Database Processing: Fundamentals, Design, and Implementation (10th Edition) [Hardcover]

David Kroenke (Author)

Book Description

ISBN-10: 0131672673 | ISBN-13: 978-0131672673 | Publication Date: March 5, 2005 | Edition: 10

Revised to reflect the needs of today’s users, this 10^th edition of Database Processing assures that you will learn marketable skills. By presenting SQL SELECT statements near the beginning of the book readers will know early on how to query data and obtain results–seeing firsthand some of the ways that database technology is useful in the marketplace. By utilizing free software downloads, you will be able to actively use a DBMS product by the end of the 2^nd chapter.   Each topic appears in the context of accomplishing practical tasks. Its spiral approach to database design (incorporating all 3 sources: from the integration of existing data, from new information, and the need to redesign an existing database) provides users with enhanced information not available in other database books on the market. Topics include: SQL, database design, implementation, processing, access standards, and business intelligence. An excellent reference and handbook for information systems professionals such as database administrators, database designers, systems analysts, web-database developers, and programmers of database applications.

Editorial Reviews

From the Back Cover

Provides a solid foundation in the fundamentals of database processing, and incorporates all
of the most current technologies on the market

COMPLETE * CLEAR * CURRENT

COMPLETE
• Extensive discussions address publishing database applications with Internet technology and using both Active Server Pages and Java Server Pages
• In-depth discussions of the relational model, normalization, and extensive SQL for both data definition and data manipulation
• Thorough coverage of database modeling and design using both the entity-relationship and semantic object models

CLEAR
• Lucid descriptions and examples of modern DBMS products including Access 2002, Oracle, SQL Server, and MySQL
• The companion website at www.prenhall.com/kroenke, provides easy navigation to exercises in Tabledesigner, drag-and-drop database design tool, and interactive study guide questions that drive home the chapter objectives

CURRENT
• Up-to-date coverage of data warehousing, data marts, and OLAP
• Presentation and discussion of important standards including DHTML, XML (including XML Schema), ODBC, and JDBC
• Discussions of object- oriented database processing that feature both SQL3 and Oracles object-relational capabilities

Study and Succeed with
David Kroenke's Database Processing 8/e & Web site: www.prenhall.com/kroenke

--This text refers to an out of print or unavailable edition of this title.

Excerpt. © Reprinted by permission. All rights reserved.

According to Alan Greenspan, Chairman of the U.S. Federal Reserve, information technology has enabled unprecedented increases in business productivity. While the Internet takes most of the credit, behind the scenes database technology plays a vital role. After all, the Internet is only a communication system; much of its value lies in the data and information transmitted to and from databases.

News of the dot-com bust may cause students to wonder if the value of these technologies will decline accordingly. Nothing could be further from the truth. Lou Gestner, Chairman of IBM, stated several years ago that the true benefits of the Internet and related technologies will occur only after those technologies have been embraced by mainstream, corporate America—by the so-called "old economy" companies. Major opportunities for database technology (and for future database practitioners) lie in applying this technology now, to every kind of business and business activity.

All of which means there has never been a better time to study database processing. From personal databases on desktops to large interorganizational databases distributed on computers worldwide, databases are increasingly important business assets. Marketing, sales, production, operations, finance, accounting, management, and indeed all business disciplines, are using database technology to gain increased productivity in their respective activities.

Moreover, after the frenzy of new technologies and products in recent years, the key elements of modern database management have now become clear. Conceptual knowledge of data modeling and database design continue to be essential; equally, the relational model and SQL are as important as in the past. Database administration, especially the technology supporting multi-user database management, has increased in importance because all databases that use the new technologies are multi-user.

Additionally, technology for publishing databases on the web, especially three-tier and multi-tier architectures, XML, Active Server Pages (ASP), and Java Server Pages (JSP) have emerged as winners among many contenders for database publishing. In concert with these technologies, both ODBC with OLE DB and JDBC continue their importance.

In short, database technology is more important than ever, and the basic technologies that need to be taught have become clearer than any time in the past five years.

FEATURES OF THIS EDITION

In accordance with these remarks, the second half of this text has been completely rewritten. Almost all of Chapters 11 through 16 is new. The major tasks of database administration are surveyed in Chapter 11 and then illustrated for Oracle in Chapter 12, and again for SQL Server in Chapter 13. Then, Chapter 14 surveys the basic technologies for database publishing on the Web and these technologies are then illustrated for ODBC, OLE DB, IIS, and ASP in Chapter 15 and again for JDBC, JSP, and MySQL in Chapter 16. Chapter 17 includes information on OLAP, while Chapter 18 introduces Oracle's new object-relational constructs.

Addressing all of these topics in a single term is a challenge, and I believe we need seriously to consider devoting a full year to the database class. Meanwhile, if you have just one term and time is short, this edition has been written to enable you to choose among three sets of alternative technologies.

Specifically, regarding data modeling, the text addresses the entity-relationship model and the semantic object model. If time is short, you might want to cover only the E-R model because it is far more popular. Similarly, regarding multi-user databases, pick either Oracle in Chapter 12 or SQL Server in Chapter 13 depending on the needs of graduates in your community'. Finally, regarding Web' publishing, if time constrains your course, choose either IIS, ASP, and ODBC in Chapter 15; or Java, JDBC, and JSP in Chapter 16. No loss of continuity will occur if you select only one of any of these three pairs. Of course, if you're not constrained by time, all of these topics are important.

This edition also includes a new series of end-of-chapter exercises. These concern a small company that markets, sells, produces, and supports a line of camping stoves. The goal of these exercises is to enable the students to apply the knowledge gained from each chapter to a small, realistic, but constrained application.

CHAPTER-BY-CHAPTER OVERVIEW

This text consists of seven parts. Part I introduces database processing. Chapter 1 illustrates sample applications, defines basic terms, and sketches the history of database processing. Chapter 2 then illustrates the development of a simple database and application using Microsoft Access XP.

The second part concerns data modeling. Chapter 3 discusses the entity-relationship model and shows how this model has been integrated with UML, or the Uniform Modeling Language. Chapter 4 presents the semantic object model, a data modeling alternative to the E-R model. Database design is the subject of Part III. Chapter 5 discusses the relational model and normalization. Chapter 6 then applies the ideas from Chapters 3 and 5 to transform entity-relationship models into relational database designs. Chapter 7 applies the ideas from Chapters 4 and 5 to transform semantic object models into relational database designs.

The next part addresses the fundamentals of relational database implementation. Chapter 8 presents an overview, Chapter 9 addresses procedural SQL, and Chapter 10 describes the design of relational database applications. Part V considers multi-user database management. Chapter 11 describes database administration and discusses important issues of multi-user database processing including concurrency control, security, and backup and recovery. The ideas presented in Chapter 11 are then illustrated for Oracle in Chapter 12. Chapter 12 also illustrates SQL for data definition. Chapter 13 also mirrors the discussion of Chapter 11 to illustrate multi-user database management using SQL Server.

Database publishing on the Web is next addressed in Part VI. Chapter 14 lays the foundations of network processing, multi-tier architectures and XML. Chapter 15 then applies these concepts using Microsoft technology including ODBC, OLE DB, IIS, and ASP. Chapter 16 applies the concepts of Chapter 14 using Java; it includes JDBC, JSP, and MySQL. Concepts are illustrated with example using Linux and Apache Tomcat. Chapter 17 then addresses issues of data administration and discusses OLAP.

Part VII contains only one chapter which addresses object-oriented database processing. New to this chapter is a discussion of Oracles object-relational features and functions. Appendix A contains a brief survey of data structures and Appendix B illustrates the use of Tabledesigner, a product that can be used to develop semantic object models and covert them into database designs and ASP pages.

--This text refers to an out of print or unavailable edition of this title.

Product Details

• Hardcover: 696 pages
• Publisher: Prentice Hall; 10 edition (March 5, 2005)
• Language: English
• ISBN-10: 0131672673
• ISBN-13: 978-0131672673
• Product Dimensions: 10.9 x 8.3 x 1.2 inches
• Shipping Weight: 3.6 pounds
• Average Customer Review: 3.0 out of 5 stars  See all reviews (30 customer reviews)
• Amazon Best Sellers Rank: #333,073 in Books (See Top 100 in Books)

More About the Author

Discover books, learn about writers, read author blogs, and more.

Customer Reviews

Most Helpful Customer Reviews

27 of 34 people found the following review helpful:

5.0 out of 5 stars Expensive, but better than its competitors, May 11, 2005

By 

Gene B. Chase (Grantham, PA USA) - See all my reviews
(REAL NAME)   

This review is from: Database Processing: Fundamentals, Design, and Implementation (10th Edition) (Hardcover)

Price over $130? Whew! But Kroenke's text is comparable in price (when purchased new) with its major competitor, Hoffer, Prescott, and McFadden's 7th edition (HPM), with which I will compare Kroenke's text below. (HPM is by the same publisher; eventually all textbooks will be sold by only one publisher!) To help with the price, I will not ask my students to buy a supplementary text for the database we choose to use, but will provide a few on library reserve.

Kroenke's text is geared more to the computer science major than to the business information systems major. For example, Kroenke recognizes that mySQL is now industrial strength, and so includes a discussion of it. For example, HPM is 700 pages of fine print, busy diagrams, and wordy explanations some of which talk down to the student ("A 'term' is a word or phrase that has a specific meaning for the business"). Kroenke's is 675 open, clearly written, succinct pages. At my college there is a sequence of courses for databases, another sequence for software engineering, and a third sequence for system analysis. HPM tries to do some of all of three of these topics, thereby diffusing a database focus. Kroenke's text by contrast is focused. In fact, the apparently comparable length to HPM is misleading, because which end chapters you read in Kroenke depends on the database you choose.

As the publisher's blurb says, Kroenke made a wise decision to introduce (easy) SQL early. And I add that Kroenke continues to introduce hard SQL later, such as nested EXISTS for the computer science major. HPM introduces SQL later, and only the easy parts.

XML is becoming increasingly important to database users. Kroenke's treatment of XML is adequate; HPM's treatment is cursory.

The chief advantage of HPM over Kroenke is the consistent use of a really excellent Mountain View Community Hospital project from beginning to end, providing continuity and depth.

I have been using Kroenke since the first edition. (I missed only the second and ninth editions.) So this is a biased review, in which it is hard for me to shake my history of good experience with previous editions.

I am among those sad to see that Kroenke's Semantic Object model didn't catch on, but given that it didn't, I'm glad that he finally relegated it to an appendix.

I am glad that Kroenke's text can be purchased for only $8 more with a CD containing Oracle or SQL Server, although I will use mySQL.

In short, I'm still a member of the Kroenke fan club.

--Gene Chase

9 of 10 people found the following review helpful:

1.0 out of 5 stars Miserable Book, February 18, 2003

By A Customer

This review is from: Database Processing: Fundamentals, Design and Implementation (8th Edition) (Hardcover)

I have to agree with the negative reviews so far. This book is a nightmare! I'm currently using this book for class.
The author contradicts himself not only from chapter to chapter but within individual paragraphs.
He spends entirely too much time on simple ideas and breezes through complex ones.
I find myself reading through paragraphs thinking, "Oh, he's still talking about that? Why is he still taking about that?"
Then the next paragraph, "What the hell is he talking about!?"
His sentences are wordy and complicated. He has forgotten the basic structure of the English sentence. That being: Stick to one subject per each, please. Throughout these verbose outbursts, he combines terms that are so similar they cause confusion. As an example:

"The physical description of a semantic object domain is just a reference to the semantic object description."

This gem of a sentence is halfway through Chapter Four. However, since this book is so poorly thought out and written, I still don't know what any of those terms mean or refer to.
If I knew what he was talking about, I would rewrite that sentence. However, I don't. So I've given up reading and am now writing a scathing review. What does that tell you?
Thankfully, there are many figures scattered throughout the book to attempt to clarify what the author can't seem to. Unfortunately, none of the figures being refered to are ever on the same page. The student must read the sentence, flip the page, try to remember what the author was rambling about, flip back, ... you get the point.

All in all, this is the most miserable textbook I have ever read. And perhaps one of the most overpriced. At "this cost", not only do expect this book to basically read itself, I would expect it to teach me through osmosis while I sleep.

8 of 9 people found the following review helpful:

4.0 out of 5 stars Good but lacks proper layout, May 9, 1999

By A Customer

This review is from: Database Processing: Fundamentals, Design, and Implementation (Hardcover)

This is really not a critique of the material in the text since I consider it adequate as a beginners guide to database concepts. Due to my limited experience with database texts I cannot comment more on the actual material, but having read many other technical texts, I can say that the material and the examples provided are laid out poorly. The text will explain a concept, but if you are truly new to this subject, you will find yourself repeatedly flipping back and forth by a few pages to the examples and diagrams that they refer to. Correct this problem for the next edition and all's well.