Owens Corning Case

926 Words2 Pages
bulb-icon

Recommended: Question about transaction processing system

Owens Corning Case

1. Data Provisioning

OCF conceptualizes the principal IS production activities that produce value for the company as transaction processing, data provisioning, and information delivery.
Data provisioning manages the inventory of data and information, using relational database management systems and a data dictionary and data catalog. Transaction processing stores only the current data necessary to provide the status of current operations. Data provisioning receives, stores, and manages all validated transaction data from transaction processing. It also provides data back to transaction processing and information-to-information delivery when requested. Data dictionary and data catalog keep way of what data exists, where it is stored, what it means, and who has authority to access it. That helps data provisioning to protect the data and to provide access to data and information to those who need it.
Data provisioning stores the organizational structure regulations in tables in its database, so these regulations can be changed without any difficulties when management decides to modify the organization.
OCF created two relational databases to support data provisioning —one to support transaction processing and another to support information delivery.
They used for transaction processing technology IBM’s DB2 running on the mainframe, designed to process high transaction volumes fast. For the information delivery technology they used a TERADATA database machine - a combination of hardware and software that is optimized for answering information questions.
2. Data warehouse

The data warehouse is part of the data provisioning function. It could be described as a big depository. Data warehouse must provide interfaces that accept transaction data from different types of transaction processing systems and move them into the warehouse environment. During this process that data are tested and validated to assure that only high quality data are accepted.
On the output side of the data warehouse, there must be interfaces that allow a user to ask for data from the devices (PCs or terminals) that he typically use. The information in the warehouse must be structured, so that users can easily obtain answers to their questions.
OCF built data warehouse in 1987. They had selected a combination of IBM’s DB2 relational DBMS, SQL query language, and TERADATA database machine to support the data warehouse.
Few months later they built a data warehouse for the Residential and Commercial Insulation Products division that contained product data, sales data, and customer data. After some time they purchased a larger TERADATA machine and related software, which enabled them to expand this data warehouse to serve the other OCF divisions.

