Premium Essay

Cloud Database Management System

In: Computers and Technology

Submitted By harikv
Words 3594
Pages 15
Cloud Database Management System
IS508E group NO.6 project

Group NO.6 members: PENG Yu KALAI Kumaraguru KUTTIKKAT VENUGOPAL Sreehari

Contents
General business case ............................................................................................................... 1 Introduction and problems ....................................................................................................... 1 The existing technology ............................................................................................................ 2 Challenges of Implementation: ................................................................................................. 9 Reference: ............................................................................................................................... 10

General business case
Thanks to the successful management, the business of the company expands very fast. However, the database management system cannot withstand the quickly and greatly increased work load, the break-down frequency increases, which make the decision-making efficiency and customer experience drop. The company tries to turn around this bad trend and poses two solutions: one is to update the present DBMS including hardware, software and human resource; the other one is to make use of SQL Azure from Microsoft to set up cloud environment and transfer the DBMS there. After cost analysis, we find that to reach the same efficiency standard, the cost of first solution is 9 times of the second solution, and the second solution has merits such as capability, flexibility and elasticity, so we suggest implementing the second solution: Cloud DBMS, SQL Azure.

Introduction and problems
We are an express company in North America. We transport the parcels for customers. We have good performance and with the blooming online shopping, our business...

Similar Documents

Premium Essay

Cloud Database

...International Journal of Database Management Systems ( IJDMS ) Vol.5, No.2, April 2013 CLOUD DATABASE DATABASE AS A SERVICE Waleed Al Shehri Department of Computing, Macquarie University Sydney, NSW 2109, Australia waleed.alshehri@students.mq.edu.au ABSTRACT Cloud computing has been the most adoptable technology in the recent times, and the database has also moved to cloud computing now, so we will look into the details of database as a service and its functioning. This paper includes all the basic information about the database as a service. The working of database as a service and the challenges it is facing are discussed with an appropriate. The structure of database in cloud computing and its working in collaboration with nodes is observed under database as a service. This paper also will highlight the important things to note down before adopting a database as a service provides that is best amongst the other. The advantages and disadvantages of database as a service will let you to decide either to use database as a service or not. Database as a service has already been adopted by many e-commerce companies and those companies are getting benefits from this service. KEYWORDS Database, cloud computing, Virtualization, Database as a Service (DBaaS). 1. INTRODUCTION A database can be accessed by the clients via the internet from the cloud database service provider and is deliverable to the users when they demand it. In other words, cloud database is......

Words: 5162 - Pages: 21

Premium Essay

Fosbap

...YFOSBAPP Database A database is information organized in such a way that a computer program can quickly select pieces of data. You can think of it as an electronic filing system. A database is an organized collection of data. It is the collection of schemas, tables, queries, reports, views and other objects. Data Integration Data integration involves combining data residing in different sources and providing users with a unified view of these data. This process becomes significant in a variety of situations, which include both commercial (when two similar companies need to merge their databases) and scientific (combining research results from different bioinformatics repositories, for example) domains. Data integration appears with increasing frequency as the volume and the need to share existing data explodes. It has become the focus of extensive theoretical work, and numerous open problems remain Existing DBMSs provide various functions that allow management of a database and its data which can be classified into four main functional groups:  Data definition – Creation, modification and removal of definitions that define the organization of the data.  Update – Insertion, modification, and deletion of the actual data.  Retrieval – Providing information in a form directly usable or for further processing by other applications. The retrieved data may be made available in a form basically the same as it is stored in the database or in a......

Words: 4053 - Pages: 17

Premium Essay

Database Systems for Business

...How can Play On Toys ensure its information technology systems are ready for growth? Issue: Play On Toys has enjoyed 5 years of success in the European market, experiencing strong growth, particularly in the past year, increasing its staff from 16 to 60 employees. With 200 customers, Play On Toys fulfils 3000 orders annually, with a turnover of 5million Euro and 1.4 million in pre-tax profit. Having expanded its range from 2 to 20 products, Play On Toys now works with 30 suppliers to acquire the 110 parts required to manufacture its wares. Expansion into Asia, Africa and America is planned over the coming three years, with the accompanying growth and challenges of moving into new markets and expanding the operation, Play On Toys is at a critical junction. Ensuring that internal systems are functioning at highest efficiency and are prepared for growth are essential elements for the continued success of Play On Toys. Currently, records and information for critical areas including sales, financial, production, and customer relations are held in isolated electronic and paper files as well as some small databases. Essential reporting and transaction processing are highly dependent on manual inputs. Critically, sales orders submitted via the website must be manually processed by sales administrators in a process requiring printing orders and entering them into a spreadsheet manually. The current system of record keeping and reporting lacks cohesion and efficiency, and......

