A Bibliography of Database Books

The following bibliography is culled from the second edition of my book, Database Administration: The Complete Guide to DBA Practices and Procedures. This listing of books was used as research material for the book, but also as suggested further reading for interested readers to dig into.

I have made no attempt to update this list, so there are likely to be quite a few new books that would be useful. At some point, I will probably post a list of books published after my DBA book that I recommend. Until then, enjoy this list…

Database Management and Database Systems

Abiteboul, Serge, et al. Foundations of Databases. Reading, MA: Addison-Wesley (1995). ISBN 0-201-53771-0

Ambler, Scott W. Agile Database Techniques: Effective Strategies for the Agile Software developer. New York, NY: John Wiley & Sons (2003). ISBN 0-471-20283-5

Ambler, Scott W. and Sadalage, Pramod J. Refactoring Databases: Evolutionary Database Design. Boston, MA: Addison-Wesley (2006). ISBN 0-321-29353-3

Atre, Shaku. Database: Structured Techniques for Design, Performance, and Management. 2nd ed. New York, NY: John Wiley & Sons (1988). ISBN 0-471-85251-1

Bell, David, and Jane Grimson. Distributed Database Systems. Wokingham, England: Addison-Wesley  (1992) ISBN 0-201-54400-8

Bobak, Angelo R. Distributed and Multi-Database Systems. New York, NY: Bantam Intertext (1993) ISBN 0-553-09156-5

Bontempo, Charles J., and Cynthia Maro Saracco. Database Management Principles and Products. Upper Saddle River, NJ: Prentice Hall PTR (1995) ISBN 0-13-380189-6

Bradley, James. Introduction to Database Management in Business. New York, NY: Holt, Rinehart, and Winston (1983). ISBN 0-03-061693-X

Brathwaite, Kenmore S. The Data Base Environment: Concepts and Applications. New York, NY: Van Nostrand Reinhold (1990). ISBN 0-442-00300-5

Brathwaite, Kenneth S. Systems Design in a Database Environment. New York, NY: McGraw-Hill (1989). ISBN 0-07-007250-7

Burleson, Donald K. Managing Distributed Databases. New York, NY: John Wiley & Sons (1994). ISBN 0-471-08623-1

Castano, Silvana, et al. Database Security. Wokingham, England: Addison-Wesley (1994). ISBN 0-201-59375-0

Celko, Joe. Data & Databases: Concepts In Practice. San Francisco, CA: Morgan Kaufmann (1999). ISBN 1-55860-432-4

Chisholm, Malcolm. Managing Reference Data in Enterprise Databases. San Francisco, CA: Morgan Kaufmann (2001). ISBN 1-55860-697-1

Chorafas, Dimitris. Handbook of Database Management and Distributed Relational Databases. Blue Ridge Summit, PA: Tab Books (1989). ISBN 0-8306-3253-0

Chorafas, Dimitris N., and Heinrich Steinmann. Solutions for Networked Databases. San Diego, CA: Academic Press (1993) ISBN 0-12-174060-9

Codd, E. F. The Relational Model for Database Management Version 2. Reading, MA: Addison-Wesley (1990). ISBN 0-201-14192-2

Connolly, Thomas and Begg, Carolyn, Database Systems: A Practical Approach to Design, Implementation, and Management, 4th edition, Harlow, England: Addison-Wesley (2004). ISBN 978-0321294012

———. Database Systems: A Practical Approach to Design, Implementation, and Management. 2nd ed. Harlow, England: Addison-Wesley (1998). ISBN 0-201-34287-1

Courtney, James F., and David B. Paradice. Database Systems for Management. 2nd ed. Homewood, IL: Irwin (1992). ISBN 0-256-08229-4

Date, C. J. An Introduction to Database Systems. 7th ed. Reading, MA: Addison-Wesley (2000). ISBN 0-201-38590-2

———. An Introduction to Database Systems, Volume II. Reading, MA: Addison-Wesley (1983, 1985). ISBN 0-201-14474-3

———. The Database Relational Model. Reading, MA: Addison-Wesley (2001). ISBN 0-201-61294-1

Date, C. J. and Hugh Darwen. Foundation for Object/Relational Databases: The Third Manifesto. Reading, MA: Addison-Wesley (1998). ISBN 0-201-30978-5

Delobel, Claude, et al. Databases: From Relational to Object-Oriented Systems. London, England: International Thomson Computer Press (1995). ISBN1-850-32124-8

Dittrich, Klaus R., and Andreas Geppert, eds. Component Database Systems. San Francisco, CA: Morgan Kaufmann (2001). ISBN 1-55860-642-4

Dunham, Jeff. Database Performance Tuning Handbook. New York, NY: McGraw-Hill (1998). ISBN 0-07-018244-2

Egan, David, et al. DBA’s Guide to Databases on Linux. Rockland, MD: Syngress Media (2000). ISBN 1-928994-04-0

Feiler, Jesse. Database-Driven Web Sites. San Francisco, CA: Morgan Kaufmann (1999). ISBN 0-12-251336-3

Fortier, Paul J. Database Systems Handbook. New York, NY: McGraw-Hill (1997). ISBN 0-07-021626-6

Gillenson, Mark L. Database Step-by-Step. 2nd ed. New York, NY: John Wiley & Sons (1990). ISBN 0-471-61759-8

Gilula, Mikhail M. The Set Model for Database and Information Systems. Reading, MA: ACM Press/Addison-Wesley (1994). ISBN 0-201-59379-3

Goldstein, Robert C. Database Technology and Management. New York, NY: John Wiley & Sons (1985). ISBN 0-471-88737-4

Goodson, John and Steward, Robert A. The Data Access Handbook. Upper Saddle River, NJ: Prentice Hall (2009). ISBN 0-13-714393-1

Grant, John. Logical Introduction to Databases. Orlando, FL: Harcourt Brace Jovanovich (1987). ISBN 0-15-551175-0

Hackathorn, Richard. Enterprise Database Connectivity. New York, NY: John Wiley & Sons (1993). ISBN 0-471-57802-9

House, William C., ed. Database Management. New York, NY: Petrocelli Books (1974). ISBN 0-88405-051-3

Jackson, Glenn A. Relational Database Design with Microcomputer Applications. Englewood Cliffs, NJ: Prentice Hall (1988). ISBN 0-13-771841-1

Johnson, James L. Database: Models, Languages, Design. New York, NY: Oxford University Press (1997). ISBN 0-19-510783-7

Kim, Won. Modern Database Systems. Reading, MA: ACM Press/Addison-Wesley (1995). ISBN 0-201-59098-0

Korth, Henry F., and Abraham Silberschatz. Database System Concepts. New York, NY: McGraw-Hill (1986). ISBN 0-07-044752-7

Larson, James A. Database Directions. Upper Saddle River, NJ: Prentice Hall PTR (1995) ISBN 0-13-290867-0

Lewis, Philip M., Arthur Bernstein, and Michael Kifer. Databases and Transaction Processing. Boston, MA: Addison-Wesley (2002) ISBN 0-201-70872-8

Loucopoulos, Pericles, and Roberto Zicari, eds. Conceptual Modeling, Databases, and CASE. New York, NY: John Wiley & Sons (1992). ISBN 0-471-55462-6

Martin, James. Computer Database Organization. Englewood Cliffs, NJ: Prentice Hall (1975). ISBN 0-13-165506-X

———. Managing the Database Environment. Englewood Cliffs, NJ: Prentice Hall Inc. (1983). ISBN 0-13-550582-8

Mattison, Robert M. Understanding Database Management Systems. New York, NY: McGraw-Hill (1993). ISBN 0-07-040973

McFadden, Fred R., Jeffrey A. Hoffer, and Mary B. Prescott. Modern Database Management. 5th ed. Reading, MA: Addison-Wesley (1999). ISBN 0-8053-6054-9

Mittra, Sitansu S., Database Performance Tuning and Optimization. New York, NY: Springer-Verlag (2003). ISBN 0-387-95393-0

O’Neil, Patrick. Database Principles, Programming, Performance. San Francisco, CA: Morgan Kaufmann (1994). ISBN 1-55860-219-4

Papadimitriou, Christos. The Theory of Database Concurrency Control. Rockville, MD: Computer Science Press (1986). ISBN 0-88175-027-1

Parsaye, Kamran, et al. Intelligent Databases. New York, NY: John Wiley & Sons (1989) ISBN 0-471-50345-2

Pascal, Fabian. Practical Issues in Database Management. Reading, MA: Addison-Wesley (2000). ISBN 0-201-48555-9

———. Understanding Relational Databases. New York, NY: John Wiley & Sons (1993). ISBN 0-471-58538-6

Piattini, Mario, and Oscar Diaz, eds. Advanced Database Technology and Design. Boston, MA: Artech House (2000): 0-89006-395-8

Podcameni, Silvio, Manfred Mittelmeir, and Michele Chilanti. Distributed Relational Database: Cross-Platform Connectivity and Applications. 3rd ed. Upper Saddle River, NJ: Prentice Hall PTR (1996). ISBN 0-13-570797-8

Pratt, Philip J., and Joseph J. Adamski. The Concepts of Database Management. 2nd ed. Cambridge, MA: International Thomsom Publishing (1997). ISBN 0-7600-4925-4

———. Database Systems Management and Design. 2nd ed. Boston, MA: Boyd & Fraser (1991). ISBN 0-87835-579-0

Purba, Sanjiv, ed. Handbook of Data Management 1999. Boca Raton, FL: Auerbach (1999). ISBN 0-8493-9976-9

———. High-Performance Web Databases. Boca Raton, FL: Auerbach (2000). ISBN 0-8493-0882-8

———. Data Management Handbook. 3rd ed. Boca Raton, FL: Auerbach (2000). ISBN 0-8493-9832-0

Riccardi, Greg. Principles of Database Systems with Internet and Java Applications. Boston, MA: Addison-Wesley (2001). ISBN 0-201-61247-X

