Why Are the Barn Swallows & Dragonflies Swarming?
Why Are the Barn Swallows & Dragonflies Swarming?
-•• passion4nature/iStock/GettyImages
When you step out onto your lawn in the summertime, you're likely to notice the warm sunshine, the birds chirping and a dragonfly or two flitting through the sky. But occasionally, you might notice unusually large numbers of dragonflies swarming. So much so that you might ask yourself, 'Why are there so many dragonflies in my yard?' The same can also be said for the swift-flying barn swallows.
Both of these creatures move quickly on the wing, but that's about where their similarities seemingly end. However, you might be surprised to find that dragonflies and barn swallows often congregate in large numbers for the exact same reason!
Why Do Dragonflies Swarm?
Dragonflies have a voracious appetite and incredible skill in the air to match. These creatures are one of the most lethal hunters on the planet – if you're a small insect, that is! Adult dragonflies can skillfully capture a wide range of insect prey straight out of the sky, including butterflies, mosquitoes, flies and moths.
This prey preference helps answer the question 'Why do dragonflies swarm?' During warm, sunny days, dragonflies congregate in their preferred hunting grounds of meadows, open fields and areas close to the water to hunt their abundant insect prey. When food is aplenty, you'll find many dragonflies taking advantage of the feast.
Why Do Barn Swallows Swarm?
A graceful and agile barn swallow in flight is a sight to behold. These birds have skillful flying abilities similar to dragonflies because they feed on the same type of prey! Barn swallows readily hunt for mosquitoes, moths, bees and butterflies. Just like dragonflies, when insect prey is plentiful you're likely to find plenty of barn swallows flying in search of it above grassy fields and meadows.
When Do Dragonflies and Barn Swallows Swarm?
Whether you're watching a barn swallow flying along the tree line at your local park or a dragonfly zipping above your rhododendrons after mosquitoes, prey activity increases around the same time for both dragonflies and barn swallows. This means that both dragonflies and barn swallows can swarm around the same time when their insect prey is at its peak in population numbers.
For example, mosquito populations are highest during the warm, humid months of the summertime, particularly in regions with colder winter seasons. Mosquito populations also boom after periods of heavy rainfall, when humidity levels increase and standing water makes favorable breeding habitats plentiful. More mosquitoes mean more food for dragonflies and swallows!
A Bit of Friendly Fire
Because both of these creatures hunt the same type of prey, it might not surprise you to find that dragonflies and barn swallows can cross paths from time to time during their search for prey. Unfortunately for the dragonflies, barn swallows aren't particular about their meals and are more than happy to scoop up a dragonfly snack, fellow insect predator or not!
In the battle between dragonfly and barn swallow, the dragonfly still puts up a fair fight – or rather, flight. Though they might not have the ability to fend off the larger barn swallow, dragonflies can certainly hold their own in a flying contest. Their best bet for survival is outmaneuvering the barn swallow and hoping they have the upper hand (or wing) in their flight skills!
Do Barn Swallows Migrate?
Another important consideration in the swarming of barn swallows is their yearly migratory patterns. Not only do swallows migrate, but barn swallows travel across long distances to do so. As wintertime approaches and the weather cools, barn swallows in North America begin to congregate and fly south for warmer over-wintering grounds. They spend their winter in Central and South America before returning to North America in the spring.
Related Articles
Where Do Lightning Bugs Go During the Day?
Birds That Fly Across the Ocean
Adaptations of the Red-Tailed Hawk
What Do Wild Birds Eat?
Facts About Buzzards
Facts About the Wisconsin State Bird - American Robin
Night Birds of North America
What Kind of Song Birds Sing at Night?
How Do Buzzards Nest?
How to Attract Pigeons
Why Are Dragonflies Important?
Information on the Cardinal Bird
Birds That Eat Mosquitoes
Life Cycle of Bats
What Kind of Sound Does an Owl Make at Night?
How to Keep Fireflies Alive
What Animals Eat Worms?
How Long Do Crickets Live?
What Do Owls Eat?
What Eats Boxelder Bugs?
Dont Go!
We Have More Great Sciencing Articles!


[New England
 Complex Systems Institute]
International Conference on Complex Systems (ICCS2006)
Precursors of a phase transition in a simple model system
Vivian Halpern
Department of Physics, Bar-Ilan University, Israel
 Full text: PDF
 Last modified: August 8, 2006
Most theoretical and numerical studies of phase transitions are concerned with the statistical mechanics and critical phenomena such as correlation lengths and critical slowing down as the temperature T is lowered towards the critical temperature Tc of the phase transition. However, an understanding of the microscopic properties of the system which are precursors of the phase transition as T approaches Tc is also of interest. Our studies show that the ferromagnetic 3-spin Potts models is a simple system in which these properties can readily be studied, and we have shown that changes in the environments of the states with time and temperature are responsible for its relaxation properties. Our new calculations indicate a change in the dominant relaxation mechanism as T approaches Tc, but not a dramatic change in them at Tc. On the other hand, we found that the tendency of the spins at most sites to return to their original values after having changed (which corresponds to the disapperance of long range diffusion of molecules in liquids as they freeze) does increase dramatically at Tc, so that the increase in this tendency as the temperature is lowered is a more reliable precursor of the phase transition. The relevance of these results to the behavior of other complex systems will be discussed.
Conference Home | Conference Topics | Application to Attend
Submit Abstract/Paper | Accommodation and Travel | Information for Participants


text:
School Libraries, Information Literacy and Reading Promotion Initiatives in Spain
School libraries in Spain have evolved very quickly in recent years. The educational authorities have been approving school library development policies, and this has greatly improved the situation of these libraries in Spain. This paper will discuss three different aspects of school libraries in Spain: their current situation, plans to promote reading, and information literacy activities. First, the current situation of school libraries in Spain will be discussed, based on different types of data relating to these libraries. Second, the information literacy initiatives that are being implemented in Spain will be analyse
This work is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.

source: openbmb/Ultra-FineWeb


text:
New monitoring equipment indicates that Port Alberni is enjoying some of the best air quality it's had in years, Air Quality Council official Bernadette Wyton said.
This despite an air quality advisory that was issued earlier this week when a temperature inversion settled over the city.
According to Wyton, the new equipment atop Alberni Elementary School interfaces with a provincial weather database allowing for more comprehensive data to be generated.
The equipment measures fine particulate matter in the air. In particular, it measures Fine Particulate 2.5, which at levels over 25 micrograms trips an air quality advisory.
On Monday an air quality advisory was issued for the Valley after fine particulate measured 26 micrograms.
The cause of the advisory was two-fold, Wyton said. One, a thick, stagnant air mass is hovering over Vancouver Island trapping any smoke that goes up. And two, a recent land clearing burn contributed to the spike, she said.
Despite the event, recent measurements show that Port Alberni's air quality has been good, she added. In 2006, the Particulate Matter 2.5 average measurement prorated over the year was 12. In 2012, the average measurement for one year was 6.0. "Our air quality is lower or better than in Duncan or Courtenay."
The improvement can be contributed to a few things, Wyton said. Firstly, people are more aware of clean air and airshed issues, she said. Also, climate patterns in 2012 were wet, and rain serves to rinse particulates out of the air. A $15,000 woodstove exchange program was underwritten by the province last year in an effort to encourage up to 50 Alberni residents to replace their old stoves with cleaner burning models.
Combined with exchange programs in previous years there have been 220 old stoves swapped so far. The number equates to 15 tonnes of pollution, Wyton said. The bylaw expires after 2017 and old stoves won't be certified afterward, Wyton said.
As incentive, the city has agreed to waive the $100 wood stove inspection fee for the 50 people who have applied for the program.

source: m-a-p/FineFineWeb


text:
The number of beta adrenergic binding sites (Bmax) in human lymphocyte membranes has been reported to decrease, remain the same, or increase with age. In order to address this issue, we used two highly specific beta receptor ligands with lymphocytes from healthy aged (range: 51-90 years) and young (19-39 years) subjects in two separate studies. Because depression can reduce Bmax, potential aged subjects were excluded if they had high scores on tests for depression. Bmax was higher in the aged group of each study (33% higher in the first, p < .01, and 72.5% in the second, p < .02); the results were similar in both studies. Antagonist affinity did not differ between young and aged groups in either study. We suggest that some of the discrepancies in the literature could be due to differences in age ranges used or to inclusion of depressed subjects in prior studies.
|Original language||English (US)|
|Journal||Journals of Gerontology|
|State||Published - 1991|
ASJC Scopus subject areas


text:
Lesson 156: The Advanced Haengma 2
You may feel somewhat nervous about learning haengmas if you think you have to memorize them. However, you don't need to memorize all of them one by one. Like when learning joseki, learning about haengma will help you develop the sense to recognize the correct position of stones. In addition, perhaps you've already experienced many haengmas when you went through the difficult process of memorizing josekis. Let's see how many you can recall.
The sequence from 1 to 6 is taken from a two-space high pincer joseki. When Black covers the white stone in the corner with a knight's move at 3, White pushes up with 4 and cuts with 6. The question is Black's next move.
Because the two △-marked stones are bigger than the x-marked one, it's reasonable to do something on the lower side. However, to give an atari with 1 and push with 3 is an immature play. It doesn't become a threat to the o-marked white stone, but just helps White to develop the left side. To play A instead of pushing with 3, letting White to extend with B, isn't any good after Black makes the naive atari with 1.
The haengma in this situation is the attachment of Black 1. The sequence up to 5, White getting the left side including the △-marked black stone, while Black has an influence on the lower side, is a joseki.
If White extends on the lower side with 2 instead of on the left side as in Diag.3, Black 3, giving atari from the farther side, is another haengma. After forcing White to answer up to 8, Black can build a better influence on the lower side up to 11.
This is another situation taken from a two-space high pincer joseki. Instead of jumping out from the lower side, Black chooses to squeeze the white stone in the corner with 1. Well, after White 6, what should Black do? Please remind yourself of what you just learned.
If you guessed the attachment of Black 1 here, you are my best student! Obviously to give an atari with A is out of the question for the same reason why Black's atari in Diag.2 is bad. After Black 1, White extends with 2, and Black can go out toward the center and separate White into two groups as well.
If White doesn't allow Black to advance to the center but blocks with 2 and 4, Black will make a base with 5, forcing White to protect a cutting point with 6 and then go to the left side with 7.
This is a situation taken from a three-space pincer joseki. White 4 and 6 make two weaknesses at A and B, and Black's job is to defend both of them at the same time. To play either of the two cutting points is unsatisfactory for Black, as it leaves the other one vulnerable.
As you've learned, to attach with 1 is the answer again. If White cuts at 2, Black will develop the lower sides with 3 and 5, letting White do the same thing with 4.
If White extends with 2 in order not to give the lower side to Black, Black can connect at 3, since the cutting point at A is protected by the 1-2 exchange.
The writer is a baduk professor at Myongji University and a professional player of the game.

