Subscribe to this list via RSS Blog posts tagged in data model
Improve Agility and Collaboration with ER/Studio XE7 On April 28, 2015, Embarcadero announced the XE7 release of our award-winning ER/Studio data modeling and architecture suite, with new features to improve agility and collaboration in enterprise data landscapes. Let’s highlight them, and for more details and a demonstration, you can watch the on-demand webinar from April 30th. ER/Studio continues to incorporate new capabilities and features to improve the user experience, enhance the data architecture, and address emerging industry technologies...
Business-Oriented Conceptual Modeling for Master Data Entities - by David Loshin In my previous post, we examined some of the challenges associated with developing data models for master data entities managed within an MDM environment, and I implied that achieving the holy grail of MDM, namely the (elusive, if not purely mythical) “golden record” would first require a practice for business-oriented data conceptual and logical data modeling. We tend to have a “dimensional attitude” about master data, focusing on “customer master” or “supplier master” or “product master” as i...
The Evolution of Data Modeling - by Ron Huizenga When we review the evolution of new data architecture and development methodologies, along with the corresponding changes in corporate culture, we can see that there have been numerous approaches over the years. In the earlier days of traditional / waterfall processes for data modeling, there was a more rigid organizational structure with data modelers, programmers, and system analysts. Agile methodologies emerged in an attempt to address the shortcomings of traditional practices. The focus chan...
The Challenge of Master Data Modeling - by David Loshin I had a recent email exchange in which a customer was looking for guidance in developing data models for master data entities used across multiple business functions and domains. One of the motivating factors was the desire for evolving a “golden record” (a term that makes me bristle each time I hear it, by the way) for each master entity type – a golden customer record, a golden product record, etc. I expressed my concern about two things: attempting to create a model intended to represent a s...
Comprehensive Data Security Requires Metadata - by Rob Loranger Anthem Inc. – 80,000,000 records stolen; Sony Pictures – 100 terabytes of data stolen; JP Morgan Chase – 70,000,000 records stolen; and EBay – 145,000,000 records stolen. This short list is the “tip of the iceberg” of organizations across all industries that have had significant amounts of their customer, employee, and other important organization data stolen. With the increased reliance of digital information by organizations and their customers, these trends will likely continue and be fueled ...
SSWUGtv Interview: Ron Huizenga on Agile Data Modeling Ron Huizenga, ER/Studio Product Manager, gave an interview on SSWUGtv to discuss Agile data modeling. Data modeling has evolved from strictly up-front relational designs (waterfall methodology) to interactive and integrated models that respond to business and IT needs. Data professionals must adapt, be flexible and address things along with way. Data modelers and DBAs need to quickly respond to changes in short development cycles; they need to know why they’re doing it, and tie it back to the re...
SSWUGtv interview: Ron Huizenga on Data Architecture Challenges Ron Huizenga, ER/Studio Product Manager, gave an interview on SSWUGtv to discuss data architecture challenges that impact us all as data professionals. These key challenges include: New methodologies Big data Multiple diverse data sources Data quality Business focus on usage of the data With many different variables and moving parts, today’s data environments required a dedicated process to manage them effectively. The best approach is still to define a design up front to ensure you ha...
Embrace the Future of Data Architecture: Make the Switch to ER/Studio Sometimes you need to face the inevitable: the tool selected years ago is not the one you need for the future. Have you been struggling with complicated modeling tasks or outdated tools? Are your data models getting too big to handle? We’ve heard from a lot of customers recently who have been frustrated with their old data modeling tools, for multiple reasons such as: Lack of functionality Lack of support Lack of a future roadmap Embarcadero is committed to enabling our users to adapt to...
10 Physical Data Modeling Blunders - Are You Making Them? Karen Lopez 10 Physical Data Modeling Blunders from Karen Lopez One of my favourite presentation themes is talking about gotchas, blunders and mistakes.  Not because I like to focus on the negative, but because there are some wonderful resources out there telling modelers how to model, and so few out there telling us what NOT to do based on lessons learned. In this slide deck, I focus on physical modeling gotchas based on my reviews of hundreds of great data models that just missed the...

Check out more tips and tricks in this development video: