PPT-Collecting data from existing databases

Prof Andrew Stokes Department of Global Health BUSPH November 20 2018 Types of secondary data Survey data Vital statistics Administrative data Digital data Types of survey data National health surveillance. Allows us to do some computations in database and extract reduced data for further manipulation Relational Databases brPage 2br What do statisticians need to know about databases Understand the relevance of databases Have familiarity with the basic Collecting Data. Census. Survey. Experiment. Observational study. Interviews/ questionnaires. Data logger to record data over time. Survey Method. Advantages. Disadvantages. Observation. Systematic and mechanical. Part of the Scientific Process of Inquiry. Organizing & Interpreting Data. Before conducting an investigation, it is important to learn how to organize the data you have collected. . After you have organized the data, you need to make sense of what you have observed.. Unit Contents. Section A: Database Basics. Section B: Database Tools. Section C: Database Design. Section D: SQL. Section E: Big Data. Unit 10: Databases. 2. Section A: Database Basics . Operational and Analytical Databases. An . entity. is anything about which the organization wishes to store data. At your college or university, one entity would be the student.. STUDENTS. Student ID. Last Name. First Name. Phone Number. Section A: Database Basics. Section B: Database Tools. Section C: Database Design. Section D: SQL. Section E: Big Data. Unit 10: Databases. 2. Section A: Database Basics . Operational and Analytical Databases. Life Without Databases: Lists. Lists are often sufficient for simple tasks. Not appropriate for complex information. Multiple lists lead to. Data redundancy. Data inconsistency. Duplicate data. Sorting issues . Distinguish between the physical and logical views of . data.. Describe how data is organized: characters, fields, records, tables, and . databases.. Define key fields and how they are used to integrate data in a database.. and Wind Energy: Understanding . Risk. Belgrade, Wednesday, May . 27. th. , . 2015. Chamber of Commerce and Industry of . Serbia. Aleksandar . Vulovic | Project Development & Environmental . Specialist. Understanding field methods is critical for analysis even if you did not collect the data so you have an idea of what is possible (and what is not).. This is required even with modern remotely sensed data so we can “Ground Truth” the data. Understanding field methods is critical for analysis even if you did not collect the data so you have an idea of what is possible (and what is not).. This is required even with modern remotely sensed data so we can “Ground Truth” the data. UNIT IV. DATABASE. A database is a . computarised. library used to store and organize data in such a way that information can be retrieved easily via a variety of search criteria.. The development of databases to handle the vast amount of molecular biological data is a fundamental task of bioinformatics..  means the . banker.  who collects the . cheques. and bills on behalf of the customers. In other words, every crossed . cheque. is necessarily to be collected through any . bank. , which is known as . Possibilities and limitations. Aldo Jongejan. a.jongejan@amc.uva.nl. Aim of this lecture. Introduce you to . (. some. ) public . databases. This lecture will . make . you aware of the large and heterogeneous amounts of information that can be retrieved from public .