data-modeling Questions
4
Solved
Consider that there is a bunch of tables which link to "countries" or "currencies" tables.
For making data easier to read I'd like make CHAR field with country code (eg US, GB, AU) and currency co...
Miletus asked 14/9, 2009 at 0:26
2
Solved
I am modelling university data using an OWL ontology with relevant classes, object properties, etc. I have the university data lying in a simple text file (say CSV). I want to create ontologies usi...
Avaria asked 30/10, 2012 at 21:30
7
Solved
What's the longest possible worldwide phone number I should consider in SQL varchar(length) for phone.
considerations:
+ for country code
() for area code
x + 6 numbers for Extension extension (...
Occiput asked 6/4, 2009 at 23:4
17
Solved
It is crucial for my application to be able to select multiple documents at random from a collection in firebase.
Since there is no native function built in to Firebase (that I know of) to achieve...
Tessin asked 17/10, 2017 at 20:48
2
Solved
I have an endpoint to create an address and one to update it. Describing this in an OpenAPI spec I'd like to use a component for the address so that I don't have to specify the address twice. Now t...
Wince asked 1/3, 2020 at 6:38
6
Solved
I am working on a report in Power BI. One of the tables in my data model collects sensor data. It has the following columns:
Serial (int) i.e. 123456789
Timestamp (datetime) i.e. 12/20/2016 12:04...
Arrowy asked 22/12, 2016 at 19:30
1
Solved
I'm trying to model my data in Typescript in the following manner. Main focus is the type MessageHandler that maps the type in a message with a callback that accepts that message. I followed the ha...
Honey asked 6/5, 2023 at 10:12
1
Solved
I have been tasked to come up with a schema to store our application logs using Cassandra. I am quite new to Cassandra but from what I have read and learned so far, it could be the best approach fo...
Norikonorina asked 4/1, 2023 at 19:24
5
Our database is designed based on EAV (Entity-Attribute-Value) model. Those who have worked with EAV models know all the crap that comes with for the purpose of flexibility.
I asked my client abou...
Nadabas asked 29/10, 2010 at 5:14
1
Solved
is there a way to make these warnings in DBT errors?
[WARNING]: Did not find matching node for patch with name 'my_model' in the 'models' section of file 'models/path/to/model.yml'
We check errors...
Glauce asked 9/8, 2022 at 13:10
3
Solved
I'm looking for a proper way to structure Firestore database to handle multiple version histories of documents inside a single collection.
For example: I have a collection named offers which have...
Mooned asked 23/11, 2018 at 7:38
3
I have a problem understanding relations and data-modeling in Prisma. I have an "easy" example about two users who can participate in a tennis game. So i have:
Model User {
id Int @id
...
Crockery asked 9/8, 2020 at 21:57
8
Solved
We develop a commercial application. Our customers are asking for custom fields support. For instance, they want to add a field to the Customer form.
What are the known design patterns to store the...
Nw asked 14/7, 2009 at 17:18
2
Solved
As I understand it when creating a supervised learning model, our model may have high bias if we are making very simple assumptions (for example if our function is linear) which cause the alg...
Komara asked 22/8, 2015 at 21:54
4
Is there some way to model type hierarchies in Neo4j? If for example I want to build a class hierarchy of cars, I might have a base type of "Car" and then have sub classes that extend that, like "S...
Needlefish asked 21/7, 2014 at 19:24
1
Solved
We are building a Data Vault (2.0) model to capture SalesForce data. Like many other sources, the records in the source are soft deleted. While we are sourcing data to the Data Model, we do not wan...
Cosmotron asked 12/7, 2021 at 8:6
7
Let's say we have a root collection named 'todos'.
Every document in this collection has:
title: String
subcollection named todo_items
Every document in the subcollection todo_items has
titl...
Conklin asked 6/10, 2017 at 17:46
8
Solved
I am implementing a tagging system on my website similar to one stackoverflow uses, my question is - what is the most effective way to store tags so that they may be searched and filtered?
My idea...
Knawel asked 2/12, 2008 at 14:51
5
Solved
i am creating a database table that is going to store menu links that will ultimately show up on a web page.
My issue is that i want to control the order of the menu items. I could have a field ca...
Falcongentle asked 6/11, 2010 at 20:39
1
I have to present some complex queries and PL/SQL codes to people who don't know anything about my project. I need to explain how tables are connected, how conditions are affecting the outcom...
Allargando asked 6/2, 2021 at 10:49
1
Solved
I have a project which requires me to create a UML Class Diagram. What I have from the previous tasks in the same project is an ERD using UML notation. Also worth noting, this project is rela...
Bradney asked 30/1, 2021 at 6:40
1
Solved
Software engineer from the C world breaking into the cloud space. I am trying to understand if I can use DynamoDB for all my scenario needs, if I shouldn't use it at all or if I should use DynamoDB...
Tithe asked 5/1, 2021 at 20:23
4
I am sure this topic has been researched before, I am not sure what it is called or what techniques I should also look into, hence why I am here. I am running this mainly in Python and Pandas but i...
Wavellite asked 2/10, 2020 at 15:36
7
Solved
Reading several papers and documents on internet, I found many contradictory information about the Cassandra data model. There are many which identify it as a column oriented database, other as a r...
Humus asked 22/10, 2012 at 11:12
15
Solved
I haven't been able to fully grasp the differences. Can you describe both concepts and use real world examples?
Rotorua asked 18/4, 2009 at 5:4
1 Next >
© 2022 - 2025 — McMap. All rights reserved.