ITEC 610: Database Analysis of Zillow.com from a Data Analyst View

This report provides a database analysis of Zillow.com from a data analyst's perspective, examining its structure and the technologies used. Zillow's database, containing over 100 million homes, incorporates data from various sources, including county records and rental listings. The report details Zillow's technological evolution, highlighting its use of R language for predictive modeling, and its transition to C++ and Java for code implementation. It discusses Zillow's adoption of Amazon Kinesis for efficient data streaming and Microsoft SQL Server as its primary data store, with expansion to Redis. The report also explores Zillow's application of machine learning algorithms, such as random forests and decision trees, and its potential use of Spark. It concludes by emphasizing Zillow's goal to be the largest and most trusted real estate marketplace and its use of AI for data cleaning and inference, while also mentioning its competitors.