文档介绍:Computer Concepts 2014 Chapter 11 Databases Chapter 11: Databases 2 11 Chapter Contents ? Section A: File and Database Concepts ? Section B: Data Management Tools ? Section C: Database Design ? Section D: SQL ? Section E: Database Security 2 Chapter 11: Databases 3 11 Section A: File and Database Concepts 3 Chapter 11: Databases 4 11 Database Basics ? A database is a collection of information ? Typically stored puter files ? The tasks associated with creating, maintaining, and accessing the information in databases are referred to as data management, file management, or database management 4 Chapter 11: Databases 5 11 Database Basics ? Databases can be used in a variety of ways ? Collect and store data ? Update data ? Organize and output data ? Distribute data ? Find data ? Analyze data 5 Chapter 11: Databases 6 11 Database Basics ? Data mining refers to the process of analyzing existing database information to discover previously unknown and potentially useful information, including relationships and patterns ? Data warehouse ? Predictive analytics 6 Chapter 11: Databases 7 11 Database Basics ? OLAP (online analytical processing) allows decision makers to quickly get answers plex queries ? Executive dashboard software ? Big data 7 Chapter 11: Databases 8 11 Database Models ? An unstructured file has a unique structure and contains different kinds of data ? A structured file uses a uniform format to store data ? The underlying structure of a database is referred to as a database model 8 Chapter 11: Databases 9 11 Database Models ? The simplest model for storing data is a flat file that consists of a single, two-dimensional table of data elements 9 Chapter 11: Databases 10 11 Database Models ? A field contains the smallest unit of meaningful information ? Each field has a unique field name ? Variable-length field vs. fixed-length field 10