Details
What is the next AWESOME in data management?
Presented by Karen Lopez
Friday, September 23, 2:00pm EST
Session Code: ET07
Audience Level: Beginner
Track: Emerging Trends
What's the next awesome thing in data management? Join industry though leaders Karen Lopez, Jim Ericson, Eric Kavanagh, and Donna Burbank as the hot industry trends that will shape the data management industry in the coming years.
This special DMRadio edition is part of the ERworld 2011 online conference, and the speakers will speak to the hot trends that were discussion during the week of ERworld conference sessions.
In collaboration with Information Management.
Details
The ERwin Query Tool - Data Browser on Steroids
Presented by Francois C. Cartier
Friday, September 23, 1:00pm EST
Session Code: ED06
Audience Level: Intermediate
Track: Erwin Education
Were you using Data Browser a lot prior to 8.0? Will you be at a loss with 8.0, because with 8.0, the Data Browser is gone? The Query Tool is the replacement, but its use is more complex and less intuitive that Data Browser. And yet, the Query Tool offers you more, a lot more. This presentation will show you, step by step, how to make the Query Tool easy to use by organizing yourself, by understanding the schema structure of ERwin's metamodel and the O-O approach of metadata storage, and by knowing where to find the information you need. The knowledge you will gain with this presentation will help you embrace the Query Tool as your new model data browser and will also help you make Crystel Reports easier to design. Prerequisite: knowledge of SQL.
Details
Using CA ERwin’s Design Layer Architecture for Enterprise Data Modeling
Presented by Casey Gwozdz
Friday, September 23, 12:00pm EST
Session Code: BI03
Audience Level: Advanced
Track: Business Intelligence
This session explores the use of design layers to synchronize data model and database objects between enterprise level objects and operational level objects. This presentation will include examples of how to leverage enterprise level data models across the organization to ensure consistent use of entities/tables for data warehousing, master data management, transaction systems, and other database driven applications.
Details
Business Benefits Driven by Quality Data
Presented by Ivan Schotsmans
Friday, September 23, 11:00am EST
Session Code: BI02
Audience Level: Intermediate
Track: Business Intelligence
The decision making process will be driven by the quality provided by our data. Quality data is based on a good data architecture, consistent data across departments/business units, ability to relate data from different data sources accurate data values, consistent use of data fields, … Clear responsibilities are required for data design and testing, integration with process designs, data mapping, data migration, data management, roles and responsibilities, policy and procedures design. The most important aspect is business responsibility required data collection, data rationalization and data cleansing. This presentation will dig deeper into the responsibility of business and project owners illustrated by real life examples, importance of leadership, dos and don’ts.
Details
Challenges in Incorporating Unstructured Data
Presented by Thananjayan Chinnaswamy
Thursday, September 22, 2:00pm EST
Session Code: ET06
Audience Level: Advanced
Track: Emerging Trends
How to make customer realise the undiscovered value of Unstructured data that would helped them to make better decision a. Types of unstructured data b) what is the value add for business c)Technological challenges
Details
Using ERwin to Develop Bitemporal Databases
Presented by Tom Johnston
Thursday, September 22, 1:00pm EST
Session Code: ET05
Audience Level: Advanced
Track: Emerging Trends
Most implementations of bitemporal data begin with the data model. Many articles have been written on how to express bitemporal requirements in data models, and many data modelers have developed their own approaches to designing databases which include temporal data (though not usually bitemporal data). This means that the work to develop new data models is much harder, since temporal requirements are difficult to model, and the integration of temporal and non-temporal tables is even more difficult. It also means that existing data models must be modified when temporal features are retro-fitted to their databases.
One of the features of the Asserted Versioning approach to managing temporal data is that it eliminates the need to express temporal requirements in data models. Instead, temporal requirements are expressed with metadata. Since this is declarative rather than procedural work, it is much easier, and less expensive. It also results in a standard way of implementing temporal requirements which, in turn, makes the maintenance and querying of temporal databases much easier.
Based on their long experience with Erwin, Tom and Randy have developed a set of Erwin macros that automates the work of generating temporal databases. These macros reference the temporal metadata specifications associated with a non-temporal logical data model, and generate fully temporal (and bitemporal) DDL from this combination. In this presentation, Tom explains how this works.
Details
Protecting Your SQL Database with Hybrid Cloud Backup and Recovery
Presented by Perry Hurtt
Thursday, September 22, 12:00pm EST
Session Code: CL02
Audience Level: Intermediate
Track: Cloud Computing
You put a lot of time and resources into designing, populating and maintaining your SQL database and it contains important information for your business. Now make sure you can quickly recover your database in the event of an outage, data corruption, or other disaster. Join this session to learn the importance and benefits of using a hybrid cloud backup and recovery solution to protect your SQL database and simplify your recovery efforts – no matter where you need to recover your database.
Details
Agile and Data Modeling: A Marriage Made in Heaven or Hell
Presented by Scott Ambler
Thursday, September 22, 11:00am EST
Session Code: ET04
Audience Level: Intermediate
Track: Emerging Trends
Over the past decade agile software development has taken the world by storm and has clearly become mainstream. Agile is based on an approach that is highly collaborative, evolutionary (iterative and incremental), quality focused, and usage driven in nature. This can be very different that traditional data modeling approaches which are specialized, serial, and data driven in nature.
Does this mean that data modeling, and other data-oriented activities for that matter, cannot be reconciled with agile methods? How do agile approaches and traditional approaches really compare? Is it too late to overcome the cultural impedance mismatch between data professionals and developers? What data-oriented techniques are being pioneered by the agile community? What existing data skills and techniques are still applicable in an agile world? Come find out.
Details
Yes SQL: Microsoft SQL Azure, a Relational Database for the Cloud
Presented by Tharun Tharian
Wednesday, September 21, 3:00pm EST
Session Code: CL03
Audience Level: Intermediate
Track: Cloud Computing
Is it time to take another look at relational databases? With internet scale, high availability, and simple provisioning becoming easier than ever in the cloud, it’s time to see what saying “yes” to a relational database in the cloud means to your business. Join us to see how a relational database can be engineered from the ground up to take advantage of the cloud.
Details
ERwin R8 Reporting - Easier Than You Think
Presented by Victor Rodrigues
Wednesday, September 21, 2:00pm EST
Session Code: ED05
Audience Level: Intermediate
Track: Erwin Education
With the launch of ERwin R8, there are extensive new reporting features to facilitate greater data exchange across your organization. In this webinar we will be exploring these features. Learn how ERwin allows users to... - Generate reusable Crystal Reports that access all of ERwin's Metadata. -Report against multiple diagrams stored within the Model Manager repository. -Use the Bulk Editor to quickly locate objects, make bulk changes, and even export reports for external modification and model update. -Find out how to import and export metadata across multiple repositories and tools. -Promote your corporate value by using the new CA ERwin Metadata Manager to allow business team members web-based access to your designs.
Details
Diagramming flexibility with CA ERwin Data Modeler R8
Presented by Casey Gwozdz
Wednesday, September 21, 1:00pm EST
Session Code: ED04
Audience Level: Intermediate
Track: ERwin Education
CA ERwin Data Modeler release 8 offers a brand new way to communicate your modeling efforts in the form of diagram pictures. This session will show you how you can leverage these flexible diagram presentation techniques, make life easier in working with the product, get non-modelers involved with contributing to the metadata population requirements, and, clearly communicate to the diverse range of your project audience.
Details
Design Layer Architecture for Data using ERwin Data Modeler
Presented by Jeff Harris
Wednesday, September 21, 12:00pm EST
Session Code: ET03
Audience Level: Intermediate
Track: Emerging Trends
Good database design requires careful analysis of both business and technical requirements. Attending this session will give you an understanding of how CA ERwin provides for this in their Design Layer Architecture approach, and how it differentiates the business and technical designs on multiple levels, a high-level conceptual view, a business view and a detailed technical view. It will also give you an insight into how a Design Layer Architecture fits within your Enterprise Architecture frameworks, like the Zachman framework.
Details
Data Modeling 101
Presented by Donna Burbank
& Steve Hoberman
Wednesday, September 21, 11:00am EST
Session Code: ED03
Audience Level: Beginner
Track: ERwin Education
Learn the basics of data modeling. This session will cover with a practical working knowledge of data modeling concepts and best practices, and how to apply these principles with CA ERwin Data Modeler r8. Conceptual, Logical, and Physical data models will be discussed, as well as the proper use-case for each. Basic principles of relational data modeling will be covered such as entities, relationships, keys, and more.
This session is based on Donna and Steve's recent book, Data Modeling Made Simple with CA ERwin Data Modeler r8. The first two people to register and attend will receive a FREE copy of the book.
Details
Improving Data Quality
Presented by Walter Howard
Tuesday, September 20, 2:00pm EST
Session Code: BI04
Audience Level: Intermediate
Track: Business Intelligence
Data Quality is a universal problem. Business users are making strategic decisions based on less than stellar data. Without a comprehensive and automated approach to tracking data quality issues, companies cannot begin to quantify the quality of their data or its associated costs. This presentation lays the foundation required to improve data quality throughout your organization. Learn how to effectively communicate data quality metrics to your business community, analyze root cause failures, and improve the confidence in your data.
Details
Satellite Navigation for Meta Data - Discovering Information Structures
Presented by Hannah Roberts
Tuesday, September 20, 1:00pm EST
Session Code: ET02
Audience Level: Intermediate
Track: Emerging Trends
Finding your way through large databases can be very challenging, particularly in complex data related projects, where current documentation may not be easily available. This presentation introduces a new structured approach which speeds up the data discovery process and provides a more robust foundation when building data warehouses, integrating or migrating data or considering master data management. This is of particular relevance with Enterprise systems. Simple systematic steps are presented to discover the data structure or metadata of part of a complex database. Hints and tips are indicated for the data analyst, and some potential tools suggested to support the method.
Details
Building an Enterprise Data Model with ERwin r8
Presented by Hamilton Hayes
Tuesday, September 20, 12:00pm EST
Session Code: ED02
Audience Level: Intermediate
Track: ERwin Education
Enterprise Data Models can be a vital link between business data requirements and database/data warehouse implementations. Using EDMs can reduce the cost and risk of DB/DW development and improve productivity and governance. This session blueprints a practical method using ERwin DM r8 for building an EDM and integrating it into the Data Model Development Life Cycle.
Details
The Logical Data Model in Agile and Model-Driven Development
Presented by Larry Burns
Tuesday, September 20, 11:00am EST
Session Code: ET01
Audience Level: Intermediate
Track: Emerging Trends
In today's Agile software development environment, the importance of a good logical data model is often overlooked, or derided as an example of "Big Design Up Front" (BDUF). Agile DBA Larry Burns will explain how the logical data model can be used as an Agile model, and can actually drive application development in a model-driven development (MDD) process. He will also explain the importance of keeping the logical and physical data models separate and distinct, and describe how each of these models are developed in an Agile project.
The first two people to register and attend will receive a FREE copy of Larry's latest book, Building the Agile Database.
Details
What’s happening in the ERwin user community?
Presented by Tom Bilcze
Monday, September 19, 2:00pm EST
Session Code: GI02
Audience Level: Beginner
Track: General Interest
Did you know that as a user of the ERwin data modeling suite you are a member of a large global user community? Regional ERwin communities are found across the USA, Europe, Far East and almost all continents. A global community oversees the global interest of the ERwin community. Whether you seek peer support in local meetings or in virtual on-line communities, there is a community that most likely meets your needs.
In this session you will get an overview of these communities and the opportunities they offer. You will see programs that the global community is currently involved in on behalf of all ERwin users. We will discuss ERwin and data related webcasts, community driven product direction discussions, the establishment of an ERwin knowledge-base and the future direction of our community.
Details
Keeping the “Social” in Social Media (Cancelled)
Presented by Darrin Cates
Monday, September 19, 1:00pm EST
Session Code: GI01
Audience Level: Beginner
Track: General Interest
Cancelled - Social networking is all the rage. Millions of people use these tools daily. But too often organizations treat this medium as technology and not as interpersonal communication tools. Darrin takes an indepth look at how to add personal touches when communicating via the major social networks. It's an exciting look at a complicated subject.
Details
CA ERwin Modeling: Today and Tomorrow
Presented by Neil Buchwalter
Monday, September 19, 12:00pm EST
Session Code: ED01
Audience Level: Intermediate
Track: ERwin Education
New and existing ERwin Modeling customers are encouraged to attend this session for an "up-close and personal" review of significant new and updated r8.x product features and functionality. Additionally, attendees will be given a high-level overview of key product features planned for our next major product release – r9. This fast-paced technical session promises to answer commonly asked questions.
Details
Necessary but Insufficient Preparation for Cloud Computing Data
Presented by Peter Aiken
Monday, September 19, 11:00am EST
Session Code: CL01
Audience Level: Intermediate
Track: Cloud Computing
This presentation provides guidance to organizations preparing for cloud computing initiatives. We will show that data quality initiatives are essential when re-engineering data for the cloud and provide examples for structural and data quality-related considerations and benefits. Showing how data quality can be engineered provides a useful framework in which to develop an organizational approach for cloud computing. Participants will also learn about the importance of understanding the role of various data quality tools and techniques that can be used to ensure the success of your organizational cloud computing initiatives.
