DB/Artisan & Performance Center Product Overview

1. DB/Artisan & Performance Center Product Overview we make data work™

2. What is DB/Artisan? Embarcadero DB/Artisan, the leading cross-platform database administration solution, helps DBAs maximize availability, performance and security.

3. DB/Artisan: Editions • DBArtisan Standard • Provides standard cross-platform database administration facilities for a specified number of databases • DBArtisan Professional • Provides cross-platform database administration facilities for an unlimited number of databases and includes the Embarcadero SQL Debugger and SQL Profiler • DBArtisan Workbench • Provides cross-platform database administration facilities for an unlimited number of databases, includes the Embarcadero SQL Debugger and SQL Profiler for troubleshooting SQL code, and also contains the Embarcadero Analyst components for proactive, advanced storage and performance management

4. DB/Artisan Workbench • Proactive Diagnosis and Management • Space Analyst:storage/object diagnostic tool combined with Job Reorganization Wizard • Capacity Analyst:storage and object growth tracking facility for proactive planning and problem prevention • Performance Analyst: client-side visual database monitor that pinpoints problems that threaten availability • Powerful Back-up and Recovery • Back-up Engine: for back-up and recovery that significantly reduces storage requirements (SQL Server) and speeds up the task

5. New Object Editors and Wizards DBArtisan 8.5 continues the reworking the object editors and wizards. Aimed at improving workflow and the user interface experience, the new editors and wizards adopt a .NET look and feel, and are being reworked for consistency. Improvements to SQL Editor components and the underlying SQL Engine A new results view grid has been implemented. Display options now allow you to switch between HTML, grid, and ASCII views. The default for the locking mechanism has been changed so that locking a query/results window to a data source remains in effect until you disable the lock, regardless of data source changes in other windows. Lastly, the results view generated on ‘Select * From’ functionality, and the Script Execution Facility, is now accompanied by an ISQL editor tab that lets you view and work with the SQL source. Schema Migration/Extraction Enhancements Options new for 8.5 optimize several aspects of schema extraction and migration. These include an option to determine dependencies by text parsing, a USE statement option, the ability to execute SQL statements before and after procedure or function extraction, and integration of DT/Engine. Additional Currency Features For each supported DBMS, DBArtisan has been upgraded to take advantage of features previously unsupported. Highlights include DB2 table partitioning, Oracle RAC and Automatic Memory Management support, support for Microsoft SQL Server schema objects, 2005 permissions, and new LOB datatypes, and new Sybase datatypes and security features. Bug Fixes and General Improvements The most significant general improvement is to performance when working with large results sets. What’s New in DB/Artisan 8.5? More

6. What is Performance Center? Embarcadero Performance Center is a 24/7 performance monitoring solution with user-defined alert thresholds and concise status information accessible through an intuitive GUI and any standard Web browser.

7. Performance Center: Business Benefits • Improve service levels across applications • Ensure 24/7 monitoring • Identify and correct potential problems • Decrease response times • Reduce inefficiencies and lower maintenance costs • Address performance proactively; spend less time in crisis management • Gain insight into usage trends to plan for capacity changes • Leverage existing staff to meet increasing demand • Reduce the time spent finding problems with the centralized user interface • Help DBAs work across database platforms as generalists with one standard solution • Enable novice administrators to do jobs that ordinarily require experts

8. Performance Center: Technical Benefits • Ensure viability of your databases, regardless of platform • One system for managing performance and availability across key database platforms, making it easier to find and correct problems • Enhance quality of management • Key statistics rolled up into one indicator for at-a-glance performance information • Historical performance statistics for every database • Tailored expert health guides for each database platform • Pre-configured templates for alarm thresholds and notifications to facilitate standard operating procedures • Easily view, identify and protect against potential problems • Web-based interface included for viewing anywhere • Customizeable problem notification: define alarm thresholds, method of notification (email, pager, etc.), and report contents • User-defined escalation path (who receives what information when)

9. 24/7 Protection Constant performance monitoring Enterprise-Ready Interface One consolidated view for all Oracle, Sybase, SQL Server and DB2 (2.0) databases User-defined alarm thresholds Drill-down capability per database Embarcadero Health Index Aggregate indicator for overall database performance Customizable by user Historical Reports Repository of performance statistics Scheduled extractions to flat files Proactive Notification Integration with Embarcadero Job Scheduler or Microsoft Windows Task Scheduler Customizable problem notification with templates Programmable Responses Automatic scripted response support (command line or SQL job invocation) Performance Center: Key Features

10. What’s New in Performance Center • Web interface • View performance data in any standard Web browser, including historical information • Eliminate the need for client software installation • Support for Unix and Linux • Fully protect their database systems by identifying problems on the actual database server machines • Exportable performance information (1.9.5 and above) • Extract performance data to send to other databases, query-able formats, Web interfaces or Excel; receive information in the format that best suits your needs • Support for DB2 on LUW (2.0)

