Implementation Study: Dell It Scales Supply Chain Management with Oracle Rac 10g

In: Computers and Technology

Submitted By taetae
Words 2272
Pages 10
dell enterprise technology center series

Implementation Study:
Dell IT Scales Supply
Chain Management
with Oracle RAC 10g
By Dave Jaffe, Ph.D.
Todd Muirhead
Tiong Tey
Raveendra Avutu

T

When the expensive proprietary servers running the Dell supply
chain management systems had reached their limits, the Dell
IT group migrated to cost-effective, standards-based Dell ™
PowerEdge™ servers running Oracle® Real Application Clusters 10g.
This architecture helped enhance database performance while
providing scalability for future growth.

tiple locations around the world. Using the same processes

worldwide manufacturing operations, including the

for disaster recovery, backup, and monitoring across all
Dell operations enables Dell IT to take advantage of a cost-

delivery of computers, accessories, parts, and supplies. These

effective and readily supported deployment model. This

systems must be designed for reliability and cost-effective scal-

Database

implemented this type of system for Dell operations at mul-

systems handle key business functions that support

efficient Dell inventory management model and fast, direct

Related Categories:

he Dell supply chain management (SCM) database

article describes how Dell IT migrated its critical SCM appli-

ability: a failure can cost thousands of dollars per minute in

cations from proprietary UNIX-based servers to industry-

factory downtime, and the SCM systems must be able to

standard Dell hardware.

handle increasing workloads as the company grows.
When Dell was a smaller company than it is now, before

Dell supply chain management

Dell Enterprise
Technology Center

the development of powerful, industry-standard servers of

The Dell SCM system must handle an enormous number of

Implementation study

the type that Dell manufactures, the Dell IT…...

Similar Documents

Which Supply Chain Management and Effective Supply Chain Strategies Affect Competitive Advantage of Dell Company

... grated fresh ginger • Salt and pepper • 2 cloves garlic, crushed Back to recipe index DIRECTIONS 1. Combine all the ingredients in a big bowl. 2. With clean hands, squeeze it together until it’s very well combined. 3. Divide into three equal portions and form into burgers about ¾ inch (2 cm) thick. 4. Spray a skillet with non-stick cooking spray. 5. Place over medium-high heat. 6. Cook the burgers for about 5 minutes per side until cooked through. - Per Serving - CALORIES: 450 184 PROTEIN : 33g CARBS : 4g FAT : 4g Metabolic Cooking ©2011 Dave Ruel | Page 4 ASIAN TURKEY BURGERS Page 4 Metabolic Cooking ©2011 Dave Ruel | Page 5 CHICKEN LIVER SAUTE No overcooking with liver, which makes chicken livers an ideal super-fast gourmet, and low-cost meal! P INGREDIENTS RECIPE MAKES 2 SERVINGS • • • • • • • • • • 8oz chicken livers 4 big sliced mushrooms ¼ cup minced onion 1 teaspoon macadamia oil 1 clove garlic, crushed ½ teaspoon rosemary ¼ cup orange juice ½ teaspoon lemon juice Salt and pepper Pinch of stevia DIRECTIONS 1. Cut livers into chunks and slice the mushrooms. 2. Coat skillet with macadamia oil over medium-high heat. 3. Add the livers, mushrooms, onions, and garlic, and stir-fry until the mushrooms are starting to change color and most of the pink is gone from the livers. 4. Add the rosemary, orange juice, lemon juice, and pinch of stevia, salt and pepper. 5. Let it simmer for just 1 to 2 minutes. - Per Serving - CALORIES: 168...

Words: 3741 - Pages: 15

Supply Chain Management

...| |Fall 2013 | | |[pic] | | | | | | | INSE 6290 Quality in Supply Chain Design DISTRIBUTED COORDINATION IN SUPPLY CHAIN MANAGEMENT CONCORDIA UNIVERSITY November 5, 2013 Montreal, Canada 1. INTRODUCTION A supply chain refers to the production and distribution process from raw materials to finished goods. Members of the supply chain are dependent on each other to reduce overall cost and maximize their profit. This dependency, resulting in risk and uncertainty along with benefit, has recently been increasing due to the rapid innovation of information technology, globalization, and outsourcing. A need for coordination mechanism arises from interdependencies between the activities of supply chain members and this need differs depending on sources of complexity and uncertainty. Supply chain coordination is ``a term encompassing cooperation (joining operation), collaboration (working jointly), and integration (combining into an integral whole). It also involves information system alignment (jointly expanding the information structure beyond the boundaries of each supply-chain member...

Words: 4186 - Pages: 17

Study of Supply Chain Management

... in its concept. This is also an interesting difference between logistics and supply chain management. Experts argue that logistics management is a part of the supply chain management that plans and implements the flow and storage of goods, services in order to meet the demands of the consumers. This is indeed an important study made by the experts. On the other hand supply chain management encompasses the management of all activities involved in the procurement and conversion. In addition to these activities the supply chain management takes care of all the logistics management activities. It is important to note that supply chain management involves all movements and storage of raw materials. In short it can be said that supply chain management takes care of the design, planning, execution, control, and monitoring of supply chain activities with the sole objective of creating net value and leveraging worldwide logistics. On the other hand logistics can be simply defined as the management of the flow of goods and the services between the point of origin and the point of consumption in order to meet the requirements of customers. It is interesting to note that logistics is a business concept that was introduced for the first time in the year 1953. Business logistics is nothing but having the right item in the right quantity at the right time at the right place for the right price in right condition to the right customer. It is also interesting to note that logistics...

Words: 1749 - Pages: 7

Supply Chain Risk Management

... models for risk management: Robust planning: This planning approach aims at exploring the uncertainty inherent in a supply chain, and developing optimization decisions which provide more predictable results. For instance at strategic decision level, how to design a supply chain so that key performance indicators have stable outcomes for different production scenarios. At operational level, we should investigate which control policy needs less modification with a changing production environment. Also it is of interest to investigate the institutional aspects of supply chain, namely, with updated conditions and institutional constraints, how the previous supply chain decisions can be modified. This involves not only the robustness of a decision, but also the (re)computational efficiency of the optimization algorithms. One advantage of this approach is due to its proactive planning capability. Revenue management: As we have mentioned in this paper, most supply chain risk study focus on supply side. But with a supply disruption, we can still use different pricing policies to redistribute customer’s demand for different products so as to mitigate the supply risk. Such a policy was used by Dell when they faced a chips supply problem in Taiwan. In this case, revenue management can be used to develop pricing policy and O. Tang, S. Nurmaya Musa / Int. J. Production Economics 133 (2011) 25–34 33 investigate how to allocate and relocate capacity to different market segments when...

Words: 8250 - Pages: 33

Oracle 10g Forms

... = :ARTICLES.CODE And emp.ref_emp.emp = :CASES.EMP ; 2.4 Items 2.4.1 Principal items file:///D|/Cours/tuto_forms/paper/PDFtutoforms10g.htm (13 sur 24)29/05/2006 23:09:57 Oracle Forms 10g : Demos, Tips and Techniques TEST_ITEMS.FMB Here is a description of the main items. Click everywhere on each item to see some information messages and some particular behaviours. 2.4.2 List items TEST_LISTES.FMB Let’s study and handle the three sorts of list item and also the different ways to populate them. In this sample, the three list items are synchronized. Change the value of the first list and it will adapt the content of the second then the content of the third. For each new list value, the corresponding value and label are displayed. a) The first list item is populated with the RG_MOIS record group: -- List 1 -errcode := Populate_Group( 'RG_MOIS' ); CLEAR_LIST('BLOC2.LISTE1'); POPULATE_LIST('BLOC2.LISTE1', 'RG_MOIS' ); -- Select the first value -:BLOC2.LISTE1 := Get_List_Element_Value('BLOC2.LISTE1', 1 ) ; b) Then init the second list item -- Update the weeks list -errcode := Populate_Group( 'RG_SEMAINES' ); CLEAR_LIST('BLOC2.LISTE2'); POPULATE_LIST('BLOC2.LISTE2', 'RG_SEMAINES' ); -- Select the first value -:BLOC2.LISTE2 := Get_List_Element_Value('BLOC2.LISTE2', 1 ) ; c) That finally init the third list item: PROCEDURE Init_Liste3 IS LC$D Varchar2(12) ; LC$Day Varchar2(20) ; BEGIN file:///D|/Cours/tuto_forms/paper/PDFtutoforms10g.htm (14 sur 24)29/05/2006......

Words: 3526 - Pages: 15

Logistics and Supply Chain at Dell

... provide some detail on the four basic supply chains and one incubator supply chain that you created – what kind of customers do each of them serve, and how do they differ from one another in the manner that they function? We basically break our supply chains into a few simple choices. (pls refer to Figure 1 below)  The main differences between each supply chain are:  The location of the push-pull horizon within the supply chain  The lead time from customer order to delivery  The amount of choice available to the customer Voice of the Customer I want a product, service. When can I get it? Global Demand Planning World-Class Purchasing and Supply Management World-Class Partner Relationships I buy from Dell. Online My order is“in production.” Build to Stock Build to Plan Build to Order Configure to Order My order is“in transit.” I got it and use it. I get support. Product Design Multiple Transportation Modes Warranty Sales Agent Partner Network Customer Care Customisation and Personalisation Supply Chain Service Options Technical Support Preconfigured by Dell Customer Configured Retail Distributor Customer or Commitments VAR Cost-to-Serve Financials Data and Tools Figure 1 January/February 2011 Supply Chain asia 31 dialogue  Customers:  With specific needs will choose configurable products  Who want to use Dell as a trusted advisor will tend to choose pre-configured products  Who value speed will choose from finished......

Words: 1294 - Pages: 6

Oracle Rac

... ..................... 14 Appendix B: Example script for setting the correct VMM settings .... 16 References...................................................................................... 17 Oracle White Paper — Oracle Real Application Clusters on IBM AIX - Best practices for system stability Executive Overview IBM and Oracle have a long standing history of technical collaboration to enhance Oracle products on IBM Power™ Systems. This joint commitment to support the Power System platform’s performance, scalability and clustering capabilities allows customers to effectively deploy Oracle Real Application Clusters (RAC) on a broad range of configurations. To support customers who choose to deploy Oracle RAC on IBM Power Systems servers IBM and Oracle have prepared this recommendation of best practices for managing memory use on AIX® systems running Oracle RAC. Implementing these recommendations will provide customers with the best possible availability and performance of the Oracle Database, and reduce the potential for node evictions due to memory over commitment. Key elements of the best practices are tuning AIX and Oracle RAC, moving to the current Oracle Database 10g Release2 patch set and monitoring the system resources to insure memory is not over committed. Introduction Customers who experience Oracle Real Application Clusters (RAC) node evictions due to excessive AIX kernel paging should carefully review and implement these recommended best practices.......

Words: 4075 - Pages: 17

Supply Chain Dell

... been able to cut down costs on warehousing, hiring people to track and maintain inventory, and thus avoid using out dated technology. As depicted in the diagrams the technique is surprisingly simple but it is best competitive tool in increasing profit. One other thing which makes this supply chain really competitive is the fact that DELL’s customers can only order computers through DELL itself which results in a profoundly bond with the customers . This makes them retain their market share in the business. DELL is also having strategic alliances with other companies to have their products sold on DELL’s direct selling distribution channel. All these elements in their supply chain make them the best in the business. The main supply chain challenges * Long-term demand sensing to continually refine its portfolio — Dell's direct model provided extensive customer insights, with over two billion online customer visits per year. But the company also had to figure out how to predict where the market was headed, define a three-year outlook of customer needs and support multiple global customer groups. * Supply chain design for a new environment — It had to address a changing business strategy, product commoditization and proliferation, emerging markets, global supply networks and multichannel sales and fulfillment. * Complexity reduction — Dell had to carve out an end-to-end, "low-cost" supply chain focused on efficiency, while maintaining its responsive heritage......

Words: 1626 - Pages: 7

Supply Chain Design and Implementation

...Assignment 2: Supply Chain Design and Implementation This assignment will help you develop an understanding about the life cycle of supply chains including the models that are aligned with it and the cost it bears. In addition, you will develop an awareness of the elements of the supply chain that should be monitored to ensure the desired results are being obtained. Scenario: You have been asked to be a guest speaker in a high school business class. Your task is to explain the basic concepts of supply chain management to a group of students. The students will take a quiz on supply chain management based on the information in your presentation. Instructions: Develop a creative, engaging, educational handout that students can use to prepare for the quiz. Your handout should accomplish the following tasks. 1. Diagram and explain the life cycle of a supply chain. 2. Explain, and provide examples of, the models organizations use to manage forecasting, planning, and inventory. 3. Examine, and provide examples of, the costs absorbed by organizations with respect to inventory and logistics. 4. Describe how organizations use various parameters to monitor supply chain performance and provide examples. Your handout should be written in a clear, concise, and organized manner, as well as demonstrate ethical scholarship in accurate representation and attribution of sources (i.e., APA); and display accurate spelling, grammar, and punctuation. Write a 1–2-page handout......

Words: 252 - Pages: 2

Case Study 14.1- Supply Chain Management

...Case Questions 1. A decently overseen database may help the healing center accomplish its mission by the following points: * Cost of the each treatment in similar hospital is stored in the database to compare rate with other hospital. * Physicians can gather the relevant information quickly by providing the electronic medical record for each patient. * To find which programs and methods are best, create a historical record of the treatments. * Track the important measure to provide the data and information for example, normal length of patient wait, price for each day for a patient. 3. Hospital should carefully manage some of the cost and risk of using database because in a job market, there is short supply of skills such as database designer and database administrator. Without the specific faculty, it creates a risk to manage the database. The installation and administration expenses include updating software and installing of database and hardware. The translation cost includes the converting cost of older application into database environment. Instead of converting the hospital can choose new system. There is a need for the backup and recovery because the framework expenses are connected with those strategies. A hospital must predict the data administration cost and other activities cost related to data definition, ownership and maintenance. 6. Mountain View Hospital could use web based applications in a few ways. * Internet hospital personnel...

Words: 410 - Pages: 2

Oracle Rac Setup

...: # date -s "7/28/2009 23:00:00" Setting the date and time from linux2: # date -s "7/28/2009 23:00:20" The two-node RAC configuration described in this article does not make use of a Network Time Protocol server.   14. Configure the hangcheck-timer Kernel Module Perform the following configuration procedures on both Oracle RAC nodes in the cluster! Oracle9i Release 1 (9.0.1) and Oracle9i Release 2 ( 9.2.0.1) used a userspace watchdog daemon called watchdogd to monitor the health of the cluster and to restart a RAC node in case of a failure. Starting with Oracle9i Release 2 (9.2.0.2) (and still available in Oracle 10g Release 2), the watchdog daemon has been deprecated by a Linux kernel module named hangcheck-timer which addresses availability and reliability problems much better. The hang-check timer is loaded into the Linux kernel and checks if the system hangs. It will set a timer and check the timer after a certain amount of time. There is a configurable threshold to hang-check that, if exceeded will reboot the machine. Although the hangcheck-timer module is not required for Oracle Clusterware ( Cluster Manager) operation, it is highly recommended by Oracle. The hangcheck-timer.ko Module The hangcheck-timer......

Words: 13991 - Pages: 56

Implementation Study: Dell It Scales Supply Chain Management with Oracle Rac 10g

...dell enterprise technology center series Implementation Study: Dell IT Scales Supply Chain Management with Oracle RAC 10g By Dave Jaffe, Ph.D. Todd Muirhead Tiong Tey Raveendra Avutu T When the expensive proprietary servers running the Dell supply chain management systems had reached their limits, the Dell IT group migrated to cost-effective, standards-based Dell ™ PowerEdge™ servers running Oracle® Real Application Clusters 10g. This architecture helped enhance database performance while providing scalability for future growth. tiple locations around the world. Using the same processes worldwide manufacturing operations, including the for disaster recovery, backup, and monitoring across all Dell operations enables Dell IT to take advantage of a cost- delivery of computers, accessories, parts, and supplies. These effective and readily supported deployment model. This systems must be designed for reliability and cost-effective scal- Database implemented this type of system for Dell operations at mul- systems handle key business functions that support efficient Dell inventory management model and fast, direct Related Categories: he Dell supply chain management (SCM) database article describes how Dell IT migrated its critical SCM appli- ability: a failure can cost thousands of dollars per minute in cations from proprietary UNIX-based servers to industry- factory downtime, and the SCM systems must be able to...

Words: 2272 - Pages: 10

Implementation of Supply Chain

... system, in this case, involves the movement of goods from the suppliers or warehouse while outbound systems involve the movement of produced goods from the end production chain to the end user of a given product. Many organizations have in recent years embraced various concepts in their supply chain management with the aim of increasing profit share and competitive advantage. Studies have shown a significant increase in company performances if their trading partners can mutually assess their expected consumer demands and plan their supply chain effectively. An evident example is the 1993 efficient consumer response (ECR) which was a study conducted by grocery industries to assess their supply chain systems. This study estimated that about $30 billion could be saved every year which is about 11 percent of the entire supply chain cost if the suppliers, distributors in the supply chain could incorporate technology in their work to deliver products (Taylor, 2010). The use of technology will ensure efficient delivery of products to the consumers hence ensuring high consumer satisfaction levels and increased profitability. Technology in the distribution of dry foods will reduce the delivery days of goods. Furthermore, rather than serving as a single part of the organization strategy, it gives organization ability to change or alter the flow of resources and value through the entire supply chain and management system. Subject of course project The broadest scope of supply......

Words: 2861 - Pages: 12

Supply Chain Management Study Guide

... phase – 3rd phase here the company starts to invest heavily in the development effort and builds and evaluates prototypes line balancing – technique used in developing product-based layouts, as would be found in a production line or group technology produced in large enough volumes to justify keeping a finished goods inventory. assemble to order – products that are customized only at the very end of the manufacturing process. customization within the supply chain product layout – a type of layout where resources are arranged sequentially according to the steps required to make a product. cellular and functional layouts – a type of layout where resources are physically grouped by fuction. Cellular is used in group technology settings; resources are physically arranged according to the dominant flow of activities for the product life. batch process, job shop, assembly line, FMS – manufacturing process where items are moved through the different manufacturing steps in groups or batches. Job shop is process used to make a wide variety of highly customized products in quantities as small as one and are characterized by general purpose equip and workers who are broadly skilled. Assembly line is a process used to produce a narrow range of standard items with identical or highly similar designs. FMS flexible manu. Systems are highly automated batch processes that can reduce the cost of making groups of similar products.manufacturing process decision – product process matrix takt...

Words: 1038 - Pages: 5

Supply Chain Management

...Dell’s Supply Chain Management Strategy Build-to-order model, Dell, Direct model, PC Manufacturing, SCM, Supply Chain Case Study Abstract The focus of this case study is the supply chain management practices of Dell. Dell has been following its unique ‘direct build-to-order’ sales model for more than 20 years. Customers can plan their own configuration and place orders directly with the company via the phone or its Web site. Over the years, Dell’s supply chain efficiencies and direct sales gave it a competitive advantage. Can Dell regain its market leader position from HP? In 2006 however, Dell faced several problems. Many customers complained about long delays in supplies. Recall of Sony battery cells in its laptops brought undesirable media hype to the company. Increasing discontent of customers led to a slowdown in sales. Consequently, Dell lost its market leadership to Hewlett-Packard Co. (HP). Industry analysts felt that, with Dell’s competitors also improving their supply chains and matching Dell’s direct model, the company had been losing its competitive edge. Dell will have to bear additional costs with its foray into retail distribution thereby minimizing its cost advantage. Besides, profit margins of Dell will drop further since it will have to offer incentives to compete with HP in retail stores. Though Dell spruced up its product design and range but Apple is clearly far ahead of it. Many experts feel that such new initiatives will only distract Dell from...

Words: 2572 - Pages: 11