Thursday Jan 09, 2014

スペインの銀行のビッグデータ事例

ワールドカップイヤーです。
だからというわけではありませんが個人的にも昨年末発表された
バルセロナの銀行のビッグデータの先端事例に注目しています。

OracleEMEA - Press Releases - CaixaBank Selects Oracle for the Deployment of its New Big Data Infrastructure

Oracle solution (including Oracle Engineered Systems, Oracle Software and Oracle Consulting Services) consists in the implementation of a new Information Management Architecture that provides a unified corporate data model and new advanced analytic capabilities.

日本語表記は"カイシャバンク"で定着しているようです。社内セミナーで
聞くかぎりは "カーシャバンク" に近く発音されてましたが。
ちなみに FCバルセロナ でスペイン代表の Xavi の "Xa" の実際の発音は "チャ" に近いそうです。

以下弊社社員のブログも参考にどうぞ。

CaixaBank deploys new big data infrastructure on Oracle (The Data Warehouse Insider)

Oracle's Reference Architecture can help you integrate structured, semi-structured and unstructured information into a single logical information resource




Wednesday Jan 08, 2014

Extract PDF titles from Windows Search

The reason why I tried the SQL for "Windows Search" was I had bunch of PDF files whose
contents I cannot guess from their filenames.

Oracle docs are part of them!  Below is one example. pdf, mobi and epub are all named "E17693".

Here's another.

Oracle Database Data Access Components Documentation

Oracle Data Provider for .NET Developer's Guide
PDF

I put these 2 pdf files and 1 mobi file in one folder.
Here's the query to find titles for all files in current folder in Cygwin.

/cygdrive/c/tmp/docs$ wssql \
> "SELECT System.ItemName,System.Title    \
>    FROM           \
>  SystemIndex        \
>    WHERE          \
>  System.ItemPathDisplay like '$(cygpath -w $PWD)%'  \
> "
Query=SELECT System.ItemName,System.Title       FROM            SystemIndex           WHERE           System.ItemPathDisplay like 'C:\tmp\docs%'
docs;NULL;
E17693-13.mobi;NULL;
e17693.pdf;Oracle Data Mining Application Developer's Guide;
e17732.pdf;Oracle Data Provider for .NET Developer's Guide;

I now know which PDF is which now. Maybe I can make the SQL more obscure or
pipe the output to 'sed' or modify the C# source to create rename script.

The above query didn't show title for the mobi file.
This is probably because I don't have appropriate IFilter installed and
I don't even know such IFilter exists!
I will write about mobi&epub next.

About

The views expressed on this blog are my own and do not necessarily reflect the views of Oracle.

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today