source: HuggingFaceFW/fineweb-edu


Does salt water take longer to boil?
In fact, adding salt does the very opposite of making water boil faster. Instead, it makes it take longer for the water to boil! The salt actually increases the boiling point of the water, which is when the tendency for the water to evaporate is greater than the tendency for it to remain a liquid on a molecular level.
Why does salt water take longer to boil?
How long does it take to boil salt water?
If you have collected water from the ocean, boil it for five minutes to kill the microscopic life in the water. Taste the salt water. It is not necessary to drink any of it. You may spit it out after tasting.
How do you speed up boiling water?
Kitchen Tip: How to Boil Water Faster
 3. Only use the amount of water that you really need. …
 4. Cover your pot.
IT IS INTERESTING: How do you boil oysters?
3 июл. 2012 г.
Does salt water heat faster than freshwater?
The higher the heat capacity the more slowly the water will heat, given the same amount of energy added. The heat capacity of freshwater is 4.182 J/(g K) and the heat capacity of salt water is 3.993 J/(g K). Therefore saltwater will heat up faster than freshwater.
Does water boil faster with sugar?
Salt raises the boiling point of water.
Dissolved solids like salt and sugar will in fact increase the boiling point of water, causing it to come to a boil more slowly, but the effect is minimal (the amounts normally used in cooking effect less than a 1 degree change).
Why does water boil faster with a lid?
Does covering the pot really make water boil faster? When you heat water in an open pot, some of the energy that could be raising the temperature of the liquid escapes with the vapor. Covering the pot prevents water vapor from escaping, enabling the temperature to rise more quickly. …
What happens if you boil salt water?
Thermal distillation involves heat: Boiling water turns it into vapor—leaving the salt behind—that is collected and condensed back into water by cooling it down. The most common type of membrane separation is called reverse osmosis. Seawater is forced through a semipermeable membrane that separates salt from water.
Why is drinking salt water harmful?
IT IS INTERESTING: Can I cook Tater Tots on parchment paper?
What makes water boil?
When a liquid reaches its boiling point bubbles of gas form in it which rise into the surface and burst into the air. This process is called boiling. If the boiling liquid is heated more strongly the temperature does not rise but the liquid boils more quickly.
Can boiled water go bad?
Can you use hot water to boil?
If you didn't realize this, you're not alone. Hot water systems like tanks and boilers contain metallic parts that corrode as time goes by, contaminating the water. Hot water also dissolves contaminants in pipes faster than cold water. And no, boiling the water does not make those contaminants (like lead) go away.
Should you cover boiling potatoes?
Once boiling, reduce the heat to a bare simmer. Do not cover. (Covering changes the environment in the pot and can make the potatoes turn mushy.) The potatoes are done when tender.
Should I add salt to my water?
While drinking salt water may be better at hydrating you than drinking normal water, it still falls short of optimal hydration. Some electrolytes aren't present in salt water. In fact, by drinking salt water you're only replenishing sodium chloride, and not any of the other essential electrolytes.
How long does it take for water to boil?
IT IS INTERESTING: How long do you boil frankfurts for?


text:
"TrendSights Analysis: Time Scarcity" looks at meeting demand for convenient, time-saving products and services.
Demand for ease and convenience derives from being time-poor and a perception of not having enough time to do all the things that one wants or needs to do. Convenience needs pervade all aspects of life, forcing dependence on highly efficient and effective products that better facilitate busy lifestyles and maximize leisure time.
GET SAMPLE REPORT @ _URL_
- Age of connectivity has fueled an "always on" mode among consumers seeking instant gratification from the products and services they use.
- Millennials heavily rely on time-saving products, and are most likely to work long hours and/or have a long commute compared to other cohorts.
- Fortification provides a "quick fix" way to boost nutrient levels, with 49% of consumers agreeing that food and drink is the most effective format for delivering health-enhancing ingredients.
Reasons to buy
- Gain insight into the different routes through which products can align with consumers' time scarcity - formulation, packaging,, and formats.
- Compare the presence of this trend in each industry across the FMCG space, and learn what the key opportunities are.
- Identify the innovation implications of Time Scarcity for your sector
Table of Content: Key Points
1 Trend Snapshot 6
2. What is Time Scarcity? 9
3. Why is Time Scarcity important? 18
4. Who is driving Time Scarcity? 20
5. How can Time Scarcity be capitalized on? 21
6. What Next in Time Scarcity? 28
7. Appendix 30
ACCESS REPORT @ _URL_
Get in touch:
Name: NORAH TRENT
Email: Send Email
Organization: WISEGUY RESEARCH CONSULTANTS PVT LTD
Address: Office No. 528, Amanora Chambers Pune - 411028 Maharashtra, India
Phone: +44 _PHONE_
Release ID: 207395


text:
Antarctica's Mount Erebus may be covered with glaciers, but they do little to cool the volcano's molten core. The world's southernmost volcano to show activity during recorded history, Erebus holds a lava lake and occasionally experiences explosive eruptions. In 2004, the reliable presence of a lava lake at this volcano's summit made Mount Erebus the perfect place to test a self-directed satellite and sensor.
This image shows two views of Mount Erebus from February 6, 2009, captured by sensors on NASA's Earth Observing-1 (EO-1) satellite. The larger image was acquired by the Advanced Land Imager (ALI), and the inset image was acquired by the Hyperion sensor. The larger image shows a true-color, photo-like view of the volcano, and the inset image shows thermal activity, highlighting the volcano's molten lava lake.
On May 7, 2004, the Autonomous Sciencecraft Experiment on EO-1 first demonstrated its ability to detect volcanic activity by sensing thermal emissions at Erebus. After the initial detection, the satellite gave itself new orders to take fresh observations of the volcano several hours later. Scientists who subsequently examined the data EO-1 acquired confirmed that a genuine thermal emission had been detected. Since that time, EO-1 has been successfully employed to detect other volcanic eruptions, including those near densely populated areas.
This Mount Erebus image shows a fairly typical level of activity for the volcano, including a molten lava lake and vapor emissions. Erebus is a stratovolcano composed of alternating layers of solidified ash, hardened lava, and rocks ejected by earlier eruptions. The volcano was erupting when British explorer Captain James Ross first observed it 1841, and it has shown continuous lava lake activity since 1972.


Loading please wait
The smart way to improve grades
Comprehensive & curriculum aligned
Try an activity or get started for free
Apply the Connection to Complete the Sentence
In this worksheet, students will identify the connection between the first two words so they can select the two words which best complete the sentence.
'Apply the Connection to Complete the Sentence' worksheet
Key stage: KS 2
Curriculum topic: Verbal Reasoning
Curriculum subtopic: Word Connections
Difficulty level:
Worksheet Overview
Greetings word detective!
Can you spot which word from the set of brackets would best finish this sentence??
Oven is to cook as refrigerator is to (store, chill, food).
First, we have to work out how the word oven is connected to the word cook. We cook in an oven, so we need to find a word which is something that we use a refrigerator for.
The correct answer is chill as we chill food in a refrigerator.
Now, let's make it more challenging.
We must pick one word from each set of brackets that can be connected to the word in front of it in the same way.
Let's look at this question:
Rest is to (relax, energy, exercise) as fit is to (exhausted, athletic, training).
First, we need to find a connection between rest and one of the words in brackets. We can connect rest to relax as they have similar meanings. These are called synonyms.
This means we need to find an synonym for fit, which is athletic.
The correct answers are relax and athletic as they are both synonyms of the words that come before them.
Let's try another:
Grape is to (vine, fruit, sweet) as raspberry is to (tree, bush, red).
First, we need to find a connection between grape and one of the words in brackets.
Vine is connected to grape as grapes grow on vines. Also fruit is connected to grape as a grape is a type of fruit.
We need to see if one of these connections can be made with raspberry and the words in brackets that are linked to it.
With raspberries, they grow on a bush.
We have found the connection!
It's the name given to the plants the fruits grow on.
Now it's your turn.
Remember to find those connections!
Connection Example
Synonyms (similar meanings) Start is to begin
Antonyms (opposite meanings) On is to off
What something is made of Shirt is to cotton
What goes inside of Tea is to teapot
What is EdPlace?
Get started
Try an activity or get started for free
 - educational
 - bettfutures
 - cxa
 - pta
 - era2016
 - BDA award
 - Explore LearningTuition Partner
 - tacm


php[world] 2015 Schedule Announced
geoip_db_filename
(PECL geoip >= 1.0.1)
geoip_db_filenameReturns the filename of the corresponding GeoIP Database
Description
string geoip_db_filename ( int $database )
The geoip_db_filename() function returns the filename of the corresponding GeoIP Database.
It does not indicate if the file exists or not on disk, only where the library is looking for the database.
Parameters
database
The database type as an integer. You can use the various constants defined with this extension (ie: GEOIP_*_EDITION).
Return Values
Returns the filename of the corresponding database, or NULL on error.
Examples
Example #1 A geoip_db_filename() example
This will output the filename of the corresponding database.
<?php
print geoip_db_filename(GEOIP_COUNTRY_EDITION);
?>
The above example will output:
/usr/share/GeoIP/GeoIP.dat
add a note add a note
User Contributed Notes 1 note
up
0
Loc d'Anterroches
4 years ago
To quickly know which databases are available on your system:
<?php
$cst
= array(

'GEOIP_COUNTRY_EDITION' => GEOIP_COUNTRY_EDITION,

'GEOIP_REGION_EDITION_REV0' => GEOIP_REGION_EDITION_REV0,

'GEOIP_CITY_EDITION_REV0' => GEOIP_CITY_EDITION_REV0,

'GEOIP_ORG_EDITION' => GEOIP_ORG_EDITION,

'GEOIP_ISP_EDITION' => GEOIP_ISP_EDITION,

'GEOIP_CITY_EDITION_REV1' => GEOIP_CITY_EDITION_REV1,

'GEOIP_REGION_EDITION_REV1' => GEOIP_REGION_EDITION_REV1,

'GEOIP_PROXY_EDITION' => GEOIP_PROXY_EDITION,

'GEOIP_ASNUM_EDITION' => GEOIP_ASNUM_EDITION,

'GEOIP_NETSPEED_EDITION' => GEOIP_NETSPEED_EDITION,

'GEOIP_DOMAIN_EDITION' => GEOIP_DOMAIN_EDITION,
 );
foreach (
$cst as $k=>$v) {
 echo
$k.': '.geoip_db_filename($v).' '.(geoip_db_avail($v) ? 'Available':'').'<br>';
}
?>
The only drawback of the PECL extension with respect to a pure PHP implementation is that you cannot select yourself where the database is. So, if you get a new version of the database, you need to put in the standard place and you may need root access to do so.
To Top


