Preview
Preview

Database Environment Classification Essay

:: 3 Works Cited
Length: 1389 words (4 double-spaced pages)
Rating: Purple      
Open Document
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

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 .
c. Database:
Repository- It is a centralized knowledge base . It contains all the data definitions , report format and definitions of organizations which are related and system components.
Database Management System- It is a commercial software system which is used to create , maintain and provide controlled access to the repository.
Database - It is a collection of logically related data which is required to meet the needs of applications or users of organizations.


SQL is a special purpose programming language designed for managing data held in relational database management systems(RDBMS). [1]

1. SQL Components:
There are three components.
a. Data Definition Language .
b. Data Manipulation Language .
c. Data Control Language .
Data Definition Language (DDL):
This component is used to CREATE and ALTER (or) modify the tables and the objects of that database.
CREATE TABLE 'TABLENAME' , DROP TABLE 'TABLENAME' and ALTER TABLE ...


... middle of paper ...


...tandards and the role they play in business
By following SQL standards there is greater role of compatibility between similar kind of databases. The structure is proper and the maintenance of the database will be less and the application would be stable which will lead to reduced cost of maintenance.
SQL standard provides a module language as a interface to other languages. SQL statements may be sent as a procedure that can have parameters passed to it from a external language and called when required.
By following SQL standards the process of handing the transitions of database is systematic which reduces the overhead costs.



References
• http://en.wikipedia.org/wiki/SQL

Bibliography
• http://www.sqa.org.uk/e-learning/SoftDevRDS04CD/page_02.htm
• http://www.itl.nist.gov/div897/ctg/dm/sql_info.html
• http://www.uniforum.org/publications/ufm/may96/standards.html



Click the button above to view the complete essay, speech, term paper, or research paper








This essay is 100% guaranteed.


Title Length Color Rating  
Database Management Essay - What is a database management system. Discuss each of the five important software components of a database management system. Data Base Managements System (DBMS) is a computer software program installed on a system hard drive that catalog, retrieve, and run queries on data. It provides ways for data to be altered or removed by users or other programs. There are several different types of database management systems that exist that were created for the proper control of databases for specific purposes....   [tags: Technology, Computer Softwares, Data] 1226 words
(3.5 pages)
Good Essays [preview]
Essay on Analysis of Database Management and Information Retrieval Systems - 1. DIFFERENCES BETWEEN DATABASE MANAGEMENT SYSTEM AND INFORMATION RETRIEVAL SYSTEM DATABASE MANAGEMENT SYSTEM (DBMS) INFORMATION RETRIEVAL SYSTEM (IRS) DBMS offer advance Data Modelling Facility (DMF) including Data Definition Language and Data Manipulation Language for modelling and manipulating data. IRS do not offer an advance DMF. Usually data modelling in IRS is restricted to classification of objects. Data Definition Language of DBMS is the capability to define the data integrity constraints. In IRS such validation mechanisms are less developed....   [tags: raw data, unstructured data]
:: 6 Works Cited
1108 words
(3.2 pages)
Strong Essays [preview]
The Client/Server Database Environment Essay - Over the last thirty plus years, in which computer software applications have been vital to business operations, the concept of client/server applications has evolved. In the early 1980’s the term, Client/Server, primarily referenced capabilities of new powerful centralized hardware. The computer world is different today and the concept is better defined as a system where the different logical components are separated from each other. The first of the three basic logical components is the Presentation Logic....   [tags: Information Technology]
:: 1 Works Cited
991 words
(2.8 pages)
Better Essays [preview]
Cemetery Prototype Database Essay - This prototype database was designed to meet the general needs of users from a range of different backgrounds in relation to cemeteries and graveyards. The scenario is described as follows: A consortium of international archaeological and historical societies has collaborated in funding a multidisciplinary database of international historical graveyards whose history goes back at least 100 years. As the database will be used for research as well as town-planning by a wide variety of people, including historians, local councils, genealogists, sociologists and epidemiologists, it is anticipated that it will include not only information about the graveyards themselves, but also the buildin...   [tags: Database] 1892 words
(5.4 pages)
Strong Essays [preview]
Database Administration Roles Essay examples - 1.0 DBA Roles: DBA plays important role in every organization, they are the core part of Technology Team, based on Organization DBA roles vary but majority of their role are very critical due to impact, Architect, Quality Analyst, System Analyst and Developers everyone has to work with DBA during different development life cycles. DBA skills are hard to find majority of organization prefer DBA which are certified, and certification for DBA are hard to achieve. Organization Expectation from DBA: - DBA should have good understanding of Database and its tools....   [tags: Database Administration Essays]
:: 1 Works Cited
941 words
(2.7 pages)
Strong Essays [preview]
Relational Database Management System Essay - Relational Database Management System Oracle provides a flexible RDBMS called Oracle7. Using its features, you can store and manage data with all the advantages of a relational structure plus PL/SQL, an engine that provides you with the ability to store and execute program units. The server offers the options of retrieving data based on optimization techniques. It includes security features that control how a database is accessed and used. Other features include consistency and protection of data through locking mechanisms....   [tags: Database Data] 1093 words
(3.1 pages)
Good Essays [preview]
An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers - Comparison Summary DBMS Server Comparison Supplement An Analysis Of The Strengths And Weaknesses Of The Big Six Database Servers. In 1991 I performed a thorough evaluation and comparison of the four major DBMSs at the time: Informix, Ingres, Oracle, and Sybase. This comparison was done for a client building a huge distributed database application, currently in its second phase of d evelopment, with the first phase running successfully country-wide. At that stage, the distinguishing criteria were query optimizers, triggers, views, and support for distributed databases....   [tags: Database DBMS] 1711 words
(4.9 pages)
Powerful Essays [preview]
Essay on History of Database Technology Past and Present - History of Database Technology Past and Present The term database was popularized with the growth of the computer industry and is typically thought of as software used to store, index, manipulate, and retrieve information (Vaughn). Database software has been in use since the Census Bureau used a punch card system to meet the requirements for the collection, sorting, and reporting of data for the 1890 census (National Research Council). These earliest databases were flat file databases. The flat-file style of database works well for small amounts of data that need to be organized to be read and edited by hand....   [tags: Data Database Management] 1389 words
(4 pages)
Strong Essays [preview]
Classifications of Beer Essay - Classifications of Beer What's more refreshing on a hot summer day than an ice cold beer. How about drinking a cold one with some friends at a local bar after a hard day's work, sounds satisfying doesn't it. Beer has been around for hundreds years and will be around for hundreds more. A beer is any variety of alcoholic beverages produced by the fermentation of starchy material derived from grains or other plant sources....   [tags: Classification Essay] 1332 words
(3.8 pages)
Strong Essays [preview]
Essay about Database Concepts - Database Concepts, what are Databases all about. I am writing this paper to answer a few questions as part of my first assignment in a class designed to provide a better understanding of Database Concepts. There are many different types of databases, different implementations of databases, and different database software applications. So how does all this database stuff work. I have worked with databases for most of my professional career at many different levels. Sometimes as the user, entering data, retrieving information, and compiling reports....   [tags: Database Data] 1204 words
(3.4 pages)
Strong Essays [preview]