Zillow Case Study Essay

Superior Essays
Introduction
In this case study, the business of Zillow.com in providing real estate information to all users to its website is explored, and the use of business intelligence by Zillow.com in its offering to customer, and the way it uses a data mart to market its new product, are discussed. In addition, this case study includes a discussion of various characteristics of information quality as seen from Zillow’s perspective, and how Zillow is using a data-driven website.

Analysis
Background of Zillow.com
Zillow.com is an online web-based real estate site helping homeonwers, buyers to find and share information about real estate and mortgages. It allows users to access information anonoyoumously and free of charge, using the kinds of tools
…show more content…
The database contains data and information related to the systems, including the details of the users and the transactions, while the DBMS creates, modifies, and delete data in the database, as well as maintaining access control and data security.
Zillow’s business is to provide information on real estate and mortgages. It recognizes that it needs to make its data accessible, scalable, reliable, and secure with high level of performance, and a relational database would provide the business advantages of meeting these needs, through increased flexibility, increased scalability and performance, reduced redundant information, increased information quality, and increased information security (Baltzan,
…show more content…
Although there is one physical copy of the data, mulitiple logical views could be created according to the needs of the individual users. In addition, users could save customized view of their choice, so that the next time they access the Zillow system they would save time by looking at only what matters to them. Second, the technical capability of the databases currently available enable exceptional scalability, allowing users and programs to perform computational demanding tasks and complex searches. Third, by recoding each piece of data only in one location and allowing data association through relational data tables, there is one single view of truth and data modification and deletion could be performed without risk of creating redundant out-of-date data.
Fourth, with a relational database, integrity contraints (both relational and business-critical) helps a company enforce business rules that ensures high information quality which provide better business decision support. Fifth, databases offer security features such as passworeds authentication, access level authorization. With cloud computing, the risk of data breach increases, so sound data governance policies and procedures help companies defend against information security threats (Baltzan,

Related Documents

  • Decent Essays

    The benefit of having a database is critical to organizations because it helps keep track of data for a long time and you can always return back check past…

    • 284 Words
    • 2 Pages
    Decent Essays
  • Decent Essays

    Policy-based management: SQL server has a feature called policy-based management which is used to define and also implement policies in SQL server. It is used if we want to apply any policy against a table or database and then checks whether the database or table satisfies with the given policy. If target database objects are not satisfied with the policies then either a trigger should be fired or we can enforce it so that an administrator will come to know that there is some policy violation. It will manage one or more instances of SQL server.…

    • 391 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Nt1320 Unit 2

    • 866 Words
    • 4 Pages

    These commands are used for updating, inserting, modifying, and querying the data within the database 10. By using SQL queries with any RDBMS, it is possible to create virtual tables, or dynamic views, whose contents materialize once documented. These views may typically be manipulated in the same way as a base table will be manipulated, through SQL SELECT queries. Materialized views, which area unit stored physically on a disk and refreshed at acceptable intervals or events, may also be used. 12.…

    • 866 Words
    • 4 Pages
    Improved Essays
  • Decent Essays

    Wgu Est1 Task 1

    • 270 Words
    • 2 Pages

    Task 1: Zillow is a worldwide company right now, it is not a traditional real estate company but a tech company. The chief from Zillow, Spencer Rascoff thinks “the real estate market is ripe for disruption”. Start from this perspective, he begin to develop Zillow, and “he wants Zillow to do for real estate agents what OpenTable did for restaurants. Zillow is a brand new creature in our society, it changes how real estate market at some point because Zillow have all the information that consumers should know. That being said, real estate agents can no longer be information provider, and they have to be real experts in the market.…

    • 270 Words
    • 2 Pages
    Decent Essays
  • Decent Essays

    Pt2520 Week 2 Assignment

    • 517 Words
    • 3 Pages

    This week we learned lots about the decomposition of our relations we are creating in the database as well how to make the relations into normal forms, which there are three normal forms. I learned that there can be data that is redundant and therefore not useful for the database. This data has no integrity and can be misplaced and even confuse how the data can be used and retrieved. This type of problem must be avoided. I had a hard time understanding how the breaking down of one relation into two or more would help keep all the data from being redundant.…

    • 517 Words
    • 3 Pages
    Decent Essays
  • Decent Essays

    Unit 10 D2

    • 502 Words
    • 3 Pages

    Task 10 (D1) Discuss how potential errors in the design and construction of a database can be avoided. One of the potential errors that can occur when creating a database is that field names and names can be spelt incorrectly due to human error this can be difficult to spot if the database is big the way of making sure that there are no naming errors is to make sure that every is checked regularly and more than twice to make sure that the chances of finding a spelling mistake is reduced. Using the wrong data type is another potential error that can occur when creating a database this can be troublesome as if there is a relationship created between the tables and the mistake is found and changed then the database wouldn’t allow you to change the field where the data type is incorrect without removing the relationship first so it will be made into a long process of removing the relationship between the tables changing the data types for each of the table before remaking the relationship between the tables again the way of preventing this is by looking at the field names for the database and then choosing the correct data type also perhaps getting the opinion of another person and rechecking that they are all correct before creating the relationship.…

    • 502 Words
    • 3 Pages
    Decent Essays
  • Improved Essays

    P1 Unit 6 Business

    • 462 Words
    • 2 Pages

    Data Confidentiality: When you keep important data it is important that the data doesn’t go out to the wrong hands. So if a business data is suddenly leaked online or maybe stolen, then this can result in a huge loss for the business and this can potentially put the business out of business. To overcome this problem, then you would need a good security program which can safeguard against any breach in confidentiality. Data Integrity: This is used to ensure that the most important data is secure and also makes sure that the data isn’t messed around with. If any of the data has been messed around with then this can result in major problems.…

    • 462 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    I found your home listed on the Zillow Make Me Move page as I was searching for homes that aren’t listed, but have the potential to be sold. I recently had a customer who sold their home for cash using Zillow’s Make Me Move listing. Not that there is a guarantee that someone will contact you to make an offer, but with the current market being a sellers’ market we are starting to see more “For sale by owner” and Zillow Make Me Move offers. I’m not a Realtor; I’m a licensed mortgage professional who has helped families finance their homes here in Kitsap County for over 14 years.…

    • 319 Words
    • 2 Pages
    Improved Essays
  • Improved Essays

    IT security threats and cryptography 7/A. P1: Explain the different security threats that can affect the IT systems of originations. 7/A.M1: Assess the impact that IT security threats can have on organization's IT systems and business whilst taking account of the principles of information security and legal requirements In today's society data is a very valuable thing companies have to take in to account how to protect that data from the threats, Threats is a way in which the data is vulnerable and therefore rules and regulations have been put in place to stop these potential threats for example all will have adhere to the principles of information security this is a way in which data is protected, I have been working for a start-up company…

    • 1332 Words
    • 6 Pages
    Improved Essays
  • Decent Essays

    The company that I choose was PNC bank. I think that the database that would be most beneficial would be a transactional database. A transactional database is a database management system (DBMS) that has the ability to roll back or undo a database transaction or operation if it is not completed appropriately.…

    • 208 Words
    • 1 Pages
    Decent Essays
  • Great Essays

    Case Study Assignment – I Campbellsville University MASSIVE DATABASE MASTERING - MASTERCARD INTERNATIONAL Various affiliations are endeavoring to address the open entryways and limit challenges related with "huge data." Industry masters gage that the total volume of data is increasing at general interims and most by a wide margin of new data being delivered is prepared to go spaces. MasterCard Universal (www.mastercard.com) is not any more impossible to miss to think about the issues identified with monstrous databases. MasterCard has amassed a data circulation focus that is more than 100-terabytes in size. Insiders expect that it will create to more than 1.8 petabytes.…

    • 933 Words
    • 4 Pages
    Great Essays
  • Great Essays

    Dataclear is a business data analytics company, based out of Baton Rouge, Louisiana. The company was founded in 1998 by Greg McNally, a graduate of UC Berkeley, with a PhD in computer science. McNally developed his skill working as a software developer for 15 years, “at Borland and Oracle” (Case Study, para.5). DataClear established itself in a market that was wide open and offered very rapid customer and profit growth. Within the first year of operation, the company’s sales hit $2.2 million (Case Study).…

    • 1259 Words
    • 6 Pages
    Great Essays
  • Decent Essays

    Information security policy is to protect the data and assets. We can apply policies to the users. What to access and what not to access. These security policies can protect the networks, computers, applications of the company.…

    • 342 Words
    • 2 Pages
    Decent Essays
  • Improved Essays

    Information systems can be processed with rapid speed and it allows the organization to be successful, effective and timely decision-making can take place with minimal errors. The decisions-making is based on the information we get from the stored data (Hoyt,…

    • 876 Words
    • 4 Pages
    Improved Essays
  • Superior Essays

    1.1 Describe the importance of developing relationships with customers Having a good rapport with your customers is extremely important for the success of any company. Having a solid relationship with your customers can help ensure that the business continues to progress and remain successful. A good way to develop a solid relationship with your customers is to reward loyalty, by simply sending a thank you note or a money off voucher can help to build and maintain brand loyalty, it also helps to introduce incentives such as a customer loyalty program as it will help to entice customers to return.…

    • 1142 Words
    • 5 Pages
    Superior Essays