[#014]Database: Definition, Types, and Fact.
Understanding database and its basic principles.
Hey friend, it’s Me again! 🤗 Welcome to Hack a craft — a weekly email around tips that will help you hack a craft and a navigating framework.
Thanks for the feedback given, we encourage you to always share your thoughts and suggestion about our newsletter with us. I’m sorry, I couldn’t send out the newsletter last Sunday but we’re back now.
This newsletter is behind our usual schedule and I am so sorry for that. Here is a curated resource for a beginner starting his/her way into web engineering and software engineering.
DATABASE DEFINITION
Databases are structured to assist with the storage, retrieval, modification, and deletion of data in collaboration with various data-processing operations. In our last newsletter, we discuss “Data Manipulation”. Remember “The information you read when you visit a website has been organized and arranged in a manner that appears to your craving for information.”
A database, also called an electronic database, is any collection of data stored, and that’s been process to present appealing information, that is specially organized for rapid search and retrieval by a computer.
DATABASE TYPES
Information are been extracted from a database in response to queries and are been stored by an action carried out by the users. The Database management system (DBMS) is a structured principle used in storing, retrieving, editing, and deleting files.
A database is stored as a file or a set of files. The information in these files may be broken down into records, each of which consists of one or more fields. Fields are the basic units of data storage, and each field typically contains information pertaining to one aspect or attribute of the entity described by the database.
Database technology has changed and evolved over the years and it can start to get confusing. Storing data doesn’t have to be a headache. If you’re trying to pick the right database for your organization/personal project, here’s a guide to the properties and uses of each type.
Relational Databases:
Data is stored in multiple, related tables. Within the tables, data is stored in rows and columns. that allows each data to be easily manipulated across rows and columns.
Examples:
Microsoft SQL Server, Oracle Database, MySQL, PostgreSQL and IBM Db
NoSQL Databases:
NoSQL is a broad category that includes any database that doesn’t use SQL as its primary data access language. Data access language gives you the access to run the CRUD operator on your database. This type of database could be called a non-relational database and they don’t have to conform to a pre-defined schema; database schema is the skeleton structure that represents the logical view of a Database.
Example:
Apache Cassandra, MongoDB, CouchDB, and CouchBase
Cloud databases:
A cloud database refers to any database that’s designed to run in the cloud. Like other cloud-based applications, cloud databases offer flexibility and scalability, along with high availability. Cloud databases are also often low-maintenance since many are offered via a SaaS model.
Example:
Microsoft Azure SQL Database, Amazon Relational Database Service, Oracle Autonomous Database.
DATABASE FACT
The information in many databases consists of natural-language texts of a document; numerical-oriented databases primarily contain information such as statistics, tables, financial data, and raw scientific and technical data. Small databases can be maintained on personal-computer systems and used by individuals at home.
When you use a DBMS, you are expected to carry out three important activities on your database and they are your data, the database engine and the database schema. By managing these three elements, your databases will be more secure and consistent. This allows multiple users to access the data and make smart business decisions.
To get started with the database, you’ll want to understand the general information about the order of operations in a database.
Again, I have curated a list of resources that will provide you with information for learning about Databases.
Enjoy the journey!
Opportunities in Tech✍️🏾
Senior Software Engineer with Cove
Suggested Articles✍️🏾
Quote for the day
Information is not knowledge, and knowledge is not wisdom. Reading - even browsing - an old book can yield sustenance denied by a database search. Patience is a virtue, gluttony a sin.
James Gleick
Book Recommendation📚📚
That's all for this letter. See you next week Sunday and stay safe! Please forward this email to your friends. If you've not subscribed yet, kindly subscribe below, and you can be a Patron.