niedziela, 23 października 2016

Teradata 15 Features

I come across Wiki page that explains new features of Teradata 15.

JavaScript Object Notation: 
JSON maksymalny rozmiar to 16 MB. JSONPath wspiera regularne wydarzenia oraz przeszukiwane formatu JSON.
Teradata QueryGrid:
Teradata posiada wtyczkę do Hadoop, a nawet więcej niż wtyczkę. umożliwia to komunikację
z Hadoop oraz wyciąganie danych z HDFS( Hadoop Filesystem).

XML Data Type:
Teradata zaimplementowała nowy typ kolumny w formacie XML. Pdobne rozwiązanie istnieje
w DB2 i jak dotąd się nie sprawdzało. Czy w przypadku Teradaty nowe rozwiązanie będzie efektywne?

DBQL Show Parameters
Parametryzacja zapytań SQL odbywa się obecnie za pomocą tych dwóch tabelek.
  • DBC.DBQLParamTbl
  • DBC.DBQLParamTbl logs
Light-Weight Redistribution:
Light-Weight Redistribution(LWR) także znane jako the Single Sender Redistribution (SSR).
Ta opcja umożliwa redystubucję danych po nie wszystkich AMPs jakie są dostępne, ale po wybranych.

Wywiad Teradata 15.10 

5 Unique Abilities of Teradata® Database 15.10

  • In-memory optimization
  • Fast JSON performance
  • Advanced hybrid row/column storage
  • Teradata Software-Defined Warehouse
  • Teradata QueryGrid™ improvements

We added the optional ability to store JSON data in two binary formats within a Teradata Database table in addition to the text format supported in Teradata 15.0. The latest version of the database includes new built-in functions for working with JSON data to improve usability and ease application development.

Teradata Columnar was introduced in Teradata 14 and used only tables without a primary index. Teradata 15.10 allows a columnar table or join index to have a primary index or a primary AMP index. As a result, a Teradata Columnar table can be tuned with a primary index to meet operational performance and concurrency requirements for tactical queries while providing strong performance for strategic queries by reducing disk I/O requirements. Previously, there were performance tradeoffs when using Teradata Columnar. Now you get the pluses without the minuses.

 Secure Zones provides zone-level isolation, with each zone appearing to be the entire system to its users. The users see only the tables and data within the zone for which they are authorized. One physical system is able to host several separate database environments, with security isolating the users and data of each one. Secure Zones can work with existing software-controlled features such as Teradata Workload Management and Teradata Data Lab to provide separation of data and users, and precise allocation of system resources. 
Przydałoby się to przetłumaczyć.

sobota, 5 marca 2016

Motivation Letter

My set of skills:
Teradata & Microtrategy
Oracle & Business Objects

Informix...
Sas Enterprise Guide

About me ;-):
Brzydzę sie chamstwem, fałszem , zdradą, kłamstwem, pozerstwem, brakiem szacunku i kultury oraz arogancją...
   Najważniejsze są dla mnie: spokój, stabilizacja, przyjaźń i zaufanie, odpowiedzialne podejście oraz wzajemny szacunek.

Praca poprzednio obejrzany projekt do timesheet play:
activator-test-patterns-scala
https://github.com/jtescher/activator-test-patterns-scala.

piątek, 19 lutego 2016

Upload CSV file to Web application Server and Database

Here are usefull sites that I have found that describe how to
load CSV file into table in database.


http://www.tutorialspoint.com/jsp/jsp_file_uploading.htm :
This simple turorial describes how to load file into application server.



https://sourceforge.net/p/opencsv/source/ci/master/tree/examples/

This is library that makes reading CSV file easy. U can easily load your data file
into memory as data structure that is easy to handle.


https://dzone.com/articles/fully-dynamic-classes-with-asm

Here is example how to use Struts 2 to load CSV file into table.

Honestly it looks difficult to me, but it have additional options that helps you handle this process without unexpected errors.

http://examples.javacodegeeks.com/enterprise-java/spring/mvc/spring-mvc-file-upload-example/













Here is standard model to do task of loading CSV file into table or server first.


If you have very old technology like Struts 1.2 and you want to pass file in jsp
into Application form you must be aware of special tags that Struts 1.2 uses:

http://people.apache.org/~germuska/struts-taglib/docs/tlddoc/html/tld-summary.html