Stack Overflow
Stack Overflow

Questions tagged [denormalized]

Denormalization is the process of moving from higher to lower normal forms of database modeling in order to speed up database (read) access.

Denormalization is the process of moving from higher to lower normal forms of database modeling in order to speed up database (read) access.

83 questions
23
votes
3 answers

NOSQL denormalization datamodel

Many times I read that data in NOSQL databases is stored denormalized. For instance consider a chess game record. It may not only contain the player id's that participate in the chess game, but also the first and lastname of that player. I suppose…
Stefan
  • 1,279
  • 4
  • 14
  • 28
13
votes
2 answers

Storing arrays in the database

I'm wondering if it is actually good practise to store Arrays in the database ? I tend to use json_encode rather than serialize, but was just wondering if it is a good idea. If not, then I can make some small changes and just implode the array with…
Jeanie Tallis
  • 595
  • 2
  • 6
  • 12
13
votes
1 answer

How to maintain denormalized consistency in NoSQL?

Say I have two collections, each with value independent of each other, but each related to one another. They are photos and users. There is a one-to-many relationship between users and photos. An example of denormalized data: users: { "id":…
Snixtor
  • 4,239
  • 2
  • 31
  • 54
7
votes
4 answers

Oracle SQL getting the nth element regexp

I am trying to get the nth element in a comma separated string using SQL in Oracle. I have the following so far.. SELECT regexp_substr( '100016154,5101884LT00001,,,,,100000010892100000012655,L,SEI,5101884LT00001,1,SL,3595.03,00,2,N,N,G,N', …
Jon H
  • 1,061
  • 4
  • 13
  • 32
5
votes
4 answers

Storing Multiple Checkbox Data in MySQL Database with PHP

I want to have multiple checkbox values be stored into one field in a database. (Ex. 1, 24,56,100). I am wanting to know how I can make this happen, and how does PHP read these values from the database if I want to call variables in a…
drummer392
  • 473
  • 2
  • 8
  • 35
5
votes
3 answers

Mysql WHERE problem with comma-separated list

I need help for this problem. In MYSQL Table i have a field : Field : artist_list Values : 1,5,3,401 I need to find all records for artist uid 401 I do this SELECT uid FROM tbl WHERE artist_list IN ('401'); I have all record where artist_list…
soulfaya
  • 65
  • 4
5
votes
2 answers

Export denormalized data from excel to xml

We are trying to export an excel table with "Denormalized Data" to xml. The table headers are as follows: | AssetManager Code | AssetManager Date | Portfolio Code | Portfolio Name | MarketValue | NetCashFlow | Field | Field Code | Field Name | The…
Martinffx
  • 2,426
  • 4
  • 33
  • 60
3
votes
1 answer

Consuming non-normalized data with the Knockout Mapping Plug-In

I have a REST service that returns a collection that contains non- normalized data. For example, it might look something like…
Armchair Bronco
  • 2,367
  • 4
  • 31
  • 44
3
votes
3 answers

How to de-normalize mysql database for user notifications?

I think it is necessary to de-normaize database for user notifications. For example, when flagging a post (which should be considered by user), we add a column of flag ENUM('yes', 'no') (or status column). Finding flagged events for a user can be by…
Googlebot
  • 15,159
  • 44
  • 133
  • 229
3
votes
2 answers

Chain of tables, when to denormalize?

Say TABLE-A can have one or more rows in TABLE-B, which can have one or more rows in TABLE-C, which can have one or more rows in TABLE-D ... and so on. Say I am at TABLE-Z and need to know details about TABLE-A. Do I make a SQL query that works from…
StackOverflowNewbie
  • 39,403
  • 111
  • 277
  • 441
3
votes
2 answers

Retrieving a Specific Value From A Serialized Array MySQL

Database structure is as…
jamckp
  • 207
  • 2
  • 11
3
votes
5 answers

Is it possible to query a comma separated column for a specific value?

I have (and don't own, so I can't change) a table with a layout similar to this. ID | CATEGORIES --------------- 1 | c1 2 | c2,c3 3 | c3,c2 4 | c3 5 | c4,c8,c5,c100 I need to return the rows that contain a specific category id. I starting by…
Andy
  • 49,085
  • 60
  • 166
  • 233
3
votes
2 answers

IEEE 754 Denormalized Decimal Converting to Half-Point Binary

I am trying to convert 0.0000211 to binary. Here is what I understand so far: E = -bias + 1. bias = 15, E = -14 Sign bit and exponent = 0. So I have: 0 00000 ?????????? With the half-point format being 1 sign bit, 5 exponent bits, and 10 fraction…
James Schmiechen
  • 243
  • 2
  • 7
3
votes
2 answers

Python: smallest denormalized double error

Using WinPython 3.4.4.2, I get the following weird result: >>> 2**-1075 5e-324 That is, the same as 2**-1074, whereas 2**-1075 should be zero in double float representation. With Python 3.5.1 at the address https://www.python.org/shell/, I get 0 as…
Tig la Pomme
  • 131
  • 3
3
votes
1 answer

Rails Model for adapting to legacy denormalized table containing multiple values

I have a legacy table that looks something like item-detail-table some-key, item-1, description-1, item-2, description-2, item-3, description-3, item-4, description-4, item-5, description-5, other-fielda, other-fieldb, …
Gavin Scott
  • 33
  • 4
1
2 3 4 5 6