Apple Database Management

There are different types of files in Apple’s Databases such as employee files, Customer files, Store Region files, Product files, Sales files.

Apple has a self developed database that manages and interrelates data within files. As an example, from sales to customers, or employees to store and sales.

Apple develops its own database through its developers. It is in constant renovation to increase the understanding of the information to their employees and managers.

Apple Database Administrators and Developers are responsible for their database information

Managers get daily reports on sales and services as well as customer’s feedback. They get it through an intranet system available only to managers. After their review, this information is made available on a daily meeting to employees also.

Reports such as sales, services (technical support, personal training, sales experience). Overall company’s averages to compare against store’s numbers.

OLAP is used to provide live analytical data for Managers to view the sales in the Store. Comparing these numbers to a sales forecast and see if the numbers are above or below the margin.

A data warehouse is used to store all the data from sales, employees, sales are stored.

Data Marts are used for all Departments in Apple. Such as Sales, Marketing, Production, Service, etc. Data marts is what constitutes Apple’s database as a whole, by combining all its information together into a Data Mart.

As in OLAP, Apple uses data mining to retrieve analytical information for managers as well as employees to increase the sales by forecasting them or by increasing customer satisfaction by customer reviews.

The team responsible for data mining is the Database Administration at Apple, and the software used for it is uniquely developed by and for Apple.

Apple Inc

Apple is one the greatest companies in the world. It was incorporated in April 3, 1977. Apple has re-invented the oprations management system. Apple represents the face of the music, phone, and computing industry. The technology advancement and CEO’s decisionmaking keeps Apple in the frontline of the market. Apple innovative designs has opened international doorways to sell their computers and devices globally.

Introduction

Apple Inc. is an American multinational corporation that designs and manufactures consumer electronics and computer software products. The company's best-known hardware products include Macintosh computers, the iPod and the iPhone. Apple software includes the Mac OS X operating system, the iTunes media browser, the iLife suite of multimedia and creativity software, the iWork suite of productivity software, Final Cut Studio, a suite of professional audio and film-industry software products, and Logic Studio, a suite of audio tools. The company operates more than 250 retail stores in nine countries and an online store where hardware and software products are sold.

Established in Cupertino, California on April 1, 1976 and incorporated January 3, 1977,the company was called Apple Computer, Inc. for its first 30 years, but dropped the word "Computer" on January 9, 2007 to reflect the company's ongoing expansion into the consumer electronics market in addition to its traditional focus on personal computers. Apple has about 35,000 employees worldwide and had worldwide annual sales of US$32.48 billion in its fiscal year ending September 29, 2008.For reasons as various as its philosophy of comprehensive aesthetic design to its distinctive advertising campaigns, Apple has established a unique reputation in the consumer electronics industry. This includes a customer base that is devoted to the company and its brand, particularly in the United States. Fortune magazine named Apple the most admired company in the United States in 2008 and in the world in 2009.

Steven Jobs

Steven Paul Jobs (born February 24, 1955) is an American businessman, co-founder and CEO of Apple Inc. and former CEO of Pixar Animation Studios.


In the late 1970s, Jobs, with Apple co-founder Steve Wozniak, created one of the first commercially successful personal computers. In the early 1980s, Jobs was among the first to see the commercial potential of the mouse-driven graphical user interface. After losing a power struggle with the board of directors in 1985, Jobs resigned from Apple and founded NeXT, a computer platform development company specializing in the higher education and business markets. NeXT's subsequent 1997 buyout by Apple Computer Inc. brought Jobs back to the company he co-founded, and he has served as its CEO since then. Steve Jobs was listed as Fortune Magazine's Most Powerful Businessman of 2007.


In 1986, he acquired the computer graphics division of Lucasfilm Ltd which was spun off as Pixar Animation Studios. He remained CEO and majority shareholder until its acquisition by the Walt Disney Company in 2006. Jobs is currently a member of Walt Disney Company's Board of Directors. Jobs' history in business has contributed greatly to the myths of the idiosyncratic, individualistic Silicon Valley entrepreneur, emphasizing the importance of design and understanding the crucial role aesthetics play in public appeal. His work driving forward the development of products that are both functional and elegant has earned him a devoted following.In mid-January 2009, Jobs took a 5 month leave of absence from Apple to undergo a liver transplant.

Assignment # 3

For your company, which of the 3 generic business strategies is used? If differentiation, then how do they differentiate their services/products?

The Apple Corporation uses the differentiation strategy. The differentiation strategy is used by Apple because the type of product and products that Apple produces are different that their competitors. An example in the IPod. An IPod is an example of a MP3 player, but has certain characteristics that make it different than an everyday MP3 player. Apple as a whole uses differentiation in many different ways. The first example as stated earlier is the IPod. Secondly is the IPhone which is similar to other phones of the market, but offers different features that sets it apart from the competitors. Apple also makes laptops that are different that an everyday laptop because of the features once again. I feel that the differentiation method is very productive because people are looking for things that set themselves apart from competition. This is why the Apple Company is so lucrative.

For your industry, estimate how much power each of the 5 forces has (suppliers include their employees and suppliers of technology). How do they reduce the buyer and supplier power? How do they create switching costs and entry barriers?

Buyer Power - Medium

Apple has competitive advantages on their products such as the iPod - iTunes or the Mac and One to One Training. Things that Apple has to try and reduce Buyer Power and increase Supplier Power.