Show More
Related

  • Deere & Company Case Summary

    451 Words  | 1 Pages

    Deere & Company (Deere) has been experiencing a decrease in its profit margins for one of its aftermarket resale products, specifically the gatherer chain, over the past couple of years. Currently, the cost-price ratio is at 80% compared to last year’s 50%. The purchase cost for the gatherer chain has been steadily increasing, while the aftermarket price has been decreasing. Deere has been budgeting its price to match that of a major competitor, which has been causing the decrease. The company’s main supplier of its gatherer chain is Saunders Manufacturing, with which Deere has established a long term relationship. The owner of Saunders has a reputation of being a tough negotiator, and is someone who is known for not willing to share financial information about the company. However, the U.S. Department of Commerce has provided financial estimates in Saunders’ industry as follows: material spend, 42%; direct labor, 16%; indirect labor, 6%; Overhead, 20%. These percentages are helpful to Deere because they can be used in the negotiation process with Sanders. Since Sanders will not share any specific cost information, Deere is able to use these estimates as a way to justify Sanders reducing its prices. Using these estimates during the negotiations might also incentivize Sanders to provide accurate numbers for its specific manufacturing costs.

    Read More

  • albertsons

    752 Words  | 2 Pages

    Data warehouse developer is responsible for maintaining the practices of modeling, dimensional data, relational structures, and other reporting techniques. Candidates possessing an inner desire for long term employment opportunities in a team oriented fast paced wonderful environment. They need to be qualified with Information Systems, Computer Science and other related fields. It would be preferable to possess minimum of 7 years’ experience with warehouse design and analysis experience with complete knowledge about data modeling and warehouse methodologies. Job requirements for Albertsons Data warehouse developer jobs-

    Read More

  • Capital One Financial Corporation

    1052 Words  | 3 Pages

    In 1994, Jim Donehey was brought in to update Capital One’s IT system. His solution was to replace their aging mainframe computers with an object-based system, but this technology had never been used on such a large scale. In contrast, two-thirds of Capital One’s competitors outsourced their IT functions. Within 5 years the company had the world’s largest Oracle database with 23 terabytes of data – winning them the Gartner Group’s Excellence in Technology Award.

    Read More

  • Dupont Case

    1919 Words  | 4 Pages

    DuPont has been known for its low reliance on borrowings. In the 1970’s, the company had to assume a substantial portion of debt of Conoco, a newly acquired company. In 1983, the managers have to decide about the future optimal target debt ratio. Should the company continue to keep about 40% of its assets financed via debt or should it strive to lower its borrowings to 25%?

    Read More

  • Case 17 ? Johnson & Johnson

    490 Words  | 1 Pages

    1.     Diversity should provide greater alternatives and inputs into the decision process, but if diversity is blocked due to organizational infrastructures that do not allow the free flow of information, than the diversity goes unutilized. Johnson & Johnson (J&J) structured its company to insure the positive impact of diversity in regards to decision making through its creation of FrameworkS. Through Frameworks, the executive committee is partnered with a variety of managers from around the organization that concentrate on specific, unprogrammed organizational decisions. FrameworkS matches the problem with appropriate decision making method. In this approach, managers share the problem with others and engage the group in consensus to arrive at a final decision.

    Read More

  • Dow Corning Essay

    1046 Words  | 3 Pages

    A few challenges that Dow Corning Company face are that customers wanted lower prices for the products which was the “dilemma of the day, but question of survival in the global arena” (Dow Corning). Few customers did not want to pay for the additional service provided and only wanted the product itself, especially if they had prior knowledge of what and how the product worked. Due to this issue, Dow Corning Inc. had created a second brand, Xiameter – product only brand, which solely focused on providing consumers with the product without the service which operated via web. By producing the brand, Xiameter; they forecasted a risk, which would cause the Xiameter brand to cannibalize

    Read More

  • Corning Case Study

    847 Words  | 2 Pages

    Corning is a decentralized company currently being plagued by both external and internal threats, such as market uncertainty and poor communication and planning systems. The company has just recently started to recover from a large layoff in 1975, which reduced worker job confidence. The Houghton family has a preference for an informal workplace with an ambiguous leadership style that contradicts the formal and strict resource allocation system designed for their international strategy. The current strategy being employed differs with the owner’s philosophy, which is important, since the President must buy into the plan to understand and communicate it effectively. This miscommunication creates goal incongruence, which is exemplified by the confusion of corporate divisions about whether they should be focusing on reducing cost or being an innovator. Also, each officer has been described as having work that overlaps, showing no focus and a lack of efficiency. The fact that each of the over 150 businesses groups have to write up a resource allocation request and business strategy creates the issue of finding time to read each report.

    Read More

  • Oracle Databases

    1555 Words  | 4 Pages

    Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.

    Read More

  • Financial Analysis of Oracle Corp

    2599 Words  | 6 Pages

    In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.

    Read More

  • Merging Object Oriented Programming Ethics with Database Management Ethics

    977 Words  | 2 Pages

    The OODBMS is the product of merging object oriented programming ethics with database management ethics. Object oriented programming concepts such as encapsulation, polymorphism and inheritance are imposed as well as database management concepts such as the ACID properties (Atomicity, Consistency, Isolation and Durability) which show the way for system reliability, it also supports an ad hoc query language and secondary storage management systems, which is allocated for managing very large amounts of data. The Object Oriented Database program specially lists the following features as compulsory for a system to support before it can be called an OODBMS; Composite objects, Object uniqueness, Encapsulation, Types and Classes, Class or Type Hierarchies, Overriding, overloading and late binding, Computational fullness, Extensibility, Perseverance, Secondary storage management, Concurrency, Recuperation and an Ad Hoc Query capacity.

    Read More

  • Metadata: Finding the Information That You Need

    1215 Words  | 3 Pages

    In one of the big company, Informatica is that data integration software and services to the organisation that enable to get the advantage to compete with others. They basically based on the metadata to run the company. Furthermore, SAS, is the company that helps organisation anticipate business opportunities, empower action and drive impact. They create and manage the metadata and define access to control and manage users through a single environment. By doing this, a number of metadata are provided to import and export the metadata from a variety of sources. They also track change history to find out who made changes and when the changes took place. As the metadata stand for finding information easily, they create data items with descriptive labels to organise data items into folder and subfolder for users to find the informations. By creating table aliases to provide additional flexibility required for proper query generations, and they create predefined filter expressions so users can choose the appropriate result subset, creating prompted filters so users can dynamically select filter values when creati...

    Read More

  • Business Intelligence

    340 Words  | 1 Pages

    A data warehouse comprised of disparate data sources enables the “single version of truth” through shared data repositories and standards and also provides access to the data that will expand frequency and depth of data analysis. Due to these reasons, data warehouse is the foundation for business intelligence.

    Read More

  • Comparison Between Rdbms With Oodbms

    816 Words  | 2 Pages

    Nowadays most of the applications connected to a database use the relational standard but recently the Object Oriented Database Management System becomes more important and it is expected that many companies like DreamHome research the advantages of OODBMS and implement this solution.

    Read More

  • Brief History Of Databases

    1727 Words  | 4 Pages

    of multiple types of end users. The data is stored in one location so that they

    Read More

  • The Importance Of Database Management Systems

    1411 Words  | 3 Pages

    Data can be organized a specific way for each business to be able to get the best use. Employees can also access the system at the same time but in different ways. For example, the customer service team can pull up documents and keep track of complaints at the same time that the marketing team is in a

    Read More

More about Owens Corning Case

Open Document