1 / 23

IT&F : Databases

IT&F : Databases. Stefano Grazioli. Debriefing. Still doing well Lab at 11:30 next Friday No office hours today 5-6pm Easy meter . DB and BI Tools. Essentials. Databases. Indispensable in commerce D ata storage, organization, retrieval Program (e.g., VBA) data is volatile. Database.

marlo
Download Presentation

IT&F : Databases

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. IT&F: Databases Stefano Grazioli

  2. Debriefing • Still doing well • Lab at 11:30 next Friday • No office hours today 5-6pm • Easy meter

  3. DB and BI Tools Essentials

  4. Databases • Indispensable in commerce • Data storage, organization, retrieval • Program (e.g., VBA) data is volatile Database

  5. DB and DBMS • A database (DB) is an organized collection of data • A database Management System (DBMS) is a software that provides data-related functionality DataBase User orprogram DBMS DataBasefile(s) • Access, Oracle, IBM DB2, SQL Server, MySQL... • Is Excel a DB or a DBMS?

  6. Data Base Management Systems DBMS is software that includes • Data Definition Language • Data Manipulation Language • Data Dictionary Purchases Purchasing Accounting Billing DBMS Customers Production Scheduling Marketing Invoices Pricing Orders Inventory

  7. SmallBank DB Example

  8. Data Definition Language CREATETABLELoan( l_id integerprimarykey, principal money, rate decimal(8,5)DEFAULT 0.015, date_due datetime, lo_id integer); LOAN

  9. Data Manipulation Language • Record visualization (selection) • Record insertion INSERT INTO LOAN (l_id, principal, rate, date_due)values (7233, 250000, 2/2/2020); • Record update • Record deletion LOAN

  10. DBMS - Data Dictionary Name: Principal Web Name: LoanAmount PC name: PrincipalDue Description: Loan amount granted to a customer Size: 20 bytes Type: numeric Date changed: 01/02/10 Ownership: LENDING Access security: MANAGER, LENDING; MANAGER, RISK MANAGER, SALES…. Used by: LENDING, RISK, MARKETING… Program using: P00023, P00034, P00121, … Reports using: R124 (daily report); R323 (lending summaries); ... Metadata

  11. RDBMS When a DBMS organizes your data so that they appear to the users as TABLES, that DBMS is a Relational DBMS, or RDBMS. “tables inside” DBMS User

  12. Relational Tables

  13. Relational Tables Table (or relation) Row (or Record) Column (or Field)

  14. Primary Key Primary key is a field that contains unique (non duplicated) information & is used to identify a record

  15. WINIT What Is NewIn Technology?

  16. DB Trends Evolution of DB architectures

  17. Technology In Place…Problem NOT Solved! Inventory Application #1 Accounting Costs Application #2 DBMS Finance Forecasts Application #3 Production DBMS Application #4 Costs Marketing Application #5 DBMS Sales Application #5 DBMS Research DB Proliferation

  18. A Solution:Integration Out Of The Box Enterprise System CentralizedDBMS App. #1 Integrated Enterprise Data Accounting App. #2 Production Unit #01 App. #3 Portal / Dashboard Production Plant #02 App. #4 Marketing SAP, Oracle, Mycrosft Dynamics GP….

  19. A Popular Fix: Data Warehousing This is hard to do!(ETL engines) Customers App #1 Customers Costs DBMS Accounting Integrated Enterprise Data App #2 Costs Sales ProductionPlant #01 App #3 DBMS Costs Sales DBMS DataWarehouse App #4 Production Plant #02 DBMS Sales App #5 DSS (BI) Portal / Dashboard Sales & Research Marketing DBMS App #6

  20. Business Intelligence Source: B. Wixom

  21. You do the talking • Name, major • Learning objectives • Things you like about the class • Things that can be improved • Strengths / Attitude towards the Tournament

  22. Homework Google’s Daily Cagr

  23. UML Activity Diagram - Daily Compound Average Growth of a Security (part II) The user press the Compute Cagr button Compute the Cagr for the next customer Print the Average of all Cagrs at the bottom of the Cagr column, with a descriptive label. Print the result for that customer [No More Customers]

More Related