Data Lake vs Data Warehouse: Pros and Cons

Assuming an extreme case that the HAB season lasts continuously for 115 days20, this implies an annual welfare loss of about $280 million. Modern lifestyles are stressful and take a toll data lake vs data warehouse on your mental and physical health. Living closer to bodies of water is even more beneficial when it comes to helping your mind relax and recoup from the daily stressors of modern life.

  • These estimates consider only the cost of CH4 emissions, but lakes and reservoirs also emit CO2 and N2O.
  • Living near a lake combats that stress by putting you close to nature.
  • Open space tends to require fewer municipal services than residential, so land preservation can decrease a community’s tax burden.
  • Concerns over diversion of Lake water are of concern to both Americans and Canadians.
  • Freshwater lakes are mostly in the Himalayas region and are from the glacial region.
  • Wisconsin Glacial Stage because it left many fresh landforms and sediments in that state.
  • This too can be a source of irrigation and also be a source of hydroelectricity power.

There are a variety of really fun activities that, while affording needed exercise, are a blast to participate in. Skiing and wakeboarding are exhilarating sports that will get your adrenaline rushing, letting you know that you’re alive. If you are interested in a more laid-back approach at the lake, get out the fishing pole and bring home dinner. Two solo pastimes on the water are kayaking and paddleboarding. A kayak can be an awesome way to spend an afternoon gliding along inches from the water’s surface. Being able to move in inches of water, a paddleboard allows you to explore areas of the lake that you aren’t always able to access.

The Cons of Living Near a Lake

Stormwater flows off of impervious surfaces like roads, parking lots and buildings, picking up pollutants and carrying them either directly to waterways or to water treatment plants. During large storms, capacity at treatment plans can be exceeded, resulting in untreated rainwater and household sewage being released into waterways. In parks, unpaved, pervious surfaces absorb rainwater, recharging ground water supplies and allowing storm runoff to be released more slowly. Vegetation stores water and allows some to be evaporated.

Merits of Lakes

Lakes that have such functions include the Poyang and Tung Ting on the Yangtze Kiang, Tonle Sap on a tributary of the Mekong, and Lake Constance on the upper Rhine. Where such lakes are not available, and flooding is a serious problem, artificial reservoirs are constructed e.g. the Hoover Dam on the River Colorado and the Bhakra and Nangal Dams on the Sutlej in India. Raw materials, minerals and fuels were economically handled and assembled in the HOMES’ district , which has since become one of the greatest industrial districts of the world. Contribute to the GeeksforGeeks community and help create better learning resources for all. Saltwater lake is also used for the production of salt.

Water levels

By 1681, a map published in Paris, obviously based on this new information, shows the Mississippi River and the western shore of Lake Michigan. Earlier maps had called the lake Lac des Illinois; this was the first to call it Lac de Michigami, thus introducing an early variation of the future state’s name. In 2007, the Great Lakes Shipwreck Historical Society announced that it had found the wreckage of Cyprus, a 420-foot long, century-old ore carrier. Cyprus sank during a Lake Superior storm on October 11, 1907, during its second voyage while hauling iron ore from Superior, Wisconsin, to Buffalo, New York. The entire crew of 23 drowned, except one, Charles Pitz, who floated on a life raft for almost seven hours.

The sounds of traffic and commotion that is typical of most urban settings are detrimental to the quality of sleep that you enjoy every night. Living close to bodies of freshwater has obvious benefits on the quality of your sleep. Living by a lake or another body of fresh water would mean that you’re far away from bustle and din of the city.


Lake Lanier, which provides drinking water for nearly 3 million people in the metro Atlanta area. Army Corp. of Engineers in the 1950s, Lake Lanier encompasses approximately 38,000 acres in Northern Georgia. The lake district has all the powers of a body corporate. Studies in the Lake Superior region indicate that a river system and valleys formed by water erosion existed before the Ice Age. The glaciers undoubtedly scoured these valleys, widening and deepening them and radically changing the drainage of the area. The Great Lakes receive their water supply from precipitation, which increases from west to east and from north to south.

Data lake provides various options and language support for analysis. It has Hive/Impala/Hawq which supports SQL but also has features for more advanced needs. For example, to analyze the data in a flow, you can use PIG or to do machine learning you can use Spark MLlib. It offers scalability and is relatively inexpensive compared to a traditional data warehouse when we take scalability into account.


The Great Lakes began to form at the end of the Last Glacial Period around 14,000 years ago, as retreating ice sheets exposed the basins they had carved into the land, which then filled with meltwater. The lakes have been a major source for transportation, migration, trade, and fishing, serving as a habitat to many aquatic species in a region with much biodiversity. The surrounding region is called the Great Lakes region, which includes the Great Lakes Megalopolis. The Great Lakes are the largest group of freshwater lakes on Earth by total area and are second-largest by total volume, containing 21% of the world’s surface fresh water by volume. The total surface is 94,250 square miles , and the total volume is 5,439 cubic miles , slightly less than the volume of Lake Baikal (5,666 cu mi or 23,615 km3, 22–23% of the world’s surface fresh water).

Merits of Lakes

Surface water is among Earth’s most important resources. Yet, benefit–cost studies often report that the costs of water quality protection exceed its benefits. One possible reason for this seeming paradox is that often only a narrow range of local water quality benefits are considered. In particular, the climate damages from water pollution have rarely been quantified.

Measuring the Economic Value of a City Park System

Instead, each is more effective at different functions and for different experts. Warehouses are ideal for organizing data required for pre-defined purposes such as reporting, which makes them great for traditional finance and data storing business functions. Lakes support many users and use cases more easily than warehouses. With the proper tools or support, users can answer more questions and analyze more information.

Merits of Lakes

These estimates consider only the cost of CH4 emissions, but lakes and reservoirs also emit CO2 and N2O. Adding current CO2 and N2O emission estimates10, the SC-GHG emissions increases by 27–51% above those for CH4 alone. Nevertheless, even our partial estimates suggest that reducing eutrophication is an important means of avoiding climate change damages with a large benefit when measured in monetary terms. River water is also used to generate hydroelectric power. Government actions and policies are launched to treat the river water, hence to overcome this, local people can use the lake water as a substitute for river water which more or less functions the same. This too can be a source of irrigation and also be a source of hydroelectricity power.

Large bays and related significant bodies of water

This allows users to benefit from the organizational capabilities of warehouses without losing the flexibility, formatting options, and breadth of data a Lake allows them to access. Meanwhile, Catalyst’s Query Tool, which we jokingly refer to as “SQL for Dummies,” lets users query, structure and marry data from different sources within the warehouses and lakes for analysis. Query makes it easy and intuitive to quickly locate and analyze the data you want, regardless of where it’s housed within your lake.

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *