Page 173 - Open Soource Technologies 304.indd

Unit 7: Multidimensional Arrays

$difference = array_diff($first, $second); Notes

print_r($difference);

Array ( [0] => 1 [2] => 3 )

Designing a Single-Server, Multidimensional Database

o implement a multidimensional database, first you install Analytic Services, and then
you design and create an application and databases. You analyze data sources and
Tdefine requirements very carefully and then decide whether a single-server approach
or a partitioned, distributed approach best serves your needs.
Using a case study, this provides an overview of the database planning process and discusses
working rules that you can follow to design a single-server, multidimensional database
solution for your organization.
Process for Designing a Database
As illustrated in The Database Design Cycle, designing an application is a cyclic process that
moves from a planning stage to a verification stage.

Figure: The Database Design Cycle

The database design process includes the following basic steps:
1. Analyze business needs and design a plan.
The application and database that you create must satisfy the information needs of your
users and your organization. Therefore, you identify source data, define user information
access needs, review security considerations, and design a database model.
Contd...

LOVELY PROFESSIONAL UNIVERSITY 167