Automatic storage of result object in queries

Asked By Schuyler 0 points N/A Posted on - 11/07/2011

I would like to know whether frequently used result object in queries are automatically stored for extended time or will it be necessary to use strong reference for such objects before the GC.

• Status: Open
• Question Views: 836
• Answer Count: 2
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: Storage Technology

Best Answer by Harpe byers

Go To Solution

Answered By Clair Charles 15 points N/A #106517

Automatic storage of result object in queries

Hello Schyuler,

For the frequently used result object in queries to be stored automatically stored for an extended time, I guess you will need to use indexing. With the indexed, you can then build them using the scoped REF columns whereby you will use the CREATE INDEX command.

With the indices set, you can therefore efficiently evaluate queries which dereference the scoped REFs, and for such queries, they will be turned into joins implicitly. Therefore you will need to use a very strong reference for the objects that you want to access automatically to be able to implement that.

___

Regards
Clair Charles

About Clair Charles

Questions
1

Answers
495

Best Answers
109

• Vote Up 0 Vote Down

• Posted on - 11/17/2011
• Question Category: Storage Technology

Best Answer

Best Answer

Answered By Harpe byers 10 points N/A #106518

Automatic storage of result object in queries

Hi friend,

Yes, you will have to create strong reference or interlink your database which is technically called “indexing” in data warehouse to retrieve the data automatically and same results from the historical queries.

Please take care following steps while indexing your data warehouse:

1. Indexing depends on type of data warehouse, dimensions and facts of the relational tables, access rights etc.

2. You must set your most important business key as primary key e.g. sales invoice numbers.

3. Your partition shall be based on foreign key.

4. You shall modify your indexing time and again as frequently as your data changes to arrive at correct results.

I am sure it helped!

About Harpe byers

Questions
3

Answers
202

Best Answers
91

• Vote Up 0 Vote Down

• Posted on - 12/07/2012
• Question Category: Storage Technology