Open Source Database: Virtue Or Vice?

By Binayaka Mishra

On 1962, it has been cited by Oxford University that, “State Development Corporation” of California,USA is the first to use data-base term on technical aspect. On mid-1960’s Charles William AKA "Charlie" Bachman III an American computer scientist, who was the author of IDS [Integrated Data Store], founded the Database Task Group within CODASYL, who was also sole responsible for creation and standardization of COBOL. In 1971, CODASYL delivered its approach to user database on the below terms, which welcomed other market leaders to follow. Although IBM had its own database known as IMS, which was developed using Apollo Program under system 360, but was always considered as hierarchical database due to its strict hierarchical data modelling unit to search any particular or group of data sets, whereas IDS was always considered as network database.

• Language: English
• Publisher: Binayaka Mishra
• Release date: Jun 8, 2017
• ISBN: 9781370277575

Binayaka Mishra

Binayaka Mishra is an experienced IT professional, in various tools and technologies like Data Warehousing, BigData Analytics, Cloud Computing, Reporting Analytics & Project Management documentation with 14+ years’of experience. He was Graduated in Computer Science & Engineering from National Institute Of Science & Technology, Berhampur, Odisha, India in 2002.He has worked in several critical roles with MNC’s like Tech Mahindra, Oracle Corporation, Wipro Technology,CapGemini UK,CapGemini India Pvt Ltd, UBS , AoN Hewitt Associates India Pvt Ltd, HMRC -UK and TUI Travel Plc -UK. Apart from technical details, his mastery are into functional domains like Payroll Processing, Tax Calculation, UK NI, BFSI,Telecommunication, Corporate Tax measurements divisions, Investment Banking, Automotive, Asset management , Security and Travel & Tourisim.Currently working as a Solution Architect / Project Manager in Tech Mahindra, India, loves to listen to music, play snooker, Bowling and a desperate swimmer like a shark.More Information could be found about him in his Linkedin Profile : https://www.linkedin.com/in/binayaka-mishra-b09612142/For any comments or advise, please feel free to write to: [e-mail]

Book preview

Open Source DataBase

Virtue Or Vice?

By Binayaka Mishra

Copyright © June 2017, Binayaka Mishra

Smashwords Edition

This ebook is licensed for your personal enjoyment only. This ebook may not be re-sold

or given away to other people. If you would like to share this book with another person,

please purchase an additional copy for each recipient. If you’re reading this book and did

not purchase it, or it was not purchased for your use only, then please return to your

favorite ebook retailer and purchase your own copy. Thank you for respecting the hard

work of this author.

In case downloading this eBook, This book remains the copyrighted property of the author,

and may not be redistributed to others for commercial or non-commercial purposes. If you

enjoyed this book, please encourage your friends to download their own copy from their

favorite authorized retailer. Thank you for your support.

DEDICATION

I Would like to dedicate this manuscript to my stalwart elder brother, Mr. Bibhu Prasad Mishra for his outstanding courage and submission to Indian Air Force irrespective of all the odds; which includes earthquakes, T-Sunami and versatile natural calamities. Though he was suffered a lot for these moments and commanded to proceed with his duties, that always make me feel proud upon his achievements and encouraged me a lot. Not too stunningly mention, If I am being little eligible to write this book to today, it’s become successful due to the painful life of my brother which always inspired me.

Table of CONTENTS

1. Background

2. Delineation

2.1 Relational Database

2.2 Operational Database

2.3 Database Warehouse

2.4 Distributed Database

2.5 End-User Database

2.6 External Database

2.7 Hypermedia Database

2.8 Navigational Database

2.9 In-Memory Database

2.10 Document-Oriented Database

2.11 Real-Time Database

2.12 Analytical Database

3. Open Source DBMS VS Commercial DBMS

3.1 Method of Score Calculation

4. Featurette

4.1 PostgreSQL

4.2 MongoDB

4.3 Cassandra

4.4 Redis

4.5 SQLite

4.6 MySQL

4.7 FireBird

4.8 ElasticSearch

5. Data Modelling

5.1 Conceptual Data Model

5.2 Logical Data Model

5.3 Physical Data Model

6. Glossary

7. Data Dictionary

8. Data Mapping

9.Entity Relationship Diagram

9.1.1. Entity

9.1.2. Entity Type

9.1.3. Entity Set

9.1.4. Entity Category

9.1.5. Composite Entity

9.1.6. Recursive Entity

9.1.7. Entity Keys

9.2 Attributes

9.3 Relationship

9.4 Relationship Set

9.5 Keys

9.6 Cardinalities

9.7 Participation Constraints

10.Normalization

10.1 First Normal Form (1NF)

10.2 Second Normal Form (2NF)

10.3 Third Normal Form (3NF)

10.4 Fourth Normal Form (4NF)

10.5 Fifth Normal Form (5NF)

10.6 Boyce Codd Normal Form (BCNF)

10.7 Functional Dependency

10.8 Armstrong’s Axioms

10.9 Trivial Functional Dependency

11. De-normalization

11.1 Adding Redundant columns

11.2 Adding derived columns

11.3 Collapsing Table

11.4 Snapshots

11.5 VARRAYS

11.6 Materialized Views

11.7 Advantages of De-Normalization

11.8 Disadvantages of De-Normalization

12. Data Independence

13. Creating Logical Data Model

14. Creating Physical Data Model

15. Data Modelling Best Practices

16. Data Modelling Variety

16.1 Flat Data Model

16.2 Entity Relationship Data Model

16.3 Relational Data Model

16.4 Network Data Model

16.5 Hierarchical Data Model

16.5 Object oriented Data Model

16.6 Record base Data Model

16.7 Object relation Data Model

16.8 Semi structured Data Model

16.9 Associative Data Model

16.10 Context Data Model

17. Open Source Database Infrastructure for Digital Transformation

18. Consolidation

19.Citation

20.Reference

ACKNOWLEDGMENTS

This paper is for informational purposes only. THIS DOCUMENT IS PROVIDED AS IS WITH NO WARRANTIES WHATSOEVER, INCLUDING ANY WARRANTY OF MERCHANTABILITY, NONINFRINGEMENT, FITNESS FOR ANY PARTICULAR PURPOSE, OR ANY WARRANTY OTHERWISE ARISING OUT OF ANY PROPOSAL, SPECIFICATION, OR SAMPLE. The author of this paper disclaims all liability, including liability for infringement of any property rights, relating to use of this information. No license, express or implied, by estoppel or otherwise, to any intellectual property rights is granted herein. I would like to personally thanks the various Informational Journals as furnished on Reference & Citation to aid me produce such quality content and also let me learn new ideas.

1.BACKGROUND

Well, those of you are new bee to OSS [Open Source Software], I can advise them to go for my previous article as mentioned on the reference section of this article to have the prescience of the OSS concept before proceeding with OSD [Open Source Database]. It’s not always imperative to have the advance cognizance about the parent to identify its child, but if you would like to understand the hierarchical relationship of inheritance what OSS & OSD possess, then it’s always advisable to start from the scratch.

As we all understand that, database is the storage place to store one’s data. If we usually go back to ancient times about six to seven decades back, people are usually using disks like CD-ROM to store and manage their data which were not only vulnerable to manage but also possessed better security risks, which may be the idea which brought us DBMS [Database Management Systems], by late 1950 or early years of 1960 and the world started using the concept of storing their data on software, rather solely depending on hardware’s.

On 1962, it has been cited by Oxford University that, "State