This tag is for general database questions; if you question is specific to SQL use that tag instead.
4
votes
2answers
175 views
database design, how to handle freelancers
The context
i'm modeling a database for a small ERP system. However I've recently hit a difficult spot that I'm having a hard time wrapping my head around. The logic of it involves a few special ...
0
votes
1answer
100 views
Are CRUD operations intended to be used with collections?
CRUD operations, by definition are...
interfaces that permit users to create, remove, modify or retrieve data
Implementations of CRUD interfaces can come in various shapes and sometimes they are ...
0
votes
1answer
34 views
Real time middleware system: Direct DB access vs REST API access
I'm developing a complex environment which involves a web application, a mobile app and a real time middleware system which accesses the DB for on-site tag readings. Currently, the web application ...
0
votes
2answers
69 views
Is a mocking framework useful if I'm unit testing a repository/database? [duplicate]
I'm trying to improve my testing skills. I frequently hear about mocking framework to build fake objects (as far as I understand). Right now I need to test my repository (the usual add, remove, update ...
-1
votes
0answers
28 views
Type of data stucture used in indexing a column in RDBMS
When an index is created on a column of a table (RDBMS), who decides that which
data structure(hash, b tree) will be used for this particular indexing?
Can we choose according to our need or DB ...
3
votes
2answers
117 views
Is a bad practice create database structure on the runtime?
Im creating a crawler app that will always in the beggining, when the Class constructor, ensure that the basic database structure exists.
Is this a bad practice? What is the advantage os creating the ...
2
votes
2answers
72 views
Unit test database insert/remove and atomicity
I create my compact test database. This is a SDF file, embedded as a visual studio resource. When test suite starts this database is copied in %LOCALAPPDATA% so my test can use it.
The first method ...
0
votes
0answers
51 views
Properly design program database to reflect organization structure
I'm having trouble setting up my program's database the 'right' way. I was hoping you guys could give me suggestions on doing it properly. I am creating a database+client for a non-profit organization ...
0
votes
0answers
26 views
Storing last polled database timestamp unix
I have a Unix script which is called by a scheduler (CTRL M) every 3 seconds. The script queries an external database(not belonging to my application and therefore I can only query it) to check for ...
-2
votes
0answers
33 views
How to connect a Django app with a Java Web app using JMS
I'm dealing with my DB systems course project, it's a stock exchange simulation app using Oracle 10g, the deal is that the support is for Java, but i'm going to do this in Python.
The last iteration ...
0
votes
1answer
102 views
Are there two type of associations between objects or are there just different representations?
I've been spending some time on 're-tuning' some of my OOP understanding, and I've come up against a concept that is confusing me.
Lets say I have two objects. A user object and an account object. ...
1
vote
1answer
87 views
Automatic denormalization for a NoSQL database application
We have a use case where we store table-like data, but we know about the schema of the data only at runtime. In our application, a power user defines a schema and normal user can create records and ...
6
votes
3answers
255 views
Proper Response to HTTP Request When Too Much Data is Requested
I'm building an API for an ad serving platform that will allow you to request tracker data for ad campaigns. Campaigns often exceed hundreds of millions of requests, which means there will be many ...
3
votes
7answers
216 views
Are mutliple database calls really significant with a network call for a web API?
At one of my employers, we worked on a REST (but it also applies to SOAP) API. The client, which is the application UI, would make calls over the web (LAN in typical production deployments) to the ...
2
votes
2answers
55 views
Communication/Updates between units of works/entity framework contexts, colliding with user changes
I'm developing a WPF application using Entity Framework for my database communication. The application has a hierarchy of tabs where each tab has a db context. Each tab allows the user to view some ...
1
vote
5answers
128 views
Database design with performance issue and use of views
I am designing database for a school system. I am having to create a lot of tables and a lot of link tables to maintain a structure in the system.
I am trying to maintain foreign integrity and trying ...
1
vote
1answer
78 views
How to save appointments in database?
There are 2 entities. One is admin. The task of admin is to define slots for appointments which will be taken by applicants.
The admin will choose a default time for the appointments like 10am to ...
3
votes
2answers
124 views
Whether to store all numbers or just their ranges in database for this application
I'm developing a (PHP MySQL) Web App which will sell dynamically generated real time cell phone numbers for cellular companies. A company will ask for, say, a thousand numbers and this app will check ...
0
votes
1answer
34 views
Tweaking a ranking algorithm from a few variables
I'm going to have a mySQL table with elements in it and would like to rank them in the same manner than Reddit but not quite. I'd like to know how to add or remove importance to a variable in my ...
0
votes
1answer
71 views
Efficiency of getters/setters with database performance
I'm currently in the process of refactoring a very old personal project of mine, which used procedural PHP-in-HTML code. I'm modernising it as a learning project, using OOP where beneficial. I ...
0
votes
0answers
44 views
Database conceptual Question [duplicate]
When querying in database through PHP, is it good to open mysql connection before every query and close it as the query completes? or should we open the mysql connection as soon as the first query ...
0
votes
2answers
132 views
Database Handler and SQL injection prevention
I've written a database model class in PHP and have written a controller class that specifically validates the data before sending it to db. I'm getting criticism that I should handle the data in ...
-1
votes
2answers
86 views
Loading database in memory vs querying
I am currently developing a continuous backup software. The key feature of the software is instant backup meaning that each time a file is created, modified, renamed or deleted the change is ...
2
votes
1answer
48 views
Using json as database with EF, how can I link EF and the json file during DbContext initialization?
For a personal testing-project I am considering to create a SPA with the following technologies:
ASP.NET MVC + EF + WebAPI + AngularJS.
The project will make use of small amount of data, so I was ...
0
votes
1answer
72 views
Prepared statement alternatives for this middle-man program?
I have an program that is using a prepared statement to connect and write to a database working nicely, and now need to create a middle-man program to insert between this program and the database. ...
2
votes
1answer
84 views
Finding a way to simplify complex queries on legacy application
I am working with an existing application built on Rails 3.1/MySql with much of the work taking place in a JavaScript interface, although the actual platforms are not tremendously relevant here, ...
1
vote
1answer
75 views
Where to store front-end data for “object calculator”
I recently have completed a language library that acts as a giant filter for food items, and flows a bit like this :Products -> Recipes -> MenuItems -> Meals and finally, upon submission, ...
0
votes
2answers
66 views
Is it a bad practice to keep database schema scripts (DDL) and manipulation (DML) scripts in different modules
we have a project structure like the following
"module-shared" module depends on "module-database" module and some other modules depend on "module-shared" but no other module depends on ...
-2
votes
1answer
58 views
How to get a database on my filesystem that I can use in my application [closed]
I'm making a .NET application where I'll have a lot of data entries. This will not go to any server though, but needs to be stored and updated, frequently on the local machine.
I would like something ...
0
votes
1answer
68 views
Dealing with data, when your database is under version control
Currently my database is not under some kind of vcs, we can get deltas but that's about it. I would like to try and make product deployments more automated, and less time consuming. I understand that ...
1
vote
1answer
41 views
How can I share a managed DBConnection across various objects?
I am implementing what I thought was a simple object wrapper around a database where one object "PartRecord" represents one row of a database table.
I want a client to be able to request a given ...
2
votes
2answers
47 views
How to ensure the success of processes after a deadlock exception occurs?
No matter the programming language is and whatever the database is, the concept should be the same:
I have 2 threads, each locking some database entities and inserting new data in database.
Let's ...
3
votes
2answers
125 views
Would these two scenarios be good candidates for a NoSQL database?
I've checked a few other threads around the topic and search around, I am wondering if someone can give me a clear direction as to why should I consider NoSQL and which one (since there are quite a ...
0
votes
0answers
75 views
Best practice: Secure Android app online authentication
Currently, I develop an Android App needing online authentication for login (and registration).
The main focus is on security. I’m amaing for:
keeping the users’ passwords safe and
preventing MITM ...
2
votes
3answers
167 views
Structural pattern for an unconventional use of a database
I'm writing a game client as a personal project and using using it as a vehicle to learn about Java database access, specifically Neo4j, and possibly Spring Data Neo4j if I decide it's appropriate. ...
0
votes
0answers
146 views
Why would I use ElasticSearch if I already use a graph database?
I don't find any deep explanation on the web about a comparison between ElasticSearch and the graph databases.
Both are optimized to traverse data.
ElasticSearch seems to be optimized for analytics.
...
-3
votes
1answer
79 views
what data storage method should I use? [closed]
I am currently writing a program and among other things need to store data.
The program listens to two computers talking to each other in a known protocol (the program know what protocol it is,the ...
1
vote
1answer
54 views
Entity-Attribute-Value table vs single table for storage of posts, events and pages
I am trying to decide whether to just use individual tables with more fields for storing posts, pages and events or using tables with basic fields plus having EAV tables as well for fields that are ...
1
vote
1answer
40 views
Which approach would be better for persisting these overridable configuration keys and values? A simple key-value store, or a graph database?
I'm creating a system where there are config keys and values. So for example:
config.key = 10
Is an example of a configuration key and a value. These keys can also have overrides based on ...
1
vote
1answer
83 views
Should data be stored to local database in Android when heavily using REST services?
Let's say I have an application that has constantly changing data. Changes are so frequent that you basically need to refresh data every time you open some screen and keep refreshing it. Is it worth ...
2
votes
4answers
81 views
In a large statically-typed software project with non-dynamic manual sql statements inside of it, how do you verify all the sql syntax?
One of the things I seem to struggle with frequently is the need to deploy a software application to test the database interaction. More often than I'd like, I have a syntax error or typo in my sql ...
1
vote
1answer
43 views
n:m as the only way to store notifications?
I have a user and a notifications table. I want to make sure that every users sees a new notification once and only once. Not more, not less. The intuitive idea is to have a n:m relation table with ...
2
votes
1answer
47 views
How do tablespaces differ in DB2 from databases in MySQL or MS SQL Server? [closed]
In DB2, it seems there is a strong separation between what a database is and what a tablespace is. Where as in MySQL and MS SQL Server tablespace and database seemed to be used synonymously.
What ...
-1
votes
3answers
161 views
What constitutes a good Database System(Java / SQL related) [closed]
I've given this so much research but still couldn't come to my own conclusion, before continuing this question I would like to give you a rough idea of my current situation. I'm 18 years old and have ...
0
votes
2answers
57 views
Static and dynamic data : should I use different databases?
Say I am building a website that uses two different types of data :
Static : information that will hardly change, like movie awards or world countries names (I want fast access so no external API)
...
3
votes
2answers
69 views
An algorithm for finding subset matching criteria?
I recently came up with a problem which I would like to share some thoughts about with someone on this forum. This relates to finding a subset. In reality it is more complicated, but I tried to ...
2
votes
3answers
108 views
Multiple many to many relations or one option table?
Let's say I have a database of persons who have some properties. For the sake of this problem let's say all of these properties relate as N-N.
I can either create two tables for each property (one ...
0
votes
1answer
68 views
Best way to deploy database-dependant application
I have always "custom developed" software for clients. This means:
Develop the software
Install SQL Express on client site
Import DB, create DB user, set DB permissions etc.
Install software on ...
3
votes
5answers
244 views
Is it useful to keep 'definition' entities in a database vs using an enum?
In a project that I have started working on, the database has a lot of FooDefinition tables which act like an enum. It's a C# project using Entity Framework although that is not central to the ...
3
votes
1answer
60 views
optimize human-readable database with index
i need to store a large amount of data - about 10 million entries of the format
unique hash (64 chars), value 1 (5 chars), value 2 (9 chars)
i will be reading and deleting (but not updating) this ...
