The first platform-independent guide to the discipline of database administration, this book presents best practices and procedures that apply to any database platform: Oracle, Microsoft, IBM, Sybase, even MySQL and Postgres. It will be an ideal resource for organizations that have deployed multiple databases -- and for professionals who want to move comfortably amongst database platforms. Craig Mullins begins with an up-to-date introduction to the field of database administration, outlining a broad range of DBA roles and responsibilities, and showing how evolving technology has changed the profession. He walks through creating the database environment; data modeling and normalization; database/application design; and change management. Next, he introduces best practices for maximizing availability, security, data integrity, and all aspects of system, database, and application performance. From data warehouse administration to Web-based data access, Database Administration: Practices and Procedures is a single source for authoritative guidance on every facet of database administration. For every database administrator, and for managers responsible for supervising database administrators.About the Author:
Craig S. Mullins is a data management strategist for BMC Software. Craig has more than fifteen years of experience in all facets of database systems development, including developing and teaching DB2 and SQL Server classes, systems analysis and design, database and system administration, and data analysis. He has used DB2 for OS/390 since Version 1 and has experience with Oracle, Sybase, and Microsoft SQL Server. Craig has worked as a DBA, developer, instructor, and analyst in multiple industries. 0201741296AB05142002
"Sobre este título" puede pertenecer a otra edición de este libro.
Descripción Addison-Wesley Professional, 2002. Paperback. Estado de conservación: New. 1. Nº de ref. de la librería DADAX0201741296
Descripción Addison-Wesley Professional, 2002. Estado de conservación: New. Brand New, Unread Copy in Perfect Condition. A+ Customer Service! Summary: (NOTE:Most chapters conclude with Summary, Review, Bonus Question and Suggested Reading.) Preface. How to Use This Book. Acknowledgments. About the Author. 1. What Is a DBA? The DBA: Revered or Reviled? Why Learn Database Administration? A Unique Vantage Point. DBA Salaries. Database Technology. The Management Discipline of Database Administration. A Day in the Life of a DBA. Evaluating a DBA Job Offer. Database, Data, and System Administration. Data Administration. Database Administration. System Administration. DBA Tasks. Database Design. Performance Monitoring and Tuning. Availability. Database Security and Authorization. Backup and Recovery. Data Integrity. DBMS Release Migration. Jack-of-All-Trades. Types of DBAs. System DBA. Database Architect. Database Analyst. Data Modeler. Application DBA. Task-Oriented DBA. Data Warehouse Administrator. Staffing Considerations. How Many DBAs? DBA Reporting Structures. Multiplatform DBA Issues. Test and Production. New Technology and the DBA. Procedural DBAs: Managing Database Logic. The Internet: From DBA to e-DBA. The PDA DBA. DBA Certification. The Rest of the Book. 2. Creating the Database Environment. Defining the Organization's DBMS Strategy. Choosing a DBMS. DBMS Architectures. DBMS Clustering. DBMS Proliferation. Hardware Issues. Installing the DBMS. DBMS Installation Basics. Hardware Requirements. Storage Requirements. Memory Requirements. Configuring the DBMS. Connecting the DBMS to Supporting Infrastructure Software. Installation Verification. DBMS Environments. Upgrading DBMS Versions and Releases. Features and Complexity. Complexity of the DBMS Environment. Reputation of the DBMS Vendor. Support Policies of the DBMS. Organization Style. DBA Staff Skill Set. Platform Support. Supporting Software. Fallback Planning. Migration Verification. The DBMS Upgrade Strategy. Database Standards and Procedures. Database Naming Conventions. Other Database Standards and Procedures. DBMS Education. 3. Data Modeling and Normalization. Data Modeling Concepts. Entity-Relationship Diagramming. The Components of a Data Model. Entities. Attributes. Keys. Relationships. Discovering Entities, Attributes, and Relationships. Conceptual, Logical, and Physical Data Models. What Is Normalization? The Normal Forms. First Normal Form. Second Normal Form. Third Normal Form. A Normalized Data Model. Further Normal Forms. Normalization in Practice. Additional Data Modeling Issues. 4. Database Design. From Logical Model to Physical Database. Transform Entities to Tables. Transform Attributes to Columns. Build Referential Constraints for All Relationships. Build Physical Data Structures. Database Performance Design. Designing Indexes. Hashing. Clustering. Interleaving Data. Denormali. Nº de ref. de la librería ABE_book_new_0201741296
Descripción Addison-Wesley Professional, 2002. Paperback. Estado de conservación: New. Nº de ref. de la librería P110201741296
Descripción Addison-Wesley Professional. PAPERBACK. Estado de conservación: New. 0201741296 New Condition. Nº de ref. de la librería NEW4.0089566
Descripción Estado de conservación: Brand New. Book Condition: Brand New. Nº de ref. de la librería 97802017412921.0