Rob, Peter, and Carlos Coronel. Databse Systems: Design, Implementation, & Management. Cambridge, MA: Thomson Learning (2000). ISBN 0-7600-1090-0

Rothstein, Michael F., and Burt Rosner. The Professional’s Guide to Database Systems Project Management. New York, NY: John Wiley & Sons (1990). ISBN 0-471-62130-7

Ryan, Nick, and Dan Smith. Database Systems Engineering. London, England: International Thomson Computer Press (1995). ISBN1-85032-115-9

Salemi, Joe. Guide to Client/Server Databases. Emeryville, CA: ZD Press (1993) ISBN 1-56276-070-X

Saracco, Cynthia Maro. Universal Database Management: A Guide to Object/Relational Technology. San Francisco, CA: Morgan Kaufmann (1998). ISBN 1-55860-519-3

Schur, Stephen G. The Database Factory. New York, NY: John Wiley & Sons (1994). ISBN 0-471-55844-3

Shasha, Dennis A. Database Tuning: A Principled Approach. Englewood Cliffs, NJ: Prentice Hall (1992) ISBN 0-13-205246-6.

Shepherd, John C. Database Management: Theory and Applications. Homewood, IL: Irwin (1990). ISBN 0-256-07829-7

Simon, Alan R. Strategic Database Technology. San Francisco, CA: Morgan Kaufmann (1995). ISBN 1-55860-264-X

Stonebraker, Michael, and Paul Brown. Object-Relational DBMSs: Tracking the Next Great Wave. 2nd ed. San Francisco, CA: Morgan Kaufmann (1999). ISBN 1-55860-452-9

Stonebraker, Michael, ed. Readings in Database Systems. San Mateo, CA: Morgan Kaufmann (1988). ISBN 0-934613-65-6

Sweet, Frank. Consultant’s Handbook of Database Design. Jacksonville, FL: Boxes & Arrows (1988). ISBN 0-939479-03-6

Thuraisingham, Bhavani M. Data Management Systems: Evolution & Interoperation. Boca Raton, FL: CRC Press (1997). ISBN 0-8493-9493-7

Ullman, Jeffrey D., and Jennifer Widom. A First Course in Database Systems. Upper Saddle River, NJ: Prentice Hall (1997) ISBN 0-13-861337-0

Widom, Jennifer, and Stefano Ceri, eds. Active Database Systems: Triggers and Rules for Advanced Database Processing, San Francisco, CA: Morgan Kaufmann (1996). ISBN 1-55860-304-2

Yang, Chao-Chih. Relational Databases. Englewood Cliffs, NJ: Prentice Hall (1986). ISBN 0-13-771858-6

Zaniolo, Carlo, et al. Advanced Database Systems. San Francisco, CA: Morgan Kaufmann (1997). ISBN 1-55860-443-X

Data Administration, Data Modeling, and Database Design

Allen, Sharon and Terry, Evan, Beginning Relational Data Modeling, 2nd edition, Berkeley, CA: APress (2005): ISBN 1-59059-463-0.

Ambler, Scott W., Agile Modeling, New York, NY: John Wiley & Sons (2002): ISBN 0-471-20282-7.

Baca, Murtha (editor). Introduction to Metadata, Version 3. Los Angeles, CA: Getty Publications (2008). ISBN 978-0-89236-896-9 

Batini, Carlo, et al, Conceptual Database Design: An Entity-Relationship Approach, Redwood City, CA: Benjamin/Cummings (1992): ISBN 0-8053-0244-1.

Bruce, Thomas A. Designing Quality Databases with IDEF1X Information Models. New York, NY: Dorset House (1991). ISBN 0-932633-18-8

Carlis, John, and Joseph Maguire. Mastering Data Modeling: A User-Driven Approach. Boston, MA: Addison-Wesley (2001). ISBN 0-201-70045-X.

Chmura, Alan and Heumann, J. Mark, Logical Data Modeling: What It Is and How To Do It, New York, NY: Springer Sicence + Business Media (2005): ISBN 0-387-22950-7.

Chrucher, Clare. Beginning Database Design: From Novice to Professional. New York, NY: APress (2007). ISBN 978-1-59059-769-9

Codd, E. F. “Further Normalization of the Database Relational Model,” in Data Base Systems. Courant Computer Science Symposia Seriues, Vol. 6. Englewood Cliffs, N.J.: Prentice Hall (1972).

Durell, William R. Data Administration: A Practical Guide to Successful Data Management. New York, NY: McGraw-Hill (1985). ISBN 0-07-018391-0

———. The Complete Guide to Data Modeling. Princeton, NJ: Data Administration, Inc. (1993): No ISBN

English, Larry. Improving Data Warehouse and Business Information Quality. New York, NY: John Wiley & Sons (1999). ISBN 0-471-25383-9

Fleming, Candace, and Barbara von Halle. Handbook of Relational Database Design. Reading, MA: Addison-Wesley (1989). ISBN 0-201-11434-8

Halpin, Terry and Morgan, Tony, Information Modeling and Relational Databases, 2nd edition, Burlington, MA: Morgan Kaufmann (2008): ISBN 978-0-12-373568-3.

Harrington, Jan L., Relational Database Design: Clearly Explained, 2nd edition, San Francisco, CA: Morgan Kaufmann (2002). ISBN 1-55860-820-6.

Hay, David C. Data Model Patterns. New York, NY: Dorset House (1996). ISBN 0-932633-29-3

Hernandez, Michael J. Database Design for Mere Mortals, 2nd edition. Boston, MA: Addison-Wesley (2003). ISBN 0-201-75284-0

Hoberman, Steve, Data Modeling Made Simple, Bradley Beach, NJ: Technics Publications (2005): ISBN 0-97714090-0-8.

Hogan, Rex. A Practical Guide to Database Design. Englewood Cliffs, NJ: Prentice Hall (1990). ISBN 0-13-690967-1

Inmon, W. H. Data Architecture: The Information Paradigm. Wellesley, MA: QED Information Sciences (1989). ISBN 0-89435-268-7

Kliewer, Bradley D. Database Modeling in the PC Environment. New York, NY: Bantam Books (1992). ISBN 0-553-08952-8

Lahdenmaki, Tapio and Leach, Michael. Relational Database Index Design and the Optimzers. Hoboken, NJ: John Wiley & Sons (2005). ISBN 0-471-71999-4

Lefkovits, Henry C. IBM’s Repository Manager/MVS. Wellesley, MA: QED Information Sciences (1991). ISBN 0-89435-349-7

Lightstone, Sam, et al, Physical Database Design. San Francisco, CA: Morgan Kaufmann (2007). ISBN 978-0-12-369389-1.

Marco, David. Building and Managing the Meta Data Repository. New York, NY: John Wiley & Sons (2000). ISBN 0-471-35523-2

Marco, David and Jennings, Michael. Universal Meta Data Models. New York, NY: John Wiley & Sons (2004). ISBN 0-471-08177-9

Modell, Martin E. Data Analysis, Data Modeling, and Classification. New York, NY: McGraw-Hill (1992). ISBN 0-07-042634-1

Mosley, Mark, et al. The DAMA Guide to The Data Management Body of Knowledge. Bradley Beach, NJ: Technics Publications (2009). ISBN 978-0-9771400-8-4

Muller, Robert J., Database Design for Smarties: Using UML for Data Modeling, San Francisco, CA: Morgan Kaufmann (1999): ISBN 1-55860-515-0.

Perkinson, Richard C. Data Analysis: The Key to Database Design. Wellesley, MA: QED Information Sciences (1984). ISBN 0-89435-105-2

Riordan, Rebecca M. Designing Effective Database Systems. Saddle River, NJ: Addison-Wesley (2003). ISBN 0-321-29093-3

Rishe, Naphtali. Database Design: The Semantic Modeling Approach. New York, NY: McGraw-Hill (1992). ISBN 0-07-052955-8

Ross, Ronald G. Entity Modeling: Techniques and Application. Boston, MA: Database Research Group (1988). ISBN 0-941049-00-0

Sanders, G. Lawrence. Data Modeling. Danvers, MA: Boyd & Fraser Publishing Company (1995). ISBN 0-87709-066-1.

Schmidt, Bob. Data Modeling for Information Professionals. Upper Saddle River, NJ: Prentice Hall PTR (1999) ISBN 0-13-080450-9.

Silverston, Len, et al, The Data Model Resource Book, New York, NY: John Wiley & Sons (2002): ISBN: 0-471-15264-8.

Simsion, Graeme C. and Witt, Graham C., Data Modeling Essentials, 3rd edition, San Francisco, CA: Morgan Kaufmann (2005): ISBN 0-12-644551-6.

Stephens, Ryan K., and Ronald R. Plew. Database Design. Indianapolis, IN: SAMS Publishing (2001). ISBN 0-672-31758-3

Tannenbaum, Adrienne. Metadata Solutions. Boston, MA: Addison-Wesley (2002). ISBN 0-201-71976-2

———. Implementing a Corporate Repository: The Model Meets Reality. New York, NY: Wiley Professional Computing (1994). ISBN 0-471-58537-8

Teory, Toby, et al. Database Design: Know It All. San Francisco, CA: Morgan Kaufmann (2002). ISBN 978-0-12-374630-6.

Weilkiens, Tim and Oestereich, Bernd, UML 2 Certification Guide, San Francisco, CA: Morgan Kaufmann (2007): ISBN 978-0-12-373585-0.

Wertz, Charles K. The Data Dictionary: Concepts and Uses. Wellesley, MA: QED Information Sciences (1986). ISBN 0-89435-180-X

Wurman, Richard Saul. Information Anxiety. New York, NY: Doubleday (1989). ISBN 0-385-24394-4

Database Security, Protection and Compliance

Afyouni, Hassan A. Database Security and Auditing: Protecting Data Integrity and Accessibility. Boston, MA: Thomson (2006). ISBN 0-619-21559-3

