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]
Response of every Type of Software Error Essay - {THOMAS and JOHAN 1983} believed that tolerance to software faults as traditional way the state restoration is can be expensive in addition to The concurrency introduce more difficulties specially when deal with timing constraints. They suggest a straightforward pragmatic approach for real-time system. The approach takes benefits of the structure of real-time system to simplify error recovery, and a classification scheme. Respond to every type of error are determined which allow service to be maintained....   [tags: classification, system, recovery, software] 1517 words
(4.3 pages)
Powerful Essays [preview]
Database in Distributive Environment Essay - Database in Distributive Environment Database is a diverse collection of information which manages data and allows fast storage and retrieval of that data. Each application requires database to hold the data specific to the application, which is accessed by the users. However, each application according to its requirement needs different type of database. Researchers classify the databases according to the user specific functionalities, parameters as well as application. There have been several discussions and researches on the joins, which is a key performance indicator of any database....   [tags: cloud theory, paralell database] 536 words
(1.5 pages)
Strong Essays [preview]
Essay on The Industrial Classification to Organize Industries - ... For example, if we are classifying a company that is in the Dairy business, they would be given a code that the first two digits indicate that they are specifically in the business of Dairy. Then the third digit would specify that they are either in the Cheese or the Yogurt business. This system was established in order to decrease the chances of making a mistake when classifying what type of product an industry is dedicated to. (The North American Industry Classification System in the Current Employment Statistics Program, 2014) SIC codes are used by agencies such as the Census Bureau, Bureau of Labor Statistics, the IRS and Social Security....   [tags: classification, businesses, coding] 1070 words
(3.1 pages)
Better 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]
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]
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]
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]
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]