Free Programming Books
Free download ebooks on computer and programming | |||
Free Oracle ebook "PeopleSoft for the Oracle DBA" Sample ChapterPeopleSoft for the Oracle DBA Download chapterFree downloadable Chapter 1: An Overview The newest addition to the OakTable Press series, PeopleSoft for the Oracle DBA, will teach you a range of techniques for maintaining a PeopleSoft system. You will then become able to implement techniques like indexing, implementing DDL, managing tablespaces, and fixing low-performing SQL queries. Author, Kurtz, is a field expert and thus, provides answers to common questions that arise when using PeopleSoft on an Oracle database. Kurtz begins the book with an architecture overview, then proceeds to BEA Tuxedo, PeopleSoft's application server. Kurtz transitions smoothly between subsequent chapters, explaining database structures, connectivity, keys and indexing, the PeopleSoft DDL, and tablespaces. Kurtz gives appropriate weight to advanced topics as well, like schemas, performance metrics, performance monitoring utilities, and SQL optimization techniques. And the final chapters provide crucial, advanced information about Tuxedo. An OverviewPeopleSoft makes packaged business-application software for larger companies. This chapter provides an introduction and overview of PeopleSoft, its technology, and its history. We'll take a very high-level look at some of the major parts that make up today's PeopleSoft systems, namely the database (in this case Oracle) that stores both the PeopleSoft application data and much of the application code, the Tuxedo Application Server, and the PeopleTools integrated development environment, which is used for most aspects of developing and administering PeopleSoft applications. We'll then step through the overall architecture of a PeopleSoft system and see how it has evolved from the initial client/server architecture to the modern four-tier Internet architecture. Finally, we'll take a look at what all this means to the database administrator (DBA) charged with maintaining a PeopleSoft application, and we'll consider the implications it has for the relationship between developers and DBAs on PeopleSoft systems. This introduction will help to put some of the following chapters into context. What Is PeopleSoft?Reuters' abridged business summary for PeopleSoft begins with this statement: PeopleSoft, Inc. designs, develops, markets and supports enterprise application software products for use throughout large and medium-sized organizations worldwide. These organizations include corporations, educational institutions and national, state, provincial and local government agencies. The Company provides enterprise application software for customer relationship management, human capital management, financial management and supply chain management, each with a range of industry-specific features and functions.1In 2003 PeopleSoft acquired J.D. Edwards. The products that were formerly PeopleSoft are now referred to as "PeopleSoft Enterprise." The products that were formerly J.D. Edwards are called "PeopleSoft EnterpriseOne" and "PeopleSoft World." This book is about PeopleSoft Enterprise software. There are currently eight Enterprise product lines that contain various modules:
There is no unique master-detail relationship between product lines and modules. Some modules are included in more than one product line. For example, there are HRMS and Payroll modules from HCM, and there are also Receivables and General Ledger modules from Financials in Service Automation. | |||