Decision support system for real estate agency
Students Name: Leochko Oleh Vasylovych
Qualification Level: magister
Speciality: Systems and Methods of Decision Making
Institute: Institute of Computer Science and Information Technologies
Mode of Study: full
Academic Year: 2022-2023 н.р.
Language of Defence: ukrainian
Abstract: The concept of "real estate" was firstly formulated in Roman law due to the emergence of the general turnover of lands and other natural resources. At that time, this form of limited ownership was known as a servitude. Servitude included the following rights: to pass through the neighboring territory, to transport goods, to carry water from neighboring waterworks, to prop up the building against the wall of a neighbor, etc. A real estate agency is a commercial organization that assists in sale, purchase or rental of real estate by providing intermediary services between the owner who sells the property and the end buyer. Apart from this, the agency can also invest in the primary real estate market. The real estate market is usually considered as a set of its subjects` relations which contain transactions of purchase, sale, exchange, lease and others. As a result of such transactions real estate ownership or temporary ownership rights are transferred in exchange for financial or other assets. Study object: the process of renting, selling and buying of real estate. Scope of the research: methods, models and means of developing a decision support system for renting, selling and buying real estate. Goal of the research: creating software to manage the purchase, sale and rental of real estate. An analytical review of literature confirmed the relevance of system development and made it possible to highlight the features it needs. A system analysis of the application was determined the general goal, divided it into sub-goals and specified using a goal tree. An analytical hierarchy method was used to determine the type of system and showed that the best option is development of a decision support system. At the next stage, we worked on the system designing. An analysis of requirements and functions was carried out, categories of users were defined and, for a conceptual model of the system, UML diagrams was build. After the system analysis the importance of Big Data technologies for the designed system was described and three main algorithms used for processing big data were considered: logistic regression, linear regression, classification and regression trees. As a result of the work, we have a web application that is designed to improve the processes of buying, renting and selling real estate. All system users will be divided into three types: regular system guest, authorized user and system administrator. According to the role a user is provided with various functional opportunities. After first running of the web application user will see a main page of site with a filter where he can enter necessary characteristics for real estate objects, click on a search button and go to the classifieds page. If there are objects in the system database that contains entered requirements then they will be displayed on the user’s page. Otherwise, will be displayed a message with the text that unfortunately, such a property is not yet in the system database. In addition, a regular guest of the system will be able to view a page with information about a real estate agency and a page with information about a broker. Also, there are a section with information about the broker and a form in which a client can write a message to broker and start communication about the selected object on the advertisement page. If a user wants to submit any real estate sale ads to the system, then he needs to register and then log in. However, this is also not enough to make any changes in the application. Each ad will undergo two checks before being posted on the site. The first is an automated check by the system for the validity of data that would correspond to type of field in the database and its limitation. The second is a manual check by the system administrator. And only after passing them, an ad can be placed on the site. Besides, it is worth talking about the administrator separately, since he is a special user of the system who is given special privileges. He can create new users, create groups with users, add new ads, delete ads and allow other users to submit ads. Keywords: web application, decision support system, real estate agency, real estate, software product, purchase, sale, rent. References. 1. Voronin V.O., Lyantse E.V., Mamchin M.M. "Real Estate Market Analysis: Methodology and Principles of Modern Valuation": Monograph. - Lviv: Magnolia Publishing House.- Lviv, 2014. – p.304. 2. Shakhovska N.B., Lytvyn V.V. "Designing information systems" - Lviv: "Magnolia-2006". – p.380.