Design And Implementation Of A Personal Address Book Management System Based On SQLite

Along with changing communications technology, the division of professionaldevelopment, interpersonal and social relations have shown a systematic, net and therefinement of mainstream trends, personal communications management system willbecome an important social role of individual information and potential, its greatinitiative and may even become the key factors related to success in one’s career.Everyone has a lot of contacts, a large number of contacts, so paper address bookcannot satisfy people’s increasing quantities of information carrier contacts theobjective needs of easy problems such as missing, inconvenient to find a paperaddress book unable to overcome weaknesses and bottlenecks. Electronic andinformation technology is increasingly deep and extensive practice in the field ofmanagement; management information system technology has been perfected andmatured the implementation level for personal address book management systemdesign and realization of technical safeguards. Management information system is agroup of people and computers, information collection, collation, processing, storage,transport, maintenance, and use of interactive systems. Management informationsystem is a constantly developing and improving the comprehensive interdisciplinaryfrontiers, raising the level of address book information automation management,comprehensive exploitation and scientific management of the planning and use ofinformation without delay. In view of this development the "personal address bookmanagement system."SQLite is an in-process library implements a self-contained, serverless,zero-configuration, transactional SQL database engine. SQLite is open source thecode, any businesses or individuals can be free to use, it reduces the cost ofapplication administration data, good portability, high performance, and reliable. SQLite is widely used at present, is an open source embedded relational database.SQLite compare with other SQL databases, and not a single server process, its biggestbenefit is that no network configuration is required, do not need to run. An SQLitedatabase is constituted by tables, indexes, triggers, and views, which are contained ina single file on disk. SQLite database permissions is only dependent on the file system,there is no concept of user accounts. SQLite is a database-level locking, but don’thave a Web server. All of these advantages, the development uses the SQLite databaseto store information, the main contribution of this paper is as follows:(1) Introduced the background and characteristics of SQLite databases, and itsdata management and architecture, analyses the five locking mechanism of SQLite.Through the study of API functions to master the main features of each API, read theSQLite source code and the documentation.(2) Complete personal communications management system based on SQLite,introduces the functional and performance requirements of the system and modulardesign structure flowchart and realize the basic function of data: query, insert, modify,and delete, and increased user login permissions, improve the safety and reliability ofthe system.Current information about SQLite is very scarce, especially with regard to itsimplementation of almost no information. This topic through source code analysis,producing accurate database and SQLite relational database theory and practical study.Throughout the paper, hoping more users understand and use SQLite databases,quality of experience its convenience, more and more products to use. This personaladdress book management system based on SQLite database development, facilitatesquick queries on the operation, strong system high security features, basically meetpeople’s daily needs for contact management systems, for the rapid advances inmodern information management service provides a point of view.