How to store table with a large number of fields?

Let’s learn how to store table with a large number of fields. The most accurate or helpful solution is served by Stack Overflow.

There are ten answers to this question.

Best solution

Implementing and indexing User Defined Fields in an SQL DB

I need to store a large table (several millions or rows) that contains a large number of user-defined fields (not known at compile time, but probably around 20 to 40 custom fields). It is very important (performance-wise) for me to be able to query the data based on those custom fields: i.e. "Select the rows where this attribute has that value, that attribute is that value, etc.". Each query has some 20 to 30 WHERE clauses. My ideas so far: Change the database schema everytime a new...

Answer:

It seems like you've listed your available options. EAV can be a pain for querying (and slow, depending...

Read more

Radu094 at Stack Overflow Mark as irrelevant Undo

Other solutions

C++ hashing table in data structure

QUESTION: Hello..Zlatko,, I have some question to ask you regarding my project question. This is the question : Write a program to perform hash table using two different hashing functions and two different resolution methods to solve the collision...

Answer:

Hello Wale. I wrote a sample hash program in the hope that it will be useful to you. The hash table...

Read more

Miningco.com Mark as irrelevant Undo

How to print results in a table

I checked when the user enters a size of 1 or 2 and it is working the way I want. The output I mailed you is different from the output you get if you run the program may be is that what make you think there is something wrong if not, I do not know what...

Answer:

Ok, if you say your program is running correctly, I believe you. However I probably broke it because...

Read more

Miningco.com Mark as irrelevant Undo

How to efficiently store data in hive?

How can I efficiently store data in Hive and also store and retrieve compressed data in hive? Currently I am storing it as a TextFile. I was going through [Bejoy article](http://kickstarthadoop.blogspot....) and I found that LZO compression will be good...

Answer:

You can use ORC File format as the underlying file format for Hive. This format has several advantages...

Read more

Gautam P Hegde at Quora Mark as irrelevant Undo

In SQL Server, how can I look for dupes on multiple similar fields?

My apologies up front if this doesn't make sense. My table has 5 phone number fields. Most of the records have the same value in 2 or 3 of these fields. I want to list each unique phone number from *any* of these fields, but only if it exists in ...

Answer:

I would first merge the fields into a single virtual column. Then you use a basic "find dupes"...

Read more

Anon User at Quora Mark as irrelevant Undo

Using a hash table with keyword searches.?

A little background: The project is to store a file of "mp3s" in the form Title|Artist into a hash table. Some of the functions i need to write are search by title, search by artist, search by keyword and insert into a playlist. I am just confused...

Answer:

take each title and hash the words of the title so Johny Be Good, Hash Johny = 27, Hash Good = 87 build...

Read more

Yahoo! Answers Mark as irrelevant Undo

What is the best design for an audit/history table?

There are three approaches, but I am not sure which one should be followed, A single table with the fields id | table | column | row | old_value | new_value | timestamp | userid. This would track all changes to all tables in a single place and has the...

Answer:

Option #3 is almost always the best one, at least for traditional structured databases. There are a...

Read more

Andrew Rogers at Quora Mark as irrelevant Undo

Create a program that uses the division method of hashing to store the data values into hash table with table?

create a data set with 100 integer values. create a program that uses the division method of hashing to store the data values into hash table with table sizes 7 , 51, 151. use linear probing method of collision resolution. print out the tables after...

Answer:

Sure! But you may have to wait a little since it will take a bit of time.

Read more

avagia at Yahoo! Answers Mark as irrelevant Undo

Best way to store arbitrary form data?

What are best practices for storing arbitrary form data? More inside... Let's say you have a bunch of online forms - I'm talking thousands here - and they could all have different fields that make them up. Is there any good way to store all this data...

Answer:

The database tables don't need to be associated with the forms directly--the form information can be...

Read more

zackola at Ask.Metafilter.Com Mark as irrelevant Undo

When designing a relational database schema, when should fields be mutable, versus when should they be in a separate table with immutable values?

For example, I'm modelling a Quora user and their credits. I already have a separate table for transactions - earning credits, and spending credits. I just need to store the Quora user and their credits. The simple solution is to make the table mutable...

Answer:

In database terms everything is mutable. You have data sets, and you can change the values, and your...

Read more

Lucian Nutiu at Quora Mark as irrelevant Undo

Related Q & A:

Just Added Q & A:

Find solution

For every problem there is a solution! Proved by Solucija.

  • Got an issue and looking for advice?

  • Ask Solucija to search every corner of the Web for help.

  • Get workable solutions and helpful tips in a moment.

Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.