Stack Overflow
Stack Overflow

Questions tagged [schema-design]

Concerned with design of properties and their hierarchy to represent an entity in a specific format. It can be JSON Schema, XML Schema, SQL Schema etc. Usually used to discuss database schemas.

142 questions
0
votes
2 answers

Data warehouse design - Multiple lookup values

Looking for inputs on a data warehouse schema design. Here is the scenario: I have an Action Table and User Table that is currently joined based on UserId to get the details about the user who did an action. Action Table: UserId Action 123…
WhatsUp
  • 73
  • 1
  • 7
0
votes
1 answer

MySql database schema referencing problem

I have the following tables; which will be holding information about various types of articles. I need some help with coming up with a proper schema for this. Tables are: CREATE TABLE IF NOT EXISTS `math_articles` ( `id` int(11) NOT NULL…
mkk700
  • 83
  • 3
  • 8
0
votes
0 answers

Create dynamic query with multiple joins in HDFS

My use case is that I want to create a reporting tool with around 200 tables each having millions of row and 100s of columns. There will be multiple joins here between the tables to finally create a report. The user will have multiple fields to…
Aditya
  • 79
  • 1
  • 8
0
votes
0 answers

MySQL schema advice for an interactive table with filters?

I'm trying to build an interactive table that shows data about people's shopping habits, with filters on the LHS that dynamically change the shown data. When no filters are checked, all data is shown. Thus in a default state, the table might look…
Bob Risky
  • 805
  • 1
  • 9
  • 22
0
votes
2 answers

HBase schema design correct?

I would like to ask you if the current schema design on a HBase table is correct for the following scenario: I receive 10 million events per day each having a unix epoch timestamp and an id. I will have to group by day, so that I can easily scan for…
Matthias Mueller
  • 102
  • 2
  • 12
0
votes
1 answer

How to associate one table with two tables

I have a users and apps tables in my application. The relationship between them is one-to-many. An app belongs to a user and a user has many apps. I want to add a invites tables too. which a has a token stored in it. When a user creates an…
Sina
  • 1,092
  • 1
  • 9
  • 19
0
votes
1 answer

best method Implements followers with meteor/mongodb

I'm doing an app where users can follow topics. What is the best schema for implement with mongodb and meteor? I thought to 2 solutions: FIRST With one collection: Schemas.Follow = new SimpleSchema({ userId: { type: String } topicId: { type: String…
Luca Romagnoli
  • 12,145
  • 30
  • 95
  • 157
0
votes
2 answers

Appropriate way to structure a database table? (empty columns vs. multiple tables)

Let's say we have a object called a Widget, for which we can construct a database table. Now, let's say we have two sets of additional detail to describe widgets. Each set of data is available at a separate time. So, let's say our widgets have three…
Dolph
  • 49,714
  • 13
  • 63
  • 88
0
votes
1 answer

BOM Changes in SQLite

Let me start out by saying that I am an engineer and not a programmer, so there are many things I am still trying to learn about databases. Anyway, I am trying to create a simple database application with Python and SQLite for managing an…
HyGear
  • 31
  • 4
0
votes
1 answer

Schema design : Order and Address

These are the stripped down version of the schema (all of the tables are in MySql) that I am using for maintaining custom orders. Order [Id, Shipping_AddressId, Receiving_AddressId] Address [Id, Contact, Line1, City] The order has references to the…
TJ-
  • 14,085
  • 12
  • 59
  • 90
0
votes
0 answers

Star Schema. One to many cardinality

I am building the data warehouse based on the star schema and I've got difficulties with one issue as follows: I have a dimension "Manufacturer" that can have several brands in his production line. And of course one brand belongs just to one…
user2729861
  • 5
  • 4
0
votes
3 answers

Can a binary tree or tree be always represented in a Database as 1 table and self-referencing?

I didn't feel this rule before, but it seems that a binary tree or any tree (each node can have many children but children cannot point back to any parent), then this data structure can be represented as 1 table in a database, with each row having…
nonopolarity
  • 146,324
  • 131
  • 460
  • 740
0
votes
1 answer

Schema design simple address book Hbase/Cassandra

I'm trying to model a simple address book schema that I will use for HBase/Cassandra. The scenario: A user can create his contacts. A contact may have many phones, addresses or emails. A user can create groups to organize his contacts (a group can…
Moody
  • 851
  • 2
  • 9
  • 23
0
votes
1 answer

Better ways to model this simple schema design (MongoDB)?

I have the following case: A user can add contacts (who are other users) on the website. Optionally, a user may also organize his contacts in groups. A user can have many emails, addresses and phone numbers. I thought of the following schema design…
Moody
  • 851
  • 2
  • 9
  • 23
0
votes
1 answer

SQL embedded document equivalent

I'm starting to use SQL after only ever using mongodb. As such, I'm having trouble mapping some practices over to the SQL world. Primarily, I'm not sure how embedded documents in mongodb map to SQL. For example, in mongodb, if I wanted to model a…
jtmarmon
  • 5,727
  • 7
  • 28
  • 45
1 2 3
…
9 10