Server (Cells) Architecture Home
Space shortcuts
Space Tools
Skip to end of metadata
Go to start of metadata
  • Validate the user by calling the Project Management cell.
  • Select a data mart based on the combination of domain_id, project_id, and user_id.
  • Call the Ontology cell with the item key and determine the dimension table to join with the fact table.
  • Save the query panel definition and the generated SQL statements.
  • Generate the list of output like the patient count, patient gender count, patient set, etc.
  • To scale the application and to support long running SQL, the execution of SQL is handled inside a set of queues. At first the query SQL statements will be executed inside a small job queue. If it doesn't complete within a certain time period then the jobs will be transferred to a mid-size job queue and then to a large size job queue.
  • If the SQL execution completes before the "result_waittime_ms" which is specified in the request, then the query results are passed in the response message. Otherwise the status of the query is passed in the response message.

  • No labels