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.