Skip to content Skip to sidebar Skip to footer
Showing posts with the label Database Design
Making Improvements To My Sql Architecture

Making Improvements To My Sql Architecture

Post a Comment
I needed to design an SQL architecture to store the various information. This is what I have came u… Read more Making Improvements To My Sql Architecture
Db Design And Data Retrieval From A Heavy Table

Db Design And Data Retrieval From A Heavy Table

Post a Comment
I have a requirement to have 612 columns in my database table. The # of columns as per data type ar… Read more Db Design And Data Retrieval From A Heavy Table
Tables Versioning (historical Tables) And Order Tables Relationship

Tables Versioning (historical Tables) And Order Tables Relationship

Post a Comment
If I add a new product in the products table or change the data - it will automatically add into pr… Read more Tables Versioning (historical Tables) And Order Tables Relationship
Conditional Foreign Key In Sql

Conditional Foreign Key In Sql

Post a Comment
i have one table called as PartyChannel having following columns ID, ChannelID, ChannelType Chann… Read more Conditional Foreign Key In Sql
Rails Activerecord And Db Normalization

Rails Activerecord And Db Normalization

Post a Comment
What are the pros and cons of breaking out optional 1:1 attributes into their own separate model. F… Read more Rails Activerecord And Db Normalization
How To Make Foreign Key Relationship On Physically Distributed Data?

How To Make Foreign Key Relationship On Physically Distributed Data?

Post a Comment
three servers server 1 is central point which links the other two servers. the other two servers ha… Read more How To Make Foreign Key Relationship On Physically Distributed Data?