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 als...

It would have simpler if my nested objects were dictionaries, but these are list of dictionaries. Example: all_objs1 = [{ 'a': 1, 'b': [{'ba': 2, 'bb': 3}, {'ba': 21, 'bb': 31}], 'c': 4 }, { ...

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 ...

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 th...

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 | ...

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,S...

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 data...

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...

I insert in database values (array) $row->units with use function serialize()=>[$row->units], how can echo they with unserialize() in json_encode with $row->name? (return send for ajax cal...

I have a hard nut to crack with joing 3 tables. I have a newsletter_items, newsletter_fields and newsletter_mailgroups which I want to be joined to get a list of newsletters. The newsletter_items ...

I have have a column name MyRoles that contains a list of items (integers) stored in a field named UserRoles. I want to write a query that checks to see if a specific item is in the list. The 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...