This is my first session as part of Hubfly Lunch & Learn. Though I have been into SharePoint development for quite some time, I have a great interest in Databases and that was my strong area until I ventured into SharePoint development. I thought sharing few pointers on Database to our team could be interesting and nostalgic for me too to dig my favorite tool after a long time.I organized my session to start from basics of what is a Database, Evolution of Data models, to the less known spatial data that is used in most of the Geo Positioning apps.
What is a Database? Key Jargons explained.
- is a collection of related data and its metadata organized in a structured format
- used for optimized information management
Database Management System (DBMS)
- is a software that enables easy creation, access, and modification of databases
- for efficient and effective database management
- is an integrated system of hardware, software, people, procedures, and data
- that define and regulate the collection, storage, management, and use of data within a database environment
Fig: Typical Database Management System
Evolution of Different Data Models
Here is how the Data Model evolved. During the 60’s, it was purely file based an as you might have guessed it had lots of drawbacks. But that is how a new model could evolve, from a primitive stage to a sophisticated system as we have today.
Then came the hierarchical system after which we say the RDBMS or the Relational Database Management System that laid the foundation for the database what we have today. A “relational database” is a database structured on the “relational” model. Data are stored and presented in a tabular format, organized in rows and columns with one record per row.
An Entity Relationship Diagram defines the relationship between entities and their attributes. In an ERD, we are simply visualizing the entities, their attributes, and the relation between them. we don’t care about where foreign keys go or how to implement that many-to-many relationship.
- 1960’s File based
- 1970’s Hierarchical, Network
- 1980’s Relational database
- 1990’s ER
- 2000’s Web based
What is NoSQL
- No SQL is not literally no SQL. They are non-relational data stores.
- Next Generation Databases being non-relational, distributed, open-source and horizontally scalable have become a favorite back end storage for cloud community. High performance is the driving force.
Spatial Database Model
A spatial database is a kind of database that is optimized for storing and querying data that will represent objects defined in a geometric space. Most spatial databases allow representing simple geometric objects such as points, lines and polygons. This finds its use in Geo fetching (Global positioning system)