Determining what database product best fits the requirements and limitations in a specific situation. This is advice that generally requires much more insight into requirements than can easily be gleaned on a Q&A forum such as StackExchange.

learn more… | top users | synonyms

0
votes
3answers
44 views

secure way to connect with remote Mysql database

I created my application using MySQL and it relies completely on the database I have around 190 tables, and I'm afraid of security breaches and another problem is for remote access I have to add the ...
0
votes
2answers
14 views

Structure database(s) dealing with different time points

I have few data sets that give a score for a specific account at a specific point in time. So, account A might have a different score each quarter going back 5 years so. There aren't a ton of data ...
0
votes
2answers
37 views

How to build a table for a private messaging system that supports replies?

I'm writing a private messaging web application in PHP, the application allows replies such that when you view a message, you also get to see to what was that a reply to, and to what was that a reply ...
0
votes
2answers
174 views

Daily snapshot fact table

I have a list of products per costumer. Costumers can delete or add products to their list. I want to know in each day what is the list of products (and count) by costumer. My first approach is to ...
1
vote
1answer
46 views

Difference beetween mysql 5.5 and 5.6

I have a big performance problem beetwen my local mysql instance and the server. I have this request : DELETE a FROM a LEFT OUTER JOIN ( SELECT MAX(id) as id, `v_id`, `v_statut`, `c_controle`, ...
1
vote
1answer
42 views

Database setup for datalogging

We're currently starting to build a version 2 of our system and one of the things we've noticed with version 1 is that we'll have quite a bit of data so we started to rethink our approach to how to ...
1
vote
1answer
320 views

CRM Address table and it relation

Hi I want to ask about I have this DBD for my CRM I am trying to have the addresss in one table(customer and Employee Address) and both customerID and Employee ID are guid I have in address table FK ...
0
votes
1answer
13 views

Putting some calculations on a database entry from phpmyadmin

I am creating an online store website for sale/purchase. I have to put a specific percentage of an amount (User enters) in database. for example If user enters 100. I have to deduct 30% of it and I ...
0
votes
1answer
40 views

Need help on a database model design

I am creating a small booking application with Laravel. It lists some centers. Each center has its own unique rooms. Each room may be booked several times (with dates). From my application, I post the ...
0
votes
1answer
169 views

Mirror / replicate only 1 table of a database

I need a good way to replicate a single table in SQL Server 2012 between different servers and different databases. I tried replica which works just fine, but there might be a much better / easier way ...
0
votes
1answer
586 views

Can I copy a collection in mongoDB from one database to another by copying the db files directly?

I tried using cloneCollection http://docs.mongodb.org/manual/reference/command/cloneCollection/ , but clonecollection takes a lot of time in case of big collection because it starts indexing the data. ...
0
votes
1answer
13 views

Debate on which id to use as reference when quering a one to many table

I have a database that has a One to Many relationship. A few changes are in order and now when I query the output I need to provide just one ID field. The output contains all iterations of the one to ...
0
votes
1answer
44 views

Is there a database system specialized in versioning documents/records?

I'm trying to find the "best" database for my application, which involves: Large (or is it?) amount of data (~15GB of text data) Documents organized in hierarchies (up to ~5 levels of nesting) ...
0
votes
1answer
36 views

Optional oneToOne relations and criteria field

Introduction: Visitors can fill reports on my website. Those report can either be filled by a legalPerson or a naturalPerson. Constraint: I don't like empty fields and I would like to normalize as ...
0
votes
1answer
2k views

Storing multidimensional array in MongoDB

I am attempting to convert a large MySQL database of product information (dimensions, specifications, etc) to MongoDB for flexibility and to move away from the restriction of a column based table. I ...
0
votes
1answer
241 views

facebook group alike database scheme

Here are my requirements: one user can have many tasks one group can have many task one group can have many users only invited user by a user can be added into a group Does this db design appear ...
3
votes
0answers
196 views

What are reasonable options for an in-memory multi-core database?

I'm going to preface this with pointing out that I only need somewhat persistent data. The purpose of this database platform would be to support statistical analysis in R. I usually build my tables ...
2
votes
0answers
818 views

which role-permission database design?

I want to manage roles and permissions. Most of designs on web look like this tables: Users Roles UserRoles Permissions RolePermissions Here, what is permissions? I am thinking for such a design ...
2
votes
0answers
115 views

Digital asset management

I'm working in a company that currently develops Media Asset Management system and now we want to improve our system for document files. I have to search nearly thousand .doc and .pdf files and index ...
2
votes
0answers
381 views

SQL Server SSIS issue retrieve data when i enter into login of server side?

can any one try solve my problem here i am facing a problem Failed to retrieve data when i enter into login of server side here is the error message TITLE: Microsoft SQL Server Management Studio ...
2
votes
0answers
620 views

How to do automated archiving for a SQL Server database based on interpretation of database metadata?

I am looking for a solution giving me automated archiving of SQL Server databases based on a smart interpretation of table relationships that is able to archive records from related tables minimizing ...
1
vote
0answers
15 views

Which database for microcontroller?

I'm choosing database for my project which involve about 20 Arduino devices. Every device should run standalone, without any external server. This devices will be connected to each other in a network ...
1
vote
0answers
17 views

Which major database platforms support TTL?

I need to store some data in a database that will be hosted on Amazon Web Services, and I have complete freedom over choosing which database platform to install, based on what I think will best suit ...
1
vote
0answers
164 views

How to handle many columns / variable schema?

I apologize in advance in case this question has been asked already. I'm working on revamping a reporting application used within my company. The requirements are: Support addition of new fields ...
1
vote
0answers
136 views

Conceptual model vs Logical model vs Physical model

I'm doing a work about database, and now I need to show three different images, one image with the conceptual model, other with logical model and other with physical model of a database. I'm looking ...
1
vote
0answers
453 views

How to generate data for News Feed efficiently like facebook , googleplus , twitter e.t.c?

I have created table as post ( post_id int(15) auto_increment primary key , user_id int(11) , post_text varchar(2000) , post_type int(1), ...
1
vote
0answers
126 views

Real Time data collection - Help select Database

My Scenario: I want to collect data from various sensors[for now I have 600 sensors sending data, but this may have to scale up to 3000 more data sensors, all sensors send real time data] Now I have ...
0
votes
0answers
3 views

Optimal engine for small lookup tables in MySQL

I have following question: I am designing web application with several dozens of small lookup tables: These tables usualy contain three columns (ID, Name, Description) and a couple of rows (mostly ...
0
votes
0answers
18 views

Design Payment System - Best way to track different payment types and reasons

I am designing a system to track incoming payments from external entities. Payments will be stored on tblPayment and take place in different ways, to mention some: 1) cash 2) cheque 3) credit ...
0
votes
0answers
29 views

