The application-design tag has no wiki summary.
1
vote
1answer
66 views
Public Database for Mobile Application
What are the proper steps to hosting a public database. Currently I a building a mobile application with Adobe Flash Builder. I have used Microsoft SQL Server, My SQL as well as WAMP Server. All of ...
2
votes
1answer
85 views
Apply in a CSV file to multiple databases
Recently, I have been working with a client whom has asked us to provide their dataset for use in a mobile application we are making for them. The requirements for this project include the ability to ...
0
votes
1answer
56 views
Searching through lots of applications
Google search has instant search feature. While you are typing, it finds the pages. Apple.com search box. StackExchange ask question part finds similar questions while you are typing question title.
...
3
votes
1answer
380 views
barcode inventory design - transaction or master?
I am building a inventory software for mobile phone retailers. There are several things confuse me.
Ok, we have:
Product
Product Attributes
Barcode
Stock In Batch (Purchases/Return, etc)
Stock Out ...
0
votes
1answer
123 views
Help me to better design my query so I can gain more performance
I need to find so called first entry in database for items regarding their partners.
I wrote query and it is giving me correct results but it sucks with performances.
I suspect that I have missed ...
1
vote
2answers
477 views
Database normalization: Describing trait - foreign key to table, or varchar field with value?
My colleagues and I are having a discussion about the normalization of descriptive traits in the database, such as "status" or "type". Let's call the central table of the discussion "Order".
In my ...
1
vote
1answer
117 views
Send a trigger to an application upon a specific SQL Server server usage pattern
I've been dealing with a vendor's unconfigurable application which is, unfortunately, the most feature-complete in its niche. I'm looking to augment its capabilities with on-top screen display. Its ...
2
votes
1answer
414 views
Separate Schemas by Industry or by Application functionality?
I currently have a small retail/Point of Sale and an Education application running as on-premise custom solutions for different customers. I am planning to rewrite the app and host as a SaaS/web ...
8
votes
3answers
1k views
What's better for large changes to a table: DELETE and INSERT every time or UPDATE existing?
I am making a project where I need to change around 36K records in one table daily. I'm wondering what will perform better:
delete rows and insert new ones, or
update already existing rows
For me ...
0
votes
1answer
229 views
How could I handle heavy load and consistency for product inventory in online retailers? [closed]
I have posted that question on Stackoverflow and they suggest me to repost my question here, as it would more likely to get help from a DB community (regarding this issue).
Hope you guys don't mind.
...
1
vote
2answers
195 views
Questions about Database Design for a Web Application
Consider a web application with 100,000 users. Each user can create blog posts. Assume each user has 100 entries.
Would it be appropriate to store all the users in one table, with another table to ...
4
votes
7answers
320 views
Policies RE database triggers in well-designed applications?
I've heard all kinds of horror stories around gremlins living in database triggers, and--worse--systems being brought down by the addition of a trigger that caused a chain of cascading ones.
I'm ...
