Premium Essay

The Pros And Cons Of Database Management Systems

Submitted By
Words 1133
Pages 5
We are in an age often referred to as the information age. In this information age, the belief is that information leads to power and success, and impressively complex technologies such as computers, satellites, etc. are available to help in collecting large amounts of information and data. Initially, with the emergence of computers and the means for mass digital storage, we started collecting and saving all sorts of data, counting on the power of computers to help sort through this mix of information. Unfortunately, these huge collections of data stored on structures that are not similar, very quickly became too much. The production of data is expanding at an incredible rate. Expert now point to a 4300% increase in annual data generation by 2020. In 2007 the estimated information content of all human knowledge was 295 exabyte, CSC predicted that in 2020 data production will be 44 times more greater than it was in 2009. …show more content…
The efficient database management systems have been very crucial assets for management of a huge amount of data, especially for effective and efficient retrieval of particular information from a large collection whenever needed. The wide spread of database management systems has also influenced the recent massive gathering of all sorts of information. Today, we have far more information than we can handle, from business transactions and scientific data, to satellite pictures, text reports and military intelligence. Information retrieval is not enough anymore for decision-making. Faced with huge collections of data, we have now created new needs to help us make better managerial choices. As we make a shift from collecting to connecting data, businesses are searching for relationships between data sets to reveal valuable new insight. How do we then sort this huge chunk of data, how do we find related patterns/relationship between these

Similar Documents

Premium Essay

Rock Bottom Records Proposal

...e-commerce and e-business to economic infrastructure, traditional brick and mortar businesses are finding it difficult to compete with more streamlined businesses that are outsourcing their products and services via the Internet. Streamlining Rock Bottom Records by adding a relational database management system (RDMS) and a website will increase productivity and cost savings by reducing the amount of time it takes for analyzing productivity, ordering and shipping, financial, and payroll. Adding a website with a RDMS and offering digital music downloads the company will be able to compete with other companies worldwide. The most popular affordable RDMS’s that are in use today are Microsoft Access that comes with Microsoft Office (Professional) is popular with most small businesses ("Microsoft Access Database: The Pros With Less Cons When Using Microsoft Access As Your Database", n.d.)., PostgreSQL which runs on multiple operating systems and is an open source database, meaning it is free (“PostgreSQL”, 1996-2012)., MySQL is also an open source database that runs on multiple operating systems ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., MSSQL is a closed, propriety database that works great with Microsoft programs ("Advantages And Disadvantages To Using Mysql Vs Ms Sql", n.d.)., and Fire Bird which works well with Window and is also...

Words: 1026 - Pages: 5

Free Essay

Pos 355 Server Pros and Cons

...Running head: CLIENT SERVER PROS AND CONS 1 Client Server Pros and Cons Henry Ford POS355 October 6, 2014 Mr. Kernan CLIENT SERVER PROS AND CONS 2 Client Server Pros and Cons Computer Networking has a vast amount of attributes. These attributes allow a system to not only function in a specific way but they also add definition to the system which in turn creates a specific identity. One of the identities of a Network is a Client/Server Network. The term "client server" defines a network system where computers known as servers are used. The Servers create central management. This form of management is used to access the network. Each network has a plethora of segments that are used for resources and data storage. These Network applications are used in Commercial applications more so than anywhere else. Since there are a variety of Network configurations, the end user has to determine which one of the specific Network features they want and also to consider the advantages and disadvantages of each system. Even though the Client/ Network architecture is the most desirable for most commercial businesses, there are certain disadvantages in this system. “The reason that client/server computing is still growing in popularity is because top management believes that it will save them money, and end-users believe that it will solve many of their computing problems.” (Windsor, 2011) Client/Server Definition: This type of computing provides the necessary comingling of personal......

Words: 854 - Pages: 4

Premium Essay

Database

