Stack Overflow
Stack Overflow

Questions tagged [vertical-partitioning]

11 questions
3
votes
3 answers

SQL Server: Any value in vertical partitioning when i'm always going to re-JOIN them?

i'm faced with having to add 64 new columns to table that already had 32 columns. For examples sake: Customers ( CustomerID int Name varchar(50) Address varchar(50) City varchar(50) Region varchar(50) …
Ian Boyd
  • 246,734
  • 253
  • 869
  • 1,219
2
votes
1 answer

SQL: vertically split table and create/populate keys, foreign key relationship

I would like to vertically split an existing (already filled with data). Say my starting table (trip) looks like this: ID Person Age Trip_to Date ... Alice 21 Los Angeles 2015-04-01 …
TVogt
  • 185
  • 1
  • 1
  • 11
2
votes
2 answers

Foreign key refering to multiple tables

I have 4 tables A(ida, name) B(ida, B-specific stuff) C(ida, C-specific stuff) D(ida, D-specific stuff) and i want that another table E could refer to just B OR C (not D). What can i write in the CREATE TABLE E ?
As As
  • 2,049
  • 4
  • 17
  • 33
1
vote
1 answer

Converting Paper/PDF forms for web - Normalize, Partition or Wide-Table it?

We'll be converting a fairly long lease application form into a web application for submission via PHP in to a PostgreSQL database. I abide by the maxim "Normalize till it hurts, then denormalize till it works" (Attr:SQLMenace) but as I jump in I…
Eric Kigathi
  • 1,815
  • 21
  • 23
1
vote
1 answer

postgresql: vertical partitioning brings no performance improvement

I struggle with optimizing the performance of my table with vertical partitioning. The following Select Statement should be more optimized from postgre imho: SELECT "ProductView".name, "ProductView".price, "ProductView".pid FROM …
Rick
  • 2,080
  • 14
  • 27
1
vote
1 answer

Does mysql support vertical partitioning?

I have a mysql database growing @ 45-50% a year. In last couple of years it has increased to a significant amount in size and now causing performance issues in production. While analyzing it on test environment I found that there is a table which…
prashant
  • 25
  • 3
0
votes
2 answers

How to produce horizontal and vertical lines with a for loop?

So this is my class. I'm trying to get the print() method to print out a horizontal line above my array and another line below my array. I also want to have vertical lines between each number in my array. Okay, I fixed my horizontal lines. Now I'm…
Miranda
  • 17
  • 2
  • 6
0
votes
1 answer

create vertical JDesktopPane at the left side of Jframe

i want to create a vertical JDesktopPane thus when a JInternalFrame minimizes its icon adds at the left side of Jframe and vertically below other icons not next to the previous icons and horizontally. it may be the same as linux or mac desktopPane…
arash
  • 176
  • 1
  • 5
0
votes
1 answer

Doctrine 2 and vertical partitioning

I'm currently working on a project for which i have to deal with a lot of users fields (+/- 80). My first approach was (and still is) to vertically partition the user table in 4 tables : main informations, administrative informations, banking…
Philippe CARLE
  • 549
  • 3
  • 18
0
votes
2 answers

vertical database partitioning in postgres 9.2

i have a table with 60 columns and want to vertically partition it, more or like dividing it in further small tables divided in columns. how to do vertical partitioning in a database using postgres 9.2? did alot of google but couldnt find anything…
Varun Gupta
  • 1
  • 2
-1
votes
1 answer

good approach for periodically adding columns to sql table

I am using mysql, I have a user table which holds some basic information like name, surname, age, gender, etc. I want to provide a feature called profile, where user will put other information like work location, alternative contact details, etc.…
Prometheus
  • 549
  • 1
  • 7
  • 18