About This Chapter
Database Management Systems & Architecture: Chapter Summary
With the amount of data that organizations review, the amount of databases is often too much for a regular person to handle, which is why professionals today need a better understanding of database management systems and the architecture involved in creating these systems. This chapter has been designed to show you the basics of database management, including its purpose, command codes, related architecture programs, and more. As you go from lesson to lesson, your knowledge about this topic will grow, and you will learn the skills necessary to help you implement better database management practices in your own place of business.
Since all of our resources are available online and around the clock, you can study this information before, after, or even during business hours. In addition, all you need is an Internet connection to study these concepts at home or on-the-go. You can even take this chapter to a training seminar to train your fellow employees.
After you go through this chapter, you will have sharpened your skills and you will be ready to do the following:
- Evaluate various models of database management systems (DBMS)
- Figure out the function and purpose of DBMS
- Identify DBMS advantages
- Apply common SQL commands in DBMS
- Name ACID properties in DBMS
- Describe the best practices in data management
- Identify the normal form of various types of DBMS
- Analyze examples of the first and third normal form
- Check out the types and design of big data databases
- Define architecture patterns in big data
- Examine Lambda architecture
1. Models of Database Management Systems (DBMS)
Get to know the different models of database management systems and learn how each one is used to systematically organize large amounts of data in a logical manner.
2. What is a Database Management System? - Purpose and Function
In this lesson, we will describe the purpose and functions of a database management system, as well as the advantages and disadvantages of using a database management system in an organization.
3. Advantages of Database Management Systems (DBMS)
In this lesson, we will learn what a database management system (DBMS) is and the advantages of its use. We appreciate the short falls of the old flat file systems and see how data integrity consistencies and securities are ensured using a DBMS.
4. Basic SQL Commands in Database Management Systems (DBMS)
Basic SQL commands allow the user to achieve significant manipulation of data in the database. The database management system is the software that allows access to the database and to apply SQL commands to manage data.
5. ACID Properties in Data Base Management Systems (DBMS)
In this lesson we are going to examine the ACID properties of a database management system. We will examine the properties of atomicity, consistency, isolation, and durability, which when adhered to constitute an accurate, robust, and stable database.
6. Data Management Best Practices
In this lesson, we will learn what data management is all about, data life-cycle and the best practices to ensure during and after data design and implementation.
7. What is Normal Form in DBMS? - Types & Examples
This lesson explains the concept of correcting table structures in order to minimize database anomalies through a process called normalization. The normal process consists of multiple steps, called normal forms, each ensuring the elimination of the various types of anomalies.
8. First Normal Form in DBMS with Examples
First Normal Form might sound like the place to be if you're a database. But being first has its drawbacks. This lesson will define first normal form and provide real-world examples.
9. Third Normal Form in DBMS with Examples
Normalization in databases help organize tables and keeps records clean. This lesson will cover the third normal form of database normalization which, through the extension of the second normal form (2NF), further reduces dependencies within the data.
10. Big Data Database Design & Types
Big Data is becoming the standard in business today. In this lesson, we'll take a look at databases, Big Data, what is unique about Big Data database design, and some types of Big Data databases.
11. Big Data Architecture Patterns
More and more, businesses are relying on big data to find answers to their questions. In this lesson, we'll take a look at big data, the architectures it uses, and some patterns associated with those architectures.
12. Lambda Architecture in Big Data
Big Data is becoming a focus point for many companies these days. In this lesson, we'll take a look at Big Data, and an architecture proposed that could simplify working with it. At the end of the lesson, you should have a good understanding of these relevant topics.
Earning College Credit
Did you know… We have over 160 college courses that prepare you to earn credit by exam that is accepted by over 1,500 colleges and universities. You can test out of the first two years of college and save thousands off your degree. Anyone can earn credit-by-exam regardless of age or education level.
To learn more, visit our Earning Credit Page
Transferring credit to the school of your choice
Not sure what college you want to attend yet? Study.com has thousands of articles about every imaginable degree, area of study and career path that can help you find the school that's right for you.