text:
BY JULIE FINZEL Contributing writer
The presence of poisonous plants in (or around) your home could affect anyone, at any time. Many of the plants that are poisonous to humans are also poisonous to pets and livestock. According to the California Poison Control System, exposure and consumption of poisonous plants is ranked as the No. 5 most common incidence of poisoning. The CPCS also reports that 51 percent of all poison exposures involve children 5 years and younger, and that 94 percent of poison exposures occur in the home.
A very commonly planted shrub here in Bakersfield, which is considered one of the most poisonous plants in the Southwest, is oleander (nerium oleander). The toxic compound in oleander is a cardiac glycoside that, when consumed in relatively small amounts can cause dizziness, irregular heartbeat, nausea, convulsions and death. Oleander is toxic to humans, pets and livestock and as few as five to 10 medium-sized leaves can be lethal for a horse or cow.
All are welcome at the UC Cooperative Extension's annual fruit tree pruning demonstrations, taking place Wednesday and Thursday at the orchard adjacent to the UCCE office, 1031 S. Mt. Vernon Ave.
Demonstrations will begin at noon each day, led by the extension's Mario Viveros. Trees include apple, apricot, cherry and almond, and Viveros will also show how to prune grapevines.
The beneficial climate of Kern County allows residential planting of many deciduous fruit tree species. Unlike shade trees, deciduous fruit trees should be pruned every year before bud swell for optimum growth and yield.
Pruning need not be complicated, but fruit trees are less forgiving than most shade tree species, and if pruned incorrectly the yield of fruit will be reduced or eliminated, and the life of the tree will be shortened. Pruning diagrams or photographs in books or on the Internet may be helpful, but demonstrations offer the advantage of seeing pruning in person and being able to ask questions.
To reach the UCCE office and orchard, take Highway 58 and exit at Mt. Vernon, then proceed south for about three-quarters of a mile.
Publications on pruning, fertilizer for fruit trees, and fruit tree varieties for the valley portion of Kern County will be available. There is no charge for attendance, nor is preregistration required.
-- John Karlik, adviser with the UC Cooperative Extension
Other common poisonous plants include poinsettias, lilies, sago palms, morning glories, some hydrangeas, and impatiens. This is by no means a complete list. The CPCS has a very thorough listing of poisonous plants at _URL_.html. The report, titled "Know Your Plants," can be downloaded for free. A number of toxic plant resources are also posted on my website at cekern.ucdavis.edu/Livestock/info.
There are a number of substances produced by plants that can cause them to be poisonous. Some of the most common compound classes are oxalates, glycosides and alkaloids. Some plants even contain well-known poisons, like cyanide. The toxicity of a plant can vary from the leaves to the stem to the roots and it can also vary by season.
The toxicity of a plant also varies by species. Some species are more poisonous than others, meaning small amounts can be dangerous, while others are less poisonous, meaning that it takes a greater quantity for the plant to have an effect. The toxicity of the plant also depends on the weight of the individual consuming it. A lighterweight person may be more susceptible than someone who weighs more.
In case of accidental exposure to a potentially poisonous substance, the CPCS recommends that you remain calm. If a patient is unconscious, having convulsions or any difficulty breathing, call 911. Otherwise, the CPCS can be reached toll free, 24 hours a day, seven days a week at _PHONE_. For further information and first aid recommendations visit the CPCS website at calpoison.org.
Tips to avoid poison exposure
Preventing exposure to poisonous plants is the best way to prevent potential poisonings and can be accomplished by following a few basic tips:
Consider removing toxic plants from your home or garden.
Know the common and scientific name of every plant you buy and own and keep a list for reference. This is best accomplished by labeling each plant. Show all caretakers where the labels and list are kept.
House plants should not be within reach of young children.
Store labeled bulbs and seeds out of reach of children and pets.
Do not eat plants or mushrooms collected outdoors unless you are certain they are safe.
Teach children not to put any part of a plant in their mouth.
Don't let children chew on jewelry made from seeds or beans.
Dispose of plant clippings in a safe manner. Do not allow children and pets access.
The smoke from poisonous plants can also be toxic; don't burn plant clippings unless you are certain they are safe.
In general, plants toxic to humans are also toxic to pets.
One of the tips above mentions mushrooms. Some species of mushrooms are edible, however, some species of mushrooms are quite poisonous and there is no easy way to tell the difference.
Eating any mushrooms collected outside should be considered dangerous and avoided.
Some symptoms of severe mushroom poisoning can include intense diarrhea and can lead to liver failure and death.
Call the CPCS if you believe someone has been poisoned. Do not wait until symptoms appear, as symptoms are sometimes delayed many hours, even in cases of severe poisoning.
Some plants and plant parts that are not poisonous to humans are poisonous to pets.
These include: grapes, raisins, macadamia nuts, onions and chocolate. A partial listing of human food that is poisonous to pets can be found at vetmed.ucdavis.edu/ccah/health_information/plants_pets.cfm and petinsurance.com/healthzone/pet-articles/pet-health-toxins/Toxic-Food-Guide-for-Pets.aspx.
Be sure to talk to your vet to receive a more complete list and before feeding any human food to your pet as serious side effects can result.
Julie Finzel is the livestock and natural resources adviser with the UC Cooperative Extension in Bakersfield.


text:
Smoke from brush fires can aggravate residents who suffer from upper respiratory system conditions or heart and lung problems such as asthma and emphysema.
The Volusia County Health Department offers these tips for persons with respiratory problems:
- Avoid physical exertion and outdoor activity in areas with smoke. This caution also extends to young children and the elderly.
- Individuals who have respiratory conditions and do not have access to air conditioning should consider spending time in areas such as shopping malls, public libraries or museums.
- If you feel you are experiencing adverse health effects, contact a physician for an evaluation or advice.
- Residents are urged to exercise caution in accordance with local area conditions.
Additional information can be found at _URL_.


text:
- Aims and Objectives
- Focus Topics for Discussion
- General Information
- Abstract Submission
- Online Registration
- Scientific Session Agenda
Aims and Objectives:
- Provide an opportunity to local health professionals and researchers to update on the latest developments in the field of medical and health sciences.
- Facilitate better cooperation and collaboration among healthcare providers and researchers.
- Provide a scientific platform to present research findings on health sciences for the local as well as international health professionals and researchers.
- Encourage research on the principles and practice of medical and health sciences.
- Encourage Bhutanese health professionals to gather at least once in a year for a scientific session to update and share professional experiences.
1. Primary Health Care services in the wake of covid
2.Maternal and Child health services
3.Innovative health service delivery
4.Sharing of experiences and management of covid and beyond
5.Leadership in times of pandemic
|Date||18 – 20 November 2020 (Wed-Fri)|
|Host||Khesar Gyalpo University of Medical Sciences of Bhutan|
|Language||English and Dzongkha|
||Mr. Tashi Norbu,
Phone No: +975-77109559
|Abstract||The Scientific Committee reviews the submitted abstracts. The outcome of the selection will be notified accordingly. Abstracts must be submitted online|
|Speakers||To be announced|
|Certificate of participation||A certificate of attendance will be issued to all.|
|REGISTERATION IS CLOSED


text:
- Is Product ID same as serial number?
- What does serial number look like?
- What can someone do with a serial number?
- What is the serial number of a document?
- What does Apple serial number tell you?
- Are serial numbers unique?
- How do you write a short serial number?
- Is it OK to give out serial number?
- Is it safe to give someone your iPhone serial number?
- How do I get the serial number for my product?
- Where would the serial number?
- What happens if someone gets your iPhone serial number?
- How many digits are in a serial number?
- Does Apple Support ask for serial number?
- How do I find my stolen Apple serial number?
- Is a serial number the same as IMEI?
Is Product ID same as serial number?
It is important to look for the term "Serial Number," "Ser.
No.," or "SN" since there may be other numbers listed, such as the product ID, network ID, or UPC.
NOTE: In software, the term "serial number" may also be used synonymously with "activation key." However, this has become less common in recent years..
What does serial number look like?
A serial number is a unique identifier assigned to a device during the manufacturing process. It's not necessarily a number—serial numbers can contain letters and symbols as well as numbers. One device's serial number may look like "123456", while another device's may look like "ABC123!@#
What can someone do with a serial number?
Chances of this actually happening are very low, but in case someone gets their hand on your serial number, they can falsely push for a part request or replacement of the device. Also Read: How to Find IMEI Number of Lost or Stolen Android and iPhone.
What is the serial number of a document?
A serial number is a unique identifier assigned incrementally or sequentially to an item, to uniquely identify it. Serial numbers need not be strictly numerical. They may contain letters and other typographical symbol, or may consist entirely of a character string.
What does Apple serial number tell you?
The serial numbers of Apple products contain a codified language that can give you information about your Apple device that can't be found through any other means—everything from the location where it was manufactured, the date it was manufactured, and much more.
Are serial numbers unique?
Serial numbers are unique to each specific product and are most frequently used for electronics. … It's that number on the barcode tag on the bottom of your laptop.) Serial numbers are used to track the ownership information of an item. They can also be used to track warranty information.
How do you write a short serial number?
This page is about the various possible meanings of the acronym, abbreviation, shorthand or slang term: Serial Number. Rate it: S.R. NO.
Is it OK to give out serial number?
If an eBay buyer asks for the serial number on something other than a phone (see the section on IMEI numbers above for that), it's usually pretty safe to give out. However, the buyer could file a false police report using the serial number and try to convince the cops you have their "stolen" item.
Is it safe to give someone your iPhone serial number?
Honestly, there is not much anyone can do with an iPhone SN. The phone's IMEI number is far more important. Checking warranty staus is really about it. … I wouldn't mention the serial number in the ad, but if somebody show genuine interest in buying your phone it is safe to reveal that information.
How do I get the serial number for my product?
Complete the following steps to have the software automatically create the serial number:Open the serialized inventory item record by selecting Product Catalog from the main Inventory menu.Select the serialized item from the inventory look up list and click on the Serial Numbers tab.
Where would the serial number?
To find your device's serial number in the software, go to Settings > System. Then jump into About Phone > Status. Your device's serial number will generally be located toward the bottom of this screen.
What happens if someone gets your iPhone serial number?
Unless your device is jailbroken, or someone has access to your unlocked device, they cannot hack it, especially with just your serial number. The ID numbers will not help either. The hacker would have to have physical access to your device, it to be unlocked, and for Find My iPhone to be disabled.
How many digits are in a serial number?
The entire serial number will appear somewhere on the receiver of the gun, and other major parts will usually have the last 4 or 5 digits. If it's been used, the other parts mayor may not match the receiver serial number. Then: It wasn't until 1968 that companies started routine use of alphanumeric serial numbers.
Does Apple Support ask for serial number?
When you contact Apple for support, you can use the serial number or the IMEI/MEID number to identify your iOS device.
How do I find my stolen Apple serial number?
Enter Apple's new Activation Lock status check tool. All you have to do is visit Apple's Activation Lock status check page, enter the device's serial number or IMEI, and it will tell you if it is locked or not.
Is a serial number the same as IMEI?
The serial number is a unique number assigned by the manufacturer (like Samsung) to help identify an individual device, like a phone, tablet, TV, and so on. … On the other hand, an IMEI or MEID is only used for phones or other communication devices. Depending on the carrier, your device will have either an IMEI or MEID.


