I need help now with YT

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

Write a program with a loop that lets the user enter a series of positive integers. The user should enter −1 to signal the end o

Fiesta28 [93]

Answer:

import java.util.Scanner;

public class num2 {

public static void main(String[] args) {

Scanner in = new Scanner(System.in);

int count =0;

int total = 0;

System.out.println("Enter the numbers");

int num = in.nextInt();

while(num!=-1){

total = total+num;

count++;

System.out.println("Enter the next number");

num = in.nextInt();

}

//Compute the average

double average = (double) total/count;

//Outputs

System.out.println("Total count of numbers entered "+(count));

System.out.println("Sum of the numbers "+total);

System.out.printf("Average is %.2f ",average);

}

Explanation:

Using java programming language
Import scanner class to receive user input
declare variables count and total and initialize to zero
Prompt user to enter numbers
Use a while statement with the condition while(num!=-1)
Within the while body keep prompting user to enter a number, increase count and update total
when -1 is entered the loop breaks and average is calculated
Use printf() method to print average to 2 decimal places.

5 0

3 years ago

What's the value of this Python expression? ((10 >= 5*2) and (10 <= 5*2))

elena-14-01-66 [18.8K]

Answer:

The Boolean value returned by that expression will be True

Explanation:

We have two logical statements in that expression:

Expression 1: (10 >= 5*2)

This can be read as: is 10 greater than or equal to 5 multipled by 2. This evaluates to true as 10 is equal to 5 * 2. Hence expression 1 returns true

Expression 2: (10 <= 5*2)

This can be read as: is 10 less than or equal to 5 multiplied by 2. This also evaluates to true as 10 is equal to 5*2. Hence expression 2 returns true.

Now between this two expression is the and operator which evaluates to true if and only if both logical expressions returnes true.

True and True ==> True

Since Expression 1 ==> True and Expression 2 ==> True

This means Expression 1 and Expression 2 ==> True which is the Boolean value returned by the statement

5 0

3 years ago

The programming projects of Chapter 4 discussed a Card class that represents a standard playing card. Create a class called Deck

RideAnS [48]

Answer:

Check the explanation

Explanation:

====================Card.java====================

package card_game;

public class Card {

public final static int ACE = 1;

public final static int TWO = 2;

public final static int THREE = 3;

public final static int FOUR = 4;

public final static int FIVE = 5;

public final static int SIX = 6;

public final static int SEVEN = 7;

public final static int EIGHT = 8;

public final static int NINE = 9;

public final static int TEN = 10;

public final static int JACK = 11;

public final static int QUEEN = 12;

public final static int KING = 13;

public final static int CLUBS = 1;

public final static int DIAMONDS = 2;

public final static int HEARTS = 3;

public final static int SPADES = 4;

private final static int NUM_FACES = 13;

private final static int NUM_SUITS = 4;

private int face, suit;

private String faceName, suitName;

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

// Creates a random card.

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

public Card() {

face = (int) (Math.random() * NUM_FACES) + 1;

setFaceName();

suit = (int) (Math.random() * NUM_SUITS) + 1;

setSuitName();

}

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

// Creates a card of the specified suit and face value.

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

public Card(int faceValue, int suitValue) {

face = faceValue;

setFaceName();

suit = suitValue;

setSuitName();

}

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

// Sets the string representation of the face using its stored

// numeric value.

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

private void setFaceName() {

switch (face) {

case ACE:

faceName = "Ace";

break;

case TWO:

faceName = "Two";

break;

case THREE:

faceName = "Three";

break;

case FOUR:

faceName = "Four";

break;

case FIVE:

faceName = "Five";

break;

case SIX:

faceName = "Six";

break;

case SEVEN:

faceName = "Seven";

break;

case EIGHT:

faceName = "Eight";

break;

case NINE:

faceName = "Nine";

break;

case TEN:

faceName = "Ten";

break;

case JACK:

faceName = "Jack";

break;

case QUEEN:

faceName = "Queen";

break;

case KING:

faceName = "King";

break;

}

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

// Sets the string representation of the suit using its stored

// numeric value.

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

private void setSuitName() {

switch (suit) {

case CLUBS:

suitName = "Clubs";

break;

case DIAMONDS:

suitName = "Diamonds";

break;

case HEARTS:

suitName = "Hearts";

break;

case SPADES:

suitName = "Spades";

break;

}

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

// Determines if this card is higher than the parameter. The

// second parameter determines if aces should be considered high

// (beats a King) or low (lowest of all faces). Uses the suit

// if both cards have the same face.

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

public boolean isHigherThan(Card card2, boolean aceHigh) {

boolean result = false;

if (face == card2.getFace()) {

if (suit > card2.getSuit())

result = true;

}

else {

if (aceHigh && face == ACE)

result = true;

else if (face > card2.getFace())

result = true;

}

=========================Sample output=======================

3 0

4 years ago

Which is true about routers and switches?

Julli [10]

Answer:

Routers control traffic between networks while switches control traffic within a network

Explanation:

There are different devices involves in computer networking. These devices include hub, switch, router and other components.

Switch is used to connect the computer with in the network. It controls the traffic between different computers within the network. Different computers are connected with each other through different cables with the help of switch.

On the other hand, different LAN's connected through the cable with a router to communicate with each other. This device is used to control the traffic between different networks.

8 0

3 years ago