What are decision support systems, PL-SQL Programming

(a) What are decision support systems, and what role do they play in the business environment?

(b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile collection of data" in support of management?s decision making process.

(i) Define the term subject-oriented and support your answer with appropriate examples.

(ii) Describe the three important differences that exist between an application oriented system and a subject oriented system.

(c) Data mining is a knowledge discovery process of automated extraction of hidden predictive information from large databases.

(i) Data mining being relatively a new technology, what advantages would an Insurance company achieved for implementing such a
technique? Provide relevant examples

(ii) To better exploit data mining what are the pre-requisites for a data warehouse?

(iii) Discuss the two critical factors which can affect success with the application of data mining technology.

Posted Date: 10/24/2013 5:43:27 AM | Location : United States







Related Discussions:- What are decision support systems, Assignment Help, Ask Question on What are decision support systems, Get Answer, Expert's Help, What are decision support systems Discussions

Write discussion on What are decision support systems
Your posts are moderated
Related Questions
Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus

a. Create a table odetails_new. It has all the attributes of odetails and an additional column called cost, whose values are the product of the quantity and price of the part bein

Disjunction (OR, ∨) Again we have nine rows instead of just four and again, when unknown is not involved, the rows are as for 2VL. Also, when anything is paired with true, t

Advantages of PL/SQL The PL/SQL is a high-performance transaction processing, completely portable language that offers the following advantages as shown: 1) Support for SQL

Use External Routines The PL/SQL is particular for the SQL transaction processing. Therefore, several tasks are more quickly completed in a lower-level language like C that is

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Parameter SELF in pl/sql The MEMBER methods recognize a built-in parameter named SELF that is an instance of the object type. Whether declared explicitly or implicitly, it is