Shortcut: Replace Tabs with Spaces and do Macro-like work in SSMS using Regular Expressions
There are so many useful things in SQL Server Management Studio (SSMS) and daily, I come across users who aren't aware of common useful functions.
A request that I hear all the time, is "I don't like tabs but <insert name of annoying colleague here> decided he likes to use them. How do I remove them?" Now SSMS allows you to choose to use spaces instead of tabs (in Tools > Options) but that doesn't fix existing tabs.
The regular expression functions in SSMS let you do this. Hit Ctrl-H to open the Find and Replace dialog (or use the Edit > Find and Replace > Quick Replace menus), then configure the window as follows:
Note that I've clicked the little square and asterisk thing (which says to use regular expressions), then put the change from text to \t which is a tab, and set the change to text to four spaces (or however many you want), then I click the Replace All button and magically all my tabs are replaced.
But this is just the start of what we can do.
For example, if I have a long row of comma-delimited values like this:
Now I could go to each comma and hit enter after each one. That's what I see most people doing. But you could do this:
I'm changing a comma to a comma followed by a carriage return. And magically, this is the outcome:
There are so many things you can use this regular expression functionality for within SSMS. I encourage you to try it out.

2 thoughts on "Shortcut: Replace Tabs with Spaces and do Macro-like work in SSMS using Regular Expressions"
 1. Awesome tip and tool … but as with any tool, use caution with "replace all" … tabs in data will be replaced along with SSMS formatting tabs.
 example:
 declare @x varchar(100) = '123 (tab)456' –<——–[ could be a breaking change! ]
Leave a Reply
Your email address will not be published. Required fields are marked *


text:
High Level Water Collection cooling tower is used for nature draft cooling tower who substitute bottom water transferred to water channel by high level water collection device and out to pump room. Then, it will be sent back to main power house by pump for recirculation. Other components such as water distribution system, filling and drift eliminator areas usual High level water collection device contains drift cant board, collection channel and spray proof filling. It is erected be ween air inlet and filling.
‐Low noise: The rain zone height is lower, and the spray proof f lling can work as noise reduction padding
‐Low investment and economical: High level water collection is normally used for large size of cooling towers.


Word Sorter
To sort words into alphabetical order paste your text into the box on the left and click the green "sort" button.
What is this tool?
This tool sorts words in a block of text from a to z. You do not need to remove characters that are typically found in paragraphs such as commas and full stops as this is automatically done during the sorting process.
To copy the output you can click the small icon on the bottom right of the output text area.


