Manage

Manage

Learn to apply best practices and optimize your operations.

• From the Editors: Analytical MDM sets up enterprise MDM, but plan well

  An analytical master data management project can be a great way to start an enterprise MDM program, but with certain conditions. Get tips for starting an analytical MDM project at your company. Continue Reading

• The evolution of MDM architecture

  Find out how MDM architecture has changed over the years and gain insight on architectural considerations to take into account when planning an MDM program and system. Continue Reading

• An introduction to enterprise architecture framework and MDM patterns

  Get an introduction to enterprise architecture framework and MDM enterprise architecture patterns. Learn about MDM framework concepts and a definition of SOA. Continue Reading

• Data governance roles and responsibilities call for diverse skill sets

  Learn about data governance roles and responsibilities, and get advice on the management and technical skills that a successful data governance strategy and program requires. Continue Reading

• Making business transaction processing and applications work

  Learn about making business transaction processing work in your company, find tips on transaction processing applications and get transaction processing definitions. Continue Reading

• Key benchmarks for measuring transaction processing performance

  Find key benchmarks for measuring transaction processing performance at your company, and learn about XA two-phase commit and types of transaction processing.Continue Reading

• Advantages and disadvantages of XML shredding

  Learn about the advantages and disadvantages of XML shredding and different shredding methods, plus find out when shredding is and isn't a good option for your company.Continue Reading

• 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