This video provides comprehensive coverage of the database management system (DBMS). In a standard DBMS there are attributes, keys, indexes, records and blocks. Data is arranged so that it is accessible in a “direct” manner. In order to understand how technology works, it is necessary to have a firm grounding in the mechanics of a data base management system, which is covered within this video, including:
• Atomic Versus Derived Data. We explain both atomic and derived data and give many examples. Learn about the various types of algorithms, including calculations, selections, summarizations, etc. Atomic data and derived data have very different characteristics such as data stability, data consistency, and data reconciliation.
• Naming Conventions. We discuss the naming of databases, the records within a database, and the attributes of these records. Databases are named after the major categories of data that they hold. Records can be named after the database, such as the Customer record in the Customer database. Attributes are named after the data they represent.
• Operational Versus Analytical Data. We explain both operational and analytical data and discuss their differences. Many examples are given. Operational data can be updated and is accurate as of the moment it is accessed. Analytical data can be calculated but not updated.
• Physical Characteristics of Attributes. We cover the properties of attributes including formatting such as character, numeric, binary, or date. We discuss fixed length versus variable length attributes.
• Data Warehouse Basics. We explain the data warehouse, what its records look like, and how it is used. A data warehouse is a subject-oriented, non-volatile, integrated, time-variant collection of data in support of management’s decisions.
• Capacity Planning. We explain capacity planning and its purpose. Capacity planning puts you in a proactive instead of a reactive mode. Capacity planning can help you avoid crises, save money, and make the end user happy. Learn how capacity planning is done.
• Database Basics. We cover the basic organization of a database. Learn the characteristics of a database. Learn the different types of databases that exist such as customer and transaction databases. We explore the typical characteristics of a database, such as data storage and data access.
• Changed Data Capture (CDC). In order to change data from an Online Database to a data warehouse, you’ll need to understand Changed Data Capture. Learn how to keep changes with Online Databases up-to-date with Data Warehousing.
• Database Design Basics. There are many ways to do database design. Learn what questions to ask yourself and how to design following best practices.
• Database Overview. Learn about the different types and aspects of database design. There are many different ways to design a database and there’s no right or wrong way. Each form of database design optimizes one thing at the expense of another. Any one technique is correct or optimal only in the context of the problem that is being solved.
• Database Operations. To understand how a standard database management system operates you need to understand the mechanics of accessing and managing data in a database. We cover the four basic interactions between end user and database.
• Database Performance Internal. We cover the different ways of looking at performance when a transaction or program executes. Performance is measured from the moment in time when a query is initiated until the first results of the query appear on the end users device. Response time is important for the end user to be efficient in the workplace.
• Database Performance System. We help you understand performance at the system level. Learn what can be done on the end user’s computer to enhance performance. At the system level you need to add greater processing power and functionality.
• Database Performance Transaction. Learn how database performance is affected from the perspective of the transaction. Performance is measured from the moment when a query is initiated until the first results appear at the user's device. We will cover the journey of a query and discuss how data is accessed and results returned.
• Relationships. Databases allow data to be gathered, stored, managed and accessed electronically. An important capability of a database is forming a relationship with one or more other databases. Relationships between databases naturally mimic the reality of business activities. By relating databases together, sophisticated and powerful representations of data can be created, and complex business relationships can be depicted. Linking data together between databases logically makes sense and appears as a reality to the user.
• DBMS Vendors. DBMS (Data Base Management Systems) are commercial products that are created by vendors. In this segment we talk about the role of DBMS and the most common vendors.
• DBMS Functions. A Complex, multifunctional, and an important component of the computing infrastructure is the DBMS (Data Base Management System). The DBMS communicates with the operating system. In turn the operating system communicates with the application. Data is found by a means of index, hashing algorithm or sequential search. The primary job of the DBMS is to manage the data found on the disk.
• Service Level Agreement (SLA). The Service Level Agreement (SLA), which is an agreement between IT and the end user relating to the performance of the system. Organizations have adapted the SLA to the data warehousing environment.