• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 2. Basic Data Analysis Technique... > Working with Relational and Multidim...

Working with Relational and Multidimensional Data

Data appears not only in data lists, but also in tables, groups of records separated by characters (such as a comma), and so on. When a group of data records (for example a single data list, a data table, or a file of character-separated data values) exists on its own without relying on another group of data records, the data is said to be nonrelational. When a group of records relies on other groups of records for complete, detailed business facts, the data is known as relational. Relationships are usually defined on a one-record-to-one-record basis or on a one-record-to-many-records basis. (These relationships are also known as one-to-one relationships and one-to-many relationships.)

In the terms of data analysis, multidimensional data is different from relational data. The concepts used in working with relational data are vastly different from those used to work with multidimensional data. While relational data is usually stored in a file-based or server-based database management system, multidimensional data usually resides in an online storage location such as a data warehouse, a central repository for capturing large amounts of data records.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint