search

LucidDB / luciddb

DEFUNCT: See README
https://github.com/LucidDB/luciddb
Apache License 2.0
52 stars 24 forks source link

[DDB-24] Historical Data Pentaho plugin #51

Open dynamobi-build opened 12 years ago

dynamobi-build commented 12 years ago

[reporter="ngoodman", created="Fri, 5 Mar 2010 06:43:07 -0800"]

Create Pentaho Plugin that

Create a Pentaho extension that:

dynamobi-build commented 12 years ago

[author="ngoodman", created="Fri, 5 Mar 2010 06:51:15 -0800"]

re: PUC plugin

dynamobi-build commented 12 years ago

[author="ngoodman", created="Fri, 5 Mar 2010 07:15:11 -0800"]

Some notes from meeting with Will Gorman on classes/implementation:

bi-platform-engine-services
org.pentaho.platform.engine.services.connection.datasource.dbcp package
PooledOrJndiDatasourceService

pentaho-solutions/system/pentahoObjects.spring.xml

edit the to make it ours

class="org.pentaho.platform.engine.services.connection.datasource.dbcp.PooledOrJndiDatasourceService" scope="singleton" />

dynamobi-build commented 12 years ago

[author="ngoodman", created="Fri, 5 Mar 2010 07:40:14 -0800"]

An example of a menu plugin in Pentaho.

The list of things (Repository Cache, System Settings, etc) will be the names of labels. The currently active label, should have a check box by it (which one is active.

Default (no label) shoudl be at top

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 8 Jun 2010 20:25:28 -0700"]

This issue is the master issue. The other two are the corresponding work items. However, the DBCP approach identified in DDB-19 may not be the solution. See email with meeting for wgorman for an alternative approach.

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 8 Jun 2010 20:28:07 -0700"]

The plugin structure should driven by both Pentaho configured datasources that are LucidDB, and the labels in each of those LucidDB nodes.

ie,

Set Data History

Each database can have a different label set.

Distinct set of labels are determined from sys_root.dba_labels.
Active label with every checked out connection should be set using 'alter session set label '"quotedlabel"'

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 8 Jun 2010 20:29:30 -0700"]

Also... a session cross cutting SQL injection method would probably be of interest to Pentaho engineering in general. Any chance of making this relatively "generalized" so that the SQL executed during connection "checkout" can be parameterized, and configured this may be useful for other people. Oracle VPD, etc

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 8 Jun 2010 20:40:25 -0700"]

Some resources:
http://pub.eigenbase.org/wiki/LucidDbWarehouseLabels
http://pub.eigenbase.org/wiki/LucidDbSystemViews#DBA_LABELS

dynamobi-build commented 12 years ago

[author="ngoodman", created="Fri, 30 Jul 2010 08:24:12 -0700"]

default label is "";

dynamobi-build commented 12 years ago

[author="ngoodman", created="Wed, 4 Aug 2010 07:20:45 -0700"]

spec from dev team

dynamobi-build commented 12 years ago

[author="ngoodman", created="Wed, 4 Aug 2010 07:39:02 -0700"]

dynamobi-build commented 12 years ago

[author="ngoodman", created="Mon, 9 Aug 2010 11:25:02 -0700"]

from suresh

dynamobi-build commented 12 years ago

[author="ngoodman", created="Mon, 9 Aug 2010 11:25:19 -0700"]

from suresh

dynamobi-build commented 12 years ago

[author="ngoodman", created="Mon, 9 Aug 2010 11:26:00 -0700"]

making you assignee

dynamobi-build commented 12 years ago

[author="ngoodman", created="Mon, 9 Aug 2010 11:33:05 -0700"]

Suresh-

re: HLD update. It still contains the following statement which is incorrect:
"This should globally change their label in all connections to the database and enable them to change Pentaho to go back in time."

Please confirm that you have captured req'mnt each database connection can have an active label, and that there's not one for the session, but rather one per session/connection.

Yes, I meant one per session/connection..(Suresh)

dynamobi-build commented 12 years ago

[author="ngoodman", created="Mon, 9 Aug 2010 11:37:48 -0700"]

re: Detailed Design

select LABEL_NAME, CREATION_TIMESTAMP FROM DBA_LABELS

should be

select LABEL_NAME, CREATION_TIMESTAMP FROM SYS_ROOT.DBA_LABELS

Let's make the WHLabelDataSourceService a bit more generalized. Let's do SQLInjectionDatasourceService as an abstract class, and make WHLabelDataSourceService extend it. Make all the connection snagging, SQL execution happening on connection happen in base class, but do the specific SQL (and session access, label, etc) in the specialized. This way, someone can use SQLInjectionDatasourceService outside of LucidDB.

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 10 Aug 2010 23:25:25 -0700"]

Suresh - regarding the issue you saw re: the driver and administration console.

I downloaded a fresh biserver-ce-3.6.0 and dropped in 0.9.3 LucidDbClient.jar into the jdbc folder of the administration-console and the proper driver (org.luciddb.jdbc.LucidDbClientDriver) showed up in the list.

Can you please do a little more debugging to see why it is not showing up on your server? If there is a bug (in Pentaho or our driver) we'd like to get it resolved...

dynamobi-build commented 12 years ago

[author="suresh", created="Thu, 12 Aug 2010 06:33:16 -0700"]

regarding the issue : the driver and administration console

I did few workarounds on this issue and I found that the driver class (org.luciddb.jdbc.LucidDbClientDriver) is detected in Linux machine but not in Windows,
This issue exists both in EE and CE of Pentaho 3.6 and 3.5

dynamobi-build commented 12 years ago

[author="ngoodman", created="Tue, 17 Aug 2010 13:37:55 -0700"]

use package name for the historical data plugin

com.dynamobi.pentaho

please check in your current project structure (build.xml, test data, plugin building, instructions, etc) to SVN prior to our Thursday call

https://studio.dynamobi.com/svn/DDB/pentaho-plugin-luciddb-labels

dynamobi-build commented 12 years ago

[author="suresh", created="Wed, 25 Aug 2010 09:37:21 -0700"]

This feature is achieved by extending org.pentaho.platform.plugin.services.connections.sql.SQLConnection and overriding the setProperties method of it to set the DataSource specific Label retrieved from the session

edit pentaho-solutions/system/pentahoObjects.spring.xml to modify following line and make it ours by replacing to our class



swade1987 commented 4 years ago

Issues go stale after 60d of inactivity.