Manage

Manage

Learn to apply best practices and optimize your operations.

• How to create automated operational decisions

  Learn why current system approaches fail and why companies should create automated operational decisions. Learn about decision logic and how SOA is helping to create smart systems. Continue Reading

• Understanding the latest data integration strategies and technologies

  Learn about new data integration strategies and technologies that can improve data integration for enterprise IT and departmental data in your organization. Continue Reading

• Understanding key data integration trends and business drivers

  New data integration trends are shaping integration projects at many organizations. Find out about important data integration business drivers in this article by Rick Sherman. Continue Reading

• Improving ODBC application performance and coding

  This book excerpt reveals how to improve ODBC application performance and create optimized ODBC code. Get coding examples, and learn how to manage ODBC drivers and database connections. Continue Reading

• Selecting ODBC functions for optimized SQL statements

  In this book excerpt, you'll find best practices guidelines for deciding what ODBC function to use when executing SQL statements and how to use bound columns. Continue Reading

• Guidelines for managing data updates to optimize ODBC performance

  Looking to optimize your ODBC applications and functions? Find guidelines for updating data and managing your data updates efficiently and how to improve ODBC performance.Continue Reading

• How to capture metadata information, ETL rules with CA Erwin Data Modeler

  Learn how to capture and retrieve metadata information such as extract, transform, load (ETL) rules by using CA Erwin Data Modeler. This data modeling excerpt also covers step by step of how to capture the ETL information using and the generating of...Continue Reading

• How to improve data quality on a tight budget -- a guide

  Many organizations may be tempted to forgo data quality management to save money, but it's important to assess the ROI of high-quality data, according to consultant David Loshin.Continue Reading

• Data quality management tips and best practices

  Get data quality management tips and best practices with expert advice and book excerpts. Learn about academic sources for data quality, key steps and common mistakes of data quality implementations, how much you should spend for data cleansing and ...Continue Reading

• Designing for performance: Strategic database application deployments

  What's your database design strategy? Find out how to design for performance and learn strategies for effective database application deployments. Find out why the way you implement database connections is important for database design and get tips ...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

• 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

• 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

• Database access security: network authentication or data encryption?

  Looking to secure your database network? Read about database performance issues relating to database access security. Find out the difference between network authentication and data encryption and learn about Secure Sockets Layer and SSL handshakes.Continue Reading

• Future of data warehousing shaped by open source, MDM, the economy

  This is the second of a two-part series examining data management trends and market drivers for the second half of 2009 and what those trends will mean for the future of data warehousing. The recommendations address what IT directors, managers and ...Continue Reading