473,320 Members | 2,189 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Request New Database Procedure

CroCrew
564 Expert 512MB
Hello everyone,

I would like to thank everyone first that reads this post and takes the time to provide me with your view/answer to my question below.

We are starting to apply “Procedures” and “Standards” in our organization that span across each development unit. Currently each unit has their own way of doing business. My question is not about the standards like “Naming Conventions” for tables but, more towards the procedures aspect like how to do something.

I have been tasked with helping create a procedure that when a new application has been requested by a development unit how to handle that request. So I would like to ask any of the people out there that are DBAs in their place of business how do you do accept request? What are your procedures? I am hoping that someone could post an example of a form that they use as their procedure.

Again, thanks for any feedback.

Happy Coding,
CroCrew~
Sep 27 '10 #1
2 166247
maxamis4
295 Expert 100+
This is a good question.

First and far most you have to establish a scope. The biggest issue with development is the scope creep of the project. Gather good requirements and understand what the customer wants regarding the application and what it captures. Commit to that version release as your primary scope. The last thing you want is the scope of your project changing and having to pay twice as much form something that was poorly planned.

The best way to capture these requirements is through work flow. The logic that is applied to your application (keep in mind at this point this is all concept no actual development is done). Many misconstrue work flow as one chart. This is a typical error in all design implementations. Work flow should be established for all aspects of the application include the function that it will perform. This will help identify what fields your database will need and what type of programmatic solutions your database will need.

This is just an overview of how I start projects regarding databases. The topic could go on forever so start with these two since they will encompass a ton of time.
Nov 22 '10 #2
NeoPa
32,556 Expert Mod 16PB
This thread will be closed to avoid further spam posts.

Anyone wishing to contribute may report this post and include their submission (intended post) for review. If it is a serious post then we'll open the thread again to allow the post.
Nov 27 '13 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
by: Adnan | last post by:
I want to read a file list in a directory from a database procedure. I m using Oracle 9i Release 2. How to do??? I don't want to user external procedures. I know it can be done through java stored...
11
by: Leroy | last post by:
Hello, I have a question regarding the maximum number of parameters that can be passed to a procedure. In VB 6 the max was 60. What is the max for Dot Net? please and thanks.
4
by: Jack | last post by:
Hi, I am trying to run an example code from a book. However I am getting the following error message: Number: -2147217900 Description: Syntax error or access violation Source: Microsoft OLE...
3
by: Shiraz | last post by:
Updated to the latest version of DBD-mysql using perl -MCPAN -e "install DBD-mysql" and now the calling mysql function r2() within perl work > $SQL_Text = "select r2() from dual " ; >...
1
by: Alan T | last post by:
Is there a sample code I can use to call a stored procedure which has input and output paramerts ?
1
by: kkubio | last post by:
Hi all, I'd like some advice on adding an extended stored procedure (XP). I found an article which advises "put the call of the extended prodecure within a database procedure in the database from...
0
by: nielsena54 | last post by:
I am currently working on a client-server project using WCF. I have been using .NET for about 3 months now and have some questions about what it can do and how to do it. Before the question, here...
2
by: Lucky | last post by:
Hi guys, I'm having problem with case sensitive collation of SQL Database. one my client is having case sensitive database. While developing the Data Layer i didn't consider this scenario. the...
4
by: vamsioracle | last post by:
Hi all, I have a stored procedure registered with the following details short name: delegateproc executable: delegateproc attached to application developer request group. and i am...
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.