Words: 3888 - Pages: 16

Premium Essay

Design and Applied Research of the Distributed Real-Time Database in Smart Grid

...Design and Applied Research of the Distributed Real-time Database in Smart Grid Chunfeng Liu, Yan Jiang, Feng Zhao, Qiao Sun, Yang Zhang, Zhiqi Li, Chao Li Beijing Guodiantong Network Technology Company Ltd., No.1 Hangfeng Road, Fengtai District, Beijing, 100070, China {liuchunfeng, jiangyan, feng_zhao, sunqiao, zhangyang2, lizhiqi, lichao3}@sgepri.sgcc.com.cn database. Both timing constraints and data consistency should be taken into consider in real-time database systems when scheduling the transactions so that they can be accomplished by their corresponding deadlines[3]. For instance, both the query and update on the acquisition data of smart electricity meters, mainly working for the calculation of the multistep electricity price and electricity increment, must satisfy not only the database consistency constraints but also the time constrain, processed within the given deadlines. Apart from the time constraints that are out of the demand of continuously data tracking, timing correctness requirements are also proposed due to the need to keep data available for the decision-making activities of the controlling systems[4]. Based on these situations, real-time databases are used in a wide Keywords— Distributed, real-time database, smart grid, typical range of applications in the power industry. applications, electric energy data acquire system At the same time, the electricity data also has astounding I. INTRODUCTION quantities. In China, the scale of the data points in......

Words: 4176 - Pages: 17

Premium Essay

Data Administrator for Department Stores

...STRATEGY PLAN FOR DATABASE SYSTEMS DATABASE ADMINISTRATOR FOR DEPARTMENT STORE (TECHICAL PAPER) ANDREW L. PASSIE STUDENT Dr. HOSSEIN BESHARATIAN PROFESSOR CIS 515 STRAYER UNIVERSITY September 6, 2013 SUMMER Page 1 STRATEGY PLAN FOR DATABASE SYSTEMS ABSTRACT We are also going to discuss a Technical paper on Database Administrator for Department Store. We should know that a Database Administrator is the person who is responsible for planning, organizing, controlling, and monitoring the centralized and shared corporate database. The DBA is the general manager of the database administration department. We are also going to discuss the potential sales of the department store transaction within a database, evaluation of all relationships of the database solution using the Crow Foot notation, justifying that Big Data tools could be used for forecasting sales and inventory of the department store, the SQL functions to help sales predictions, implementing cloud-hosted solution for a database in the cost involved and pricing structure required,......

Words: 4277 - Pages: 18

Premium Essay

Test

...Week 1: Information Systems in the Digital Firm - Lecture | | | Information Systems in the Digital Firm Evolution | Current State | Trends | Tutorial The Evolution, Current State, and Trends of Information Systems In addition to the material currently described, an introduction to cloud computing and user involvement in IT projects also will be included in this lecture. This is required as foundational knowledge for the chapters to come. We will explore it at a business level and a minimal technical level. | | Evolution | | The business landscape has changed over the past seventy years in every significant way. Without information systems, these changes would not have occurred. To gain a perspective on the evolution of information systems, we can review the significant computer inventions from the first computer through to cloud computing. As computer technology progressed, new skills had to be learned, and new methods of management evolved to replace old hierarchical styles with new team based methods. Increased productivity resulting in new information technology caused the downsizing of employees that began in the late 1980s and has continued. Information systems consultants identified productivity gains, so large that they cut the numbers in half and still weren't believed. Many of the products and services we use every day had not been invented just five or ten years ago. The ability to communicate electronically with anyone anywhere in the......

Words: 5656 - Pages: 23

Premium Essay

Database Systems Cornel/Morris Chapter 1 Summary

...Chapter 1 Database Systems Why Databases? * At the heart of all of these systems are the collection, storage, aggregation, manipulation, dissemination, and management of data * Databases are specialized structures that allow computer-based systems to store, manage, and to retrieve data very quickly Data vs. Information * Data – raw facts * Raw indicates that the facts have not yet been processed to reveal their meaning * You transform the raw data into a data summary * Information – the result of processing raw data to reveal its meaning * Data processing can be as simple as organizing data to reveal patters or as complex as making forecasts or drawing inferences using statistical modeling * To reveal meaning, information requires context * Raw data must be properly formatted for storage, processing, and processing * Ex: dates must be stored in Julian calendar formats and yes/no responses must be converted to Y/N or 0/1 * Data are the foundation of information which is bed rocked of knowledge * Knowledge – body of information and facts about a specific subject * Knowledge implies familiarity, awareness, and understanding of information as it applies to the environment * A key characteristic of knowledge is that “new: knowledge can be derived from “old” knowledge * Key Points: * Data constitute the building blocks of information * Information is produced by......

