Manage

Manage

Learn to apply best practices and optimize your operations.

• 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

• Real-life examples of effective dashboard design

  Browse through these optimized dashboard examples from BITadvisors, Inc., including examples of strategic, tactical and operational dashboards. Find out how to encourage interactivity in dashboards and how to set up your dashboard. 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

• 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

• 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

• Using bare-metal recovery to migrate physical machines to virtual machines with VMware

  Learn how to use the bare-metal recovery procedure to migrate physical machines into virtual machines in VMware.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

• Simple data mining examples and datasets

  See data mining examples, including examples of data mining algorithms and simple datasets, that will help you learn how data mining works and how companies can make data-related decisions based on set rules.Continue Reading

• What is a data rollup?

  Learn what a data rollup is and read about data rollup macro examples and case studies in this data mining tutorial from the book Data Mining: Know it All.Continue Reading

• EMC NetWorker backup best practices

  Brien Posey shares EMC NetWorker backup best practices and troubleshooting tips in this article on EMC NetWorker backup.Continue Reading

• IBM Tivoli Storage Manager backup software tips

  IBM Tivoli Storage Manager (TSM) has been a popular data backup software product for more than 15 years. Learn about TSM implementation best practices, and how to troubleshoot common Tivoli Storage Manager issues.Continue Reading

• Oracle backup and recovery best practices

  Backing up Oracle is one of the most important tasks a backup/storage administrator can do today. Learn about backup best practices with Recovery Manager and Automatic Storage Manager.Continue Reading

• Including employees in your disaster recovery plan

  To really ensure business continuity, organizations need to protect and support employees while continuing to manage the business. This tip examines key issues that are affecting employees in business continuity and disaster recovery situations.Continue Reading

• How to use SQL Developer to run SQL statements

  In this chapter, learn how to use SQL Developer to enter and execute SQL statements and scripts, work with a Snippets window, solve common syntax errors and more.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

• The benefits of metadata and implementing a metadata management strategy

  This section of the chapter excerpt will introduce and explore the basics of metadata.Continue Reading

• Successful business intelligence: The role of BI front-end tools

  Learn about the business intelligence front-end tools that are available to business users -- and how the right BI tool can lead to BI success.Continue Reading

• How to increase SGA_MAX_SIZE in Oracle

  How to increase SGA_MAX_SIZE in Oracle? I got the error "ORA-03113: end-of-file on communication channel" during startup.Continue Reading

• ILM vs. DLM: The importance of data management

  Knowing the differences between information lifecycle management (ILM) and data lifecycle management (DLM) will ultimately determine which storage offerings you bring to a client's table.Continue Reading

• Common SQL Server Integration Services (SSIS) package management scenarios

  Whether connecting to SQL Server Integration Services (SSIS), running packages or viewing package summaries, these scenarios will answer basic SSIS package management questions, from the book "Inside Server SQL Tools."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

• How to validate zip code, city, and state code

  Continue Reading