Comprehensive in scope, this volume covers all aspects of using Oracle products - from initial information systems planning tasks through developing an application and implementing it in production. The book suggests methods for what to do from the time a company chooses Oracle as one of their DBMS products through to designing and implementing distributed systems. It includes numerous tips on developing screens, reports, and procedural code with Oracle tools - discusses the best uses of Oracle's CASE tools, illustrates the common tricks used in programming with Oracle's 4GL development tools, points out the types of programming styles that lead to slow performance, and offers tuning tips. It also provides worked examples that illustrate the types of real-life reasoning that goes into building enterprise models, data models, and process analysis; uses a running case study about a mail order company to illustrate complete worked examples; examines some of the third party products which are alternatives to Oracle's development tools, discussing when such tools are appropriate; and includes annotated code with tips and techniques for different ways of implementing an application.
| |||||||||||||||
|
There is a newer edition of this item:
|
Book Description
Editorial Reviews
From the Inside Flap
Preface
This book was originally published in 1991. The preface then suggested that you should not believe in the sales hype about relational technology. Today, the sales hype is about objects and the Internet technology. Do you still believe the latest sales hype that this technology will solve your application problems? If you do, or have learned differently from experience, then this book is for you. Development tools are still oversold in the effect they will have on application backlogs. The pace of technology-and the ever increasing sophisticated demands of users-has just one net effect: frustrated information systems managers, overworked programmers, and disappointed end users. This book is about the right way to develop quality applications regardless of the changes in technology.
There are many reasons why the sales hype does not pan out in practice. It only describes the achievements of organizations that already have significant expertise in using the tools and techniques. If you are just beginning, you have to master the initial learning curve before you are able to accomplish similar results. You also need to establish an environment that nurtures quality development practices. We will discuss how the organization's maturity affects the development practices and what you can do improve it.
As a consultant, I help many organizations manage their systems development efforts: from strategic planning, application requirements definition, development and implementation. This book discusses many of my experiences-you are likely to face similar challenges. The topics should be of interest to: Information officers, who are looking for tools and techniques for effective information planning. Managers, who need techniques to manage user expectations throughout the development effort on the one hand and on the other hand they must improve the quality of systems developed. Analysts and designers, who face the challenges of enterprise wide systems and require tools and techniques to support their activities. Developers, who need tips on using Oracle's fourth-generation tools. End users, who need to be involved in the development effort.
Oracle's products cover the gamut of database and related technologies. It has products that support all phases of software development in addition to its core database management product. Its analysis and design tools support many techniques using object modeling, entity-relationship models, function hierarchies and process flow models. The tools then proceed to support code generation for systems derived from these models. This book provides the methodology you need to make effectively use these tools to develop maintainable systems. This book is organized into four parts:
Part 1: Managing the Implementation
This part covers management issues such as the skills you need to foster in your organization, and how to rise above the fire-fighting chaos prevalent in many IT organizations. We cover techniques for gathering requirements for supporting the business and how the Oracle Oracle Designer tools support these models. We discuss project approaches-RAD or waterfall, and the conditions under which they are appropriate.
Part 2: Designing Oracle Applications
This section takes you through the transformation from business orientated models to systems oriented models. We describe the challenges of this transformation and the compromises that might be needed during the process. We also discuss peripheral issues such as database administration and how the development and production environments differ. Our design addresses both the development and target production environments. We also define the architectural issues involved in designing for roaming, Internet-based, and data warehouse environments.
Part 3: Developing Oracle Applications
This part is the nitty gritty issues of developing in the database environment. We explore some of the features of Oracle's GUI tools. We also discuss how the Oracle Designer generators make use of these features when generating code. This section is aimed at the development of serious operational systems.
Part 4: Data Warehouse, Distributed Systems, and the World Wide Web
These technologies are part of the normal environment, although not yet common for our daily operational systems. We discuss how to model and manage historical data in a data warehouse. In particular we describe how to address the challenges of consolidating data from disparate legacy systems. There are many issues raised by the need to support global operations with multiple physical systems locations. We address these in the distributed systems issues and the use of the world wide web environments.
I have learned a lot since the first publishing of this book. The funny thing is that I have not unlearned anything. I have incorporated many of the techniques I have learned into this book. Also included are some related approaches from the respected leaders of our industry that complement the methods outlined here. They help put the various models in context. They also help you understand the level of success you can expect based on the capabilities and maturity of your own organization.
This book includes tips and techniques I gained on a variety of projects. Although too many to identify individually, I am grateful to the initiator of each of those projects for the opportunities to practice my ideas and theories. I am also grateful to the many people involved in hours of discussions on the pros and cons of alternative approaches. Thank you, friends and colleagues.
My particular thanks go to my partner in life and business, Paul. The tremendous effort involved in writing this book would not have been possible without his playing Mr. Mom on weekends. Writing technical matter while reciting Dr. Seuss stories to my daughters is a whole another experience-probably one not to be repeated.
Finally, thanks to the publishers and staff at Prentice-Hall, in particular, Jeffrey Pepper and Kathleen Caren for jump-starting my stalled project. Thanks also to the production staff. This book would not be possible without their efforts. --This text refers to an out of print or unavailable edition of this title.
This book was originally published in 1991. The preface then suggested that you should not believe in the sales hype about relational technology. Today, the sales hype is about objects and the Internet technology. Do you still believe the latest sales hype that this technology will solve your application problems? If you do, or have learned differently from experience, then this book is for you. Development tools are still oversold in the effect they will have on application backlogs. The pace of technology-and the ever increasing sophisticated demands of users-has just one net effect: frustrated information systems managers, overworked programmers, and disappointed end users. This book is about the right way to develop quality applications regardless of the changes in technology.
There are many reasons why the sales hype does not pan out in practice. It only describes the achievements of organizations that already have significant expertise in using the tools and techniques. If you are just beginning, you have to master the initial learning curve before you are able to accomplish similar results. You also need to establish an environment that nurtures quality development practices. We will discuss how the organization's maturity affects the development practices and what you can do improve it.
As a consultant, I help many organizations manage their systems development efforts: from strategic planning, application requirements definition, development and implementation. This book discusses many of my experiences-you are likely to face similar challenges. The topics should be of interest to: Information officers, who are looking for tools and techniques for effective information planning. Managers, who need techniques to manage user expectations throughout the development effort on the one hand and on the other hand they must improve the quality of systems developed. Analysts and designers, who face the challenges of enterprise wide systems and require tools and techniques to support their activities. Developers, who need tips on using Oracle's fourth-generation tools. End users, who need to be involved in the development effort.
Oracle's products cover the gamut of database and related technologies. It has products that support all phases of software development in addition to its core database management product. Its analysis and design tools support many techniques using object modeling, entity-relationship models, function hierarchies and process flow models. The tools then proceed to support code generation for systems derived from these models. This book provides the methodology you need to make effectively use these tools to develop maintainable systems. This book is organized into four parts:
Part 1: Managing the Implementation
This part covers management issues such as the skills you need to foster in your organization, and how to rise above the fire-fighting chaos prevalent in many IT organizations. We cover techniques for gathering requirements for supporting the business and how the Oracle Oracle Designer tools support these models. We discuss project approaches-RAD or waterfall, and the conditions under which they are appropriate.
Part 2: Designing Oracle Applications
This section takes you through the transformation from business orientated models to systems oriented models. We describe the challenges of this transformation and the compromises that might be needed during the process. We also discuss peripheral issues such as database administration and how the development and production environments differ. Our design addresses both the development and target production environments. We also define the architectural issues involved in designing for roaming, Internet-based, and data warehouse environments.
Part 3: Developing Oracle Applications
This part is the nitty gritty issues of developing in the database environment. We explore some of the features of Oracle's GUI tools. We also discuss how the Oracle Designer generators make use of these features when generating code. This section is aimed at the development of serious operational systems.
Part 4: Data Warehouse, Distributed Systems, and the World Wide Web
These technologies are part of the normal environment, although not yet common for our daily operational systems. We discuss how to model and manage historical data in a data warehouse. In particular we describe how to address the challenges of consolidating data from disparate legacy systems. There are many issues raised by the need to support global operations with multiple physical systems locations. We address these in the distributed systems issues and the use of the world wide web environments.
I have learned a lot since the first publishing of this book. The funny thing is that I have not unlearned anything. I have incorporated many of the techniques I have learned into this book. Also included are some related approaches from the respected leaders of our industry that complement the methods outlined here. They help put the various models in context. They also help you understand the level of success you can expect based on the capabilities and maturity of your own organization.
This book includes tips and techniques I gained on a variety of projects. Although too many to identify individually, I am grateful to the initiator of each of those projects for the opportunities to practice my ideas and theories. I am also grateful to the many people involved in hours of discussions on the pros and cons of alternative approaches. Thank you, friends and colleagues.
My particular thanks go to my partner in life and business, Paul. The tremendous effort involved in writing this book would not have been possible without his playing Mr. Mom on weekends. Writing technical matter while reciting Dr. Seuss stories to my daughters is a whole another experience-probably one not to be repeated.
Finally, thanks to the publishers and staff at Prentice-Hall, in particular, Jeffrey Pepper and Kathleen Caren for jump-starting my stalled project. Thanks also to the production staff. This book would not be possible without their efforts. --This text refers to an out of print or unavailable edition of this title.
From the Back Cover
Streamline Oracle development-and supercharge your applications!
From strategic business analysis through rollout and optimization, Oracle: A Database Developer's Guide will help you streamline your entire Oracle development process. It's replete with proven solutions and worked examples for Designer/2000, Developer/2000, the Oracle database engine, PL/SQL coding, and more-all designed to maximize performance, even on tight development schedules. Top Oracle consultant Ulka Rodgers demonstrates key techniques for building Web, client/server, and data warehousing applications, including:
*Making the most of the Oracle Application Server and Oracle Designer/2000 application generator.
*Practical object-oriented, data and process modeling.
*Better ways to develop screens, reports and procedural code.
*When and how to use third-party alternatives to Oracle's tools.
Oracle: A Database Developer's Guide delivers extensive tuning guidance, covering query optimization, Enterprise Manager monitor facilities, dynamic performance tables and more. You'll also find crucial design and coding information for optimizing today's distributed applications. Whether you're a manager, analyst, Oracle data administrator, designer or developer, this book will help you achieve more, and get it done faster. --This text refers to an out of print or unavailable edition of this title.
From strategic business analysis through rollout and optimization, Oracle: A Database Developer's Guide will help you streamline your entire Oracle development process. It's replete with proven solutions and worked examples for Designer/2000, Developer/2000, the Oracle database engine, PL/SQL coding, and more-all designed to maximize performance, even on tight development schedules. Top Oracle consultant Ulka Rodgers demonstrates key techniques for building Web, client/server, and data warehousing applications, including:
*Making the most of the Oracle Application Server and Oracle Designer/2000 application generator.
*Practical object-oriented, data and process modeling.
*Better ways to develop screens, reports and procedural code.
*When and how to use third-party alternatives to Oracle's tools.
Oracle: A Database Developer's Guide delivers extensive tuning guidance, covering query optimization, Enterprise Manager monitor facilities, dynamic performance tables and more. You'll also find crucial design and coding information for optimizing today's distributed applications. Whether you're a manager, analyst, Oracle data administrator, designer or developer, this book will help you achieve more, and get it done faster. --This text refers to an out of print or unavailable edition of this title.
Product Details
Would you like to update product info or give feedback on images?
|
More About the Author
Discover books, learn about writers, read author blogs, and more.
Customer Reviews
|
Share your thoughts with other customers:
|
||||||||||||||||||||||
|
Most Helpful Customer Reviews
2 of 2 people found the following review helpful:
5.0 out of 5 stars
I DO GET IT! So should you. This is a GREAT book!,
By A Customer
This review is from: Oracle: A Database Developer's Guide 2/E (Paperback)
Ulka Rodgers has provided a unique book that stands out from the run-of-the-mill "how to" books overpopulating the technology shelves today. While the "how to" is addressed, so is the "what, when, and why to". If you are a database developer who receives very specific requests, and you simply need to know how commands work so you can put together the most efficient code, this book is not for you. If you are a database developer who needs to determine the best course of action to achieve success in a variety of situations, take a good look at this book.The book takes you step by step through the development of a world class database environment. It provides insights that will help you make the right decisions each step of the way, from the first decisions regarding methodology and approach, to the final decisions regarding system performance. The book delves into the latest technology areas one needs to know about to succeed such as the internet and data warehouse technology. I find it to be invaluable as a learning tool whenever I enter into unfamiliar territory. The book is structured to impart knowledge that Ulka Rodgers has gained through her extensive experience. As such, it is the type of book you want to read and enjoy. It is the type of book that has so much to offer, you may want read sections more than once. I don't mean to take away from the "how to" value this book provides. There are tips and techniques as well as detailed examples throughout the book that I find extremely useful. The coverage is thorough. But tips and techniques, although important, do not make a project succeed. What Ulka Rodgers has done here is provided a road map that, if followed properly, will clearly have a significant positive impact on your likelihood of success.
2 of 2 people found the following review helpful:
1.0 out of 5 stars
I don't get it!,
By A Customer
This review is from: Oracle: A Database Developer's Guide 2/E (Paperback)
I bought this book after reading the review for it in Select magazine (written by the same fellow who wrote the one on Amazon, Dr. Paul Dorsey). I could not disagree with his appraisal more.In short, I found the book useless. The author's treatment of the material was, in my opinion, superficial. As a businessman, I needed to understand the value of the technology and to get an appreciation for Developer issues. I simply couldn't get this from the book. The book's style was high-handed and the author appears very satisfied with herself and her accomplishments, although she shares little insight given her "years of experience." Obviously, this is a technical person who is trying to impress beyond her capabilities. I am puzzled by the dramatic difference between my impressions and the other reviewer's impressions. I hope he doesn't mislead others into buying this essentially useless book
1 of 1 people found the following review helpful:
5.0 out of 5 stars
A well-written guide to the Oracle environment,
By A Customer
This review is from: Oracle: A Database Developer's Guide 2/E (Paperback)
Overall, Oracle - A Database Developer's Guide 2nd Edition is clear and well written. It is the type of book that you might want to read a chapter of in an evening of your spare time. The book is written from the perspective of someone with a great deal of experience managing projects and building real-world systems. This experience is reflected in what Ms. Rodgers wants to tell her readers about systems development. A useful comprehensive example is woven throughout the book. This device works very well to reinforce the real world applications of the material discussed.The book is directed at the CIO or project manager of an organization, who may not know any more about Oracle than what they read in the trade papers. The Oracle environment is very complex. Ms. Rodgers has provided us with a guided tour of this environment, shrewdly pointing out the lovely vistas as well as the swamps. Given this scope, the book succeeds admirably; although it is impossible to cover this range of topics in depth in a mere 400 pages. The book is an excellent overview. Any one of its chapters could easily be expanded into its own book. If you are a senior project manager and want a different perspective on approaching an Oracle development project, this book has value. For those new to the industry who want to get a sense of why projects work and why many fail, the book also has merit. If you are merely looking for SQL tuning tips or the best init.ora parameter to accomplish a specific task, this is not the right resource for you. However, there are numerous useful tidbits of information scattered throughout the book. Ultimately, in reviewing a book, I always ask myself two questions: 1. Was it worth the cover price? 2. Was it worth the time it took to read? In both cases, for Ms. Rodgers book, the answer is a resounding "Yes."
Share your thoughts with other customers: Create your own review
|
|
Tag this product(What's this?)Think of a tag as a keyword or label you consider is strongly related to this product.
Tags will help all customers organize and find favorite items. |
Sell a Digital Version of This Book in the Kindle Store
If you are a publisher or author and hold the digital rights to a book, you can sell a digital version of it in our Kindle Store.
Learn more
Customer Discussions
|
This product's forum
Active discussions in related forums
Search Customer Discussions
|
Related forums
|
