Questions tagged [database-development]

The tag has no usage guidance.

Filter by
Sorted by
Tagged with
-1
votes
1answer
99 views

As a client; how to present database needs to perspective designers?

[I am preparing to solicit proposals for database/project management software design. I know that the quality of the final product will depend on how clearly and completely I can organize and explain ...
0
votes
0answers
34 views

What is best approach to designing a local-to-cloud cloud-to-local Infrastructure?

I plan to have a cloud web application(CWA) and several local web application(LWA), let's assume 3 LWAs and 1 CWA. CWA === LWA. This web application would consist of a database server, file storage ...
6
votes
2answers
211 views

How do services distribute their servers around the globe while maintaining their whole dataset intact?

I've always been curious on how services such as google/youtube have multiple datacenters across the globe to serve requests faster to users while keeping their whole dataset structure intact. There ...
0
votes
0answers
41 views

NoSQL Database Schema w/ Very Flexible Hierarchy

Recently I have been working with a NoSQL database (Firestore to be exact) to be used for my Web App where we essentially allow our users to create 'trees' of some sort. What this means is that you ...
0
votes
2answers
131 views

When placing an order in a shop, should a snapshop be taken of the products in an order also?

...to prevent messing up with data updates, such as prices, titles, of the products that are placed in an order. Namely, a customer buys 3 items: for $5, $10 and $33 and pays for them. All is well. ...
0
votes
3answers
172 views

Proper development workflow for fullstack app with multiple developers?

Say that I am developing a web application that has the following structure: An SPA web frontend (angular in my case) Postgresql database with: A bunch of initial data in CSV's and JSON's that need ...
0
votes
2answers
167 views

What's the best way to save/track change requests on multiple objects in a database?

I have a schema containing contracts, sub-contracts, services offered by each of those and sub-services. I also have a application that allows to extend the duration of the contract and to modify ...
0
votes
1answer
1k views

ER Diagram in Barker Notation

I engineered an ERD diagram using Barker's notation. The problem was to make a database for system of water pipes where one node is connected to another using a section (pipe), each node can have ...
47
votes
8answers
10k views

Is domain driven design an anti-SQL pattern?

I am diving in the domain driven design (DDD) and while I go more deeply in it there are some things that I don't get. As I understand it, a main point is to split the Domain Logic (Business Logic) ...
-1
votes
1answer
52 views

How to ease the pain of lack of diffs when using database migrations?

The pain that I've often felt when creating database migration files, is best described in this Speakerdeck: Sane Database Change Management with Sqitch. Paste entire function to new "up" ...
0
votes
2answers
78 views

Will introducing a long standing Dev branch create unnecessary maintenance overhead?

I am seeing bad practices occurring in our version control where my colleagues are creating their own versioning system with stored procedures so that they can compare results before/after changes and ...
1
vote
1answer
325 views

Best way to model pricelist per customer for products in webshop

I am making a b2b-webshop system that will have multiple customers. Each customer will have a separate active pricelist which contains the products that they can buy and the prices that applies for ...
-1
votes
2answers
61 views

The challenges of removing/modifying entries from a database located in persistent storage

I'm implementing my own simple database with disk storage, and I'm not sure how to go about modifying and deleting entries. The problem is that as you delete a record from arbitrary position within ...
1
vote
1answer
73 views

How to go about accessing data on a server that has large downtime periods

Where I work, there is an Oracle data warehouse that is managed by another group that contains some pretty critical information for the company to run smoothly. The issue is that they (apparently, ...
3
votes
2answers
108 views

API-oriented databases: is it maintained by the back or API team?

From what I understand, no-SQL databases differ from SQL databases because they allow the developpers to designe the tables to fit the usage, rather than fitting the model. Which means most of the ...
0
votes
2answers
387 views

Optimistic locking with business constraints [closed]

Consider this simple example: Tables (in a restaurant) can be booked for a period. Business constraint: No two table bookings for the same table may overlap in time. How might one prevent business ...
0
votes
3answers
210 views

How to associate one type with another in multiple contexts?

An application has types Game (and other business units) and Message. (Message is not a simple class with text, but a composition of a variable number of blocks like texts, images, and videos). ...
1
vote
1answer
29 views

Imagers for a product in Internet Store — one to many or many to many?

I'm creating a database schema for a internet store and I wonder how to better create the tables "images" and "products". A simpler way will be to have it as one_to_many, that is: images(....., ...
-7
votes
1answer
283 views

Where should I store data related to UI/presentation?

Say, I have a table Categories. On a page I have a header and for each category the colour of a header varies. A colour is of the presentation level and I've heard that what's related to the UI/...
0
votes
2answers
54 views

A single field or 2 fields for “description” and “content” of Article?

Say, I want to create a db schema for a blog. So far I've used 2 separate fields for "description" and "content" of Article. But I've seen a lot that usually only a single is used for both. The "...
0
votes
1answer
425 views

How should I go about creating a db schema for “news subscription” and connecting it with “users”?

On my website there's a new subscription form. And users can also register and subscribe to news after. When an anonymous user subscribes to the news, how should I better handle that? Should I create ...
2
votes
2answers
86 views

unique varchar(NNN) with an index in database and its overhead

I've seen the url like this domain.com/some-article-title-which-can-be-very-long many times. There's no ID embedded in it. Therefore, in a db it must be defined as "unique article_url varchar(NNN)" ...
31
votes
8answers
26k views

What's a universal way to store a geographical address/location in a database? [closed]

What's a correct format of a geographical address/location which is a good fit for any address on the Earth? At the moment I have: country city street number text data (for simplicity) zip lat/lng ...
0
votes
1answer
730 views

Shared configs between backend and frontend

I have some data (list of parameters) that should be shared across the backend and the frontend. The changes are really infrequent, and changes usually mean a redeploy. Currently, it is stored in the ...
0
votes
1answer
46 views

design implementation for a postgres database in a not connected environment

I have several postgres DB, on distant sites, two in China, 1 in India , one in Korea, one in Germany, one in France and one in Mexico. All dbs, regardless of their site, have one table that is part ...
1
vote
2answers
922 views

Best way to sync data from one database to another

Let's say I have my web shop and database have multiple tables like Products, Product prices and similar. I'm selling my software solution to my affiliate partner. He gets its database, it window ...
1
vote
2answers
117 views

How to create database, tables and stored procedures during installation of application

Our company code base still has some code that will create the database, tables, stored procedures and the like.Coding the SQL stored procedures line by line in Java, in string format is a real pain. ...
3
votes
4answers
1k views

Database modeling, software development, and version control

Here is the framework We have an SQL database in which our database model lives in. On the other side, there is a bunch of code using and filling that database. Here is what we want We want to put ...
0
votes
3answers
103 views

using two database in .net

I am trying to implement the use of two database in my application, sqlite and mysql. Currently i added references to both database connection library, and duplicate all first checking which database ...
2
votes
1answer
528 views

How to show if a database is ACID or BASE?

I was wondering if there are general guides or standards which can be followed when trying to show if your own database implementation is ACID or BASE compliant? For example are there any specific ...
0
votes
2answers
78 views

Should we sanitise and clean data or only display it in the expected format?

So my problem is, I have users entering their data(names, address) in a mixed form- some with first letter in caps and some without, some inserting more than necessary spaces and so forth. Also, ...
1
vote
0answers
465 views

Best way to handle multiple environment specific sql scripts in source control

I am maintaining an app that uses a lot of sql server 2008r2 stored procs, views etc. The problem that I have is that certain stored procedures/views have code that is specific to the environment: ...
3
votes
1answer
1k views

How is one or more aggregate function implemented in most SQL engines?

In the book Database Fundamentals, Silberschatz. It is explained that aggregate functions can be calculated on the march. This make sense. What it means is that for calculating the maximun, average ...
3
votes
1answer
647 views

Managing a development database in a group project

I'm working for a small webdevelopment company and we want to set up development environments. We'll be using the Laravel framework in combination with Homestead. Now, Homestead has its own database ...
4
votes
1answer
326 views

What's the advantage of storing database transaction changes in the log as well as data pages?

I know the basics of why a database uses a transaction log - fulfilling ACID properties, ability to rollback/restore, etc. The basic algorithm that I see for a transaction is as follows: ...
5
votes
3answers
553 views

Is it a good practice to have a pre-filled embedded database for development?

I'm currently working on a project which only uses its database for data storage. This means there are no triggers or stored procedure in it, just tables and data to put into it. In this scenario I'm ...
3
votes
1answer
943 views

Good approach/Strategy to keep integration test database in-sync with production db?

I'm building a web application in Spring. I'm using an in-memory (embedded) database for my integration test - HSQL My production database is MySQL. When i setup my integration tests a while back i ...
1
vote
1answer
112 views

Creating a specific table for shared columns among other tables (models)?

I'm creating a webapp that has a variety of models: Product, Category, ProductOption, etc. All of these models have a set of shared attributes: name, description, image, etc. There are two options I ...
3
votes
2answers
312 views

Is there any point in preventing developers from having a local copy of the database in their machine?

Is there any point to having a dedicated development database server(s) that all developers can use, i.e. they don't have a local copy of the db in their machines. Quite clearly, this will slow down ...
3
votes
0answers
763 views

how to import large amounts of data without locking sqlite database

Background Information I have a web app that provides the user with the usual CRUD functionality for "widgets" let's say. But I also have give them the option of creating widgets in bulk via ...
4
votes
2answers
360 views

How does I/O work for large graph databases?

I should preface this by saying that I'm mostly a front end web developer, trained as a musician, but over the past few years I've been getting more and more into computer science. So one idea I have ...
1
vote
3answers
768 views

Select custom output formats from database with SQL

I am planning to make a simple rest service application, and I am currently deciding the architecture. I have decided that I want to write the middle layer in multiple languages, so that it is easy to ...
3
votes
3answers
3k views

Tracking correct order details in commerce database when modifying 'products'

I am implementing an ecommerce database. This is slightly different than most as the 'products' that are for sale are for services provided. For example a user (vendor) of the system may define a ...
5
votes
2answers
1k views

Deploying Database Schema changes in a patching process [duplicate]

I am facing a conceptual development methodology problem that I was hoping you could help me with. Firstly, a little bit of background. Background The project I am developing is a niche application ...
1
vote
1answer
1k views

How to store Status for Reservation table

I have a reservation table (a user fills out a form to request a reservation). It has two parts that need to be confirmed. isReservationAccepted (decline,accept,waiting) and hasReservationBeenSent (...
0
votes
1answer
926 views

How does this normalized example work?

I had the following DB schema: Customer Car Rental ------- ---- ------ Name Name Car_ID ID ID Customer_ID Date This is said to be non normalized ...
0
votes
1answer
272 views

How should I evaluate the Database Solution for Large Data Application

Background I have been tasked to write an application that will be a combination of document and inventory management in VB.net which will be used to store document images in TIFF, PDF, XPS, TXT, DOC, ...
1
vote
1answer
857 views

What's the best approach to building a db schema for profile, but to track changes?

I'm working on a site where companies can create a profile then add locations for each profile. Those first two tables are simple enough. But any changes to their profiles or locations have to go ...
0
votes
2answers
2k views

SQL Server: When to use SSIS vs T-SQL for ETL Tasks [closed]

When should I use one versus the other? For instance, let's say I have 20 comma delimited, denormalized text files and I want to transform the data and load it into normalized SQL Server tables.
12
votes
5answers
1k views

What methods are available to show colleagues the advantages of a database+application solution over Excel?

I work in a company where there are Excel spreadsheets everywhere. As my colleagues are non-programmers, I'm sure they haven't contemplated that there might be a better/easier/more productive way of ...