Running Header: 77583863 DISCUSSION QUESTIONS 1
Discussion Questions 1
Discussion Questions 1
1. Poolet’s (2006) article discusses the usefulness of lookup tables in a relational database. What is a lookup table? Discuss at least two ways that lookup tables are useful. Support your answers with real or hypothetical examples from your own workplace.
Lookup table
Lookup table is an interesting excel data structure, involves an array of data that is applied in storing computations, where the time to look them up in the array is much lesser than computing them. It is used when an input data is compared to a list of data in an array. It is more essentially used in databases that have huge amounts of data as well smaller databases. Its adds value to the data being accessed.
Importance of Lookup table
The main importance of the lookup table is its speed. The amount of time that is applied in acquiring data from a list is shorter than computing the data using an algorithm, and they are quite relevant in the maintenance of integrity of data, according to the quality of products produced in Chicago Rivet & Machine Co., when an electronic inspection is done of the records for the Control Plan Production Lot it is recorded and an audit of the sample size as well as frequency is done at a relatively faster and reliable manner (Rivet, 2008). The data that is stored are quite reliable for an audit to take place as they are correct and not tampered with. The company is similarly able to access its files easily by just inserting the file type, prior to (YYYYMMDD) and the selection of the ownership as well as the limit one desires per page. This is a relatively easier method to use when trying to access a record faster. The company is similarly able to respond to the customer’s concerns and complaints at a faster rate. The client is considered important and every step to maintain their loyalty is done at a quicker pace.
2. SQL is often used as a tactical tool to provide operational reports. Provide examples of tactical information that a company could retrieve using SQL.
SQL
SQL is a structured query language that manages data in a relational database. It is quite relevant in companies that use huge amount of data and needs to only access certain sections of the database. Lookup makes this faster at the same time maintaining its integrity, flexibility and scalability. There are several methods are used to manage data, one can; insert, query, update and delete. Data in the Chicago Rivet & Machine Company is recorded in a much more efficient manner. When one desires to conduct an audit of the company, SQL can access the data through the use of appropriate queries. Any subsequent addition to the company has to be reciprocated in the database through an update using the SQL. Removal of any data is similarly easily done using the delete clause.
SQL is a server query language that applies technical methods to retrieve tactical information from a company. The tactical information must possess quality of service, as well as a good information management that is performed in environmental and operational constraints like perfect network connectivity, small bandwidth, limited CPU and battery strength. Companies apply several techniques to acquire queries from the application layer. Audio information is retrieved from the radio-communication layer and sends them to a mobile device. Video or otherwise imagery information can also be acquired through the application of these tactical methods.
There are additionally certain technologies that use applications to retrieve this data; there is the tactical information middleware that uses SQL (Xu Bo et al. n.d. ). There is the OMG Data Distribution Service (DDS) technology which uses the DOD applications. High levels of quality of service are applied in the whole process so as to produce quality information. They are more so applicable in vehicles, mobile devices among other devices.
Bibliography
Poolet, M. A. (2006, February 8). Designing for Performance: Lookup Tables. SQL Server Magazine, p. 33.
Rivet, C. (2008). Chicago Rivet & Machine Company. Retrieved June 28, 2011, from http://www.chicagorivet.com/quality.html
Xu Bo et al. (n.d.). A Tactical Information Management Middleware for Resource-constrained Mobile P2P Networks. Retrieved June 30, 2011, from http://www.google.co.ke/search?q=tactical+information+to+be+retrived+using+SQL&ie=utf-8&oe=utf-8&aq=t&rls=org.mozilla:en-US:official&client=firefox-a