Anand, Sanjay. Sarbanes-Oxley Guide for Finance and Information Technology Professionals, 2nd edition. Hoboken, NJ: Wiley (2006). ISBN 0-471-78533-9

Ben Natan, Ron. Implementing Database Security and Auditing. Oxford, UK: Elsevier Digital Press (2005). ISBN 978-1-55558-334-7

Castano, Silvana, Mariagrazia Fugini, Giancarlo Martella, and Pierangela Samarati. Database Security. Wokingham, England: Addison-Wesley/ACM Press (1995). ISBN 0-201-59375-0

Clarke, Justin. SQL Injection Attacks and Defense. Burlington, MA: Syngress (2009). ISBN 978-1597494243

Cougias, Dorian J., et al. Say What You Do: Building a framework of IT controls, policies, standards, and procedures. Lecanto, FL: Schaser-Vartan (2007). ISBN 978-0-9729039-6-7

Denning, Dorothy E., Cryptography and Data Security. Reading, MA: Addison Wesley (1983). ISBN 0-201-10150-5

Fowler, Kevvie. SQL Server Forensic Analysis. Upper Saddle River, NJ: Addison Wesley (2009). ISBN 978-0-321-54436-0

Ingram, Aaron and Shaul, Josh. Practical Oracle Security. Rockland, MA: Syngress (2007). ISBN 978-1-59749-198-3

IT Governance Institute. CobiT 4.0: Control Objectives, Management Guidelines, Maturity Models. Rolling Meadows, IL: IT Governance Institute (2005). ISBN 1-933284-37-4

Kenan, Kevin. Cryptography in the Database: The Last Line of Defense. Upper Saddle River, NJ: Symantec Press/Addison-Wesley (2006). ISBN 0-321-32073-5

Litchfield, David, et al. The Database Hacker’s Handbook: Defending Database Servers. Indianapolis, IN: Wiley (2005). ISBN 0-7645-7801-4

Olson, Jack E. Database Archiving: How to Keep Lots of Data for a Very Long Time. Burlington, MA: Morgan Kaufmann (2009). ISBN 978-0-12-374720-4

———. Data Quality: The Accuracy Dimension. San Francisco, CA: Morgan Kaufmann (2003). ISBN 1-55860-891-5

Oram, Andy and Viega, John. Beautiful Security. Sebastopol, CA: O’Reilly (2009). ISBN 978-0-596-52748-8

Ottman Jr., John B. Save the Database, Save the World! New York, NY: Sumo Press (2010). ISBN 978-1-4583-6368-8

Perry, William E., Control in a Data Base Environment, Wellesley, MA: Q.E.D. Information Sciences (1980). ISBN 0-89435-042-0

Redman, Thomas C., Data Quality: Management and Technology, New York, NY: Bantam (1992). ISBN 0-553-09149-2

———. Data Quality: The Field Guide, Boston, MA: Digital Press (2001). ISBN 1-55558-251-6

Schuler, Karen, et al. E-discovery: Creating and Managing an Enterprisewide Program. Burlington, MA: Syngress (2009). ISBN 978-1-59749-296-6

Thomas, Gwen. Alpha Males and Data Disasters: The Case for Governance. Orlando, FL: Brass Cannon Press (2006). ISBN 978-0-0786579-0-1

Thuraisingham, Bhavani. Database and Applications Security: Integrating Information Security and Data Management. Boca Raton, FL: Auerbacj (2005). ISBN 0-8493-2224-3

Wright, Craig, et al. The IT Regulatory and Standards Compliance Handbook: How to Survive an Information Systems Audit and Assessments. Burlington, MA: Syngress (2008). ISBN 978-1-59749-266-9

Data Warehousing

Adamson, Christopher. Star Schema: The Complete Reference. New York, NY: McGraw-Hill (2010). ISBN 978-0-07-174432-4

Adelman, Sid, et al. Impossible Data Warehouse Solutions: Solutions from the Experts. Boston, MA: Addison-Wesley (2003). ISBN 0-201-76033-9

Barquin, Ramon, and Herb Edelstein, eds. Planning and Designing the Data Warehouse. Upper Saddle River, NJ: Prentice Hall (1997). ISBN 0-13-255746-0

Devlin, Barry. Data Warehouse from Architecture to Implementation. Reading, MA: Addison-Wesley (1997). ISBN 0-201-96245-2

Hackney, Douglas. Understanding and Implementing Successful Data Marts. Reading, MA: Addison-Wesley (1997). ISBN 0-201-18380-3

Inmon, W. H. Building the Data Warehouse. 2nd ed. New York, NY: John Wiley & Sons (1996). ISBN 0-471-14161-5

Inmon, W. H., and Richard Hackathorn. Using the Data Warehouse. New York, NY: John Wiley & Sons (1994). ISBN 0-471-05966-8

Inmon, W. H., Claudia Imhoff, et al. Building the Operational Data Store. New York, NY: John Wiley & Sons (1996). ISBN 0-471-12822-8

Inmon, W. H., John A. Zachman, et al. Data Stores, Data Warehousing and the Zachman Framework. New York, NY: McGraw-Hill (1997). ISBN 0-07-031429-2

Kelly, Sean. Data Warehousing in Action. New York, NY: John Wiley & Sons (1997). ISBN 0-471-96640-1

Kimball, Ralph. The Data Warehouse Toolkit: The Complete Guide to Dimensional Modeling (Second Edition) New York, NY: John Wiley & Sons (2002). ISBN 0-471-20024-7

Lewis, William J. Data Warehousing and E-Commerce. Upper Saddle River, NJ: Prentice Hall (2001). ISBN 0-13-091154-2

Poe, Vidette. Building a Data Warehouse for Decision Support. Upper Saddle River, NJ: Prentice Hall (1996). ISBN 0-13-371121-8

Witten, Ian H. and Frank, Eibe. Data Mining: Practical Machine Learning Tools and Techniques. San Francisco, CA: Morgan Kaufmann (2005). ISBN 0-12-088407-0

SQL

Beighley, Lynn. Head First SQL. Sebastopol, CA: O’Reilly (2007). ISBN 978-0-596-52684-9

Bhamidipati, Kishore. SQL Programmer’s Reference. Berkeley, CA: Osborne/McGraw-Hill (1998). ISBN 0-07-882460-5

Celko, Joe. SQL For Smarties: Advanced SQL Programmin, 4th edition. San Francisco, CA: Morgan Kaufmann (2011). ISBN 978-0-12-382022-8

———. SQL Programming Style. San Francisco, CA: Morgan Kaufmann (2005). ISBN 0-12-088797-5

———. Data, Measurements and Standards in SQL. San Francisco, CA: Morgan Kaufmann (2010). ISBN 978-0-12-374722-8

———. Thinking in Sets: Auxiliary, Temporal, and Virtual Tables in SQL. San Francisco, CA: Morgan Kaufmann (2008). ISBN 978-0-12-374137-0

Cumming, Andrew and Russell, Gordon. SQL Hacks: Tips & TRools for Digging into Your Data. Sebastopol, CA: O’Reilly (2007). ISBN 978-0-596-52799-0      

Date, C. J., with Darwen, Hugh. A Guide to the SQL Standard. 4th ed. Reading, MA: Addison-Wesley (1997). ISBN 0-201-96426-0

Donahoo, Michael J. and Speegle, Gregory D. SQL: Practical Guide for Developers. San Francisco, CA: Morgan Kaufmann (2005). ISBN 978-0-12-220531-6

Faroult, Stephane. The Art of SQL. Sebastopol, CA: O’Reilly (2006). ISBN 0-596-00894-5

Groff, James R., and Paul N. Weinberg. LAN Times Guide to SQL. Berkeley, CA: Osbourne-McGraw-Hill (1994). ISBN 0-07-882026-X

Gulutzan, Peter, and Trudy Pelzer. SQL-99 Complete, Really. Lawrence, KS: R&D Books (1999). ISBN 0-87930-568-1

———. SQL Performance Tuning. Boston, MA: Addison-Wesley (2003). ISBN 0-201-79169-2

Harrington, Jan L. SQL Clearly Explained 3rd edition. Burlington, MA: Morgan Kaufmann (2010). ISBN 978-0-12-375607-8

Houlette, Forrest, Troubleshooting SQL. Berkeley, CA: Osbourne/McGraw-Hill (2001). ISBN 0-07-213489-5

Kline, Kevin. SQL in a Nutshell, 3rd edition. Sebastopol, CA: O’Reilly (2009). ISBN 978-0-596-51884-4

Limeback, Rudy. Simply SQL: The Fun and Easy Way to Learn Best Practice SQL. Collingwood VIC Australia: Sitepoint (2008). ISBN 978-0-9804552-5-0

Melton, Jim. Advanced  SQL 1999: Understanding Object-Relational and Other Advanced Features. San Francisco, CA: Morgan Kaufmann (2003). ISBN 1-55860-677-7

———. Understanding SQL’s Stored Procedures: A Complete Guide to SQL/PSM. San Francisco, CA: Morgan Kaufmann (1998). ISBN 1-55860-461-8

Molinaro, Anthony. SQL Cookbook. Sebastopol, CA: O’Reilly (2006). ISBN 978-0-596-00976-2

Tow, Dan. SQL Tuning. Sebastopol, CA: O’Reilly (2004). ISBN 0-596-00573-3

Object Orientation and Database Management

Barry, Douglas K. The Object Database Handbook. New York, NY: John Wiley & Sons (1996). ISBN 0-471-14718-4

Brathwaite, Kenmore S. Object-Oriented Database Design: Concepts and Application. San Diego, CA: Academic Press (1993). ISBN 0-12-125882-3

Cattell, R. G. G. Object Data Management. Reading, MA: Addison-Wesley (1992). ISBN 0-201-53092-9

Hughes, John G. Object-Oriented Databases. New York, NY: Prentice Hall (1991). ISBN 0-13-629882-6

Kroha, Petr. Objects and Databases. London, England: McGraw-Hill (1993). ISBN 0-07-707790-3

