INFS1602 Lecture Notes - Lecture 6: Railways Act 1921, Database Server, Foreign Key
Document Summary
Infs1602 digital transformations in business (semester 1 2018) Importance: development of new business initiative, ubiquitous, dynamic business environment & adaptation to new is, build own database. 5. 3 how do database applications make databases more useful: database application collection of forms, reports, queries & application programs that serves as an intermediary between users & database. More vulnerable: problems: multi-user processing problems/lost-update problem (e. g. two people buying the same ticket at the same time) 5. 4 what are non-traditional dbms products: reasons for change, need to differently store new data types, businesses do not want to store data in separate tables; inefficient & inconvenient, need for faster processing using many servers (e. g. Cassandra: types of non-traditional dbms, nosql dbms support very high transaction rates processing relatively simple data structures, replicated in many cloud servers, without acid transaction support, newsql dbms process high levels of transactions, with acid support. In-memory dbms process databases in main memory.