Problem solve

Data warehouse software

• Dimension tables vs. fact tables: What's the difference?

  Fact tables and dimension tables are used together in star schemas to support data analytics applications. But they play different roles and hold different types of data. Continue Reading

• Operational data store vs. data warehouse: How do they differ?

  Operational data stores and data warehouses both store operational data, but the similarities between them end there -- and they both have a role to play in analytics architectures. Continue Reading

• Imhoff: Data warehouse architecture must go beyond the traditional

  In a video interview, consultant Claudia Imhoff discusses the increasing need to augment data warehouses with technologies such as Hadoop and real-time analytics systems. Continue Reading

• Big data, fast: Avoiding Hadoop performance bottlenecks

  A variety of performance issues can bog down Hadoop clusters. But there are ways to sidestep the pitfalls and keep your big data environment humming. Continue Reading

• Database administration best practice: Balance DBA team skills

  Balancing development and operations skills is a first step to achieving database administration best practices in-house. Continue Reading

• Hadoop helps bring big data into a data warehouse environment

  Hadoop emerged primarily to handle unstructured big data. Now it can help IT teams looking to efficiently mix big data systems and data warehouses.Continue Reading

• Data warehousing architecture takes logical turn in big data era

  To make the most of different data assets, analysts say data warehouses and big data systems should be blended into logical or hybrid architectures.Continue Reading

• Why IT departments should consider a large data warehouse system

  Find out how a large data warehouse system can benefit companies. Learn how enterprise data warehouses help meet business needs. Get tips on operational considerations for a central data warehouse.Continue Reading

• Key issues to consider when building a data warehouse

  There are numerous issues, both technical and cultural, that organizations need to consider before building a data warehouse. Learn what they are from our data warehousing expert.Continue Reading

• How semantic modeling will change data modeling in the future

  Find out how semantic modeling is changing data modeling and what the future holds for the use of semantic technologies in data modeling.Continue Reading

• The state of enterprise information management technology use in 2011

  Get expert insight on whether there likely will be any strategic shifts during 2011 in how companies use enterprise information management technology.Continue Reading

• The best way to begin an enterprise information management program

  Get expert advice on launching an enterprise information management program and creating an EIM strategy.Continue Reading

• Common enterprise information management strategy mistakes to avoid

  Learn about four common mistakes that companies make when creating an enterprise information management strategy and starting an EIM program.Continue Reading

• Six tips for improving data warehouse performance

  Get six expert tips for improving data warehouse performance. Learn how database engines, SSDs and MOLAP cubes can affect your data warehouse performance.Continue Reading

• DBMS and data warehouse trends: the rise of data warehouse appliances

  DBMS and data warehouse trends in 2011 include the rise of data warehouse appliances, according to one expert. Learn why appliances and semi-structured data are getting increased attention.Continue Reading