Schlagwörter » Database

Managing data store changes in containers

When creating microservices it’s common to keep their persistence stores loosely coupled so that changes to one service do not affect others. Each service should manage it’s own concerns, be the owner of retrieving/updating it’s data and define how and where it gets it from. 463 weitere Wörter

Generating series of data in PostgreSQL

Recently I had received an apparently simple task: „Count the number of returning users, per month age.“, and it should be presented like a cohort analysis… 600 weitere Wörter

Cohort

Mail Merge

„Oh, dear!  We have 200 invitations to send to this wedding, and my handwriting is no longer readable. With the onset of my arthritis, just the idea of handwriting 200 envelopes is painful.“ 207 weitere Wörter

Printing

Process of Data

Written back in January 2016. Great amount of information could be changed in this.

Process of Data

1. Let’s say there is a data question that needs to be answered so we need to identify the schemas (tables). 1.409 weitere Wörter

Data

Weekly Create - Week 5

For this week’s Weekly Create we were asked to evaluate an online DH project/database/edition/archive of our choosing in accordance with the following criterion:

  1. What contribution does it make to scholarship?
  2. 540 weitere Wörter

Find Out Invalid Database Objects

The following finds out invalid database objects:

#####################################################################
## invalid_object_alert.sh ##
#####################################################################
#!/bin/ksh
. /etc/oracle.profile
sqlplus -s <<!
oracle/$1@$2
set          feed off
set heading off… 169 weitere Wörter

Scripts

Check Alert Logs (ORA-XXXXX)

Some of the environment variables used by each script can be put into one  profile:

#######################################################################
## oracle.profile ##
#######################################################################
EDITOR=vi;export EDITOR ORACLE_BASE=/u01/app/oracle; export
ORACLE_BASE ORACLE_HOME=$ORACLE_BASE/product/8.1.7; export… 194 weitere Wörter

Scripts