Dynamic Field DB Schema Brainstorming

Hello -
Have a project where we are going to build a form creation application. (ASP.NET). This will allow an administrator to build a form on the fly - this form will appear on the front end of the site.
This is a fairly common thing. Are there any resources out there as to where to start designing the DB schema? I'm not looking to reinvent the wheel. Here's the basic objects I'm seeing:
Tables
Forms
FormFieldNames
FormFieldTypes
FormFieldJS
Any tips on the right direction to go?
Thanks
Rob
Try the link below and right click to download the PPT slides for datamodeling. The key to data modeling is files and associations, that means you may have fifty files but you may only have three tables based on files association. The table relationship is determined by upper and lower bound cardinality and it is not complicated. There are six complete database catalogs in the book. Hope this helps.

http://wings.buffalo.edu/mgmt/courses/mgtsand/data.html|||

Thanks for the resource, good stuff - organized nicely. I was looking specifically to my example, so I didn't plow through an ERD of what's already out there, thankx.

|||A relational database sounds like a completely inapropiate tool to build this application you're looking to build. When you are using a RDBMS, you need to know what data you are modeling. You can't just try to make it up on the fly.
You need to consider other solutions, technologies, tools. XML may be suited formatted for this -- the administrator would define an XML schema (possibly through your tool) and then build a form to input data to create XML documents that conform to the schema.
No less, any time I see anyone try to do this in a RDBMS, it falls apart in less than a year -- if it ever makes it out of development.|||

Sounds like you're both directing me the same way - a relatively small DB schema that holds the forms, the fields, and descriptive text for the fields, etc. The actual field types, values, javascript, etc... should be in a bunch of files that describe each fieldID, most likely in XML.

Thank you for that. We were thinking about compiling a bunch of .JS files for each field, and then one large.js file for the form aggregate fields. But XML would make more sense for the fields' descriptive data I believe, no?

Dynamic Data Source

Hi All,
In my project there is separate database for each client.
Based on the client i need to connect to the corresponding database and use
that as the data source to generate Report.
Is it possible to have dynamic data source without deploying all the reports
with different ds for all the clients.
Kindly let me know how to proceed ...
looking forward to your replies
ThanksYou can use data source expression since it will be executed at run time.
e.g="data source=" &Parameters!ServerName.Value & ";initial
catalog=AdventureWorks, the same can be for catalog as well.
But for your problem, you cant allow the user to select the dat source in
the form of a drop down.
If I have understood correctly, you need, depending on the users the DB
should be selected automatically. you can write custom code through asp.net.
infact this will be pretty simple.
Amarnath
"Toby" wrote:
> Hi All,
> In my project there is separate database for each client.
> Based on the client i need to connect to the corresponding database and use
> that as the data source to generate Report.
> Is it possible to have dynamic data source without deploying all the reports
> with different ds for all the clients.
> Kindly let me know how to proceed ...
> looking forward to your replies
> Thanks
>

Dynamic Create Table in Stored Procedure

Hi,
Sorry, I know this is a very easy question.
I as a amature SQL learner because of my college project have to create a stored procedure in a SQL SERVER Database with this condition :
-get Columns and datatypes as parameters like this :
col1,datatupe1,col2,datatype2,...
-create table with this properties ... .
I have some problem about syntax. :o
I would appreciate your help.Why don't you cut and paste the assignment as is so we can all see it.

Better yet, why don't you go to a lab and ask for help?

I find it very hard to believe that the assignment is to build objects dynamically.

What school did you say this was?

Dynamic connection to sql database via Access 2k7 project

I am using SQL server 2005 with multiple client databases with the identical
structure. Is it possible to disconnect from one database and connect to
another within the same ACCESS 2007 project? In Access 2007 connecting to
the database through an ODBC connection (with linked tables) is slower. I
would like to have the direct access for speed purposes. Any help on this
qould be greatly appreciated.
Refer to the following article:
How to programmatically change the connection of a Microsoft
Access project
http://support.microsoft.com/kb/306881
-Sue
On Tue, 5 Jun 2007 17:11:00 -0700, Ed C <Ed
C@.discussions.microsoft.com> wrote:

>I am using SQL server 2005 with multiple client databases with the identical
>structure. Is it possible to disconnect from one database and connect to
>another within the same ACCESS 2007 project? In Access 2007 connecting to
>the database through an ODBC connection (with linked tables) is slower. I
>would like to have the direct access for speed purposes. Any help on this
>qould be greatly appreciated.

Dynamic connection to sql database via Access 2k7 project

I am using SQL server 2005 with multiple client databases with the identical
structure. Is it possible to disconnect from one database and connect to
another within the same ACCESS 2007 project? In Access 2007 connecting to
the database through an ODBC connection (with linked tables) is slower. I
would like to have the direct access for speed purposes. Any help on this
qould be greatly appreciated.Refer to the following article:
How to programmatically change the connection of a Microsoft
Access project
http://support.microsoft.com/kb/306881
-Sue
On Tue, 5 Jun 2007 17:11:00 -0700, Ed C <Ed
C@.discussions.microsoft.com> wrote:

>I am using SQL server 2005 with multiple client databases with the identica
l
>structure. Is it possible to disconnect from one database and connect to
>another within the same ACCESS 2007 project? In Access 2007 connecting to
>the database through an ODBC connection (with linked tables) is slower. I
>would like to have the direct access for speed purposes. Any help on this
>qould be greatly appreciated.

Dynamic Columns & Dynamic Grouping ?

Hi,

We need to design more than 500 Reports for our ongoing project and we are dealing with MS SQL Server Reporting Services first time. We are currently confused in 2 things

1) How to manage Reports? I mean we should store entire report in database and load at runtime or simply store as a report file

2) Most Important is Dynamic Columns & Dynamic Grouping.

We need something like Microsoft Office Accounting 2007 Reports. Header part of form has some parameters for filter and right part has some parameters for showing or hiding and reordering columns and groups.

We are not getting clue for this dynamic stuff. Can any one post working sample or at least necessary basic code with some idea?

Reply on Urgent Basis

Thanks lot

Someone Please Help

If I have posted in wrong forum then suggest the correct one.

Dynamic (user requested) Dimension

In our project, we constantly have the need to analyse the data in the cubes, but with "restricted" dimension... maybe an example helps:

Like this: "Get the total for orders, but only those placed on a Wednesdays". This would be an easy task, since you only have 7 weekdays. In your cube browsing frontend you simply click away the 6 you do not need, and there is your result.

Now imagine you get a list of 10,000 Customer IDs, or maybe 30,000 Invoice IDs, or only 300 Product IDs that shall be used to restrict the space in which all further analysis takes place. No one wants to (manually) select 10,000 items out of a list of 2.5 million... even selecting the 300 Products out of the Products list (2,500 items) is a task you cannot really explain to someone.

The content of the lists do change, but not very frequent. IF the lists are changed however, they are changed completly, not just added upon! These special jobs happen maybe once a week, and are started only by one user at a time. So there is no need to make this work with several different lists at once or so.

Currently, I am importing the list into SQL Server, then build a query "joining" the list with my tables so I get the restricted data, and then recreate all groupings and calculations the cube does by manual SQL - the last part is the really bad job.

What can be done to have a dimension (or in this case, 3 lists = 3 dimensions) in the cube whose content is based on an "external" list that changes from time to time?

I will solve the "external" part first by creating a either mail-in or html form to upload a txt list file to the server and then run a SSIS package to import the data so it is part of the database - no problem there!

How would "intelligent" processing of this dimension and the cube be handeled? I understand it that "dimension update processing" is not possible, as the content can be totally different. Doing "dimension full processing" will solve that, but require a "full cube processing" as well?

Hi Ralf,

try to have a look at this precious document by Marco Russo and check the Multiple Groups chapter, probably is what you're looking for:

http://www.sqlbi.eu/Portals/0/Downloads/M2M%20Revolution%201.0.93.pdf