Loomis, Mary. Object Databases: The Essentials. Reading, MA: Addison-Wesley (1995). ISBN 0-201-56341-X

Taylor, David A. Object-Oriented Technology: A Manager’s Guide. Reading, MA: Addison-Wesley (1990). ISBN 0-201-56358-4

Operating Systems

Bruzzese, J. Peter, Barrett, Ronald, and Dipchan, Wayne. Windows Server 2008: How To. Indianapolis, IN: SAMS (2010). ISBN 978-0-672-33075-9

Hassell, Jonathan, Learning Windows Server 2003, 2nd ed. Sepastopol, CA: O’Reilly (2006). ISBN 0-596-10123-6

Johnson, Robert H. MVS Concepts and Facilities. New York, NY: McGraw-Hill (1989). ISBN 0-07-032673-8

Nemeth, Evi, et al. UNIX and Linux System Administration Handbook, 4th edition. Upper Saddle River, NJ: Prentice-Hall (2010). ISBN 978-0131480056

Reiss, Levi, and Joseph Radin. Unix System Administration Guide. Berkeley, CA: Osborne McGraw-Hill (1993). ISBN 0-07-881951-2

Samson, Steven L., MVS Performance Management. New York, NY: McGraw-Hill (1997). ISBN 0-07-057700-5

Young, John. Exploring IBM’s New Age Mainframes, 5th edition. Gulf Breeze, FL: Maximum Press (1998). ISBN 978-1885068156

Related Topics

Abiteboul, Serge, et al. Data on the Web: From Relations to Semistructured Data and XML. San Francisco, CA: Morgan Kaufmann (2000). ISBN 1-55860-622-X

Allspaw, John. The Art of Capacity Planning. Sebastopol, CA: O’Reilly (2008). ISBN 978-0-596-51857-8

Anagol-Subbarao. J2EE Web Services on BEA WebLogic. Upper Saddle River, NJ: Prentice Hall (2005). ISBN 0-13-143072-6

Applequist, Daniel K., XML and SQL: Developing Web Applications, Boston, MA: Addison-Wesley (2002). ISBN 0-201-65796-1

Bell, Judy Kay. Disaster Survival Planning: A Practical Guide for Businesses. Port Hueneme, CA: Disaster Survival Planning, Inc. (1991)

Bernstein, Philip A., and Eric Newcomer. Principles of Transaction Processing. San Francisco, CA: Moirgan Kaufmann (1997). ISBN 1-55860-415-4

Ceri, Stefano, et al. Designing Data-Intensive Web Applications. San Francisco, CA: Morgan Kaufmann (2003). ISBN 1-55860-190-2

Chantico Publishing Company, Inc. Disaster Recovery Handbook. Blue Ridge Summit, PA: Tab Professional & Reference Books (1991) ISBN 0-8306-7663-5

de Guise, Preston. Enterprise Systems Backup and Recovery: A Corporate Insurance Policy. Boca Raton, FL: Auerbach/CRC Press (2009). ISBN 978-1-4200-7639-4

DeMarco, Tom and Lister, Timothy. Peopleware: Productive Projects and Teams. New York, NY: Dorset House (1987). ISBN 0-932633-05-6

Dix, Paul. Service-Oriented Design with Ruby and Rails. Reading, MA: Addison-Wesley (2010). ISBN 978-0-3216-5936-1

Eddy, Sandra E. XML in Plain English. Foster City, CA: M&T Books (1998). ISBN 0-7645-7006-4

EMC Education Services, Information Storage and Management: Storing, Managing, and Protecting Digital Information. Indianapolis, IN: Wiley Publishing (2009). ISBN 978-0-470-29421-5

Freedman, Daniel P., and Gerald M. Weinberg. Handbook of Walkthroughs, Inspections, and Technical Reviews. New York, NY: Dorset House (1990). ISBN 0-932633-19-6

Fronckowiak, John W. Teach Yourself OLE DB and ADO in 21 Days. Indianapolis, IN: SAMS Publishing (1997). ISBN 0-672-31083-X

Gagliardi, Gary. Client/Server Computing. Englewood Cliffs, NJ: Prentice Hall PTR (1994). ISBN 0-13-290784-4

Gane, Chris and Sarson, Trish. Structured Systems Analysis: Tools & Techniques. St. Louis, MO: IST Data Books (1980). ISBN 0-930196-00-7

Geiger, Kyle. Inside ODBC. Redmond, WA: Microsoft Press (1995). ISBN 1-55615-815-7

Ginac, Frank P. Creating High Performance Software Development Teams. Upper Saddle River, NJ: Prentice Hall (2000). ISBN 0-13-085083-7

Gunther, Neil J., The Practical Performance Analyst, Lincoln, NE: Authors Choice Press (2000) ISBN 0-595-12674-X

Gray, Jim, and Andreas Reuter. Transaction Processing: Concepts and Techniques. San Francisco, CA: Morgan Kaufmann (1993). ISBN 1-55860-190-2

Jennings, Roger. Database Developer’s Guide with Visual Basic 6. Indianapolis, IN: SAMS Publishing (1999). ISBN 0-672-31063-5

Jepson, Brian. Java Database Programming. New York, NY: John Wiley & Sons (1997). ISBN 0-471-16518-2

Johnston, Tom and Weiss, Randall. Managing Time in Relational Databases. Burlington, MA: Morgan Kaufmann (2010). ISBN 978-0-12-375041-9

Kaute, Pierre Henri; Harris, Tobin; Bauer, Christian; and King, Gavin. NHibernate in Action. Greenwich, CT: Manning Publications (2009). ISBN 978-1932394924

Khoshafian, Setrag, et al. A Guide to Developing Client/Server SQL Applications. San Mateo, CA: Morgan Kaufmann (1992). ISBN 1-55860-147-3

Koch, Richard. The 80/20 Principle. New York, NY: Currency/Doubleday (1998) ISBN 0-385-49170-0

Limoncelli, Thomas A., et al. The Practice of System and Network Administration. Boston, MA: Addson-Wesley (2007). ISBN 978-0321492661

Loosely, Chris, and Frank Douglas. High Performance Client/Server. New York, NY: John Wiley & Sons (1998) ISBN 0-471-16269-8.

Marguerie, Fabrice; Eichert, Steve; and Wooley, Jim. LINQ in Action. Greenwich, CT: Manning Publications (2008). ISBN 978-1933988160

McClain, Gary. OLTP Handbook. New York, NY: McGraw-Hill (1993). ISBN 0-07-044985-6

Orfali, Robert, Dan Harkey, and Jeri Edwards, Essential Client/Server Survival Guide. New York, NY: Van Nostrand Reinhold (1994) ISBN 0-442-01941-6

O’Reilly Media. Big Data Now. Sebastopol, CA: O’Reilly (2001). ISBN 978-1-449-31518-4

Patrick, Tim. ADO.NET 4: Step by Step. Sebastopol, CA: Microsoft Press (2010). ISBN 978-0-7356-3888-4

Photopoulos, Constantine, Managing Catastrophic Loss of Senstive Data. Burlington, MA: Syngress (2008). ISBN 978-1-59749-239-3

Piedad, Floyd, and Michael Hawkins. High Availability: Design, Techniques and Processes. Upper Saddle River, NJ: Prentice Hall PTR (2001). ISBN 0-13-096288-0

Poelker, Christopher and Nikitin, Alex. Storage Area Networks for Dummies. Indianapolis, IN: Wiley Publishing (2003). ISBN 0-7645-2480-1

Pugh, Eric and Gradecki, Joseph D. Professional Hibernate. Indianapolis, IN: Wrox (2004). ISBN 0-7645-7677-1

Reese, George. Java Database Best Practices. Sebastopol, CA: O’Reilly (2003). ISBN 0-596-00522-9

Rinehart, Martin. Java Database Development. Berkeley, CA: McGraw-Hill (1998). ISBN 0-07-882356-0

Sheldon, Tom, ed. LAN Times Guide to Interoperability. Berkeley, CA: McGraw-Hill (1994) ISBN 0-07-882043-X

Sceppa, David. Programming Microsoft ADO.NET. Sebastopol, CA: Microsoft Press (2012). ISBN 978-0-7356-4801-2

Strauss, Melvin J. Computer Capacity: A Production Control Approach, New York, NY (1981) ISBN 0-442-26243-4

Sturm, Rick, Wayne Morris, and Mary Jander. Foundations of Service Level Management. Indianapolis, IN: SAMS Publishing (2000) ISBN 0-672-31743-5.

Sungard Recovery Services, Inc. Action Plan for Disaster (1995)

Taylor, Ed. Demystifying SNA. Plano, TX: Wordware (1993): 1-55622-404-4

———. Demystifying TCP/IP. Plano, TX: Wordware (1993): 1-55622-400-1

Terplan, Kornel and Hintington-Lee, Jill. Distributed Systems and Network Management. New York, NY: Van Nostrand Reinhold (1995). ISBN 0-442-01873-8

Thornburgh, Ralph H. and Barry J. Shoenborn. Storage Area Networks. Upper Saddle River, NJ: Prentice Hall PTR (2000) ISBN 0-13-027959-5

Toigo, Jon William. The Holy Grail of Data Storage Management. Upper Saddle River, NJ: Prentice Hall PTR (2000) ISBN 0-13-013055-9

———. The Holy Grail of Network Storage Management. Upper Saddle River, NJ: Prentice Hall PTR (2004). ISBN 0-13-148968-2

———. Disaster Recovery Planning. 2nd ed. Upper Saddle River, NJ: Prentice Hall PTR (2000) ISBN 0-13-084506-X

Walmsley, Priscilla. XQuery. Sebastopol, CA: O’Reilly (2007). ISBN 978-0-596-00634-1

DB2 (Db2)

Bond, Rebecca, et al. Understanding DB2 9 Security. Indianapolis, IN: IBM Press (2007). ISBN 0-13-134590-7

