Tagged Questions
2
votes
3answers
103 views
Referencing countries via Foreign Key Constraint
To make things simple to explain: I've got two tables: Table1 and Countries.
The Countries table contains a nice flag and some information, such as DisplayName, the ISO3166 ALPHA3 code and the phone ...
0
votes
2answers
142 views
Create a database for database tables
I'm working on a project where I have to give users the ability to build their own tables,
each user can create more than one table.
(the type of all data is string).
The user can create a table and ...
1
vote
1answer
108 views
Multi-user Configuration Settings design
I am designing a flexible and extensible way to store configuration settings for users.
Database Table Design:
╔═════════════════════════════╗
║ ConfigurationItemDefinition ║
...
0
votes
1answer
88 views
What is a good design for a container, assignment and items
------------- 1 * -------------- * 1 --------
| Container |--------| Assignment |-----------| User |
------------- -------------- --------
^ ...
2
votes
3answers
155 views
Using a database for each module in a system [duplicate]
I was reading this question:
I was trying to standardize and modularize some functions (Email
Management Module, CMS Module & etc) by implementing a 3-tier
architecture concept where each ...
1
vote
1answer
55 views
NoSQL (Azure Table Storage) RowKey design for ordered data
I store large quantities of GPS data in storage tables. Each partition can reach up to 1 million entities. Each GPS entity that is inserted into the table is actually sequential to the previous data ...
1
vote
1answer
45 views
Azure Storage Table design with multiple query points
I have the following Azure Storage Table.
PositionData table:
PartitionKey: ClientID + VehicleID
RowKey: GUID
Properties: ClientID, VehicleID, DriverID, Date, GPSPosition
Each vehicle will log ...
2
votes
2answers
824 views
When should we use weak entities when modelling a database?
This is basically a question about what are weak entities? When should we use them? How should they be modeled?
What is the main difference between normal entities and weak entities? Does weak ...
2
votes
2answers
127 views
how to model this relationship ? in ERD
I have three entities :
Technician
Vehicle
Repair
The question is how to model this in ERD? Knowing that a technician can repair multiple cars, and the same car can be repaired by one and only one ...
3
votes
2answers
109 views
Best approach for saving highlighted areas on geographical map
I am designing an application that allow users to highlight areas of a geographical map using a tool that is like brush or a pen. The tool basically draw a circle with a single click and continue ...
0
votes
2answers
244 views
The limit of Int32 for Identity Column
This is just a consideration for a site am creating and for other big sites out there.
I am using Identity Column to store the ID of some of my tables and I have classes whose Id are decorated with ...
0
votes
2answers
275 views
Does there exist a design-pattern for this problem?
I have a big database of data which we can consider today's system. The data has a web front-end which allows my users to update the data. Let's call this "original solution"
When new users come in ...
23
votes
10answers
1k views
How do you organize highly customized software?
I'm working on a large software project which is highly customized for various customers arround the world. This means that we have maybe 80% code which is common between the various customers, but ...
0
votes
2answers
378 views
Is it reasonable to use POCO's that inherit from DTO's?
I'm designing a tiered .NET application, and I want to use the Code First approach. I'm new to this, so I'm struggling to envision how it ought to be designed. Would the following be a reasonable ...
2
votes
3answers
228 views
Should each app have its own database, or should small apps be merged into one? [duplicate]
Possible Duplicate:
Should I use one database per application or share a single database amongst multiple applications
We have a bunch of small to medium sized apps, each of which has its ...
