blueCubs.com Forum Index Portal
 FAQ  •  Search  •  Preferences  •  Usergroups  •  Register  •  Profile  •  Log in to check your private messages  •  Log in
Calendar 

How to find attributes on the database

Users browsing this topic:0 Registered, 0 Hidden and 1 Guest
None		 View next topic
View previous topic
Post new topicReply to topic blueCubs.com Forum Index » blueCubs.com Products + Services » xinco DMS [ eXtensible INformation COre ] - FAQ » How to find attributes on the database View previous topicEmail to a Friend.List users that have viewed this topicSave this Topic as filePrintable versionLog in to check your private messagesView next topic
Author Message
cartilage



Joined: 13 Apr 2009
Posts: 1

blank.gif
PostPosted: Tue Apr 14, 2009 12:13 pm  Post subject:  How to find attributes on the database Reply with quoteBottom of PageBack to top
Hi,

i've read that all values of the attributes are stored in xinco_add_attribute. But if i define a keyword as 'test', how to find this value in the database?
I want other applications with access to the database to capture those values.
Is this even possible?

I'm thankful about every single hint!

Cheers
   OfflinePersonal Gallery of cartilageView user's profileSend private message
alex
 Administrator
Administrator


Age: 29
Joined: 19 Sep 2004
Posts: 535
Location: Remseck, Germany
germany.gif
PostPosted: Mon Apr 20, 2009 5:58 pm  Post subject:   Reply with quoteBottom of PageBack to top
Indeed all attributes are stored in the table "xinco_add_attribute".
They are linked to data in table "xinco_core_data" with the field "xinco_core_data_id".
Data is linked to folders in table "xinco_core_node" with the field "xinco_core_node_id".

With this information you can write SQL to find and retrieve any data and its attributes.
Aries Gender:Male Cock OfflinePersonal Gallery of alexView user's profileSend private messageVisit poster's website
javydreamercsw
 Moderator
Moderator


Age: 31
Joined: 14 Jun 2006
Posts: 398
Location: Texas
puertorico.gif
PostPosted: Sat Jan 09, 2010 6:04 am  Post subject:   Reply with quoteBottom of PageBack to top
Just as a hint, the next version 2.1.0 will use JPA for DB access. Feel free to request a feature. I'm leaning to do the reporting with iReports/Jasper and expose the database with the persistence definition interface so anyone can do custom Reports. Jasper 3.0.0 supports this!
_________________
Glad to help always!

Learn more from me at: https://www.ohloh.net/accounts/javydreamercsw
Virgo Gender:Male Horse OfflinePersonal Gallery of javydreamercswView user's profileSend private messageSend e-mail
heronfisher


Age: 30
Joined: 12 Mar 2010
Posts: 4
Location: london
algeria.gif
PostPosted: Fri Mar 19, 2010 2:15 pm  Post subject:   Reply with quoteBottom of PageBack to top
Sometimes the index picked is a dog and just does not work very well. Most indexes are supposed to contain attributes that have a large number of values evenly spread over the domain of attribute values. This allows the optimizer to get the fastest search plan for the retrieval of data. Well, sometimes the index attributes have very few values and are not good. This script helps to show the order and cardinality of the attributes in an index so the DBA can assess whether this index is worth the overhead. This script is dependent on runing the analyze utilities to load statistics for the SQL optimizer.

On some small tables, who cares, you do not even need an index. On other large tables an index will make a huge difference. This script helps me decide if the index will be useful. Why create an index if there is only a couple values in the domains of the attributes chosen, it will just add overhead to most queries.
_________________
m3i zero
Capricorn  Goat HiddenPersonal Gallery of heronfisherView user's profileSend private messageSend e-mail
Display posts from previous:      
Post new topicReply to topic blueCubs.com Forum Index » blueCubs.com Products + Services » xinco DMS [ eXtensible INformation COre ] - FAQ » How to find attributes on the database View previous topicEmail to a Friend.List users that have viewed this topicSave this Topic as filePrintable versionLog in to check your private messagesView next topic


 Jump to:   





View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum


All times are GMT + 1 Hour
Powered by phpBB2 Plus 1.52 and Hostinginfo based on phpBB © 2001, 2002 phpBB Group :: FI Theme :: Mods and Credits