myITscrapbook

I'll post and clip something about IT which is useful for me

[nosql]

Prakash Karia with a short overview of the new in-memory engine for SQL Server 2014:

Today I am going to discuss the new SQL Server 2014 feature In-memory OLTP a.k.a. Hekaton — a Greek word which means hundred or hundredfold. In-memory OLTP significantly reduces the time required for OLTP workload processing. The best part of this feature is that this is installed with the SQL Server 2014 Engine without requiring any additional installations. It also allows its benefits without rewriting your database application.

It’s not EDW so I cannot use it to prove my scenario.

Original title and link: Hekaton: In-memory OLTP Engine in SQL Server 2014 (NoSQL database©myNoSQL)

[johngoodwin225-deactivated20180]

Useful blog post (found via semanticweb.com) on using SPARQL with the statistical programming language R. Examples are given using data from data.gov.

[johngoodwin225-deactivated20180]

New Book on Graph Databases

New book on graph databases available as a free download here.

[graylien]

Making a SPARQL Query

To make a SPARQL Query, you can use

sparql.org

Virtuoso

These are both generic endpoints where you can run SPARQL queries. Each endpoint provides a form where we can input a query, and the results are returned (as HTML).

TRY IT

Using sparql.org, paste this into the large box:

PREFIX foaf: <http://xmlns.com/foaf/0.1/> SELECT ?name WHERE {  ?person foaf:name ?name . }

and this into the Target graph

URI: http://dig.csail.mit.edu/2008/webdav/timbl/foaf.rdf

[steveharris-blog]

Some time ago Nick at Garlik wrote a UNIX-flavoured command line tool for interacting with SPARQL query endpoints. He released it under the GPL, and we occasioanly make small hacks on it.

I got to thinking about what’s the most annoying thing about writing SPARQL queries? I find remembering an...

[mlamoureux-deactivated20200315]

I’m taking up a pet project to develop a personal data dashboard that I will make partially public on my blog. I’m challenging myself to do this as I was looking for a achievable project to undertake using Semantic Web technologies. Here are the data sources, some of which are manual, that...

[matthew4545]

SPARQL Cheat Sheet

SPARQL Cheat Sheet

View more presentations from LeeFeigenbaum

If the presentation is too small to see here, see it at Slideshare.

[g-hennux-blog]

This is the story of how I tried to use Semantic Web technologies, like RDF and Linked Data, to achieve a basically simple task, and of everything that prevented me successfully doing so.

The Task

The very simple task (TM) was: Given the German Wikipedia identifier of an article...

[nosql]

Impressive roster for Teradata. I’d also love to see a list of deployments where Teradata and Hadoop are meeting.

Original title and link: Teradata Deployments:Apple, Walmart, eBay, Verizon, AT&T, BoA (NoSQL database©myNoSQL)

[nosql]

Kathryn Kelly for SmartDataCollective:

This is the one that really got people. Companies need solutions that enable them to use and customize their data easily, because it is the whole team, not just the individual analyst, that knows the business best. By offering business users intuitive data solutions, we bypass the need for the data scientist, who works in isolation. In fact, most data scientists are associated with the old school of business intelligence, where systems were so complicated that they needed someone with a data science background to run and get value from them. The new generation of solutions, on the other hand, is making it easy for business users to engage big data. An interdisciplinary team will see and use the visuals provided, and collaborate on the best decisions on a regular basis.

It’s better not to make predictions when you miss the point.

Original title and link: The Data Scientist Concept Will Die (NoSQL database©myNoSQL)

[orabach]

create diskgroup for asm

CREATE DISKGROUP data NORMAL REDUNDANCY DISK   'o/192.xxx.xx.xa/DATA_H*',   'o/192.xxx.xx.xb/DATA_H*',   'o/192.xxx.xx.xc/DATA_H*',   'o/192.xxx.xx.xd/DATA_H*',   'o/192.xxx.xx.xe/DATA_H*',   'o/192.xxx.xx.xf/DATA_H*',   'o/192.xxx.xx.xg/DATA_H*' ATTRIBUTE   'content.type' = 'DATA',   'au_size' = '4M',   'cell.smart_scan_capable'='TRUE',   'compatible.rdbms'='11.2.0.x',   'compatible.asm'='11.2.0.x' ;

  add another disk to diskgroup

ALTER DISKGROUP data ADD DISK   'o/192.xxx.xx.xh/DATA_H*',   'o/192.xxx.xx.xi/DATA_H*',   'o/192.xxx.xx.xj/DATA_H*' ;

[orabach]

using grep to find file using string word

grep stringword  ./*

[inercia]

A scalable RPC interface to MySQL, with client-side sharding, limited ACID support and more

[inercia]

[orabach]

tmux.conf

#Prefix set-option -g prefix C-z

#Characterset setw -g utf8 on set -g status-utf8 on

bind C-r source-file ~/.tmux.conf

set -g status-interval 10 set -g status-bg colour100 setw -g window-status-current-fg black setw -g window-status-current-bg white

#vi-style controls for copy mode setw -g mode-keys vi

# syhchronize bind C-s set-window-option synchronize-panes on bind C-f set-window-option synchronize-panes off

[orabach]

[orabach]

match better or maybe the best

COLUMN SEGMENT_NAME HEADING "セグメント名" FORMAT A36 COLUMN OWNER HEADING "オーナー" FORMAT A8 COLUMN SEGMENT_TYPE HEADING "セグメントタイプ" FORMAT A16 COLUMN AREA_M HEADING "エリアサイズ(M)" FORMAT 999,990 SELECT SEGMENT_NAME, OWNER, SEGMENT_TYPE, TRUNC(BYTES/(1024*1024),0) AREA_M FROM DBA_SEGMENTS WHERE TABLESPACE_NAME = '&t.' ORDER BY SEGMENT_TYPE,SEGMENT_NAME /