473,700 Members | 2,747 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Request New Database Procedure

CroCrew
564 Recognized Expert Contributor
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 166346
maxamis4
295 Recognized Expert Contributor
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,569 Recognized Expert Moderator MVP
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
4423
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 procedure. Any other solution like a single command......Java code is still ok... Regards, Adnan
11
13417
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
6713
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 DB Provider for SQL Server SQLState: 42000
3
4394
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 " ; > $sth=$dbh->prepare($SQL_Text); > $sth->execute(); > while ( ($tt) = $sth->fetchrow_array( ) ) { print $tt; } for reference here is the mysql Funtion
1
348
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
4434
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 which it will be called". http://www.windowsitlibrary.com/Content/77/20/1.html#1 This sounds like what I want to do, where can I find details on "how to" do this, including granting rights to execute the SP, XP? Running Windows 2000 Server, MS SQL...
0
1311
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 is the process that program follows: 1) A user logs in on a messenger-esque windows application. They are validated using a web service call to a central server. 2) Embedded in the application is a WCF service that exposes certain information....
2
7274
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 problem is I've all Store Procedures in the Database and I'm using sqlcommand to execute those SPs with Parameters. for e.g. Data Layer: ...... SqlCommand cmd = new SqlCommand();
4
3181
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 calling this in plsql:
0
9066
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
8916
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
7802
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6558
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4400
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4652
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
3083
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
2383
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
2022
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.