text:
- Solar Block/Cancellation/Nullification
The user can negate solar energy and any solar-using attacks, ignoring their effects, such as the sun's heat, the sunlight, the radiation, etc.
- Power Negation
- Solar Energy Absorption
- Solar Energy Manipulation
- Solar Manipulation
- Sun Blocking
- May not work at night.
- Does not work against those with negation immunity.
- Negating solar energy may have harmful effects on the area.
- Perfect Kars (JoJo's Bizarre Adventure Part II: Battle Tendency)
- Count Heinrich von Kinkel (Tsukuyomi: Moon Phase)


This article aims to simplify the concepts of generic repository and CRUD operations in ASP.NET Core using a Web API. For this, we build a simple application and implement the process of Creating, Reading, Updating and Deleting records from a database to demonstrate the CRUD concepts using generic repository methodology.
A Web API Operations In ASP.NET Core
To get along with this article, you need to have SQL Server and Visual Studio (we used Visual Studio 2019) installed on your system.
Here is how you do it:
 1. Open Visual Studio 2019.
 2. In the Visual Studio 2019 welcome screen that launches, select Create a new project from the options shown on the right.
 3. In the following screen, select ASP.NET Core Web Application.
 4. Click Next.
 5. There is the New ASP.NET Core Web Application window that will open next. Select the Web Application (Model-View-Controller) option here.
 6. Select the Configure for HTTPS checkbox at the bottom.
 7. Click OK.
 8. In the Configure your new project window that opens, enter a project name.
 9. Click on the Create button.
 10. In the Solution Explorer window, create a new folder and name it Models.
 11. Thereafter, in the Models folder, create a new class and name it Employees.
 public class Employees
 {
 [Key]
 public int ID { get; set; }
 public string Name { get; set; }
 public string Email { get; set; }
 }
Add an interface to the Models class and name it IDataRepository. Add the following code.
 public interface IDataRepository<TEntity>
 {
 IEnumerable<TEntity> GetAll();
 TEntity Get(int id);
 void Add(TEntity entity);
 void Change(TEntity dbEntity, TEntity entity);
 void Delete(TEntity entity);
 }
Adding an interface is necessary for implementing Generic Repository as this would allow for defining generic functions. Overall, five methods are being declared for CRUD operations. The methods will then be implemented in the action class of each model.
Next, add an Action class. Add a class and name it EmployeesManager. Add the following code in the EmployeesManager class.
 public class EmployeesManager : IDataRepository<Employees>
 {
 readonly DbContext dbContext;
 public EmployeesManager(DbContext context)
 {
 dbContext = context;
 }
 public IEnumerable<Employees> GetAll()
 {
 return dbContext.Employees.ToList();
 }
 public EmployeeGet(int id)
 {
 return dbContext.Employees
 .FirstOrDefault(e => e.ID == id);
 }
 public void Add(Employees employees)
 {
 dbContext.Employees.Add(employees);
 dbContext.SaveChanges();
 }
 public void Change(Employees employees, Employees entity)
 {
 employees.Name = entity.Name;
 employees.Email = entity.Email;
 dbContext.SaveChanges();
 }
 public void Delete(Employees employees)
 {
 dbContext.Employees.Remove(employees);
 dbContext.SaveChanges();
 }
 }
As is evident from the code above, the IDataRepository interface inherits the EmployeesManager class. Also, all the methods that have been defined in IDataRepository interface get implemented in this class for CRUD operations.
Next, add a new class and name it DbContext and add the following code to the class.
 public class DbContext
 {
 public DbContext(DbContextOptions<DbContext> options)
 : base(options)
 {
 }
 public DbSet<Employees> Employees { get; set; }
 }
Add the following connection string in your appsetting.json file.
{
 "Logging": {
 "Loglevel": {
 "Default": "Warning"
 }
 },
 "ConnectionString": {
 "tDB": "server= xyz; database=Database;integrated security = true;"
 },
 "AllowedHosts": "*"
}
Next for implementing the CRUD operation, you will have to add a Controller for Employees Class. For this, add a New Controller and name it EmployeesController. Add the following code in EmployeesController.
 public class EmployeesController : Controller
 {
 private IDataRepository<Employees> _repository;
 public EmployeesController(IDataRepository<Employees> repository)
 {
 _repository = repository;
 }
 // GET: api/<controller>
 [HttpGet]
 public IActionResult Get()
 {
 IEnumerable<Employees> employees = _repository.GetAll();
 return Ok(employees);
 }
 // GET api/<controller>/5
 [HttpGet("{id}")]
 public IActionResult Get(int id)
 {
 Employees employees = _repository.Get(id);
 if (employees == null)
 {
 return NotFound("The Employee record couldn't be found.");
 }
 return Ok(employees);
 }
 // POST api/<controller>
 [HttpPost]
 public IActionResult Post([FromBody]Employees employee)
 {
 if (employee == null)
 {
 return BadRequest("Employee is Null");
 }
 _repository.Add(employee);
 return CreatedAtRoute("Get", new { Id = employee.ID }, employee);
 }
 // PUT api/<controller>/5
 [HttpPut("{id}")]
 public IActionResult Put(int id, [FromBody]Employees employee)
 {
 if (employee == null)
 {
 return BadRequest("Employee is null");
 }
 Employees employeeToUpdate = _repository.Get(id);
 if (employeeToUpdate == null)
 {
 return NotFound("Employee could not be found");
 }
 _repository.Change(employeeToUpdate, employee);
 return NoContent();
 }
 // DELETE api/<controller>/5
 [HttpDelete("{id}")]
 public IActionResult Delete(int id)
 {
 Employees employee = _repository.Get(id);
 if (employee == null)
 {
 return BadRequest("Employee is not found");
 }
 _repository.Delete(employee);
 return NoContent();
 }
 }
Implement the CRUD operations
The process starts by creating a Web API:
For that, create a new project in Visual Studio and it a name, say CRUD_operation.
In the next window that opens, select the Web API template.
Click OK.
In Solution Explorer, add a new API Controller and the name is EmployeesController.
Create a new SQL table and name is Employees.
Next, add an ADO.NET Entity Data Model for your database.
Finally, you will also be required to create an 'Entities' class object in EmployeesController, the new API controller you just created.
Now for the actual CRUD operations:
For the READ operation:
There are two GET methods to accomplish the same, the code snippets for which is added below.
This method does not accept any parameters and returns a list of all employees.
 public IEnumerable<Employees> Get()
 {
 return db.Employees.ToList();
 }
This method accepts an ID as a parameter and will return the only record that matches that ID.
 public EmployeeGet(int id)
 {
 Employees employees = db.Employees.Find(id);
 return employee;
 }
For Create operation:
This is accomplished by the POST method in API. In the POST method shown here, the method will accept an Employee as a parameter and will add the same in the database as a new record.
 public void POST(Employees employee )
 {
 db.Employees.Add(employee);
 db.SaveChanges();
 }
For Update operation:
This is accomplished by the PUT method and will accept a parameter to update the details that match with that parameter, which generally is the ID related to that employee.
 public void PUT(int id, Employees employee)
 {
 var emp = db.Employees.Find(id);
 emp.Email = employee.Name;
 emp.FullName = employee.Email;

 db.Entry(emp).State = System.Data.Entity.EntityState.Modified;
 db.SaveChanges();
 }
For Delete operation:
This again is accomplished by the method of the same name, .i.e. is the DELETE method. Also, the method takes an ID as a parameter and will delete the record that matches that parameter.
 public string Delete(int id)
 {
 Employees employee = db.Employees.Find(id);
 db.Employees.Remove(employee);
 db.SaveChanges();
 return "Employee Deleted";
 }
Conclusion:
So, this should serve as a guide to understanding the concept of generic repository and CRUD operations in ASP.NET Core using Web API.
Related Articles
Last modified: December 14, 2019
Comments
Write a Reply or Comment
Your email address will not be published.


text:
Do we really think that the Earth–the Mother of all Life–is some damsel in distress who can't take care of herself?
The staple food source in most of Southeast Asia is rice. It is a plant that acquires its nutrients from the water–and not the soil in which it grows.
In shaded corners of sultry groves across Kerala, you can find stone deities coated in turmeric nestled at the foot of a tree. These shrines mark a sacred space known as the sarpa kavu or snake forests.


text:
The Mayor's Interagency Task Force on Truancy, Chronic Absenteeism and School Engagement has launched the nation's boldest, most comprehensive effort to combat truancy and chronic absenteeism in NYC's public schools. Established by Mayor Bloomberg in 2010 in partnership with the NYC Department of Education, the Task Force has piloted innovative, data-driven programs and policies in 100 pilot schools to help identify best practices for schools citywide.
The results have been promising: during the 2011-2012 school year, Task Force schools outperformed comparison schools across elementary, middle and high schools in reducing chronic absenteeism. In fact, chronically absent students with Success Mentors, one of the core initiatives, gained 11,800 additional days of school as compared to chronically absent students at comparison schools.
Research shows that the consequences of chronic absenteeism are severe: three out of four students who are severely chronically absent – meaning they missed 38 or more days of school – in the sixth grade never graduate from high school. In addition, nearly 80 percent of children in New York City's juvenile justice system were chronically absent in the period preceding their arrest.
Chronic absenteeism is not solely a Department of Education issue. Because the causes of chronic absenteeism are complex and varied, it is a city-wide and community-wide issue that requires strategic collaboration of key city agencies and other multi-sector organizations.
Download an Infographic About Truancy and Absenteeism in (PDF)
Download an overview of the Truancy Task Force (in PDF)


The Ultimate Solution for What Is a Slug Physics
The Benefits of What Is a Slug Physics
When you begin, it's a good deal simpler to stay in motion. Now things began to get really intriguing. Read a couple of jacket blurbs, to find an awareness of the manner that it's finished.
The Debate Over What Is a Slug Physics
Awards made at the right time of admissions are created on the grounds of merit only. On all homework you must demonstrate all your work for nearly any credit. People working inside this lab proved also instrumental help write my essay in creating the exact first School of Chemistry in the country at UCV.
What Is a Slug Physics Secrets
For reverse unit aspects to convert into pfsf please click on the proper unit below. Soil includes soil, water and organic issue. The aim is to simply nick the tubing.
Ideas, Formulas and Shortcuts for What Is a Slug Physics
I think your question is one of several answers and interpretations, which makes it a fantastic question, but very challenging to reply. These scientific statements help to spell out the character of matter and motion. Expert witnesses are many times called by either side for explanations.
Whatever They Told You About What Is a Slug Physics Is Dead Wrong…And Here's have a peek at this website Why
Because high-speed applications have a tendency to manage thin material, you may usually lessen the land. The manufacturer did a amazing testing on the ammo simply to make certain that it is working well. In everyday usage, units like the pound-force are occasionally utilized in place of newtons in nations like the usa.
There's a complete column specializing in slugs. By way of example, how slugs move is a fantastic example. Tiny Little Slug features a great deal of interesting tidbits.
Its motion is known as projectile motion. Electrons on the conductor will be repelled from the area nearest the charged object. Galilean is the thing that appears intuitive.
At the finish of the day, even if you go to a exceptional academic institution, it's dependent on what you learnt and how you leverage it and increase the job. Even in the event you work in a group, it's still your duty to understand the work you hand in. Each tutor is necessary to go through an exhaustive ID check.
The Ultimate What Is a Slug Physics Trick
Immersing the LED in liquid nitrogen _URL_ results in the electrons to get rid of a whole lot of thermal energy, which raises the bandgap. These varieties of resistors are commonly utilized in the electronic circuits. See that the quantity of moles does not have to balance on both sides of the equation.
How to Get Started with What Is a Slug Physics?
In that situation, the pressure-area term in the overall equation is equivalent to zero. Inside this circumstance, two equations could possibly be employed to fix the issue. Though the pound-force might still be utilised in some specific contexts, it isn't a widely used unit of measurement.
Here's What I Know About What Is a Slug Physics
Acceleration is the rise in speed or velocity above a time period. Distance is a good example of a scalar quantity. Voltage measurement related to ground.
When you examine a speedometer in a vehicle, you're seeing the instantaneous speed. Let's see the reason why this is true. Say you grow to be a drag racer so as to analyze your acceleration farther down the dragway.
What You Should Do to Find Out About What Is a Slug Physics Before You're Left Behind
To be sure, biological databases can easily be accessible and datasets may be located on the internet that could serve as challenge problems for classification, and so forth. Therefore, the state level data may not be entirely accurate. Somewhere deep in your algorithm or the manner in which you implement your algorithm you're leaking information, which could completely defeat the purpose of the whole encryption, said Bhargavan.
Anyway, there are numerous endowment scholarships provided by the Institute. Also amazing, the plastids can stay functional for around a year! The slow start may also cause problems.
Indeed, it might be applied as such. Famous foreign publications within the field of physics consist of IE Irodov and SS Krotov. That means you'll get what you desire.
To permit physics, you have to first prepare the physics world. If you're facing any problem associated with computational physics homework or algorithm writing, you might simply approach us. It is most certainly the most fundamental and fundamental science.
So that your mass doesn't change based on where you're. A shotgun's gauge is set by the variety of round projectiles of equal diameter that could be subdivided from 1 pound of lead. In discussing the creation and application of energy it is frequently convenient to talk with respect to the bulk sum of fuel, e.g. a barrel of oil or a whole lot of coal.


Enable or disable the properties of a command-queue.
cl_int clSetCommandQueueProperty( cl_command_queue command_queue,
 cl_command_queue_properties properties,
 cl_bool enable,
 cl_command_queue_properties *old_properties)
Specifies the command-queue being queried.
Specifies the new command-queue properties to be applied to command_queue. Only command-queue properties specified for clCreateCommandQueue can be set in properties; otherwise the value specified in properties is considered to be not valid.
Determines whether the values specified by properties are enabled (if enable is CL_TRUE) or disabled (if enable is CL_FALSE) for the command-queue. The allowed property values are the same as those specified for clCreateCommandQueue.
Returns the command-queue properties before they were changed by clSetCommandQueueProperty. If old_properties is NULL, it is ignored.
As specified for clCreateCommandQueue, the CL_QUEUE_OUT_OF_ORDER_EXEC_MODE_ENABLE command-queue property determines whether the commands in a command-queue are executed in-order or out-of-order. Changing this command-queue property will cause the OpenCL implementation to block until all previously queued commands in command_queue have completed. This can be an expensive operation and therefore changes to the CL_QUEUE_OUT_OF_ORDER_EXEC_MODE_ENABLE property should be only done when absolutely necessary.
It is possible that a device(s) becomes unavailable after a context and command-queues that use this device(s) have been created and commands have been queued to command-queues. In this case the behavior of OpenCL API calls that use this context (and command-queues) are considered to be implementation-defined. The user callback function, if specified when the context is created, can be used to record appropriate information in the errinfo, private_info arguments passed to the callback function when the device becomes unavailable.
Returns CL_SUCCESS if the command-queue properties are successfully updated. Otherwise, it returns the following:
 - Returns CL_INVALID_COMMAND_QUEUE if command_queue is not a valid command-queue.
 - Returns CL_INVALID_VALUE if the values specified in properties are not valid.
 - Returns CL_INVALID_QUEUE_PROPERTIES if the values specified in properties are not supported by the device.
OpenCL Specification
Also see
clCreateCommandQueue, clGetCommandQueueInfo, clReleaseCommandQueue, clRetainCommandQueue


text:
Researchers at Georgia Tech and Duke University have created a wirelessly powered robot swarm. Their demo robot swarm consists of five robots performing a line following task, each consuming 200mW. The fundamental design looks quite straight-forward, relying on a robot arena surface equipped with a transmit coil and robots with a receiving coil positioned between their wheel base close to the ground.
A circulating current in the transmit coil generates a magnetic flux which transfers power to the robots via inductive-coupling. The technology is great news for people working with swarms of dozens or hundreds of robots which currently require laborous connection and deconnection to charging stations. Details of the setup used, including a detailed description and circuit diagrams, are available online
Links:Surface Based Wireless Power Transmission and Bidirectional Communication for Autonomous Robot Swarms (PDF)Video


Take the 2-minute tour ×
It would seem that one way of proving this would be to show the existence of non-algebraic numbers. Is there a simpler way to show this?
share|improve this question
A finite dimensional vector space over $\mathbb{Q}$ is countable. – user641 Oct 7 '10 at 2:19
_USER_: Please add that as an answer so people can upvote. – Aryabhata Oct 7 '10 at 2:50
Does that mean that a vector space over $\mathbb{Q}$ is finite-dimensional iff the set of the vector space is countable? If so, please prove it. – Isaac Solomon Oct 7 '10 at 2:55
_USER_ Your question doesn't require the 'only if' anyway. Steve's observation answers your original question. – yasmar Oct 7 '10 at 3:04
_USER_: how is the fact that $\mathbb{R}$ is finite dimensional over itself relevant? – Arturo Magidin Oct 7 '10 at 3:31
show 2 more comments
4 Answers
up vote 52 down vote accepted
As Steve D. noted, a finite dimensional vector space over a countable field is necessarily countable: if $v_1,\ldots,v_n$ is a basis, then every vector in $V$ can be written uniquely as $\alpha_1 v_1+\cdots+\alpha_n v_n$ for some scalars $\alpha_1,\ldots,\alpha_n\in F$, so the cardinality of the set of all vectors is exactly $|F|^n$. If $F$ is countable, then this is countable. Since $\mathbb{R}$ is uncountable and $\mathbb{Q}$ is countable, $\mathbb{R}$ cannot be finite dimensional over $\mathbb{Q}$. (Whether it has a basis or not depends on your set theory).
Your further question in the comments, whether a vector space over $\mathbb{Q}$ is finite dimensional if and only if the set of vectors is countable, has a negative answer. If the vector space is finite dimensional, then it is a countable set; but there are infinite-dimensional vector spaces over $\mathbb{Q}$ that are countable as sets. The simplest example is $\mathbb{Q}[x]$, the vector space of all polynomials with coefficients in $\mathbb{Q}$, which is a countable set, and has dimension $\aleph_0$, with basis $\{1,x,x^2,\ldots,x^n,\ldots\}$.
Added: Of course, if $V$ is a vector space over $\mathbb{Q}$, then it has countable dimension (finite or denumerable infinite) if and only if $V$ is countable as a set. So the counting argument in fact shows that not only is $\mathbb{R}$ infinite dimensional over $\mathbb{Q}$, but that (if you are working in an appropriate set theory) it is uncountably-dimensional over $\mathbb{Q}$.
share|improve this answer
Related to the note about uncountable dimension, there are explicit examples of continuum-sized linearly independent sets, as seen in this MathOverflow answer by François G. Dorais: mathoverflow.net/questions/23202/… – Jonas Meyer Oct 7 '10 at 4:18
Yes: but can one show that there is a basis for $\mathbb{R}$ over $\mathbb{Q}$ without some form of the Axiom of Choice? (There is a difference between exhibiting a large linearly independent subset and exhibiting a basis). – Arturo Magidin Oct 7 '10 at 14:51
No, one cannot, but without the Axiom of Choice the notion of dimension breaks down (except for finite vs. infinite). Assuming AC (as I virtually always do), the size of a linearly independent set gives a lower bound on the dimension of the vector space, and I think it is wonderful that in this case such "explicit" proof exists that the real numbers have continuum dimension, as opposed to the nice qualitative proof one could give by extending your argument to larger cardinals. – Jonas Meyer Oct 7 '10 at 16:02
_USER_: No argument there (with any of your points). – Arturo Magidin Oct 7 '10 at 17:23
good link _USER_, thanks – Leon Lampret Sep 23 '11 at 0:23
add comment
The cardinality argument mentioned by Arturo is probably the simplest. Here is an alternative: an explicit example of an infinite $\rm\: \mathbb Q$-independent set of reals. Consider the set consisting of the logs of all primes $\rm\: p_i\:$. Then if $\rm\ \: c_1\ log\ p_1 +\:\cdots\: + c_n\ log \ p_n \: =\ 0\:,\ \: c_i\in\mathbb Q\:,\: $ multiplying by a common denominator we can assume that all $\rm\ c_i \in \mathbb Z\:,\:$ and, exponentiating, we obtain $\rm\: p_1^{\:c_1}\cdots p_n^{\:c_n} = 1\ \Rightarrow\ c_i = 0,\:$ for all $\rm\:i\:$.
share|improve this answer
_USER_ +1 What a nice example. – Adrián Barquero Oct 7 '10 at 4:50
_USER_. Wow! :-) – a.r. Oct 7 '10 at 6:08
Is this proof unique to Q or does it generalize to provide explicit examples of reals linearly independent over, e.g., Q(sqrt(2))? Above, Q appears to be "hard-wired" into the proof, as the group of exponents in the prime factorization. – T.. Oct 12 '10 at 7:14
_USER_ S. "Then, any number field has a finite extension whose class number is 1." This would imply in particular that there are infinitely many number fields of class number one, which I am pretty sure is an open problem. I wonder what you are thinking here? – Pete L. Clark Jan 22 '11 at 10:20
Can you extend the idea of this proof to get the right dimension? Currently, you only have a countably infinite independent set, but the dimension is size continuum. – JDH Jun 23 '11 at 2:22
show 1 more comment
No transcendental numbers are needed for this question. Any set of algebraic numbers of unbounded degree spans a vector space of infinite dimension. Explicit examples of linearly independent sets of algebraic numbers are also relatively easy to write down.
The set $\sqrt{2}, \sqrt{\sqrt{2}}, \dots, = \cup_{n>0} 2^{2^{-n}} $ is linearly independent over $Q$. (Proof: Any expression of the $n$th iterated square root $a_n$ as a linear combination of earlier terms $a_i, i < n$ of the sequence could also be read as a rational polynomial of degree dividing $2^{n-1}$ with $a_n$ as a root and this contradicts the irreducibility of $X^m - 2$, here with $m=2^n$).
The square roots of the prime numbers are linearly independent over $Q$. (Proof: this is immediate given the ability to extend the function "number of powers of $p$ dividing $x$" from the rational numbers to algebraic numbers. $\sqrt{p}$ is "divisible by $p^{1/2}$" while any finite linear combination of square roots of other primes is divisible by an integer power of $p$, i.e., is contained in an extension of $Q$ unramified at $p$).
Generally any infinite set of algebraic numbers that you can easily write down and is not dependent for trivial reasons usually is independent. This because the only algebraic numbers for which we have a simple notation are fractional powers, and valuation (order of divisibility) arguments work well in this case. Any set of algebraic numbers where, of the ones ramified at any prime $p$, the amount of ramification is different for different elements of the set, will be linearly independent. Proof: take the most ramified element in a given linear combination, express it in terms of the others, and compare valuations.
share|improve this answer
_USER_..: Yes, of course. But, in my experience, students find the proof using logs of primes to be much simpler than any of the algebraic versions. That's why I presented it that way. – Bill Dubuque Oct 11 '10 at 14:18
_USER_: the question asked about proofs that do not "show the existence of non-algebraic numbers", and so it is of interest to give proofs that stay entirely within the algebraic (real) numbers. The set of sqrt(p) has minimal "depth" and the sqrt(sqrt...(2)) tower has minimal "width" among algebraic examples, making them somewhat canonical. The log(p) argument can be thought of as using an Archimedean valuation, complementing the approach with p-adic (non-Archimed


text:
Payments for environmental services (PES) have attracted increasing interest as a mechanism to translate external, non-market values of the environment into real financial incentives for local actors to provide environmental services (ES). In this introductory paper, we set the stage for the rest of this Special Issue of Ecological Economics by reviewing the main issues arising in PES design and implementation and discussing these in the light of environmental economics. We start with a discussion of PES definition and scope. We proceed to review some of the principal dimensions and design characteristics of PES programs and then analyze how PES compares to alternative policy instruments. Finally, we examine in detail two important aspects of PES programs: their effectiveness and their distributional implications.
PES is not a silver bullet that can be used to address any environmental problem, but a tool tailored to address a specific set of problems: those in which ecosystems are mismanaged because many of their benefits are externalities from the perspective of ecosystem managers. PES is based on the beneficiary-pays rather than the polluter-pays principle, and as such is attractive in settings where ES providers are poor, marginalized landholders or powerful groups of actors. An important distinction within PES is between user-financed PES in which the buyers are the users of the ES, and government-financed PES in which the buyers are others (typically the government) acting on behalf of ES users. In practice, PES programs differ in the type and scale of ES demand, the payment source, the type of activity paid for, the performance measure used, as well as the payment mode and amount. The effectiveness and efficiency of PES depends crucially on program design.
Topic: payments for environmental services,incentives,conservation,ecosystem services
Publication Year: 2008
Source: Ecological Economics 65(4): 663-674


text: ISTE STUDENTS CHAPTER ACTIVITY Poornima College of Engineering under ISTE student chapter activity organized "TREE PLANTATION AND ESSAY WRITING COMPETITION" on 20th September, 2014. The activity of tree plantation proved to be very fruitful in two ways i) the students got awareness towards the environment and ii) they came to know the importance of trees in their life. In this activity more than 50 plants of fruits and flowers were planted with the motto to make our mother earth and environment more beautiful and a pleasant place to live in. Mrs. Renu Singhi, Advisor P.A.A. and Dr. Om Prakash Sharma, Director PCE appreciated and motivated students. They communicated the students about the relevance and importance of plant to save environment. The topic of the Essay Writing competition was "HOW COULD INDIA BECOME GREEN AND CLEAN". The essence of the essays received truly shows the keenness of the disciples towards our INDIA. The top three rankers of the competition were awarded with the cash prizes. Other participants were also motivated by Dr. Om Prakash Sharma for indulging more efforts to work well in future. Dr. Bina Rani and Ms. Megha Modani, Advisors of ISTE coordinated the whole event.


