Click here to Skip to main content
15,867,488 members
Home / Discussions / Database
   

Database

 
GeneralRe: database auto-growth setting Pin
kyi kyi11-Apr-14 0:04
kyi kyi11-Apr-14 0:04 
Questiongetting last inserted row Pin
Member 1026351910-Apr-14 22:05
Member 1026351910-Apr-14 22:05 
AnswerRe: getting last inserted row Pin
Peter Leow10-Apr-14 22:18
professionalPeter Leow10-Apr-14 22:18 
GeneralRe: getting last inserted row Pin
Member 1026351910-Apr-14 23:01
Member 1026351910-Apr-14 23:01 
GeneralRe: getting last inserted row Pin
Mycroft Holmes11-Apr-14 2:30
professionalMycroft Holmes11-Apr-14 2:30 
AnswerRe: getting last inserted row Pin
Bernhard Hiller10-Apr-14 23:17
Bernhard Hiller10-Apr-14 23:17 
QuestionDatabase Planning Pin
Sea_Sharp10-Apr-14 6:03
Sea_Sharp10-Apr-14 6:03 
AnswerRe: Database Planning Pin
Eddy Vluggen10-Apr-14 7:17
professionalEddy Vluggen10-Apr-14 7:17 
Sea_Sharp wrote:
1. All employees will need to be able to access the
data from reports easily and quickly without having to memorize commands
That means you need a UI. That probably means you'd need to write one, generate one, or use Access as your front-end.

Sea_Sharp wrote:
2. Data will come from 4 sources.
The database doesn't care where the data comes from. A is a simple import-operation. B and C cannot be automated, someone will have to enter the data. D is missing.

Sea_Sharp wrote:
3. Data will need to auto-generate reports.
Data doesn't do things, it just sits there. Databases are also usually not responsible for generating a report; you will probably need to create a report-template that gets filled dynamically, with a filter for each property. I'd put the database in SQL Server, link from Access to it, and exclaim it's "done". Access has a low learning-curve and everyone could click together the reports as they see fit. Excell could probably do the same.

Sea_Sharp wrote:
4. Data will need to be backed up often (at least once maybe more per day, to prevent data loss or erroneous operations
Backups do not prevent errors; any error gets backed up along with the rest of the data. Any major database-server supports backup-operations.

Sea_Sharp wrote:
In terms of importance I believe it should be arranged in the following hierarchy
It doesn't work that way. There's a comparison of database-servers here[^] - take a look at the capabilities, compare them to your needs, pick one. And make sure it is SQL Server that you pick. SQL Server Express is free, you could design your db in Access (and have a working Access-db as a backup if this experiment fails), and simply import it in SQL Server when you're ready (using the upsize-wizard in Access)

"No bugs" is something that can never be guaranteed in complex systems; there's however a difference in patch-frequency. I know most people disable their auto-update, but I kinda like being updated regularly.

You can also safely assume that databases store data without loss, unless it's beta-software. And yes, all major database-servers return data on simple queries in nearly no time.
Bastard Programmer from Hell Suspicious | :suss:
If you can't read my code, try converting it here[^]

GeneralRe: Database Planning Pin
Jörgen Andersson10-Apr-14 7:36
professionalJörgen Andersson10-Apr-14 7:36 
GeneralRe: Database Planning Pin
Sea_Sharp10-Apr-14 9:06
Sea_Sharp10-Apr-14 9:06 
AnswerRe: Database Planning Pin
Eddy Vluggen11-Apr-14 9:09
professionalEddy Vluggen11-Apr-14 9:09 
SuggestionRe: Database Planning Pin
Kornfeld Eliyahu Peter10-Apr-14 7:45
professionalKornfeld Eliyahu Peter10-Apr-14 7:45 
AnswerRe: Database Planning Pin
Mycroft Holmes10-Apr-14 13:05
professionalMycroft Holmes10-Apr-14 13:05 
QuestionMySQL Create every Sun for date = xx Pin
Jassim Rahma9-Apr-14 1:46
Jassim Rahma9-Apr-14 1:46 
AnswerRe: MySQL Create every Sun for date = xx Pin
Eddy Vluggen9-Apr-14 3:00
professionalEddy Vluggen9-Apr-14 3:00 
GeneralRe: MySQL Create every Sun for date = xx Pin
Jassim Rahma10-Apr-14 1:09
Jassim Rahma10-Apr-14 1:09 
AnswerRe: MySQL Create every Sun for date = xx Pin
Mycroft Holmes9-Apr-14 13:01
professionalMycroft Holmes9-Apr-14 13:01 
Questioncan I trust Triggers? Pin
Jassim Rahma9-Apr-14 1:04
Jassim Rahma9-Apr-14 1:04 
AnswerRe: can I trust Triggers? Pin
thatraja9-Apr-14 2:16
professionalthatraja9-Apr-14 2:16 
GeneralRe: can I trust Triggers? Pin
Bernhard Hiller9-Apr-14 22:23
Bernhard Hiller9-Apr-14 22:23 
GeneralRe: can I trust Triggers? Pin
thatraja10-Apr-14 21:06
professionalthatraja10-Apr-14 21:06 
QuestionRe: can I trust Triggers? Pin
Eddy Vluggen9-Apr-14 3:00
professionalEddy Vluggen9-Apr-14 3:00 
AnswerRe: can I trust Triggers? Pin
jschell10-Apr-14 8:53
jschell10-Apr-14 8:53 
GeneralRe: can I trust Triggers? Pin
Jassim Rahma12-Apr-14 1:36
Jassim Rahma12-Apr-14 1:36 
QuestionTrigger on select Pin
Jassim Rahma9-Apr-14 1:00
Jassim Rahma9-Apr-14 1:00 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.