Blog - Table Spelunking - New Tables in DotNetNuke Database as of V5.3

Table Spelunking - New Tables in DotNetNuke Database as of V5.3

Mar 29

Written by: host
Monday, March 29, 2010 8:24 PM

Spelunking is another term for caving - according to Wikipedia, the British also call it potholing (Really?). I often relate the idea of discovering what may lie ahead in an underground cave to the effort of discovering what exist in a new database and related tables. I also like the name - Spelunking! But then again people have often said I was “different”.

With the release of DotNetNuke Version 5.3, the database has two table groups centered around the ContentItems and Taxonomy_Terms tables.

Let look at the Taxonomy tables first. The taxonomy tables define the categorization of terms into various Vocabularies. The vocabularies can be either lists or trees. The support for the different organization of vocabularies is maintained in the table structure. From a database point of view rather straight forward data storage for a define purpose.

However, the other tables based on the ContentItems seem a little different. The ContentItems table maintains information regarding the various tabs and modules on the site. (Remember that in the database the use of tab is equivalent to page and for historical reasons the page id’s are called tabid.)

So you will find information about pages and the modules on the pages. However the table structure is open ended in that the content type is defined in a support table – currently there is only two types defined – tabs and modules. So is it possible that additional content may be defined in the ContentItems table in the future – or in the PE version of DotNetNuke?

Also of interest in the ContentItems table are two columns – ContentKey and Indexed. Neither of these fields seems to be used at the moment. The ContentKey is a nvarchar value that could possibly contain the explicit key reference to a part of a modules data – say a blogid? The indexed field is a bit value so it is either 0 or 1. Could this information be indexed by the Search engine? This seems not to be the case in the current version of the Community Edition of DotNetNuke.

Lastly, there is a link between the two table groups – the table Content_tags maintains a reference to Taxonomy_Terms for ContentItems of type Tab (aka Page). So you will be able to search for pages based on a selected taxonomy term -- soon?.

Aslo of note is a subtle change in the database naming convention. Underscores are now appearing in the database table names. Nothing wrong with that – it’s just “different”.

Paul.

Trackback Print

Location: Blogs

DNN Musings

Tags:

4 comment(s) so far...

Re: Table Spelunking - New Tables in DotNetNuke Database as of V5.3

It's great to hear from you and see what you've sent up to. All of the projects look great! You make it so simple to this. Thanks

By abercrombie and fitch on Sunday, January 29, 2012 1:37 AM

Re: Table Spelunking - New Tables in DotNetNuke Database as of V5.3

All of the projects look great! You make it so simple to this. Thanks

By abercrombie fitch on Sunday, January 29, 2012 1:38 AM

Re: Chinese Footware - and the removal of...

GameCoach Factory Outlet Onlineare usuallyCoach Factoryin By Coach Outlet Online on Thursday, February 02, 2012 1:30 AM

beats by dre uk

The author of the paper joint, Cornell university application and engineering physics institute scientists morty-Fred mann according to design a special method, "this method through the change of laser beam frequency and wavelength, Cheap Beats By Dre so the spread in different rate, thus produce a (time) gap." Then, time holes on the other side of the second pulse laser beam, this bunch of pulse laser the function of the one is in the opposite direction to change the attributes of the laser beam, so that the laser beam back to the original attributes. In the experiment, occurs in time of vulnerability of events, can escape the probe detection.
University of rochester institute of optics scientists ShiZhiMin (Zhimin Shi) said, "this is the first real time gap between the produce experiment, is also the first realize objects in space and in time and invisible experiment." ShiZhiMin was not involved in the study.
Although the study is still in the early stages, but this time to the operation will has a broad prospect of application. ShiZhiMin said, "I believe, may the people do not have to this kind of technology exactly how much use thinking too much. auriculares beats Maybe people thinks of above all is to let something invisible don't be detected, or intentionally let some event in 'the cloak of'."
However, time lens technology and may be quietly to the continuous flow of data to insert specific information, this behaviour can be perfect, and it is hard to find. Fred mann explains, "I think you can bring some data is coming into the hidden in optical fiber in data flow. Using the time lens, beats by dr dre australia you can follow one's inclinations to manipulate data, they may be reduction."
Experts think, the technology will can be applied to the research and development due to chip, speed up the Internet and computer internal data and data flow processing speed. ShiZhiMin says, beats by dre headphones any application will depend on whether to expand the time holes. In addition, in the present experiment, simply by a single laser experiments, and the actual application to consider three dimensional light from different point of view to illuminate. ShiZhiMin think, Cornell university experiment has taken the first step in the key.

beats by dre
beats by dre australia
beats by dre outlet
dre beats
beats by dr dre australia

By beats by dre uk on Friday, February 03, 2012 1:28 AM

Your name:
Your email:
	(Optional) Email used only to show Gravatar.
Your website:
Title:
Comment:

Security Code Enter the code shown above in the box below
Add Comment Cancel