data-structures

I have millions of songs, each song has its unique Song ID. Corresponding to each Song ID I have some attributes like song name, artist name, album…

I'm wondering if I structure my comment system with just one table where I have all my comments and userid will be good? I want to know if this…

I need to save a 3-level tree structure into MySQL. Before each time I modified the tree, I will copy the original tree somewhere.After…

I'm currently redesign a heavy loaded website, and I would appreciate any opinion about a specific database design issue. The concept is to keep in…

I am collecting lots of data from lots of machines. These machines cannot run PostgreSQL and the cannot connect to a PostgreSQL database. At the…

Articles in wikipedia get edited. They can grow/shrink/updated etc. What file system/database storage layout etc is used underneath to support it.…

I need a way to create an invoice from multiple orders every month? In the tbl_order table, I have a list of orders from the customer. tbl_order…

What are the main motivations behind the invention of NoSQL Databases? Your point of view would help my research on NoSQL databases.

When I tried to create a partition it shows me this error. SQL query: CREATE TABLE t1( id INT, val INT )PARTITION BY HASH( val )( PARTITION p0…

I've looked around for a bit now at other suggestions relating to this, but nothing I've seen has quite suited my needs, so here goes! What I have…

package com.example.whitehat; import java.io.BufferedReader; import java.io.InputStream; import java.io.InputStreamReader; import…

Hey, what is the difference between these data models ? If you think of an xml document persistence for which hierarchical data model is used (…

I am new to hadoop and trying to process wikipedia dump. It's a 6.7 GB gzip compressed xml file. I read that hadoop supports gzip compressed files…

i got two tables and my environment transaction is allowed... Table A - ID + Name Table B - ID + Value A+ Value B+ IDTable A may i know how to write…

Hi Guys! I have a complicated table (few hundred columns) and I get data in csv files every now and then. All I have to do is update the table with…

Hi! I've developed a website more than a year ago. The content were/is in two languages and now I need to build a database driven update/data…

Hi All I am building a C# program for a company that eventually will store information about newspaper articles in a data structure. The key here is…

I am new to PostgreSQL. I have a very unusual requirement for a hybrid database I need to build. From modules I've seen, it seems to me that the…

I have a table called members. It has the following columns: I am looking on advice how to improve it. id : This is user id (unique) (auto…

Please excuse the title, I had trouble wording my question without being overly descriptive. My application has tables likes these: contacts…