Questions tagged [database]

This tag is for general database questions; if you question is specific to SQL use that tag instead.

Filter by
Sorted by
Tagged with
-2
votes
1answer
46 views

Preuso/empty entity or only real entities + nulls?

I have a table "products" and a child one "product_modifications" Some products have "product_modifications": "colour", "size",, .... But not all. When a client orders a product, views pictures and ...
-2
votes
1answer
56 views

Designing a facial recognition systems database

First of all, I hope im in the right stack exchange. So I'm trying to build a facial recognition system, e.g. one that recognizes a face and compares it to a database of known faces. For the first ...
-2
votes
1answer
45 views

Connecting android app(android studio) to myphpadmin database(already on the server)

I have a website for admin and a mobile app for normal user. Both of them share a same database which is now on the cloud(The website for admin is already deployed with the database on the server). ...
-2
votes
2answers
53 views

database/orm model design for contacts

I am building a internal crm which has contacts which are just people with first name, last name, email, phone etc. Contacts can be one or more types e.t.c. job candidates, hiring managers, customers, ...
-2
votes
1answer
2k views

Databases - Difference between roll-back and roll-forward with example

Kinda new here and also learning new db concepts. I got little bit confused about terms: Roll-back and Roll-forward. I read definitions and thought I understand it. I found some little tasks about ...
-2
votes
1answer
61 views

Login Register Page for Anroid

I have a mysql database in server, storing user accounts information (username and password). I'm developing the Android login/ register page for an app. When the app is first loaded on client ...
-2
votes
1answer
76 views

Considering the testing software issues when designing software [closed]

When designing the software, must we consider how much this code could be testable? for example, if we used X technology/Class/Interface instead of Y, based on that X can be tested more easily than Y, ...
-2
votes
1answer
3k views

Connecting a native iOS app to backend and database

I have a good amount of experience working with objective-C and making iOS apps that work locally and with BaaS providers (Parse.com). However, I'd like to take my mobile development to the next level ...
-3
votes
4answers
356 views

I am trying to figure out how difficult or expensive it would be to add this feature

I am trying to figure out how difficult/time consuming it would be to add the following feature: We have a database with our subscribers and we want to send updates to paying subscribers. The catch ...
-3
votes
2answers
148 views

Is the system with no central storage more secure?

Consider a distributed system S that consists of several processing nodes (N1, N2, N3, ...) and spans the geographical boundaries. S -> {N1, N2, N3, N4 ...} N is more than 1000. now consider that ...
-3
votes
7answers
442 views

Selling LINQ To Management

I recently started working at a new company that currently doesn't use linq, but does use C# and the .net framework. I'm coming from a LINQ background, so I'm biased, but I still think there are a ...
-3
votes
2answers
108 views

How to structure a database where a record can be a child of a parent or a grand parent record

I have these concepts for a database application: Session, Subsession and File A session can have multiple files A session can have multiple subsessions A subsession can have multiple files A session ...
-3
votes
5answers
153 views

One Single Table or Two Smaller Tables

We currently have a Users table in the database, this has quite a few columns in it. Around 50% of the columns are barely used in the system (only on one or two pages). We've been discussing amongst ...
-3
votes
1answer
67 views

Creating a multiplatform (IOS, Javascript, and JAVA) linked user account database

I have done weeks researching this question for my App Idea. Background of the APP - Simply a multi crypto currency wallet which users sign up with ONLY username and Password - no email, FB, or ...
-3
votes
1answer
1k views

c++ - implimenting an in memory database [closed]

I'm practicing various C++ exercises. In this particular exercise they are asking me to implement an in memory database. I guess they are not asking me to use something like SQLlite. Could anybody ...
-3
votes
1answer
508 views

How can I test a method which aggregates data from a database? [closed]

I'm developing the web Java application and come across the following issue: I'm using jUnit 4.5. Suppose that I have a method which aggregates data from a database for the rendering their to a ...
-3
votes
1answer
41 views

Defer insert data into a database

I need to insert some records into a database at a time when it normally it's not being used, what are some approaches I can take? I have considered using the SQL Server Agent to run some stored ...
-3
votes
1answer
193 views

Using pattern “Repository” for table relations

Have read about "Repository pattern", before it, I have used pattern DAO (data-acess-object). How should I implement table relations with this pattern? Should I create entity for links between tables?...
-3
votes
1answer
86 views

Database change automation for CI?

Our application stack looks something like Java 8 out of Tomcat 7, several distinct Postgres databases, Maven for build and Jenkins for CI. I have fully automated my team's build process using except ...
-3
votes
4answers
121 views

Asp.net Performance Issue

I have been working on Asp.net (Classic), where I need to render the lot of data in Telerik - grid. During loading, its taking too much time. My doubt is which one is causing the impact. Whether the ...
-3
votes
1answer
207 views

I'm trying to create a file with all possible outcomes of tic tac toe and store it using java. How do i do it?

I'm trying to store more than 512 combinations of a game somewhere locally on my hard drive as a single file permanently unlike the temorary nature of arrays. If I store it in a text file like I ...
-3
votes
1answer
224 views

Storing a Database for a JavaFX program

I am currently developing a JavaFx program for a friend's company. I need to store information, so I am using an embedded database (mostly likely derby). Since the database needs to be outside of the ...
-3
votes
2answers
346 views

Database Schema for a multiplayer quiz game

I'm trying to accomplish this scenario : There are 2 types of users, let's say Admin and Worker, and there have different roles. Admin can do a CRUD of questions, and also can create a room where ...
-4
votes
1answer
74 views

What options are there to administrate a database for an online business? [closed]

Say you create a small online business from scratch, a nice Rails or Django app or something to that effect. With luck, you end up with a database full of customer orders and things. Now, aside ...
-4
votes
1answer
95 views

Can one time executable scripts be a part of SOLID design? [closed]

Imagine a table T, with 2 columns containing data. Everyday, one row is added the table. Now you add 3rd column to the table (After adding this column too, one row will be added the table everyday)....
-4
votes
1answer
68 views

Is PHPmyadmin “SAAS”? [closed]

AFAIU a SAAS software is any software which is runs on a browser and performs a certain service, (aside of giving a way to contact the owner of that software) and is also aimed for reuse, whether if ...
-4
votes
1answer
71 views

DB interface design

I have some doubts on how to proceed on my project. Two years ago, we started a small project for a industrial quality control (es: dimensional control). Originally the software must ran only in a PC ...
-5
votes
1answer
150 views

What should I use columns for, and what should I use rows for in SQL?

In SQL, what's the standard convention for what rows and columns should be used for? For instance, if I need to make a table of users and their data, which axis (rows or columns) should be the users ...
-6
votes
2answers
6k views

Best way to keep large amounts of data (no relational database needed)

I would like to know what should be the best way to keep data on a server related to the following points: Chat logs Heavy text content User references like amounts of ids (1,4,14,524,23220,...) I'm ...
-6
votes
3answers
2k views

Is it a row or a record (or a tuple)

If I look at a database table for editing - is it made up of rows or records? If I write some sql and then look at the result is this made up of the same elements as the answer to 1.? Is it the case ...
-6
votes
1answer
120 views

Database design — what should be included in Order and not in Invoice and vise versa in a simple online store?

I'm developing a simple online store with simple functionality. Among others, there're 2 tables: Orders and Invoices. What exactly should be included in one and not in the other? For now I can think ...
-7
votes
1answer
187 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/...