The result of database design is a plan for the construction of a database that captures some of the essential features of the proposed database, but omits a lot of less important detail. These plans often take the form of data models, and database design can be learned as the art of constructing a ...
2
votes
2answers
74 views
Looking for example design of using an SQL database as a queue for throttling web service requests of multiple users
I'm designing a system for multiple users to queue their requests to a web service which takes requests such as creating new entries, changing entries, requesting data. Many of the web service calls ...
-1
votes
1answer
28 views
Write Access Client App for SQL Server 2005 Backend [closed]
I'm writing an inventory/payroll system, and I'm storing all the records on a remote server running SQL Server 2005 on Windows Server 2008 R2. I was wondering how I could start writing forms(very ...
0
votes
2answers
33 views
schema analyzer tool
I am currently using TOAD to connect to the database. I have around 20 tables that I have been asked to analyze ( I am new to project ). I think the first place to start is to understand the relation ...
2
votes
1answer
55 views
What are the limitations of Toad for SQL Server freeware?
I just downloaded the freeware version of Toad for SQL Server. Toad's download site says: "the Freeware edition has certain limitations, and is not intended to be used as a TRIAL for the Commercial ...
14
votes
4answers
118 views
Database design: how to handle the “archive” problem?
I'm pretty sure a lot of applications, critical applications, banks and so on do this on a daily basis.
The idea behind all that is:
all the rows must have a history
all links must stay coherent
it ...
0
votes
1answer
26 views
How do you query supertypes to get subtype data?
I'm a bit of a DBA newbie here (coming from a programming background having to fill the role of a DBA), so please excuse by blantant and somewhat basic ignorance.
Using a simple relationship between ...
1
vote
1answer
43 views
Weak entity and one-one or many-many relationship
In Entity Relationship Model, can the supporting (or identifying) relationships of the weak entities be many-many or one-one rather than many-one?
Suppose I have a customer entity (C), a video entity ...
0
votes
2answers
63 views
What is a common way to save 'debit' and 'credit' information?
I'm working on an accounting system, and for each transaction I need to save if this is either debit or credit. I can think of two ways (MySQL database):
METHOD 1
Amount (decimal)
Type (enum, ...
3
votes
1answer
49 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
18 views
mysql picasa like photo tags store and query [closed]
I want to make a photo website, allow users to upload photos and write 1-10 customs photo tags, like picasa. I use mysql.
Tags could be words or short sentence, but total length can not over 80 ...
2
votes
3answers
153 views
How costly is opening and closing of a DB connection?
How CPU intensive is opening and closing of a DB connection (for a web app) in MySQL
... when the DB software is on localhost?
... when the DB software is on another machine?
5
votes
1answer
45 views
Database Design: Linking 'vague' entries to associations?
Experienced developer, inexperienced DBA here.
I'm currently working on a project that lets users input the names of freight vehicles for particular packages. Eg:
Company: White Star Line
Vehicle: ...
2
votes
1answer
29 views
Is a year-to-date dimension the same as a time dimension?
If I have a table such as...:
YYMM | Sales
------------
1201 | 10
1202 | 20
1203 | 30
1204 | 40
... then I might describe this as having a time dimension. If I wanted to calculate a year-to-date ...
1
vote
2answers
68 views
How can you have two auto-incremental columns in one table?
I have a MySQL table that contains information on invoices of a company. However, this company has two branches, and each of them has a unique invoicing sequence; a "Serie A" and "Serie B", so to ...
2
votes
2answers
51 views
Data type for currency 'type' column, e.g. usd, cat, etc.
I am setting up a MySQL database for accounting software. One of the fields is to save the currency used for each transaction. What field type would you recommend? Details:
No more than 10 different ...
