Database Management System In An Organization

Data junior-grade Management System In An OrganizationA selective in chance variableationbase wariness corpse Database Management System is a commercial softw be program utilise to ascendancy, manipulate and maintain the Database by enabling intakers to admittance, barge in, organize, modify, retrieve, secure and provide impartiality of cultivation in a entropybase.A DBMS accepts request from users or lotions and instructs the operating scheme to transfer the appropriate entropy as shown in the diagram below.Figure 1 selective informationbase wariness(Source http//broncu.blogspot.com/2010/04/dbms-mysql.html)Wikipedia (2011) defines Database Management System as a set of computer programs that looks the creation, maintenance, and the use of a database. It allows arrangings to place control of database development in the hands of database administrators (DBAs) and other specialists. A DBMS is a system softwargon package that patrons the use of integrated collection o f data records and shows known as databases. It allows different user application programs to easily access the same database.DBMSs whitethorn use any of a variety of database models, much(prenominal) as the net dally model or relative model. In hulky systems, a DBMS allows users and other softw ar to store and retrieve data in a bodily structured way. Instead of having to write computer programs to commit information, user better go on ask simple questions in a wonder language. Thus, many another(prenominal) DBMS packages provide Fourth-generation programming language (4GLs) and other application development features. It helps to specify the logical organization for a database and access and use the information within a database. It provides facilities for controlling data access, enforcing data integrity, managing concurrency, and restoring the database from backups. A DBMS also provides the ability to logically contribute database information to users.ExamplesMicros oft Access, My SQL, Microsoft SQL horde, vaticinator and FileMaker pro are all examples of database focussing systems. (Wikipedia, 2011).Microsoft AccessMicrosoft Office Access, previously known as Microsoft Access, is a relational database management system from Microsoft that combines the relational Microsoft jet database Engine with a graphical user interface and software package-development tools. It is a member of the Microsoft Office suite of applications, included in the Professional and high editions or sold separately. In mid-May 2010, the current version Microsoft Access 2010 was released by Microsoft in Office 2010 Microsoft Office Access 2007 was the prior version.My SQLMySQL is a relational database management system that safaris as a server providing multi-user access to a number of databases. It is named after developer Michael Widenius daughter, my. The SQL phrase stands for Structured Query Language.Microsoft SQL ServerMicrosoft SQL Server is a relational mo del database server lay downd by Microsoft. Its primary oppugn languages are T-SQL and ANSI S SQL.OracleThe Oracle Database (commonly referred to as Oracle RDBMS or simply as Oracle) is an object-relational database management system (ORDBMS), produced and marketed by Oracle Corporation.FileMaker ProFileMaker Pro is a cross-platform relational database application from FileMaker Inc., formerly Claris, a ancillary of Apple Inc. It integrates a database engine with a GUI- base interface, allowing users to modify the database by drag new elements into layouts, screens, or forms.AdvantagesSingh (2009) illustrates advantages and disadvantages of DBMS. A true DBMS offers several advantages over file processing. The principal advantages of a DBMS are the followings Flexibility Because programs and data are independent, programs do not convey to be modified when types of uncorrelated data are added to or deleted from the database, or when physical computer reposition changes. disru ptive solvent to information requests Because data are integrated into a undivided database, complex requests can be handled much much rapidly so if the data were located in separate, non-integrated files. In many melodic linees, faster response means better customer service. Multiple access Database software allows data to be accessed in a variety of ways ( much(prenominal) as finished various key fields) and often, by using several programming languages (both 3GL and nonprocedural 4GL programs). dispirit user training costs Users often find it easier to learn such systems and training costs whitethorn be reduced. Also, the total time interpreted to process requests may be shorter, which would increase user productivity. Less storage Theoretically, all occurrences of data items need be stored only once, on that pointby eliminating the storage of redundant data. System developers and database practiceers often use data normalization to minify data redundancy.Warehouse of information, where large data can be stored. overbearing storage meaning data can be stored in the form of tables.Change of schema meaning it is not platform dependent tables can be edited to add new mavens without hampering the applications.No language habituation meaning use of various languages on various platforms.Table joins meaning data can be in two or much tables and can be put into one table this enables easy retrieval of data.Data security meaning DBMS secures all your data.The data license and expeditious access of dataEasy in data face or data management.Provides concurrent access, recovers the data from the crashes.DisadvantagesA database system for the most part provides on-line access to the database for many users. In contrast, a conventional system is often designed to meet a specific need and and so generally provides access to only a small number of users. Because of the bigger number of users accessing the data when a database is apply, the green ligh t may involve redundant risks as compared to a conventional data processing system in the following areas.Confidentiality, privacy and security.Data quality.Data integrity.Enterprise vulnerability may be higher.The cost of using DBMS.Confidentiality, Privacy and tributeWhen information is centralized and is made available to users from remote locations, the possibilities of abuse are often more than in a conventional data processing system. To reduce the chances of unauthorised users accessing sensitive information, it is necessary to take technical, administrative and, possibly, legal measures.Most databases store valuable information that must be protected against deliberate trespass and destruction.Data QualitySince the database is accessible to users remotely, adequate controls are needed to control users updating data and to control data quality. With increased number of users accessing data directly, there are enormous opportunities for users to damage the data. Unless th ere are sufficient controls, the data quality may be compromised.Data IntegritySince a large number of users could be using a database concurrently, technical safeguards are necessary to ensure that the data remain correct during operation. The main little terror to data integrity comes from several different users attempting to update the same data at the same time. The database therefore demand to be protected against accidental changes by the users.Enterprise VulnerabilityCentralising all data of an opening move in one database may mean that the database becomes an indispensible resource. The survival of the enterprise may depend on reliable information being available from its database. The enterprise therefore becomes vulnerable to the destruction of the database or to unauthorised modification of the database.The represent of using a DBMSConventional data processing systems are typically designed to run a number of well-defined, pre-planned processes. Such systems are oft en tuned to run businesslikely for the processes that they were designed for. Although the conventional systems are unremarkably fairly inflexible in that new applications may be sticky to fulfill and/or expensive to run, they are usually very efficient for the applications they are designed for.The database approach on the other hand provides a flexible alternative where new applications can be developed comparatively inexpensively. The flexible approach is not without its costs and one of these costs is the extra cost of running applications that the conventional system was designed for. Using standardised software is almost always less machine efficient than specialized software.Cost of hardware and software meaning having to upgrade the hardware used for file based system it is very costly.Cost of data spiritual rebirth meaning its costly to convert data of data files into database and go through to pursue database and system designers.Cost of staff training meaning or ganization has to be aid a lot of amount for the training of staff to run dms.Database damage meaning all data stored into a single file if database is damaged due to electric failure or database is corrupted on a storage media meaning all valuable data may be lost forever.It also takes a lot of time and move to get DBMS started.Benefits of a Database Management System in an organizationAs discuss by the Ezinearticles (2011), organizations often times find themselves in a dilemma on how they can effectively serve the needs of their members. At the same time, they also enter a situation wherein there is difficulty in handling data, given the sheer volume of information. more(prenominal) often than not, the results of these instances are not anything but desirable confusion, chaos, mismanagement, lost bureau by members, etc.To solve these problems, organizations turn to information technology (IT) experts for answers. With many years of experience in coming up with solutions for b usinesses and other entities, IT professionals have what it takes to come up with an effective data management and accreditation system that impart be used by organizations. thither must also be enhanced accessibility to the said system, which means that members from other locations can motionlessness gain entry into the system, regardless of elements such as time and geography. investment on the go of IT consultants is, however, not like buying something from a store. It entails farseeing sums of money to come up with a good data management and accreditation system for an organization, aside from engaging the professional services of IT experts. Fortunately, IT experts can help minimize the cost through the creation of a database system based on existing resources being held by the organization.Investing on the services of IT experts and having a good data and accreditation management system may count to be too costly, but the long-term benefits are worthy to be seen. By havin g a good database system, it will be much easier for organizations to deal with their members because of enhanced access to information. The placement of additional pieces of information can be done better if there is a good data management system.Having a good data and accreditation management system empowers members of an organization. This is possible because they have the ability to gain the necessary information about things that matter to them as members. They conduction of business with the organizations intervention is made faster and more efficient if a good data management system is in place.There is no reason for organizations to hesitate when it comes to investing on a good data and accreditation management system. The long-term benefits of having one are far greater than the costs, and will be very helpful to the organization and their members in the long run.Improved strategic use of corporate data. cut down complexity of the organizations information systems environme nt.Reduced data redundancy and inconsistency.Enhanced data integrity.Application-data independence.Improved security.Reduced application development and maintenance costs.Improved flexibility of information systems.increase access and availability of data and information.(Blurtit, 2011).Prospects in DBMS and Career OpportunitiesThe work of a database administrator (DBA) varies according to the nature of the employing organisation and the level of obligation associated with the post. The work may be pure maintenance or it may also involve specialising in database development.Prospects, the UKs official career website (2011) states that jobs available in this field areSenior Database ArchitectDatabase Architect design and builds database structure and objects that trump support operational and analytics application. Tests and debug physical database objects for performance and troubleshooting.* convention and implement optimal star and snowflake schema in the database* commune and collaborate with group members and management on the designed database structures and schemas* Write and present eloquently with the appropriate audience perspective in mind* erect troubleshooting of payoff issues of existing application as warranted* Participate in collaborative discussions with team members to monitor progress against enhancement queue and bug resolution.* bewilder proactive in identifying potential risks/issues due to the overall application design and watch recommendations.Database AdministratorThis position requires a Top Secret Security Clearance. This position will support a US Air describe Contract. The successful candidate will be responsible for planning, coordinating and administering computerized databases, including base interpretation, structure, documentation, long and short range requirements, operational guidelines, protection and logical-physical database design. Formulates and monitors policies, procedures and standards relating to datab ase management. Identifies, evaluates and recommends relevant COTS software tools. Collaborate with software engineers, security administration, computer operations, network management and system administration to ensure quality and integrity of databases, application software and data. responsible for(p) for performance monitoring, database.Database Architect SpecialistDatabase Architect design and builds database structure and objects that best support operational and analytics application. Tests and debug physical database objects for performance and troubleshooting.* Design and implement optimal star and snowflake schema in the database* Communicate and collaborate with team members and management on the designed database structures and schemas* Write and present eloquently with the appropriate audience perspective in mind* Support troubleshooting of production issues of existing application as warranted* Participate in collaborative discussions with team members to monitor pro gress against enhancement queue and bug resolution.* Stay proactive in identifying potential risks/issues due to the overall application design and make recommendations.Database Administration ConsultantEvaluates new database technologies and tools, sets database system and programming standards, applies database technology to business problems and manages the development and production database environments with emphasis on security, availability and performance. Provides database services in compliance with all audit and regulatory requirements. The ideal candidate must be experienced in the management of Oracle E-Business 11.5.10.2 including installation, upgrade, patching, cloning, backup and recovery, monitoring, tuning, security, and definition of procedures for custom development. The ideal candidate must be experienced in the implementation and management of Oracle E-Business 11.5.10.2 as configured for the Oracle wide Availability Architecture.Senior Database EngineerRespo nsible for requirements analysis, software development and installation, integration, evaluation, enhancement, maintenance, testing, and problem diagnosis and resolution. Qualifications Bachelors degree with ten (10) years experience as a Database Engineer in developing relational database software and experience with one or more relational database products. Preferred Additional Skills Possess organizational and management skills, along with the ability to respond to crises objectively. Understanding of the current database management system releases.ConclusionThe document that we have put together is a group assignment that was done by four individuals. Some of the problems that we go about as a group are that, we couldnt meet due to our clashing schedules others are busy with other obligations. We would like to say that we tried to produce the best group work that we could, hopefully learnt from this experience to better ourselves for our succeeding(a) endeavors.