Words: 2824 - Pages: 12

Premium Essay

Geoupnet Paper

...expenses of $1.5 million annually by 30%. Suggest for the company: GROUPNET.Inc Composed of three personnel, the Section supports IT requirements for Physical Plant Division system needs. With one of the most advanced IT hardware/software complexes on campus, the system operates fifteen servers operating on UNIX, Linux and WindowsNT platforms. Support is provided for mission critical applications running in the Oracle, SQL and MS Access database systems. Training programs are coordinated with the Training Officer for all personnel. Daily support is provided for basic PC operation, system usage, network management, and database management. The Section works closely with OIT to improve areas of operation which may be lacking, and provides input for future Campus IT initiatives. The current network includes 125+ PCs and 35 printers which all tie into the University backbone. Current projects include TimeTracker, an electronic interface allowing card swipe time to be recorded in both Peoplesoft and the internal Plant work management system EMPAC Echelon Services If you need a flexible, cost-effective cloud for delivering computing power, cloud services from Echelon can be your ideal solution. Let Echelon Synaptic Compute as a Service help you, we are able to build your virtual private cloud in a highly secure network. We’ve designed synaptic compute as a service with Vmware, vCloud, and Datacenter Service for you. Providing quick, secure access to virtual......

Words: 599 - Pages: 3

Premium Essay

File Organization Terms and Concepts

...FILE ORGANIZATION TERMS AND CONCEPTS THE DATA HIERARCHY A computer system organizes data in a hierarchy that starts with bits and bytes and progresses to fields, records, files, and databases * A bit represents the smallest unit of data a computer can handle * A group of bits, called a byte, represents a single character, which can be a letter, a number, or another symbol (A,2?,S) * A grouping of characters into a word, a group of words, or a complete number (such as a person’s name or age) is called a field Ex: employee Last name, Customer Account number * A group of related fields, such as the student’s name, the course taken, the date, and the grade, comprises a record; Ex: There will be one record for every one * A group of records of the same type is called a file. Ex: Employee Benefits file, Employee payroll file * Database: A group of related files about a specific entity Ex: HR database PROBLEMS WITH THE TRADITIONAL FILE ENVIRONMENT In most organizations, systems tended to grow independently without a company-wide plan. Accounting, finance, manufacturing, human resources, and sales and marketing all developed their own systems and data files. Figure 6-2 illustrates the traditional approach to information processing * In the company as a whole, this process led to multiple master files created, maintained, and operated by separate divisions or departments. As this process goes on for 5 or 10 years, the organization is saddled...

Words: 3898 - Pages: 16

Free Essay

Final Year Project Management System

...2010-05. Who’s Driving this Cloud? Towards Efficient Migration for Elastic and Autonomic Multitenant Databases Aaron Elmore Sudipto Das Divyakant Agrawal Amr El Abbadi Department of Computer Science University of California, Santa Barbara, CA, USA {aelmore, sudipto, agrawal, amr}@cs.ucsb.edu Abstract The success of cloud computing as a platform for deploying webapplications has led to a deluge of applications characterized by small data footprints but unpredictable access patterns. An autonomic and scalable multitenant database management system (DBMS) is therefore an important component of the software stack for platforms supporting these applications. Elastic load balancing is a key requirement for effective resource utilization and operational cost minimization. Efficient techniques for database migration are thus essential for elasticity in a multitenant DBMS. Our vision is a DBMS where multitenancy is viewed as virtualization in the database layer, and migration is a first class notion with the same stature as scalability, availability etc. This paper serves as the first step in this direction. We analyze the various models of database multitenancy, formalize the forms of migration, evaluate the offthe-shelf migration techniques, and identify the design space and research goals for an autonomic and elastic multitenant database. Categories and Subject Descriptors H.2.4 [Database Management]: Systems—Relational databases General......

Words: 5142 - Pages: 21

Premium Essay

Mis Project

