text:
Q. I just got through reading an article on sailfin mollies in which it said they do well in planted aquariums. It also said they need water with certain salinity and that you should run airstones for them. Forgive me if this is a dumb question, but isn't it true that freshwater aquatic plants would not stay alive in salted water and that airstones would drive off the carbon dioxide they so desperately need?
Penwood Crowley
Vernon, Connecticut
A. Sailfin molly fish (Poecilia latipinna) are nice for planted aquariums because they tend to eat some forms of algae but do not bother the aquatic plants. They have a gentle disposition and get along well with a wide variety of other fish, provided they are not kept with fin nippers attracted to their long, beautiful fins. Sailfin mollies tolerate a wide range of water conditions, including water that has little oxygen. They get their share using water near the surface with their upturned mouths.
Their natural environment, however, is often marshes and other locales that tend toward brackish. They will breed in brackish water in the planted aquarium. Water that has up to about 17 parts salt per thousand parts water (ppt) is considered brackish. Freshwater would normally have less than 0.5 ppt of salt. Ocean water is about 35 ppt. Put another way, sea water is about 3.5-percent salt. One teaspoon of salt per gallon of distilled water equates to about 0.132 percent salinity, and a tablespoon per gallon is about 0.4 percent salinity.
Generally, aquatic plants do not tolerate much salinity. Too much salt can destroy plant cell structure, resulting in withering and death. They can withstand a few parts per million (perhaps as much as about 1 part sea water in 7 or 8 parts distilled water). However, it gets trickier if you go higher. Some freshwater aquatic plants, such as the Bolbitis species, can stand as high as a tablespoon per gallon, whereas others, such as the Hygrophila species, need much lower levels.
So the ideal, if you want to keep sailfin mollies in a planted aquarium, would be to have only a slight amount of salt, maybe a teaspoon per gallon. This would be a bit of a compromise between plant and freshwater fish preferences. If any of your aquatic plants react badly, change plants, or add some freshwater to reduce the salinity.
Cell damage isn't the only problem that salinity can pose for freshwater aquatic plants. If you add sodium chloride (NaCl) or sodium bicarbonate (NaHCO3) to very soft water (a GH of less than 4), the sodium can interfere with the aquatic plants' uptake of calcium. The result would be deformed growth in some hard water plants, such as vals (Vallisneria). So, if you add a small bit of salt to your planted aquarium and you notice deformed growth, try adding some calcium to balance the sodium for the aquatic plants.
Regarding carbon dioxide, if you are adding it to your planted aquarium with a fermentation bottle or a compressed gas setup, then you are trying to aim for about 20 to 30 ppm CO2, or about five to 10 times what would be in the water without added carbon dioxide. Surface turbulence will cause the water to shed carbon dioxide more quickly than otherwise, making higher levels more difficult to maintain. Airstone bubbling is a form of air and water turbulence that has the same effect. On the other hand, if you are not adding carbon dioxide but relying on fish respiration, and more importantly, the atmosphere as a source of carbon dioxide, then aeration is not likely to deplete the relatively low carbon dioxide levels under such conditions.


text:
Las Vegas Cocktail Classic II w/ DIPLO
Cocktail City
Wednesday, March 26, 2014 from 8:00 PM to 10:00 PM (PDT)
Who's Going
San Francisco, California
London, United Kingdom
Florence, Italy
Event Details
Come enjoy creations from eight mixologists and eight liquor brands as we celebrate the biggest cocktail competition in Las Vegas. The guests sample unlimited creations from all eight cocktail cabana experiences and votes for their favoties. The night concludes with a perfromance from nationally receognized DJ, DIPLO. Special guest dj, PAPER DIAMOND.
When & Where
3121 S Las Vegas Blvd
Las Vegas,
Wednesday, March 26, 2014 from 8:00 PM to 10:00 PM (PDT)
Add to my calendar
Cocktail City
CocktailCityVegas.com is a unique set of events that focuses on beverages and music. Events are held at some of Las Vegas's premier venues, showcasing custom cocktails, craft beer, and regional wines. Every event features live bands and or DJ's that are hand selected for that event. Events are limited on ticket sales and usually sell out in advance. Check out cocktailcityvegas.com for all upcoming events.

subset: commoncrawl


text:
525 East 80th StreetApt. 3E
Between York Avenue and East End Avenue Upper East Side
This home has been sold
We have 46 similar homes for sale.
Subway Lines
Nearby Subway Stations
- Price$1,695,000
- TypeCondo
- Bedrooms3
- Bathrooms3
- Rooms6
- Approx. Sq. Ft.1,637
- Exposure South
Key Features
- Doorman
- Elevator
- Pet friendly
- Dining room
Gracious loft like 3 BR, 3 Bath home with split bedrooms in full service condo in a quiet Upper Eastside neighborhood. Huge open kitchen, open formal dinning room, large, open step-down living room with southern light-filled exposure, beautifully renovated bathrooms, high ceilings, pet friendly. This is one of those rare opportunities for a lovely 3 bedroom.
Agent Ask me a question
firstname.lastname@example.com Email Me See my 2 other sale listings
Upper East Side
Upper East, from 59th Street to 110th Street, from the East River to Fifth Avenue, with Sutton Place and Carnegie Hill as separate enclaves.
The Upper East Side historically exemplifies serious landmark-type apartments but remains a neighborhood where a co-op or condo can be found for everyone. Strict co-ops (some with incredible Central Park views) continue to prevail in the Upper East Side from Park to Fifth Avenues, but there are plenty of studios, one- and two-bedroom condos, and rentals on the Upper East Side as well. New luxury condo buildings include 20 East End Avenue, inspired by the pre-war architecture of the Upper East Side, and Citizen360 which is committed to sustainable building practices.
525 East 80th Street
2nd Ave - 83rd & 84th St7 mins
525 East 80th Street, also known as the Wakefield, is a full-service condominium built in 1981 by the architectural firm of Rothzeid, Kaiserman & Thompson with 13 floors and 68 apartments. The building offers an elegant lobby with full-time doorman as well as a live-in superintendent and a garage on-site. There is also laundry and storage in the basement.
Additional features of this building include: Garage - directly accessible from bldg., Bicycle room.
- Postwar
- Built in 1981
- 12 floors
- 68 units
- Elevator
- Pet friendly
- Doorman
- Central laundry room
- Common courtyard
- Garage


text:
Mainstream MMA 9: New Era
Mainstream MMA 9: New Era - Mixed Martial Arts (MMA) Event on April 5, 2008 in Cedar Rapids, Iowa USA
On April 5th, 2008 Mainstream Mixed Martial Arts 9, "New Era" will feature a double main event with 2 Championship bouts in one night at the Vets Coliseum, downtown Cedar Rapids. Joe Pearson will be defending his Lightweight Championship against the undefeated Erik Koch and Local fan favorite Tom Grubb will get his shot at the Middleweight Championship when he faces Elite Performance's Brian Monaghan, who has a reputation for feeding undefeated fighters their first loss. Also Derrick Mehmen and Rashad Brooks will fight for #1 contendership status in the Light Heavyweight Division along with an undercard of the area's top MMA talent. TICKETS AVAILABLE AT: www.MainstreamMMA.tv Nutrisport - 319 447-4936 Jersey's Pub and Grubb - 319 848-2210 Woody's Showclub - 319 841-9250 Beef's Tattoo - 319 362-3400


text:
WASHINGTON - On the 11th anniversary of the attacks of September 11, 2011, U.S. Senator Bob Corker, R-Tenn., made the following statement after participating in the Navy reenlistment ceremony for Aviation Support Equipment Technician Second Class (AW) Randy Miracle of Rogersville, who first joined the Navy in response to 9/11.
"Randy Miracle, like many brave Americans of his generation, volunteered to serve his country because of the devastating attacks of September 11, 2001. His decision to re-enlist after ten years of service in the Navy is yet another reminder of the heroism and patriotism displayed by so many Americans following the events of that dark day. We are forever indebted to Randy and all our military service members who make tremendous sacrifices everyday to defend this country," Corker said. "What began as one of the worst tragedies in our history soon turned into a day remembered for courage, compassion and the resolve of the American people. As we once again pay tribute to those we have lost, let us honor their memories by confronting our nation's challenges together to preserve the greatness of this nation for generations to come."


