Aster Data expands SQL for map/reduce

Aster Data has built a business out of map/reduce, and the release today of a thousand new SQL query building blocks—what it calls "functions"—is designed to give business users access to map/reduce computed analytics.

Whereas open-source big data solution Hadoop, for instance, is based entirely on its own implementation of map/reduce, as well as a set of homegrown query structuring frameworks like Pig and Hive, Aster Data wants to use SQL right from the start. Sharmila Shahani-Mulligan, executive vice president of marketing at Aster Data, said that this is a significant advantage over Hadoop.

“Hadoop lends itself more to batch-type processing. Most of our customers are running analytics on a daily basis with the expectation of results returned every few minutes," she said. "It's not real-time, but it's near real-time.

"The second advantage is SQL map/reduce. We are literally targeting the business analyst with SQL using full map/reduce underneath.”

Map/reduce is the framework for processing huge amounts of data, and it is the basis of the Apache Hadoop project, as well as of Big Table, which runs Google's search engine. Using map/reduce, huge stores of data can be processed, and the results can be combined into a cohesive set of information.

Stephanie McReynolds, director of product marketing at Aster Data, said the new sets of query-building tools aren't limited to business users. “We introduced many new business analyst-ready functions," she said. "[These] functions address particular business issues, like path analysis for website traffic.

"We also have a series of packages for power users. These are for people building their own SQL map/reduce applications. They want to use Java or C functions to get ahead. These are smaller building blocks."

Shahani-Mulligan said that Aster Data's analytics can be tweaked and queried by business users, a major advantage over Hadoop. She said that many business users already know SQL, which cannot be said of Hive or Pig. She said that with Hadoop, developers likely need to be called in to implement any analytics batches that need to be run, but with Aster Data, the business users can do that themselves.

“With almost any of our [customers] you talk to, one of the big appeals has been that their existing business analysts can work with functions and don't have to use a new language," said Shahani-Mulligan. "This is why we came out with SQL map/reduce. Some of them also have Hadoop, but it requires you to do constant programming in map/reduce versus having a simple-to-use interface."

By Alex Handy

Moss 2007 FAQ: Enable/ Disable fields with selection of radio button in Moss 2007 - By Mario Fernandes

Query by Biplab Mitra: 

I need some help from you regarding MOSS.

I need to enable/disable some fields with the selection of radio buttons.

How can I add JavaScript to the fields in the list? As I am unable to get the field ID.

Even I need to add some logic for calculating some fields with the selection of the radio buttons.

Solution by Mario Fernandes

1. Open the List.  ( I am assuming its Employee list.)
   
   
2. Pick any one record & go in edit mode.
   
   
3. Right click on the page & View Source
   
   
4. Search for <form element  - note down the “name” value
   
   
5. Search for the field you wish to make read only say “EmployeeName”. Check <input element next to it – note down the “name” value
   
   
6. Copy the URL of this EditForm.aspx
   
   
7. Open Sharepoint Designer, File à Open à paste the url you copied
   
   
8. Go to code window.
   
   
9. Locate <IMG src="/_layouts/images/blank.gif"
   
   
10. Just after this <Img> element put this code  ---      document.formname.inputfieldname
    
    
11. <script type="text/javascript" language="javascript">document.aspnetForm.ctl00$m$g_bf411c27_b525_4df6_a7f3_a64ee5b5aef3$ctl00$ctl04$ctl01$ctl00$ctl00$ctl04$ctl00$ctl00$TextField.disabled="true";</script>
    

    
    
12. Save the form. Refresh the page.
    
    
13. There you go
    
    

Synergetics is a premium brand in the Indian IT industry in the area of people competency development  engaged in delivering it thru  its training and consulting interventions; primarily focusing on their productivity with regards to the project and deliverables on hand . Its primary differentiator has been its solution centric approach and its comprehensive client focused service portfolio.

.NET 3.5 WPF FAQ: How to remove highlighted attributes in WPF application - By Mario Fernandes

Query by Mr. Rajpreet Singh

I have a query in my WPF application.

I was trying to generate XAML styles at runtime using the following code:

XNamespace xmlns = XNamespace.Get("http://schemas.microsoft.com/winfx/2006/xaml/presentation");

XNamespace x = XNamespace.Get("http://schemas.microsoft.com/winfx/2006/xaml");

XDocument xamlDoc = new XDocument(

      new XElement(xmlns + "ResourceDictionary",

            new XAttribute(XNamespace.Xmlns + "x", x.NamespaceName)));

xamlDoc.Root.Add(

      new XElement("SolidColorBrush",

            new XAttribute(x + "Key", "ButtonBrush"),

            new XAttribute("Color", "Red")));

The output which I get is as shown below, but it also brings this (highlighted) useless attribute.

<ResourceDictionary xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation">

            <SolidColorBrush x:Key="AutoBrush" Color="Black" xmlns="" />

      </ResourceDictionary>

Please tell me what I should change in the code to get rid of this. For now I have manually removed it from the XAML string.

I have also tried combing both the statements into a single one but that also doesn’t help:

XDocument xamlDoc = new XDocument(

new XElement(xmlns + "ResourceDictionary",

new XAttribute(XNamespace.Xmlns + "x", x.NamespaceName),

new XElement("SolidColorBrush",

new XAttribute(x + "Key", "ButtonBrush"),

new XAttribute("Color", "Red"))));

Solutions by Mario Fernandes

(Just add the variable I have marked in green.)

XNamespace xmlns = XNamespace.Get("http://schemas.microsoft.com/winfx/2006/xaml/presentation");

XNamespace x = XNamespace.Get("http://schemas.microsoft.com/winfx/2006/xaml");

XDocument xamlDoc = new XDocument(

      new XElement(xmlns + "ResourceDictionary",

            new XAttribute(XNamespace.Xmlns + "x", x.NamespaceName)));

xamlDoc.Root.Add(

      new XElement(xmlns + "SolidColorBrush",

            new XAttribute(x + "Key", "ButtonBrush"),

            new XAttribute("Color", "Red")));

The output which I get is as shown below, but it also brings this (highlighted) useless attribute.

<ResourceDictionary xmlns:x=http://schemas.microsoft.com/winfx/2006/xaml xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation">

            <SolidColorBrush x:Key="AutoBrush" Color="Black" xmlns="" />

      </ResourceDictionary>

Please tell me what I should change in the code to get rid of this. For now I have manually removed it from the XAML string.

I have also tried combing both the statements into a single one but that also doesn’t help:

XDocument xamlDoc = new XDocument(

new XElement(xmlns + "ResourceDictionary",

new XAttribute(XNamespace.Xmlns + "x", x.NamespaceName),

new XElement("SolidColorBrush",

new XAttribute(x + "Key", "ButtonBrush"),

new XAttribute("Color", "Red"))));

 Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications.