Questions tagged [schema]
The schema tag has no summary.
87 questions
2
votes
2
answers
197
views
Proving two XML schema's are functionally equivalent
I work for a standards organization that publishes an exchange standard using XSD files.
These XSD files are being generated from a model with a tool, and now we want to change to a new tool.
Because ...
- 154
1
vote
3
answers
931
views
How do you test whether schema changes will break services?
I maintain a relational database of sorts, and occasionally a feature request requires a schema change (eg. add a new column, etc...).
However, a number of "services" consume this data. It's ...
- 343
1
vote
1
answer
102
views
Efficient Schema For Pairing Styling Metadata with Text Fields in JSON Messages
I am trying to design a schema for pairing styling data with text. However, I need it to pair styling metadata to only one part of a larger string.
For example:
"This is a test string"
I ...
- 143
0
votes
1
answer
480
views
Store UUID Reference vs. storing string in Mongodb
I am trying to store user preference for notifications.
One way to do is store types of notification in separate collection and store UUID of that notification type in user table.
e.g. notification-...
-2
votes
2
answers
233
views
Avoid redundant field using JSON type in MySQL [closed]
I have experienc with designing relational dbs but first time attempting to store JSON in a mysql table. I am using mysql 5.7.8 which has the ability to store json data type as a column.
When I create ...
- 139
-4
votes
1
answer
55
views
Create the database using schema migration for the first time? [closed]
what is the best practice when creating a database schema for the first time? Do I need to write schema migrations, or create it from the DBMS tools?
- 169
0
votes
2
answers
81
views
In a database schema, should frequently changed information be isolated from static information?
A contrived example:
I have many Thimbles, identified in real-life by their color, that I lend out to friends. I want to know only the most recent friend that is wearing my Thimble. My friends covet ...
- 41
0
votes
1
answer
294
views
Where should schemas be maintained?
When working with big architecture, I experienced high costs when it comes to changes of a data model that is used in multiple applications, servers, databases.
So I thought about designing a server ...
- 61
0
votes
1
answer
72
views
What is the schema to specify relationships in a flat-document structure?
I have a question about the best database schema to do this. So, we want our database schema to carry out some generic operation <> involving two units of data, x1 and x2 (e.g. a1).
// CURRENT ...
- 587
1
vote
2
answers
195
views
Appropriate database schema
I'm currently collecting the data about flat prices. I have size, price, location, price per m2 and date of retrieving the data about flat(sample date). I'm plannig create MySQL database filled with ...
- 121
-2
votes
1
answer
763
views
Converting a table to an ORM schema
I'm trying to convert this table into an ORM schema:
The solution given by the book is this one:
It connects all the paramether to the Member one. This is my solution, which I think it's less ...
2
votes
2
answers
5k
views
Bidirectional sync between two databases with differing schemas
I'm embarking upon a project where the goal is to create a bidirectional sync mechanism between two database systems with differing schemas. One is a custom CRM app build on MongoDB, the other is ...
- 357
1
vote
2
answers
174
views
Which REST API url structure should I take?
I am wondering which API url scheme should I use.
I am designing multi-site project so that the URL can looks like:
[GET] /website/1
[GET] /website/1/category
[GET] /website/1/product
Which is life ...
3
votes
1
answer
637
views
Is it recommended to use schemas on non-relational databases?
I'm trying to figure out if the use of schemas on non-relational schemaless databases like MongoDB is a recommended practice or a bad practice to be avoided.
I am doing research work and am looking ...
- 51
1
vote
8
answers
1k
views
Is there a way to prevent developers leaking data while they are developing?
I am working with a startup company for a while now. They have been affected by some reckless developers in the past. One area they want a real and immediate improvement is when they assign a task to ...
- 127