By using this site, you agree to the Privacy Policy and Terms of Use.
Accept
SmartData Collective
  • Analytics
    AnalyticsShow More
    data analytics in sports industry
    Here’s How Data Analytics In Sports Is Changing The Game
    6 Min Read
    data analytics on nursing career
    Advances in Data Analytics Are Rapidly Transforming Nursing
    8 Min Read
    data analytics reveals the benefits of MBA
    Data Analytics Technology Proves Benefits of an MBA
    9 Min Read
    data-driven image seo
    Data Analytics Helps Marketers Substantially Boost Image SEO
    8 Min Read
    construction analytics
    5 Benefits of Analytics to Manage Commercial Construction
    5 Min Read
  • Big Data
  • BI
  • Exclusive
  • IT
  • Marketing
  • Software
Search
© 2008-23 SmartData Collective. All Rights Reserved.
Reading: Entry Point: Architecture or Crumbling Foundation
Share
Notification Show More
Latest News
data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security
ai in software development
3 AI-Based Strategies to Develop Software in Uncertain Times
Software
Aa
SmartData Collective
Aa
Search
  • About
  • Help
  • Privacy
Follow US
© 2008-23 SmartData Collective. All Rights Reserved.
SmartData Collective > Big Data > Data Mining > Entry Point: Architecture or Crumbling Foundation
Data MiningData Warehousing

Entry Point: Architecture or Crumbling Foundation

DataQualityEdge
Last updated: 2009/06/22 at 7:14 PM
DataQualityEdge
3 Min Read
SHARE

Let us talk for a moment about architecture.

Good architecture is built to last, to withstand the elements and the test of time. Good data architecture will allow you to extract data quickly, will help prevent data errors from occurring, and promote easy integration of future data assets.

With bad architecture, the following will persist like vermin in your basement:

  1. Data retrieval times will increase
  2. Data retrieval will become more difficult
  3. The integration and migration of projects will become cumbersome
  4. The creation and spread of bad data will be more likely

Soon the walls around you will begin to crumble as more and more data becomes questionable. Your users will question the data, and eventually your system will become synonymous with the term “poor data quality.”

More Read

analyzing big data for its quality and value

Use this Strategic Approach to Maximize Your Data’s Value

7 Data Lineage Tool Tips For Preventing Human Error in Data Processing
Preserving Data Quality is Critical for Leveraging Analytics with Amazon PPC
Quality Control Tips for Data Collection with Drone Surveying
3 Huge Reasons that Data Integrity is Absolutely Essential

When building your data warehouse, remember to:

  1. Ensure you size it properly and measure future capacity for continuous growth
  2. If bad data does occur, have your data analysts cleanse it; and don’t build overly complicated data models — remember the KISS principle
  3. Improve speed to delivery and reaction time
  4. Improve query and data retrieval times

When defining your architecture and/or database system remember the following…


Let us talk for a moment about architecture.

Good architecture is built to last, to withstand the elements and the test of time. Good data architecture will allow you to extract data quickly, will help prevent data errors from occurring, and promote easy integration of future data assets.

With bad architecture, the following will persist like vermin in your basement:

  1. Data retrieval times will increase
  2. Data retrieval will become more difficult
  3. The integration and migration of projects will become cumbersome
  4. The creation and spread of bad data will be more likely

Soon the walls around you will begin to crumble as more and more data becomes questionable. Your users will question the data, and eventually your system will become synonymous with the term “poor data quality.”

When building your data warehouse, remember to:

  1. Ensure you size it properly and measure future capacity for continuous growth
  2. If bad data does occur, have your data analysts cleanse it; and don’t build overly complicated data models — remember the KISS principle
  3. Improve speed to delivery and reaction time
  4. Improve query and data retrieval times

When defining your architecture and/or database system remember the following steps to help prevent bad architecture from occurring:

  1. Define the objective of the data warehouse
  2. Research the data and datasets (understand the business and its processes)
  3. Design the data model
  4. Define the database relationships
  5. Define rules, triggers and constraints
  6. Create views and/or reports
  7. Implement it.

TAGGED: architecture, data quality
DataQualityEdge June 22, 2009
Share this Article
Facebook Twitter Pinterest LinkedIn
Share

Follow us on Facebook

Latest News

data analytics in sports industry
Here’s How Data Analytics In Sports Is Changing The Game
Big Data
data analytics on nursing career
Advances in Data Analytics Are Rapidly Transforming Nursing
Analytics
data analytics reveals the benefits of MBA
Data Analytics Technology Proves Benefits of an MBA
Analytics
anti-spoofing tips
Anti-Spoofing is Crucial for Data-Driven Businesses
Security

Stay Connected

1.2k Followers Like
33.7k Followers Follow
222 Followers Pin

You Might also Like

analyzing big data for its quality and value
Big Data

Use this Strategic Approach to Maximize Your Data’s Value

6 Min Read
data lineage tool
Big Data

7 Data Lineage Tool Tips For Preventing Human Error in Data Processing

6 Min Read
data quality and role of analytics
Data Quality

Preserving Data Quality is Critical for Leveraging Analytics with Amazon PPC

8 Min Read
data collection with drone use
Data Collection

Quality Control Tips for Data Collection with Drone Surveying

9 Min Read

SmartData Collective is one of the largest & trusted community covering technical content about Big Data, BI, Cloud, Analytics, Artificial Intelligence, IoT & more.

AI and chatbots
Chatbots and SEO: How Can Chatbots Improve Your SEO Ranking?
Artificial Intelligence Chatbots Exclusive
ai in ecommerce
Artificial Intelligence for eCommerce: A Closer Look
Artificial Intelligence

Quick Link

  • About
  • Contact
  • Privacy
Follow US

© 2008-23 SmartData Collective. All Rights Reserved.

Removed from reading list

Undo
Go to mobile version
Welcome Back!

Sign in to your account

Lost your password?