Which of the following is a separate summary worksheet in the same workbook?

Online transaction processing (OLTP) and online analytical processing (OLAP) are similar MIS strategies used to help with busine

Stels [109]

OLTP ( On-line Transaction Processing )

As the name suggests, this system is designed for handling transactions on web applications.

Examples include Banking system.

OLAP ( On-line Analytical Processing )

As per the name, this system is developed for analyzing and reporting functions for web applications.

These systems form a part of data warehousing.

Examples include data mining for Banking system.

OLTP databases undergo ETL operations to form a part of OLAP system. Data from several OLTP database are extracted as per the requirements, transformed ( formatted and cleaned ) to fit the OLAP requirements, and loaded into the OLAP system.

Similarities

• Both OLTP and OLAP are designed for online processing and support web based applications.

• In both systems, processing is done on large scale owing to their online presence.

Differences

• OLTP is designed to handle daily operation. OLAP is designed for decision support.

• OLTP supports data update and data insert operations. OLAP supports data analysis.

• OLTP supports insert, update and delete operations only. OLAP supports data extraction to support decision making process.

• Transactions form the source of data. Several OLTPs form the source of data.

• In OLTP, transactions are shorter in nature. In OLAP, transactions are longer.

• In OLTP, processing time is shorter. In OLAP, processing time is longer.

• Data modification queries are simpler. Data analysis queries are complex in nature.

• OLTP are normalized up to third normal form. OLAP are not normalized.

• Data in OLTP system are frequently modified. Data in OLAP systems are not frequently modified.

• OLTP should maintain data integrity. Data integrity in OLAP is unaffected.

• OLTP stores only current data. OLAP stores historical data.

• OLAP systems must have periodic back up. OLTP back up is achieved by reloading the databases.

The major differences are discussed above to clarify the functioning of both the systems.

8 0

3 years ago

How many tens are there in the number 156? A. 1 B. 15 C. 6 D. 56

dexar [7]

Answer:

15

Explanation:

15 times 10 is 150, therefore there is 15 tens inside 156.

7 0

3 years ago

Read 2 more answers

Here we have a program which is calling the subtract function to calculate the difference between two numbers. The value from th

statuscvo [17]

Answer:

See explanation

Explanation:

Given

The above program that subtracts two numbers and returns the result

Required

Modify the source code to run perfectly

When the given program is tested, it displays

4 minus 10 equals -6

Which is different from the expected output of

10 minus 4 equals 6

Modify

solution = minuend-subtrahend

to

solution = subtrahend - minuend

And that does it.

8 0

3 years ago

Express 0.0005 x 10-4 farads as picofarads

prohojiy [21]

0.0005 x 10⁻⁴ Farad = 0.000 000 05 Farad.
1 pF = 0.000 000 000 001 Farad

Divide them and get 50000 pF.

3 0

3 years ago

Read 2 more answers

The Account class contains a definition for a simple bank account class with methods to withdraw, deposit, get the balance and a

melamori03 [73]

Answer:

I've updated the Account class as per the instructions. The instructions mention "the constructor for this class creates a random account number" although I didn't find where that was. As a result, I created a simple method to generates the account number (located at the bottom of the class). Be sure you understand the changes (highlighted in yellow) and feel free to ask follow-up questions:

Explanation:

//*******************************************************

// Account.java

//

// A bank account class with methods to deposit to, withdraw from,

// change the name on, and get a String representation

// of the account.

//*******************************************************

import java.util.Random; // Used for Random # generator

public class Account

{

private double balance;

private String name;

private long acctNum;

//----------------------------------------------

//Constructor -- initializes balance, owner, and account number

//----------------------------------------------

public Account(double initBal, String owner, long number)

{

balance = initBal;

name = owner;

acctNum = number;

}

// !!!!!! New Constructor !!!!!!

public Account(double initBal, String owner)

{

balance = initBal;

name = owner;

acctNum = generateAccountNumber();

}

// !!!!!! New Constructor !!!!!!

public Account(String owner)

{

balance = 0;

name = owner;

acctNum = generateAccountNumber();

}

//----------------------------------------------

// Checks to see if balance is sufficient for withdrawal.

// If so, decrements balance by amount; if not, prints message.

//----------------------------------------------

public void withdraw(double amount)

{

if (balance >= amount)

balance -= amount;

else

System.out.println("Insufficient funds");

}

// !!!!!! New withdraw() method !!!!!!

public void withdraw(double amount, double fee)

{

double amountWithFee = amount + fee;

if (balance >= amountWithFee)

balance -= amountWithFee;

else

System.out.println("Insufficient funds");

}

//----------------------------------------------

// Adds deposit amount to balance.

//----------------------------------------------

public void deposit(double amount)

{

balance += amount;

}

//----------------------------------------------

// Returns balance.

//----------------------------------------------

public double getBalance()

{

return balance;

}

//----------------------------------------------

// Returns a string containing the name, account number, and balance.

//----------------------------------------------

public String toString()

{

return "Name:" + name +

"\nAccount Number: " + acctNum +

"\nBalance: " + balance;

}

// !!!! NEW PRIVATE HELPER METHOD TO GENERATE ACCOUNT NUMBERS !!!!!

//-------------------------------------------------------

// Returns a random account number between 10000 - 99999

//--------------------------------------------------------

private long generateAccountNumber()

{

Random r = new Random(); // Seed the random number genertor with the system time

return 10000 + r.nextInt(89999); // .nextInt(89999) will return a value between 0 and 89999)

}

8 0

4 years ago