Advantages and Disadvantages of Database Management

In: Computers and Technology

Submitted By Michael51210
Words 631
Pages 3
Michael Cooper
9/11/15
Role in the Database Environment
A database management system is the software system that allows users to define, create and maintain a database and provides controlled access to the data. A Database Management System (DBMS) is basically a collection of programs that enables users to store, modify, and extract information from a database as per the requirements. DBMS is an intermediate layer between programs and the data. Programs access the DBMS, which then accesses the data. There are different types of DBMS ranging from small systems that run on personal computers to huge systems that run on mainframes.
There are a lot of database software manufacturers out there and a wide range of prices, sizes, speeds and functionalities. At the lower end of the scale are personal database software products like Microsoft Access, which is designed to be used by individuals or small companies relatively little data. User friendliness and ease of use are the priority rather than speed and scalability (in other words, it works well when you have 100 records but not when you have 100,000). At the higher end are full-fledged enterprise solutions, such as Oracle Enterprise Edition. These database software products can handle millions of data entries and are fast and efficient. They have ·many optimization and performance tools and generally require a Database Administrator (DBA) to look after them. Products in this range can also be very expensive.
In file system, each application has its own private files, which cannot be shared between multiple applications. This can often lead to considerable redundancy in the stored data, which results in wastage of storage space. By having centralized database most of this can be avoided. It is not possible that all redundancy should be eliminated. Sometimes there are sound business and technical reasons for·…...

Similar Documents

Advantages and Disadvantages of Mac and Windows

...1 Advantages MAC 1. Mac UI is geared towards simplicity. It employs the best possible design principles with its hallmark minimal UI concept that apple has mastered over decades. As a result users have a short learning curve. 2. It is built upon the Unix core which is known for its security features. Its extremely difficult to install a Virus on a Mac unless the user specifically grants it Root privileges. 3. Since 2008 Apple has been updating its Mac OSX yearly with 100s of new user features of which most of them are adopted from its iOS line. Hence, it has seen some phenomenal changes over the last few years iOS was released 4. Apple makes both, the OS and the Hardware. Apple controls every part of it. Since the OS is developed from scratch purely for the hardware, chances of failure and breakdown reduces. Moreover, Apple owns several hundred retail outlets throughout the world that provide various hardware, software and other services which helps shape the customer experience in the end. 5. Since Mac Store was launched it has become the most popular way for users to download and install Applications just like on an iPhone Disadvantages MAC : 1.Since it enjoys a minority share the number of Applications is low. 2. Mac only runs on an Apple hardware so ultimately the options for end users becomes limited. 3. The Support from community is not as vibrant as that of Windows. 4. Mac OS is relatively inexpensive compared to Windows however the cost of the......

Words: 2332 - Pages: 10

Advantages and Disadvantages of the Emr

...Advantages and Disadvantages of the EMR Abstract The use of the Electronic Medical Record (EMR) system has gained popularity within the healthcare organization. It has advantages and disadvantages for both patients and providers. These are discussed as well as regulations of the EMR. Overview of the Electronic Medical Record System The way that records are being kept has changed dramatically within this century. The process of entering data into a simple database has also evolved. The Electronic Medical Record System that health care providers are now using has many advantages and even a few disadvantages compared to the previous ways the information was stored and how it was accessed. Throughout the health care industry there are several different types of software that may be utilized to record a patient’s information. There is a wide range of information stored such as problems, medications and vital signs, notes, procedures, medical history, immunizations, allergies and the list goes on. With all the different information that must be stored, a paper record can become quite thick and important information may not be found easily or even lost forever. Poor penmanship may make the file unreadable and if unclear, mistakes can be costly for the patient. The efficiency of the computer reduces many of the problems of the paper trail. The quality of care a patient receives must......

Words: 945 - Pages: 4

Advantages and Disadvantages of Planning

