![]() ![]() ![]() In this system of storing data, we're using multiple data tables that refer to one another in order to store lots of information about a single entity. In this case, something called a Relational Database. When we throw the word relational into the mix, such as when we say, Relational Database Management System or RDBMS, than we're being specific as to the type of database that we're working with. So that's a quick overview of what a Database Management System is. Some DBMS's also allow you to setup permissions for different users and control access to just the portions of the system that they need in order to do their jobs while keeping them out of areas that they shouldn't be accessing. These allow you to optimize the database for speed and create routine backups and other tasks, which keep the data itself healthy and reliable. In addition to creating and interacting with the database, a DBMS provides maintenance and user administration capabilities. Or they can be more complex and robust systems like SQL Server or Oracle, which largely provide a pair of database and engine but require you to develop the interface or the application in a programming language of your choice. They can be a simple desktop systems like Microsoft Access, which runs on a single computer, and includes the database, the engine, and the end user interface development, all under one roof. This is a system of tools that package up all three of these components into a single application that we can develop within. When talking about creating a database however, we're usually talking about what's called a Database Management System or a DBMS. Once the information is retrieved, the process reverses itself, and the database passes the information back to the engine which translates it into a format that the user can make use of, usually on screen or in a particular port. ![]() The Database Engine translates those instructions into code that is then used to retrieve information from the database itself. It starts with a Database Application which collects user input in the form of instructions. So this might seem like a bunch of moving parts that we have to contend with. This is where we convert our human intentions and questions about the data into code that the database engine understands and we usually do this through user-friendly input features, like buttons and text boxes, and drop-down menus, and so on. This is the responsibility of a database engine, a collection of programs that are able to sift through the database items and perform the required tasks, and in order for you or I, or any other end user to access the database engine, we need to go through some sort of Database Application or what's sometimes referred to as a front end. That is to say, we need a way to create new data items, read and find existing data items, update data items with new information, and delete outdated data items. In order to make use of a database, we need a way to perform what are called CRUD tasks. Regardless of where the data is physically stored, the database acts as a single entity to anyone or any system that makes use of it. This collection of data items can be stored in a single location or hard drive, or distributed across large networks with components in many physical locations. At its most basic level, a database is a collection of individual data items that are stored in a highly structured way that represents a model of reality. Before we can understand what a Database Management System is though, we first need to understand what a database is. In this course, we're going to be moving towards storing our data inside of a Database Management System. ![]()
0 Comments
Leave a Reply. |