Re: Java DB rotation

From:

=?ISO-8859-1?Q?Arne_Vajh=F8j?= <arne@vajhoej.dk>

Newsgroups:

comp.lang.java.programmer

Date:

Tue, 31 Jan 2012 20:31:37 -0500

Message-ID:

<4f2895f9$0$283$14726298@news.sunsite.dk>

On 1/31/2012 1:57 PM, Chris Riesbeck wrote:

On 1/31/2012 1:38 AM, Robert Klemme wrote:

On 31.01.2012 03:32, Arne Vajh?j wrote:

On 1/30/2012 9:24 PM, Jim Lee wrote:

On Tue, 31 Jan 2012 02:21:11 +0000 (UTC), Martin Gregorie
<martin@address-in-sig.invalid> wrote:

On Mon, 30 Jan 2012 18:08:04 -0800, Jim Lee wrote:

I have a Java server controller that read/write to Database table

Java server will start read / write to a new DB table every
week/monday
e.g.
table-1-2-2012 table-1-9-2012 table-1-16-2012 table-1-23-2012 ... etc

What problem are you using table rotation to solve?

What would prevent you from using a single table containing
datestamped
rows which are archived and/or deleted the rows after "cycle length"
days?

my main problem is how to make sure "how to get the correct table name
to read/write to" depending what day in the week

start a new DB table is a must since it's going through some other
REST backend layer

There is nothing in REST that requires such a table structure.

And it would be better to fix the bad code requiring such
a table rollover than to make other apps bad to work with it.

Another question: Jim, what database are you using? If the instance
requiring multiple tables is afraid of volume the typical solution to
this issue is called "partitioning". If your database supports it,
that's typically the way to go for such kind of data.

Pretty much every response from the OP has suggested either really bad
intra-team communication (distributed team?), or a system architect
angling for an appearance on the Daily WTF.

In both cases it would make sense to push back a little
bit.

(within the constraints given by the org chart)

Arne