...Advantages and Disadvantages of Planning Even though planning is very important in achieving the objectives of organizations, it also has its disadvantages. Firstly, the advantages of planning are, the employees will be hard working as they are aware of the directions that need to be achieved. As the planning involves a specific time period and managers are well aware that the objectives will be archived when the time comes. As a result, managers and the employees will work more enthusiastically throughout the period of achieving that objective. With the panning, everyone in the organization knows the objectives, and will be working towards the same direction. When a senior manager sets an objective, the managers automatically starts to establish strategies of achieving that objectives. Planning has a positive impact on both the organization and the individuals. It helps the organization grow and expand while performance of the individuals will improve because of the objectives and work strategies. On the other hand, there are not much disadvantages but it could have negative impact on the organization. As plans some plans are made for a specific time period, existing plans needs to be updated. This would lead to employees to change the strategies as they will be no longer suitable. This could cause an implementation failure in the present plans. Usually plans are made on the assumptions of future occurrence. If the forecast made is wrong, then the planning made based......

Words: 751 - Pages: 4

Advantages and Disadvantages of Computers

...As you know nowadays almost every home, office or school has a computer or even a few of these devices. Anyway, these modern technologies without which lots of people cannot imagine their lives have some advantages as well as disadvantages. To begin with, I would like to comment on the advantages. So firstly, computer gives you the opportunity to access a lot of information about everything not to mention the fact that you can store large amounts of information on the computer in a database. One computer disk can hold the same amount of information as several books. And don’t forget about the fact that computers can do some jobs very quickly. For example, writing some report with charts and diagrams on a computer will take you less time than writing it manually. Computers not only allow doing those jobs faster, but also allow doing them from a distance for example, from home and sending somewhere you need by e-mail. Finally, computer is useful for communication. To my mind there is plenty of communication software which helps you to socialise with your friends, mates as well as with foreigners from all over the world not even leaving your room. On the other hand as any other appliance it has its own minuses. Let’s face the problem that computer becomes old – fashioned very fast after buying it and needs to be replaced. The point is that replacing a computer is quite expensive. The newer the computer is the more you have to pay for it. Not to mention, the costs you have to......

Words: 500 - Pages: 2

Advantages and Disadvantages of Online Shopping

...TermPaperWarehouse.com - Free Term Papers, Essays and Research Documents The Research Paper Factory JoinSearchBrowseSaved Papers Home Page » Business and Management Advantages and Disadvantages of Online Shopping In: Business and Management Advantages and Disadvantages of Online Shopping Recently shopping online has become very popular because of the vast availability of internet. Online shopping is one kind of E-business where one consumer can directly shop over the internet. Ebay and Amazon are the 2 most popular and trusted website for shopping online. Millions of products are sold all over the world through this E-business model. Most of the people prefer to shop online because searching a product online is very easy and relatively less time consuming. Besides products are usually sold at a cheaper price in online. Besides these advantages, Shopping online has got many disadvantages as well. In this Article I will discuss the advantages and disadvantages of Shopping Online. Advantages of online shopping 1. Finding a product online is much more easier than looking for it in the local store. You can search any product easily by using the search engine feature of a online shopping website. But in store you have to look for it until you find it. This is how you can save some valuable time. 2. Now it is very easy to shop online because of the availability of internet every where in the world. 3. You don't have to waste your time......

Words: 395 - Pages: 2

Business Structures; Advantages and Disadvantages

...business. Those activities include conducting research, creating a business plan, securing financing and marketing. Additionally, business owners also have to decide the type of business form that they would like to operate under. There are three main business structures in which entrepreneurs must establish their business. The following paper will detail the three business structures along with the advantages and disadvantages that each hold. Sole Proprietorships The first and most simple form of a business is a sole proprietorship. Within this form of business structure, the owner usually owns and manages all aspects of the business. Additionally, taxes are not paid on a sole proprietorship as a company; instead the owner pays taxes off of the income that is received from the business. As in all business structures, there are both advantages and disadvantages to operating as a sole proprietor. The advantages of sole proprietorships are minimal legal costs of formation; owners have absolute control over decision making and the ease of business sale. The disadvantages of sole proprietorships are all business decisions are the responsibility of the owner, lack of interest for investments and total liability of the business. Individuals that are seeking sole proprietorship would need to conduct a personal assessment to determine if they are fit to handle a business entirely on their own. Partnerships Partnerships are the second form of......