What is wrong with my ERD?

I am trying to create a reservation/booking ERD. Is their anything wrong with my current ERD? It must show a supertype and subtype, and it must identify attributes for regular, weak, and associative ...
0
votes
0answers
14 views

Should I partition table by time or project_id, or both?

I have a table of event data that is getting slightly large. It's ~10 million records. I want to partition the table to help speed things up. I almost always restrict the query by both the time and ...
0
votes
0answers
18 views

reset password database and table

While working on lost password feature on a website, I have created two tables tbl_lost `id`(PK) | `umail` (FK) | `pcode` | `count` | `expired_on`| `asked_on` | tbl_user `id`(PK) | email | ...
0
votes
0answers
28 views

Data containing list of all the domain names. MongoDB or MySQL?

Data containing list of all the domain names (currently present in the Internet world), along with few attributes (5-6 or maybe 10, each attribute being a column) will be considered as Big Data? ...
0
votes
0answers
17 views

Recommend a suitable DB for storing events

I have rows of the following type: identifier (string), type (int), date (date), count (int), extra info Rows have a unique constraint on (identifier, type, date). I want to perform the following ...
0
votes
0answers
39 views

What kind of data cannot be stored economically in a database / data-warehouse?

Someone mentioned this in a presentation but didn't provide any examples. This stuck with me and I am trying to figure out what kind of data couldn't be stored economically in datbases ever since. It ...
0
votes
0answers
48 views

linking a single table (comment) to multiple tables (article,link,attachment)?

the main idea is that i can post an article , link or an attachment and i can receive comments on each of these types of posts (the structure of the comment is the same) , the problem here is that i ...
0
votes
0answers
19 views

Retrieving log files from users and dumping into a web based database

Please forgive me for not being familiar with database tools. I am trying to figure out even the best jumping off point for my senior project. Basically I've designed a front end application in ...
0
votes
0answers
24 views

Platform to manage and analyze peer evaluations?

Our academic department (at a US university) collects mandatory paper-based peer evaluations at undergraduate level for a number of classes each semester. So in a typical class of 60 students, folks ...
0
votes
0answers
20 views

Should I install hadoop on a single node

I just bought a desktop computer with 16GB RAM and 1TB drive, i7-quad core. I will be partitioning off 800GB for Ubuntu so I can do some data science type tasks. Is there any advantage to installing ...
0
votes
0answers
47 views

TPC-DS data generation

Is there a way to generate TPC-DS/TPC-H data using Normal Distribution, i.e., is there a way to specify the distribution type while generating TPC-DS/TPC-H? EDIT : I believe there is an option for ...
0
votes
0answers
18 views

Database Engine Tuning Advisor - is number of queries important or not

By number i don't mean number of unique signature queries I mean raw number For example i have this query select name from my table where id=3 It is a single unique signature Having it only 1 ...
0
votes
0answers
52 views

Database that supports fast prefix matching

I have a list of potentially millions of url's, e.g. twitter.com/user1, facebook.com/user2. For every incoming other url (10K/s) I want to find the longest prefix match among all the stored url's. ...
0
votes
0answers
69 views

How to manage MySQL database with Oracle Fusion Middleware?

Is it possible to connect and manage a MySQL database with Oracle Fusion Middleware?
0
votes
0answers
43 views

employees Evaluation System database

I am new to database designing I want to design an Employees Evaluation System for a company. Based on Competencies Rating Each Manager will rate his/her employees at the end of each year for 6 ...
0
votes
0answers
86 views

Best practices for ranking records in flexible way

Suppose we have 10000 records of any product. User search on our website with his given criteria. so we output search results based on given criteria. Now Admin want to rank products in search. so ...