Data Management
Ahmed EL Makki
Walden University
Abstract
We will discuss in this paper the data warehousing and the online processing of data. We will describe the best ways to manage the data and the difficulties that you could face. Also we will talk about how can we solve or reduce these difficulties.
Database Management Systems (DBMS)
Database Management Systems (DBMS) maximize:
● Data security
● Data integrity
● Data independence
Data Warehousing
Data warehousing is a powerful business intelligence tool for maximizing the organization’s investment in the information technology. It is can be describe as a collection of decision support technologies, maid to allow executive, manager, and analyst, to make faster decisions.
IT managers need to learn and implement data warehousing because it is very powerful tool provides storage, functionality and responsiveness to queries beyond the capabilities of today 's databases. It also improves the data access performance. Since it is very rare today to remove the data because most users have only read-access also rapid access to a larger volume of data which could be inconvenient sometimes.
Software and systems support started to design systems to support decision makers as online analytical processing (OLAP), decision-support systems (DSS) and data mining.
online analytical processing (OLAP): is a software technology that allows users to analyze and view data from multiple points-of-view. OLAP provides dynamic
The purpose of data warehousing is to combine all of a company 's data and allows users to access the data directly, create reports, and obtain responses to
This data is collected and organized in order to process orders and maintain good customer service. The logical view of data would allow a knowledge worker to arrange and access information based on the needs of the business separating it from the physical view of how information is arranged and stored. The ability to do this allows for an employee to create detailed reports in order to determine information such as customer information and their order numbers and dates. This is imperative for a company like Comcast who has over 27 million customers in order to have a system to keep important data to analyze. Using a data warehouse allows them to gather from several databases and then the company can use the information to determine for example how many units of voice products are sold to create the necessary business intelligence to make future decisions and remain
Suppose that the data for analysis include the attribute age. The age values for the data
One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Company gathers data by using Web analytics and operational systems, we must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.
Data and information management is a huge growth area. But it's not just data management creating new job opportunities, its gathering, analyzing, storing and securing the data as well.
In order to obtain peer reviewed research articles related to the impact of the psychological contract on job satisfaction in community mental health care workers it is important to review research that has been completed in a variety of researchers and in different settings. The databases that were selected to locate peer reviewed articles for this paper where Academic Search Complete and ProQuest Psychology. Tutorials were available for each of these databases and ProQuest was used to learn how to navigate through the data base since it was not a familiar data base to this author.
A data warehousing is defined as a collection of data designed to support management decision making. Data warehouses contains a wide variety of data that present a coherent picture of the business conditions at a single point in time. Development of a data warehouse includes development of the systems that extract data from operating systems plus the installation of the warehouse database system that provides managers flexible access to the data. The term data warehousing generally refer to the combination of many different databases across an entire enterprise. (webopidia)
A data warehouse is a large databased organized for reporting. It preserves history, integrates data from multiple sources, and is typically not updated in real time. The key components of data warehousing is the ability to access data of the operational systems, data staging area, data presentation area, and data access tools (HIMSS, 2009). The goal of the data warehouse platform is to improve the decision-making for clinical, financial, and operational purposes.
This paper will identify the best possible decisions used in determining databases and data communication. I will discuss and respond to two scenario-based questions. As a marketing assistant for a company and I have to tracks data about booth components, equipment, shippers, and shipment. I will determine if a database system is suitable or whether an Excel is more appropriate. I will also decide if I will use a personal or enterprise database. In the second scenario I will decide type of network my company will use as well if my business will require wireless. I will also examine the proper security protocol and use Microsoft Excl to impact my decision.
The data-collection and analysis company is expected to grow 60% over the next 18 months This will include increasing the Data Warehouse (DW) by 20% to store data for collected data beyond the standard relational databases. A Business Requirement Document is needed in order to know the expectations of the project. This includes defining the scope of the project and how to control the scope. The risks, constraints, and assumptions are identified and how they could affect the project. Information will be gathered for the relationship and integration between the systems and the infrastructure. During the project there may be a need for outsourcing tasks or using offshoring companies. Resources will be needed to in order to complete the project in a timely manner and relevant terms used throughout the project will be defined.
Due to the increase in new technology, business, communication, device, big scale of data was produced. About 90% data in today’s world was just created in last two years alone, without counting those data that has been created previously. The information retained in those data was a big risk to many organizations as the current technology was managing the data with traditional approach, which consisted of user, a centralized system and relational data base. This style had various drawbacks together along with two key problems: less storage capacity and slow data processing.
This paper will present the return on investment (ROI) of data warehousing (DW). The history of data warehousing is based on the definition and timeline. Then, detailed information about return on investment will be discussed. Following, will be information about data warehousing new technology of hardware and software. Data Warehousing is a new term in my department where we use the Network Appliance (NetApps) Netfiler storage devices/units. The information read was very informative and helpful in my understanding data warehousing better. Finally, a conclusion about the return on investment of data warehousing.
Data warehouse are multiple databases that work together. In other words, data warehouse integrates data from other databases. This will provide a better understanding to the data. Its primary goal is not to just store data, but to enhance the business, in this case, higher education institute, a means to make decisions that can influence their success. This is accomplished, by the data warehouse providing architecture and tools which organizes and understands the
Design, code and deliver user friendly multi-tier business intelligence solutions that utilize data warehouse/data mining technologies to consume data across various database platforms and data stores.
Data has always been analyzed within companies and used to help benefit the future of businesses. However, the evolution of how the data stored, combined, analyzed and used to predict the pattern and tendencies of consumers has evolved as technology has seen numerous advancements throughout the past century. In the 1900s databases began as “computer hard disks” and in 1965, after many other discoveries including voice recognition, “the US Government plans the world’s first data center to store 742 million tax returns and 175 million sets of fingerprints on magnetic tape.” The evolution of data and how it evolved into forming large databases continues in 1991 when the internet began to pop up and “digital storage became more cost effective than paper. And with the constant increase of the data supplied digitally, Hadoop was created in 2005 and from that point forward there was “14.7 Exabytes of new information are produced this year" and this number is rapidly increasing with a lot of mobile devices the people in our society have today (Marr). The evolution of the internet and then the expansion of the number of mobile devices society has access to today led data to evolve and companies now need large central Database management systems in order to run an efficient and a successful business.