{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

Session 1 (1).pptx

Session 1 (1).pptx - Session 1 DBMS Introduction 2017-18 KL...

Info icon This preview shows pages 1–7. Sign up to view the full content.

View Full Document Right Arrow Icon
Session 1 DBMS Introduction © 2017-18 KL University – The contents of this presentation are an intellectual and copyrighted property of KL University. ALL RIGHTS RESERVED
Image of page 1

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
© 2017-18 KL University – The contents of this presentation are an intellectual and copyrighted property of KL University. ALL RIGHTS RESERVED History of Database systems Basic Terminology Approaches to store data File based Approach Problems with traditional Approach Database Approach Operations on database Database Characteristics Differences between File and Database Approaches Advantages of DBMS Database environment Database users Agenda:
Image of page 2
History of Database Systems 1950s and early 1960s: Data processing using magnetic tapes for storage Tapes provide only sequential access Punched cards for input Late 1960s and 1970s: Hard disks allow direct access to data Network and hierarchical data models in widespread use Ted Codd defined the relational data model Won the ACM Turing Award for this work IBM Research began System R prototype UC Berkeley began Ingres prototype High-performance (for the era) transaction processing © 2017-18 KL University – The contents of this presentation are an intellectual and copyrighted property of KL University. ALL RIGHTS RESERVED
Image of page 3

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
Basic Terminology Database : A collection of related data. Data : Known facts that can be recorded and have an implicit meaning. Mini-world : Some part of the real world about which data is stored in a database. For example, student grades and transcripts at a university. Database Management System (DBMS) : A software package/ system to facilitate the creation and maintenance of a computerized database. Database System : The DBMS software together with the data itself. Sometimes, the applications are also included. © 2017-18 KL University – The contents of this presentation are an intellectual and copyrighted property of KL University. ALL RIGHTS RESERVED
Image of page 4
Approaches to store data •There are two approaches for storing data in computers: File-based approach. Database-approach. © 2017-18 KL University – The contents of this presentation are an intellectual and copyrighted property of KL University. ALL RIGHTS RESERVED
Image of page 5

Info icon This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
File Based Approach A filesystem is a method for storing and organizing computer files and the data they contain to make it easy to find and access them. File systems may use a storage device such as a hard disk or CD ROM and involve maintaining the physical location of the files. Programmers used programming languages such as COBOL, C++ to write applications that directly accessed files to perform data management services and provide information for users.
Image of page 6
Image of page 7
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern