The database-denormalization tag has no wiki summary.
0
votes
1answer
36 views
Which one is best solution for future database structure?
I'm working on a big web application. so i need to create user_preference_table it has the marks for every users for each attributes. here attributes are games so in the user_preference_table i need ...
0
votes
0answers
17 views
Storage solution for large number or denormalized records
We currently have a MSSQL server with the data stored in a denormalized format in a single table (per record type) where there can be millions of rows containing many columns in some cases. The ...
3
votes
2answers
151 views
Denormalized tables within OLTP database
My company has a product centered around a fairly normalized mssql server database. At this point we have several reports and a web application that needs the data in a much flatter fashion to ...
5
votes
3answers
510 views
Replace relational database with “poor” design in software product with non-relational DB? [closed]
Edit: This question is about how to deal with many issues that arose from a overall system design, which made parts of the system deviate from common standards. For example, managing everything in the ...
0
votes
3answers
163 views
Best way to create relationship between multiple tables
I have a question about how to best handle a table that would be shared among multiple relationships, but shouldn't really be joined with all these tables. For example, suppose I have a table that has ...
1
vote
2answers
312 views
Best practice database design - user rating tables
I want to create a table to store user ratings of items for collaborative filtering algorithms. So far my table looks like this:
IID | UID | Rating
i.e.
item ID |user id |rating.
From ...
1
vote
1answer
34 views
Denormalization Strategies: When is it appropriate to create redundancy for faster querying?
So I sometimes see databases purposely add redundant information for faster querying. I saw that this was mentioned here but I was wondering when would this be better than indexing, or creating a ...
0
votes
0answers
57 views
Store both a city and its region?
I store various events (such as a search on the site) into a table (in fact I have two tables: one for the event and other (linking to the first) with characteristics of the event).
Each city belongs ...
0
votes
2answers
56 views
Should I create separate table or have the information as columns in the same table
Sorry for the title but I could not find anything better that could suit my needs. I'm designing the database of a Document Management (Circulation) application. There are two types of documents - A ...
1
vote
1answer
35 views
Should I denormalize lat & lon on area searches?
I run a hobby web site for tabletop gamers. They can search based on postal code in a radius round their location. As I consider adding new countries, my best option seem to be silo'ing the geo ...
6
votes
4answers
239 views
Store millions of rows of denomalized data or some SQL magic?
My DBA experience doesn't go much further than simple storage + retrieval of CMS style data - so this may be a silly question, I don't know!
I have a problem whereby I need to lookup or calculate ...
3
votes
1answer
77 views
Database Normalization
If someone could guide me on helping me understand if my results are correct I would appreciate that. Let's say I have the following table:
BOOK(BookTitle, AuthorName, BookType, ListPrice, ...
2
votes
0answers
64 views
Denormalizing to speed up inserts
I have a MySQL InnoDb table with approximately 40 million rows and the following columns:
param1 (int),
param2 (int),
param3 (int),
geo (char2),
value1 (bigint),
value2 (bigint)
I have an ...
1
vote
0answers
101 views
Decomposing table into BCNF that preserves dependencies
I have a relation like
R(A,B,C)
and dependencies like
A->B , B->C , A->C
I think the relation is in 2NF as candidate key is A. AFAIK when there is only one candidate key then the ...
1
vote
1answer
76 views
Database Over Normalized [closed]
How can you tell when a database is over normalized? Example: I have a database for employee. These are the following tables involved:
User - contains email, password, companyId
Profile - ...
1
vote
1answer
76 views
Will a specific denormalization increase performance in a specific scenario?
Suppose I have a table with fields | a | b | c | d | ... | z | which contains millions of records and which will serve millions of queries a day. And the field z holds the id of some parameter which ...
2
votes
1answer
54 views
Denormalize Design Modification
Our DBA is on medical leave, I am just a developer trying to do my part. Initially, the bean counters were going to use quickbooks. However, after seeing how much time they could save with custom ...
0
votes
1answer
152 views
Are de-normalised tables preferred in any aspect of a project? [closed]
While going through interview , My Interviewer asked me a question about Denormalization of tables and its usage in applications.
On guess, I answered, Yes it might be. Being denormalized , you have ...
1
vote
1answer
327 views
Database denormalization: multiple rows into single column. How bad is it? [duplicate]
We have few join-heavy queries to our SQL Server 2008 database and in an attempt to optimize them I thought of having a view that would produce this
OrderID Number Traveller
1 102 ...
3
votes
2answers
287 views
Why is my CPU usage increase after setting database to read-only on SQL Server 2008 R2 [closed]
I administrate a reporting database. We run all the de-normalization process on a database DB1 daily, then we copy all the data to an another database DB2 on the same server which is queried by web ...
