1 / 0

Who is Polk

Who is Polk . Global Operations. R. L. Polk & Co. is the premier provider of automotive information and marketing solutions to the automotive world and its related industries

senta
Download Presentation

Who is Polk

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. Who is Polk Global Operations R. L. Polk & Co. is the premier provider of automotive information and marketing solutions to the automotive world and its related industries We collect and interpret global data and provide extensive automotive business expertise to help assist our customers with their most important market issues. A privately held global firm, Polk is based in Southfield, Michigan with operations in Australia, Canada, China, France, Germany, Japan, Spain, the United Kingdom and the United States.
  2. ~2.6 Billion Transactions ~500 Million Unique Vehicles ~250 Million Unique Households Personal Firms Financial Institutions Vehicle Manufacturers Titles Registrations Sales Passenger Commercial Polk Data Polk manages a complex set of online vehicle data to support the automotive industry
  3. Polk Data Data management expertise Automotive & consumer data linking & enhancement rules Delivery of application under SaaS Advanced technology platforms automate the collection, standardization, enhancement, storage and delivery of data and analytics Polk Vehicle History Over 2 billion transactions on-line Over 1 million updates per day Support Batch and real-time applications Online transaction queries Operational Data Store Over 600 Million automotive / consumer transactions annually Vehicle Decoding Geography Coding Dealer Coding Data Standardization and conformance Record linking … Polk Insight Automotive market reporting Web based on-line analytics 2TB Warehouse Standard & Ad-hoc reporting Thousands of on-line users Thousands of data feeds: States Governments Auto Manufactures Auto Dealer DMS Finance Companies PolkConnect warehouse/ data marts Global Parts & Service / Sales CRM Over 1300 dealers in 11 counties 12 manufactures Over 180M Service Documents, 800M line items and 24 M vehicles
  4. Polk Solutions Recall Notices Vehicle Verification Services Lead Scoring Global Price & Specifications Dealer Service * Based on. ..
  5. Polk Solutions Recall Notices Vehicle Verification Services Lead Scoring Global Price & Specifications Dealer Service * Based on ….
  6. “Grid” Building Blocks Commodity Intel based servers 4 Dual Core Processors 64 GB Memory Linux RH4 Oracle 10.2.0.4 RAC using ASM GigE Interconnect Tuned for our NIC/Switch hardware Parallel Instance Groups Defined on all DB Instances Prevents RAC from distributing parallel slaves across multiple Without this setting, Infiniband interconnects would be required OEM Grid Control 10.2.0.4 Packs Diagnostic, Configuration, Tuning, Change Management, Provisioning Storage ASM allows mixing EMC DMX4, EMC CX, Pillar
  7. Polk’s “Global Grid” DC Data Center (Production Only) 1 x 6 node cluster, 3 x 4 node clusters, 1 x 2 node cluster Total of 20 DB servers, 160 cores 31 databases (114 database instances) EMC DMX4, 40TB OMS install monitors DC & Southfield Southfield Data Center (Test/Dev/DR) 5 x 2 node clusters Total of 10 DB Servers More than 60 databases EMC CX & Pillar SANs (60TB?) UK Data Center (Production/Test/Dev) 3 x 2 node clusters Total of 6 servers 12 Production databases (22 database instances), more than 24 Test/Dev databases Pillar SAN (7TB in Production, 14 TB for Test & Dev) OMS Install to monitor UK Data Center
  8. High Availability Install
  9. Polk’s DBA Staff Responsibilities 36 Database Servers 43 Production Databases 90+ Test/Dev databases Thousands of production jobs run each month Many Customer facing Web applications High transaction volume 24x7 applications Applications with thousands of users 200+ Polk employees run custom and ad hoc work Responsible for MS – SQL Server databases One DBA team for both Operations and Design/Development DBA Staff One manager and 6 DBAs in Southfield One DBA in the UK office
  10. Storage Management in the Grid Easily Mix & Match storage types Very little interaction with Storage Administrator Mounts or Unmounts LUNs to clusters Little or no downtime for maintenance Point & Click administration A Good example of simplified Provisioning ni the Grid
  11. Choose Target Type of ASM
  12. Choose Target ASM Node
  13. Choose Administration Tab
  14. Login as Privileged User
  15. Choose Disk Group
  16. Click “ADD” Button
  17. Choose Candidate Lun & Rebalance Power
  18. Management by Exception Well defined Alerts are a key to effective management of the Grid Avoid Alert Spam Critical to the on call phone The rest to e-mail (filter to cabinets based on severity)
  19. Target Page Alert List
  20. Alert Log Entries
  21. Target Page Alert List
  22. Click on “Additional Advice”
  23. Click on “View Snapshots”
  24. Click on “Report” Tab
  25. AWR
  26. RAC Statistics
  27. Other Options
  28. Alerts in the real World
  29. Tracking Down Those Mysterious Problems
  30. Setting up Alerts
  31. Create groups
  32. Create Notification rules
  33. Select Groups to be monitored
  34. Create Group Email Accounts
  35. Add your pager/email information
  36. Subscribe to notifcation rules
  37. Blacking out Alerts
  38. Choose Target Type
  39. Choose Target
  40. Click on “Black Out” Button
  41. Refine Target List
  42. Add Descriptive Information
  43. Choose Blackout Type
  44. Choose Blackout Details
  45. Define Blackout Timing
  46. Review Selections
  47. Success
  48. Blackout Expired
  49. Managing RMAN Backups
  50. How we (Polk) schedules and maintains backups
  51. Step 1 – Click on “Preferences”
  52. Select “Preferred Credentials”
  53. Select “Host”
  54. Enter “Default Credentials”
  55. Apply your Credentials
  56. Select “Jobs” tab
  57. Select “Job Library”
  58. Enter “Create Library Job – OS Command” Select “Go” button
  59. Enter Job Name and DescriptionThen and Host
  60. Select a Host
  61. Select “Parameters” tab
  62. Enter script to run on the Host
  63. Select “Credentials” tab
  64. Select “Use Preferred Credentials”
  65. Select “Schedule” Tab
  66. Enter Your Schedule
  67. Select “Save to Library”
  68. Select a Job – then Press the “Submit” button
  69. Change Any Info if Needed
  70. Change Any Info if Needed
  71. Change Any Info if Needed
  72. Change Any Info if Needed
  73. Press “Submit”
  74. Select Job Activity to review jour submitted jobs
  75. Review your Job
  76. Last Night’s Backup Report
  77. Last Valid Backup Report
  78. Database not Backed Up for 7 Days
  79. Backup Schedule
  80. Interconnect Monitoring
  81. Choose Target Type Cluster
  82. Choose Target
  83. Click on “Interconnects” Tab
  84. Interfaces by Host
  85. Interfaces by Cluster Databases
  86. Hosts
  87. Graphs
More Related