Words: 738 - Pages: 3

Advantage and Disadvantages

...Language. (d) In Life Skills Beginning Knowledge is allocated 1 hour in Grades R-2 and 2 hours as indicated by the hours in brackets for Grade 3. 1.4.2 intermediate Phase (a) The instructional time in the Intermediate Phase is as follows: suBJeCt Home Language First Additional Language Mathematics Natural Sciences and Technology Social Sciences Life Skills Creative Arts Physical Education Personal and Social Well-being total Hours 6 5 6 3,5 3 4 (1,5) (1) (1,5) 27,5 6 CURRICULUM AND ASSESSMENT POLICY STATEMENT (CAPS) LIFE SCIENCES GRADES 10-12 1.4.3 senior Phase (a) The instructional time in the Senior Phase is as follows: suBJeCt Home Language First Additional Language Mathematics Natural Sciences Social Sciences Technology Economic Management Sciences Life Orientation Creative Arts total Hours 5 4 4,5 3 3 2 2 2 2 27,5 1.4.4 Grades 10-12 (a) The instructional time in Grades 10-12 is as follows: suBJeCt Home Language First Additional Language Mathematics Life Orientation A minimum of any three subjects selected from Group B Annexure B, Tables B1-B8 of the policy document, National policy pertaining to the programme and promotion requirements of the National Curriculum Statement Grades R-12, subject to the provisos stipulated in paragraph 28 of the said policy document. total time alloCation Per Week (Hours) 4.5 4.5 4.5 2 12 (3x4h) 27,5 The allocated time per week may be utilised only for the minimum required NCS subjects as specified above, and may not be used for......

Words: 21816 - Pages: 88

Advantages and Disadvantages of a Union

