Carnegie Mellon University
15-826 Multimedia Databases and Data Mining
Fall 2013 - 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, 1:30-2:50, on Tu 10/22 (as announced).
• Extra office hours by instructor:
• Wed 10/16, 12noon-1pm (and the usual, 2-3pm)
• Thu 10/17, 4-5pm
  
• Mo 10/21, 12noon-1pm

Notice:

Required text

• [MM Textbook] C. Faloutsos Searching Multimedia Databases by Content, Kluwer Academic Press, 1996. Evaluation draft (internal to CMU -  pdf)

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

1. Foils:

• From the course schedule, all the foils, up to and including  the lecture of '220_text2.pdf'. Notice that the file names for the foils are numbered in increasing order. As we said, foils marked with the string 'optional' in a yellow diamond, are excluded.
  

2. Multimedia Indexing

• Primary key access methods
  • Litwin, W., (1980), Linear Hashing: A New Tool for File and Table Addressing, VLDB, Montreal, Canada, 1980.
  • MM Textbook, chapters 2-3
• 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.
  • Ibrahim Kamel and Christos Faloutsos, Hilbert R-tree: An improved R-tree using fractals Proc. of VLDB Conference, Santiago, Chile, Sept. 12-15, 1994, pp. 500-509. ( gzipped postscript)
  • 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)
•  Text: full text scanning, inversion, signature files
  
• MM-textbook, chapter 6.
  

Last modified: Oct. 14, 201, by Christos Faloutsos