COMM 437 Database Technology - UBC Sauder PDF

Comm 437 – Database Technology COMM 437 Database Technology  Comm 437 – Database Technology Agenda for Today Introductions Course outline and information Course format Assessment Expectations Course Project ...

Comm 437 – Database Technology COMM 437 Database Technology  Comm 437 – Database Technology Agenda for Today Introductions Course outline and information Course format Assessment Expectations Course Project  Comm 437 – Database Technology Databases are EVERYWHERE Databases are behind: UBC’s operation (Registration, course catalog, grades, alumni, parking, tuition, payments….) Websites, mobile apps, financial systems, etc. No business can survive without database technology, including the class we are having now Lots of innovation happening  Comm 437 – Database Technology Demand for Data Skills All types of data people (data scientists, analysts, programmers, visualizers, reporting experts… ) are in demand New and unsolved opportunities to understand data are continuously emerging It takes perseverance to get your first data job, but salaries can greatly vary after entry level and quickly reward talent  Comm 437 – Database Technology SQL & Its Many Uses This course only covers a small portion of the places that SQL (Structured Query Language) can be used, it doesn’t cover examples like: Moving data between systems Explaining reporting and data quality issues Evaluating and selecting technologies Understanding new database technologies Building new technology / digital products Etc…  Comm 437 – Database Technology Learning Objectives Communicate with non-technical Develop conceptual data models using entity- colleagues relationship diagrams Communicate with technical Develop relational schemas from entity- database programmers and relationship diagrams colleagues Create and manipulate a database using SQL in Access data yourself, understand an optimal way what is happening “behind the scenes” in complex databases Explain emerging database concepts such as Awareness of the innovations and NoSQL, big data other approaches to data, especially as data volumes grow Overall Objective: Be a Power User of database  Comm 437 – Database Technology About the Course - Syllabus -  Comm Com 437437 – DatabaseTechnology_MJ – Database Technology PulseClick Checkto edit Master title style Answer the poll: Are you awake? a) Yes b) No c) Not sure  Comm 437 – Database Technology Overview of Database Technology Get to know your classmates Introduce yourself (5min) Your name How much you know about database What you did during the summer, etc. Share how you store your music data such as artist names and song titles (On your phone or computer) Find out if it’s easy to share music data from one person to another  Comm 437 – Database Technology Data Storage Before Computers Images (picture Alphabet (from sounds writing) on stone on not pictures) – walls of caves cuneiform – clay tablets Quipu - assembly of colored knotted cotton cords used by the ancient Inca as a data storage device. Cord color, manner of connection, relative placement, cord spacing, the types and placement of knots on individual cords, are elements of the recording code. Old paper-based records & filing systems are moving to databases: medical records, construction and building designs/documents, libraries  Comm 437 – Database Technology Old Data Storage Devices  Comm 437 – Database Technology Old Data Storage Devices  Comm 437 – Database Technology Overview of Database Technology File processing systems  -> Database Technology ☺ Program-data dependence -> Program-data independence Duplication of data -> Planned data redundancy Limited data sharing -> Improved data sharing Lengthy development times -> Improved productivity of application development Excessive program maintenance -> Reduced program maintenance  Comm 437 – Database Technology About the Course What is the difference between Data and Information? This Photo by Unknown Author is licensed under CC BY  Comm 437 – Database Technology About the Course Data: Raw facts concerning objects, people, and events, can be text, images, audio, or video Information: Data processed in such a way as to make it meaningful (data + meaning = information)  Comm 437 – Database Technology About the Course https://web.stanford.edu/group/sdgc/cgi-bin/ycisl/?p=4927  Comm 437 – Database Technology The Information Value Chain https://internetofwater.org/  Comm 437 – Database Technology About the Course Database: an organized UBC student records collection of logically UBC payroll records related data Carnegie Mellon’s Database of Database technology: tools Databases Project https//:dbdb.io and methods used to create, maintain, and Popularity ranking of database provide controlled access to management systems https://db- databases engines.com/en/ranking  Comm 437 – Database Technology Overview of Database Technology System Development Life Cycle Database Development Activities Identify Project Enterprise Initiate and Plan Modeling Conceptual Analyze Data Modeling Logical Logical Design DB Design Physical DB Physical Design Design/Creation DB Implementation Implementation DB Maintenance Maintenance  Comm 437 – Database Technology Overview of Database Technology Enterprise Data Modeling Enterprise Modeling The first step in database development, in which the scope Conceptual and general contents of organizational databases are Data Modeling specified. Logical DB Design A model which includes: Physical DB Overall range of organizational databases Design/Creation General contents of organizational databases DB Implementation Built as part of IS planning for the organization and not the DB design of a particular database Maintenance One part of an organization’s overall information systems architecture (comm436, comm438)  Comm 437 – Database Technology Overview of Database Technology Conceptual Database Modeling Enterprise Determine user requirements Modeling Determine business rules Conceptual Data Modeling Build conceptual data model Logical Outcome is an entity-relationship diagram DB Design Physical DB Design/Creation Please answer the poll: how familiar are you with ERD? DB A. Very familiar Implementation B. Somewhat familiar DB Maintenance C. Somewhat unfamiliar D. I have no clue  Comm 437 – Database Technology Overview of Database Technology Logical Database Design Enterprise Select logical database model Modeling Conceptual Commit to a database alternative (the relational Data Modeling database is the focus of our course) Logical DB Design Map Entity-Relationship Diagrams Physical DB Design/Creation Normalize data structures DB Specify business rules Implementation DB Outcome is a relational schema Maintenance  Comm 437 – Database Technology Overview of Database Technology Logical Database Design Enterprise Modeling Conceptual Data Modeling Please answer the poll, how familiar are you with Logical DB Design logical design? Physical DB Design/Creation A. Very familiar DB Implementation B. Somewhat familiar DB C. Somewhat unfamiliar Maintenance D. I have no clue  Comm 437 – Database Technology Overview of Database Technology Physical Database Design Enterprise Select DBMS Modeling Conceptual Data Modeling Select storage devices Logical DB Design Determine access methods Physical DB Design/Creation Design files and indexes DB Implementation Determine database distribution DB Maintenance Specify update strategies  Comm 437 – Database Technology Overview of Database Technology Database implementation Enterprise Modeling Code and test database processing programs Conceptual Complete documentation Data Modeling Logical Install database and convert data DB Design Physical DB Design/Creation DB Implementation DB Maintenance  Comm 437 – Database Technology Overview of Database Technology Database Maintenance Enterprise Analyze database and applications to ensure evolving Modeling Conceptual information requirements are being met Data Modeling Tune database for improved performance Logical DB Design Fix errors Physical DB Design/Creation Provide data recovery when needed DB Implementation DB Maintenance  Comm 437 – Database Technology Overview of Database Technology Last but not least, database uses Data queries with Structured Query Language (SQL) Emerging database technologies Please answer the poll, how familiar are you with SQL? A. Very familiar B. Somewhat familiar C. Somewhat unfamiliar D. I have no clue  Comm 437 – Database Technology A fun journey in front of us!