Database Environment

Database Environment Paper DBM-380 November 18, 2012 Introduction A database defines a structure for storing info and it collects information that is organized in such(prenominal) a mood that a computer program hind end quickly lead desired pieces of data. A database apprize also be thought of as anelectronic filingsystem. Data and information argon extracted from a database by creating a interrogative and then(prenominal) submitting it to the query database management system (DBMS) and it is be in a language that exclusively the DBMS can understand.The query can be in the form of a motion or just a keyword and once these queries run against the database, it will find a matching record (Reynolds, 2004) . Database Decisions When building a system for information, you kick in to limit how much responsibility for data management your softw be will fill up. A database can be rather monumental or it can be sm apiece depending on the information that is being stored. Request for information from a database atomic number 18 made in the form of a query or a question asking the database for particular information.All databasemanagement systemsare non the same from a technical standpoint. They differ mostly in the way they organize their information internally. The internal organization can then feel how quickly and supplely the information can be extracted (Jupitermedia, 2011) . Analyzing the use of databases Analyzing the use of databases In the Client Fulfillment part at Tactical Training chemical group Pacifics, there are two databases that are mainly employ and those are the Command Active directory and the Military & international international ampereere civil SME (MC&SME).These databases are very vital to this subdivision because they dish out with the daily drudgery goals. With the use of the dictation directory, it is helpful in finding different associates throughout the organization as well as finding certain departments, telecom municate poesy, mail codes, locations of command tuition centers, and Watch Station machines. When creating a unexampled accountfor a client or associate they must conjure up whether they are an existing client or that they are an associate the command directory is accessed to verify this information in align for them to receive the benefits as an associate.Another wages of the command directory is helping to find other department phone numbers or Watch Station locations. With the command directory database you select the issue that you are calculateing for like associate search, location, telephone number, Watch Station and then you enter your query not in the form of a question but a certain query language that is unders excessivelyd by this database to extract this information. This database relies on the Microsoft SQL server.Another database that is used command is the Military & Civilian Subject proceeds Experts (MC&SME). This database is used to help associates a cross all lines of business to do their job effectively. MC&SME contains processes and procedures for each department to abide by so if you are not sure on how to complete a customer request or the correct information to give to a customer it can all be constitute on MC&SME. MC&SME moulds on structured query language or SQL that it is usually asked a conventionalized question in put to execute and answer.This is a very large database because it contains so many another(prenominal) work procedures and specialists that are very important for each and every department at TTGP Command. Data specifications For TTGP it is important to remember that we have got tether types of people in our database Command Staff, Clients and Subject Matter Experts(SME) for training areas and certifications. The Following entities and attributes will apply relationally to all three areas 1. Command Staff * Name * Address * call in number * incision Name * Supervisor . Client/Customer * Nam e * Address * Phone number * Company Name * Company POC/Supervisor 3. Subject Matter Expert(SME) * SME Name * Company Name * Certifications (Separated By Commas) * Special Training * toll for Services The requirement for this Database is to ensure a check is made relationally for every name or skills to ensure duel entities arent entered. This DB is graduate(prenominal) usage throughout the day and has to backup and saved daily so that repairs upkeep and maintenance can be done by the wickedness IT crew.Database Management/Upkeep Both of these databases, the Command Directory and MC&SME have to be managed and regular maintenance has to be done in order to keep the information up to date. There are so many changes for associate / employee information if they leave the company or switch department or even if a department is no longer surgery all of this information has to be current. With MC&SME, there are so many changes to job procedures qualifications Etc very day in order to minimize fraud or if new products are on the market place and other ones are no longer being offered, MC&SME sends an alert immediately so if it affects your part of production, you will have to analyse it right away and make all necessary changes on how your work is done so the administration of both databases are important in order to take full advantage of the output to the relevant query. Proposing Improvements Improvements that can be done in order to maximize results for both of these atabases are to make them more client friendly. The Command directory could contain less field in order to search for results since the 411information page search and the location search is going to give you the same results and if you are not sure or the correct spelling of an member of staffs name, the sounds like field is not very helpful because it will come back with too many results and you still have to keep looking. MC&SME can definitely be made more user friendly.This is the m ost confound database because if you dont have the proper training it will take hours just to look up simple information. MC&SME involve to be reduced in search / query size in order to maximize retrieval results faster. Conclusion Because this 3 entity with attributes relational Database has such a high operational Tempo we need to ensure that only the critical attributes fields are used. This will help in not only over all DB performance but help with query retrieval speed as well.Keeping the relational processing unavoidable down to a minimum is imperative. Constant upgrades, maintenance along with surety patches are done and need to remain transparent to the user. This database is akin to the lungs that lie life into our command. References Jupitermedia. (2011, Spring). Internal Database Organization. Retrieved from http//jupitermedia. org/DBorg Reynolds, J. N. (2004). Database Structures. PC Magizine, 10(7), 123.