...Review of Major DB Concepts • Data and Information – Data: raw facts – Information: processed data • • • • Database Metadata DBMS: Database management system Database system 1 An Example of Data • Sales per employee for each of Xcompany’s two divisions 2 Data and Its Structure • Data is actually stored as bits, but it is difficult to work with data at this level. • It is convenient to view data at different levels of abstraction. • Schema: Description of data at some level. Each level has its own schema. • Three schemas: physical, conceptual, and external. 3 Physical Data Schema • Describes details of how data is stored: tracks, cylinders, indices etc. • Early applications worked at this level - explicitly dealt with details. • Problem: Routines hard-coded to deal with physical representation. – Changes to data structure difficult to make. – Application code becomes complex since it must deal with details. – Rapid implementation of new features impossible. 4 Conceptual Data Level • Hides details. – In the relational model, the conceptual schema presents data as a set of tables. • DBMS maps from conceptual to physical schema automatically. • Physical schema can be changed without changing application: – DBMS must change mapping from conceptual to physical. • Referred to as physical data independence. 5 Conceptual Data Level (con’t) Application Conceptual view of data DBMS Physical view of data 6 External Data Level ...

Words: 1553 - Pages: 7

Premium Essay

Information Technology Management Assignment - Mcmann Cars Company

...issues are communication, data management, security and fragmentation network operation system, supply chain management, obsolescence system, and weather forecasting. Communication issues This is the prioritisation problem faced by the company, there are a plenty of issues which the organisation is facing within this trouble. The very first complication is the geographical dispersion of offices in Europe countries, so that senior managers have to travel around divisions to communicate directly. As a consequence, money and time are being spent inefficiently. In addition, the lack of good intranet with compatible email system is also suffering to internal communication: current systems are introducing unnecessary redundancy which offers incoherent association with other branches. Furthermore, the status of real-time correspondence is not supporting effectively in connecting with suppliers and sub-contractors, this leads to the problem of missing project timeline. Obsolescence systems issues The loss and corruption of data has been experiencing during a period of using times, this could be the potential threat affects directly to business management and operation. Moreover, the current systems do not adequately support emerging trends in working practices such as accessing systems on mobile devices (e.g. smartphone, tablet, so on), the 2 creation of dispersed and virtual project teams. Also, some components of the latest updated systems are...

Words: 3475 - Pages: 14

Premium Essay

Wireless Technologies Proposal

...in the business industry, the team at REI is ready to move forward and maintain its position as one of the industry leaders in outdoor enthusiast gear sales. Proposal: As technology has progressed REI has fallen behind. Large retail companies have followed the wireless technology trend to stay ahead of the curve. REI’s goal is to increase sales, improve inventory management, and customer service through an increased use of technology. Studies have shown that if needs are not met quickly, one in ten customers will abandon a line while waiting. This might cause the customer to leave the store, making them less likely to return in the future. Mobile point of sales (POS) systems can be integrated, using handheld computers, scanners, and printers with integrated credit card readers. During the holidays and high volume periods, sales personnel can be strategically placed throughout the store with these mobile devices. The whole transaction can be completed for customers paying by credit card with receipt printed or emailed, all with never having to stand in a line. A major expense for retailers like REI is management of inventory in the warehouse and on the retail floor. Inventory must be tracked when it arrives to the warehouse, when it is moved to the retail floor, and removed once it has been sold. Accurately tracking this information can reduce out of stock conditions and increase sales and customer...

Words: 650 - Pages: 3

Premium Essay

Lions…Tigers…and Bears: the World of E-Hrm

...Running head: THE WORLD OF E-HRM Lions…Tigers…and Bears: The World of e-HRM Submitted in partial fulfillment of the requirements for the Degree of Master of Science in Management College of Business & Management Cardinal Stritch University November 29, 2011 Abstract Rapid development and expansion of the internet has boosted the realization and application of e-HRM. Technological optimist assume, that from a technical perspective, the IT possibilities for e-HRM are endless: in principal all HR processes can be supported by IT. This paper aims at giving a clear definition of what HRM and e-HRM actually is, as well as the current uses and technologies utilizing the e-HRM concept. This paper will also discuss some of the pros and cons associated with e-HRM from 4 different perspectives: individual, operational, relational, and transformational. Keywords: e-HRM, HRM, technology, management With the rapid development and expansion of the internet the realization and application of e-HRM has intensified. Technological optimist assume, that from a technical perspective, the IT possibilities for e-HRM are endless: in principal all HR processes can be supported by IT. Surveys of HR consultants suggest that both the number of organizations adopting e-HRM and the depth of applications within the organizations are continually increasing. (CedarCrestone, 2005) In addition, there is anecdotal evidence that......

Words: 2326 - Pages: 10

Free Essay

Facility Management

...“Facility Management” is as like as to “Property Management” but usually applied to sizeable or commercial properties where the management and operation is more complicated. The International Facility Management Association defines facility management as a profession that encompasses multiple disciplines to ensure functionality of the buit environment by integrating people, place, process and technology. The facility Management responsibilities are covering a wide range of function and support services likes security, property or building management, engineering services, accounting, postal, computing, information technology system,, staff safety and other supportive duties. Therefore, in business, Facility Management means the management of managing both buildings and services. The services are divided into “hard services” and “soft services”. Hard services including those things like to ensure the building air conditioning is operating in safe and stable mode. For examples, Plumbing and water-works, Spatial planning, Civil and Structural engineering. On the one hand, Soft services including those things like to ensure the building is cleaned and have a regular repair checking with the service contractors says Team-building, Time management. Facility Management is basically a property-based discipline, the objective is to achieve the following operation efficiency. For examples: (i) Property – Maximize the value and minimize risks for those Swire......

Words: 619 - Pages: 3

Premium Essay

Cmis 351 Assignment 1 Essay

...Introduction The purpose of this report is to analyze the Queen’s Inn current reservation system and propose a recommendation for management to move towards an automated system that will increase profit, transparency to management on daily operation and to introduce a solid tracking system of their customers promoting efficiency and accuracy by using Microsoft Access. As a result of utilizing automated advanced database entry system like Microsoft Access, users will be able to generate queries and reports based on their own desires without going through circles or complex steps. Using a database querying system, anyone in management of Queen’s Inn will be able to find out how the business is doing on a daily basis, how many rooms are occupied, average length of stay per guest, what is the average base income in a specific timeframe or season, what room type is rented most and it will identify the strongest customer base they have and more. Background of Queens Inn Queen’s Inn, located in St. John’s, Newfoundland is a thirty rooms hotel. It has thirty rooms with various views such as ten that overlooks the side streets, ten that has ocean view and ten with partial ocean view. Guest rates depends on the type of room they stay in, how long they stay in a room, and the number of guests in a room. Rates varies per room, applying discounts or extra charges to a standard rate. With steady growth, and complete renovation, the inn service expanded to attract other...

Words: 2070 - Pages: 9

Free Essay

Technologies Proposal

...wireless systems will help advance Paper Plates. The first wireless technology is Radio Frequency Identification (RFID) system. RFID is a tracking device to ensure products and supplies are currently in stock, received, and shipped accurately and updated daily. RFID makes counting inventory less expensive because extra cost for inventory labor is eliminated. This system is beneficial because inventory is more accurate and reordering products and supplies are easier to perform. The cost of changing the current system of barcodes to RFID will save money with its accuracy of inventory, reordering items, and theft reduction. The second wireless technology is the installation of Electronic Credit Card Processing. This system requires the installation of computer software called Virtual Terminal that sends credit card information to merchants for processing. Paper Plates Internet website allows customers to browse products but not purchase online. Electronic Credit Card Processing allows customers to place orders and pay online. This technology will increase the number of sales from the website. Although the two wireless technologies are beneficial, there are pros and cons for incorporating each. RFID (Radio Frequency Identification) Pros The system allows scanners to communicate with tags, eliminating the checking and scanning of incoming inventory. The system tracks inventories incoming and distribution, and inventory shrinkage occurring during shipping. The system......

Words: 702 - Pages: 3

Premium Essay

Scare Economic Resource in Uae

...Discuss any economic resource which is scarce in UAE or a well-known country. Then analyze the pros and cons of the government procedures which have been carried out toward this problem. In your opinion, what are the most effective suggestions to solve this scarcity problem? INTRODUCTION: Economic resources are the land, labor, capital and entrepreneurial ability that are combined to produce outputs in order to meet the ever-changing needs and wants of individuals and society as the whole. They earn, rent, wages, interest, and profit, respectively as their resource payments. Good and services that are scarce are economic goods. Scarcity is the basic economic problem that is unlimited human needs and wants, in a world of limited resources. UAE is oil rich country which is in a serious danger of losing its water resource in the coming 50 years. Abu Dhabi is one of the richest emirates swallow around 550 liters of water per day by per person which is comparatively quite more as compare to other countries in the world.UAE government incurs lot of money on the energy cost as desalination plants are set up in order to provide fresh water. Desalination plants costs $18 million a day, apart from this they also have huge environmental impact. The arid climate of the country plays a significant role in the water resources availability. Rainfall, which is a main source of recharge for different water resources, such as surface water and groundwater, is scanty and extremely......

Words: 1521 - Pages: 7

Free Essay

Database Mangement Systems

...IBM DB2 | Microsoft SQL Server 2008 | Operating Systems Supported | Windows Server 2000, 2003, 2003RT, Windows XP Professional, Windows Vista 64 bit and 32 Bit | Oracle Linux, Oracle Solaris, Red Hat, Canonical, Suse, Debian, Windows 8, 7 Vista, XP, Server 2012, 2008, 2003 | Linux, Unix, Windows | Windows Xp, Vista SP2 Windows 7 both 32bit and 64bit | Interface Supported | Oracle Call Interface | Workbench, Navicat, Sequel Pro, HeidiSQL, phpMyAdmin | Control Center, DOS-like interface, Eclipse-based database developers workbench | Multilingual user interface | Stored Procedures | Single ResultOne Result SetTwo Result Set | Single ResultOne Result SetTwo Result Set | Single ResultOne Result SetTwo Result Set | Output parameters, Return codes, A global cursor | Latest Stable Version and Year of Release | 11g Release 2 (11.2.0.4) 2014 | MySQL 5.6.22 2014 | DB2 10 2014 | SQL 2008 R2 SP2 2014 | Advantages | Ability to group several transactions into the same batch. The Real Application Cluster allows multiple servers to work on the same database. | Free open source relation database, active development team. Database-driven application for the internet | Low Cost Platform Per User, Rapid application and warehouse deployment for business growth | Reduce Cost with Virtualization, Simplify Datacenter Management, Improved Datacenter Security | Disadvantages | Cost, difficult to learn and operate | Dose not support a very large database. Does not support ROLE, COMMIT. | Table of......

Words: 479 - Pages: 2

Premium Essay

The Broadway Cafe Case Study

...Porter’s Five Forces & Generic Strategy 4 2.2 Making business decisions II – Customer Order Process 5 3 Customer Relationship Management 7 3.1 Making business decisions II - CRM 7 3.1.1 Extended Strategy 8 3.1.2 New Technologies 8 4 Business Intelligence 9 4.1 Making business decisions II 9 5 Systems Development 14 5.1 Making business decisions II – PYT Business Requirement 14 6 Bibliography 15 Appendix B – PYT Business Requirement for New Payroll System 16 Appendix C - Groupware Tools 20 Figures Figure 1: As-is Broadway Cafe Rich Picture 2 Figure 2: Broadway Cafe Alters Diagram 3 Figure 3: The Broadway Café Five Forces model 4 Figure 4: Customer Ordering Process 6 Figure 5. As-Is payroll system 14 Figure 6. Flow chart payroll system 17 Figure 7: Team ISO Groupware Home Page 20 Tables Table 1: YouTube Pros and Cons 7 Table 2. Comparison of Spreadsheet and Databases 11 Table 3. Wikispaces advantages & disadvantages 20 Introduction This case study addresses the following information systems (IS) concepts for the Broadway Café, as detailed at http://www.cohesioncase.com. • Competitive Advantage - Making business decisions I (Porter’s Five Forces & Generic Strategy • Competitive Advantage - Making business decisions II (Customer Order Process) • Customer Relationship Management (CRM) – Making business decisions II • Business Intelligence – Making business decisions...