Plum - harm and benefits, advice, answers to questions
What is valuable plum? The harm and benefits of this fruit for our diet - what exactly? Let's figure it out. Many of us love to feast on juicy fruits. Especially tasty fruits from their own garden. Someone likes a sour variety, someone loves the honey sweetness of this popular fruit.
 - Characteristics and definitions of plum
 - Plum - useful properties of
 - Plum - health benefits and harm
 - Can a nursing mother plum?
 - Plum during pregnancy
 - Plum stones - the benefits and harm, which is more
In addition to the excellent taste, plum really contains a lot of useful trace elements, vitamins( B, A, PP, E, C).This common, popular stone tree is of West Asian origin. Widely used fresh, dried, dried, canned. Compotes are made from fruits, jam is made, savory sauces are prepared, and many other different, delicious dishes are prepared. Despite the wide variety of varieties, this fruit is a mine of useful ingredients in any of its manifestations.
Another name, even a synonym for plum, is the word green. Further, I will mention this definition as a generalized concept for garden varieties.
Universal President variety, photo:
содерж to content ↑
Characteristics and definitions of plum
People often ask themselves: is plum a fruit or a berry? Logically, if a tree is defined as fruit, then its fruit will be fruit. A plum is a tree, not a shrub, and the fruits growing on the trees are called fruits, not berries. If the fetus has one large bone, it will be considered a stone. On this basis, the greengage is a fruit and a stone fruit at the same time. For comparison: berries are called multi-seeded fruits, such as blueberries, strawberries, raspberries, gooseberries, currants, watermelon can also be counted among them.
Often the question arises for those interested in: plum and cherry plum - what's the difference? These trees are representatives of the same family, but it is plum that is a subspecies of plum. The fruits of the green leaf can be of a different color, since there are more than one hundred varieties of this crop. Cherry plum is also one of the varieties of plum, that is, two different representatives of the same family. In terms of taste, cherry plum is more acid, it is ideal for making various sauces, such as Tkemali, Satsebeli, Moldavian sauce, various Asian sauces.
The maturity of these two representatives is also different: plum is ready for harvest by the end of August / beginning of September, but her relative has ripened much earlier. The greenstone color varies in shades of blue, violet, and cherry plum is often bright yellow or yellowish red. The fruits are oblong, and plum is always round. As for cultivation, here plum shows a more stable immunity to disease. It is often used as a stock for various varieties of plums.
Plum, photo:
In fact, wild plums do not exist in nature. There is an assumption that this fruit is the result of crossing a blackthorn( prickly representative) with cherry plum. Cherry plum is a wild crop, this additionally explains the fact that its fruit is smaller in size than that of a blue-violet relative. Today, the works of breeders have already cultivated worthy varieties of cherry plum, which can compete with green tea in taste indicators. It is worth looking at the cultivated cherry plum variety "Kuban comet" - it has an interesting taste, it is larger than the usual wild cherry plum, it is more resistant to frost.
How many calories are there in a sink? This question seriously worries people watching their diet, as well as women who care about their figure. Since the hero of our article is one of the most delicious, inexpensive fruit at the price, this issue becomes especially relevant. Juicy renklod contains very few calories( 100 g / 42 cal), but along with this factor it is very useful. It contains vitamin P - a rare substance that the human body does not produce on its own. Rutin( vitamin P) does not disappear from the fruit even after heat treatment, it is able to normalize pressure, strengthen blood vessels. Calorie fresh fruit is low, but if the fruit is dried, it will increase significantly( 230 cal / 100 g).
Fresh as well as dried fruits have a delicate laxative effect - this feature of the fruit is well known to those who watch their weight. The use of low-calorie green food will help to quickly get rid of extra pounds, excess water, salt. Calorie plum - not the main advantage for the human body. It is incredibly useful, has a cleansing effect, contains a significant percentage of carbohydrates compared with the concentration of fats and proteins.
содерж to content ↑
Plum - useful properties of
No matter which sort you prefer, they all have the same beneficial effects on the body:
 - optimize the work of the digestive system;
 - have a cleansing action;
 - have a strengthening effect on the heart muscle, nervous system, blood vessels, capillaries;
 - boosts immunity;
 - normalize the functions of the kidneys, liver;
 - has a beneficial effect on the condition of the skin, horn derivatives - nails and hair.
