Database Systems Dbm380

Database Systems

In years past the dilemma to keep data organized and easy for users to access has troubled IT staffs across the board. A database is a shared, integrated computer structure that stores input end-user data as well as metadata which is data that is used to manage and integrate end-user data. A database system can also be used to centralize data for an organization to share with the end-users and have an ease of maintenance for the local IT staff. These systems are used to collect data that users input, organize it, and then make it easily shareable across the organization. The main question that is heard across each organization is “Why use a database system?” The simple answer is to use a database system for efficient user access, data independence, reduced application developments time, data integrity and security, and finally for the ease of data administration. One of the most popular database architectures used today is Microsoft SQL server.

Database architecture – Microsoft SQL Server

According to "MSDN Microsoft Sql Server" (2012), "Microsoft® SQL Server™ is a database management and analysis system for e-commerce, line-of-business, and data warehousing solutions” (para. 1). The architecture of the database is broken down into components. Data in the database is organized in logical components that are visible to the end-users and the database is also physically implemented as two or more files on disk. According to Microsoft (2012), "When using a database, you work primarily with the logical components such as tables, views, procedures, and users. The physical implementation of files is largely transparent. Typically, only the database administrator needs to work with the physical implementation.” (para. 2). Every instance of the SQL database has four system databases as well as one or more user databases. Those four are the master, model, tempdb, and msdb, which are the base components installed when the server software has...