Friday, January 31, 2020

To determine the concentration of limewater Essay Example for Free

To determine the concentration of limewater Essay The aim of my experiment is to find the concentration of limewater solution provided. To do this I am provided with the following chemicals. Limewater: 250cm (1g dm ) Hydrochloric acid at concentration of 2 mol dm As you can see the hydrochloric acid is too concentrated for titration (i.e. one drop could change the colour of the solution.) therefore this acid will need to be diluted. Background knowledge: Limewater can be made by dissolved slacked lime in water to get a solution of calcium hydroxide (Ca (OH) 2 ) Quicklime + water slaked lime CaO (s) + H2O (l) CaCl2 (aq) + 2H2O (l) In this reaction it shows the calcium oxide reacts with water to produce calcium hydroxide. After adding more water to calcium hydroxide, it produces the saturated aqueous solution known as limewater. My experiment will be based on this neutralisation reaction between the limewater and hydrochloric acid. Ca(OH) 2(aq) + HCl (aq) CaCl2 (aq) + 2H2O (l) ï ¼Ë†back ground knowledge of limewater provided by AS chemistry 1 page†¦Ã¯ ¼â€° Diluting hydrochloric acid: My first task for this experiment is to dilute the hydrochloric acid. To do this I first needed to work out how many moles I wanted for hydrochloric acid. For this part of my calculation I choose to use text book Calculations for chemistry to help me. Page†¦.. Ca(OH) 2(aq) + HCl (aq) CaCl2 (aq) + 2H2O (l) 1gdm of Ca(OH) 2 Number of moles of limewater Mr of lime water= 40.1 + (16 x 2) + (1 x 2) = 74.1 Mass of lime water=1g Moles of lime water =mass(g)/Mr So 1/74.1=0.13 mol dm-3 Molarities of limewater solution: Morality = no. moles of limewater / volume = 0.013 / 1 = 0.013 mol dm So there is 0.013 mole of Ca(OH) 2 per every 1000cm3 of solution. Therefore 25cm should contain 3.2510-4 moles of Ca(OH) 2. 0.013/40=3.2510-4 mole Ratio of limewater: Hydrochloric acid = 1: 2 = 3.25 x 10 : 6.5 x 10 The hydrochloric acid is 2M which is 2 moles HCl in 1dm of solution. I need 6.5 x 10 moles of acid. Now I need to work out the volume of hydrochloric acid like this: Volume = no. moles x 1000 / concentration = 6.5 x 10 x 1000 / 2 = 0.325cm I want a 25cm titre that contains 6.5 x 10 mol dm Now I need to work out the concentration of hydrochloric acid. Concentration = no. moles x 1000 / volume = 6.5 x 10 x 1000 / 25 = 0.026 mol dm I now know that I want 0.026-mol dm of hydrochloric acid for the reaction to work. But I have been supplied with 2.00-mol solution. I want 250cm of dilute hydrochloric acid at 0.026-mol dm. The total no. moles in 250cm is unknown. 250 cm of the solution should be enough to repeat the experiment. Total number of moles of HCL: No. moles = concentration x volume / 1000 This equation is rearranged to make: Volume = no. moles x 1000 / concentration So 1000cm contains 0.026 moles therefore 250cm contains 0.0065 moles Volume of hydrochloric acid I need : Volume = no. moles x 1000 / concentration = 0.0065 x 1000 / 2 =3.25cm Apparatus Pipette25ml Burette50ml Conical flask 250cm Volumetric flask 250cm Graduated pipette Clamp + stand White paper Distilled water Squeezing pump Safety: Concentrated HCL must be handled with extreme caution due to its corrosive property. Goggle and lab coat must be worn all the way through the experiment. Rubber gloves must be worn when handling concentrated HCL. Hazard sheet must be filled before the experiment. Chemicals used for my titration: Chemical in burette: hydrochloric acid( 0.026mol dm ) Chemical in conical flask: lime water Indicator: methyl orange Method: Here is how I am going to carry out my experiment: Part 1: diluting acid. Add the 3.25cm of hydrochloric acid to the volumetric flask using the graduated pipette to get the exact amount of hydrochloric acid. Fill the same volumetric flask with distilled water until is reaches 250ml. This should now make my dilute hydrochloric acid with 0.0065 -mol dm. Now the hydrochloric acid is ready. Part 2: the titration. Wash burette with tap water, then distilled water and finally with hydrochloric acid. Wash the conical flask with tap water, then distilled water and finally with limewater Set up titration apparatus. Fill the burette with 50cm of the dilute hydrochloric acid making sure the bottom of the meniscus is reading at 50 on the burette. Using a funnel to put the dilute hydrochloric acid in the burette increases safety against spillage. Fill the conical flask with 25cm of limewater using the squeezing pump and pipette. Add three drops of methyl orange to the limewater and mix until it turns a light yellow depending on the concentration of the methyl orange. Place the conical flask containing limewater onto a white paper. Start to run the dilute hydrochloric acid steadily, starting of constantly when a you see a localised colour change, then start to add small drops, finally into drop by drop. shake the conical flask after every drop of HCL is added. This will make sure you will use the exact amount of hydrochloric acid when the colour changes. This improves accuracy and reliability. Repeat all the tests at least three times (Time dependent) so that an average can be obtained. Repeating the experiments several times will help to produce better and more accurate results, as any inaccuracies in one experiment should be compensated for by the other experiments. Note all the results in a table. One thing I have to decide is what indicator I want to use. The indicators methyl orange and phenolphthalein are pretty much one-three drops change and a clear change. The pink/colourless change for phenolphthalein is very definite, the yellow/pink change for methyl orange is clear too. Because these are clear it means I can tell when the reaction has finished easier than using other indicators. Limewater, which is calcium hydroxide, is a strong alkali, even though it is only sparing soluble. Its pH is 14. Hydrochloric acid is a strong acid. This means that even if you have quite a weak concentration it completely dissociates in water into H3O+ ions and OH- ions giving a pH of 1 (The pH is a measure of how many hydrogen ions are present in solution). For the reaction of Calcium hydroxide and Hydrochloric acid I would use methyl orange. It changes colour at around pH 4.4 and will change from yellow in acid to pink in alkali by the addition of limewater. To make this experiment as accurate as possible, the pipette, burette and volumetric flask only have a percentage error of + or – 0.1%. This is only a small error. Also making sure the hydrochloric acid is poured into the burette carefully using a funnel will prevent the hydrochloric acid pouring down the side of the burette.

