Features

Features

• 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

• IT project management: The cost estimating process

  Learn about the cost estimating process in IT project management by reading examples and definitions of cost estimation terms, in this free chapter download.  Continue Reading

• Personal information management: History and details

  Learn about personal information management and why managing personal information is especially important in today's data inundated world.  Continue Reading

• Continuous integration: The value of CI

  Learn about the value of continuous integration and get reasons why continuous integration can benefit the enterprise in this free sample chapter download.  Continue Reading

• MDM-CDI project implementation guidelines

  This chapter excerpt deals with the practical aspects of implementing MDM-CDI solutions as complex, multidisciplinary, enterprise-wide projects or programs. Implementing MDM-CDI solutions requires an approach that may be even broader than a single ...  Continue Reading

• Data governance: Information ownership policies and roles explained

  Who owns the data? This chapter defines information ownership boundaries and best practices, and outlines the specific roles and responsibilities of all involved in the battle for data governance.  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