...Advantages and Disadvantages of a Union Abstract This work will describe the advantages and disadvantages of a union for a cashier at Wal-Mart. It will present some ways a union could benefit the cashiers and also ways a union could be harmful to them. Unions could protect the cashiers from the abuse of the company. On the other hand, unions could also abuse in their demands hurting all the employees. Finally, this paper will show my viewpoint on the unions as beneficial or not to cashiers at Wal-Mart. Advantages and Disadvantages of a Union The word union evokes strength. However, when people talk about labor unions, the effects can be both positive and negative. Mathis and Jackson (2011) state, “union is a formal association of workers that promotes the interest of its members through collective actions” (p. 540). Cashiers at Wal-Mart have a lot of responsibility. First of all, they work with cash, products, prices, and, the most important, they work directly with customers providing service. They have a key role in the store. The advantage of having a union at Wal-Mart for a cashier would be that the union would negotiate better pay and benefits for them. Some of the benefits for the cashiers are: 1. Cashiers have to deal with different type of customers and sometimes they encounter difficult situations. With these risks and conditions, a union can protect them from those working conditions and request to keep their work. (Not sure what you......

Words: 683 - Pages: 3

Advantages and Disadvantages of Computers

...Arlette Jimenez 0281024 ESL 024 N02 Irma Sanchez 11.04.14 Advantages and disadvantages of computers Nowadays we can find many advantages about how the computers have given us a lot of help, but what happens when these advantages change our way of life and try to harm us destroying little by little our lives. Let us talk about this controversial topic in two important points. First of all, our everyday life has known a very remarkable development in fact the use of computers technologies became indispensable. This excessive use of it has permitted a considerable growth in different fields, study research and industry. But it renders the human factor less creative, more dependents and it is not friable one hundred per cent. For example, because of computers we can store data and make stay in its original state, like pictures, documents and other things. This was not possible in the earlier time. Because of it, we can store large amounts of data and make this data available for usage at any time we needed it. In addition, the computers also help us work efficiently and save time, they are a good entertainment venue where people can play games, watch movies and listen to music. Despite the huge benefits of computers, it can’t be denied that their disadvantages are also a complicated problem. The computers can have a bad effect to our health, especially our eyes. Seeing computers too often in the long run might causes a lot of optic diseases.......

Words: 408 - Pages: 2

Advantages and Disadvantages of E-Voting

...Advantages & Disadvantages of E-voting An electronic voting system (on-line voting, internet voting) is an election system which uses electronic ballot that would allow voters to transmit their secure and secret voted ballot to election officials over the internet. With the prosperity of internet over the years, inventers start to make the use of electronic voting in order to make the voting process more convenient and raise the participation of the civic. From now on, engineers have repeatedly created new technology to improve the feasibility of electronic voting system. Advantages of e-voting The advocate of electronic voting claims that the convenience, mobility, tally speed, less cost, and flexibility are the main advantages. Following are the descriptions of the advantages. • Convenience : With the well-designed software and system, the voters can simply use his voting equipment with the minimal time and skill to finish the voting process. • Mobility : Voters can cast their votes at a specific polling place, home, or any place in which they can get access to the internet. People can even use the mobile device such as cell phone or PDA to vote. There is no restriction on the location. • Tally Speed : Once the voting time is over,the computer can immediately calculate the result of the election. It is much faster than the traditional ballot counting method operated by people. • Less Cost : Compared to paper ballot voting,electronic voting saves money......

Words: 666 - Pages: 3

Advantages &Disadvantages

...Advantages and Disadvantages of Convention and Concept Advantages of accounting concepts, conventions and regulations. There are many advantages that accounting concepts have on financial statements. Four important accounting concepts that underpin the preparation of any sets of accounts one of which is going concern that helps an account to assume for any future problems that occur in a business. This helps companies to make future plans and gives them time to gather money to sort out any financial problems. Consistency also has an advantage in helping in accounting by users of accounts can make more meaningful comparisons of financial performance. Prudence helps investors sort out financial performance such as future problems and cost of the business before recognising any signs of profits. Accruals also help financial data to be useful for users by all business revenues and cost are recorded in the appropriate statements and at the appropriate time. Conventions also have many advantages in influences financial statements to be useful for investors. Separate entity is one example this convention seeks to ensure that all private transactions and matters relating to the owners are segregated from transactions that relate to the business. This is an advantage because owner’s transactions are kept private. Also they are not mixed with the business finance so that users can clearly see the business financial state. Also materiality is also an important convention in a......

Words: 327 - Pages: 2

B2B Advantages and Disadvantages

... This page intentionally left blank Te n t h E d i t i o n MODERN DATABASE MANAGEMENT Editorial Director: Sally Yagan Editor in Chief: Eric Svendsen Executive Editor: Bob Horan Editorial Project Manager: Kelly Loftus Editorial Assistant: Jason Calcano Director of Marketing: Patrice Lumumba Jones Marketing Manager: Anne Fahlgren Marketing Assistant: Melinda Jensen Senior Managing Editor: Judy Leale Project Manager: Becca Richter Senior Operations Supervisor: Arnold Vila Operations Specialist: Ilene Kahn Senior Art Director: Jayne Conte Cover Designer: Suzanne Behnke Cover Art: Fotolia © vuifah Manager, Visual Research: Karen Sanatar Permissions Project Manager: Shannon Barbe Media Project Manager, Editorial: Denise Vaughn Media Project Manager, Production: Lisa Rinaldi Supplements Editor: Kelly Loftus Full-Service Project Management: PreMediaGlobal Composition: PreMediaGlobal Printer/Binder: Edwards Brothers Cover Printer: Lehigh-Phoenix Color/Hagerstown Text Font: Palatino Credits and acknowledgments borrowed from other sources and reproduced, with permission, in this textbook appear on appropriate page within text. Microsoft® and Windows® are registered trademarks of the Microsoft Corporation in the U.S.A. and other countries. Screen shots and icons reprinted with permission from the Microsoft Corporation. This book is not sponsored or endorsed by or affiliated with the Microsoft Corporation. Copyright © 2011, 2009, 2007, 2005,......

Words: 193467 - Pages: 774

Advantages and Disadvantage of Computer

...changed the way things were made before. For example, a lecture to the students or the presentation of a paper to a Congress are completely different with respect to those of only a few decades ago, when blackboard, transparencies or photographic slides were used. There are many positive aspects of using computers, for example making a talk very attractive. However, there are also negative aspects. In this paper an analysis is presented of advantages and disadvantages I experienced and of consequences of using computers. Advantages and Disadvantages of Computers As you know nowadays almost every home, office or school has a computer or even a few of these devices. Anyway, these modern technologies without which lots of people cannot imagine their lives have some advantages as well as disadvantages. To begin with, I would like to comment on the advantages. So firstly, computer gives you the opportunity to access a lot of information about everything not to mention the fact that you can store large amounts of information on the computer in a database.   One computer disk can hold the same amount of information as several books. And don’t forget about the fact that computers can do some jobs very quickly. For example, writing some report with charts and diagrams on a computer will take you less time than writing it manually. Computers not only allow doing those jobs faster, but also allow doing them from a distance for example, from home and sending somewhere you need by......

Words: 547 - Pages: 3

Advantages and Disadvantages of E-Commerce

...James Davis Advantages and Disadvantages of E-commerce Bus 107 Debra Wilson November 22, 2010 Abstract In today’s economy, business moves at a rapid pace and shows no sign of slowing down. Many of the revolutionary changes that have taken place and supplied this economic engine with fuel are due to electronic commerce. The introduction of the computer into the workplace has brought about manifold changes and seemingly unlimited possibilities for merchants. This new technology offers many advantages for businesses but there are disadvantages as well. Each company must weigh the pros and cons while determining what direction they will take. Advantages and Disadvantages of E-commerce Electronic commerce is a fundamental part of today’s business world. It has undergone many changes since its inception and will continue to do so. The information technology field has always moved rapidly and businesses must align themselves with these changes in order to remain competitive. E-commerce has many advantages and has transformed business, as we know it. Although fewer in number, there are also disadvantages associated with e-commerce. The advantages of e-commerce are great in number and have quite a range of variation. E-commerce is still fairly young but has brought manifold changes in the way business is conducted. Businesses great and small have taken advantage of the new opportunities afforded by electronic transactions. As we move on in the twenty first......

Words: 1937 - Pages: 8

Advantages and Disadvantages of Pursing an Mba

...Advantages and Disadvantages of Pursuing an MBA Advantages and Disadvantages of Pursing an MBA The decision to pursue a Master’s in Business Administration is a difficult, personal decision. In fact, I categorize it as a life changing decision. For instance, this decision is like most major decisions people make. Whether the decision is over buying a home, changing careers, starting a family or buying that dream car, it is usually laced with advantages and disadvantages, pros and cons, and benefits and consequences. Whether or not those advantages and disadvantages are tangible, quantifiable and measurable, most would agree that they exist and they sometimes have life changing affects. For example, some people think that it is a disadvantage to buy a home because it usually results in one securing a long-term loan whereby a monetary commitment is required from the borrower or homeowner. If this commitment is broken or one is unable to pay as agreed, the borrower or homeowner can lose valuable assets, seriously hinder their ability to borrow money in the future and be looked upon by the banking and financial community as a liability or risk. On the other hand, or some of the advantages of buying a home may result in credit worthiness, proves that you are trustworthy, disciplined and according to Weintrub (2010), “gives one a sense of pride in ownership, stability and security” (para. 2.). With the above mention in mind, I will explore my personal advantages and......

Words: 1259 - Pages: 6