Thursday, January 23, 2020

Network Security :: essays research papers

Over the last 10 years, computers have increased in speed and capacity while decreasing drastically in price. Computers that where once used in the corporate environment, are now slower than typical household computers. While this change occurred, telecommunications have improved to allow computers to communicate easily from remote locations, adding great opportunities for illegal activities. Data can be changed or destroyed, systems can be made to malfunction and long distance charges can be avoided. One of the biggest challenges today is to control the network security. Network security is having protection of networks and their services from unauthorized access, destruction, or disclosure. Malicious acts bring up the important topic of disaster recovery. Companies must have up to date copies of their important documents and software to prevent extended downtime. The saved information will let the company’s employees continue to work while the IT department deals the damage d media. In 2002, computer virus attacks caused companies roughly $20 billion to $30 billion up from $13 billion in 2001. This number continues to grow as more computers are sold. Users must realize the risk of the internet and file sharing before the statistics can decline. Examples are peer-to-peer download software, instant messaging channels, and email. These examples sound like home user issues but the reality is that employees are always finding ways to use this software in the working environment. In the end, it jeopardizes the network and costs companies money. Software companies have developed ways to deal with computer viruses and email spam in an automated fashion. Some can be free for personal use and others are expensive intended for corporate level networks. Confidentiality in computer systems prevents the release of information to unauthorized people. Individuals who trespass into someone else’s computer system or exceed their own authority in accessing certain information, violate the legitimate owner’s right to keep private information secret. Integrity of electronically stored information ensures that no one has tampered with it or modified it without authorization. Any unauthorized corruption, impairment, or modification or computer information or hardware constitutes an attack against the integrity of that information. Many of the malicious hacking activities, such as computer viruses, worms, and Trojan horses, fall into the integrity category. The same is true for individuals who purposefully change or manipulate data either for profit or some other motivation, such as revenge, politics, terrorism, or simply for a challenge. Internal computer crimes are alterations to programs that result in the performance of unauthorized functions within a computer system.

Wednesday, January 15, 2020

A Data Warehouse Appliance Can Have a Huge Positive Impact on Businesses and Organizations Essay

