Data Modeling & Architecture

Integrating Data from Multiple Sources: The Challenge of Data Element Conformance - by David Loshin This is the first post in this series. Read the next post. The continued fascination with expanding an organization’s analytics capabilities often centers on the desire to identify interesting and new data sources originating outside the enterprise that can be integrated into a big data analytics application. The presumed wealth of information hidden within third-party or otherwise externally-sourced data sets has inspired many aspiring data scientists to rapidly create processes for accessing ...
Tags: data metadata
Documenting Your Data Landscape For The Organization When it comes to making informed decisions, data is the most critical asset an organization possesses. In this session, you'll see how to create documentation of organizational data, which is easily understood and readily available to anyone within the organization. Click here to watch 15 more videos from the DataU series.Click here to learn more about ER/Studio. Rob Loranger is a Sr. Software Consultant and Associate Product Manager for Embarcadero. Although he currently focuses his time ma...
How to centrally manage enterprise data definitions in your data mangement projects? One of the key issues in a Data Warehouse, Master Data Management or BI project is the lack of a centralized and easily accessible Data Definition or Metadata Repository.  Mostly, business users are using word and excel documents placed on a shared folder. Everybody is aware that the maintenance, stewardship and accessibility of metadata in a project not to mention in an enterprise are daunting tasks. Embarcadero TEAM SERVER provides the best data modeling tool I know on the market to bridg...
Getting Physical - Using automation to build robust, high-fidelity schemas from your logical models High-fidelity database schemas capture essential business rules and help ensure data quality, but can be very time-consuming to produce and maintain. Enterprise-grade data modeling tools excel in automating the construction and maintenance of robust database designs from logical models. Learn how to leverage tooling and automation to build and manage consistent, high-quality database schemas from your logical models..  Click here to watch 15 more videos from the DataU series.Click here to ...
The Intrinsic Value of Data Modeling Maybe you're using Visio, Excel, or a proprietary tool with limited functionality to create a data model. Perhaps you are expanding your job scope to include data modeling and aren't sure where to start. Or you might be very experienced with data modeling, but need a tool that gives you more capabilities to simplify your tasks. Learn more about the value of data modeling.  Click here to watch 15 more videos from the DataU series.Click here to learn more about ER/Studio. Joy Ruff is the ...