Supplier Power - Medium

*CORRECTED*

Apple, as read in an article on 'How Apple Does It,' Steve Jobs, Apple's CEO, has been always fanatic of high customer experience. Which brings us to the point that Apple has always found ways to reduce supplier power by seeing who makes the next iPod with the highest standards in designs and technology and above all, secrecy. Because of the requests that Apple has, I believe Apple must have medium Supplier Power, Although it tries to keep it low, there will be a small hand-full of manufacturers that assemble the next revolutionary product Apple comes up with.

Threat of Substitute Products or Services - High

There are many products that Apple has that there’s an alternative product for. Nevertheless, Apple has managed to create a competitive advantage into merging the iPod with the music store which is not offered as a whole in the market. Zune HD is a substitute with music store rasphody, but the interface and reputation of the iPod has given Apple that competitive advantage.

Threat of New Entrants - Low

There is a very low possibility for a competitor to enter the market that Apple is in. The entry barriers are the competitive advantages mentioned before as well as the loyalty that the customers have towards Apple.

Rivalry Among Existing Competitors - High

As seen on TV. There are many ads on “I’m a Mac and I’m a PC,” which is informative for new customers to enter the world of Mac and commercials of PC’s such as “You find it, you keep it” campaign to find a laptop PC on a budget. So there is definitely rivalry on each side of the market. It is competitive advantages that keep each other within the industry.

Apple creates switching costs by making all their products user friendly. Even then, it offers programs like One to One training to help customers in their first steps on how to use a Mac. Cutting edge technology in Apple’s devices are switching costs that enable the customer to think twice before purchasing a cheaper media player.With this in mind, Apple has not only created a switching cost but also entry barriers. Since a new competitor will be low likely to provide a customer the services that a present company already offers and does well.

Read Chapter 2. For your company, what major business initiatives are used or being considered? What software is used? Are they top-line or bottom-line initiatives?

Apple uses an E-collaboration style of business initiative, they get everyone involved from each department to work on a product. Their focus is to be innovative so their competitive strategy is differentiation, because of that they are a top- line initiative.

What type of IT organization is used? What philosophical approach do they use.

The philosophical approach they use is knowledge. They have the technology to learn their customers inside and out in order to satisfy the demand of there customers needs. The type of IT that my company uses is e-collaboration.

Apple Prepares for iphone Launch in China Fall 2009

10/07/09
By Santiago A. Mirabal

Apple Inc. makes its Iphones in China, so it was a matter of time before the Iphone would make its way to the Chinese market.
On August 28th Apple announced that it made a deal with China Unicom, the country’s second largest mobile service provider. With this new partnership, the Iphone will be available to hundreds of millions of consumers in mainland China opening a new market.
China has 700 millions mobile devices currently in use. It's the country with the most mobile phones in service on the planet.
Now the question that most skeptics are asking is whether China Unicom has the Marketing and Customer Service skills to generate Iphone sells. The company has 140 million customers while the market leader has 500 million. While the Iphone comes with a marketing halo, it is up to China Unicom to harness that and make it a successful launch.

Source information courtesy of Times Magazine

Time Article

Assignment # 4

1) In the E-Administrator case study, what were the problems with the old system? How were they solved?

2) Is E-Administrator an Intranet? Why? How could it become an Extranet?

3) For your company, answer the following as part of the business strategy post on your blog:

a) What kinds of e-Commerce are used?

b) What types of internet business models are used?

c) What type of marketing mix does it adopt?

d) What payments systems are used?

The case study is also available on Unit 9 E-Business on the course materials.
Attachments
Submission:
1) In the E-administrator case study, what were the problems with the old system? How were they solved?
Problems:
• The system consisted of some input screen and output report, and was mostly used to print mailing labels.
• The system had very poor interface and did not provide for ad-hoe reporting
• The system did not provide with the ability to monitor student progress
• Coordinators couldn’t indentify and follow up on students with missing prerequisite courses, and failing academic requirements
Solution:
They created a Program using widely available technologies, like Visual Inderv and JavaScript that was able to support data entry, do analysis, and generate reports. They use Microsoft web servers using a single PC with its own IP for their PWS. The system was built with existing hardware, software, and labor so it was done in house so no additional cost.
2) Is E-Administrator an Intranet? Why? How could it become an Extranet?
• An E-Administrator is an intranet. An E-Administrator is a way the company’s convert all of their paper records into electronic records. It is all of the mechanisms that convert one to the other. An Intranet is a secure network that allows people who have access to view whatever information is available. This is similar to a group of people who work for a business and can see all the records. Therefore, and E-Administrator is and Intranet. This could become and extranet in only a few cases. If it is information that is about health records or other personal information, it would not be wise to use an E-Administrator as an extranet. When it comes to information that could be passed along to vendors and others who can use the information it would be a valuable tool to have.


3) For your company, answer the following as part of the business strategy post on your blog:
a) What kinds of e-Commerce are used?
• Apple sells their products to Customers, Businesses and even Government.
• B2C
• B2B
• B2G
b) What types of internet business models are used?
• Apple uses Business to Consumer, Business to Business on their internet model.
c) What type of marketing mix does it adopt?
• Online Ads often seen in CNN, NY Times, and Tech Blogs.
d) What payments systems are used?
• Apple accepts Credit/Debit Card, Gift Cards, Bill me Later on their website.