We use cookies to give you the best experience possible. By continuing we’ll assume you’re on board with our cookie policy

Huffman Trucking and the Modern Maintenance Database Essay Sample

essay
  • Pages: 4
  • Word count: 1,091
  • Rewriting Possibility: 99% (excellent)
  • Category: database

Get Full Essay

Get access to this section to get all help you need with your essay and educational issues.

Get Access

Introduction of TOPIC

Huffman Trucking is a virtual organization that was founded in 1936 by K. Huffman with a single truck and a trailer. The company grew during World War 2 and forged a relationship with the United States government hauling cargo for them and continues to do so today. They have a substantially larger fleet of trucks and trailers today than when the company was started in 1936. They have grown to 800 tractors (trucks) and 2,100 trailers as well as 260 units of what they call “roll on, roll off” trailers that enable them to move cargo and vehicles for customers across the country and has four facilities spread throughout the United States to service these customers. They state that “every piece of rolling equipment undergoes preventative maintenance every 25,000 miles in their central office’s maintenance facility located in Cleveland, Ohio (Apollo Group, 2003, 2004, 2012)”. In order to keep track of the maintenance schedules of the more than 3,000 units of “rolling equipment” the Huffman Trucking company utilizes a SQL database. In the days before computers, I can take an educated guess at the type of tracking system that they used to keep track of their equipment’s maintenance because when I was in the military the Army was still using a similar system.

Before the use of computers a master log book or spreadsheet at the central maintenance facility where each piece of equipment’s serial number, vehicle part ID, date that it was put in service, last maintenance date, next scheduled maintenance due date, and type of maintenance, and whether or not the vehicle or part is under warranty would be recorded. Additionally, there were probably log books in each truck as well to track similar information so that the truck drivers were aware of the maintenance schedule and any unscheduled maintenance that occurred due to road hazards or equipment failure as well as other part maintenance information stored on other paper log books or large paper spreadsheets (maybe chalkboards or dry erase boards). It is imperative to keep track of this information on each piece of rolling equipment because it is the backbone of this shipping and trucking company (Intuit, 1997-2013). With this antiquated form of data collection, there would not have been a need to keep an information technology department to perform maintenance on the storage media or systems that support how data is entere

d or viewed because that kind of maintenance would be more along the lines of the managers in charge

Sorry, but full essay samples are available only for registered users

Choose a Membership Plan
of the different maintenance departments whether it was supply, mechanics, et cetera.

With the implementation of computers, the whole data storage methods would have been turned upside down. The information would have begun to be entered in a piece of database software and stored digitally as well as the normal logbook that traveled with the driver. Along with the changes bringing in the computers to manage the maintenance schedules would have been a new department entirely – the information technology department, whose job would be to train users, implement hardware and software, and maintain these new systems. These databases would have been updated as technology in hardware and software improved and eventually would bring us to the modern database technology stored on a server, or more likely a SQL cluster – a cluster of servers that provides redundancy to ensure availability and reliability for a critical database (Volonino, Turnban, & Wood, 2013), which can be accessed in real-time by employees working in any of the facilities across the nation as well as by the drivers themselves from laptops in their trucks with a wireless hotspot in the truck and virtual private networking clients installed on the laptops (Laudon & Laudon, 2012)- ensuring that a truck enroute to a maintenance facility for unscheduled maintenance can have a replacement truck dispatched quickly to minimize the delay in service to the customers.

These databases and the ease of access also provides maintenance crews with maintenance history on a per unit basis to know better which parts of the vehicle to pay extra attention to when performing scheduled maintenance. This SQL database is much easier to maintain and back up but requires several specialties in the information technology world to perform upkeep of different systems. These specialties include personnel to build and deploy new PC’s and servers and the software that they run, database specialists to perform maintenance, upgrades, and backups of the database, and a team of network specialists to maintain and expand the network as the company grows. While paper records are still used, they take the form of reports pulled by querying the maintenance database and are much more accurate than the paper records that preceded them and are always in sync and can be accessed by anyone that has authorized access to the maintenance database client application to view the data housed in the database. With technology changing again, Huffman Trucking is looking to consolidate multiple database systems to streamline operations and lower IT maintenance costs by maintaining one central database that houses the company’s information for all systems.

This new information technology system, called an Enterprise Resource Planning (ERP) will fully integrate Huffman Trucking’s major business components from customer sales order, shipping tracking services, bill of lading, and maintenance, HR and driver scheduling, general ledger, accounts payable/receivable, et cetera. The ERP system will enable high level managers to easily view the company status without needing to access multiple databases on several systems as well as allow the separate departments to easily access pieces of data from other departments that they require. This next logical step will once again change the way that the company operates giving it a new opportunity to grow and operate like a well-oiled machine.

Works Cited

Apollo Group. (2003, 2004, 2012). Huffman Trucking. Retrieved 07 06, 2013, from University of Phoenix Virtual Organizations Portal: https://ecampus.phoenix.edu/secure/aapd/CIST/VOP/Business/Huffman//internet/index.asp

Intuit. (1997-2013). A Timeline of Database History. Retrieved 07 06, 2013, from Intuit Quickbase: http://quickbase.intuit.com/articles/timeline-of-database-history

Laudon, K. C., & Laudon, J. P. (2012). Management Information Systems. Managing the Digital Firm (12th ed.). Pearson Education.

Volonino, L., Turnban, E., & Wood, G. (2013). Information Technology for Management (9th ed.). Hoboken, NJ, U.S.A.: John Wiley & Sons, Inc.

We can write a custom essay on

Huffman Trucking and the Modern Maintenance Databa ...
According to Your Specific Requirements.

Order an essay

You May Also Find These Documents Helpful

What is the difference between controlled and...

Controlled redundancy is the state to improve the performance of queries. We want to control redundancy and retrieve the data along with the all the details. By placing all the data together, we do not have to search multiple files to collect this data. In some cases, the DBMS should control this redundancy in order to prohibit inconsistencies among the files. A controlled redundancy is a necessary technique to use redundant fields in a database. When a record showed that is inconsistent with the data file and when the DBMS has no control over this, we have uncontrolled redundancy. An example, of controlled and uncontrolled redundancy, is if you put in a document please enter your name and the input could be numbers, symbols, letter and multiple letters with a maximum of x things. But we could have controlled redundancy and put a rule where we only allow 12 letter...

Database Design

Introduction Every Weekend I rent a Video or DVD from my local videostore in Dungannon, and when I ask about new releases the employee behind the desk sits rummaging through lots and lots of file paper. I can see where they have taken down details of the person renting the filming in one column and in another the film number. I think they would be better off with a computer, so I put that idea to them and they said, "how would a computer help us?" so I would like to give them my answer by designing a database for them that not only is organised but very secure. Explanation of databases and why they would be of use to this system What is a database? A database is a collection of information put together in an organised way so that it is easy to retrieve. The first databases systems...

Database Report

In this report I will show how I created my own database so you can also create your own database following these simple steps that I will guide you through. How to set a Drop down list: How to set the primary key: How to set the Input Masks: How to set the Data Validation: Relationship: I have completed my tables now I need to make a relationship between them, we use relationships to link tables. This is done so that the details in the table can easily link up. The purpose of a Relationships The purpose of a relationship is to link tables together by a specific filed that consists in both tables. I linked the "Costumers Details" table with the "Lending Details" by the "Account no". This is called a one too many relationships because there could be only one "Account no" in the "Costumers Details" table per...

Popular Essays

logo

Emma Taylor

online

Hi there!
Would you like to get such a paper?
How about getting a customized one?