Design And Application Of Highway Toll System Database Based On Oracle

This article mainly discusses the database design based on Oracle and problems of data protection. It based on the theory of database design.First, the article present background of the engineering project, meaning of research, related theory of database and method of database design. The Barker method adopted by the article is a kind of waterfall method and the database is designed by seven phases as strategy, analysis, design, construct, document, transplant and product. The article primarily dissertates the phases of analysis and design. The database is designed with Conceptual Information Model, Logical Data Model and Physical Data Model. A strong emphasis is laid on the physical design of database. The physical design is composed of tablespace layout, partition, cluster design, index design and view. In this sect index design is discussed emphatically. The article expatiates the characteristic, use condition of different indexes detailedly and effect of different indexes is compared by practical data. In this article, I also discussed the index scan type, index rebuild and index watch, which are part of index design. In addition, the article discussed the Oracle Text technology, which is used in index design.The article discusses the related question of data protection on the basis of accomplish of database design. The data protection system is composed of security management, data archiving, backup and recovery. It discusses in detail the database security, audit, the methods of data archiving and the methods of data backup&recovery.Finally, at the end of the article, it discusses Null, Datetime and LOB data type. This three special data type are used in the database design.