11. Why Choose Performance Center • Lightweight, non-invasive 24/7 server-side solution • Does not deploy agents or put anything into the database • Proactive notification of impending problems • Multiple address / notification capabilities – email, pager, SMS, SMNP, etc. • Health Index • Single indicator created by compiling configurable statistics for memory, I/O, space, network, objects, etc. • Integration with DBArtisan • Go from finding problems to fixing / avoiding problems quickly

12. DEMO

13. What is ER/Studio? ER/Studio, a model-driven data architecture and database design solution, helps companies discover, document, and reuse data assets. With round-trip database support, data architects have the power to thoroughly analyze existing data sources as well as design and implement high quality databases that reflect business needs.

14. Related ER/Studio Products & Add-ons • ER/Studio MetaWizard • Import and export models and metadata from a wide variety of UML and Data modeling applications, BI platforms, and industry standard exchange formats • ER/Studio Viewer • Advanced viewing, navigation and printing features to support non-modeler team members • Schema Examiner • Provides in-depth analysis of schema design to relational theory best practices. • EA/Studio • Provides graphical process model integration and analysis via BPMN, an emerging process modeling standard.

15. What Can Data Modeling Do For Me? • Discover • Visualize database assets • Navigate them with ease • Analyze • Analyze impact of change • Correct data inconsistencies • Centralize • Link to corporate standards • Collaborate on database designs • Build • Rapidly build databases • Enforce physical design standards • Communicate • Generate “a la carte” reports to various audiences • Generate comprehensive on line “data dictionary”

16. ER/Studio Enterprise Architecture ER/Studio Clients TCP/IP Native Client Connection Open Architecture Demonstration Repository Server “Communication Traffic Cop” Installs on Windows Server (currently) Repository Communication Service Repository Database Service Repository Event and Dispatch Service RDBMS Native Client Utilities Repository Database “Persisted Data Store” Windows or Unix flavor Host OS’s Oracle, DB2, Sybase or SQL Server RDBMS Native Client Utilities

17. ER/Studio Enterprise Overview • Project Creation • Organize Diagrams into Projects • Apply Security to Projects • Version Management • Manage all successive states of Diagrams, models and object metadata. • ‘Branch & Merge’ diagrams away from ‘gold’ or ‘certified’ releases • Named Releases • “Code Freeze” versions of a Diagram. • Roll back to Named Releases for disaster recovery purposes • Repository Security, Users & Roles • Bind Users to Projects, Diagrams, Objects, Dictionaries • Simple model allows for flexible role based access • Users can be created and bound to many roles (e.g. access and duty privileges of the repository) • Roles are an uniquely named set of permissions (‘allowances or denials’) attached to specific functions of the Repository. • Administrative User Management • Power user functions to help govern Repository users and their activities.

18. ER/Studio Enterprise Overview • Concurrent Diagram and Object Access • Real-time collaboration • Entity is lowest level of collaboration (at this time) • Real-time Objects Status Notification • Understand who in your enterprise is accessing objects in real-time • Display/hide status symbols in tree and on diagram • Reviewing Changes and Resolving Conflict • Selective bi-directional updating of conflicting changes in the Repository • Over write subordinate changes. • Component Sharing and Reuse • Enterprise Data Dictionary (EDD) Standardizes Low Level Object use across diagrams • Report on distribution of objects across diagrams • “Detached” Collaboration • Work off-line from Repository Server • Return, check in and resolve conflicts

19. ER/Studio Enterprise Overview • Diagram Stored in an open/documented Relational Database • Repo Database installed on distributed databases: Oracle, Sybase, SQL Server or DB2 LUW • Objects are intentionally user-approachable to ensure YOU know where YOUR (meta) data is. • Installation is extremely simple. • Meta-Model ships with ER/Studio • Note that DM1 file shows ‘logical’ relationships but the database enforces RI programmatically • Use the Sub models! • Sample Queries ships with ER/Studio • Queries demonstrate the relationship chains of many common queries and ensure understanding of Versioning to obtain the most up-to-date data from the Repository. ER/Studio Standard vs. Enterprise Architectural Breakdown Architectural Breakdown Enterprise Collaboration Enterprise Collaboration Secure Collaborative Modeling Open Architecture Demonstration Demonstration

20. Why Choose ER/Studio? • True separation of models • Manage multiple physical models along with relationships to logical model • Ease of use • Highly intuitive user interface to ensure immediate productivity gains • Diagram layout engines and navigation • Easy-to-use, effective diagram layout features • Extensive navigation features including pan, zoom and relationship navigation • Flexible, adaptive architecture • VBA capability for customizing applications • Incorporation and reuse of existing functions • Open RDBMS Repository that you can query • Provides visibility into data use and re-use • Helps streamline new development efforts

21. What’s New in ER/Studio 7.5? • XML Schema Generation Wizard • Modelers can generate an XML schema based on a logical or physical model or sub model. • Customize XML schema structure by clicking the desired options and dragging the available objects from the database design into a tree representing the XML schema. • Transform relational entities and attributes into complex types, elements and attributes • Naming Standards Utility • Modelers can now define and apply naming standards to logical and physical objects by using naming standards templates. • Naming Standards Templates support acronyms, abbreviations, and rankings for duplicate abbreviations. • Flexible naming conventions for logical and physical models are supported by using an abbreviation list when translating names used in the logical model type to names used in the physical model type. • Custom Logical to Physical Data Type Mapping • Data type mapping between the logical and physical models has now been exposed to customize how logical data types map to each physical database platform. • Using the Data type Mapping Editor, you can replace the default physical data type mapping of an object and select another data type for the selected platform.

22. Metadata: The Key to Enterprise Data Management • The Enterprise Metadata Landscape Metadata Sources The legacy apps know customer as: CU22E_SS Spreadsheets, documents, files and like treat customer as: Customer, Cust, Partner, Internal Resource, etc Various data and application models treat Customer as: Party, Customer, Supplier, Employees, both business and technical think of a customer as: Someone who buys goods, A Partner, A Party, The enemy…. Our front end applications, intranets, web sites, e-commerce portals think of customer as: VisualBasic, PowerBuilder, Access…all managing customer differently!

23. Metadata: The Key to Enterprise Data Management • The Enterprise Metadata Landscape Metadata Integration, Where Used Analysis, Documentation CU22E_SS Customer, Cust, Partner…. PARTY, Customer, Supp… Standards-based Metadata Interchange (OMG XMI, W3C XSD, etc) “A customer is a….” Business Entity: Customer Business Rules: “A customer can…” Where Used: Database A, spreadsheets a,b, c, [FIELD]: CUSTOMER

24. Metadata: The Key to Enterprise Data Management • The Enterprise Metadata Landscape Metadata Management External Metadata to Core Enterprise Metamodel Mapping Metadata Management Metadata Marts

25. Metadata: The Key to Enterprise Data Management • The Enterprise Metadata Landscape Metadata Repurposing and Delivery ETL B.I. Customer Customer Warehousing Metadata Management Customer Customer Customer Customer Customer Customer Customer Metadata Marts

26. Metadata landscape

27. What is EA/Studio Business Modeler Edition? EA/Studio is a modeling tool for documenting business processes and how those processes use data screenshots

28. EA/Studio Business Benefits • Better communication between data modelers and business people • Reduce implementation time by thoroughly capturing process and data requirements • More easily articulate how data modeling directly impacts the business • Understand the relationships between processes and data • Easily answer questions like ‘Which business people modify customer data?’ or ‘What business processes touch the order management database?’ • More efficient business processes • Find and eliminate inefficiencies in document business processes • Make the data needed for these processes more readily available • Enterprise architecture projects that work • Use process, conceptual, and data modeling to solve real world business problems • Use underlying meta-model to incrementally develop models over time that build on each other

29. EA/Studio Technical Benefits • One tool for business users and modelers • User interface allows for capturing concepts and process diagrams by business users without requiring them to understand or interact with complex modeling notations • Powerful capabilities allows modelers to add meta-data and notation compliance during creation or later on • Separation of data and display • Underlying model captures meta-data independent of the display diagram for better information sharing and performance • Show the information to users in a format they want: the definition of “customer” is the same whether it’s in a ER model, UML class diagram, or spreadsheet of business terms. • Based on open standards • Business process modeling based on the BPMN notation standard • Built on the Eclipse framework • XML-based file format • Leverage existing work • ER/Studio import/export • Visio and Excel import / export • Export to HTML, XML, PDF, MS Word

30. EA/Studio : Key Features • Conceptual modeling • Model core business concepts • Use conceptual models as the foundation for logical and physical data models • Business process modeling • Create process models using elements such as tasks, events, sequences, and gateways • Models support the full semantic of the BPMN standard • Impact analysis reporting • Report on the relationships between elements in the models to see how people, processes and data interact • Usage (CRUD) reporting • Link business processes and data • Display and analyze these links to understand how data is used • Import/export • ER/Studio, Visio, Excel, HTML, Excel (CSV), PDF, etc.

31. EA/Studio can help you • Communicate with business users without them having to understand technical models with things like crow’s feet, cardinality, data structures, foreign keys, etc. • Get funding for data modeling projects by showing business impact • Quickly get an understanding of business processes • Use conceptual models to gather core requirements from business users around the basic concepts and subject areas of the business. • Track what business processes are using what data • Move your process modelers away from Visio & PowerPoint to a more robust tool that is as easy to use, but track the core metadata needed to meaningfully interact with IT (e.g. to create data models and process models)

32. ER/Studio Embarcadero Technologies Award Winning Data Modeling Tool In Use By More Than 10,000 People. Intuitive data modeling Forward/Reverse engineering Enterprise model management True separation of logical and physical models Metadata support for business definitions, etc. Integration with process modeling (EA/Studio) EA/Studio: Related Products

33. DEMO