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
2answers
165 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
41 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
268 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
51 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
67 views

What is the best design for storing courses subscription data?

Building an app that will manage lessons, students, courses. Each lesson belongs to a certain course. A student can subscribe to a single lesson or to a whole course. So it seems straightforward that ...
0
votes
1answer
347 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
32 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
1k 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
218 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
183 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
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
351 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
572 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
63 views

postgresql 9.3 with Ubuntu 14.04.1 LTS throw 's ERROR: invalid page in block 105 of relation base/16385/17407

This is Ubuntu 14.04.1 LTS with postgresql 9.3 in production, Now i got this below error's in log. # tail -f /var/log/postgresql/postgresql-9.3-main.log 2015-01-08 14:10:16 IST CONTEXT: automatic ...
1
vote
0answers
137 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
116 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
394 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
759 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 ...
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
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
16 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
24 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
15 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
30 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
31 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
22 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
17 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
32 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
16 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
50 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
33 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
0answers
61 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
40 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
120 views

Using MySQL As A Graph Database, Can It Be Done Efficiently?

So I am currently working on a startup idea with a friend and we've come a long way, it's somewhat functional and I've tried to not let database design decisions slow the progress of the site. As of ...
0
votes
0answers
78 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 ...