Chong, Raul, et al. Understanding DB2: Learning Visually with Examples. Indianapolis, IN: IBM Press (2005). ISBN 0-13-185916-1

Eaton, Chris. High Availability Guide for DB2. Upper Saddle River, NJ: Prentice Hall (2004). ISBN 978-0768682205

Mullins, Craig S. DB2 Developer’s Guide. 6th ed. Boston, MA: IBM Press (2012). ISBN 978-0132836425

Garvin, Curtis and Eckols, Steve. DB2 for the COBOL Programmer Part 1, 2nd edition. Fresno, CA: Mike Murach & Associates (1999). ISBN 1-890774-16-2

Garvin, Curtis and Prince, Anne. DB2 for the COBOL Programmer Part 2, 2nd edition. Fresno, CA: Mike Murach & Associates (1999). ISBN 1-890774-03-0

IMS

Geller, Joseph R. IMS Administration, Programming, and Database Design. New York, NY: John Wiley & Sons (1989). ISBN 0-471-62185-4

Hogan, Rex. Diagnostic Techniques for IMS Databases. Wellesley, MA: QED Information Sciences (1986). ISBN 0-89435-174-5

Hubbard, George U. IMS (DL/1) Database Organization and Performance. New York, NY: Van Nostrand Reinhold (1986). ISBN 0-442-23583-6

Lyon, Lockwood, The IMS/VS Expert’s Guide. New York, NY: Van Nostrand Reinhold (1990). ISBN 0-442-23977-7

Meltz, Dean, et al, An Introduction to IMS. Upper Saddle River, NJ: IBM Press/Pearson (1995). ISBN 0-13-185671-5

MySQL

Beighley, Lynn, and Morrison, Michael. Head First PHP & MySQL. Sebastopol, CA: O’Reilly (2009). ISBN 978-0-596-00630-3

Bell, Charles, et al. MySQL High Availability. Sebastopol, CA: O’Reilly (2010). ISBN 978-0-596-80730-6

Cabral, Sheeri K.and Murphy, Keith. MySQL Administrator’s Bible. Indianapolis, IN: Wiley (2009). ISBN 978-0-470-41691-4

MySQL AB, MySQL Administrator’s Guide and Language Reference (2nd Edition). Indianapolis, IN: MySQL Press (2006). ISBN 0-672-32870-4

Reese, George, et al. Managing & Using MySQL, 2nd edition. Sebastopol, CA: O’Reilly (2002). ISBN 0-596-00211-4

Schwartz, Baron, et al. High Performance MySQL, 2nd edition. Sebastopol, CA: O’Reilly (2008). ISBN 978-0-596-10171-8

Smirnova, Sveta. MySQL Troubleshooting. Sebastopol, CA: O’Reilly (2012). ISBN 978-1-449-31200-8

Yank, Kevin. Build Your Own Database Driven Web Site Using PHP and MySQL, 3rd edition. Collingwood, VIC, Australia (2004). ISBN 0-9752402-1-8

Oracle

Bach, Martin and Shaw, Steve.  Pro Oracle Database 11g RAX on Linux, New York, NY: APress (2010). ISBN 978-1-4302-2959-9

Bales, Donald. Java Programming with Oracle JDBC. Sebastopol, CA: O’Reilly (2002). ISBN 0-596-00088-X

Caffrey, Melanie, and Douglas Scherer. Oracle DBA Interactive Workbook. Upper Saddle River, NJ: Prentice Hall/PTR (2001). ISBN 0-13-015742-2

Carpenter, Larry. Oracle Data Guard 11g Handbook. Berkeley, CA: McGraw-Hill/Oracle Press (2009). ISBN 978-0-07-162111-3

Foot, Christopher T. OCP Instructors Guide for Oracle DBA Certification, Kittrell, NC: Rampant Techpress (2003). ISBN 0-9744355-3-8

Freeman, Robert and Hart, Matthew. Oracle RMAN 11g Backup and Recovery. Berkeley, CA: Oracle Press/McGraw-Hill (2010). ISBN 978-0-07-162860-0

Harrison, Guy. Oracle Performance Survival Guide: A Systematic Approach to Database Optimization. Boston, MA: Prentice Hall (2009). ISBN 978-0137011957

Jesse, Scott, et al. Oracle Database 11g Release 2 High Availability: Maximize Your Availability with Grid Infrastructure, RAC and Data Guard.  Berkeley, CA: McGraw-Hill (2011). ISBN 978-0-07-175208-4

Kreines, David C., and Brian Laskey. Oracle Database Administration: The Essential Reference. Sebastapol, CA: O’Reilly (1999). ISBN 1-56592-516-5

Kyte, Thomas. Effective Oracle by Design. New York, NY: McGraw-Hill (2003). ISBN 0-07-223065-7

———. Expert Oracle Database Architecture: Oracle Database 9i, 10g, and 11g Programming Techniques and Solutions. New York, NY: APress (2010). ISBN 978-143022946-9

Lawson, Christopher. The Art and Science of Oracle Performance Tuning. Birmingham, UK: Curlingstone (2003). ISBN 1-904347-01-0

Lewis, Jonathan. Cost-Based Oracle Fundamentals. New York, NY: APress (2006). ISBN 1-59059-636-6

———. Oracle Core: Essential Internals for DBAs and Developers. New York, NY: APress (2011). ISBN-13:978-1430239543

Loney, Kevin. Oracle Database 11g: The Complete Reference. Berkeley, CA: McGraw-Hill/Oracle Press (2008). ISBN 978-0-07-159875-0

Price, Jason. Java Programming with Oracle SQLJ. Sebastopol, CA: O’Reilly (2001). ISBN 0-596-00087-1

Velpuri, Rama. Oracle Backup & Recovery Handbook. Berkeley, CA: Osborne/McGraw-Hill (1995)  ISBN 0-07-882323-4

SQL Server

Baird, Sean, et al. SQL Server System Administration. Indianapolis, IN: New Riders (1999). ISBN 1-56205-955-6

Bertucci, Paul. Microsoft SQL Server High Availability. Indianapolis, IN: SAMS (2005). ISBN 0-672-32625-6

Colledge, Rod. SQL Server 2008 Administration In Action. Greenwich, CT: Manning (2010). ISBN 978-1-933988-72-6

Fowler, Kevvie. SQL Server Forensic Analysis. Upper Saddle River, NJ: Addison-Wesley (2009). ISBN 978-0-321-54436-0

Kehayias, Jonathan and Krueger, Ted. Troubleshooting SQL Server – A Guide for the Accidental DBA. Cambridge, UK: Red Gate (2011). ISBN 978-1-906434-77-9

Otey, Michael. Microsoft SQL Server 2008 High Availability with Clustering & Database Mirroring.  Berkeley, CA: McGraw-Hill (2010). ISBN 978-0-07-149813-5

Henderson, Ken. The Guru’s Guide to SQL Server Architecture and Internals. Boston, MA: Addison-Wesley (2004). ISBN 0-201-70047-6

Horninger, Mark, et al. The Real MCTS SQL Server 2008 Exam 70-432: Database Implementation and Maintenance Prep Kit. Burlington, MA: Syngress (2009). ISBN 978-1-59749-420-5

———. The Real MCTS SQL Server 2008 Exam 70-433: Database Design Prep Kit. Burlington, MA: Syngress (2009). ISBN 978-1-59749-421-2

McBath, Frank. SQL Server Backup and Recovery: Tools and Techniques. Prentice Hall (2001). ISBN 978-0130622983

Syverson, Bryan. Murach’s SQL for SQL Server. Fresno, CA: Mike Murach & Associates (2002). ISBN 1-890774-16-2

Stanek, William R. Microsoft SQL Server 2008 Administrator’s Pocket Consultant, 2nd edition. Redmond, WA: Microsoft Press (2010). ISBN 978-0-7356-2738-3

Sybase

Garbus, Jeffrey. Administrator’s Guide to Sybase ASE 15. Plano, TX: Jones & Bartlett (2006). ISBN 978-1-55622-360-9

Hitchcock, Brian. Sybase Database Administrator’s Handbook. Upper Saddle River, NJ: Prentice Hall PTR (1996). ISBN 0-13-357477-6

Kirkwood, John. Official Sybase Internals: Designing and Troubleshooting for High Performance. New York, NY: ITP New Media (1997). ISBN 978-1850323341

Other Database Systems

Anderson, J. Chris, et al. CouchDB: The Definitive Guide. Sebastopol, CA: O’Reilly (2010). ISBN 978-0-596-15589-6

Hamilton, D.D. Inside Adabas, Wellesley, MA: WH&O International (1995). ISBN 1-878960-03-2

Husband, Robert E. et al. IDMS/R Systems Desk Reference. New York, NY: Wiley-Interscience (1987). ISBN 0-471-85236-8

Informix Software Staff. Evolution of the High Performance Database. Upper Saddle River, NJ: Informix Press/PTR (1997). ISBN 0-13-124314-4

Lumbley, Joe. Informix Database Administrator’s Survival Guide. Upper Saddle River, NJ: Informix Press/PTR (1995). ISBN 0-13-124314-4

White, Tom. Hadoop: The Definitive Guide. Sebastopol, CA: O’Reilly (2009). ISBN 978-0-596-52197-4

Worsley, John C. and Drake, Joshua D. Practical PostgreSQL. Sebastopol, CA: O’Reilly (2002). ISBN 1-56592-846-6

Posted in DBA | Tagged , , | 1 Comment

Get Your DBA Planner for 2023!

I have published a 2023 planner specifically designed for DBAs to help them navigate the upcoming year. Get your copy now and be prepared early for 2023.

DBA Planner 2023

This is a weekly calendar where each page contains a week with 7 daily blocks. There is ample space for notes and meeting details. The planner is 8″x10″ to accommodate your plans, meetings, and notes. Here is an example page for the first week of the year:

And each week is accompanied by a “DBA Proverb.” You may be familiar with some of these proverbs from my past articles and blog posts. But there are new ones in the DBA Planner 2023, too! Each weekly quote is applicable to helping you better excel at your database administration tasks.

