Introduction:
Database environment can be classified into three simple categories:
a. Human: Database Administrator - They are responsible to monitor and maintain the databases in an organization. Systems Developers - They are responsible for the development of the computer applications which will talk to the database in do the necessary operations and display the results to the end users.
b. Machine:
User Interface - This is how the computer application looks and what the end user will use to interact.
Application Programs- This is the core of the computer application. These are the programs which are related to the application, so that user can use the system to get output
…show more content…
They take care of the security and maintain the data backups.
The execution of SQL commands can be done by the SQL developers but the changes should be approved by the DBA , because finally they are the responsible for maintaining the structure and security of the database. Developers should not create the SQL commands as this might lead to conflicts on the data, sometimes they might not be aware of the complete structure of the database.
For instance if a query needs to be written which generates reports, if the application developer writes the query it can be used only in the application but if the a SQL developer writes the query it can be used by the application developer and also independently to generate reports. Because the SQL developer places the queries in the database as a view and that is accessed by the developer and others .
The end users should not execute queries, as they might also not be the aware of the structure except the understanding of functionality.
Basic troubleshooting queries can be executed by the DBA but when there is a bigger issue SQL developers can resolve them as they have better understanding of the low level
problem and it will be used in this case to build the databases. The databases
Databases always used to fascinate me from my under graduation with great curiosity to know how large data is managed and queried. This led me to do Masters in computer science concentrating in the field of Data Management. In the course of my study, I understood the concepts of DBMS which provides a robust and efficient way of managing and mining data. Through the courses like Database Systems (ITCS 6160), Knowledge Discovery in Databases(ITCS 6162) and Knowledge Based Systems(ITCS 6155) I gained enough theoretical and practical knowledge about the importance of proper organization of data, good techniques to build an efficient database management system and how well the data can be managed.
In an SQL database like MySQL, or Oracle, it executes queries, retrieves or updates data, and even deletes or creates new records. SQL is a lightweight language that is declarative and does a lot of heavy lifting for the relational database, thus it may act like a server side script but only database version of it.
Microsoft Access is a database engine and development environment in one package. It is typically workstation-based, and designed to be easy to use, even for users with no experience. However, it also provides advanced functionality for experienced users. MySQL is the largest open-source RDMBS, and it is server-based, as well as the rest of the DBMS that will be discussed. According to the mysql.com website, it offers high reliability and performance, easy use and deployment, freedom from platform lock-in by providing ready access to source code, and cross-platform support. SQL Server is an enterprise class RDBMS from Microsoft. It is part of the Back Office Suite of products. Although it is always server-based in production, it can be client-based in development. DB2 is also an enterprise-class DBMS, produced by IBM. It offers some object-oriented functionality, as well as cross-platform compatibility, and is server-based. Finally, Oracle offers much of the same functionality as DB2, with cross-platform capability, and some object-oriented features. It, as well, is server-based.
Circumventing the Need for a Query Language: A query language is not necessary for accessing data from an OODBMS unlike an RDBMS since interaction with the database is done by transparently accessing objects.
There are many different types of databases, different performances of databases, and different database software functions. Before we get to much into databases lets take a step back and think about what a database really is and how they are applied. A database is a software program arranged to collect hold and process information. There are quite a bit of software programs out there already that can allow you to do all this. However, what makes databases different is that once you enter information in to, the database will operate the information in ways that allow you to analyze the information. Databases are designed in such a way that as to make it easier to obtain particular pieces of data. Databases are used in many ways existing in pretty much the entire world of computers. Databases are the most used method of storage for large multiuser funtions where the coordination between many users is necessary. This is just basically what a database is.
The database application design can be improved in a number of ways as described below:
Some benefits to using SQL server are the seamless navigation which gives enough support for users to know how to work the system without asking an expert for assistance, it includes a query editor which is a tool used for executing T-SQL quires, which comes with the three features which support the database; Estimated Execution plan, Actual execution plan and Client Statistics. The Object scripting allows you to script out an object from one server to any other server, Generate Script Wizard which allows users to move their databases quickly and efficiently. It also contains templates, dialog supports to help the user and Object Explorer Details which provides a tabular view of all the objects in the server and produces a user interface to manage them.
Some faculties and departments are already using Oracle applications in their day-to-day operations. As time goes by, more and more information users will be working with an application based on Oracle database technology. If you get the opportunity to be a member of an application development team, you will become familiar with the workings of Oracle and relational databases. Other users may have to learn about this popular database management system through their own experience. This article is for our readers who, as of yet, have no access to Oracle databases but have a yearning for learning what they're all about.
Network databases share several problems with the hierarchical database management system. Both are the very inflexible, and also set relationships and record the structures that must be predefined. The major disadvantage of both network and hierarchical database management systems was that they are the programmer’s domains. To answer the simplest query of this database, one had to create the program that navigated the database management structure and produce an output; unlike SQL, this program was written in the procedural, and required the great deal of the knowledge of both database management structure and underlying the operating system. As a result, these type of programs were not portable and took enormous amount of time to write.
The main component of a DBMS is the software. It is the set of programs used to handle the database and to control and manage the overall computerised database. This component manages or controls the ...
There are three types of Database Management System which are the relational Database Management System, the non-relational Database Management System and Object Oriented Database Management System. The relational DBMS is the most widely accepted Database Management System nowadays. The non-relational DBMS that are in large scale are still in use while the Object Oriented DBMSs are in development. Besides, more and more DBMSs are supporting basic multimedia storage and retrieval facilities.
This is an application program that a computer program that interacts with database by issuing an appropriate request (SQL statement) to the DBMS.
In our world, people rely heavily on the power of technology every day. Kids are learning how to operate an iPad before they can even say their first word. School assignments have become virtual, making it possible to do anywhere in the world. We can receive information from across the world in less than a second with the touch of a button. Technology is a big part of our lives, and without it life just becomes a lot harder. Just like our phones have such an importance to us in our daily lives, database management systems are the same for businesses. Without this important software, it would be almost impossible for companies to complete simple daily tasks with such ease.
Another function of the DBMS is the concurrency control services. Database Management System must ensure that the database is updated correctly because the database can be used by many multiple users. The DMS enable many user to access the data concurrently. The database managements system will help from ay data loss. It have the features which that can support the updates like batch processing, locking, two-phase locking and the time stamping.