text:
Recent Posts
- At the Castle
- Attractions
- Bicycling
- Craft Beers and Distillery Tasting Rooms
- Food & Recipes
- Gift Shop
- Guest Services
- Holiday's
- Lake Michigan Getaway
- Live Theatre
- Restaurant
- Reviews
- Romance
- Rooms
- Skiing
- Spa Resort in Michigan
- Special Offer
- Uncategorized
- Weddings at Castle in the Country
- Winery Tours and Tasting Rooms
Category Archives: Food & Recipes
Recipe for Apple-Filled Croissants
The trick with croissants is keeping the butter from melting while working the dough. In this "quick" recipe, we cut a massive amount of butter into dry flour instead of softening it and spreading it over the rolled out flour. … Continue reading
Recipe for Cranberry-Orange Muffins
Cranberry-Orange Muffins Fresh cranberries are available in late fall through the winter months. This recipe uses their tart flavor against what would be a typical sweet muffin. The combination of spices adds a holiday touch, the allspice/ginger combination being more … Continue reading
Cherry Chocolate Cream Scones :: Delicious Breakfast Recipe
Most traditional scone recipes use both butter and milk or cream. Here we simplify by using only heavy cream. This simplifies & shortens the preparation process, and the end result yields a crispy, more browned crust with a moist interior. … Continue reading
Seckel Pears Baked in Cardamom-Mint Sauce
This recipe works with any variety of pear that is available. Be sure to adjust baking time according to ripeness of the pears. This recipe actually works better with hard, less ripe pears. Serves 8 Ingredients 8 Seckel Pears (or … Continue reading
Picnic Basket Package
When our guests arrive at our Southwest Michigan Inn Castle in the Country we find that many of them never want to leave their guest room. They're coming for complete rest, relaxation and romance and every package we provide is … Continue reading
Chocolates included in our packages come from a store in Allegan called, "Something Sweet." We talk with the owner about her favorite subject, Chocolate Truffles!
Chocolate Dipped Strawberries
Romantic, delicious, and available here. Someone ordered a dozen for tonight, so we thought a picture was in order. Lucky, lucky, lucky.
Recipe for Chicken and White Wine Pub Pie
The addition of white wine adds a nice dimension of flavor to the sauce, use whatever you like:sweet, dry, sherry, whatever. The parsley and green beans can be substituted with what is available and in season. Ingredients:1C Chicken Broth2.5 lbs … Continue reading
Recipe for Steak and Guinness Pub Pie
This hearty pub pie is made with beef tenderloin, enhanced with Guinness stout and thickened with sharp white cheddar cheese. The vegetables included are optional and can be varied based on seasonal availability: for example, I use frozen peas instead … Continue reading
Cherry Cobbler
I lucked out at the Holland Farmers Market Wednesday and found some pie cherries. While sweet cherries are plentiful and available many places, consider yourself fortunate when you see these, at least in West Michigan. The season for pie cherries, … Continue reading


text:
- 7 total posts
- 1 review
- 6 comments
Reviews & Stories
New Year Re-Solution! - Tennessee, TN
So my SmartLipo will be completed on the first week January of 2013! I am so excited because I got a really good deal (can't reveal real cost), so I know it had to be heaven sent. Thank you Jesus! And of course I have a lot of haters. I just have to explain that I have decided to invest my money in something other than weave, eyelashes, and nails. So this is my fix! Anyhow, I have dreamed... READ MORE
Recent comments from Beautiful_Blessed
Thank you, Im sure you will look great! READ COMMENT
Thanks a bunch! READ COMMENT
You look really nice. I can definitely see the difference. Keep up the good work! READ COMMENT
Looking good Daisy76 cant wait to see the 6 month. What are you doing for your scars? READ COMMENT
Yes, I'm still trying to lose up until the date of surgery. I hope my skin tightens up. Have you seen any change in your skin elasticity. Your results look great. READ COMMENT


text:
I've been looking for a simple and elegant logo, nothing fancy with pictures or wild 3D things. Just the name of the business that will pop and stand out on a simple white background. The name of the business is constellation management. Please send me an email at email@example.com
Thank you!
Did you received my email?
I've sent an email to you
Hey! I've sent email. Please check and let me know your thoughts!
- Sandra ..


text:
Monday was the first day of the rest of Aaron Donald's life.
And the former Pitt defensive tackle didn't waste it, putting on an impressive show for NFL scouts and coaches at Senior Bowl practice in Mobile, Ala. Donald is a member of the North squad, coached by the Atlanta Falcons staff. The game will be played Saturday.
Here is a report from NFLDraftScout.com senior analyst Dane Brugler:
"DT Aaron Donald was an unstoppable force on Monday. Like his play all season, the Pitt defensive tackle was extremely quick in drills and was relentless from snap to whistle. His burst and anticipation off the snap and active energy to fight through and around blocks make him tough for any blocker to handle.
"Donald repeatedly victimized Baylor OG Cyril Richardson at practice, winning with leverage, hustle and fluidity that Richardson has likely never seen before on the football field. Donald's skill-set is ideal for one-on-one drills so he should shine, but the NFL team that drafts him will get a really good football player."
Here are some additional comments from Brugler:
— Former ACC quarterbacks Stephen Morris of Miami, Logan Thomas of Virginia Tech and Tajh Boyd of Clemson were "inconsistent on day one, which was almost expected after the up-and-down senior seasons of all three."
"Boyd in particular struggled with accuracy and his ball placement is a strong concern. Thomas threw a few pretty passes that hit receivers between the numbers, but other fastballs hit the ground or sailed over his intended target.
The good news for this group? The only place to go from here is up.
— Also flashing good and bad tendencies was Miami OT Seantrel Henderson.
— Wide receivers Jared Abbrederis of Wisconsin, Robert Herron of Wyoming and Josh Huff of Oregon looked good and have a chance to among the first 100 players drafted in May.
— North Carolina DE Kareem Martin (and his long 34 3/8" arms) did an excellent job combating hand moves from Ohio State OT Jack Mewhort and riding him past the pocket. But it was a good day overall for Mewhort, 6-6, 306, who has shown good improvement from his underclassmen days.
— Northern Illinois S Jimmie Ward is the top safety prospect in Mobile, according to Brugler. "He overcame a few poor angles early and put together a good practice, showing off his foot quickness and aggressive instincts.
— Clemson OT Brandon Thomas projects better at guard where he can operate in a smaller space. He measured in at 34 3/8" arms and will use that length to engage and bury defenders – just ask DE James Gayle of Virginia Tech. Thomas dominated Gayle a few times. But Thomas struggled in space during drills, bringing up questions on whether or not he should stay on the edges.


text: And taking a page from the non-NFL world, I know several blacks who've told me they've been passed over for promotions while whites have been sought out for promotions. When they express interest in moving into management, one of the responses they get is "I didn't know you were interested in management." When you have a policy that mandates you consider certain individuals, you eliminate this dynamic - to some degree - because it addresses that "default" mechanism that has managers picking people they think make great managers and opens them to picking people (at least for the interview) whom they wouldn't have ordinarily considered.


text:
NEW DBTN Podcast
Have you checked out the NEW Disney Parks Podcast at www.disneyparkspocast.com.
Weistroffer says there are literally hundreds of flavor combos if you mix and match with a shot of liqueur. Ice cream flavors include classic chocolate and vanilla, mint chocolate made with fresh mint, pistachio, hazelnut, caramel fleur de sel, cherry, coconut-white chocolate, coffee and profiterole. Pastry Chef Olivier Saintemarie bakes crunchy mini-profiteroles, dips them in dark chocolate and mixes into vanilla ice cream, with some more chocolate sauce – this one you must try.
Sorbets are strawberry, mango, melon, lemon, pomegranate and mixed berry. The frozen treats will be available by the scoop in cups or cones – and for grown-ups, there's a double scoop served in a martini glass with a shot of Grand Marnier, whipped cream-flavored vodka or rum from Martinique.
Cost is $3.99 for 1 scoop, $6.10 for 2 scoops, or $11.50 with liqueur. A single scoop is one snack entitlement on the Disney Dining Plan.


text:
Have Cat Questions? Ask a Cat Vet Online.
Hi there,
Sorry to jump in here but I felt it was urgent to mention that brake fluid contains ETHYLENE GLYCOL!
I am a vet and I have personally treated cats with this poisoning. It is highly toxic! If a cat were to walk through a puddle of ethylene glycol (in antifreeze) and then lick his paws this would be sufficient to kill him. It destroys the kidneys.
You need to take your cat to a vet immediately so they can make the cat vomit. There is an antidote but it must be administered within 6 hours of ingestion to be effective.
Here is more information:
I sincerely XXXXX XXXXX your cat did not lick any off her fur but it is SO toxic that I am very worried about her.
How is she doing? How long ago did the splash happen?


text:
Activists Re-Writing Rules
Pershing Square Capital Management may be re-writing the rules of activist investing after teaming up with Valeant on a takeover proposal for Allergan.
The effort is the first that counts an activist hedge fund investor as a crucial piece and it raises the prospect of similar marriages between activist investors and deal-seeking corporations looking to press an unsolicited merger.
On April 21, Pershing Square disclosed it had acquired over $4 billion worth of Allergan's stock, or approximately 9.7% of the company's outstanding shares, as part of an unsolicited effort to merge the two pharma industry giants.
And then on April 22, Valeant released details of its bid, including estimates of $2.7 billion in annual operating synergies in the event of a merger and the prospect of a 20-cent dividend.
While Allergan is best known for its Botox treatments, Valeant Pharmaceuticals has emerged as one of the fastest growing generic drug manufacturers in the world.
Valeant's initial offer contained a cash component of $15.5 billion with the rest of the transaction financed with stock. Such a merger would be among the largest pharmaceutical deals and values Allergan at over $45 billion.
Barclays and Royal Bank of Canada agreed to financing commitments to cover the cash portion of a deal.
"The combination of Valeant and Allergan represents the most strategic and value-creating transaction I have ever analyzed," Bill Ackman, head of Pershing Square, said in a statement in April. Ackman said Pershing would elect to take all-stock in a transaction as part of a long-term investment.


text:
The opportunities have not been plentiful for the right-hander as the Storm has struggled but Dale Thayer has been up to the task when he is asked to take the mound.
Thayer went ten straight games without allowing a run before manager Rick Renteria inserted him into the closer's role.
"When he first came into the role where he was at in middle relief, it was just a matter of transitioning him from Fort Wayne and giving him some opportunities to pitch and just settle in," Renteria said. "As things went the roles just took care of themselves. Basically that's what happened. That is what he did last year. It was just a matter of if it ended up just being a natural progression."
Since his ascension, Thayer has saved eight games and seen work in twenty games total. He has allowed just one earned run over his last 31 games and two total. He has not blown a save to date and his ERA is a miniscule 1.66.
Is there much of a difference going from a role in middle relief to the pressure cooker that is the closer's role? Some would cite a different mindset, a forget attitude where you have to leave behind the last outing. But with Thayer pitching so well, there is little to forget and he is more concerned with focusing on what he has been doing right.
"I really don't think there is that much difference," Thayer said of assuming the closer role. "When I go out there I just go to get three outs. I have only had eight saves this year so a lot of my appearances I have not had an opportunity to get a save. I am focused on getting three outs and am not really worried about whether it is a save opportunity or not, if we are winning by one…"
Last year Thayer was the closer for the Fort Wayne Wizards and his numbers were just as impressive as this year. In 45 games Thayer had 25 saves and an ERA of 2.06. He struck out 72 in 48 innings and his WHIP was a paltry 0.96.
With the Storm he has been just as, if not more, effective. Since that horrendous first outing he has been unhittable and his WHIP is 0.92 for the year. More than 25 percent of his hits came in that first outing and he has given up just 18 hits over his last 36 innings of work.
The difference between leagues is subtle for Thayer but he sees a thing or two that has him focusing more.
"Just hitting your spots," Thayer said of the differences. "Last year in Low-A you could miss more and they would not hit it. This year you just have to make sure you hit your spots. If you don't they are going to hit the ball harder."
As with any prospect he is still in the process of ironing out a few of his pitches. As he climbs the ladder within the Padres system the hitters will become more responsible outside of the zone and Thayer recognizes that.
"Mainly my location and throwing my change up a little bit more, but not much (more)," Thayer said. "My slider – I need to work on that so I can throw it for strikes in an 0-0 count to get ahead and so I am not always just throwing fastball and to get a better breaking pitch."
To think, Thayer was once just another guy on the side of the road looking for a chance. Who knew someone would come looking for him and offer him a tryout with the San Diego Padres.
Sometimes destiny has a way of finding you.
"I was planning on seeing (about tryouts) when this guy asked me to if I wanted to go to this tryout and of course I said yes," Thayer voiced with a laugh. "Then they just picked me up from there."
John Conniff can be reached at firstname.lastname@example.com
Padres Prospect Interview: Dale Thayer
MadFriars Top Stories
MadFriars Daily Farm Report: July 19Pedro Avila dominates in Fort Wayne while great bullpens lead San Antonio and Tri-City to wins.
MadFriarsYesterday at 11:40 PM
MadFriars Q&A: Jose RuizThe former catcher gives us some details on his transition to pitching.
MadFriarsMonday at 10:07 PM
June Padres Player of the MonthBrad Zunica has the best month of his young professional career.
MadFriars Q&A: Josh NaylorThe Lake Elsinore Storm first baseman talks about his experience playing in the World Baseball Classic and his approach at the plate.


text:
Live Commentary
FULL-TIME! Barcelona earn another easy victory as they run out 4-1 victors against Malaga. The champions go four points clear after Real Madrid's draw with Almeria earlier. Barcelona dominated the first-half but took their foot off the pedal in the second period. Malaga didn't play too badly but looked toothless in attacks. That's it from us tonight at Goal.com. I've been Luke Matthews and on a personal level, i've covered four Barcelona games this season and seen 22 goals. amazing stuff. Goodnight and god bless.
90'IT SHOULD BE FIVE! A breakaway from Bojan sees the striker play the ball to Afellay who crosses for Messi. However the 'keeper brilliantly gets a hand to it before Villa's rebound is saved by the shotstopper on loan from Atletico Madrid.
89'Barcelona are having all of the possession and showing some good build-up play but Malaga have defended resolutely in this second period and look determined not to be another team concede five against Barcelona.
86'Adriano goes for goal after a quick corner but his left-footed effort is high and wide.
84'Barcelona are seeing all of the ball at the moment as Bojan's ball fails to find Villa in the box. Good opportunity missed.
82'SubstitutionIniesta Ibrahim Afellay
82'SubstitutionPedro Bojan Krkic
81'Villa looks to play an early ball into the box for Pedro but Weligton intercepts the cross. Pedro and Iniesta make way for the two substitutes.
80'It has to be said that Barcelona have been pretty wasteful at times, this time Villa mis-controlling the ball. Afellay and Bojan are coming on for the home team.
78'SubstitutionCamacho Recio
77'Barcelona are in complete control once again after Malaga had a 10 minute spell of keeping the ball well. Can they make it five?
76'Yellow Card Éric Abidal
74'Assist Xavi
74'Goal David Villa
74'4-1! EASY FOR VILLA! Xavi slips a precise throughball to the striker who rounds the 'keeper before sliding the ball into the empty net. Malaga players are appealing for offside but Weligton was playing Villa onside.
73'BRILLIANT RUN FROM PEDRO! The winger showsquick feet to get clear of Malaga defenders before he attempts to play a ball to Busquets for a tap-in.However Weligton intercepts the pass.
70'Comeback on the cards maybe? Probably not but at least Malaga have put in a decent account of themselves this second-half.
68'Goal Duda
68'GOL MALAGA! 3-1! It's Duda who takes the free-kick and his wonderful left-foot curls the ball into the top corner with Valdes getting nowhere near it.
67'Baptista is brought down on the edge of the area by Busquets. The Brazilian will surely fancy this.
65'First shot on target for Malaga but it's never going to trouble Valdes. Danish left-back Mtiliga does a few fancy step-overs before getting hios shot away on the corner of the box. However it's straight at Valdes.
63'Malaga are struggling to create anything in this one. Eliseu looks to counter-attack and after some decent play by Duda on the left the ball is played Rondon who is too weak on the ball as Pique disposesses him with ease.
62'More good build-up gifts Adriano the opportunity to whip in a cross. However it's a poor one as Demichelis puts the ball out for a corner.
60'SubstitutionQuincy Owusu-Abeyie Rondón
60'SubstitutionVincenzo Maresca Eliseu
59'A lot less urgency from Barca in the second-half who look content with their three goal lead. Eliseu and Rondon come on for Malaga.
56'Not much, the first man clears the ball for Malaga who have defended well so far in the second half.
55'Adriano is doing a pretty decent job down the right, this time playing it to Pedro who is then brought down by Mtiliga. Pedro free-kick on the right, what can he do?
52'Villa breaks into the box but his low cross is cut out by Weligton and put out for a corner which Barcelona waste.
51'SHOCK HORROR! XAVI GIVES THE BALL AWAY The midfielder loses possession after some good build-up play from his teammates. Please people, remember the date and time because this probably won't happen again...ever.
49'Messi shows off those magic feet one again to get past three Malaga defenders and into the box but then gets crowded out and dispossessed by Demichelis who is having a fairly decent game despite his side conceding three.
48'Decent start to the second half by Malaga who are seeing more of the ball. Unfortunately Baptista is struggling to hold the ball up at the moment, the Brazilian will need to do better.
46'We're back underway here with Malaga immediately giving the ball to Barcelona. Can the Andulusian's get an early goal?
HALF-TIME! What can be said that hasn't already been said about this wonderful team? They have been all over Malaga and deservedly lead 3-0 at the break. A four point lead at the top of La Liga is on the cards. At this rate will this team drop that many points this season? Probably not. Join us in 15 minutes for what promises to be an exciting second-half (well for Barca fans at least).
44'Great play by Messi who works his way past several Malaga defenders before seeing his shot from a tight angle saved once again by Asenjo. A battle emerging between this two and the 'keeper is doing well so far.
42'VERY GOOD SAVE FROM ASENJO! Villa plays a ball across the box that Xavi wisely leaves for an unmarked Messi. The Argentinian is one on one with Asenjo who brilliantly stands up and turns the ball around the post for a corner. Where was the Malaga defence?
41'Barcelona have already scored five goals or more on eight occasions this season! Surely they will make it nine times tonight? Damage limitation for Pellegrini's men surely?
38'SHOULD BE FOUR! Barcelona break on the counter-attack as Pedro slides in Villa. The angle is fairly tight as the striker drags his shot wide with Messi inches away from getting a toe to the ball for a tap-in.
36'Assist Iniesta
36'Goal Pedro
36'3-0! GAME-OVER! Messi's ball to Iniesta is sublime, fooling the whole Malaga defence. Iniesta sees his shot saved by Asenjo but the ball falls to Pedro who has the simple task of slotting the ball into an empty net from 12 yards. Barcelona's 60th goal of the season!
34'Can Barca score a third before half-time? Will they probably could but at the moment they are toying with this new Malaga team who still look like they need to gel, understandably so.
32'Close again from Barca with Messi playing a delightful one-two with Iniesta. However he is then left at a tight angle and can only lift the ball over the bar.
31'On a rare break forward Duda looks to play a ball through to Quincy but the ex-Arsenal striker fails to hold his run and is flagged offside. He will need to do better than that the Ghanian international.
28'Yellow Card Martín Demichelis
28'Malaga have decided to try and break up Barca's play with a couple of niggly fouls. This time Demichelis clatters Villa.
27'SubstitutionDaniel Alves Adriano
27'Malaga are seeing a little more of the ball as Adriano replaces the injured Alves.
24'Alves is down and it looks unlikely that the right-back to continue. It doesn't appear there was a specific foul. It appears the Brazilian has pulled his hamstring.
23'Barcelona are calmly stroking the ball around the pitch at the moment. Everything looks so easy for them when they play like this. They can score at will.
21'This really could be another hammering tonight. Malaga need to defend better and keep their concentration.
18'Assist Messi
18'Goal David Villa
18'2-0 BARCA! Clinical finish by Villa but Malaga really cannot afford to defend like that. Xavi and Busquets make lightweight of dispossesing Camacho with Xavi then sliding the ball to Messi who then slips a wonderfully weighted pass to Villa who calmly slots the ball between the 'keeper's legs for his 13th goal of the season. Wonderful.
17'WOW! XAVI HITS THE BAR! The diminutive genius picks the ball up 25 yards out and gives the ball a good old wack. Asenjo is helpless but the ball smashes back off the crossbar.
16'PEDRO STINGS THE PALMS OF ASENJO! The wide-man is played in by Xavi and shoots from 20 yards out. It's a decent effort but one that the 'keeper should be saving. He parries the ball into the path of Villa but the Malaga defence mop up well.
14'Barcelona look like they are going to wreak havoc in the Malaga defence when Messi plays an insightful ball to Iniesta into the box. However, the midfielder uncharacteristically mis-controls the ball which goes out for a goal-kick.
11'How can Malaga get back into this one? First of all they will need to make sure they don't concede another goal anytime soon. So many teams have come to Camo Nou this season, played well and still been on the end of a thrashing.
9'Duda comes close to hitting back at Barca instantly. The ball is played to the Portuguese attacker who hits it first time on the left side of the box. He fails to hit the target but Barcelona were certainly under pressure there.
8'Assist Daniel Alves
8'Goal Iniesta
8'GOL BARCA! Brilliant build up play and a brilliant finish from Iniesta. Alves plays a bouncing ball to the attacking midfielder who is on the edge of the area who hits it first time into the far corner with Asenjo left stranded. Not quite in the top corner but it is an excellent finish.
6'Their are certainly some interesting angles to this tie tonight, mainly involving Real Madrid. Pellegrini of course managed Real last season but lost both el Clasicos. Also, Baptista has scored a winning goal at Camp Nou before for Real in a 1-0 victory.
4'Barcelona have their first shot at goal with Abidal storming through and smashing a powerful effort from a tight angle. Unfortunately for the home supporters the ball hits the side netting.
2'The home side are dominating possession in the early exchanges but no chances as of yet.
1'Leo Messi and David Villa get us underway here at Camp Nou. Barcelona kicking from right to left and in their traditional red and blue while Malaga wear light blue and white stripes.
Just to confirm, Real Madrid have drawn 1-1 away at Almeria, the same Almeria that Barcelona dismantled 8-0 back in November. The Catalans are at full strength tonight while Malaga include all of their five new January signings in the starting line-up.
Malaga: Asenjo, Gaspar, Demichelis, Weligton, Mtiliga, Maresca, Camacho, Duda, Apono, Baptista, Quincy
Barcelona: Valdes, Alves, Pique, Puyol, Abidal, Busquets, Xavi, Iniesta, Pedro, Messi, Villa
Here come the teams...
Hello and welcome to Goal.com's coverage of the Sunday evening La Liga tie between Barcelona and Malaga from Camp Nou. I'm Luke Matthews and I will be taking you through a game where Barcelona will be hoping to continue their neverending great form and with Real Madrid currently drawing 1-1 with Almeria the Catalans could extend their lead at the top to four points. Malaga on the otherhand have invested well in January and will be hoping their winter signings will help catapult the club into the European places. Can the Andalusian club create a statement of intent here?


text:
Negotiation and diplomacy: only the most munchkiny, hack festival, break down the door, hardcore mercenaries of war groups have never had a use for it. And yet I think making it a skill and a die roll is a mistake, if not only for the following reasons:
First, the actual skill is flawed in it's write-up. Taking a look at the rolls and DCs, I can see a 10th level bard that never needs to enter combat simply by announcing he is using diplomacy and converting everyone he meets into friendly groupies waiting on his every word. There is no scaling DC, no contested roll of any sort, no will save, and yet it duplicates the effects of some of the games most useful spells. While this is not bad in and of itself, it becomes bad when one reaches the "never roll" skill threshold. Even groups that want to keep the diplomacy skill should need a rewrite of it to keep it from becoming game breaking. I recommend this variant for any who agree with me so far but do not like the other options.
I think that a lot of skills and actions make more sense as ratings. As it is, a first level character has a small chance to make a red dragon friendly and helpful, discover gun powder, and remember that the arch villain of the campaign is deathly allergic to celery. To create a rating, just assume that a character is always taking 10 on certain actions. This is great for reducing the abuse of other skills and makes standard event like ambushes easier. For example, lets assume the Jay the Bard is shopping for a good deal and is haggling with a merchant. If the merchant has a good diplomacy rating, then that might be a signal to the GM that this merchant has thus far been able to sell at 50% above market price with no complaints. But if Jay has a good diplomacy rating, too, than maybe he can haggle the merchant down to base price. Lower if Silent Bob succeeds on an intimidate check...
This also aids role play, as there is less die rolling. While this variant can lead to some unfortunateness, like the shy kid being asked to talk to the scary GM because his character has the best rating, a quick reference to the character sheet as well as what is actually said can allow role play to resolve many situations. And emphasis on "what is actually said", because I think that should be a determining factor in whether a diplomacy check wins or fails. Offering 10,000 gold for a serfs hat should always succeed, just as offering not to take a dump on the throne in exchange for a night with the queen should always fail. Also, diplomacy does not seem to allow haggling, as there is no chance for a counter offer. You either succeed or fail in convincing someone and it's done. Same problem with fast talk and groveling. In addition, there should be some form of contested roll if rolls are to be involved. I like the idea of a will save or sense motive, but I could also see another diplomacy (counter offer), intimidate (threat), or a bluff (deception) as very viable options, although I do prefer a rating system for these skills as well.
So, in summery, diplomacy is and should be a viable skill, but not as it is written. Thank you.--Teh Storm 18:05, October 4, 2010 (UTC)


text:
|Publication number
|Publication type
|Application number
|Publication date
|May 17, 2011
|Filing date
|May 19, 2008
|Priority date
|Jul 30, 2004
|Fee status
|Also published as
|Publication number
|Mehmet Altinel, Christof Bomhoevd, Chandrasekaran Mohan, Mir Hamid Pirahesh, Berthold Reinwald, Saileshwar Krishnamurthy
|Original Assignee
|International Business Machines Corporation
|Export Citation
|BiBTeX, EndNote, RefMan
|Patent Citations (14), Non-Patent Citations (8), Referenced by (17), Classifications (5), Legal Events (2)
|External Links: USPTO, USPTO Assignment, Espacenet
This application is a continuation of U.S. application Ser. No. 10/902,583, filed Jul. 30, 2004, pending.
1. Field of Invention
The present invention relates generally to the field of database caching. More specifically, the present invention is related to local cache consistency maintenance with respect to one or more backend databases.
2. Discussion of Prior Art
Transactional Web Applications (TWAs) have recently reached widespread use in modern enterprise application infrastructures. Such applications are typically implemented within a broad range of technologies including network load balancers, HTTP servers, application servers, transaction-processing monitors, and databases. In its simplest form, a TWA is associated with an HTTP server hosting presentation logic, and with an application server hosting business logic (e.g., Java servlets or EJBs). A TWA is provided with data obtained from queries, issued by an application server, to a relational database.
Typical TWA operations include browsing a product catalog, populating a shopping cart or a wish list, placing the order, and checking order status. Requests from TWAs go through several layers of computer systems as shown in
Caching static HTML pages and data as a technique to achieve better scalability and faster response time of interactive TWAs has long since been popular. Caching takes place in various forms: a cache for a client browser, forward and reverse proxy caches, nodes of content-delivery overlay networks, and in specialized object caches associated with application business logic. Combining caching technologies at various levels in an application infrastructure stack often adversely affects response time and scalability. However, as web pages become more dynamic and equipped with increased personalization capabilities, such static HTML caching techniques become less useful in supporting the delivery of high volumes of frequently updated information. High-volume web sites often serve highly personalized content to their users.
As a consequence, reusability of generated web pages is low, and data needed to build a web page often cannot be profitably cached far away from those enterprise application servers housing business logic that manipulates such data. For this reason, some enterprise applications run their business logic on application server nodes deployed in remote data centers that are proximate to users (e.g., web-hosting services). Partnerships between content-delivery network service providers (e.g., Akamai Technologies Incorporated) and application server vendors (e.g., IBM Corporation and BEA Systems Incorporated) facilitate the transfer of content and applications from origin enterprise servers, thereby improving response times and reducing the load on local, in-house systems. These approaches, however, are limited in their provision of access from remote application servers to central backend databases on origin enterprise servers.
Addressing this limitation is a promising technique capable of handling the dynamic nature of TWAs: database caching. Data stored in a database cache is obtained by a remote application server via database queries in the same manner as would be obtained by direct, backend database access.
There are a number of different options addressing a database cache entity implementation; semantic caching as disclosed by Dar et al. in the non-patent literature entitled "Semantic Data Caching and Replacement" and DBProxy as disclosed by Amiri et al. in the non-patent literature entitled "DBProxy: A Dynamic Data Cache for Web Applications" are two of such implementations. In these implementations, query results are locally stored in a cache; this cache is consulted for each new query to determine whether a result can be produced solely from local data. By contrast, other caching approaches describe systems in which a full-fledged database server is collocated with an application server.
One advantage of the latter approach is that a significant portion of query parsing and analysis logic that already exists in a full-fledged database system can be exploited to manage a cache. Such an approach also enables caching of other associated database objects, such as triggers, constraints, indices, and stored procedures. In this manner, application performance and semantics are provided along with uninterrupted service when backend databases are unavailable.
A simple approach to implementing a database cache would be to replicate full content of selected tables from a backend database. In this case, each cache table referred to in a query can be used as long as stale data is acceptable. However, front-end systems are much less powerful than backend systems thus making full-table caching more difficult. Even for a powerful front-end system, large table sizes can easily make full-table caching infeasible because of increased replication and maintenance costs in a database cache. Deepening this approach, sub-table caching provides an effective alternative by caching only selected parts of backend database tables. Materialized view mechanisms in current database products can be exploited for this purpose. Materialized views are developed to store pre-computed query results that are later used to improve performance and speed data access of expensive queries.
Nicknames in DB2™ are references to remote tables that can be used in federated queries. In order to implement a sub-table cache, in particular by creating materialized views based on nicknames, extra processing effort is not required. This way, existing materialized view-matching mechanisms in DB2™ can be exploited to route queries to either cached tables, by materialized views, or to backend tables, by nicknames depending on query predicates. However, in a database cache, this approach is limited in that materialized views require declarative specification. Once specified, the definition of materialized view content cannot change dynamically based on demand. Unfortunately, it is difficult, if at all possible, to know a priori exactly what to cache because of the dynamic nature of web applications (e.g., caching the content of a shopping cart in a typical e-commerce application).
As described in the product documentation entitled "Oracle Internet Application Server Documentation Library," by Oracle Corporation, and the non-patent literature entitled "Mid-tier Caching: The FrontTier Approach," by The TimesTen Team, Oracle™ and TimesTen offer database cache products of interest. The Oracle™ approach involves full-table caching using a full-fledged database server at a middle tier between remote data centers and a central backend database, in which updates are propagated through replication. Their solution ensures that other database objects, including stored procedures and user-defined functions, are deployed in the middle-tier, from a central backend database, as well. Although this approach has the advantage of considerable application transparency, it requires considerable cache population and management tasks for large tables. On the other hand, the TimesTen Front-Tier approach allows sub-table level caching and local updates at cache databases. However, an application utilizing such a cache needs to be made aware of the freshness of cache content and choose a target database (i.e., cache or backend) accordingly. Moreover, the TimesTen Front-Tier approach is restricted to work only with an Oracle™ backend database. A cache group first introduced by The TimesTen team is defined solely based on referential integrity constraints of a backend database and is therefore less restrictive.
Whatever the precise merits, features, and advantages of the above cited references, none of them achieves or fulfills the purposes of the present invention.
The system and method of the present invention provides for transparent, adaptive caching functionality via cache tables defined by a database cache model and via two-headed query plans. A cache table is a database object by which an end user specifies a table in a cache database as being a cache of a remote table in a separate, remote backend database. Each cache table is associated with a nickname that represents the corresponding backend table. From the application viewpoint, cache tables are semantically equivalent (i.e., peer-level objects) to the associated backend tables. For this purpose, semantically importance database objects, such as constraints and triggers, are also cached as well. A database cache model specifies a caching scheme that harnesses the distributed query processing power of, for example, DB2™ to build an adaptive database cache. In one embodiment, such a scheme dynamically populates a cache table by exploiting frequently-occurring characteristics of typical transactional web applications (TWAs). Typical TWAs have characteristics comprising: a relatively high volume of short transactions, simple equality predicates, and multiply joined queries (e.g., 3-way, 4-way). The application of caching to TWAs is not restrictive; caching may be applied to any type of database application. In another embodiment, a declarative population method is specified by a database cache model. As a result, a cache table is formed in such a manner that provides a database cache instance with the ability to adapt to an application's changing workloads. In yet another embodiment, a database query optimizer does this by generating dynamic query plans, formed from one or more parts of an original database query, against either a local database cache or a remote backend database server.
If existing content in a database cache table is insufficient to fully provide results for a query, the query is transparently routed to and executed against an appropriate backend database table using an associated nickname. To achieve transparent deployment of a database cache, it is not necessary to make changes to the database schema as viewed by the applications. Each backend database table is represented locally in a cache database schema either by a local cache table or by a nickname referring to a specific backend database table, depending on whether caching is enabled for a particular backend database table. Although query compilation and maintenance mechanisms differ depending on the type of cache table, a combination of declarative and dynamic settings is possible in one cache database embodiment.
A two-headed query plan is comprised of a probe portion, a local query portion, and a remote query portion. During run-time execution, database conditions are initially examined with respect to a set of cache constraints using a probe portion in order to guarantee the "correctness" of query results. While a remote query portion is constructed solely of nicknames for remote backend database tables, a local query may be comprised of nicknames and local cache tables such that query partitioning is enabled. Depending on the degree of rigor imposed by a query constraint, a local query is distributed amongst both a local cache and a remote database by a query.
While this invention is illustrated and described in a preferred embodiment, the invention may be produced in many different configurations. There is depicted in the drawings, and will herein be described in detail, a preferred embodiment of the invention, with the understanding that the present disclosure is to be considered as an exemplification of the principles of the invention and the associated functional specifications for its construction and is not intended to limit the invention to the embodiment illustrated. Those skilled in the art will envision many other possible variations within the scope of the present invention.
Referring now to
In contrast, declarative cache tables are primarily used when desired portions of cache table content are known in advance, is created with a declarative cache table creation template statement 300, as shown in
Cache Constraints
Population methods and content contained within a dynamic cache table are described by cache constraints. By observing cache constraints, a correctness property is guaranteed; executing a query against dynamic cache tables obtains the same results as if executed against a backend database at some previous point of time. Cache constraints assist in the determination of a valid set of dynamic cache tables, wherein each member of the set maintains a correctness principle and is eligible for reference by an application-issued query. By observing cache constraints, a correctness property guarantees that the result of a query obtained by using dynamic cache tables is the same as the result of the query if it were to be executed at the backend database, modulo the differences due to the cached database being out-of-date. Types of cache constraints enforced for dynamic cache tables are comprised of cache key constraints defined for specified columns of a cache table and of referential cache constraints involving multiple cache tables.
A cache key is defined as a cache table column whose values identify records contained in a given cache table. A cache key is necessarily domain complete, which guarantees that a cache table contains all the rows from the backend table that contain a particular value. Of notable interest, unique cache table columns and hence, primary key columns as well, are domain complete by definition. If a cache key is defined for a non-unique column, the database caching system and method of the present invention (DBCache) satisfies domain completeness for that column by fetching and loading into a cache table, necessary backend records. For a single cache table CTi, domain completeness guarantees the correctness of equality predicates of the form of "CTi.cx=value", where cx is a domain-complete column. If such is the case, CTi is deemed an eligible table for a local query. Using the domain completeness property, a set of eligible cache tables comprising single table equality predicates is determined for reference by local queries. Explicitly defined cache keys indicate an intention of triggering on-demand loading for missing cache key values. Shown in
Referential cache constraints (RCC) are specified to guarantee the correctness of join operations between cache tables. DBCache makes a provision for maintaining consistent copies of correlated values in a cache table. An RCC, defined for any pair of columns from distinct cache tables between which it is possible to apply a join operation, creates a cache-parent/cache-child relationship between two cache tables. An RCC between a column cn of a cache table CTi (cache-parent) and column cm of another cache table CTj (cache-child) is an indication that any value of cn in CTi is associated with all rows having the same value in cm of CTj. Given an example in which an equi-join predicate is specified such that "Ti.cn=Tj.cm", where Ti, Tj are backend tables corresponding to cache tables CTi, CTj, respectively, and CTi is the cache-parent of CTj via columns cn and cm; if cache-parent CTi is eligible for use in a local query plan, cache-child CTj is eligible as well. More generally, the join operation "CTi.cn=CTj.cm" can be performed in the cache database. Shown in
Cache Groups
DBCache identifies as a cache group, a set of related cache tables populated with values of at least one cache key of a single, distinct root cache table. Tables in a cache group that can be reached from a root table via RCC constraints are known as member tables of their cache group. If a cache table does not contain a cache key, it must be a member table of at least one cache group. In a cache database, a first cache group is a subset of a second cache group if a root table the first cache group is a member of the second cache group. Cache groups intersect if they share in common one or more member tables. Cache groups are implicitly constructed, as opposed to declaratively constructed, based on cache constraints.
A cache group is represented as a directed graph, known as cache group graph, in which nodes denote cache tables and edges denote RCCs. An edge is directed from a node representing a cache-parent table to a node representing a cache-child table. A bidirectional edge indicates the existence of two RCCs between a pair of corresponding columns, one in each direction. For each row in a cache table, there are corresponding rows in another table. A unidirectional path is one formed from a source table to a target table in the graph by following direction edges representing a set of RCCs. Each participant table is traversed at most once; however a cycle path starts and ends with the same table. Of notable interest, each bidirectional edge corresponds to a cycle. A cache group graph also corresponds to a reachability graph of a root table, in which all members of a cache group represented by nodes can be reached. Additionally, a connectivity graph captures the combined representation of overlapping cache group graphs.
When a cache group graph contains a cycle, there exists the possibility of recursive cache load for each participant table. A safe condition that prevents recursive cache load for a cycle is in effect when only a single column of each participant table is touched upon once during a traversal. Such a cycle is called homogeneous cycle. Note that each bidirectional edge creates a homogeneous cycle. On the other hand, a heterogeneous cycle is formed by a path if one of the participant tables contains two or more columns used in the traversal.
Referring back to the exemplary connectivity graph shown in
Query Plan Generation
Queries involving declarative cache tables are compiled using existing materialized, view-matching mechanisms. Specifically, declarative cache tables are created as materialized views over nicknames such that, during query compilation, a view-matching mechanism is able to route queries to either a local cache database or a backend database. In essence, each declarative cache table reference is replaced with its corresponding nickname in a query, such that existing view-matching mechanisms are enabled to route a given query.
For dynamic cache tables, two alternative query plans for each query are created during query compilation. A first plan, constructed from available dynamic cache tables and database nicknames in the query, is termed a local query plan 608. A second plan, constructed solely of database nicknames, enables remote query execution as a remote query plan 610. Both plans are tied together with a conditional switch operator 606, and are jointly known as a Janus plan 600, as shown in
A Janus plan is constructed in four steps. An initial query plan is first converted into a remote plan referencing only backend database table nicknames. Thus, a query is ensured to be executable even if a Janus plan is not created. For example, when a currency setting for a cache database indicates that dependent applications cannot tolerate out-of-date data, no attempt is made to generate a Janus plan and data is retrieved from a backend database. Subsequently, a probe query is generated by checking equality predicates in an input query to determine participation in a probe query condition (see Appendix A for details of computations). If an equality predicate does not exist for a given input query, Janus plan creation is aborted. Otherwise, an input query is cloned and clone nicknames are replaced with corresponding cache database table names. A cloned query plan becomes a local query plan and an unaltered, original query plan remains a remote query plan. Lastly, a switch operator is inserted at the top of the query plan, and local, remote, and probe query plans are tied to the switch operator.
To populate declarative cache tables initially and to keep them up-to-date later, DBCache relies on an asynchronous replication tool for relational data consisting of two separate components, the data change capture program and an apply program. Based on subscription settings, a capture program detects changes in a source database and notifies an associated apply program which in turn applies corresponding database operations to replicated data. Using predicates given during the creation of declarative cache tables, automatic replication subscriptions are configured. When capture and apply programs are started, declarative cache tables are loaded with data from counterpart tables in a backend database and are asynchronously updated at a specified frequency.
Asynchronous On-Demand Cache Loading
Referring now to
Cache miss messages are not necessarily persistent. If a pending cache miss message is lost after a system failure, another cache miss message is simply sent for the same cache key value at the next corresponding cache miss. If a given cache miss message is sent and applied multiple times, for example because a second request for the same cache key occurred before the first cache miss was processed, a resulting primary key constraint violation will cause the process to skip the second message. To reduce the likelihood of processing multiple cache miss messages for the same cache key values, a specified number of last cache miss messages received are stored; incoming cache miss messages already in the list are discarded.
At most one insert statement per cache table in a cache group is prepared during cache population. Subsequently, insert statements are executed in a single transaction, to guarantee consistency of the affected cache tables.
Dynamic Cache Population
For each received cache key value, a set of rows necessary for insertion into a corresponding cache table CT0, known as a set of qualifying rows, is determined by considering all cache keys of CT0. For each defined cache key, it is necessary to guarantee domain completeness. Starting from a cache table CT0, for every RCC constraint CTi→CTi+1, qualifying rows for CTi+1 are determined based on qualifying rows for CTi and cache keys defined on CTi+1. A set of qualifying rows for CTi+1 is the set of cache-child rows corresponding to a qualifying row set for CTi plus rows necessary to satisfy domain completeness properties, due to cache keys for CTi+1 Recursively, for all outgoing edges from CTi+1, qualifying rows are determined.
Qualifying rows for a cache table are represented as nested sub-queries that refer to corresponding backend tables. Thus, an insert statement for each visited cache table is a federated query and contains a select sub-query on corresponding nicknames thus enabling retrieval of qualifying rows not already existing in the cache table. Referring to connectivity graph example shown in
To process a cache population message, a cache daemon generates and executes a list of appropriate relational database statements (e.g., SQL statements). To increase performance, statement lists are generated once, and stored internally in a generated statements cache thus enabling re-usability across messages of the same type. Since statements generated by a cache daemon contain parameter markers, equivalent statements with different parameter bindings are used for an equivalent type of cache operation. For example, equivalent insert statements are used to populate the same cache group based on different cache key values. A key for a generated statements cache is based on fields determined by operation type. Database name and operation type are pieces of information common to all operation types. For cache population and garbage collection operations, a key also contains a fully qualified column name of a corresponding cache key column. For deletion, additional information comprising fully qualified names of primary key columns. Finally, for an update operation, fully qualified column names of all updated columns are additionally used in a key. The size of a generated statements cache (i.e., the maximum number of statement lists stored) can be specified individually for each type of cache population and maintenance operation.
Cache Maintenance
Dynamic cache table content is updated in response to update, deletion, and insertion of represented rows at a corresponding backend database. As shown in
A local cache database is maintained by making corresponding changes to a local cache consistent with row data insertions, updates, and deletions occurring at a remote backend database. In support of maintaining cache consistency with respect to row data insertions, a newly inserted row is imported to a local cache database if either: for any value in a target column of an RCC, a corresponding cache parent row exists in a local cache database; or if for a non-unique cache key of a target cache table, rows having the same key value exist in target cache table table.
Based on the location of update operation relevancy determination, a plurality of alternatives exist for column subscription to corresponding backend database tables. In addition to values for primary key columns, an insert message contains values for columns that are either the target of an incoming RCC or values for a non-unique cache key of a corresponding table. Having such values in an insert message allows determination at a cache database whether it is necessary to insert new row data, without the necessity of accessing a corresponding backend database. However, if new row data qualifying for insertion to a cache is missing column values, retrieval from a backend database table is necessary.
If an update occurs on columns that are neither referenced by an RCC, nor are cache key columns, it is possible to simply update a corresponding row in a cache database. Similarly, if for either of an updated RCC or cache key column, a new value exists in a cache database, the corresponding row in a local cache database is updated. However, if new values of an updated RCC or cache key column are not stored in a cache database, the corresponding row storing old values is deleted from cache database. Maintenance information sent to a cache daemon includes a primary key value as well as old and new values of updated columns for a modified row. If an update message is seen by a cache daemon before the row is imported to a cache database due to a cache miss, a corresponding update message is discarded.
In the case of a row deletion from a backend database in which the same row exists in a local database cache, a row deletion occurs from a corresponding cache table. Otherwise, a received deletion notification message is discarded. If a given deletion notification message requires the deletion of a cache child, the corresponding row is deleted from a local cache database. If a given deletion notification message requires the deletion of a cache parent, it is not necessary to delete corresponding cache children in the preservation of cache consistency. However, for every outgoing RCC pointing to a cache child table having no other cache key columns or incoming RCCs from other cache parent tables, cache children not shared by another cache parent row are deleted. The reason for this is to avoid un-reachability of cache children during garbage collection. Maintenance information sent to a cache daemon contains a primary key value for a deleted row at a backend database.
A garbage collection mechanism for a cache daemon deletes rows directly from cache tables based on cache key values, in order to delete whole cache group instances in the reclamation of cache space. A metric used to determine candidates for eviction is based on components comprising: popularity (i.e., the number of cache hits that have occurred for a particular cache group instance), recency (i.e., the length of time that a cache group instance has been in a cache database), and storage space consumption (i.e., the size of a cache group instance in terms of memory occupied). In one embodiment, different weights are applied metric components by a system or user. Differing from a row deletion based on a delete statement at a backend database, an eviction requiring the deletion of a cache parent correspondingly requires deletion of cache children as well. In specific, cache children of a give cache parent that are not referred to by the same cache parent in an RCC of another cache group, are deleted. From a cache daemon point of view, garbage collection appears as the execution of multiple delete statements within a single transaction.
The present invention provides for an instance of DB2™ is represented as a transparent database cache manager by modifying existing engine code and leveraging existing federated database functionality. Thus, database caching is supported not only at mid-level nodes of central enterprise infrastructures, but also at remote data centers and edge servers within content delivery networks. Given the potential for a large number of database cache deployments at remote data centers and edge servers in the latter scenario, declarative specification of table subsets detracts from the scalability of the entire system. To overcome such a limitation, a database cache of the present invention adapts to system load by automatically choosing data to cache, without requiring modification to the format of database queries. Distributed query execution, in which a query is executed at either a local database cache or a remote backend database server, is also provided.
In an alternative embodiment, two-headed query plans are used for checking the freshness of cache table contents at runtime. For this purpose, a probe query portion in a two-headed query plan further comprises conditions eliciting a comparison of the latency of cache table data with a desired freshness value, at the time a query is executed. If a desired freshness constraint is not satisfied, remote query portion of a two-headed plan is executed.
Additionally, the present invention provides for an article of manufacture comprising computer readable program code contained within implementing one or more modules to maintain an adaptive database cache consistent with a corresponding remote backend database. Furthermore, the present invention includes a computer program code-based product, which is a storage medium having program code stored therein which can be used to instruct a computer to perform any of the methods associated with the present invention. The computer storage medium includes any of, but is not limited to, the following: CD-ROM, DVD, magnetic tape, optical disc, hard drive, floppy disk, ferroelectric memory, flash memory, ferromagnetic memory, optical storage, charge coupled devices, magnetic or optical cards, smart cards, EEPROM, EPROM, RAM, ROM, DRAM, SRAM, SDRAM, or any other appropriate static or dynamic memory or data storage devices.
Generally implemented in computer program code based products are software modules for: (a) populating an instance of an adaptive database cache consistent with a corresponding remote backend database; (b) generating a query plan utilizing locally cached database tables; (c) performing on-demand loading of local cache tables; and (d) operating on a local database cache to maintain consistency with respect to changes occurring a remote backend database. More specific embodiments (as disclosed herein), variations, and functional equivalents are deemed within the scope of the present invention.
A system and method has been shown in the above embodiments for the effective implementation of a system and method for adaptive database caching. While various preferred embodiments have been shown and described, it will be understood that there is no intent to limit the invention by such disclosure, but rather, it is intended to cover all modifications falling within the spirit and scope of the invention, as defined in the appended claims. For example, the present invention should not be limited by software/program or computing environment.
|Cited Patent
|Filing date
|Publication date
|May 13, 1999
|Sep 19, 2000
|International Business Machines Corporation
|Relational emulation of a multi-dimensional database index
|Jun 30, 1997
|Mar 20, 2001
|International Business Machines Corporation
|Relational database management of multi-dimensional data
|Oct 15, 1999
|Dec 10, 2002
|Microsoft Corporation
|Adaptive database caching and data retrieval mechanism
|Sep 22, 1999
|Jul 22, 2003
|International Business Machines Corporation
|Method and apparatus for cross-node sharing of cached dynamic SQL in a multiple relational database management system environment
|Dec 23, 2002
|Sep 27, 2005
|International Business Machines Corporation
|Transparent edge-of-network data cache
|Apr 16, 2001
|Sep 19, 2006
|Circadence Corporation
|System and method for providing distributed database services
|Apr 16, 2001
|Jan 10, 2002
|Mark Vange
|System and method for providing distributed database services
|Apr 27, 2001
|Jul 11, 2002
|Martin Andrew Richard
|Data-base caching system and method of operation
|Apr 12, 2002
|Oct 16, 2003
|International Business Machines Corporation
|Adaptive edge processing of application data
|May 5, 2003
|Nov 6, 2003
|Ward Mullins
|Dynamic class inheritance and distributed caching with object relational mapping and cartesian model support in a database manipulation and mapping system
|Apr 12, 2002
|Nov 6, 2003
|International Business Machines Corporation
|Enforcement of service terms through adaptive edge processing of application data
|Dec 23, 2002
|Jul 8, 2004
|Amiri Khalil S.
|Transparent edge-of-network data cache
|Jun 25, 2002
|Aug 5, 2004
|Uwe Hansmann
|System and method for a caching mechanism for a central synchronization server
|May 17, 2004
|Nov 17, 2005
|Microsoft Corporation
|Data controls architecture
|Chan et al., "MODEC: Multi-Granularity Mobile Object-Oriented Database Caching Mechanism, Prototype and Performance," Distributed &Parallel Databases, V7,N3, 7/99, pp. 343-372.
|Kalnis et al., "An Adaptive Peer-to-Peer Network for Distributed Caching of OLAP Results," ACM SIGMOD, Jun. 2002, pp. 25-36.
|Leong et al., "On Adaptive Caching Mobile Databases," 1997 ACM Symposium on Applied Computing, 1997, pp. 302-309.
|Luo et al., "Middle-tier Database Cache for e-business," 2002, ACM Press, New York, NY, pp. 600-611.
|Shaffer et al., "A Highly Configurable and Adaptable Process Scheduler," IBM Technical Disclosure Bulletin, Apr. 2001, p. 630.
|Wang et al., "An Effective Wrapper Architecture to Heterogeneous Data Source," Proc. 17th Intl Conf. on Advanced Information Networking and Applications, Mar. 2003, pp. 1-4.
|Yang et al., "Dynamic Adaptive File Management in a Local Area Network," 20th Int'l Conf. on Distributed Computing System (ICDCS), IEEE Proceedings, Apr. 2000.
|Zaharioudakis et al., "Adaptive, Fine-Grained Sharing in a Client-Server OODBMS: A Callback-Based Approach," ACM Transactions on Database System, V22, N4, Dec. 1997, pp. 570-627.
|Citing Patent
|Filing date
|Publication date
|Apr 14, 2009
|May 8, 2012
|International Business Machines Corporation
|Consolidating file system backend operations with access of data
|Apr 14, 2009
|Sep 11, 2012
|International Business Machines Corporation
|Dynamic monitoring of ability to reassemble streaming data across multiple channels based on history
|Dec 23, 2008
|Dec 18, 2012
|International Business Machines Corporation
|Reassembling streaming data across multiple packetized communication channels
|Apr 3, 2012
|Jul 16, 2013
|International Business Machines Corporation
|Dynamic monitoring of ability to reassemble streaming data across multiple channels based on history
|May 1, 2012
|Feb 11, 2014
|Concurix Corporation
|Meta garbage collection for functional code
|May 1, 2012
|May 13, 2014
|Concurix Corporation
|Recompiling with generic to specific replacement
|Jul 17, 2012
|Jul 29, 2014
|Concurix Corporation
|Pattern extraction from executable code in message passing environments
|Nov 21, 2005
|Feb 3, 2015
|Oracle International Corporation
|Path-caching mechanism to improve performance of path-related operations in a repository
|Jul 12, 2011
|Dec 29, 2015
|Alcatel Lucent
|System and method for caching mobile services database objects
|Jun 29, 2010
|Jun 28, 2016
|Samsung Electronics Co., Ltd.
|Apparatus and method for processing a data stream
|Jul 17, 2012
|Feb 21, 2017
|Microsoft Technology Licensing, Llc
|Pattern matching process scheduler with upstream optimization
|Nov 21, 2005
|May 24, 2007
|Oracle International Corporation
|Path-caching mechanism to improve performance of path-related operations in a repository
|Dec 23, 2008
|Jun 24, 2010
|International Business Machines Corporation
|Reassembling Streaming Data Across Multiple Packetized Communication Channels
|Apr 14, 2009
|Oct 14, 2010
|International Business Machines Corporation
|Consolidating File System Backend Operations with Access of Data
|Apr 14, 2009
|Oct 14, 2010
|International Business Machines Corporation
|Dynamic Monitoring of Ability to Reassemble Streaming Data Across Multiple Channels Based on History
|Jun 29, 2010
|Jun 16, 2011
|Samsung Electronics Co., Ltd.
|Apparatus and method for processing a data stream
|Nov 10, 2015
|May 11, 2017
|International Business Machines Corporation
|Intelligent Caching of Responses in a Cognitive System
|U.S. Classification
|International Classification
|Cooperative Classification
|European Classification
|May 20, 2008
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:ALTINEL, MEHMET;BORNHOEVD, CHRISTOF;MOHAN, CHANDRASEKARAN;AND OTHERS;REEL/FRAME:020971/0625;SIGNING DATES FROM 20040630 TO 20040727
Owner name: INTERNATIONAL BUSINESS MACHINES CORPORATION, NEW Y
Free format text: ASSIGNMENT OF ASSIGNORS INTEREST;ASSIGNORS:ALTINEL, MEHMET;BORNHOEVD, CHRISTOF;MOHAN, CHANDRASEKARAN;AND OTHERS;SIGNING DATES FROM 20040630 TO 20040727;REEL/FRAME:020971/0625
|Oct 10, 2014
|Fee payment
Year of fee payment: 4


text:
Have you ever lost track of what you read where and when on the internet, struggled to remember where that interesting snippet of information was?
Whether doing research, searching for a new job or looking for a best buy - the bee app can help you capture the interesting bits when and as you find them on the internet. You can quickly create collections and lists of data that can be shared and conveniently viewed on your smartphone, tablet or pc (screen shot).
Palmoto bee makes internet based research more manageable and useful. Like a bee collecting nectar to make honey you can use the app to capture, curate, store and share data.
*Web app requires chrome, firefox or safari browsers to capture data - other browsers are limited to viewing data.
Data is captured using web forms that you create in Google Drive and inject into any web page to capture data using the bee app. When a form is submitted the data is collected and stored in your Google Drive spreadsheet. All your data is stored on Google Drive along with your other documents. No login is required to use the bee app and no data is processed or stored by Palmoto - giving you complete control.
Palmoto bee is an open source project hosted on Google Code. Using a secure server to deliver the application files means your secure web browsing will not be compromised. Being an open source project also means that anyone can review the integrity of application source code as required. It is published with a MIT code license.
Palmoto bee works with google drive, if you are not familiar with creating forms in google drive please read 'Create a Google form' before proceeding.
Once you have created the necessary Google Drive documents, and copied the url to the live form - open up the palmoto bee app in your browser and do the following:
You can simply view the captured data in you spreadsheet on Google Drive and use the powerful tools to create graphs or edit the data. You can also use the bee app to view your data collections as follows:
The selection type options enable you to specify what data to extract from the host web page as follows:
The default selection type is content/text. You can preset a default for individual fields when creating your form by specifying the selection type in the 'Help text' of the form field as follows: [bee/document/href],[bee/date/local] or [bee/image/url] etc (see example academic referencing form).
The selection mode options change the way in which your captured data is entered into the form as follows:
The palmoto bee app is ideal for capturing data to create academic references. Look at the following example spreadsheet and form to see what form fields are required to create your personal academic referencing app (Note the example form is not currently saving responses).academic referencing spreadsheet academic referencing form
Notice the example form makes use of the time saving data selectors [bee/document/href] and [bee/date/local] to automatically configure the form fields to the correct data type when filled. When viewed in the bee app the above documents will appear as follows:bee data bee form
You can display more than one blok in the bee app as follows:bee data and form
©2013 palmoto legal


text:
ITUs relationship with IMPACT continues to gain momentum, with over 130 UN Member States now part of the ITU-IMPACT coalition.
ITU-IMPACT is the first cooperative global venture to make available cybersecurity expertise and resources to enable Member States to detect, analyze and respond effectively to cyberthreats. Of particular benefit to developing countries and smaller states without the capacity and resources to develop their own sophisticated cyber response centres, the coalition also benefits technically advanced nations by providing them with a continuous global snapshot of potential and real online threats.
© Copyright 2017, International Telecommunication Union
The information presented within this blog comes from various organizations around the world. ITU encourages users to seek more detailed information from the original source through the links provided.
Links to third-party websites are provided for the convenience of all users. The ITU is not responsible for the accuracy, currency or the reliability of the content on these third-party websites. ITU does not offer any guarantee in that regard nor does ITU endorse the third-party organizations, their sites or content.


text:
Jennifer Garner tells Ellen what baby names her two daughters have suggested for the new baby -- and whether she and hubby Ben Affleck are hoping for a boy or a girl!
Plus, Jennifer talked about a project for which she teamed up with Frigidaire, to benefit Save the Children. For more information about Save the Children, visit frigidaire.com.


text:
The Lakers may eagerly await new coach Mike D'Antoni's arrival, but that just gives more chances for Bickerstaff to keep reporters laughing. He provided plenty of one-liners on a wide-range of topics before the Lakers played Houston.
That included D'Antoni's absence ("He and Steve Nash are waiting to make their debut together"). Bickerstaff sounded stoic D'Antoni will keep him on staff ("That's news to me; I haven't heard any pro or con"). Bickerstaff also poked fun at his son, J.B, who's a Rockets assistant coach ("I want o kick his `A' double `S' He told me the same thing").


text: This article needs additional citations for verification.Please help improve this article by adding reliable references. Unsourced material may be challenged and removed. The Cauldron is the force that powers the Heart of the Throne.[1] See AlsoEdit This article is a stub. You can help Titannica by expanding it. ReferencesEdit ↑ Daggers of Darkness - ??? Retrieved from "http://fightingfantasy.wikia.com/wiki/Cauldron?oldid=65736" Ad blocker interference detected! Wikia is a free-to-use site that makes money from advertising. We have a modified experience for viewers using ad blockers Wikia is not accessible if you've made further modifications. Remove the custom ad blocker rule(s) and the page will load as expected. Categories: Daggers of Darkness Entries References Needed Article stubs Miscellaneous Places Add category Cancel Save


text:
£120, tiffany.co.uk
Prince George hasn't cornered the market in silver spoons and this would make a lovely – if lavish – gift for non-royal babies.
2. Sophie The Giraffe gift case
£24.99, sophielagirafe.co.uk
Sophie has been in the lives of newborns for more than 50 years. She's made from natural rubber so is soft and perfect for chewing.
£149, notonthehighstreet.com
Made in Sri Lanka using ethically sourced materials, this traditional ark feels lovely to the touch.
4. Once Upon a Time Silver Rattle
£22.50, mamasandpapas.com
A silver-plated rattle will ensure your humble crib is rendered fit for a future king or queen.
£145, mothercare.com
Comes with a certificate that can be redeemed for a pair of 3D casts (hand and foot, two hands or two feet) at Mothercare stores.
£15.99, thebookpeople.co.uk
The coloured jackets in this marvellous 15-book collection are all adorned with Quentin Blake's timeless illustrations.
7. Clevamama Clevamemories book and keepsake case
£34.99, kiddicare.com
ClevaMemories is a thoughtful yet inexpensive gift personalised with baby's name and date of birth.
From £129, makesomethingspecial.co.uk
What child (once it's started walkling) wouldn't love its very own swing in the garden?
9. Vera Wang @ Wedgwood Silver-Plated Music Box
£40, selfridges.com
Silver-plated music box plays a soothing lullaby and will soon have baby drifting off to sleep.
10. Links Expandable Baby Bracelet
£75, linksoflondon.com
Classic and plain, this sterling silver bracelet has an expandable clasp, so it'll grow with them.Reuse content


text:
Cool looking graphics and innovative designs for the office or school.
Turns your desk into a blooming garden.Tags: kids, home, humor, computers, computer accessories, office supplies, electronics, usb, technologyAdded 8 Years Ago from Gift-ideaz
Duct tape has never been so stylish. Now you can fix everything around the house and not worry about looking like a college student.. oh wait...Tags: home, office supplies, storage, travel, stylish, containers, designer, wood, tapesAdded 8 Years Ago from Betterlivingthroughdesign
Never forget your keys, phone, lucky pen, ever again with this Doorganizer that you just hang on your doorknob so you see what you don't want to forget, on your way out.Tags: kids, home, sunglasses, office supplies, memory, office, cell phones, gifts, home decorAdded 9 Years Ago from wishingfish
i heart this and have often stared at it longingly... one in every color, pleaseTags: office supplies, storage, office, modern, containers, wall, organization, air, deskAdded 9 Years Ago from Velocity Art and Design
What dad couldn't use an eight day week?Tags: home, office supplies, office, modern, stationery, mom, organization, notes, notebooksAdded 9 Years Ago from Seejanework
Designed in 1998 and still going strong...looks so strong, modern and looks like it could hold your life together.... well, atleast the tape inside will hold something together....aluminumTags: office supplies, office, modern, tapes, organizing, organize, design, cool, organizedAdded 10 Years Ago from Moss Online
pretty colors, contemporary patterns...and your own combination! have fun picking your own set...for a gift, or for yourself. these are the perfect treat. handmade. set of 5
Spices, office supplies or sewing notions...these magnetic containers hold any small item and sticks to virtually any metal surface.Added 10 Years Ago from Organizedliving


text:
Let's meet for some collaborative coding and pair programming to get the productive juices flowing and keep each other motivated as we continue to crank out some code. Bring your laptops, projects, lessons and assignments and catch up on some coding with some of the most cool and interesting people in NYC!
Meetup members, Log in
By clicking "Sign up" or "Sign up using Facebook", you confirm that you accept our Terms of Service & Privacy Policy


text:
$1,437.00 1 year ago
$1437 / 2br - 925ft2 - Pet-Friendly Roseville Apartment: Live Life to its Fullest! (Roseville, Folsom, Rocklin, GB, Auburn)
Experience Deer Valley and discover resort-like living in the heart of Roseville. CALL:x892 $1,437 - $1,567 . 2 Bed 2 Bath . 925 sq ft * Unit 396 - Available Now * Unit 317 - Available 03/12/16 Deer Valley Apartments : 1801 Eureka Road Roseville, CA 95661 Property Website: http://www.ExperienceDeerValley.com Want more information? http://unit-availability.com/lead/1jz6p8478466/1?extnId=5563539 DE
1 year ago
Roswell, NM
$1,295.00 1 year ago
$1295 / 2br - 900ft2 - $1295/Updated 2bd 1ba duplex near ARD park w/garage-SPM Inc (Auburn, CA)
"Like" us and "friend" us on facebook and we'll enter you into our drawing for a Starbucks gift card! A drawing will take place each time 50 people have posted.For additional Placer County or other Gold Country rental homes listings or to download our application, please visit our website at: www.sutherlandpropertymanagement.comRefer to property code#238501: Built in 1938- Updated duplex near Aubu
1 year ago
Glens Falls, NY


text:
Welcome to Riverside's home page. As medical director of the facility, Dr. Frank Scaccia is a uniquely qualified Dual Board Certified Facial Plastic Surgeon and Otolaryngologist who specializes in cosmetic surgery, plastic surgery, rhinoplasty, facelift and treatment of sinus/nasal disorders. After a unanimous vote by his peers, Dr. Scaccia was appointed for 2012 as the Chairman and Section Chief for the departments of Ear, Nose and Throat, and Head & Neck Surgery at Meridian Health's Riverview Medical Center in Red Bank, NJ. Riverview is one of the busiest and most respected hospitals in the region being a 5 time winner of The J.D. Power and Associates Award. His list of honors in plastic surgery includes the Jack Anderson Award which he won in 1995 after receiving the highest score in the United States on the certifying exam given by the American Board of Facial Plastic & Reconstructive Surgery. In addition, his surgical abilities have been featured in Time, Newsweek, Channel 7 "Eyewitness News," and most recently this past June on the "Anderson Cooper Show" where a TV personality was commenting to Mr. Cooper how much she likes her new nose that Dr. Scaccia operated on for her and that he is an "amazing doctor." He has also contributed to the medical literature with publications in textbook and journals. Dr. Scaccia was one of the first to publish in a textbook a technique to perform simultaneous rhinoplasty and sinus surgery. Follow this link for a copy of this interesting book chapter.
MM More recently, Dr. Scaccia has been named as one of New Jersey's leading cosmetic surgeons in a special article on "Top Beauty Docs" by magazine in the February 2006 through 2009 editions. Furthermore, he was cited as one of only seven cosmetic surgeons in New Jersey that was specifically recognized for his rhinoplasty nose skills. The criteria for selection of this honor was based on Castle Connolly's physician lead research team who uses a vigorous screening process to survey physicians and administrators at leading hospitals for recommendations of highly skilled, exceptional doctors in the field of cosmetic plastic surgery. In addition Dr. Scaccia has also earned the prestigious recognition of being listed in the 2006 to 2010 editions of "The Guide to America's Top Physicians," the 2006 through 2013 editions of "Top Doctors: New York Metro Area," the 2011 listing in "US News &World Report" of Top Doctors and 2012 edition of Top Doctors: The-Star-Ledger's Inside Jersey, the Marquis' 2007 through 2012 editions of "Who'sWho in America" and most recently, has been selected for inclusion in both the 2010 and 2012 editions of "Who'sWho in Medicine and Healthcare," and the 2011 through 2012 edition of "Who'sWho in the World." Finally, Dr Scaccia has the added distinction of being included in the 2013 list of "Top Cosmetic Doctors" in the nation by Castle Connelly Medical Ltd.
MM His new office is located in the historic town of Red Bank allowing convenient access from all northern and central New Jersey sites and the New York City metropolitan area. The plastic surgery NJ and sinus center NJ includes it's own federally approved and accredited ambulatory outpatient surgical suite built to hospital safety standards and is one of the first in Monmouth County to utilize Brain Lab's Image Guided Navigational Sinus System allowing for state-of-the-art endoscopic sinus surgery.
MMRiverside has also been awarded accreditation by JCAHO (Joint Commission on Accreditation of Healthcare Organizations) the nation's leading evaluator among hospitals and other healthcare groups for quality care and patient safety. The center underwent a thorough onsite evaluation against nearly 150 standards which demonstrates our mission to provide the highest level of care possible. Your safety, comfort and privacy are our top priorities. Procedures can be performed under various levels of anesthesia (including general and twilight sleep) and will be administered by only board certified physician anesthesiologists. You will find that Dr. Scaccia's commitment to safety and excellence is exemplified throughout this web site. One benchmark is the fact that in his 20 years (residency training and private practice) as a physician (which includes thousands of surgical procedures) no medical malpractice judgments or even settlements have ever been brought against him.
MMSome of the facial plastic surgery procedures performed at the center include facelift, rhytidectomy, mini facelift, midface lift, s-lift, platelet gel facelift, weekend neck lift, eyelid rejuvenation, blepharoplasty, eyebrow lift, forehead lift, lip enhancement/rejuvenation, chin/cheek implants, liposuction, snoring and sleep apnea correction, female nasal sculpturing, rhinoplasty, male nasal sculpturing, rhinoplasty, Asian nasal surgery, Afro-American rhinoplasty, Ethnic rhinoplasty, revision/redo nasal surgery and sinus surgery.
MMBotox injections, laser surgery for tattoos, moles, pigment, spider veins, wrinkles, skin resurfacing, hair removal and scars are also available. Other plastic surgery procedures performed include ear surgery (otoplasty), split earlobe repair, AlloDerm implants, sclerotherapy and chemical peels. Gentlewaves LED Photomodulation is a new technology that we are now using to reverse photoaging and potentially speeds healing after surgery.
70 East Front St., Third Flr., Red Bank, NJ 07701 Tel: (732) 747-5300 / Fax: (732) 747-9922
Additional Offices:
525 Route 70, Suite 3A, Brick Township, Ocean County, NJ 08723 •
Tel: (732) 262-3695
305 Seguine Avenue Suite #1 Staten Island, NY 10309 • Tel: (718) 967-2411
219 Taylors Mills Road, Manalapan, NJ 07726 Tel: (732) 308-6000
Content and photos are the intellectual property of Frank J. Scaccia, M.D., F.A.C.S. and Riverside Nasal & Sinus Center and may not be used or duplicated for any reason. ©2015
A rhinoplastic correction can be performed on a patient who is under sedation, under general anaesthesia, or under local anaesthesia; initially, a local anaesthetic mixture oflidocaine and epinephrine is injected to numb the area, and temporarily reduce vascularity, thereby limiting any bleeding. Generally, the plastic surgeon first separates the nasal skin and the soft tissues from the osseo-cartilagenous nasal framework, and then corrects (reshapes) them as required, afterwards, sutures the incisions, and then applies either an external or an internal stent, and tape, to immobilize the newly reconstructed nose, and so facilitate the healing of the surgical cuts. Occasionally, the surgeon uses either an autologous cartilage graft or a bone graft, or both, in order to strengthen or to alter the nasal contour(s). The autologous grafts usually are harvested from the nasal septum, but, if it has insufficient cartilage (as can occur in a revision rhinoplasty), then either a costal cartilage graft (from the rib cage) or an auricular cartilage graft (concha from the ear) is harvested from the patient's body. When the rhinoplasty requires a bone graft, it is harvested from either the cranium, the hips, or the rib cage; moreover, when neither type of autologous graft is available, a synthetic graft (nasal implant) is used to augment the nasal bridge. Revision sinus surgery Avon By The Sea NJ 07717.
For the benefit of patient and the physician–surgeon, a photographic history of the entire rhinoplastic procedure is established; beginning at the pre-operative consultation, continuing during the surgical operation procedures, and concluding with the post-operative outcome. To record the "before-and-after" physiognomies of the nose and the face of the patient, the specific visual perspectives required are photographs of the nose viewed from the anteroposterior (front-to-back) perspective; the lateral view (profiles), the worm's-eye view (from below), the bird's-eye view (overhead), and three-quarter-profile views. Revision sinus surgery Avon By The Sea NJ 07717.


text: Hello everyone. So, I went shopping with my girlfriend last night (I think I am ready to join a women´s shoes forum now) and we came across a white blazer in Hackett. I have never really liked white blazers or suits, but she insisted on me trying it on, and while she totally loved it I am not sure about it. Since she was so convinced I got it, but now I am thinking about returning it. What do you think? How does it fit? Is a white blazer too over the top? I am 20 and it would be used in totally informal situations. I was just trying the blazer on, just ignore the rest of the clothes I was wearing at that moment. Thanks for reading!


text:
Sergey Lebedev of the Local House on Mixology, Miami, and His Favorite Drinks
Sergey Lebedev of the Local House.
Courtesy Sergey Lebedev
Sergey Lebedev looks like the Hollywood version of a South Beach bartender. He's handsome, dresses fashionably, and wears plenty of product in his hair.
He also makes a mean cocktail. Recently crowned the Ultimate Miami Bartender during the Ultimate Miami weekend competition, Lebedev works behind the bar at the Local House on Ocean Drive.
See also: Julio Cabrera Is a GQ Cover Model
Three and half years ago, the Russian native started mixing drinks at private parties back home. He studied mixology in New York before moving to Florida.
Lebedev's tip for aspiring mixologists? "Always put passion and love into your recipes. You can taste the difference when there's no life in the drink," he says.
Short Order talked to the bartender about his life in the biz, mixology, and his favorite drink.
Short Order: What do you drink when you're at home?
Sergey Lebedev: Smoothies and fresh squeezed juices. I try to load my body with nutrients and vitamins to stay in shape.
What's your favorite drink when you go out on the town?
A good sipping bourbon, neat. My work revolves around complex flavor combinations; it's nice to take a break and drink something smooth.
What's your favorite part of your job?
The creation process. Also, I love the reactions my clients have when taking their first sip.
Do you serve any local celebrities regularly?
Damian Marley. He stops by the Local House often and has a drink at the bar.
If you weren't bartending, what would you be doing?
I'd most likely be a conflict journalist. I am an avid writer and love language. I strive to be a globally-aware individual. And to be honest, I'm a bit of an adrenaline junkie.
What are some trends in Miami's mixology scene?
I'm seeing more handcrafted liquors/small batch alcohol on bar shelves. Also, infusions are pretty popular.
What's the best tip you've ever received?
A black American Express credit card left by an old lady who said: "You can use it for one day."
Follow Ily on Twitter @realily.
Follow Short Order on Facebook, on Twitter @Short_Order, and Instagram @ShortOrder.
Related Location
400 Ocean Dr.
Miami Beach, FL 33139
Get the Food & Drink Newsletter
Our weekly guide to Miami dining includes food news and reviews, as well as dining events and interviews with chefs and restaurant owners.
Recommended for You
Powered by SailThru
Popular Stories
Sponsor Content


text:
A typical Mediterranean modern designed unit, characterized by a circular big sofa at the stern. A very trend steering console with a sliding door gives the chance to enter into a semi-cabin with a WC, storage places and a refrigerator.The huge front sundeck is about 2,50 m long.
Club Nautico Santa Ponsa
Locals C&D, Via de la Cruz 46
Santa Ponsa, Mallorca