Products

Evoq Content Overview Content Creation Workflow Asset Management Mobile Responsive Personalization Content Analytics SEO Integrations Security Website PerformanceEvoq Engage Overview Community Management  Dashboard  Analytics  Member Profile Gamification Advocate Marketing Community Engagement  Ideas  Answers  Discussions  Groups  Wikis  Events Mobile ReadyDNN Support PackagesEvoq: CMS FeaturesEvoq OnDemandCompare DNN's CMS Products

Solutions

Content Management SystemMulti-Channel PublishingDigital MarketingOnline Community ManagementIntranet Software SolutionOur CustomersPrime

Resources

Test DrivesSchedule A DemoDocumentation CenterWebinarsWhite PapersProduct ManualsRequest PricingData SheetsCase StudiesEvoq Preferred Products Content Management Ecommerce Forms Identity Management and Authentication Site Management Social Themes

Partners

DNN Partners Partner Directory Become a DNN Partner Partner Program Overview  Hosting  Implementation  ISV  Training  Competencies

Community

Participate Ask a Question Forums Community Showcase DNN MVP  Program Overview  Lifetime MVPs  Honorary MVPs Subscribe to DNN Digest Advisory Groups  Awareness Advisory Group  Developer Advisory Group  Partner Advisory Group  Technology Advisory GroupLearn Documentation Wiki Community Blog Video Library Project History Development RoadmapDownload DNN Store Language Packs Manuals Nightly BuildsSecurity Policies Security Center

Blog

About

News Press Releases News Coverage Press KitCareersContact DNN

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcustom databasecustom database
Previous
 
Next
New Post
8/21/2007 4:28 AM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

to give you a bit mire insight: UDT stores its data in tables at the sql database, but in a specific (serialized) structure, that allows to store different table layout per module in the same database tables. Therefore UDT provides functions to generate the table, add, edit, delete and retrieve the data in it. Please take it as a "separate microcosmos" inside the DNN world, that has only limited options of data level interoperability with other modules (like reports) due to its design.

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
9/26/2007 3:15 PM
 
OJ Nordhagen

Joined: 9/18/2007
Posts: 39

leupold wrote

to give you a bit mire insight: UDT stores its data in tables at the sql database, but in a specific (serialized) structure, that allows to store different table layout per module in the same database tables. Therefore UDT provides functions to generate the table, add, edit, delete and retrieve the data in it. Please take it as a "separate microcosmos" inside the DNN world, that has only limited options of data level interoperability with other modules (like reports) due to its design.

Interesting information there Leupold! What are the pros and cons in short to this in-house solution. Is this in any way a more efficient than providing a standardized SQL-based solution that anybody could build on and develop? Just curious! Regards, OJ, Stavanger.
 
New Post
9/28/2007 6:18 PM
 
lauren meyers

Joined: 9/18/2003
Posts: 40

I had the same issue--needing to report on UDT data. Feel free to check out my post and free download:  http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/56/threadid/170387/scope/posts/Default.aspx  or http://dnn.microssoftware.com
 
New Post
9/28/2007 7:14 PM
 
Sebastian Leupold


Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

Sebastian Leupold's Avatar

www.dnnwerk.de
Joined: 3/8/2004
Posts: 46212

ojnord wrote

 leupold wrote

 

to give you a bit mire insight: UDT stores its data in tables at the sql database, but in a specific (serialized) structure, that allows to store different table layout per module in the same database tables. Therefore UDT provides functions to generate the table, add, edit, delete and retrieve the data in it. Please take it as a "separate microcosmos" inside the DNN world, that has only limited options of data level interoperability with other modules (like reports) due to its design.

 

Interesting information there Leupold! What are the pros and cons in short to this in-house solution. Is this in any way a more efficient than providing a standardized SQL-based solution that anybody could build on and develop? Just curious! Regards, OJ, Stavanger.

OJ,

you obviously missed my UDT session at OpenForce '07 Europe conference last week...

major advantage of the serialized storage is the fact, that there is no need to create a custom table whenever a module is created - which may be limited by the sysadmin to module installation only. Serialized storage is less efficient for densely populated tables, because there are two extra indexes FK fields per value, but for records with an number of columns of which only few values are filled, serialized storage is more efficient. However there is always a (small) overhead during loading and saving data, as well as the difficulties to access the data directly using standard approaches - as you already noticed.

HTH

Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
10/3/2007 3:34 PM
 
Pril

Joined: 1/25/2005
Posts: 150

You can try third-party module like http://components.init.si/

Kind regards,

Primoz



www.indoolab.com
 
 Page 2 of 2
Previous12 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and Listcustom databasecustom database


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out