Questions tagged [application-design]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
1
vote
1answer
47 views

Omiting schema names to manage access to SQL Server databases more flexibly [closed]

When applications hardcode a schema name, dbo.TABLE, it reduces the DBA's ability to migrate the data as needed. Is it safe and more flexible for applications to omit schema names? I know you will ...
0
votes
0answers
65 views

Building an Entity-Relationship Diagram for a Language Dictionary

I need advice on how to build entity-relationship diagram (ERD) for Language Dictionary. Since I did not build ERD before, I will try to explain and show the ultimate goal of this project below. ...
1
vote
1answer
32 views

How to handle removing ASP.NET users where their UserID is tied to rows that should be maintained even after a user is deleted?

I have a website that uses ASP.NET membership and so there are multiple aspnet_... tables in our database. We are creating a service for the users that allow them to essentially create laboratory ...
1
vote
0answers
33 views

Foreign keys pointing to “look-up” tables: Should we reference Id or Code values? [closed]

We are rewriting from a huge monolithic application to smaller application using rest. While the old application had one huge tables called REFERENCE tables with applicable values had all these ids ...
0
votes
1answer
63 views

Any way to represent simple AND/OR business logic in a database?

I'm designing an application to provide students access to modules once they have completed certain online courses. I have tables for: Students, Modules, Courses, and StudentCourseResults. Course ...
0
votes
1answer
40 views

Common practices to determine what database technology to use [closed]

Supposing I've started a new project that needs a database for persistence purposes. What are common practices to determine which database technology (MSSQL, MySQL, MongoDB, etc...) would best fit ...
0
votes
0answers
30 views

Set up table for relationship type with both users in a different visitor table

I am a newbie in database driven application, and I just started working on a web app for my brother and parents clinic to manage patient records. So for their clinic I have one table Visitor that ...
2
votes
1answer
42 views

DB design to avoid versioning inconsistencies between the application layer and the database layer

Usually there is a 1-1 mapping between an object in the application layer and a table in the database layer. This coupling leads to complexities whenever there is a database schema change and the ...
3
votes
2answers
187 views

What is the industry term for superset of “metrics” and “dimensions”? [closed]

If I want to refer to measures/metrics and dimensions with a single term, what would be a good industry-accepted expression? Metrics is used commonly in UIs as well such as Google Analytics or ...
2
votes
2answers
111 views

Insert/update data into relational database tables only after administrator approval - how to approach it?

I'm building a relational database that holds 21 tables, which is connected to my website application through PHP. The website has search functionality which allows users to search this database. ...
2
votes
2answers
394 views

SqlDataAdapter vs SqlDataReader for DBAs

Speaking to developers about the use of SqlDataAdapter vs SqlDataReader and reading this: https://stackoverflow.com/questions/1676753/sqldataadapter-vs-sqldatareader Yields little in the way of ...
0
votes
1answer
53 views

SOA and Oracle cascade data between two pdb

