0
votes
1answer
29 views
How can I handle huge amount of data comming from web request
I am newbie on Data handling and optimize network data fetching . So Can any one suggest me any good options to handle in ruby on rails with mysql to handle huge amount of byte data coming from a web ...
0
votes
0answers
21 views
Dynamic form from a database but submitting?
I am considering to develop a dynamic form so all the fields and validation type can be stored on the database. For example I could do table design something like this:
Field ID | Field title | ...
0
votes
1answer
29 views
Database Structure involving dynamic fields
Im working on a project. Its mostly for learning purposes, i find actually trying a complicated project is the best way to learn a language after grasping the basics. Database design is not a strong ...
-2
votes
2answers
43 views
Use multiple records for one record [duplicate]
Lets say I have a database with the following tables:
Table movie containing:
movie1
movie2
Table actors containing:
actor1
actor2
actor3
Lets say actor2 appears in both movies movie1 and ...
0
votes
1answer
12 views
Checking Database for Active Billing Services
I am putting together a small script that will query our billing database and report any customer accounts that have free services active (provided complimentary) but no longer have paid services on ...
1
vote
1answer
28 views
Database Design: Many tables VS One “long” table _ Performance-Wise?
Just from a performance point of view:
Store with 10s of 1000s of items with so many categories and attributes. Which is better to store all attributes in one table. Or categorize them in different ...
0
votes
0answers
35 views
what database design is best for a chat in a website? [on hold]
I'm trying to build a database design for a chat.
My database is in MySQL.
First i wanted to create two tables :
CONVERSATION : id
MESSAGES : id, USER_id ,CONVERSATION_id, date, message
With this ...
0
votes
1answer
24 views
Database design: Best Way to store heterogeneous subtypes of a parent class?
Website has products with different categories
(Phones, tablets, Washing machines, ... etc)
Each product will have diff. prices depending on the store (If the user views Galaxy S4 16GB it will show ...
1
vote
1answer
31 views
Proper way to create ranking table?
I am creating tennis site which of course needs to display results. Currently to get ranking I need to sum scores for each player and then order them, even if I only need single player results. I ...
0
votes
1answer
49 views
Database Schema - Create one large table or many?
I'm trying to decide on the best way to store entities which have very similar properties. The main difference is that each entity references other entities. I was going to setup the database as:
...
0
votes
1answer
27 views
Fetch rows with primary keys within range
Is it possible to efficiently do range scans on a big table(may be a billion rows) under heavy load to fetch all rows with primary keys within range. The primary key is of BIGINT type. Rows are very ...
0
votes
0answers
20 views
How to store dynamically built lists in database in a natural way so that they are just ready for reads?
For a social network site, I need to store dynamic lists for each entity(& millions
of such entities) which are:
frequently appended to
frequently read
sometimes reduced
...
0
votes
0answers
30 views
Database design for printshop
I need to redesign a database for a print webshop.
Currently I have 3 levels for indexing the products
- tblProducts (contains main product)
- tblProductSubs (contains the different paper weights and ...
0
votes
4answers
38 views
MySQL table with a varchar column as foreign key
I am trying to create a table with a varchar column as foreign key but MySql gives me an error while creating the table. My query is like this:
CREATE TABLE network_classes (
id TINYINT(1) ...
0
votes
0answers
23 views
Products-SalesChannels Database design
I am working on integration between internal database with products and online sales channels using web services.
I have the following database design problem:
There are two tables(objects):
Product
...
