Joy Ruff - All About Data Architecture

Product Marketing Manager for ER/Studio

Read data and database blogs on:
http://community.embarcadero.com/index.php/blogs/blog-menu/categories/listings/database

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 Data Modeling for the DBA Ron Huizenga, ER/Studio Product Manager, gave an interview on SSWUGtv to discuss data modeling for the DBA. Database administrators may find themselves asked to take care of modeling tasks that are not part of their normal job scope, which could result in frustration. By getting involved in the data modeling process, a DBA can better understand potential performance implications and provide that insight back into the database and its models.   Tools like ER/Studio and DB PowerStudio can h...
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...
Integrating Data from Multiple Sources: Making Sense of Conformable Data - by David Loshin, Knowledge Integrity This is the third post in this series. Read the previous post. In my last post, the discussion focused on the ability to infer metadata about data sources to be ingested into the enterprise for which there is little (or no) provided metadata. Yet the topic of our discussion is not purely ingestion of data into the enterprise, but integration of that data. So presuming that we were able to assemble a comprehensive view of the metadata for the data sets to be brought into the organization, w...
The Future of ER/Studio: A Roadmap Outlook Customers often ask us what we plan to do for future releases of ER/Studio. Many times we hold that information close, and only provide information under a non-disclosure agreement (NDA). However, we want to show you that we are listening to your requests and responding to your needs. With that in mind, we would like to share the outlook for our 2015 plans for ER/Studio with a short slide deck. This is a high-level summary of some of the planned additions, and we'd be happy to provide you w...

Check out more tips and tricks in this development video: