PPT-Modern Main-Memory Database Systems

Paul Larson Justin Levandoski Microsoft 992016 MMDB Tutorial VLDB 2016 1 Tutorial Overview Mainmemory database research has been going on for a long time Only recently do we have a number of generalpurpose commercial mainmemory databases. g a core dump Semiconductors are almost universal today Memory Cells Properties Exhibit two stable or semi stable states representing 1 and 0 Capable of being written to at least once to set state Capable of being read to sense the state Memory Cell The truth is though that processors are way too fast to wait for each memory access In the time it tak es to access memory just once th ese processors can execute hundreds if not thousands of instructions If you need to speed up an application it is yaleedu Alexander Thomson thomsoncsyaleedu Daniel J Abadi dnacsyaleedu Northwestern Polytechnical University China Yale University ABSTRACT Locking is widely used as a concurrency control mechanism in database systems As more OLTP databases are store Disk Access time Memory is faster than disk Access pattern Memory is better for random access than disks Stableness Memory is volatile Disk is nonvolatile Security Memory is more vulnerable to software errors 15823 April 5 2001Mengzhi Wang 4 Justin DeBrabant. Brown University . debrabant@cs.brown.edu. A bit of history…. 1974 – System R. query optimization . recovery . transaction serialization. lots of locks. Application. Primary Storage. A program that controls . and . supports . the usage of computer . systems. Usage. Users . of a computer system. :. . programs. - use memory, use CPU time, use I/O . . devices. . human . users. Operating Systems Overview. Stallings OS 6. th. edition. Chapters 1 & 2. Kevin Curran. Operating System. Exploits the hardware resources of one or more processors. Provides a set of services to system users. Chapter 1. The Worlds of Database Systems. Section 1.1 . Evolution of Database Systems . The DBMS is expected to :. 1 . Allow users to create new databases and specify their schemas ( logical structure of the data ) , using a specialized data - definition language.. Fall 2017. Instructor: . Jianer. Chen. Office: HRBB 315C. Phone: 845-4259. Email: chen@cse.tamu.edu. Notes #7. secondary. storage. (disks). database. administrator. DDL. language. database . programmer. to: Wes. , . Michael. , and . Jeremy. In-Memory Databases. Overview. Oracle . TimesTen. SAP HANA. History of In-Memory Databases. IBM’s . DB2 . database launched in the early 90’s. First significant IMDB by TimesTen, later acquired by Oracle. 11. th. Lecture, October 2, 2018. Today. Storage technologies and trends. Locality of reference. Caching in the memory hierarchy. Random-Access Memory (RAM). Key features. RAM . is traditionally packaged as a chip.. System. -. . General . Idea and Applications. Hongnan Li. Yanpu. Li. Chong Zhou. Agenda. General idea. . of. . MMDB. . . -. . Mechanisms. . and. . details. Application. . demonstration. . By: Lecturer . Raoof. . Talal. 1.1 What are the Operating Systems. ?. An . operating system . is a program that manages the computer hardware. It also acts as an intermediary between the computer user and the computer hardware. Shimin . Chen. * Phillip B. Gibbons* Suman Nath. +. *Intel Labs Pittsburgh . +. Microsoft Research. Introduction. PCM is an emerging non-volatile memory technology. Samsung is producing a PCM chip for mobile handsets.