Tagged Questions
This tag is for general database questions; if you question is specific to SQL use that tag instead.
2
votes
3answers
38 views
Two Database Architecture : Operational and Historical
I thought about an uncommon database structure and wonder if anyone has seen it in use before. It's basically using 2 databases:
First database hold only the data that is currently valid
Second ...
0
votes
0answers
12 views
Hybrid Apps and Storage - how does it work with Native apps and which to use?
I'm using Ionic at the moment. I believe, like many others, that hybrid apps will become more more common/important than they are now simply because the frameworks are getting better and better.
...
0
votes
0answers
24 views
How can I model this scenario in a graph database?
I'm developing an application where users can tag resources and it's also important to know who tagged the resource with a specific tag.
A graph database seems like a good fit for this and the rest ...
2
votes
3answers
56 views
How to save many changes to database data?
I'm working on a feature which will pull many (say, 1000-5000) rows from a database, display them to the user and allow the user to edit them. This editing may involve changing text; adding rows at ...
4
votes
1answer
195 views
How does the team ensure a good DB design? [on hold]
We want to ensure that our team delivers a good performing DB design. But we are not quite sure how to achieve this.
Couple of solutions have been suggested within the team:
Adding DB indexes to ...
6
votes
6answers
140 views
How would you design a user database with custom fields
This question is around how should I design a database, it can be relational / nosql databases, depending on what will be the better solution
Given a requirement where you'll need to create a ...
-2
votes
0answers
12 views
Database solution for multi-user uml-ish application [migrated]
I'm working on a Eclipse RCP-based application that will switch from single user local storage to multi-user database storage and are now considering what storage solution to use.
It's sort of UML ...
0
votes
1answer
106 views
Where should the following business logic be written?
I have a C# console application. This application has many different projects/C# class files, each of them dedicated to parsing a certain kind of XML and creating an object, called 'Response'. Now, ...
0
votes
1answer
47 views
+50
Definition of the NHibernate Mapping by Code / EF Code First pattern?
Sub-questions:
Does this pattern have a formal definition?
Who invented it?
Is it considered a DSL?
The reason why I am asking is because I would like to better assess its applicability to ...
1
vote
3answers
168 views
OOP implementation doubts with databases
I was starting a project today and after designing the database structure and how the data would be stored etc, I started the implementation. I am doing this on php, but the language isn't really ...
0
votes
0answers
46 views
SQL: GROUP BY where a column is unique [migrated]
So I have this one giant table e.g.
PROD_IDGEOG_IDTIME_IDVALUE1
1 MT JAN 100
...
3
votes
2answers
110 views
Design, how to utilize The Hardware (multiple threads and/or GPU) while indexing (via a database) a very large set of binary files
Problem
How can design my file parser to maximize the hardware when processing (creating meta data for) a large file
(i.e. how to avoid being blocked by IO and running out of memory)
preferably ...
0
votes
1answer
42 views
REST and foreign key constraints
I have a rather complex database schema using foreign key constraints. This database schema will be accessed with REST services.
Should REST or the database be responsible for referential integrity? ...
0
votes
0answers
11 views
How to use an Address Gazatteer in an application that contains addresses
Say I had access to the post office address file (http://en.wikipedia.org/wiki/Postcode_Address_File) and wanted to cleanse about one million addresses. I am trying to think of an "algorithm" to do ...
4
votes
1answer
62 views
Should I implement the consumer/producer pattern in my java video app, and if yes, how?
I built a small video frame analysis app with desktop Java 8. On each frame, I extract data (5 doubles now, but could expand to a 1920x1080x3 OpenCV Mat in the future). I would like to store this data ...
1
vote
1answer
54 views
how to decide when to use database replication vs. custom REST applications vs. message brokers (pub / sub)
We have a distributed solution that's currently under design. There are a few points of integration where some application needs data from someone else and vice versa. We could solve by either ...
58
votes
10answers
6k views
Is it premature optimization to add database indices?
A colleague of mine today suggested that we go through all of the queries in our application and to add indices accordingly.
I feel this is premature optimisation because our application is not even ...
0
votes
0answers
20 views
Database data Bucketing Report Design
Here's the scenario:
I have item x (item_id, customer_number, cost) which can be submitted to another system multiple times over months which may or may not reject item x before finally accepting it ...
0
votes
0answers
12 views
how to store program actively processing info for remote monitoring? Database?
So I have a program that processes a bunch of files.
File in, start processing, file finished, next file.
The question is, now I want to be able to monitor how that program is getting on, how?
...
-2
votes
0answers
9 views
International characters in pyodbc - ODBC python library [migrated]
I'm using pyodbc to connect to my *.mdb files and store them in a sqlite / spatialite database for further work and analysis. I'm passing DSN like this:
...
1
vote
2answers
177 views
Is it possible to avoid SQL injection by not using a Query Language for most tasks? [duplicate]
I'm coming at this from a somewhat beginners viewpoint so if this is an obvious question it's because I didn't know the right terms to search for. Are there DBMS's that provide an alternative ...
2
votes
3answers
93 views
User roles in database [duplicate]
What would be the most efficient way to store a users role(in my case) in the database?
What my user table looks like:
id int(AI)
username varchar(80)
...
0
votes
1answer
58 views
Design caching system
I am thinking about making my own caching system, mainly for C#, but this is more a design question, so the language doesn't really matter.
Let me start at the beginning, I have a basic web api, ...
2
votes
1answer
41 views
Multitenancy and nested set trees
The application I work on utilizes nested sets1 to represent tree structures within our database.
We need to expand a particular area of access control to support multiple clients who should not be ...
2
votes
1answer
135 views
Any way to use VoltDB in rails app?
I've been curiously looking at VoltDB and one year ago I have even seen a gem that was providing Ruby connection to VoltDB. I have checked today again and it seems gone.
I'm planning to go through ...
0
votes
1answer
54 views
Like structure table with Laravel and showing the most popular content at top
I am using Laravel to creating a website, my users can post questions and other users can write their comments under the post, each comment have Up vote and Down vote, and users can voting for ...
3
votes
2answers
72 views
Should log/data files be stored in the database? [duplicate]
I'm working on a project where we produce lots of data in the form of simple .txt files. These usually contain a set of columns that will later be loaded in to Matlab to be analysed. I've implemented ...
0
votes
2answers
95 views
Web API alternatives to save a file to server's file system
We have a SQL Server 2012 Enterprise edition and an ASP.NET Web API 2.2 web service. The web API is the public interface for the database.
We need to end a production order doing:
Changing a value ...
1
vote
3answers
151 views
Is self referencing tables a good idea for geographical data?
I am creating a design for different Geographical types where each type is just a little "place holder" in over all heirarchy.
One example is
Zip code Belongs to Territory Belongs to District
...
3
votes
2answers
122 views
Best practice for uploading large file, previewing, and editing before saving to database?
I am allowing users to upload a relatively large .csv file (about 1MB) - it will contain thousands of records that each represent one of my business objects. I want the users to upload the file and ...
0
votes
0answers
23 views
Database integration of Rails and Laravel apps
I have some very small apps on a VPS running ruby on rails and a co-worker also have some of his own apps running on laravel at another VPS.
So far we dont needed to share any data among the apps, but ...
49
votes
6answers
5k views
Should Latin-1 be used over UTF-8 when it comes to database configuration?
We are using MySQL at the company I work for, and we build both client-facing and internal applications using Ruby on Rails.
When I started working here, I ran into a problem what I had never ...
0
votes
0answers
119 views
Is this a good implementation of the builder pattern?
I'm trying to design an SQL builder in PHP. I'm trying to make it so that the system could work with different database systems (e.g. Oracle, MySQL, MSSQL). Here's what I've got so far.
First, I have ...
1
vote
1answer
64 views
Trying to Move Logic to DB - Reservation System
So I'm planning a basic resource reservation system. Basically I'm going to have a room (resource) that has X number of open spots per 30 minute increment. When someone reserves a resource I would ...
9
votes
2answers
615 views
Should I keep email addresses as plaintext in database?
It's clear to everyone (I hope) that storing passwords without at least salting/hashing them is a terrible idea.
What about emails? Let's say you keep the subscription email address, if you encrypt ...
2
votes
1answer
91 views
How to design database tables for a Factory class?
How can I design database table structure for a class that varies in its core parameters, when it is created by a factory method?
I have a Factory like this:
class ProductFactory
{
public ...
0
votes
0answers
40 views
What could possibly be a Mysql database structure for an web app say like Flurry?
Simply say, I'm working on a web App say like Flurry (http://www.flurry.com/), that would communicate with a Smartphone App trough API.
Right now I'm designing the database structure, and I guess ...
2
votes
3answers
97 views
Is it an abuse of SOA to use it as a database abstraction layer? [closed]
I have a question whether it is a good or bad practice to use an SOA layer for the application servers to talk to the database. A web application server can obviously directly connect to a database, ...
2
votes
1answer
90 views
What should be the structure of a person to person store database?
I am going to create a person to person store with Laravel, a website where its users can share and sell their product or their mobile, TV, Computer, Shoes, Shirts, Books, Cars, Bags, Animal, etc.
I ...
1
vote
3answers
133 views
How to choose DB and/or DBMS for own application? [closed]
I'm creating application in C++ and found out that storing information in XML file was very prodigally. Despite the possibility to read it without any specific application, random access via DOM or ...
0
votes
1answer
37 views
Large volume report operations, how best to replicate transactional data
We are overhauling a legacy accounting app that has some large reports. One concern that has been raised is due to the transactional nature of the data, if we start a long running report how do we ...
0
votes
1answer
55 views
Closed source proprietary web application with an AGPL source code in iframe or sub-domain [closed]
In a closed source proprietary web application, if I use an AGPL product in a sub-domain or in an iframe do I have to open-source my project?
If answer is no, is it possible that both applications ...
3
votes
2answers
169 views
Meaning of an “instance of a database”
From http://en.wikipedia.org/wiki/Extension_(semantics)#Computer_science
In computer science, some database textbooks use the term 'intension' to refer to the schema of a database, and 'extension' ...
0
votes
0answers
40 views
Minimizing database requests for moves of a chess game?
I'm writing a webapp for chess which, for a given move and a database of games, shows all the moves that follow from that move. Pretty much what this website has already done: ...
1
vote
1answer
61 views
RavenDb - Get data through a REST Web API
I would like to build a RESTful API where I need to get data from a RavenHQ-cloud-database. First of all, is this possible?
The idea is to have multiple applications (xamarin-app, mvc-app, etc.) and ...
0
votes
2answers
168 views
Saving to file before storing into a database in a REST service
A mobile back-end I am building should receive a larger amount of data (some sensor recordings) from an Android phone. The phone does not have much use of it so it was most efficient to store the data ...
3
votes
2answers
195 views
S3 image urls in database
I have an application where users will be able to upload multiple images for one Product (via something like Ryan Bates nested fields, so you'd click "Add Image", and a file upload would appear on the ...
1
vote
2answers
94 views
Users in SQL databases
I took up programming a couple of months ago (alongside my day job) and am struggling with a couple of basic concepts. Currently, I'm trying to learn how to build a database based PHP login/logout for ...
7
votes
2answers
256 views
How to efficiently store big time series data?
I need to store and to be able to query some very large amounts time series data.
Properties of the data are as follows:
number of series : around 12.000 (twelve thousand)
number of data points, ...
1
vote
4answers
135 views
Database design for objects with multiple states
Context
I'm designing a database which, simplified, should be able to handle users sending job requests to each other, and after that a job can be started, finished, and reviewed. The design should ...
