473,322 Members | 1,379 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,322 software developers and data experts.

design of application / schema / multiple development schemas

bdj
Hello!
Can anyone tell me where to read more about best practices about this:

Should I put data in a seperate scheme for tables,
packages in anoter schema
and create a lot of users that have access to (some) packages.

When the tables are in anoter schema than the packages, where should the
table-API (generated from Designer) be?

Or should i just put data and package in the same schema an create a lot of
users that have access to (some) packages?

How to support multiple developer-teams that wish to access the same tables
during development (they should work with different sets of data)?
One (bad) 'solution' is having multiple instances with its own
database-files on the same machine, but then you will get an
performance issue by wasting memory.

Greetings
Bjørn
Jul 19 '05 #1
1 4574
bdj wrote:
Hello!
Can anyone tell me where to read more about best practices about this:

Should I put data in a seperate scheme for tables,
packages in anoter schema
and create a lot of users that have access to (some) packages.
Security manuals, probably. And yes, the above scenario is valid
in some cases.
For one, it is relative easy to split the app into a database part
(tables, table API) and an application server part (users/access and
the replacement for the packages, like Java).

The general consensus seems to be to 'let the database do, what the
database does best', and that would be process data.
So, do *not* fetch record-for-record into an array on the app. server,
and sort it there - let Oracle do that. You might find it easy to
use packages for that purpose, maybe in addition to the TAPI, and
whatever you use on the app. server.
When the tables are in anoter schema than the packages, where should the
table-API (generated from Designer) be? I would see that as one complete unit, so the API would be in the
same schema as the tables. You may find otherwise, and separate the
TAPI from the tables (and possibly, from the interface packages).

Or should i just put data and package in the same schema an create a lot of
users that have access to (some) packages?
What suits your environment/client(s) best.
It all depends.

How to support multiple developer-teams that wish to access the same tables
during development (they should work with different sets of data)?
One (bad) 'solution' is having multiple instances with its own
database-files on the same machine, but then you will get an
performance issue by wasting memory.


I find that a perfectly acceptable solution for development, if the
above is the case. Actually, I do not see a single instance scenario,
where different teams will access that *same* tables.

Multiple instances will allow for typical development scenarios
like bouncing without disrupting the other workers.
Also, source control would be tighter, as you may force the
delivery of installation/modification scripts over the instances.

I would worry about your code base/source control, having
different groups of developers, working on the same product.

--
Regards,
Frank van Bortel
Jul 19 '05 #2

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

Similar topics

3
by: Davide Bedin | last post by:
I have a "library" schema with the simple and complex types I commonly use in other schemas and then several other schemas, maybe created by other developers, that import/include the library...
4
by: bibsoconner | last post by:
Hi, I hope someone can please help me. I'm having a lot of trouble with schema files in .NET. I have produced a very simple example that uses "include" to include other schema files. It all...
5
by: Jeff | last post by:
We are using .Net and the wsdl Utility to generate proxies to consume web services built using the BEA toolset. The data architects on the BEA side create XML schemas with various entities in...
0
by: vihrao | last post by:
I am designing wsdl that uses multiple schemas. I can do this in two ways: 1) use multiple schema imports in one wsdl or 2) use multiple schema imports in to one common schema and then import a...
5
by: paul_zaoldyeck | last post by:
does anyone know how to validate an xml file against multiple defined schema? can you show me some examples? i'm making here an xml reader.. thank you
0
by: YellowFin Announcements | last post by:
Introduction Usability and relevance have been identified as the major factors preventing mass adoption of Business Intelligence applications. What we have today are traditional BI tools that...
2
by: olympus_mons | last post by:
Hi, I'm just discovering the power of xsd.exe, so maybe I'm doing something wrong. schema files describing requests and responses. So there is an extra xsd file for each response and each...
12
by: nyathancha | last post by:
Hi, I have a question regarding best practices in database design. In a relational database, is it wise/necessary to sometimes create tables that are not related to other tables through a...
1
by: bdj | last post by:
Hello! Can anyone tell me where to read more about best practices about this: Should I put data in a seperate scheme for tables, packages in anoter schema and create a lot of users that have...
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
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...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
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
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...

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.