I am Java developer and need help for design and manage database . Please view this picture : I have two service named : 1) Authentication Service (Register new user and login) 2) Customer service (...
0
votes
1answer
34 views

What sort of database setup is used for an App Store or Google Play Store? [closed]

I'm trying to build a desktop App Store, and it's just a small project for demonstration purposes, I'll be using java to create the application. In essence it's just a mock App Store that stores ...
2
votes
1answer
40 views

Using Text Fields As Booleans

We are developing a product system and I was curious to what industry standards were for many Boolean statements. In our system we have some, what you could call main, bit fields. E.G. isBackordered, ...
0
votes
1answer
22 views

Help with schema design [duplicate]

I am having trouble designing a schema in which there are two models an employee and projects. I am storing employees details in a table structure as: id | employee | report_to wherein employee ...
1
vote
1answer
62 views

MSAccess: creating a new row in a related table and linking it back to the “master” table

In a hypothetical 'cars' database, assume there's a model table and a make table: models modelID int model varchar make int makes makeID int make varchar Model's make column has a foreign ...
6
votes
1answer
559 views

Entity-relationship diagrams and application program functionalities

It seems that the core functionalities of an application program I'm working on are nothing but associative entities. Hence one-to-many relations sort of produce "metadata" that will only feed (one ...
-1
votes
1answer
87 views

When to create a new table and when to differentiate between table columns?

I am not too experienced in database best practices so I am wondering if anyone has some advice on whether to make a new database table or just differentiate between columns on an existing table. For ...
2
votes
2answers
81 views

Optimize architecture for SQL Server projects [closed]

I often find myself hacking together multiple .sql files for a project and calling them one after the other through Task Scheduler. Everything I know about SQL is self-taught, so I don't know anything ...
0
votes
1answer
717 views

Best way to design a database for a bakery store? [closed]

I am building an application that will be used as a Sales Management system for a bakery store. I have built the following tables: Products has a single row per product. This is a Master Data ...
1
vote
1answer
119 views

Permission for business logic layer & application

I'm very new to db development and currently working on my first production app. I learned that I would need a business logic layer (BLL) to authenticate and authorize users (for example John can only ...
1
vote
2answers
439 views

How to use a foreign key?

I'm creating the following table: CREATE TABLE fund_identifier ( id BIGSERIAL PRIMARY KEY NOT NULL, identifier TEXT NOT NULL ); CREATE UNIQUE INDEX IF NOT EXISTS fund_identifier_pkey ON ...
1
vote
1answer
84 views

Database Designer's Block

Aloha DBA's, I've got major DB Designers-block and I can't wrap my head around the proper way to design the database to meet my web application requirements. This is strictly a DB design question and ...
1
vote
1answer
98 views

Avoiding foreign key repetition on related tables in a relational DB

I have a simple DB schema describing certain objects that belong to a historical time period of a country and (optionally) a subdivision of that country at that period. The contrived UML class diagram ...
1
vote
1answer
25 views

How should I design a re-usable content like table?

So I've got a database that holds articles, recipes, and comments in seperate tables, and I'm wanting to allow users to be able to like each of these content pieces (articles, recipes, comments). I'm ...
3
votes
2answers
2k views

Can I use a single stored procedure to operate on different schemas based on the executing user

I have thousands of schemas with same set of tables, Each user has a default schema. But I dont want to create copies of a single stored procedure in every schema. Can a single stored procedure access ...
1
vote
2answers
84 views

Validate application to access the database

I need some help for my issue I will explain. We have a delphi application named for instance App.exe. We use oracle database with our application. I would like to allow just my App.exe (my valid ...
0
votes
1answer
436 views

Can we use the multiple databases system concept in a single web application?

Am building a simple web based expert application.I have created two databases in the back-end,One database holds user data and the other holds user activity data.Hence it is accessed by a single web ...
1
vote
3answers
123 views

Relational tables with same content, custom solution

So let`s say that I am building an app where I can add comments for FOO. Normally I would have something like this: Table foo and table foo_comments, where foo_comments contains id, foo_id and other ...
0
votes
1answer
275 views

Mongodb database design

I'm planning to implement this schema in Mongodb, I have been doing some readings about schema design, and the notion was whenever you structure your data like a relational database you must be doing ...
1
vote
1answer
654 views

Keep files in Mongo as part of the data

I want to create a news app that works in the following way: The site will contain articles, and each article with have multiple versions. Each version is a docx file. The article itself does not ...
2
votes
0answers
266 views

Design university schedule system

I'm not sure if this is the right place to ask for tips and improvements in a database design but I don't know about another one. I want to design a simple University system. Below I'll have included ...
2
votes
0answers
49 views

insert/update from web server or database

I have a data-model on the front-end that I want to insert/update in the database which of the following approaches (or neither!) is considered best practice: # in webserver some_model = {json} ...
5
votes
2answers
517 views

Efficient Database schema for multi-lingual content?

Assume I have a table for blog posts, posts, and schema as id author title content and each post can belonged to some categories id name descrtiption So a blog post can belong to multiple ...
-1
votes
1answer
1k views

Database design for timetable in mysql

I have to make a web application in java. The web application is like a online appointment book. Everyday of the week has 1 column with times from 9.00am to 10.00pm (only full hours). I already ...
4
votes
2answers
443 views

How to prevent duplicates while storing result from different application

For my case multiple application uses data from db based on date, this data is date specific so if for a date data exist application should just read it otherwise it should fetch information from ...
0
votes
1answer
753 views

How would you design a table for approval system between User and Sports Club

I am currently learning database modelling and struggling to model the following requirement. I have a user and sports_club table. User can only join a sports_club if three existing users of the club ...
1
vote
0answers
32 views

Storing resource information efficiently

I'm looking for any advice on how to efficiently store some resourcing data for our app. For each project in our system we need to store the resources required and this comes in the following form: ...
1
vote
1answer
45 views

design database with 2 simillar tables

I have a database which has product_sell and product_buy tables, these two tables are different in a few fields and each one has own comment table product_sell >---< product_sell_cmt ...
1
vote
1answer
74 views

Should my application utilize database credentials for user login?

I'm working on an application that has an ASP front end and a SQL Server database. The way credential management is currently performed is there is a custom built User Table in the database that ...
0
votes
2answers
241 views

Heavy load causing MySQL Slave threads to remain “locked” or “Sending data” indefinitely

We have been rapidly adding MySQL servers as slaves to our master database server to help alleviate a massive increase in search (read-only) traffic to our web service. This past week, I was tasked ...
1
vote
1answer
50 views

Is it possible to execute queries in random order?

I have a list of INSERTs, UPDATEs and DELETEs queries. My problem is that I always receive them in the wrong order (random), and I cannot know their original order. Are there techniques to group/...
0
votes
1answer
208 views

when to put a business rule in the business application layer or into a database constraint

I need you wisdom, I am debating with another person when is it recommended to put the code of a business rule into a database constraints or inside of the application business layer? There is a ...
0
votes
1answer
3k views

Database structure for users, events and event lists

I am creating a web service for managing events. The service will have users, who are listed in one database, called Users. It will also have events, which are listed in another database, called ...
0
votes
1answer
131 views

Comma List vs Multiple Records

I am currently building out an application that will contain many users, two roles and two groups. Logically we want users to be able to be administrators of other users within the two groups. User ...
0
votes
1answer
482 views

Division Email Template DB Design [closed]

First question for me on the DBA SA site! This is for an Java email notification app using MySQL for backend. I have a small number of groups in our organization, [Marketing, Commerce, ...
0
votes
0answers
67 views

Tables with same schema in DB for different sources. Bad pattern?

The main purpose of the system being developed is to collect data from different sources, process and standardize it, and then add it to the DB. After information from all sources is collected it ...
0
votes
0answers
165 views

Database & Structure for SaaS reporting software

I'm building a SaaS application to allow users to upload data and perform reporting and analytics on it. The reporting and analytics would be quite simple like grouping and aggregating. This has ...
2
votes
2answers
446 views

Overhead of decomposing complex query into multiple simple queries?

What kind of overhead should I expect when replacing a single complex query with multiple simple queries? My goal is to improve the readability and portability of all SQL code so I will be favoring ...
0
votes
0answers
26 views

How to model mappings at various levels

I'm trying to design the database model for my application and I'm finding it difficult to design the mappings for user access to various entities stored in the database. If access was only ...