Businesses and organizations of all sizes are becoming increasingly dependent on data analytics, and data warehouses or business analytic infrastructure has become a business critical application for many (if not most) companies. Indeed, these companies have always searched for better ways to understand their customers, and anticipate their needs. They have longed to improve the speed and accuracy of operational decision-making. Equally important as timeliness is the depth of the data analysis. Generally, the companies want to decipher all secrets hidden within the massive amounts of ever-increasing data. A data warehouse appliance, which is an integrated collection of hardware and software designed for a specific purpose typically involving the high throughput of data and analytic functions, can be used by organizations to optimize various areas of data processing. Its main intent is to supplant conventional business intelligence functions, such as warehousing, extract-transform-load (ETL), analysis and reporting. Due to its cost-effectiveness and efficiency, the data warehouse appliance has become an important segment of the data warehousing market. In this paper, I will examine the data warehouse appliances and describe its positive impact on business enterprises. Introduction Since introduced in the early 1990s, data warehouse (DW) has proven to be the key platform for strategic and tactical decision support systems in the competitive business environment today. See more: Analysis of Starbucks coffee company employees essay It has become a major technology for building data management infrastructure, and resulted in many benefits for various organizations, including providing â€Å"a single version of the truth, better data analysis and time savings for users, reductions in head count, facilitation of the development of new applications, better data, and support for customer-focused business strategies† (Rahman, 2007). The technology has become extremely important in an environment where increasing competition, unpredictable market fluctuations, and changing regulatory environments are putting pressure on business organizations. Data warehouses are also becoming the central repositories of organization/company information for data, which is obtained from a variety of operational data sources. Business applications will find data warehouses more beneficial and rely on them as the main source of information as they progress. These applications are able to perform all sorts of data analysis, with increasing customer demands for having the most up-to-date information available in data warehouses. Improving data freshness within short time frames is essential to meeting such demands. According to Hong et al, virtually all Fortune 1000 companies, today, have data warehouses, and many medium and small sized firms are developing them. The desire to improve decision-making and organizational performance is the fundamental business driver behind data warehouses. DW help managers easily discover problems and opportunities sooner, and widen the scope of their analysis. Hong also mentions that data warehouse is user-driven, meaning that users are allowed to be in control of the data and will have the responsibility of determining and finding the data they need. But however, the data warehouses have to be designed and evaluated from the user perspective in order to motivate users to be responsible for finding the data they need. Data warehouse is said to be â€Å"one of the most powerful decision-support tools to have emerged in the last decade† (Ramamurthy, 2008). They are developed by firms to help managers answer important business questions which require analytics including data slicing and dicing, pivoting, drill-downs, roll-ups and aggregations. And these analytics are best supported by online-analytical processing (OLAP) tools. A data warehouse appliance, which is the main topic of discussion in this research, is referred to as an integrated collection of hardware and software designed for specific purposes involving the high throughput of data and analytic functions. Data warehouse appliance has become an important segment of the data warehousing market, due to its cost-effectiveness and efficiency. A business or organization can use a data warehouse appliance to optimize various areas of data processing. In general, the main purpose of the DW appliance is to supplant conventional business intelligence (BI) functions including warehousing, extract, transform, load (ETL), analysis, and reporting. A data warehouse appliance can have a huge positive impact on a business enterprise. Large organizations are able to staff their data warehouse more efficiently, while assisting mid-level companies in solving business intelligence challenges. Data warehouse is fundamentally changing the way the businesses operate, as they are increasingly adopted across various companies. The purpose of this paper is to present the data warehouse appliances and how they impact businesses and organizations. In the next sections, I present a brief overview of data warehousing and the current state of BI, then I define and discuss DW appliances including its benefits, after which I describe the positive impact of DW appliances on businesses. Data Warehousing A data warehouse can basically be defined a subject-oriented, integrated, non-volatile, and time-variant collection of data in support of management’s decisions. Unlike the on-line transaction processing (OLTP) database systems, data warehouses are organized around subjects storing historical/summarized data for business requirement purposes. According to O’Brien and Marakas, a data warehouse is a central source of data which have been cleaned, transformed and cataloged so they are usable by managers/business professionals for data mining, online analytical processing, market research, and decision support. These stored data are usually extracted from various operational, external, and other database management system of an organization. DW can be sub-divided into data marts, holding subsets of data from the warehouse that focus on specific aspects, such as department, of a company. In general all data warehouse systems comprises of the following layers; data source, data extraction, staging area, ETL, data storage, data logic, data presentation, metadata, and system operations layer. But the four major components include the multi-dimensional database, ETL, OLAP, and metadata. The dimensional database applies the concept of standard star-schema including dimension and fact tables, hierarchies for drill-down, role models, aggregates and snow flaking. It optimizes database design for better performance. The ETL process involves the extraction, transformation and loading of data with appropriate ETL tools. Data integration is one of the most important aspects of data warehouse, whereby data is extracted from multiple heterogeneous source systems and placed in a staging area where it is cleaned, transformed, pruned, reformatted, standardized, combined, and summarized before loading into the warehouse. OLAP (online analytical processing) tool provides the front-end analytical capabilities including slice and dice, drill up, drill down, drill across, pivoting, and trend analysis across time. And metadata stores information (or data) about the data in the warehouse system. The components of a complete data warehouse architectural system are illustrated in Figure 1 below. Figure 1 An important characteristic about the data in a data warehouse is that they are static, unlike a typical database with constant changes. Once the data are gathered up, formatted for storage, and stored in the data warehouse, they will never change. The restriction is such that complex patterns or historical trends can be searched for, and analyzed, by queries. Data warehouses are also non-volatile in the sense that end-users cannot update the data directly, thereby being able to maintain a history of the data. A major use of the data warehouse databases is data mining, in which the data are analyzed to reveal hidden patterns and trends in historical business activity. Such analysis could be used to help managers make decisions about strategic changes in business operations in order to gain competitive advantages in the marketplace. Data warehousing is a relatively new technology that â€Å"brings the vision of an entirely new (customer-centric) way of conducting business to reality†, and can provide â€Å"environments promising a revolution in organizational creativity and innovation† (Ramamurthy, 2008). Ramamurthy also mentioned that data warehouse generally serves as an IT infrastructure technology, focused on data architecture, as it provides a foundation for integrating a diverse set of internal and external data sources, enabling enterprise-wide data access and sharing, enforcing data quality standards, providing answers to business questions, and promoting strategic thinking through CRM, data mining, and other front-end BI applications. Users of the data warehouses are from virtually every business unit, amongst which information systems, marketing and sales, finance, production and operations, are the heaviest users. Current State of Business Intelligence Business Intelligence are computer based techniques used in identifying, extracting and analyzing business data. Sales revenue by products, department, time, region or income are such examples. The BI technologies provide historical, current and predictive views of business operations. Some common functions of BI technologies include reporting, online analytical processing, analytics, data mining, text-mining and predictive analytics. As BI aims to support better business decision-making, they can also be referred to as a decision support system. BI applications often use data gathered from data warehouses or data marts, however, not all BI applications require a data warehouse. With sources from Wikipedia, business intelligence can be applied to business purposes in order to drive business value. Amongst these business purposes include measurement, analytics, reporting, collaboration, and knowledge management. BI is widely used today, mainly to describe analytic applications. According to Watson, BI is currently the top-most priority of many chief information officers. In a survey of 1,400 CIOs, from Gartner Group, it was discovered that BI projects were the number one technology priority for 2007. Watson further informs that the BI is a process which basically consists of two primary activities; â€Å"getting data in and getting data out†. Getting data in, also referred to as data ware housing, delivers limited value to a business enterprise. Organizations realize the full value of data from data warehouses only when users and applications access the data and use it to make decisions. Getting data out receives the most attention, as it consists of business users/applications accessing data from DW to perform enterprise reporting, OLAP, querying and analytics. The business intelligence framework is depicted in figure 2. Current BI infrastructure is a patchwork of hardware, software and storage that is growing ever more complex. Figure 2 – BI framework BI is continuing to evolve, and several recent developments are generating widespread interest, including real-time BI, business performance management, and pervasive BI. Data Warehousing Appliance A data warehouse is developed to support a broad range of organizational tasks. It can be referred to as an organized collection of large amounts of structured data, designed and intended to support decision making in organizations. The import of information and knowledge from a data warehouse is a complex process that requires understanding of the logical schema structure and the underlying business environment. According to Hinshaw, a data warehouse appliance, applied to business intelligence, â€Å"is a machine capable of retrieving valuable decision-aiding intelligence from terabytes of data in seconds or minutes versus hours or days†. The appliances represent the difference between decision-making using either stale data or the freshest information possible. With sources from Wikipedia, a more standard definition of the data warehouse appliance is an integrated collection of hardware and software designed for a specific purpose that typically involves the high throughput of data and analytic functions. It typically consists of integrated set of servers, operating systems, data storage facilities, database management systems (DBMS), and software that is pre-installed and pre-optimized for data warehousing. DW appliances provide solutions for the mid-to-large volume data warehouse market, offering low-cost performance usually on data volumes within the terabyte range. Due to its cost-effectiveness and efficiency, the data warehouse appliance has become a critical segment of the data warehousing market. A business or an organization can use a data warehouse appliance to optimize various areas of data processing. The main purpose of a DW appliance, in general, is to supplant conventional business intelligence functions, such as warehousing, extract, transform, load (ETL), analysis, and reporting. A true DW appliance is defined as one that does not require fine-tuning, indexing, partitioning, or aggregating, whereas, some other DW appliances use languages such as SQL to facilitate interaction with the appliance at a database request level. With reference to Wikipedia, most data warehouse appliance vendors use massive parallel processing (MPP) architectures to provide high query performance and platform scalability. The MPP architectures consist of independent processors or servers executing in parallel, implementing a â€Å"shared nothing architecture† which provides an effective way to combine multiple nodes within a highly parallel environment. A DW appliance is capable of deploying up to thousands of query processing nodes in one ppliance package, compared to traditional solutions where the cost and complexity of each additional node prevents a high level of hardware parallelism. Leveraging fully integrated data warehouse architecture, a data warehouse appliance can deliver a significant performance advantage, performing up to 100 times faster than general-purpose data warehousing systems. Maturation With reference to Hinshaw, data warehouse appliance is specifically designed for the streaming workload of business intelligence and is built based on commodity components. It integrates hardware, DBMS and storage into one opaque device and combines the best elements of SMP and massively parallel processing (MPP) approaches into one that allows a query to be processed in the best possible optimized way. A data warehouse appliance is fully compatible with existing BI applications, tools and data, through standard interfaces. It is simple to use and has an extremely low cost of ownership. The development of standardized interfaces, protocols and functionality is one of the most important trends in BI. In comparison to about a decade ago, there are a wealth of tools and applications using these standardized interfaces including MicroStrategy, Business Objects, Cognos, SAS and SPSS. And these are coupled with ETL tools having standardized interfaces such as Ab Initio, Ascential and Informatica. The appliances work seamlessly with these tools and other in-house applications. A data warehouse appliance is truly scalable. The bottlenecks are the speeds of the internal buses, internal networks, and disk transfer in BI, whereas in transactional workloads, scalability is limited primarily by CPU. Reliability, which is provided by the homogenous nature of an appliance – all parts of the system coming from a vendor, is also critical. A data warehouse appliance also provides simplicity for the administrators, in that it allows administrators spend a more productive time in troubleshooting complex database systems. And DBAs can be deployed to assist end users doing real-time BI. A data warehouse appliance offers the lowest cost of ownership as it has one source and one vendor, thereby reducing costs associated with support. Businesses and organizations will run more efficiently with the simple, efficient solution provided by a data warehouse appliance. Benefits Data warehouse appliances provide freedom to the business user. With patch-work systems, users are limited in the queries they can run due to the time required to run them. And with the time required to run a complex query reduced to seconds, users can not only run their old analysis with more iterations, but have the time to devise and run entirely new sets of analysis on granular data. With sources from Wikipedia, some researched benefits of DW appliance are briefly discussed as follows; Reduction in costs – As a data warehouse grows, the total cost of ownership of the data warehouse consists of initial entry costs, maintenance costs, and the cost of changing capacity. DW appliances offer low entry and maintenance cost. Parallel performance – DW appliances provide a compelling price/performance ratio. The vendors use several distribution and partitioning methods to provide parallel performance. With high performance on highly granular data, DW appliances can address analytics that could previously not meet performance requirements. Reduced Administration – DW appliances can provide a single vendor solution, taking ownership for optimizing the parts and software within the appliance, thereby eliminating the customer’s costs for integration and regression testing of the DBMS, OS and storage on a terabyte scale. DW appliance reduces administration via automated space-allocation, reduced index-maintenance and reduced tuning and performance analysis. Scalability – DW appliances scale for both capacity and performance. In massive parallel processing architectures, adding servers increases performance as well as capacity. Built-in high availability – Massive parallel processing DW appliance vendors provide built-in high availability via redundancy on components within the appliance. Warm-standby servers, dual networks, dual power-supplies, disk mirroring with fail-over and solutions for server failure are offered by many. Increasingly, business analytics are expected to be used to improve the current cycle, and DW appliances provide quick implementations without the need for regression and integration testing. Also, DW appliances provide solutions for many analytic application uses. Some of these applications include; enterprise data warehousing, super-sized sandboxes isolating power users with resource intensive queries, pilot projects, off-loading projects from the enterprise data warehouse, applications with specific performance or loading requirements, data marts that have outgrown their present environment, turnkey data warehouses, solutions for applications with high data growth and high performance requirements, and applications needing data warehouse encryption. Impact of Data Warehouse Appliances on Businesses and Organization Demand for data warehouse appliances is increasing, and businesses taking advantage of the benefits of this hardware range from a world-wide large-scale business to the smallest individual business. Data virtualization could be a useful partner to appliances, providing a single view of information across multiple appliances. Data virtualization is also useful because it provides a stable reporting layer during normal migration exercises, such as the circumstances during addition of data warehouse appliances to the information infrastructure. As businesses today continue to process extremely large volumes of data, there is always the need to keep data warehousing costs under control while ensuring a superior BI and application performance. Scalability, flexibility, and affordability are essential requirements for designing an infrastructure capable of supporting next-generation BI performance. When asked why the demand for data warehouse appliance is increasing, during an interview, Robert Eve (executive vice president of marketing for Composite Software Inc. ) stated that it is the confluence of three primary drivers at the macro level. The first is â€Å"the well-reported information explosion, and the technical challenges involved in making this information accessible in forms that business decision-makers can easily use†. Secondly, data warehouse appliances are more affordable and appealing, as the costs per terabyte and for support are coming down. And finally, recent advancements in analytics technology, notably in predictive analytics, promise to concur with the massive data volumes. Data warehouse appliances offer numerous advantages some of which are similar to benefits. Amongst the advantages include; more reporting and analytical capabilities – data warehouse appliance are able to handle bigger and more complex query workload, if it executes queries, Cost reductions – data warehouse appliance requires a minimal amount of tuning and optimization of the database server and database design. It is also able to run most queries with a quick speed, Flexibility – it will be easier to implement new user requests if less tuning and optimization is needed. With other database servers, a new query might lead to quite a number of technical changes, such as creating and dropping indexes, repartitioning tables, etc. Sometimes, decision is made not to implement the new request at all, due to the overwhelming work. The need for these additional technical changes is less with a data warehouse appliance. Data warehouse appliances helps support impressive BI deployments. With reference to Hinshaw, real world application examples of the positive impact of DW appliance on businesses are discussed. The rapid growth of call detail records, in the telecommunications industry, creates an imposing amount of data, which makes it difficult for companies to quickly and efficiently analyze customer and call plan information. And traditional approaches have been inefficient in processing queries on even a month’s data, seriously hampering an organization’s ability to perform trend analysis to reduce customer churn and generate timely reports. However, with a DW appliance, the telecom user can analyze customer activity down to the call detail record level over a full year’s worth of detailed data. Another industry where data warehouse appliances have begun to prove their worth, and are poised to play a bigger role in the future, is the retail. Hinshaw states that Brick-and-mortar and online retailers are capturing great amounts of customer transaction and supply chain information, creating a data explosion that threatens to overwhelm an average retail organization and its current IT infrastructure. But data warehouse appliances enable these retailers to manage and analyze the terabytes of information in near-real time. They are able to use the information to effectively forecast buying patterns, quickly generate targeted promotions and optimize their inventory and supply chain. Business intelligence remains the foundation for the success of decision making in any company. And BI, itself, relies on the underlying database architecture. Eve also presents other real world examples of positive business impact among a broad range of industries. A leading worldwide convenience foods business uses data warehouse appliances and analytic applications to acquire major business benefits in two specific areas. One of which the company optimizes its international network of delivery routes, making the system more efficient and ensuring timely delivery of its products. Secondly, it continuously refines its merchandizing mix daily, on a retail basis, in order to maximize sales and margins. Major League Baseball captures information about every pitch, at-bat, and fielding play within a data warehouse appliance, using this data to predict players’ future on-field performance. This can help teams to evaluate current and free-agent talent, refine coaching and development methods, and determine salaries, hence maximizing their wins. Also, a global freight, transportation, and logistics company uses data warehouse appliances to identify behavioral patterns that indicate potential dissatisfaction within its existing customer base. The customer care group then proactively takes steps to improve satisfaction before they lose their customers. Currently, smaller data warehouse appliance vendors seem to be focusing on adding functionality to their products in order to compete with the mega-vendors. However, it is anticipated that all appliance vendors will be impacted by the trend toward an inexpensive, high-performance, and scalable virtualized data warehouse implementations which use regular hardware and open source software. Conclusion In general, data warehouse appliance is a combination hardware and software product specifically designed for analytical processing. In a traditional data warehouse implementation, the database administrator can spend a significant amount of time tuning and putting structures around the data to get the database to perform well for large sets of users. But with a data warehouse appliance, it is the vendor who is responsible for simplifying the physical database design layer and making sure that the software is tuned for the hardware. In this research, a comprehensive examination/review of the data warehouse appliances, their benefits, and how they positively impact businesses and organizations, was presented. Based on this research, the negative impact of DW appliances on businesses are negligible compared to its positive impact. And there is an increasing demand for DW appliances. I believe that, in the near future, the DW appliances will become the sole platform for all business intelligence applications and requirements. I gained much knowledge and insights from researching this topic, and I intend to further my research on future impacts of DW appliance on businesses.