Words: 5097 - Pages: 21

Premium Essay

Systems Analysis, Design, and Integration

...Table of Contents System or Application Overview 3 Brief Description 3 Intended Users 3 Project Initiator 3 Requirements Specification 4 Overall Goals 4 Requirements Gathering 4 Functional Requirements 4 Describe nonfunctional requirements 4 Functions and constraints used to frame the scope 4 Application Design 5 High Level Use Case Diagram 5 Functional Decomposition Diagram 6 Class Diagram 7 Sequence Diagram 8 Story Board 8 Test and Quality Assurance Plan 9 Unit Tests 9 System Tests 9 Acceptance Tests 10 Bug Tracking 10 Development Strategy 11 Insourcing 11 Pros 11 Cons 11 Outsourcing 11 Pros 12 Cons 12 Combination 12 Pros 12 Cons 13 Financial Analysis 13 Investment 13 Savings 13 Timing 13 Strategic Fit 13 Economic Impact 13 Operational Model 13 Cultural Fit 13 Risk Management 14 Recommendation 14 Integration and Deployment Plan 15 Work Breakdown Structure 15 References 17 System or Application Overview Brief Description This document will be used to track the Requirements, Design and Implementation of a Time Card System. This system will be used to track the time 20 different employees spend working on different projects. It will also allow managers to run reports allowing them to track time by either employee or project. Intended Users This system will be used by both employees and managers. Employees will need to clock in to the current project, clock out, and change projects...

Words: 3357 - Pages: 14

Free Essay

Logical and Physical Security

...CONVERGENCE OF LOGICAL AND PHYSICAL SECURITY SYSTEMS INTRODUCTION Up to now, majority of organizations have their physical and logical access systems operating as independent structures, with each being run by a totally separate department. The information technology security system, which controls access to information technology infrastructure including mail servers, the internet, database applications and web servers was managed by the department of information technology. The physical security system, which incorporates door access into buildings, systems of life support such as CCTV and Fire, and the badging process of employees, was run by the department of facilities (Mehdizadeh, Y, 2003). Currently, security operations involve the guarding of buildings and equipment in addition to protection of networks, taking care of issues of privacy, and risk management. The interrelation between the aspects of the security initiatives necessitates consolidation of the two security systems. Such a convergence of the IT and physical security functions is important in achieving an efficient security system (Mehdizadeh, Y, 2003). However, such an operation is also lined up with disadvantages. This paper looks at the pros and cons of combining the IT and physical security functions in a medium to large-size firm with complex IT system requirements and a global footprint. It also analyzes the fundamental components of an IT security system and explains how their integration......

Words: 1624 - Pages: 7

Premium Essay

Star Schem & Snowflake Schema

...Hello One and All, In my last Blog we discussed about Dimensional Modelling and some of its components. Today we will go through different Schema that can be used during Dimensional Modelling to create a Data Warehouse. Before we start with today's topic , For my viewers those who are new to this field i would like to revisit some of the key points of my previous blogs: 1) Business Intelligence is mainly divided into three parts as per my understanding a) Data Warehouse design and Implementation (ETL process) b) Data Analysis (Using OLAP cubes) c) Reporting and Dashboard Creation For further details revisit my First blog 2) Important Components involved in Dimensional Modelling or Data Warehouse Designing a) Fact Tables (Additive Facts, Semi-Additive Facts, Non- Additive Facts) b) Dimension Table c) Grain For further details revisit my Second blog After a thorough revision of previous concepts lets start our today's discussion about different Schema involved in Dimensional Modelling or Data Warehouse Designing. First of all i would like to explain the meaning of the topic i.e Snow Covered Wagon Hitched to a Star = SnowFlake Schema and Star Schema are two types of Schema that are used while designing a Data Warehouse, Hence they can be explained as follows: Star Schema: A Star Schema is one of the simplest and easiest schema to understand. A...

Words: 557 - Pages: 3