专英课件Chapter12.pptVIP

QUESTIONS What are the 5 parts to a DBMS? What does the data dictionary do? What is batch processing ? What is real time processing? What is key field? How is data organized? What is data? What is a database? What is secondary storage ? How is data organized in a table? What is the 2 ways to view data What is the logical view? What is the physical view? What are the five kinds of databases? What is a data warehouse ? What is data mining ? * No pre-determined access paths – Data stored in a collection of columns and rows called a table, or a relation Tables may be electronically linked via a key field containing common data item Most valuable feature of relational database (Key Term): simplicity Entries can be easily added, deleted, and modified Common for microcomputers: Access, Paradox, dBASE, R: Base Widely used for mainframe and minicomputer systems * Includes additional or multiple dimensions called a hyper cube Data can be viewed as a cube having three or more sides and consisting of cells Each side is considered a dimension of the data Used for complex relationships between data Complex relationships between data can be represented and efficiently analyzed Conceptualization – provide users with an intuitive model in which complex data and relationships can be conceptualized Processing speed – analyzing and querying a large multidimensional database (Key Term) is faster * Objects – entities that contain both data and action that can be taken on that data Classes – are similar objects grouped together Entities – person, place, thing, or event that is to be described Attributes – the description of entities; similar to fields Methods – descriptions of how the data is to be manipulated * Five kinds of databases whether large or small, limited or widely accessible: Individual Company or shared Distributed databases (Key Term) Proprietary databases (Key Term) Web database * An individual database (Key Term) may be valuable if you are in sales. For example: W