1 / 47

GE Medical Systems

e. GE Medical Systems. Migrating a Global Networking Environment to Oracle Internet Directory. e. GE Medical Systems. Daniel Rivera New Technology Implementation Leader Information Management Leadership Program daniel.rivera@med.ge.com Raman Batra Database Architect

glain
Download Presentation

GE Medical Systems

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. e GE Medical Systems Migrating a Global Networking Environment to Oracle Internet Directory

  2. e GE Medical Systems Daniel Rivera New Technology Implementation Leader Information Management Leadership Program daniel.rivera@med.ge.com Raman Batra Database Architect New Technology Implementation raman.batra@med.ge.com

  3. Migrating to Oracle Internet Directory Topics to be Covered • About GE • Problem Statement • About Oracle Internet Directory Technologies • Administering Oracle Internet Directory • Pilot Plan and Summary

  4. Migrating to Oracle Internet Directory General Electric - Overview • GE is a diversified technology and services company dedicated to creating products that make life better • Quick Facts • Chairman and CEO: Jeffery R. Immelt • 2002 Revenues: $137.7 Billion • Number of Shareholders: 4 Million • Number of Countries: > 100 • Number of Employees: > 315 Thousand Imagination at Work

  5. Migrating to Oracle Internet Directory GE Medical Systems - Overview • For more than 100 years, health care providers have relied on GE for high-quality medical technology, services, and productivity solutions • Quick Facts • Radiology, Cardiology, Surgery, Critical Care Units, Molecular Imaging, Clinical Information Systems, Healthcare Services • President and CEO: Joseph M. Hogan • 2002 Revenue: $9 Billion We Bring Good Things to Life

  6. Migrating to Oracle Internet Directory GE Medical Systems - IT Logistics • ~1200 servers ( 40+ Database Servers) • Sun Solaris (E6800-F15K) • 10000+ Users • 1000+ Developers and IT Support (Americas, France, India, Singapore, China, Japan) • 100+ TB SAN Storage (EMC, HP) • 70+ Applications – Sales, Service, Internal Training, Engineering • CRM - Seibel Applications and Home Grown • Data Warehousing Huge, Complicated Environment

  7. Migrating to Oracle Internet Directory GE Medical Systems – Oracle Environment • Applications 11i • Average Peak TPM ~ 20000 • Average Peak number of Processes ~ 12000 • Average Concurrent Users ~ 13000 Enterprise Wide Use of Oracle Technology

  8. Migrating to Oracle Internet Directory Six Sigma Overview – The Way We Work • Identify Process for Improvement, Identify Customer CTQs, Develop Team Charter, High Level Process Map Define • Identify Project Y, Identify Specification Limits, Validate Measurement System, Collect Data, Characterize Data using Standard Deviation Measure Analyze • Identify Functions Required to meet CTQs, Establish Improvement Goal, Simulation, Risk Analysis An • Develop Detailed Design, Flowdown CTQs, Error Proof, Pilot Design • Pilot Verified, Performance Evaluation, Execute Control Plan, Transfer Ownership Verify A Statistical Approach to Product Design

  9. Requirements/CTQ Flowdown DMADV Migrating to Oracle Internet Directory QFD (House of Quality) Many Factors Contribute to Reaching our CTQs

  10. Migrating to Oracle Internet Directory Problem Statement – As Is Process Map Manual Process Leads to Availability Problems

  11. Migrating to Oracle Internet Directory Problem Statement – Manual Touch Points Many Touch Points = Many Chances for Errors

  12. Migrating to Oracle Internet Directory Problem Statement – Goals and Complexity • Availability 99.99% • 260+ Databases • 5000+ Users • 1000+ Developers and IT Support • Leasing Arrangements • Several Global IT Programs Concurrently Running Aggressive Goals Coupled with Complicated Environment. We Need a Better Solution

  13. Migrating to Oracle Internet Directory Problem Statement - Data Huge Availability Issues Whenever a DB is Moved

  14. Migrating to Oracle Internet Directory Goal Project Goal Statement The goal of this project is to increase the availability and MTBF for Oracle databases by improving how we resolve Net Service Names. Key EnablerOracle Internet Directory

  15. Migrating to Oracle Internet Directory What is Oracle Internet Directory LDAP Clients • Directory Service • Fast Centralized Management • LDAP v3 DB • Scalability • High Availability • Security • Standards-based Oracle InternetDirectory Server LDAP over SSL Oracle Directory Manager Oracle9i Database

  16. Migrating to Oracle Internet Directory What is a Directory • Organize Complex Information • Allows quick searches for information about objects

  17. Migrating to Oracle Internet Directory What is LDAP • Lightweight Directory Access Protocol • Standard, Extensible Directory Access Protocol • Based on ISO’s X.500 • Requires Thin Client making it ideal for Internet

  18. Migrating to Oracle Internet Directory Concepts • Entry = Collection of Information about an object • Attribute = Specific information about an entry • Distinguished Name (DN) = Uniquely identifies an entry • Relative Distinguished Name (RDN) = The lowest component within a DN • Directory Information Tree (DIT) = Entry Hierarchy

  19. Migrating to Oracle Internet Directory LDAP - Logical Architecture DIT Attribute Entry DN: cn=Anne Smith,ou=Server Development,c=uk,o=acme RDN: cn=Anne Smith

  20. Migrating to Oracle Internet Directory LDAP – GEMS LDAP Logical Architecture

  21. Migrating to Oracle Internet Directory OID Node

  22. Migrating to Oracle Internet Directory OID Node Concepts • Oracle Directory Server Instance = Services directory requests through OID dispatcher process listening on a specific TCP/IP port • Oracle Directory Replication Server = Tracks and sends changes to replication servers in another OID system • Oracle 9i Database = Stores the directory data • OID Monitor (OIDMON) = Initiates, monitors, and terminates the LDAP server process. Interprets OID Control Utility commands. Logs to: ORACLE_HOME/ldap/log/oidmon.log • OID Control Utility (OIDCTL) = Communicates configuration parameters OID Monitor required to run each Oracle directory server instance

  23. Migrating to Oracle Internet Directory Oracle Directory Server Instance Architecture

  24. Migrating to Oracle Internet Directory Pre-Installation Considerations

  25. Migrating to Oracle Internet Directory GEMS Hardware • CPU: 2x400MHz • Disk: 4GB • Memory: 1GB

  26. Migrating to Oracle Internet Directory OID – Single Point of Failure Client Tier Oracle Internet Directory Database Tier

  27. Migrating to Oracle Internet Directory LDAP - Concepts • Naming Context = A subtree of the DIT that resides entirely on one server. Must be contiguous and must extend to leaf.

  28. Migrating to Oracle Internet Directory OID Replication

  29. Migrating to Oracle Internet Directory OID Partitioning

  30. Migrating to Oracle Internet Directory High Availability and Failover Globally Distributed Architecture Ensures Availability

  31. Migrating to Oracle Internet Directory Reliability Block Diagram Redundant Architecture Ensures Availability and Performance

  32. Migrating to Oracle Internet Directory Simulation Results 99.9987% Uptime

  33. Migrating to Oracle Internet Directory Oracle Directory Manager - Console

  34. Migrating to Oracle Internet Directory Oracle Directory Manager – Creating Classes

  35. Migrating to Oracle Internet Directory Oracle Directory Manager – Creating Classes

  36. Migrating to Oracle Internet Directory Oracle Directory Manager – Creating Classes (Command Line) Ldapmodify –h myhost –p 389 –f myfile.ldi myfile.ldi dn: cn=subschemasubentry changetype: modify add: objectclasses objectclasses: (1.2.3.4.5 NAME ‘myobjclass’ SUP top STRUCTURAL MUST ( cn $ sn ) MAY ( telephonenumber $ givenname $ myattr ) )

  37. Migrating to Oracle Internet Directory Oracle Directory Manager – Command Line Tools • ldapadd [arguments] –f filename • Allows you to add Entries, their Object Classes, Attributes, and Values to the Direcory • ldapbind [arguments] • Allows you to see whether you can Authenticate a Client to a Server • ldapcompare [arguments] • Allows you to match attribute values you specify in the command line with attribute values in the directory entry

  38. Migrating to Oracle Internet Directory Oracle Directory Manager – Command Line Tools • ldapdelete [arguments] [“entry_DN | -f input_filename] • Allows you to delete entire entries from the command line • ldapmoddn [arguments] • Allows you to modify the DN or RDN of an entry • ldapmodify [arguments] –f filename • Allows you to act on attributes • ldapsearch [arguments] filter [attributes] • Allows you to search and retrieve specific entries in the directory

  39. Migrating to Oracle Internet Directory Oracle Directory Manager – Adding Entries with Bulk Tools • bulkload – Load large number of entries to Oracle Internet Directory through LDIF files. • ldifwrite – Copy data from the directory information base into an LDIF file that can be read by any LDAP compliant directory server. • bulkmodify – Modify a large number of existing entries efficiently. • bulkdelete – Delete a subtree efficiently.

  40. Migrating to Oracle Internet Directory GEMS Next Steps: Pilot Demographics • 125 Users • 7 Groups: RTS, Programs, DBA, Center of Excellence • Users located in: United States, France, India • Tested for 1 Month Pilot Group is Representative of End User Community

  41. Migrating to Oracle Internet Directory Benefits to be Attained: Higher Availability A Possible Game Changer for GE Medical Systems

  42. Migrating to Oracle Internet Directory Benefits to be Attained: 1 Change vs. Hundreds DBA End Users A Possible Game Changer for GE Medical Systems

  43. Migrating to Oracle Internet Directory Benefits to be Attained: 1 Change vs. Hundreds End Users DBA OID Server A Possible Game Changer for GE Medical Systems

  44. Migrating to Oracle Internet Directory Benefits to be Attained: Centrally Managed End Users DBA OID Server A Possible Game Changer for GE Medical Systems

  45. Migrating to Oracle Internet Directory Benefits to be Attained: Productivity Increase A Possible Game Changer for GE Medical Systems

  46. Migrating to Oracle Internet Directory Roadblocks • Product Maturity • Release Vehicles: 9i AS • Problems with Replication • Problems with Bulk Tools: ldifwrite, bulkload, bulkdelete Need to resolve issues before Production Rollout

  47. e GE Medical Systems Thank You Daniel Rivera New Technology Implementation Leader Information Management Leadership Program daniel.rivera@med.ge.com Raman Batra Database Architect New Technology Implementation raman.batra@med.ge.com

More Related