Renclod - a source of vital vitamins. By consuming it, you provide yourself with the required amount of iron, fluorine, copper, nickel, zinc, and many other necessary ingredients that strengthen the "shield" of your immunity. The body will be much easier to resist viral infections, various seasonal colds, ailments.
Fruits on the tree, photo:
Plum properties are useful for manifestations of hypertension( high blood pressure), love these fruits, eat them more often. As for strengthening the vessels, increasing their elasticity, here the blue-violet fruit also demonstrates its potential as a source of essential trace elements. The frequent use of these fruits balances the nervous processes, the presence of potassium favorably affects the work of the urinary system. Renklod also contributes to the normal production of bile, facilitates the work of the liver.
The benefits of plum are manifested in the normalization of the pH of gastric juice - this factor is very helpful in the treatment of gastritis, gastric ulcers, duodenal ulcers( along with the general drug therapy).Excretion of excess salts, as well as cholesterol, a pronounced anti-edema effect( due to the sodium content) are additional advantages of the use of this fruit. The coumarins contained in the fruit work to expand the coronary vessels. Thus, with frequent use of green tissue you produce a kind of prevention of the formation of blood clots, helping the body to "dissolve" the already formed ones.
How is plum useful? What else can supplement the list of benefits of this fruit? It is successfully used by cosmetology( mainly home) for the preparation of vitamin masks that improve the structure and condition of the skin of the face. The combination of fruit pulp with other useful products only enhances its beneficial effects on skin turgor. These masks help to get rid of pigmentation( with sour milk), moisturize the skin( with sea buckthorn oil or rye flakes), remove acne( with garlic or onion juice).
↑ to the content ↑
Plum - the benefits and harm to health
As for the benefits - we have already figured out, but in addition it is worth mentioning the well-known laxative qualities of green ads. Since the fruit contains a large concentration of the klechatki, cleansing the body of toxins will be quite soft. Active trace elements normalize the work of the intestines, help to get rid of constipation( even chronic, with regular use), strengthen peresaltika. Fruit, as mentioned above, improves metabolism, allows you to get rid of excess weight, and in the form of a bonus gives a healthy complexion, vigorous state of health.
Grade "Red Ball", photo:
Sometimes in the relevant forums you can see the following question: is the drain strong or weak? Given all the above, now we can give an affirmative answer - yes, it is weak, but gently, "natural", without causing stress to the body. It can be given even to children, starting from 9 months of age, but very carefully, preferably after consulting a doctor. One fruit per day will be quite enough, thus, the baby will receive useful elements, vitamins without harm to the stomach. Greengrass is equally good for children and adults, even compote made from fruits has a delicate laxative effect.
However, this fruit can cause problems to the body - it will be fair to mention this. Contraindications to use is a more precise definition, as initially useful, a good product cannot objectively be harmful.
When, who should not use green tea:
 1. Suffering from obesity, diabetes( high sugar content in the fruit);
 2. Children - a large number threatens with diarrhea, stomach pain;
 3. Patients with gout( due to the diuretic effect);
 4. Those who suffer from rheumatism( the fruit removes a lot of fluid from the body);
 5. Categorically it is impossible to use unripe fruits;
 6. With exacerbation of gastritis or peptic ulcer disease( due to the content of organic acids);
 7. Individual allergic reaction.
Plum - the benefits and harm of its use is moderation. An overdose can badly affect the condition of your stomach, intestines, and heartburn or diarrhea will spoil your mood and well-being. If there are even the


