DVD Direct: Information Systems
Transaction Processing Systems at DVD Direct
Alice: What's a TPS?
Elizabeth: A TPS is a Transaction Processing System. It is a collection of programs that keep track of routine operations and record those operations in a database. The production department's TPS records what movies have been ordered, when they are sent out, and when they are returned. For example, if you needed a report on what movies are available right now, the TPS could provide you with that information. It can also provide the bandwidth data for the past several months that you're interested in. Go see Frank, a supervisor in production. He will help you locate the data you need. His office is located in Building B. Tell him I sent you.
Alice walks down to Building B where all the DVDs for DVD Direct are received, warehoused, packaged, and shipped. Although she knows that DVD Direct ships several thousand DVDs a day, she is still surprised at the size of the operation. Workers scan incoming DVDs into the Transaction Processing System with handheld scanners, while others scan outgoing DVDs. After asking around, Alice finally locates Frank in his office on the second floor.
Alice: Excuse me, Frank? I'm new here. My name's Alice. Elizabeth said you'd help me find some data.
Frank: Hello there, Alice. Elizabeth? Sure thing!
Alice: I'm helping my boss Bob prepare something for Carol for this afternoon. She is looking for some historical data for low and high bandwidth customers for the past year. I'm tracking down the source of data used to calculate these figures here.
She hands Frank the cover page from the Monthly Membership Report and a printout of the formulas that Elizabeth identified.
Alice: As you can see, the formulas reference data in the production database captured by your department's TPS. I was hoping that you could use the TPS to analyze the bandwidths used by new customers over the past twelve months.
For a moment Frank looks at the cover page and the formulas and chews on his pencil.
Frank: So this is the report everyone is talking about. I'm afraid the TPS won't help with the analysis. The TPS stores data on day-to-day activity and current inventory, but it doesn't analyze trends.
Alice: So you don't think we can get the data for the last twelve months?
Frank: We can get the data. Our TPS collects that data automatically from our Web site whenever an order is placed. However, the TPS does not analyze data.
Alice: Can't I use the MIS to analyze the data?
Frank: Not really. Our MIS is designed to produce standardized reports. I suppose you could create an MIS program to analyze the bandwidth data, but that would require more time and money than is necessary. Besides, you only need to do this analysis once . . . not every month. The best way is to use a DSS.
DVD Direct: Information SystemsTransaction Processing Systems at DVD DirectAlice: What's a TPS?Elizabeth: A TPS is a Transaction Processing System. It is a collection of programs that keep track of routine operations and record those operations in a database. The production department's TPS records what movies have been ordered, when they are sent out, and when they are returned. For example, if you needed a report on what movies are available right now, the TPS could provide you with that information. It can also provide the bandwidth data for the past several months that you're interested in. Go see Frank, a supervisor in production. He will help you locate the data you need. His office is located in Building B. Tell him I sent you.Alice walks down to Building B where all the DVDs for DVD Direct are received, warehoused, packaged, and shipped. Although she knows that DVD Direct ships several thousand DVDs a day, she is still surprised at the size of the operation. Workers scan incoming DVDs into the Transaction Processing System with handheld scanners, while others scan outgoing DVDs. After asking around, Alice finally locates Frank in his office on the second floor.Alice: Excuse me, Frank? I'm new here. My name's Alice. Elizabeth said you'd help me find some data.Frank: Hello there, Alice. Elizabeth? Sure thing!Alice: I'm helping my boss Bob prepare something for Carol for this afternoon. She is looking for some historical data for low and high bandwidth customers for the past year. I'm tracking down the source of data used to calculate these figures here.She hands Frank the cover page from the Monthly Membership Report and a printout of the formulas that Elizabeth identified.Alice: As you can see, the formulas reference data in the production database captured by your department's TPS. I was hoping that you could use the TPS to analyze the bandwidths used by new customers over the past twelve months.For a moment Frank looks at the cover page and the formulas and chews on his pencil.Frank: So this is the report everyone is talking about. I'm afraid the TPS won't help with the analysis. The TPS stores data on day-to-day activity and current inventory, but it doesn't analyze trends.Alice: So you don't think we can get the data for the last twelve months?Frank: We can get the data. Our TPS collects that data automatically from our Web site whenever an order is placed. However, the TPS does not analyze data.Alice: Can't I use the MIS to analyze the data?Frank: Not really. Our MIS is designed to produce standardized reports. I suppose you could create an MIS program to analyze the bandwidth data, but that would require more time and money than is necessary. Besides, you only need to do this analysis once . . . not every month. The best way is to use a DSS.
การแปล กรุณารอสักครู่..