Tuesday, January 7, 2020

The Planet Mars Science Fair Project Ideas

Scientists are learning more about the planet Mars every year and that makes now a perfect time to use it as the subject of a science fair project. It is a project that both middle and high school students can pull off and they can take many different approaches to create  a unique and impressive display. Why is Mars Special? Mars is the fourth planet from the Sun and is commonly referred to as the Red Planet. Mars is more similar to Earth than Venus in regards to atmosphere, even though its only just over half the size of our planet. There is intense interest focused on Mars due to the possibility of liquid water being present there. Scientists are still trying to figure out if there is still water on Mars or if it was present at some time in the plants past. That possibility yields the chance of Mars harboring life. Quick Facts About Mars Mars has two moons, Phobos and Deimos.Mars is named after the Roman god of war and it influenced the naming of the month March.One year on Mars is equal to about two years on Earth.One day on Mars is half an hour longer than one day on Earth.The atmosphere of Mars is 95% carbon dioxide. Recent Mars Expeditions NASA has been sending spacecraft to study Mars since 1964 when Mariner 3 attempted to photograph the planet. Since then, over 20 space missions have launched to explore the surface further and future missions are planned as well. The Mars rover, Sojourner, was the first robotic rover to land on Mars during the Pathfinder mission in 1997. More recent Mars rovers like Spirit, Opportunity, and Curiosity have given us the best views and data available to date from the Martian surface. Mars Science Fair Project Ideas Build a scale model of our solar system. Where does Mars fit in the grand scheme of all the other planets. How does its distance from the Sun affect the climate on Mars.Explain the forces at work when the Mars orbits the sun. What keeps it in place? Is it moving further away? Does it have remain the same distance from the sun as it orbits?Study pictures of Mars. What new discoveries did we learn from pictures the rovers sent back versus satellite photos NASA captured before? How does the Martian landscape differ from Earth? Are there places on Earth that resemble Mars?What are the features of Mars? Could they support some kind of life? Why or why not?Why is Mars red?  Is Mars really red on the surface or is it an optical illusion? What minerals are on Mars that cause it to appear red? Relate your discoveries to things we can relate to on Earth and show pictures.What have we learned in the various missions to Mars? What were the most significant discoveries? What questions did each successful mission answer and did a later mission prove these wrong?What does NASA have planned for future Mars missions? Will they be able to build a Mars colony? If so, what will it look like and how are they preparing for it?How long does it take to travel to Mars?  When astronauts are sent to Mars, what will the trip be like? Are photographs sent back from Mars in real-time or is there a delay? How are the photos relayed to Earth?How does a rover work? Are the rovers still working on Mars? If you love to build things, a scale model of a rover would be a great project! Resources for a Mars Science Fair Project Every good science fair project begins with research. Use these resources to learn more about Mars. As you read, you may even come up with new ideas for your project. Mars Exploration from NASABuild a Solar SystemYour Weight on Other Worlds