text:
This is a slip that identifies the parish register for the marriage of Frédéric Cormier and Emma Tétreault (see the related question Finding Actes notariés (Notarial Acts) when Notary's name is known?).
The register is from Notre Dame de (something) in the Diocèse de Saint-Hyacinthe, but I cannot make out the name of the parish. The locality on the record page is Richelieu, Québec.
Using Ancestry's browse function doesn't reveal the name of the parish. I'd like to find a list of parishes in the diocese, or a list of parishes in the Drouin collection, where I could pick out the name of the parish from a list.
The title page of the register:
Wikipedia has an article about Notre-Dame-de-Bon-Secours Chapel in Montreal:
The Notre-Dame-de-Bon-Secours Chapel (chapelle Notre-Dame-de-Bon-Secours, "Our Lady of Good Help") is a church in the district of Old Montreal in Montreal, Quebec. One of the oldest churches in Montreal, it was built in 1771 over the ruins of an earlier chapel.
Does the archive slip say "Notre Dame de Bonsecours"? How can I find out more about where this parish register came from, and where this parish is located?


text:
It seems counter-intuitive but weight-for-weight, a strand of human hair is comparable in strength to steel. It's also elastic, being stretchable one and a half times its original length before breaking. These properties have attracted interest in a new class of materials that mimic hair. Now, a group from the University of California San Diego have finally found out what makes hair so strong and suggest a body armor made from synthetic hair as a first application.
"Nature creates a variety of interesting materials and architectures in very ingenious ways. We're interested in understanding the correlation between the structure and the properties of biological materials to develop synthetic materials and designs — based on nature — that have better performance than existing ones," said Marc Meyers, a professor of mechanical engineering at the UC San Diego Jacobs School of Engineering and the lead author of the study.
Meyers and colleagues put single strands of human hairs to deformation and compression tests. Examining the hairs as they deformed or stretched at the nanoscale level revealed they behave differently depending on how fast or slow they're stretched. The fast hair stretches, the stronger it is, which is analogous to how honey behaves, Meyers said.
"Think of a highly viscous substance like honey," he explained. "If you deform it fast it becomes stiff, but if you deform it slowly it readily pours."
Hair is essentially made of two main parts: the cortex, made of parallel fibrils, and the matrix, comprised of an amorphous (non-ordered, random) structure. It's the matrix that's sensitive to the speed of deformation while the cortex is not. It's these two properties combined that lend hair the ability to withstand high stress.
[ALSO SEE] How fair hair grows
That's not all. The cortex fibrils are each made of thousands of spiral-shaped chains of molecules called alpha helix chains. When hair is deformed, these chains uncoil and turn into sheet structures. According to the UC San Diego researchers, this structural change allows hair to handle a large amount of deformation without breaking, as reported in the journal Materials Science and Engineering.
Another interesting fact about hair deformation is that it's partly reversible. If you stretch a strand of hair under a small amount of strain, it will recover to its initial shape. Stretch it further, though, and the deformation becomes irreversible.
Next, the team plans to study why water has such a strong influence on human hair properties. For instance, washing hair causes it to revert to its initial shape.
"Since I was a child I always wondered why hair is so strong. Now I know why," said Wen Yang, a former postdoctoral researcher in Meyers' research group and co-author on the paper.
Was this helpful?


text:
Level III-Art Lesson 12: Da Vinci's Clock
Learn to create a collage from shapes inspired by the parts of da Vinci's clock
The lesson is suitable for students in grade 5 through adult.
Art Lesson Description:
We often think of Leonardo da Vinci as a painter. Who hasn't heard of his painting of the Mona Lisa, The Last Supper, or the Lady with the Ermine? But da Vinci was more than a painter. In fact he thought of himself first of all as an engineer/inventor, and invented
- The first self-propelled "car,"
- A robot,
- War machines, and
- Several clocks.
The Academy Model Company has converted one of his plans for a clock into a working model, making it easy to study the clock's mechanics. The model makes it easy to imagine what the invention might have looked like if one were using 15th Century materials.
Students will study the parts of the clock, and use them as inspiration to create a collage. In the process they will:
- Collect templates,
- Collect paper with a variety of textures,
- Trace the template shapes onto the papers, cut them out, and
- Glue the shapes into a collage.
In the PowerPoint version, the collage with be finished in monochromatic colors, using paint and oil pastels. In the Video version, the collage is finished with aluminum foil and color media. Students learn techniques to achieve unity in a composition. It's an exciting way to explore collage and create an original composition.
This lesson includes both POWERPOINT and VIDEO versions of the lesson.
List of Supplies for Each Student:
- (This lesson has NO drawing warm-up)
- A piece of cardboard about 11" x 14"
- Acrylic paints (_TAG_)
- Set of brushes (_TAG_)
- 1 set of oil pastels (_TAG_)
- White glue or glue stick (_TAG_)
- 1 scissors
- A collections of geometric shapes to be used for templates
- A collection of papers with different textures to be cut for the collage
- Aluminum foil (video version)
- Colored magic markers (_TAG_) (optional for the video version)
Suggestions for Cross-Curricular Connections:
- Learn why Da Vinci's clock was an important invention.
- Watch the model clock in operation.
- Watch a different da Vinci clock invention as it ticks.
- Da Vinci invented the first alarm clock. Read about it in "Springs and Things" in Leonardo Da Vinci's Life.
- You can also watch a third da Vinci clock in operation.
- Learn about the history of timekeeping devices with this video. (You may find the opening moments controversial, but stay with it for a good summary of clock history).
- Do an experiment with pendulums.
- Find ideas for science projects with pendulums.
- Learn about a 3-pendulum rotary harmonograph.
The Life of Da Vinci
- Read Neo Leo: The Ageless Ideas of Leonardo da Vinci (_TAG_) by Gene Barretta.
- Read Amazing Leonardo da Vinci Inventions: You Can Build Yourself (Build It Yourself) (_TAG_)
- Read "Leonardo Da Vinci as Told to Children" (p. 19 in this UNESCO publication).
- Find several lesson plans about Da Vinci.
- Learn how Da Vinci combined art and science.
- Read some Quick facts about Da Vinci.
- Find 20 things you probably didn't know about Da Vinci.
- Discover more facts about da Vinci.
History: What makes a person like da Vinci a "Renaissance Person?"
Approximate Time to Complete the Art Class:
- Collecting textures: 1-60 minutes (Take your time! This can be a lot of fun.)
- Tracing and cutting shapes: 20 minutes
- Arranging, gluing and painting the collage: 45 minutes
- Total time: 125 minutes


functional dependency Subtype -> Type. That is, subtypes are actually sub - types of the types, you can't have the same subtype for two different types. Without functional dependencies, the database has no information about the relationship between these 2 columns. Now, you could make 2 indexes, one for Type and one for Subtype; or you could make a compound index of (Type, Subtype). Now imagine the functional dependencies are more complex, and you have yet another third column Class, with the functional dependency Subtype -> Class; and no relationship between Type and Class.
The result is that you can make 3 simple indexes, 2 compound-indexes or just leave one of the columns un-indexed.
Now, if you had functional dependencies, you could exclusively define the index on Subtype and still use it partially for searchs or joins on the Type or Class columns. Imagine you had Subtype indexed and you wanted to join the table with antoher table through the Type column. You could create a temporary table with the Subtype and Type of each register of your table ordered by subtype (this would be simply extending the index by adding the Type column, order 1.000.000); then proceed to do the linear search through Type on that table, and once you found a row with a matching Type, you know that all the rows with the same Subtype have therefore the same Type and can bulk-join them as your table is ordered by Subtype. Then simply continue to linearly look for more matching Types.
In the opposite case. B -> A, C -> A. You could have the index only in A; and the efficiency gain wouldn't be that big, but you could still, to search by B, do a linear search on B until you found an equivalence. Therefore, you know that all other ocurrences of that value b will have a specific value a on the A column (the one that matched). Therefore, for that row of the <<other>> column you can restrict the search to the subset which has a on the A column, which you can separate because A is indexed, and later on remove the row from the <<other>> table and continue the linear join. The gain here is significantly lower and probably deprecatable, but in the first case it isn't.
Disadvantages of functional dependencies:
- They are very easy to define and as defined over columns and no data needed to be "maintained" when adding/removing rows (it is a column constraint, as the way its defined); it wouldn't take much space to keep so it isn't a disadvantage on that sense.
- They can make operations slower when adding new rows, but since typically you will have an index on the left attribute of the dependency (A in A->B), it will not be that slow. You could even force this index the same way as an index is forced on a foreign key. In any case, this can be controlled by simply not overkilling functional dependencies and LETTING THE DATABASE DESIGNER THINK IF IT IS WORTH USING FUNCTIONAL DEPENDENCIES.
- You have to program the algorithms??? I don't think lazyness is a disadvantage if there are actual advantages to it.
I know that all of these things are well-known (for those that know them well) and etc... but I wanted to explain them to avoid discussing with other people afterwards about what I have already thought. Overall, I just don't understand the reasoning for simply not adding functional dependencies to SQL.
Thanks in advance for reading and for your comments.]]>
Juan Casanova Constraints Wed, 25 Jan 2012 16:26:18 +0000
_URL_ Error 1062 duplicate entry (no replies) _URL_
Last_Errno: 1062
Last_Error: Error 'Duplicate entry '39f88d2b:132af843b99:-68c5' for key 1' on query.
can any one please provide me solution.
thanks in advance]]>
zahid quadri Constraints Thu, 29 Sep 2011 11:55:54 +0000
_URL_ A Database Error Occurred (no replies) _URL_
A Database Error Occurred
Error Number: 1064
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ORDER BY RAND() LIMIT 0, 5' at line 7
SELECT * FROM jem_content_articles WHERE (jem_content_articles.content_tags LIKE '%Blog%'AND content_type = '1' AND date_published <=_PHONE_ AND (category_id = '1' OR category_id > '6') AND jem_content_articles.status = '1' ORDER BY RAND() LIMIT 0, 5
MySQL Detail:
Server: Localhost via UNIX socket
Server version: 5.0.92-community
Protocol version: 10
User: myroshaz@localhost
MySQL charset: UTF-8 Unicode (utf8)
PHPmyAdmin Version information: 3.4.3.2]]>
azamazim md noh Constraints Thu, 15 Sep 2011 08:49:35 +0000
_URL_ check constraint for fix value in a column (4 replies) _URL_ can any one help me .
i need a constraint that should allow only 10 digit to insert into table not 11 and not 9 also. only fix 10 digit.
if any one know please reply me on urgent basis.
regards
zahid]]>
zahid quadri Constraints Fri, 02 Sep 2011 12:43:19 +0000
_URL_ Where clause for calculated column (no replies) _URL_ datediff(now(), date_added) as Waiting
I wanted to use "Waiting" in the where clause, but got a syntax error.
I ended up using the phrase "datediff(now(), date_added)" in the select statement and it took an unnecessarily long to read all 7 rows in the database.
I suppose I can work around this restraint by creating a view with "Waiting" defined inside it. Would this work, or is there some undocumented restraint about using that column in the where clause of the view?]]>
Howard Cary Morris Constraints Tue, 16 Aug 2011 04:32:51 +0000
_URL_ Multiple column foreign key (no replies) _URL_
delimiter $$
CREATE TABLE 'customers' (
'CID' int(10) unsigned NOT NULL,
'First_Name' varchar(30) NOT NULL,
'Last_Name' varchar(30) default NULL,
'Father_Name' varchar(45) default NULL,
'Address_Res' varchar(100) default NULL,
'Phone' varchar(60) default NULL,
'Mobile' varchar(60) default NULL,
'Comment' varchar(200) default NULL,
'Register_Date' datetime NOT NULL,
PRIMARY KEY ('CID')
) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Table to store Customer informatios'$$
delimiter $$
CREATE TABLE 'accounts' (
'CID' int(10) unsigned NOT NULL,
'ACN' int(10) unsigned NOT NULL,
'Loan_Amount' int(10) unsigned NOT NULL,
'Interest_Rate' decimal(10,0) unsigned NOT NULL,
'Opening_Date' date NOT NULL,
'Closing_Date' date NOT NULL,
'Comment' varchar(200) default NULL,
'DB_Save_Date' datetime NOT NULL,
KEY 'INDEX_Accounts_ACN' ('ACN'),
KEY 'FK_Accounts' ('CID'),
CONSTRAINT 'FK_Accounts' FOREIGN KEY ('CID') REFERENCES 'customers' ('CID') ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1$$
========================
Now I want to create another table 'Mortgages' with following definition
CREATE TABLE 'bankpage_'.'Mortgages' (
'CID' INT UNSIGNED NOT NULL ,
'ACN' INT UNSIGNED NOT NULL ,
'Type' VARCHAR(45) NOT NULL ,
'Weight' DECIMAL UNSIGNED NOT NULL ,
'Mortgage_Date' DATE NOT NULL ,
'Release_Date' DATE NOT NULL ,
'IsSeized' TINYINT(1) NOT NULL ,
'Comments' VARCHAR(45) NULL ,
INDEX 'FK_Mortgages' ('CID' ASC, 'ACN' ASC) ,
CONSTRAINT 'FK_Mortgages'
FOREIGN KEY ('CID' , 'ACN' )
REFERENCES 'bankpage_'.'accounts' ('CID' , 'ACN' )
ON DELETE NO ACTION
ON UPDATE NO ACTION);
=================
On execution I am getting the following error:
ERROR 1005: Can't create table '.\bankpage_\mortgages.frm' (errno: 150)
================
Please help me
I want to reference two columns of mortages table to accounts table]]>
Shashwat Tripathi


text:
In February of this year, farmers G.S. Shropshire & Sons found a massive trunk of black bog oak thousands of years old in their field at Downham Market, Cambridgeshire, east England. The marshy Fenland area is known as a treasure trove of ancient timber which fell when sea levels rose starting around 7000 years ago. The fallen timbers were preserved in the silty water that would become peat. This trunk is 44 feet long and weighs five tons...Instead of processing this log into parquet-sized pieces, such as those for the table in the insert above, the finders decided that this one deserved special treatment:
The finders alerted cabinet makers Adamson and Low, specialists in bog oak processing who purchase hundreds of logs a year from fenland farmers who turn them up while working their fields. Hamish Low recognized that the size and condition of this trunk made it exceptional, that as a remnant of the giant trees that once bristled in England's forests this specimen should be saved for the nation instead of being made into small furniture pieces.
He could go ahead and plank the trunk, but instead of dividing the planks into more easily dried boards, they would be kept in their 44-foot lengths. Once dried the planks would shrink, but they'd still be massive and could be used to make a giant table. That huge tabletop could then be exhibited as an example of and tribute to the arboreal giants that once dominated the English landscape. There isn't a single piece of bog oak as such on public display in the UK. Here was the perfect opportunity to rectify that oversight...That required specially-made equipment, extra funding, and the skills and muscles of 40 volunteers. Some of the details are discussed in The History Blog. The table was projected to be completed and publicly displayed in the summer of 2013.


text:
Tranmere Rovers will this weekend be paying their respect as part of Armistice Day and remembering those who fought and made the ultimate sacrifice during the First World War. Below is an article detailing the unveiling of the Wilfred Owen statue in Birkenhead dedicated to the 88 Old Boys of Birkenhead Institute.
With the nation celebrating 100 years since the signing of the Armistice that ended the First World War, it is fitting to mention the Ingleborough Road playing fields which was a memorial site.
For the Old Boys of Birkenhead Institute, their former playing fields held a special place in their hearts in much the same way that Prenton Park does for Rovers fans, but for different reasons.
Ingleborough Road was first dedicated in 1926 as a War Memorial to the 88 Old Boys of the School who did not survive the Great War and then subsequently those who lost their lives in later conflicts.
When Tranmere Rovers submitted their latest planning application for change the use of the playing fields to residential development land, to help the Club build a state-of-the-art training facility at the Campus, TRFC Chairman Mark Palios worked with Birkenhead Institute Old Boys, Wirral Council and David Armstrong to create a fitting tribute to all those that sacrificed their lives during the war.
This has culminated in the creation of a new memorial which was unveiled on the corner of Hamilton Square, Birkenhead, last Saturday by The Right Hon, Frank Field MP, and dedicated to the 88 Old Boys of the School. However, it will also speak to a new and wider audience about the futility of war as expounded by the school's most celebrated Old Boy, Wilfred Owen.
Another Old Boy commemorated is 25-year-old, Tommy McNaught, one of the school's most gifted sportsmen of his generation. He was among the first to go to war in 1914 and died on 12 March 1915, falling to a sniper's bullet as he ran along the front line trench with bandages for a wounded comrade.
Tommy's death was not just a tragedy for his family, or the school but also for Tranmere Rovers on whose books he was listed.