Purchase Solution

Delta Dental Michigan

Not what you're looking for?

Ask Custom Question

Review of current database size, partitioning approach and make recommendations based on key attributes. Review data model for opportunities to optimize and make recommendations. Create 3-5 slide deck on Oracle12c features that can be leveraged for large databases, any tiered storage data management to support ILM. Lead DBA discussions with client DBAs and participate in DBA related discussion with team.

1. Size doesn't matter all that much if the data is managed properly (that is, the data is managed for performance and usability). Small databases that are badly managed can have very slow, sloppy and inconsistent performance.
2. Opportunities will include making sure we got partitions and that they match the way queries are used. For instance, we don't want partitions on date when all the queries refer to some other column.
3. New features of Oracle 12c New Features doc.
4. ILM (Information Lifecycle Management) has been expanded and refined for 12c.
5. DBA team discussion:
a. Challenges
b. Observations
c. Suggestions
d. Issues they'd like to see addressed

Attachments
Purchase this Solution
Solution Summary

Report on current situation and recommendations for moving to oracle 12c

Solution Preview

Partitioning Approach
Partitioning strategy must be one that maximizes benefits while minimizing adverse effects. Oracle 12c provides the most comprehensive set of partitioning strategies which rely on fundamental data distribution methods. Partitioning approach that should be utilized by Delta Dental is composite partitioning with combination of Range and Hash Partitioning.
Range partitioning
Data distribution: consecutive range of values. Data tables partitioned by order-date
Hash partitioning
Data distribution: internal hash algorithm. Data tables partitioned by customer_id
New features of Oracle 12c
Introduces 10th generation of partitioning, enabling customers to take advantage of Oracle Partitioning for their needs
Differentiates between three types of index- local index, global partitioned index and global non-partitioned index.
Data pruning can occur on a partition level and even on much finer granularity- zones. For partitioned tables the zone map also contains the ...

Purchase this Solution
Free BrainMass Quizzes
IPOs

This Quiz is compiled of questions that pertain to IPOs (Initial Public Offerings)

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Organizational Behavior (OB)

The organizational behavior (OB) quiz will help you better understand organizational behavior through the lens of managers including workforce diversity.

MS Word 2010-Tricky Features

These questions are based on features of the previous word versions that were easy to figure out, but now seem more hidden to me.

Learning Lean

This quiz will help you understand the basic concepts of Lean.

View More Free Quizzes
Related BrainMass Solutions

  • Nonparametric Hypothesis Testing

    Listed below are the costs of flights from New York to San Francisco for US Air, Continental, Delta, United, American, Alaska, and Northwest.

  • Continuous probability distribution - Dental insurance for employees

    45217 Continuous probability distribution - Dental insurance for employees Shaver Manufacturing, offers dental insurance to its employees.

  • The Environmental Impact of Dental Floss

    How is the materials used to make dental floss useful to the ecosystem? 4. Which brands make the better packages for dental floss? 5. How does dental floss affect pipes and septic systems if these are used by consumers to dispose of it? 6.

  • Adverse Selection versus Moral Hazard Incentive Problem

    Employees who elect dental coverage pay the remaining 20% of the dental premiums. The costs of the employee dental plan have been skyrocketing 35% per year. In 2005, 79% of the employees chose dental coverage.

  • Three scenarios of Adverse Selection and Moral Hazard, and p

    Employees who elect dental coverage pay the remaining 20% of the dental premiums. The costs of the employee dental plan have been skyrocketing 35% per year. In 2005, 79% of the employees chose dental coverage.

  • Adjusting Entries

    ., opened a dental practice on January 1, 2002... Karen Tong, D.D.S., opened a dental practice on January 1, 2002. During the first month of operations the following transactions occurred. 1.

  • Ethics and Jurisprudence

    240796 Ethics & Jurisprudence in dental practice are noted. Guiding questions: What do you think is the most critical aspect of Risk Management in dental practice? How do you think this will affect your dental hygiene practice?

  • Prepare journal entries for first month of operations

    ., opened a dental practice on January 1, 2008. During the first month of operations the following transactions occurred. 1. Performed services for patients who had dental plan insurance.

  • maximizing profits

    Michigan will be $5 (the cost of 200th unit).

View More Related Solutions