BIG Data Increasing the speed

Graphics Chips Help Process Big Data Sets in Milliseconds: A new database tool dramatica

Visualizing Big Data in Milliseconds on Cheap Computers

An Overview of MapD (Massively Parallel Database)

MapD is a software system that is designed to run on a hybrid architecture of GPUs and CPUs. Every modern computer has at least one CPU, and increasingly computer CPUs are divided into more than one sub-processing unit, called cores. It is not uncommon, as of early 2013,

Known as MapD, or massively parallel database, the new technology achieves big speed gains by storing the data in the onboard memory of graphics processing units (GPUs) instead of in central processing units (CPUs), as is conventional. Using a single high-performance GPU card can make data processing up to 70 times faster.

What are the Parts available in Hadoop 1.0?

Hadoop consists of two pieces 

* Map Reduce

* HDFS 

*Map Reduce 

This is Processing part of data.

for example: Job will run and nodes will be created. 

*HDFS: Hadoop Distributed File System.

 This is storing part of the data.

Happy coding. 

Bala

What is the Apache Hadoop?

=> Solutions for Big Data. 
It's deals with complexities of High Volume, Velocity and  Variety of data.

=> Set of Open Source Projects. 

=>Transforms commodity hardware in to services that 

It's stores petabytes of data reliability
Allows huge distributed computations.

=>Key Attributes.

It's redundant and reliable.
Extremely powerful.
Batch processing centric.
Easy to program distributed applications.
It's run on commodity hardware.

Big Data

Everyone talking about Big data in the industry, This is one of the major growing industry world wide.I was attended few session about Big data from Microsoft and some other vendor. 

It's really interesting stuff and gives more value to business, and that is the reason am writing to share Knowledge in Big data to all. 

Big Data,

This is nothing but a massive structure and unstructured data can't handle in a normal relational database management and it require to handle 10's and 100's servers. 

Example:

Facebook data, Tweeter data.

Manual Filter Will not enable the Table list click option in Qlikview

Step 1

Right click the list box and click Lock The filter and then the default selection will change to Blue color.

Step 2: 

Right click the list box and go to properties 

in General table select "Override Locked Field"

Now in the chart control enable to handle the selection one record.

Happy Coding.
Bala

Drop variable after use in Qlikview Load Script

LET vFromdate=Now()
LET vToDate=Today()
///LOADD ****
//From Table


LET vFromdate=;
LET vToDate=Null();

Inline Query Using Qlikview

Data1:
LOAD * INLINE [
    F1
    A
    B
    C
    D
    E
    F
    G
    H
    I
    J
    K
    L
];

>

Regex spliting the obs level in clarity

,regexp_substr(s_ndo.PATH,'[^/]+',1,6) OBSLevel6 ,regexp_substr(s_ndo.PATH,'[^/]+',1,5) OBSLevel5 ,regexp_substr(s_ndo.PATH,'[^/]+',1,4) OBSLevel4

Retrieving Multiple Roles through XOG out

<div dir="ltr" style="text-align: left;" trbidi="on"&rt; <div dir="ltr" style="text-align: left;" trbidi="on"&rt; <br /&rt; <nikudatabus xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:nonamespaceschemalocation="../xsd/nikuxog_read.xsd"&rt;</nikudatabus&rt;<br /&rt;   <br /&rt; <header action="read" externalsource="NIKU" objecttype="role" version="7.5"&rt;</header&rt;<br /&rt;   <query&rt;</query&rt;<br /&rt;  <filter criteria="OR" name="resourceId"&rt;CMS0001,CMS0002,BGUM_FO,APMDPASS,CMS0003,BGUM_US_Rolename,BGUM_US Rolename,CMS0004,CMS0005,CMS0071,CMS0006,CMS0007,CMS0066,CMS0008,CMS0009,CMS0010,CMS0011,CMS0012,CMS0013,CMS0014,CMS0015,CMS0016,CMS0017,CMS0018,CMS0019,PMD04599,CMS0020,CMS0021,CMS0022,CMS0023,ggggg,CMS0024,CMS0025,MS0026,CMS0068,CMS0027,CMS0028,CMS0029,CMS0030,CMS0031,CMS0032,CMS0033,CMS0034,CRS17157,CMS0035,MCS09573,CMS0036,CMS0063,CMS0037,CMS0038,CMS0067,CMS0039,CMS0062,CMS0040,CMS0070,CMS0041,CMS0042,CMS0043,CMS0044,CMS0045,CMS0069,CMS0046,CMS0047,CMS0048,CMS0049,CMS0050,CMS0051,CMS0052,CMS0053,CMS0054,CMS0055,CMS0056,CMS0057,CMS0058,CMS0059,CMS0060,CMS0072,CMS0061</filter&rt;<br /&rt;   </div&rt; <br /&rt; <br /&rt; Note: Don't give any gap in between resourceid.<br /&rt; <br /&rt; Happy Coding.</div&rt;

Week number display in VBA

Function GetPhilipsWeekYear(getDate As String)
Dim weeknumber As String
Dim YYYear As String
Dim mmmonth As String
Dim strDate As String

If getDate <> "" Then
' Getting the Week Number and Any format will convert to "mm-dd-yyyy"

strDate = Format(getDate, "mm-dd-yyyy")
weeknumber = Application.WorksheetFunction.WeekNum(strDate, 21)
' Getting the year from the date
YYYear = Year(getDate)
mmmonth = month(getDate)

If Len(weeknumber) = "1" Then
weeknumber = "0" & weeknumber
End If
            If ((weeknumber = "01") And (mmmonth = "12")) Then
            YYYear = YYYear + 1
            End If
            YYYear = Right(YYYear, 2)
            GetPhilipsWeekYear = YYYear & weeknumber
End If
End Function

Clarity Table Space

Clarity Table Space check for size of the memory