Click here to Skip to main content
15,879,326 members
Home / Discussions / Database
   

Database

 
AnswerRe: can someone please help me to solve the relational algebra equation? Pin
data modeling guy29-Sep-14 6:49
data modeling guy29-Sep-14 6:49 
QuestionPackage executed through SQL SERVER AGENT throwing exception Pin
hemjogi26-Aug-14 2:34
hemjogi26-Aug-14 2:34 
QuestionRe: Package executed through SQL SERVER AGENT throwing exception Pin
Eddy Vluggen26-Aug-14 3:02
professionalEddy Vluggen26-Aug-14 3:02 
QuestionTransactiona Replication Database MSSQL Server 2008 automatic sync Pin
Ahmad Hoshya23-Aug-14 8:48
Ahmad Hoshya23-Aug-14 8:48 
QuestionWriting A Database As Back-End For Application Developed By Others Pin
phil241514-Aug-14 1:41
phil241514-Aug-14 1:41 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
Mycroft Holmes14-Aug-14 4:18
professionalMycroft Holmes14-Aug-14 4:18 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:38
phil241521-Aug-14 5:38 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
jschell15-Aug-14 9:39
jschell15-Aug-14 9:39 
phil2415 wrote:
This morning I've been reading about CRUD and writing RESTful services and so on (not completely understanding it all)


Rest applies to the application server not to the database. The application server deals with a data model where objects in that often but not always map to tables in the database. It that 'not always' part that means that the application server should have its own data model and then map that to the database.

The stored procedures provide the access layer to the database. Far as I am concerned they (stored procs) server the same purpose as any other application layer so I am in favor of them. Additionally I consider the permissions possible with them a win.

phil2415 wrote:
I'm not really sure what they'll be expecting.


First thing of course is that someone, somewhere needs to come up with a data model. Doesn't need to be formal but a team (more than one person) can't work without a division of labor and so they need to target a data model and so do you. You should of course be prepared to participate in that process. You might even be the sole person given that you have experience both in database and application development.

Your role other than that would be in insuring that the data model is not going to impose problems such as performance. Then normal DDL development with any additional database tests (archive, back up, etc) that would normally be identified in any production system.

Depending on the team/project you might also be in charge of writing the application side abstraction layer - the thing that interfaces with the stored proc.

Of course one potential problem with all of the above is that one of the incoming people already has an idea how the database should be done and it doesn't jive with your view.
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:37
phil241521-Aug-14 5:37 
AnswerRe: Writing A Database As Back-End For Application Developed By Others Pin
PIEBALDconsult21-Aug-14 5:11
mvePIEBALDconsult21-Aug-14 5:11 
GeneralRe: Writing A Database As Back-End For Application Developed By Others Pin
phil241521-Aug-14 5:20
phil241521-Aug-14 5:20 
Question(Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 21:45
Jassim Rahma11-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
Kornfeld Eliyahu Peter11-Aug-14 21:58
professionalKornfeld Eliyahu Peter11-Aug-14 21:58 
GeneralRe: (Expiring Next Month) Problem Pin
Jassim Rahma11-Aug-14 23:40
Jassim Rahma11-Aug-14 23:40 
GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 1:42
professionalGuyThiebaut12-Aug-14 1:42 
GeneralRe: (Expiring Next Month) Problem Pin
Bernhard Hiller12-Aug-14 21:28
Bernhard Hiller12-Aug-14 21:28 
GeneralRe: (Expiring Next Month) Problem Pin
GuyThiebaut12-Aug-14 21:45
professionalGuyThiebaut12-Aug-14 21:45 
AnswerRe: (Expiring Next Month) Problem Pin
GuyThiebaut11-Aug-14 22:07
professionalGuyThiebaut11-Aug-14 22:07 
QuestionT-Sql Distribute data into groups based on existing numbers Pin
dreaddan10111-Aug-14 10:42
dreaddan10111-Aug-14 10:42 
AnswerRe: T-Sql Distribute data into groups based on existing numbers Pin
Jörgen Andersson13-Aug-14 22:44
professionalJörgen Andersson13-Aug-14 22:44 
QuestionProblem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd9-Aug-14 23:02
professionalVimalsoft(Pty) Ltd9-Aug-14 23:02 
AnswerRe: Problem with Decimal Places and Rounding off Pin
Kornfeld Eliyahu Peter10-Aug-14 0:00
professionalKornfeld Eliyahu Peter10-Aug-14 0:00 
GeneralRe: Problem with Decimal Places and Rounding off Pin
Vimalsoft(Pty) Ltd10-Aug-14 1:28
professionalVimalsoft(Pty) Ltd10-Aug-14 1:28 
QuestionSelect and Update Pin
jkirkerx8-Aug-14 11:43
professionaljkirkerx8-Aug-14 11:43 
AnswerMy none soup version Pin
jkirkerx8-Aug-14 12:11
professionaljkirkerx8-Aug-14 12:11 

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.