• Complex
  • Title
  • Keyword
  • Abstract
  • Scholars
  • Journal
  • ISSN
  • Conference
搜索

Author:

Guo, Xiaoyu (Guo, Xiaoyu.) | Liu, Haoran (Liu, Haoran.) | Xiao, Xiao (Xiao, Xiao.)

Indexed by:

EI Scopus

Abstract:

In contemporary community management, digital community management systems are of great importance. A database system for community management maintains the generated data and provides efficient and organized services to the residents. In this paper, a SQL-based community information management database system is developed, and the design and implementation of this community information management database are studied. The database stores and manages information about buildings, apartments, residents, parking lots, cars, equipment, resident feedback, etc. in the community. At the same time, this paper has also designed a relational model between entities, so that this paper can sort out the attribute relationships between entities, and then design SQL statements to query the data of the entered entities, to achieve an efficient data search. In addition, the paper also performs some manipulations of the developed database using SQL language which helps the residents and management people to maintain the community. To sum up, the database designed in this article can effectively store community data and play an important role in the normal operation of the community. © 2022 IEEE.

Keyword:

Database systems Information management Query processing

Author Community:

  • [ 1 ] [Guo, Xiaoyu]Jinan University, Guangzhou, China
  • [ 2 ] [Liu, Haoran]Beijing University of Technology, Beijing, China
  • [ 3 ] [Xiao, Xiao]Beijing Jiaotong University, Beijing, China

Reprint Author's Address:

Email:

Show more details

Related Keywords:

Related Article:

Source :

Year: 2022

Page: 232-237

Language: English

Cited Count:

WoS CC Cited Count:

SCOPUS Cited Count:

ESI Highly Cited Papers on the List: 0 Unfold All

WanFang Cited Count:

Chinese Cited Count:

30 Days PV: 2

Affiliated Colleges:

Online/Total:685/10645938
Address:BJUT Library(100 Pingleyuan,Chaoyang District,Beijing 100124, China Post Code:100124) Contact Us:010-67392185
Copyright:BJUT Library Technical Support:Beijing Aegean Software Co., Ltd.