Furthermore, a monthly calendar is provided underneath each quote so you can quickly see where you are in the year, month, and week. For example, this calendar appears underneath the first quote of the year:

A section is provided at the end of the planner for capturing additional meeting notes, phone numbers, and other details of daily DBA life.

So what are you waiting for? Order one for yourself… and for all the DBAs in your life!

Posted in DBA | Leave a comment

My Recent Published Data Articles and “Stuff”

Just a short blog post today to refer my faithful blog readers to some other material that I have recently written that may be of interest!

First of all, I have written a series of articles on the IBM Z zIIP specialty processor for CloudFrame. This series of 8 articles discusses various aspects of using, optimizing, and saving money using the zIIP. You can find links to all of these articles in a Db2 Portal blog post at https://db2portal.blogspot.com/2022/08/all-about-ziips.html.

If you are interested in a more concise way to review this material, take a look at the eBook on this topic that I wrote entitled From A to zIIP: Leveraging the IBM Specialty Procewssor for Mainframe Cost Savings.

Of course I know that this blog is frequented by data and database professionals, and not everybody who reads it is an IBM Z mainframe user. So let’s take a look at some of the other stuff I’ve written recently.

As most of you know, I write a monthly column titled DBA Corner for Database Trends & Applications magazine. In July 2022, I wrote about Techniques for Optimizing Databases. You see, optimizing the performance of operational databases and the applications that access them is a constant battle for DBAs. In this article I take a look at techniques for tuning and optimizing the design, parameters, and physical construction of database objects, and the files in which their data is stored.

In August 2022, I wrote how Proper Data Types Pave the Road to Data Quality. Assuring data quality should be one of the most important goals for IT professionals. Accurate, quality data is required if you want to make accurate decisions. And that is true, whether the data is being analyzed by a human or a computer algorithm.

I also frequently write for TDAN (The Data Administration Newsletter), and in August 2022 I wrote about why it is important to Ingerate Database Archiving and Recovery. If you archive data from your operational databases you have to be careful about your backup and recovery procedures. Failure to incorporate and integrate archiving and recovery can result in lost data, duplicate data, and more data than is appropraite in your databases.

I also regularly write and update content on the TechTarget SearchDatabase site. I recently updated four of my articles for TechTarget, and the titles of these should be somewhat self-explanatory.

What is data warehouse as a service (DWaaS)?

What is database as a service (DBaaS)?

What is a database administrator (DBA)?

Evaluating the different types of DBMS products

I have also started writing for web ELNION, a newer site with a lot of interesting analysis and content. In July I wrote about why Mainframe Modernization is a Non-Sequitur. Whenever anybody uses the term “mainframe modernization” I sort of wince and look at them like they don’t know what they’re talking about. Because they really don’t. You see, there is no need… the mainframe already IS a modern platform… click the link to read the article and understand my reasoning.

In June I wrote Data Mesh? Data Fabric? I Don’t Care What You Call It, You Need It! Most of you have heard the terms “Data Mesh” and “Data Fabric,” but it unlikely that you know what they mean… at least in-depth. Are they important? This piece digs into the hype and gives some guidance.

Finally, also in July 2022, I wrote an article for a publication that I have been writing for (under its various names) for decades, Enterprise Tech Journal. The article, Data Masking: An Imperative for Compliance and Governance, covers masking data to protect it as data moves for test dats management and other requirements.

So I hope you take a moment of two to click through these links, if you haven’t seen them already, and read what has been on my mind the past couple of months!

Posted in backup & recovery, cloud, data, data integrity, Data Quality, data warehouse, DBA, mainframe, software cost, zIIP | Leave a comment

Rules for Ensuring Beautiful Views

One of the most debated areas of relational database development has been when and how to create and use views. Some analysts promote the liberal creation and usage of views, whereas others preach a more conservative approach.

When properly implemented and managed, views can be useful for easing data access and simplifying development efforts. Although views are easy to create and use, few organizations take a systematic and logical approach to view creation. And therein lies the problem. A strategic and reasonable policy guiding the creation and maintenance of views is required to avoid a confused hodgepodge of dubious views. Basically, views are useful when implemented wisely, but can be an administrative burden if implemented without planning.

Let’s back up a minute and define what a view is.  First, remember that all SQL access to relational tables results in another table. This is called relational closure and it is a requirement of the relational model. A view can be considered a logical table. More completely, a view is a “logical” representation of data that is “physically” stored in other tables (and perhaps other views as well). Views are defined using SQL and are represented internally to the DBMS by SELECT statements, not by stored data (unless it is a materialized view, which is another thing altogether and beyond the scope of this particular post). Almost any SQL that can be issued natively can be coded into a view.

View Implementation Rules

After you understand the basics of views, you should develop guidelines for view creation. This will ensure a smooth implementation of views and minimize administrative overhead. The following rules should be used to ensure a responsible and useful view creation policy at your shop. These rules were developed over a number of years as a result of reviewing implementations and working with views in many different environments. There are three basic view implementation rules:

1. The View Usage Rule

2. The Proliferation Avoidance Rule

3. The View Synchronization Rule

The View Usage Rule: The first rule is simple: your view creation strategy should be goal-oriented. Views should be created only when they satisfy a specific application or business requirement. That requirement should be documented somewhere, preferably in a dictionary or repository. Furthermore, the view purpose and DDL should be reviewed and approved by both the application team requesting the view and the DBA team that will support it.

Although this rule may seem to be an obvious one, some shops approach view creation without much forethought. This can cause the number of views that need to be supported and maintained to continually expand until so many views exist that it is impossible to categorize their purpose and current usage. Furthermore, the time needed to maintain and administer the system increases as the number of views increases.

There are five basic uses for which views excel. These are: 

1) to provide row and column level security, 

2) to ensure efficient access paths, 

3) to mask complexity from the user, 

4) to ensure proper data derivation, and 

5) to rename tables and/or columns.

These are all reasonable uses for views

The second rule is the Proliferation Avoidance Rule. This rule is simple and to the point: do not needlessly create views (or, indeed, any database objects) that are not absolutely required. Whenever a database object is created additional entries are placed in the system catalog. Creating needless views causes “catalog clutter”…that is, entries in the catalog for objects which are not needed and/or are not used.

The proliferation avoidance rule is based on common sense. Why create something that is not needed? It just takes up space that could be used for something that is needed.

The third, and final view implementation rule is the View Synchronization Rule. The basic intention of this rule is to ensure that views are kept in sync with the base tables upon which they are based.

Whenever a change is made to a base table, all views that are dependent upon that base table should be analyzed to determine if the change impacts them. All views should remain logically pure. The view was created for a specific reason (if we followed the View Usage Rule above). The view should therefore remain useful for that specific reason. This can only be accomplished by ensuring that all subsequent changes that are pertinent to a specified usage are made to all views that satisfy that usage.

For example, say a view was created to satisfy an access usage, such as a join between the employee table and the department table. If a column is added to the employee table specifying the employee’s location, it should also be added to the EMP_DEPT view if it is pertinent to that view’s specific use. Of course, the column can be added to the table immediately and to the view at the earliest convenience of the development team.

The synchronization rule requires that strict change impact analysis procedures be in place. Every change to a base table should trigger the usage of these procedures. Simple SQL queries can be created to assist in the change impact analysis. These queries should pinpoint any SQL in QMF queries, application packages, dynamic packages, and so on. Policies for informing users of the views to be impacted also need to be established before view changes can be implemented.

View synchronization is needed to support the view usage rule. By keeping views in sync with table changes the original purpose of the view is maintained.

Synopsis

Views are practical and helpful when implemented in a systematic and thoughtful manner. Hopefully, this post has provided you with some food for thought pertaining to how views are implemented at your shop. 

Posted in views | Leave a comment

Reducing MIPS and Mainframe Software Costs with CloudFrame

There is no denying that mainframe computing can be costly. The hardware alone can cost several million US dollars, and over time the software can be just as, if not more costly. As such, reducing mainframe software costs is an important goal for every organization that uses the platform.

Please note that I am not saying that the mainframe is too costly, or more expensive long-term than other commodity servers. The mainframe is very cost-effective when managed appropriately. And part of that, management needs to be understanding mainframe pricing strategies and cost control.

A significant component of overall mainframe cost is the software you are billed for monthly, known as Monthly License Charge (MLC) software. Not all mainframe software falls into the MLC category, but most of the big system software offerings do, such as z/OS, Db2, CICS, IMS, MQ, and COBOL. Furthermore, this software is billed based on usage, therefore reducing usage can reduce your monthly software bill. Of course, there are many nuances to how this usage-based pricing and billing occurs (we will mention a few in a moment), so it is not as easy as simply reducing workload to reduce costs.

But in a moment, I will tell you about a tool you can use to help estimate cost savings as you modernize your mainframe applications. First, let’s talk more about mainframe software costs.

Using zIIPs to Reduce Cost

One method of reducing cost is to increase the usage of zIIP specialty processors. The zIIP is a dedicated processor available on the IBM Z mainframe. When you activate zIIP processors, some percentage of the relevant workload can be redirected off of the general processors onto the zIIP. Why would you do this? Well, a workload that runs on the zIIP is not subject to monthly software charges.   You can save money by running work on the zIIP instead of the general-purpose processor.

But not all workload is eligible to run on the zIIP. You need to understand what types of processing can utilize zIIPs  to accrue cost savings. Java programs are zIIP eligible and therefore represent a very ripe opportunity for cost reduction in mainframe shops. If you  convert traditional workload, such as COBOL programs, to run on a Java Virtual Machine, that workload becomes zIIP eligible and can deliver significant cost savings.

Of course, this means you will need options for converting from COBOL to Java.

CloudFrame Solutions for Application Modernization

So, chances are you are sitting there with a large portfolio of COBOL applications written over the course of multiple decades. They run in batch and online. They access databases. And they run much of your business. Who has the time, let alone the resources, to re-write all of that code into Java?

Nobody does, right. And that is where CloudFrame’s application modernization solutions can help. They provide two different offerings, supporting different use cases, both of which can be used to reduce cost by converting COBOL to Java.

The first option is CloudFrame Renovate which converts your COBOL code to Java. The resulting source code is not JOBOL (that is, Java that looks like COBOL) but well-written object-oriented Java source code. Using this approach, you can get rid of the COBOL and start working with Java, running your code on the mainframe, another platform, or in the cloud – anywhere that Java runs.

Another approach is offered by CloudFrame Relocate. In this case, you keep the COBOL source code but convert the executable code to run in a Java Virtual Machine. No change is necessary to your data or other processes, but now that the code runs as Java, it is zIIP-eligible and can help reduce costs.

Both are viable methods of generating cost savings and can be deployed separately or together for different workloads and use cases.

How Much Can You Save?

Of course, to this point, we have been discussing cost savings as a broad generality under the assumption that moving workload to zIIPs using Java will result in savings. But how much? To that end, CloudFrame has put together an ROI estimation tool for customers to help them estimate how much money they can save using the CloudFrame solutions. The tool is  a spreadsheet with calculations to analyze cost reduction based on workload mix, average MIPS cost, cost of licensing CloudFrame, and other metrics.

You can click here to request access to use the cost estimation tool, and CloudFrame will help walk you through it. After you complete the registration, a CloudFrame representative will schedule time to help you walk through the cost estimation process. You will need to provide information about your environment to make the tool worthwhile. For example, you’ll need to know the average cost per MIP for your organization and the monthly MIPS usage for the workload you plan to convert from COBOL to Java. You will also need to provide additional information about your environments, such as the number of mainframes installed and the total number of disaster recovery environments you use.

You will also be asked to provide some details about the workload mix, such as the mixture of batch vs. online processing. The actual MSU rating for a CPC model will generally be highest for batch-type workloads and lowest for online type workloads, so this type of information is helpful.

The cost estimation tool will also consider the percentage of Db2/SQL workload involved, as that can impact the zIIP offload and cost savings that may be possible.

After supplying the appropriate input, the tool will show an estimate of your net savings (or ROI) over a three-year period, along with an Executive Summary that shows year by year break down of the annual cost to run your applications, the projected annual cost savings, the cost of the CloudFrame subscription, and the over net savings. Of course, the results will depend significantly on the accuracy of the information you provide.

You would do well to keep the following issues in mind as you work through your ROI evaluation. First of all, the spreadsheet is based on MIPS instead of MSUs. IBM no longer really talks about MIPS, but many mainframe shops are still more comfortable talking about MIPS than MSUs. That said, the customer’s monthly MLC software bills are calculated based on MSUs reported by the SCRT. So, you may need to do some MIPS to MSU conversions along the way. Loosely speaking, 1 MSU equals approximately 8.5 MIPS.

Another thing that you will need to know is the average cost of a MIP in your organization. This can be a difficult thing to ascertain. The CloudFrame tool provides some assistance with some analyst-sourced cost/MIPS estimates that you can plug in based on the size of your environment. That said, an average is just that, an average. It may or may not be the actual cost at your site, which can change from month to month based on the type of mainframe software pricing your organization uses.

This brings up another nuance, sub-capacity pricing, which most organizations use. Subcapacity pricing, such as AWLC or VWLC, means your MLC software is billed monthly based on a calculated rolling four-hour average (R4HA) of LPAR MSU usage. The monthly LPAR peak of the R4HA, by product, determines your software bill. This is a good thing because it means you are paying for capacity based on the R4HA instead of the maximum capacity of your system.

So, what does this mean for your cost estimation when converting COBOL to Java? Well, MSUs run on the zIIP are not factored into the R4HA, so if the workload contributed to the monthly peak R4HA period, then you can accrue savings. However, if the converted workload does not run during the peak monthly R4HA, you will not accrue any savings for that workload. 

Of course, if you are using a full-capacity pricing metric, or perhaps tailored-fit pricing, then every saved MSU can help to reduce your software bill. The bottom line is that you will need to understand the type of pricing your organization uses and when the workload to be converted runs to understand the type of savings you might be able to achieve.

That said, many organizations’ monthly mainframe software bill is so high that analyzing and estimating methods of reducing that cost makes a lot of sense!

Cost of CloudFrame

The CloudFrame pricing model differs from those used by most mainframe software vendors. The goal is to provide a simple, understandable method for charging. The CloudFrame Relocate software is priced based on a flat fee subscription license per IBM CPC instance. The CloudFrame Renovate offering is based on an annual subscription license based on lines of code migrated. Additionally, the CloudFrame Developer Kit is priced based on the number of developer seats required.

So, it is relatively easy to determine the cost of the CloudFrame solutions.

I discussed the pricing and business case calculator with CloudFrame’s COO, Hans Otharsson, and here’s what he told me: “CloudFrame has created a pricing model based on input from customers and our years of enterprise software experience that can be summed up with this phrase, ‘easy to understand.’ We’re eliminating surprises and hidden fees and presenting pricing that offers great value to customers.” That will be music to the ears of most mainframe software buyers!

The Bottom Line

Using CloudFrame to renovate and/or relocate COBOL programs to Java can reduce costs, perhaps significantly. Why not get in touch with CloudFrame today and use the ROI estimation tool to see what type of savings you can achieve?!?!  

Posted in capacity planning, cloud, DB2, digital transformation, enterprise computing, IBM, IT, legacy data, mainframe, software cost | Leave a comment

Bad Database Standards

Several years ago I wrote a series of blog posts on bad database standards, that is, things you should avoid doing when creating the standards for your organization regarding database systems and development.

These posts, although over a decade old now, are still relevant, so I thought I’d post an index linking to the articles to bring them back up for your review and comments!

Bad Database Standards Part 1 – Limits on Indexing

Bad Database Standards Part 2 – Too Many Columns!

Bad Database Standards Part 3 – Limiting The Number of Tables in “Online” Joins

Bad Database Standards Part 4 – Duplication of Data

Bad Database Standards Part 5 – None Shall Pass! Standards Can be too Rigid

Bad Database Standards Part 6 – What’s In a Name?

Bad Database Standards Part 7 – What Does Support Mean?

What do you think? Do you have any issues with any of these observations?

Are there any “bad database standards” that you have seen that need to be added to this list?

Feel free to drop a comment and startup a discussion here…

Posted in DBA, DBMS, SQL, standards | Leave a comment

A Few Good SQL Book Recommendations

Every professional programmer that accesses data in a relational/SQL database should have a good book (or four) on SQL… Actually, the same goes for DBAs because they also regularly use SQL in their day-to-day work. There are many SQL books to choose from, and many of them are very good. Here are four of my favorites from over the years…

The first SQL book I recommend is SQL Performance Tuning by Peter Gulutzan and Trudy Pelzer. This books offers up a treasure trove of tips for improving SQL performance on all of the major database systems. This book does not teach SQL syntax, but instead helps the reader to understand the differences between the most popular DBMS products, including Oracle, DB2, SQL Server, Sybase ASE, MySQL, Informix, Ingres, and even InterBase.

Throughout this book the authors present and test techniques for improving SQL performance, and grade each technique for its usefulness on each of the major DBMSs. If you deal with heterogeneous database implementations this book will be a great assistance, whether you are a programmer, consultant, DBA, or technical end user. The contents of this book can help you to decide which tuning techniques will work for which DBMS.

My next SQL book recommendation is altogether different in purpose than the first. It is SQL in a Nutshell, by Kevin Kline, Daniel Kline, and Brand Hunt.

This book offers a great cross-platform syntax reference for SQL. It probably is not the easiest reference to use for finding the exact syntax for one particular DBMS; but it is absolutely the best reference for those who work with multiple DBMSs.

Next up is The Art of SQL by Stephane Faroult, which is a guide to SQL written using the approach of “The Art of War” by Sun-Tzu.

The author actually uses the exact same title chapters for The Art of SQL that Sun Tzu used in The Art of War. Amazingly enough, the tactic works. Consider, for example, the chapter titled “Laying Plans,” in which Faroult examines how to design databases for performance. As anyone who ever built database applications knows an improperly designed database can be the biggest impediment to flawless application performance.

The chapter titled “Tactical Dispositions” covers the topic of indexing and in “The Nine Situations” the author examines several calssic SQL patterns and how best to approach them.

This book is not for a novice who wants to learn SQL from scratch. The authors assume the reader is conversant with SQL as they describe how to apply SQL in a practical manner. If you can’t code an outer join or don’t know what a nested table expression or in-line view is, then this is not the book for you.

Neither is the book a list of SQL scripts that you can pluck out and use. Instead, The Art of SQL skillfully manages to explain how to properly attack the job of coding SQL to effectively and efficiently access your data. The book offers best practices that teach experienced SQL users to focus on strategy rather than specifics.

The Art of SQL skillfully manages to explain how to properly attack the job of coding SQL to effectively and efficiently access your data. The book offers best practices that teach experienced SQL users to focus on strategy rather than specifics.” You know, if Sun Tzu coded SQL, he might have written a book like “The Art of SQL”. But since Sun Tzu is dead, I’m glad Stephane Faroult was around to author this tome.

The final SQL book recommendation is the latest edition of SQL for Smarties by the grand master of SQL, Joe Celko. Celko was a member of the ANSI SQL standards committee for ten years, and is highly qualified to write such a text.

The 3rd edition was completely revised and boasts over 800 pages of advanced SQL programming techniques. If you have any of the past two editions of this book, you owe it to yourself to get the newly revised third edition.

This book offers tips, techniques, and guidance on writing effective, sometimes complex, SQL statements using ANSI standard SQL. It touches on topics ranging from database design and normalization to using proper data types to grouping and set operations, optimization, data scaling, and more. Every developer who codes SQL statements for a living will find something useful in SQL for Smarties!

