StudentShare
Contact Us
Sign In / Sign Up for FREE
Search
Go to advanced search...

Stored Procedures and Triggers - Research Paper Example

Cite this document
Summary
Stored Procedures and Triggers Date Stored Procedures and Triggers Stored procedure refers to a collection of SQL statements assembled to allow easy data development process (Michael, 2011). While developing a database program, the choice of a programming language to apply is one of the most important considerations, which is driven by the client preferences…
Download full paper File format: .doc, available for editing
GRAB THE BEST PAPER95.8% of users find it useful
Stored Procedures and Triggers
Read Text Preview

Extract of sample "Stored Procedures and Triggers"

Download file to see previous pages

Considering that the operating system running on any computer determines the type of programming language most appropriate for use, then, this can limit database programming on such systems. However, since SQL 2008 can be written in a variety of programming languages, then it is not limited to only one or a few operating systems (Norman, 2007). This is so because, if one programming language is incompatible with the operating system running in a given computer, then a different programming language can be opted for, which is more compatible with the operating system, serving to preserve the data being utilized, and making it possible to utilize similar data in different computer systems.

The other determinant of programming language compatibility is the server software under use in the system where such programming is to be undertaken (Robert, 1996). Therefore, the programming language to be used is determined by the server software that is under use in the system. However, with the ability if stored procedure SQL 2008 to be written in various languages, then, it enhances its compatibility with any sever software, as a different programming language, which is compatible with the software, can be selected and used. . This is a very vital aspect, in that, it allows for the individuals undertaking the programming to incorporate business logic in the database program.

Through the application of various languages, this business logic serves to ensure that the necessity of encoding such logic in the client specific programs is eliminated. Additionally, the possibility of applying multiple programming languages for stored procedure SQL 2008 provides for the consistency of data used, in that it involves the use of similar data that is encoded in different languages, making it possible to preserve the integrity of the data, even though applied under different coding languages (Pratt, 1996).

Any chance of corrupting such data is thus eliminated and the client programs can easily be maintained universal, only that they involve different programming languages, as per the client specification and preferences. The application of various languages under SQL 2008 stored procedure allows for a range of programming and coding that can enhance the protection of the data from SQL injection attacks (Michael, 2011). This makes such databases more stable and thus protected against various vulnerabilities.

The ability of the stored procedure SQL 2008 to be written in various languages is important in database development, in that it enhances the reduction of costs involved in database development (Michael, 2011). Some programming languages are offered as free software, while others are licensed for commercialization. This means that some of the programming language can be obtained and used free, while others must be bought. Due to its ability of being written in different languages, then, it allows for the use of some programming languages that are offered freely, thus

...Download file to see next pages Read More
Tags
Cite this document
  • APA
  • MLA
  • CHICAGO
(“Stored Procedures and Triggers Research Paper Example | Topics and Well Written Essays - 750 words”, n.d.)
Retrieved from https://studentshare.org/information-technology/1453603-stored-procedures-and-triggers
(Stored Procedures and Triggers Research Paper Example | Topics and Well Written Essays - 750 Words)
https://studentshare.org/information-technology/1453603-stored-procedures-and-triggers.
“Stored Procedures and Triggers Research Paper Example | Topics and Well Written Essays - 750 Words”, n.d. https://studentshare.org/information-technology/1453603-stored-procedures-and-triggers.
  • Cited: 0 times

CHECK THESE SAMPLES OF Stored Procedures and Triggers

Application Development and Databases

The capability can be stored with the subject.... The capability can be stored with the subject.... The ACL can be stored with the object or the resource.... All issues will be thoroughly reviewed and al possible solutions will be provided in the light of the case study....
17 Pages (4250 words) Essay

Web Servers and Internet Applications.Client Server Communication.Goodyear (1999)

Client/server is network architecture that separates a client application that generally deals with end user from a server that does the most work.... Each instance of the client software can send requests to a server.... … Client/server is network architecture that separates a client application that generally deals with end user from a server that does the most work....
12 Pages (3000 words) Essay

SQL/PL Database project

For example, triggers in PL/SQL are the special stored programs which are triggered by… triggers run between the issuance of a command and database management action is performed.... There are five types of the triggers which belong to Oracle database 11g.... triggers are also fired in the response to the event of database.... For example, triggers:triggers in PL/SQL are the special stored programs which are triggered by the use of events for the given program....
1 Pages (250 words) Essay

Structured Query Language Database

In the new data model the customer information is subsidiary to sales information, the trigger is identified as “for each statement type” and is an additional data set for the salesperson each time the tour booking triggers the event.... The normalization process will be done in two phases i....
3 Pages (750 words) Essay

The Attack of Pearl Harbor

They include tables, queries, forms , reports, indexes, view, stored procedures and This paper and exposition would thus analyze and contextualize the main components of a database set.... The term database in the simplest and most basic sense refers to the whole body and unit of information which is used to collect and ratify data and information that is collected....
3 Pages (750 words) PowerPoint Presentation

Comparing between Database Systems

It contains data and other objects such as indexes, views, stored procedures, and triggers defined to support external applications data manipulation activities.... … Handling Multimedia Data: A comparison between leading RDBMS MS SQL, ORACLE, and IBM DB2Comparing or finding the advantage and disadvantage among the leading RDBMS particularly in handling multimedia data is not an easy task....
10 Pages (2500 words) Essay

Motivation for Building a Business Logic Layer Using PL/SQL

The procedures are grouped in packages making accessibility and modification easier.... The well defined SQL/PL procedures make it modular and flexible thus enabling implementation of new features and upgrading of the system is easy.... Instead, the translations are stored in the database.... he other benefit of a business logic layer is that a file system is not needed since all information and business logic is stored in the database in the form of PL/SQL....
19 Pages (4750 words) Thesis

Oracle Database Management System and the Object Oriented Data Model Overview

… Stage IHorizon Tech University established with the vision of building technical capacity has the sole objective of offering quality technical education and opportunity for further intellectual development consisting of undergraduate and post Stage IHorizon Tech University established with the vision of building technical capacity has the sole objective of offering quality technical education and opportunity for further intellectual development consisting of undergraduate and post graduate courses....
14 Pages (3500 words) Coursework
sponsored ads
We use cookies to create the best experience for you. Keep on browsing if you are OK with that, or find out how to manage cookies.
Contact Us