HB 337 1st Edition Lecture 2Today’s Lecture - Electronic Data Processing (EDP)- Database Electronic Data Processing (EDP) - Input -> Memory -> Process -> Output Advantages of EDP1. Speed2. Reliability3. Accuracy4. Retention5. Control Signals- Digital vs. Analog o Digital is on/ofo Analog is adjustable o Computers can only recognize digital o Human voice is an analog signal (robot, monotonous voice would be digital)Database - Database – A collection of interrelated data, collection of bits - Start with 1’s and 0’s, these are called bitsThese notes represent a detailed interpretation of the professor’s lecture. GradeBuddy is best used as a supplement to your own notes, not as a substitute.- 8 bits = bite - Bunch of characters or bites are called a Field- A bunch of fields are called a record- A bunch of records are called a file- A bunch of files are called a database - DEF – an application for rapidly storing and retrieving dataFlat Files – Text Files that have no structured interrelationship 4 Types of Databases1. Hierarchical2. Network3. Relational4. Object-oriented Hierarchical Database - Parent/Child relationship among data- Starts at top, moves downward Network Database - Have circular, less ordered relationships- Not used very much todayRelational Database- Most common database today- Organize in tables- Flexible Object oriented database - New form of database - Multimedia and graphic-based data Linking Tables- 2 types of keys- Primary Key – unique identifier- Foreign Key – Connector - Combines finals, record, and enable users to manage data Data Extraction- Structured Query Language (SQL) – A query format providing instructions for building and modifying the structure of a database or for modifying data stored in tables Data Storage- Data Warehouse – massive collection of enterprise data- Data mart- limited to a single division or line of business or functional area- Data cube – data segmentation for intense application analysisData Mining- Process of finding relationship in datao Profilingo Clusteringo
View Full Document