background preloader

Liquibase > DB Refactoring

Liquibase > DB Refactoring
Related:  infra-gestion

HSQLDB Home Oracle Date functions and parameters Oracle Date Functions Version 10.1 Date Current Date SELECT CURRENT_DATE FROM dual; SELECT SYSDATE FROM dual; Current Time SELECT CURRENT_TIME FROM dual; Formats J Julian Date -- Day -- Month -- Year -- Fill Mode Formats That Can Be Used With ROUND And TRUNC Functions - One greater than the first two digits of a four-digit year - Year (rounds up on July 1) - ISO Year - Quarter (rounds up on 16th day of the 2nd month of the quarter) - Month (rounds up on the sixteenth day) - Same day of the week as the first day of the year - Same day of the week as the first day of the ISO year - Same day of the week as the first day of the month - Day - Starting day of the week - Hours - Minute SELECT SYSDATE + 1 FROM dual; SELECT SYSDATE - 1 FROM dual; Add A Month To A Date ADD_MONTHS( , SELECT add_months(SYSDATE, 2) FROM dual; Returns the current date of the server as a value in the Gregorian calendar of datatype DATE col sessiontimezone format a30 SELECT sessiontimezone, current_date FROM dual; SELECT DUMP(SYSDATE) FROM dual; FROM t;

The 38 Subsystems of ETL -- InformationWeek Three little letters -- E,T, and L -- obscure the reality of 38 subsystems vital to successful data warehousing. The extract-transform-load (ETL) system, or more informally, the "back room," is often estimated to consume 70 percent of the time and effort of building a data warehouse. But there hasn't been enough careful thinking about just why the ETL system is so complex and resource intensive. Everyone understands the three letters: You get the data out of its original source location (E), you do something to it (T), and then you load it (L) into a final set of tables for the users to query. When asked about breaking down the three big steps, many designers say, "Well, that depends." It depends on the source, it depends on funny data idiosyncrasies, it depends on the scripting languages and ETL tools available, it depends on the skills of the in-house staff, and it depends on the query and reporting tools the end users have. The 38 Subsystems Extract system. More Insights

Il gene - Siddhartha Mukherjee - Google Libri Spring Data Graph with Neo4j Support Spring Data Neo4J offers advanced features to map annotated entity classes to the Neo4j Graph Database. The template programming model is equivalent to well known Spring templates and builds the basis for interaction with the graph and is also used for the advanced repository support. Spring Data Neo4j is part of the Spring Data project which aims to provide convenient support for NoSQL databases. Features Quick Start Example @NodeEntitypublic class Movie { @GraphId Long id; @Indexed(type = FULLTEXT, indexName = "search") String title; Person director; @RelatedTo(type="ACTS_IN", direction = INCOMING) Set<Person> actors; @RelatedToVia(type = "RATED") Iterable<Rating> ratings; @Query("start movie=node({self}) match movie-->genre<--similar return similar") Iterable<Movie> similarMovies;} Repositories Declare a repository interface Activate Spring Data Neo4j repositories Use the repository

fr:pnp-0.6:new-features [PNP4Nagios Docs] Le travail sur la version 0.6.x est toujours en cours. Depuis la version 0.6.x nous sommes passés de subversion à GIT. Le code source est disponible chez sourceforge. Fonctionnalités déjà présentes Affichage web se basant sur Kohana Fonctions javascript se basant sur des plugins jQuery process_perfdata.pl est capable d'utiliser une base RRD par source de données Amélioration de l'installateur. Retour a l'index | Pré-requis Traitements temporels en SQL - Cl La difficulté des calculs portant sur des dates ou des horaires (et parfois les deux) est lié à la codification même de la mesure du temps ainsi qu'au fait que le temps est une entropie (disons le, même une "isentroprie"), c'est à dire qu'il s'écoule de manière uniforme (iso) et dans un seul sens irréversible (vers le futur). La mesure du temps n'obéit pas à des règles conventionnelles, comme le comptage décimal ou l'origine zéro. En effet : Les années comptent tantôt 365 tantôt 366 jours en fait 365 jours 5 heures 48 min. 45,97 sec... Les mois de 29 à 31 jours Il n'y a pas d'année 0, mais il y a des années négatives (avant JC !) Les siècles et millénaires commencent par une année unitaire (1, 1901, 2001...) Tous ces éléments font que les calculs, notamment de comptage du temps obéissent à des algorithmes complexes. De ce fait, la norme SQL 2, propose une solution générale assez intelligente. Le lundi est considéré comme le premier jour de la semaine. 1.1. La norme propose les types :

Open source data quality, data profiling and master data management | DataCleaner Centro Italiano Filatelia Tematica - Filatelia Tematica Filatelia Tematica Tutti siamo diventati filatelisti raccogliendo le nuove emissioni di uno o più paesi e poi andando a ritroso nel tempo per cercare di completare quelle collezioni con tutti i francobolli emessi in precedenza. La cosa funziona finche ci si accorge che diventa difficile completarla perchè restano mancanti i francobolli più costosi o difficili da trovare. C'è un rimedio contro questo pericolo? Basta osservare con attenzione i francobolli. Prendiamo ad esempio questo, emesso dall'Italia nel 1981: guardandolo con attenzione e senza curarci di quale casella occupi nell'album vediamo che esso raffigura un veliero, un sestante, un marinaio; e quindi soggetti come le navi, i mezzi di comunicazione, la scienza, le uniformi, i centenari (dell'Accademia Militare), Amerigo Vespucci (il nome della nave).Sono i TEMI che questo francobollo propone. Ugualmente utili le affrancature meccaniche; sì, proprio quelle impronte rosse che spesso vediamo sulla nostra corrispondenza quotidiana.

Related: