Downloaded 101 times
Databases and types of databases
This document provides an overview of different types of databases including relational, document oriented, embedded, graph, hypertext, operational, distributed, and flat file databases. Key points include: - Relational databases store data in tables with rows and columns and use primary and foreign keys. - Document oriented databases store flexible documents without uniform fields. - Embedded databases consist of end-user files like documents and spreadsheets. - Graph databases represent data through nodes and edges to show relationships. - The document also provides contact information for Baabtra, a company that offers online courses and mentoring for software development.
More Related Content
Similar to Databases and types of databases
More from baabtra.com - No. 1 supplier of quality freshers
![UiPath Automation Suite Installation (Hands-On) [2/3]](https://cdn.slidesharecdn.com/ss_thumbnails/automationsuitecommunitysession2-251015095633-a6d862f1-thumbnail.jpg?width=600ounds&width=560&fit=bounds)
Databases and types of databases
- 2.
- 3. Disclaimer: This presentationis prepared by trainees of baabtra as a part of mentoring program. This is not official document of baabtra –Mentoring Partner Baabtra-Mentoring Partner is the mentoring division of baabte System Technologies Pvt . Ltd
- 4. DATABASE MANAGEMENT SYSTEM ADatabase is a collection of records. Database management systems are designed as the means of managing all the records. DBMS is a software system designed to allow the definition , update , retrieval and administration of databases.
- 5. TYPES OF DATABASE •Relational database • Document oriented database • Embedded database • Graph database • Hypertext database • Operational database • Distributed database • Flat file
- 6. Relational Database • Arelational database is a database that has a collection of tables of data items. • Data in a single table represents a relations. • Tables consist of rows and columns. • The columns constitute the attributes. • The rows constitute tuples.
- 7. • Row-A dataset representing a single item. • Column-A labeled element of a tuple, e.g. "Address" or "Date of birth”, of multiple data item.
- 8. • A primarykey is used to uniquely identify each row. • The foreign key a column or group of columns in one table that points to the primary key of another table. • A stored procedure is executable code that is associated with, and generally stored in, the database.
- 9. Document Oriented Database •A computer program designed for storing, retrieving and managing document oriented information. • Documents inside a document-oriented database are similar to records or rows in relational databases. • Do not store data in tables with uniform sized fields for each record.
- 10. • Any numberof fields of any length can be added to a document.
- 11. Embedded Database •The databasesconsist of data developed by individual end users. •Examples of these are collection of documents, spreadsheets, presentations and other files.
- 13. Graph Database • Agraph database is a database that uses graph structures with nodes, edges, and properties to represent and store data. • A graph database is any storage system that provides index- free adjacency. • This means that every element contains a direct pointer to its adjacent elements.
- 15. Hypertext Database • Hypertextdatabases are particularly useful for organizing large amount of disparate information. • Hypertext is text displayed on a computer display or other electronic devices with references to other text which the reader can immediately access. • Pages often written in HTML.
- 17. Operational database • Anoperational database contains data about the things that go on inside an organization or enterprise. • Example: data on customer complaints, employee information, etc.
- 18. Distributed Database • Itis a database in which portions of the database are stored on multiple computers within a network. • The DDBMS synchronizes all the data periodically. • Updates and deletes performed on the data at one location will be automatically reflected in the data stored elsewhere.
- 19. Flat File • Aflat file database is a database that stores data in a plain text file. • Flat files are ideal for small amount of data. • Each line of the text file holds one record, with fields separated by delimiters, such as commas or tabs.
- 22. Want to learnmore about programming or Looking to become a good programmer? Are you wasting time on searching so many contents online? Do you want to learn things quickly? Tired of spending huge amount of money to become a Software professional? Do an online course @ baabtra.com We put industry standards to practice. Our structured, activity based courses are so designed to make a quick, good software professional out of anybody who holds a passion for coding.
- 23. Follow us @twitter.com/baabtra Like us @ facebook.com/baabtra Subscribe to us @ youtube.com/baabtra Become a follower @ slideshare.net/BaabtraMentoringPartner Connect to us @ in.linkedin.com/in/baabtra Give a feedback @ massbaab.com/baabtra Thanks in advance www.baabtra.com | www.massbaab.com |www.baabte.com
- 24. Emarald Mall (BigBazar Building) Mavoor Road, Kozhikode, Kerala, India. Ph: + 91 – 495 40 25 550 NC Complex, Near Bus Stand Mukkam, Kozhikode, Kerala, India. Ph: + 91 – 495 40 25 550 Cafit Square, Hilite Business Park, Near Pantheerankavu, Kozhikode Start up Village Eranakulam, Kerala, India. Email: info@baabtra.com Contact Us