Manage

Manage

Learn to apply best practices and optimize your operations.

• Executing SQL statements using prepared statements and statement pooling

  In this database tutorial, find out about executing SQL statements using prepared statements and statement pooling. Learn what a statement pool is and how to retrieve long data types efficiently. Continue Reading

• An introduction to database transaction management

  Find out the performance advantages of using one connection for multiple statements in this database tutorial. Get a definition of local vs. distributed transactions and learn how to manage database transactions. Continue Reading

• Static SQL vs. dynamic SQL for database application performance

  Learn the difference between static SQL vs. dynamic SQL and the benefits and drawbacks of each for database application performance. Get a definition of stored procedure, find out about database drivers and wire protocol database drivers and how the... Continue Reading

• Top 13 master data management (MDM) buzzwords and definitions

  Get the top master data management (MDM) terms, definitions and concepts and learn how MDM can improve your enterprise data. Also get links to useful MDM tutorials, training, video, podcasts and articles. Continue Reading

• Similarities and differences between ROLAP, MOLAP and HOLAP

  Find out the differences between ROLP, MOLAP and HOLAP and their advantages and disadvantages. Learn about data quality and the evolution of data warehouse applications. Continue Reading

• Advantages of the multidimensional database model and cube modeling

  Discover the advantages of the multidimensional database model and find out how data warehouse cube modeling, data restricting and data slicing work. Learn the role meta-data plays and get a definition of functional dependency.Continue Reading

• Data warehouse architectures, concepts and phases: What you need to know

  This tutorial explains the different types of data warehouse architecture including bus, federated and hub-and-spoke. Learn about ETL processes and data staging and data warehouse phases.Continue Reading

• The importance of managing data assets

  Get an overview of data management and data lifecycle, learn how important managing data and data assets is and learn how to control data in this information management tutorial.Continue Reading

• Data modeling for the business: What is a data model?

  Learn about high-level data modeling, what a data model is and how business and IT can use logical data modeling to plan a data design with these best practices from a data modeling handbook and guide.Continue Reading

• Designing an MDM project plan

  Master data management (MDM) projects require enterprise buy-in and participation in order to be successful. In this chapter, learn how to identify the people in the organization that can benefit from MDM and how to assemble an MDM project team. ...Continue Reading

• Types of DBAs

  DBAs can take on many different roles. This excerpt from the "Database administration: The complete guide to practices and procedures" takes a closer look at different types of DBAs.Continue Reading

• What is the difference between DB2 UDB and DB2 OS/390?

  Database expert Craig Mullins explains the differences between DB2 UDB and DB2 OS/390. He begins by clarifying that the two are comprised of completely different code bases.Continue Reading