Carnegie Mellon University
15-826 Multimedia Databases and Data Mining
Fall 2014 - C. Faloutsos
Midterm Study Guide
Preliminaries - IMPORTANT
- No aids allowed, except
- a standard, 8'' x 11.5'' page with your notes - you may use both sides, and
- Pocket calculators: strongly recommended (logarithms)
- Photo id: please bring one
Additional info:
- Drill questions: are at http://www.cs.cmu.edu/~christos/courses/826-resources/REVIEW-QUESTIONS/
- Duration: 1h 20 minutes
- Place: in class, during class time, 3:00-4:20, on Tu 10/14 (as announced).
- Office hours by instructor:
- no office hours on Wed 10/8 (dentist appt. - apologies!)
- Thu 10/9, 2-2:30 (right before class)
- Fri 10/10, 11am-12noon
- Mo 10/13, 6pm-7pm
Notice:
Several of the links are internal to CMU.Required text
Recommended text
- Undergraduate DB textbook, for
those who took a db class too long ago:
- Raghu Ramakrishnan, Johannes Gehrke, "Database Management
Systems," McGraw-Hill 2002 (3rd ed).
MATERIAL TO BE EXAMINED
All the material covered, up to and including
the parts of lecture of Thu Oct. 9, 2014, that cover power laws. Specifically:
1. Foils:
- From the course schedule, all the
foils, up to and including the lecture of '190_powerLaws.pdf'.
Notice that
the file names for the foils are numbered in increasing order.
- Attention: also included: SQL, B-trees, hashing
- Excluded: all foils marked with the string 'optional' in a yellow diamond.
2. Multimedia Indexing
- Primary key access methods
- Secondary key and spatial access methods
- Jon Louis Bentley,
Multidimensional binary search trees used for associative
searching, Comm. of the ACM (CACM), Volume 18 ,
Issue 9, pp. 509-517, (September 1975)
- A. Guttman
R-Trees: a Dynamic Index Structure for Spatial
Searching, Proc. ACM SIGMOD, June 1984, pp. 47-57, Boston,
Mass.
- J. Orenstein,
Spatial Query Processing in an Object-Oriented Database
System, Proc. ACM SIGMOD, May, 1986, pp. 326-336,
Washington D.C.
- Roberto F. Santos Filho, Agma Traina, Caetano Traina Jr., and
Christos Faloutsos:
Similarity search without tears: the OMNI family of all-purpose
access methods ICDE, Heidelberg, Germany, April 2-6
2001.
- MM-Textbook, chapters 4 and 5.
- Fractals
- Christos Faloutsos and Ibrahim Kamel,
Beyond Uniformity and Independence: Analysis of R-trees Using the
Concept of Fractal Dimension, Proc. ACM
SIGACT-SIGMOD-SIGART PODS, May 1994, pp. 4-13, Minneapolis, MN.
(and
gzipped postscript)
- Alberto Belussi and Christos Faloutsos, Estimating
the Selectivity of Spatial Queries Using the `Correlation' Fractal
Dimension Proc. of VLDB, p. 299-310, 1995 (and
gzipped postscript )
- Power laws, lognormals etc: M. E. J. Newman, Power laws, Pareto distributions and Zipf's law Contemporary Physics 46, 323-351 (2005) (local pdf copy)
Last modified: Oct. 7, 2014, by Christos Faloutsos