Tagged Questions
0
votes
0answers
31 views
Database with history journaling [closed]
In the database I need to store a data about vehicles (about 240 objects), their locations, working job, etc. In my table this info stored in one table. User should not input everyday this info. It ...
-1
votes
0answers
37 views
Network Databases [closed]
I am doing some research on network database e.g. IDMS-type databases. Are there any free/open source network databases available?
TIA
1
vote
3answers
124 views
Relational vs Non-Relational Database for Events Database
I'm trying to find out whether an SQL or no-SQL solution would be better for creating an events database. I'm creating a ticketing system, similar to ticket master. I know that for either ...
1
vote
1answer
81 views
Approach for a 2,000 table migration
What might be the best approach when converting or migrating a database containing over 2,000 tables? Where would you begin to tackle such an issue? Steps to take in the first weeks of designing? ...
0
votes
0answers
41 views
How to identify computer specifications [closed]
We need to assemble a system that can store streaming data from a dozen sensors, including several cameras, averaging >5 Gb / minute. The desired data storage system is a single machine running a DBMS ...
0
votes
1answer
60 views
good practices of creating tables in mysql [closed]
Hi I was thinking of developing an web apllication using php and mysql.
Application will give a professor the required data about the student.
i want to design application considering Engineering ...
-1
votes
1answer
46 views
Database theories possible topics to research through [closed]
I need to conduct a research on database theories. I want to know what possible questions should I research on which is believed to be suitable when researching database topics for a online assessment ...
1
vote
0answers
54 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 ...
2
votes
0answers
63 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 ...
0
votes
0answers
29 views
“Related search” trick in huge Hypertable database?
Several years ago, I've created search engine using PHP with MySQL (MyISAM)
The "Related search" pick 5 most similar search title.
The data has growing bigger in matter of days.
Each submission has ...
2
votes
2answers
162 views
Should I create a separate user table for different web products within the same platform?
We have a web product for young professional that gives them the possibility to create their page to show their professional identity.
So a table users that has both information about the user (email, ...
3
votes
2answers
57 views
Which database type to use
I want to implement database for following application:-
User creates task and assigns to other user who can furthur split it into subtasks and assign it to other users.creaking a tree like ...
0
votes
1answer
85 views
Database suitable for data mining
What would be an appropriate / suitable database sans Oracle that would be suitable for the following conditions?
data mining
includes but does not limit to the following:
a. clicking on links
b. ...
0
votes
1answer
70 views
Looking for a scalable relational database [closed]
I'm looking for a database that achieves the following:
fully ACID.
relational with joins.
has transactions.
allows the administrator to specify sharding rules (for example: users from Europe should ...
2
votes
2answers
116 views
Database structure for a system with multisite
The system I'm working is structured as below. Given that I'm planning to use Joomla as the base.
a(www.a.com),b(www.b.com),c(www.c.com) are search portals which allows user to to search for ...
0
votes
1answer
182 views
Keep total transaction in invoice application
I want to make an application called as Invoice Application with MySQL database. Now I have designed this database. Now I want to know is this database good for Invoice Application. I will use MySQL ...
3
votes
2answers
208 views
Save history editable data RDBMS
I want to make application like testing system. Every question has one or many variant of answers (and one or many can be right). I apologize that tutors and students use my testing system. It means ...
4
votes
3answers
147 views
Storing date increments in tables
I'm working on a ASP/MS SQL project that performs a lot of calculations based on dates and time. In one case, the system will lookup a value based on the nearest half hour increment throughout the ...
0
votes
0answers
440 views
oracle database project ideas [closed]
I have to prepare three project ideas for my final year undergraduate project module. I like to work with databases and i want any challenging database design and implementation with various ...
6
votes
4answers
1k views
Is there a tool to check if my database is normalized to the third normal form?
I learned about normalization recently, and understand how important it is when implementing a new schema.
How can I check if my database is 2NF or 3NF compliant ?
Manual review is a sure option, ...
3
votes
1answer
252 views
Curious Database building Problem (ER Diagram)
I am trying to build an EER Model for a Autostore that has 5 locations and offers a range of auto products. They offer car repairs and roadworthy tests as a service also.
I need to be able to make ...
1
vote
2answers
253 views
Database design experienced view
I want to make a database that stores countries, their respective states, and cities. I am confused how to normalize these. Can anyone help?
My ideas:
Table 1 Countries (id pk, name , code)
...
3
votes
3answers
114 views
Is this database fine for calculation?
I am doing an application called as Invoice Application.For that I have my database is like this.
Now my problem comes when I am taking the tax part in my database.As I have made tax as an option ...
0
votes
0answers
93 views
Oracle VPD Implementation?
Our team is implementing VPD into the already existing Schema. The application is currently used by one customer and in order to generalize the application we need to implement VPD in our schema. The ...
2
votes
4answers
290 views
One table with many rows or many tables with a few rows
I'm having a question rounding my mind. It's better to create one table and store a lot of rows there or create various tables and have a few rows on them? What's the performance and the I/O saved at ...
-2
votes
1answer
56 views
Design the database of an existing application [closed]
I want to make the mirror application of Invoicera .For that I need the database.Can someone tell me what should be the database like.I want to make that application in php so the database will be in ...
3
votes
2answers
280 views
Recommendations for building a big search engine
I am creating a image search engine that would probably have millions of images tagged with keywords. Basically it would be something like Google Image search.
So I want to ask for any tips on ...
1
vote
3answers
78 views
Need suggestion for placing foreign keys in the databases
I have the database for customers. The customers table is something like this
+------------------+
| Customers |
+------------------+
| id (PK) |
| business_email |
| business_name ...
3
votes
2answers
384 views
What type of datastore should I use for high volume time series data?
Imagine a project which requires to be able to process 50,000+ (tiny ints) writes per second. The data, once inserted, won't change. The data is a measurement on a particular time. Sub second ...
2
votes
1answer
141 views
Using Foreign Keys in database
I am doing a small application for Invoice.In that the tables will be like this
=== invoice ===
id (pk)
customer_id (fk)
invoice_title
invoice_issue_date
due_date
description
created_by
updated_by
...
1
vote
1answer
95 views
Right Distribution of Databases amongst Multiple Instances
So it's obvious that many times you'll have multiple instances (even if on the same server) to have a logical separation of databases for security purposes.
But when does it make sense on the ...
4
votes
3answers
207 views
How do I model data from arbitrary CSV's in a database?
I am setting up a web interface for data management. Users upload CSV or similarly structured files, and I want to store these in the database so they can do manipulations on them -- filtering, ...
3
votes
2answers
483 views
Ready-to-Use Database models example
Where can I find ready-to-use database models ?
I don't need a database with data in it, but only schemas (UML diagrams). Perhaps something like the data models at this link, but much more complex ...
4
votes
1answer
226 views
Would appreciate some suggestions on how I should model this data
I am setting up a website that will have users. Users can search for songs and (if signed in) save them to a playlist or their library of songs.
I want it to be like iTunes in that all the songs on ...
0
votes
1answer
408 views
Database design : multiple category of users login into same system
In our new system we have three type of people
Business owner
Assistant of business owner
Staff (a skilled employee)
I am having following entity
[Business] - include detail about business ...
1
vote
1answer
100 views
Is maintaining a single database an issue when the underlying project becomes larger?
I have seen this related post but it was more focusing on the amount of consumers for the databases, which is not my only problem.
I have a situation, where I am taking part of the design of a new ...
4
votes
1answer
198 views
Speed inserts in database with a table with +47 million data per each year, containing more than 10 years?
I'm moving my database to mysql but there is one table that is pretty big (more than 47 million rows for each year) and it takes years to insert all the data.
I already tried everything I found in ...
3
votes
3answers
408 views
Should I use MongoDB or a NoSQL solution at all for this?
I apologize if this belongs in web applications or something.
I'm creating a web application that is sort of a similar concept to github. Basically I plan to allow someone to create a design of ...
2
votes
1answer
333 views
Database Design: Storing Map Locations
When working on a game, I developed a database that used X/Y coordinates, roughly as:
CREATE TABLE Map
(
MapId INT IDENTITY PRIMARY KEY,
X INT NOT NULL,
Y INT NOT NULL,
North INT ...
5
votes
2answers
846 views
Database Hardware and Software to handle million requests per second?
I'm curious about the necessary hardware and software requirements to support a strong MMORPG. For example, what kind of requirement (both hardware and software) would I need if I were to build a ...
8
votes
4answers
2k views
Whether or not to create separate tables for different product types?
I'm in the process of designing a database and I'm having second thoughts about my initial design decisions...
Product types are as follows... Models, parts, replacement part kits and options.
...
4
votes
1answer
251 views
Proper Database Partitioning
I had asked a previous question "Proper technique for storing users event data" and the correct answer in my opinion was to create a database partition. Now from what I have read on it there are ...
6
votes
2answers
323 views
Proper technique for storing users event data
I am mostly a self-taught when it comes to database designs. I am posing this question because I have settled on this common structure, but am wondering if it is the most efficient or 'industry ...
8
votes
3answers
670 views
Suggestion for Large SQL Server Database Design
We are creating a database in MSSQL 2008 R2 Standard where we will be storing a large number of records. We estimate 200 million+ records in one table annually and we are primarily INSERTing with very ...
1
vote
1answer
416 views
Which NoSQL database(s) should be used for advertising platform? [closed]
What NoSQL database or combination of databases best meets these criteria?
Very fast writes and reads
Persistent data that won't get lost in a crash
Plays nice with PHP
Works well in the cloud (EC2)
...
7
votes
3answers
211 views
Database design advice
I'm designing a database for our sales team to use as a quick job quoting tool. I would like some feedback on a particular aspect of the design.
A quote is basically built up by selecting a list of ...
4
votes
1answer
232 views
What databases or styles of database can use git (or another dvcs architecture) to manage cross-site replication?
I'm looking for a database software package for a dictionary (like the hunk(s) of dead tree that you might have somewhere at home). I would like the database to
scale well to a million key-value ...
7
votes
3answers
478 views
What are negative keys used for?
Somewhat new to using standard SQL databases (currently working with MySQL mostly) I haven't run across many usages of this as of yet.
When and why is it useful to have negative (or rather signed) ...
1
vote
2answers
259 views
Determining sizes for Separated Partitions of programs, data and logs in SQL Server
As per the recommendations of the CIS benchmarks for SQL Server, I want to create separate partitions for the data, the programs and the logs on my SQL Server dedicated server.
Question is, what is ...
11
votes
6answers
1k views
Is polling the only way for updating app's data from a database?
An application needs to have data as more freshly updated from a database as possible. In such a case, is there any other way for getting the data, besides of a timer based requesting (polling) the ...