...MANAGEMENT INFORMATION SYSTEM IMPLEMENTATION Abstract Table of Contents Page 1. Company Background 4 - 5 2. Business Problem Statement 5 - 6 A. Identification of Issues B. Desired State of Problem C. Obstacles 3. High-Level Solution 6 - 8 A. Introduction a. Solution Outline b. Summation 4. Implementation Benefits 8 - A. Management Information System (MIS) Presentation B. MIS Projections a. Database Management System (DBMS) b. Cloud Computing c. E-commerce and The Internet 5. Benefits/Technical Approach X XXX X XXX X 6. Business Process Changes X XXX X XXX X 7. Solutions X XXX X XXX X 8. Recommendations X XXX X XXX X 9. Implementation Plan X XXX X XXX X 10. Project Summary X XXX X XXX X Company Background The Knitter’s Lounge & Café (KL&C) is a modern approach to arts and crafts. It began as an innovative conceptual idea for a café style retail arts and crafts store in 2010 after the owner and Chief Executive Officer (CEO) visited a number of yarn shops and realized a need for a shop that bade more than the common knitting and crocheting supplies found in traditional arts and crafts establishments. The first store is located in Sandy Springs, a suburb of Atlanta, GA. Sandy Springs is an affluent community nestled along Cobb County with the Chattahoochee River to the......

Words: 1770 - Pages: 8

Free Essay

Oracle Database Trends

...Research projectDatabase TrendssUBMITTED BYAndrew HoPatrick TchissamboFlavio baptista | | | PROFESSOR TAHEREH DANESHI | Summary page Our project is about database trends. We started the project by identifying aims and goals such as understanding what database is.We calculated in detail and understood and researched on database understood database used by ORACLE. INTRODUCTION The definition of a database is a structured collection of records or data that is stored in a computer system. In order for a database to be truly functional, it must not only store large amounts of records well, but be accessed easily. In addition, new information and changes should also be fairly easy to input. In order to have a highly efficient database system, you need to incorporate a program that manages the queries and information stored on the system. This is usually referred to as DBMS or a Database Management System. Besides these features, all databases that are created should be built with high data integrity and the ability to recover data if hardware fails. (What is a Database?, 2010) AIM The aim of the study is many folded such as, understanding database, go in detail and understand and research on database, understand the technology used by ORACLE, derive conclusions on the development in the field of database. LIMITATIONS This study is descriptive in nature and the research is done on published secondary materials. Logical conclusions are made based on our......

Words: 3078 - Pages: 13

Premium Essay

Assignment 1 Systems Consideration

... HRM-Human Resource Information Systems 15 April 2014 Introduction Human Resource Information System (HRIS) is software used for tracking, entering and storing of data needs by Human Resources within an organization. There are many companies that sell HRIS software with each form having different features. An effective HRIS provides comprehensive information on all the current employees, former employees and the potential employees (Obeidat, 2012). Two Commercial HR Database Systems HR Quik® by Data Ingenuity, Inc. is a simple human resource employee database system. The HR Quik database system can be loaded onto the company’s server, network, hard drive or cloud based. HR Quik offers an on-line applicant website with the program. Just link the application website to the company website. Then, when employment applicants click on "Jobs", they will be directed to the application website with the company’s logo. The applicant can complete an on-line application, submit their resume, and complete EEO data. The hiring manager can process applicant as Hire, Decline, Pending, etc. Hired applicants can be imported into HR Quik where offer letters and other new employee paperwork can automatically be generated (dataingenuity.com). BambooHR is the second HR database system researched. Their system is a flexible HRIS system and pricing that adapts to the......

Words: 1355 - Pages: 6

Premium Essay

Data Warehousing Case Study

...understanding about Data Warehousing and how to apply this in emerging fields of big data and online data storage management. Data Warehousing Data Warehousing is more concerned with database administration in a computer based environment. Data Warehousing which is also known as enterprise data warehousing (EDW) is an efficient system to keep the inventory of data pertaining to different aspects of the organization which is ultimately use for reporting and data analysis. Data Warehousing is treated as the core component of business intelligence. It is the main repositories of integrated data from different departments of an organization or different sources (i.e. suppliers,...

Words: 1077 - Pages: 5

Premium Essay

Database Design

...Database Design Paper John Hancock DBM/380 April 23, 2013 April Johnson Database Design Paper Database systems are an organized collection of data. The data is normally organized by a couple different methods; structured and unstructured. Database systems make working in a company a lot easier when an employee is looking for information. By having a database management system in the work place the employees will have improved data sharing, data security, data access and better data integration. A couple examples of databases would be Oracle, Microsoft Access and Microsoft SQL Server. Oracle’s primary function is to store and retrieve data as it is requested. Database architecture not only focuses on the design, development, implementation and maintenance of computer programs that store and organize database information for any business or company big or small. Also a database architect my use a vast array of different languages to create a database, one language is called the structured query language or SQL. When I was in the Navy at first I didn’t realize how structured all of the information was and how much information was actually kept on file. Every duty station has a database system that is used which is Oracle. This database in particular is a very great database for the Navy to use because as information is needed a service member can access the information on the Oracle database cloud at any given time. Also the service member will know that the......

Words: 464 - Pages: 2