Joe also wrote an introductory SQL book titled SQL Programming Style (Morgan Kaufmann: ISBN 0-12-088797-5) that offers useful guidance on how to write standard SQL. If SQL for Smarties is too much for you, start off with SQL Programming Style.

Finally…

In all cases, if there is a newer edition of the book than the ones in the links then, by all means, buy the latest edition. These authors have proven themselves to write quality content and I trust that any new edition would improve on their existing material.

Happy SQL coding everybody!

Posted in books, performance, SQL | Leave a comment

I Will be A Regular Contributor on Data Management Topics for Elnion

Just a short blog post today to let my readers know that I will be contributing to elnion as a data management content provider. Elnion is a thought leadership site for technology news and issues, with a focus on cloud, data, the digital enterprise, and more. It was founded by well-known social influencer Dez Blanchfield.

My first article, titled DBA and the Cloud: Not Never, Always, All, or Nothing! was published late in April 2022.

Be sure to check out elnion on a regular basis for more of my data management content, as well as informed and interesting pieces from other thought leaders.

Posted in data, data management, social influencer, thought leadership | Leave a comment

Let’s Create the Future with IBM Using Data, AI, and Cloud

This post is sponsored by IBM

As IT professionals, creation is what we do. Every day developers are writing new code to make it easier to run our business, or writing (creating) code to maintain existing systems. DBAs are creating new databases and structures, as well as creating new ways of making sure vital corporate data is available all the time, every day and in multiple ways. And data scientists and analysts are using the data in those databases to gain a deeper understanding of the business, discover heretofore unknown trends, and create new ways to gain competitive advantage by transforming their business. And when you put them all together with IBM technology and services, there are virtually no limitations to what you can create.

In my experience as an IBM partner, creation using IBM solutions for hybrid cloud, AI, and data fabric delivers unparalleled capabilities for modern, useful systems.

It is important to understand that on-premises and cloud computing must co-exist to deliver the highest value to most organizations. Large enterprises like banks, insurance companies, airlines, and retailers have billions of lines of code invested in applications that run their business. And they are not going to simply jettison that investment to re-write everything in the technology du jour. But it is possible to continue to benefit from existing workloads while modernizing them.

A hybrid cloud approach is the standard method for creating modern enterprise systems and applications. With a hybrid cloud approach, you can choose what makes sense for each component, task, and project that you tackle. Building applications that mix and integrate on-premises systems with cloud capabilities enables new platforms to benefit from the rich heritage of existing systems and integrate them with new capabilities and techniques as appropriate.

This means you can integrate the capabilities of existing on-premises applications, such as those running on IBM Z and IBM Power Systems platforms, with the secure, flexible hybrid capabilities of the IBM Cloud. Creating useful applications and content on all platforms is easier when you embrace your legacy applications and many organizations are embracing digital transformation to create new ways to benefit from existing systems, by extending their IBM Z and Power workloads to the IBM hybrid cloud. Creating in this manner enables organizations to nimbly modernize their systems on the IBM Cloud while continuing to benefit from their long-time core applications running on IBM’s proven hardware.

As all IT professionals know, it is not enough to build applications, but they also need to be supported. Assuring development and operations to support what is developed is the reason the whole DevOps movement is flourishing. IBM provides the tools needed for managing and deploying your hybrid cloud applications. On the dev side, IBM Red Hat OpenShift, which is the leading multicloud container development platform, provides microservices frameworks, serverless support, continuous integration and delivery (CI/CD) integration, and more. And on the ops side, IBM Cloud Schematics brings the power of both Red Hat Ansible and Terraform to IBM Cloud users for automating the end-to-end deployment of cloud infrastructure and applications. 

Turning our attention to data, it is undeniable that data is the underlying lynchpin of IT. In all cases, data is required to create business value whether you are performing analytics, coding applications, running machine learning models, or even just generating a report. None of it can be done without data.

But all too frequently data is not treated as the valuable corporate asset – required to drive the business – that it is. Data typically exists in silos, managed independently, and perhaps not documented as well as it could be. What is needed is a data fabric that delivers the data management services required to discover, curate, govern, and orchestrate your data regardless of where it is deployed — on-premises, or in the cloud.

And IBM provides a data fabric solution, IBM Cloud Pak for Data, that can improve creativity by improving your data health and management. Using IBM Cloud Pak for Data you can define and connect your disparate data where it exists across your hybrid cloud, integrating data and creating a catalog of re-usable data assets. And when you know where your data is, it makes it easier to provide business users with the data they need to improve customer experiences, as well as to enforce data usage and access policies. All while leaving the data in place, without having to move it to make it accessible. With a data fabric in place, you can unite, govern. and secure your data for faster, more accurate insights.

Furthermore, the data fabric powers and enables the adoption of AI, which most organizations are utilizing to create modern applications and systems that deliver valuable insights. AI needs data, without it, there isn’t much that can be accomplished, because trustworthy AI relies on accurate data for models and decision-making. With a data fabric in place, your managed, useful corporate data becomes available to data scientists for AI projects.

IBM delivers the solutions to help you infuse AI into your creations. Your data scientists and analysts will use IBM Watson Studio, which works with IBM Cloud Pak for Data for building, running, and managing AI models, and building AI applications for optimizing decisions based on your data anywhere throughout your organization.

Additionally, people can interact with your creations using natural language with IBM Watson Assistant, which uses AI that understands users in context to provide fast, consistent, and accurate answers across any application, device, or channel. You can create a highly-intelligent, AI-powered virtual agent for your application(s) without writing a single line of code.

Putting It All Together

Imagine this: a hybrid cloud application accessing data on-premises from Db2 for z/OS and Db2 on Linux, as well as data in Db2 on the IBM Cloud. IBM Cloud Pak for Data is in place creating a data fabric such that your data is clearly defined and governed making it accessible to all. You’ve used Red Hat OpenShift and Ansible to ensure that the application is delivered and managed in a simple, intuitive manner.

Because you’ve integrated Watson Assistant into this system all of your users can interact with it using natural language, so nobody has to learn a cumbersome new interface.

And best of all, you can use these services and tools from IBM solutions to create any applications you need in the hybrid cloud.

So, what are you waiting for? Let’s create incredible, practical new systems that integrate our existing and valuable resources with all these useful technologies from IBM. And then we can experience the true power of modern computing!

Posted in AI, analytics, cloud, data, Watson | Leave a comment

Let’s Talk About Database Performance Analyzer

Recently, I published a tweet thread on database performance and SolarWinds’ Database Performance Analyzer. Today’s blog post captures those tweets for posterity!

Let’s talk about #DatabasePerformance and SolarWinds (Tweet #1)

Applications that access relational databases are only as good as the performance they achieve. And, every user wants their software to run as fast as possible, right? It is for that reason that database and application performance tuning and management is one of the biggest demands on the DBA’s time. When asked what is the single most important or stressful aspect of their job, DBAs typically respond “assuring optimal performance.” Indeed, a recent Forrester Research survey indicates that performance and troubleshooting tops the list of most challenging DBA tasks.

Handling performance problems should be an enterprise-wide endeavor. And, most organizations monitor and tune the performance of their entire IT infrastructure encompassing servers, networks, applications, desktops, and databases. However, the task of enterprise performance management frequently becomes the job of the DBA group. Anyone who has worked as a DBA for any length of time knows that the DBMS is usually “guilty until proven innocent.” Every performance problem gets blamed on the database regardless of its true source cause. DBAs need to be able to research and decipher the true cause of all performance degradation if only to prove that it is not caused by a database problem.

Truly, it is the case that optimizing data access and modification has been important ever since the invention of the first DBMS. And managing database performance has only gotten more complex over time. (Tweet #2)

Most organizations have multiple different databases, but they want them all to perform well! However, Oracle, SQL Server, Db2, PostgreSQL, MySQL, and other popular database systems all work differently. (Tweet #3)  Assuring optimal performance of applications across a heterogeneous database environment is a significant ongoing operational challenge… one that SolarWinds can help you tackle. (Tweet #4)  SolarWinds Database Performance Analyzer (DPA) is designed to help you uncover and resolve your most complex database performance problems (Tweet #5).

Figure 1. SolarWinds Database Performance Analyzer

At a glance you can see where database performance problems exist and then navigate easily to learn more details. SolarWinds DPA can do this across all major database systems from, a single installation (Tweet #6).

Figure 2. View Database Performance Issues at-a-glance

And SolarWinds DPA offers expert tuning advisors that deliver precise database tuning guidance to help you remediate poor performing databases, applications, and SQL statements. (Tweet #7)

Tuning SQL statements becomes easier when you use SolarWinds DPA to focus on the SQL that is consuming the most resources and causing the most problems. Each color on the graph represents a separate SQL statement. (Tweet #8)

Figure 3. Resource-Consuming SQL Statements

And then SolarWinds DPA can even drill down into the SQL statement text for more details. (Tweet #9)

Figure 4. Drill Down to the SQL Statement Text

Gathering all of the details needed to analyze SQL problems can take a lot of time and effort, but SolarWinds DPA minimizes the effort involved. The response time analysis feature of Database Performance Analyzer provides operational intelligence about database performance over time. It tracks every query in every active session and captures the events that impose delays on the queries. (Tweet #10)

Furthermore, with SolarWinds DPA dynamic baselines you can view detailed metrics and years of history to see the trends and patterns that tell the complete performance story over time. (Tweet #11)

SolarWinds Database Performance Analyzer is a smart choice for optimizing database performance. It requires no agents and imposes minimal impact on monitored databases. (Tweet #12)  Read what DBAs and performance analysts are saying about how SolarWinds Database Performance Analyzer improves database performance. (Tweet #13)

The Bottom Line

Any organization looking to improve #DatabasePerformance should consider adopting SolarWinds Database Performance Analyzer to optimize their applications and systems. (Tweet #14)

Posted in automation, DBA, optimization, performance, SQL | Tagged | 1 Comment