Este modelo logico foi gerado a partir do novo modelo conceitual. Este e o codigo em xml para a geracao do cubo no StarSchema._______________________________________________________________________________- <Schema name="tebd_clinica_etl">- <Cube name="clinica" visible="true" cache="true" enabled="true"> <Table name="clin_func_empr_exames" schema="tebd_clinica_etl" /> - <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_exames" highCardinality="false" name="Exames">- <Hierarchy name="Exames" visible="true" hasAll="true" primaryKey="exam_codigo" primaryKeyTable="clin_exames"> <Table name="clin_exames" schema="tebd_clinica_etl" /> <Level name="TipoExame" visible="true" table="clin_exames" column="exam_nome" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension>- <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_medico" highCardinality="false" name="Medico">- <Hierarchy name="Medico" visible="true" hasAll="true" primaryKey="medi_codigo" primaryKeyTable="clin_medico"> <Table name="clin_medico" schema="tebd_clinica_etl" /> <Level name="Especialidade" visible="true" table="clin_medico" column="medi_especialidade" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> <Level name="NomeMedico" visible="true" table="clin_medico" column="medi_nome" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> <Level name="CRM" visible="true" table="clin_medico" column="medi_crm" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension>- <Dimension type="StandardDimension" visible="true" foreignKey="clin_func_empr_exam_fk_tempo_exame" highCardinality="false" name="TempoExame">- <Hierarchy name="TempoExame" visible="true" hasAll="true" primaryKey="temp_exam_codigo" primaryKeyTable="clin_tempo_exame"> <Table name="clin_tempo_exame" schema="tebd_clinica_etl" /> <Level name="AnoExame" visible="true" table="clin_tempo_exame" column="temp_exam_ano" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> <Level name="MesExame" visible="true" table="clin_tempo_exame" column="temp_exam_mes" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> <Level name="DiaExame" visible="true" table="clin_tempo_exame" column="temp_exam_dia" type="String" uniqueMembers="false" levelType="Regular" hideMemberIf="Never" /> </Hierarchy> </Dimension> <Measure name="Qtd" column="clin_func_empr_exam_qtd" aggregator="sum" visible="true" /> </Cube> </Schema> Coodenador da semana: Roberval JuniorModelo Conceitual e logico. [lucas e barbara];Esquema de Banco de Dados e Script do Banco de Dados. [Lucas, Roberval e Barbara];Programa para povoar o banco (5Gb deinformacao - provar q esta feito e como foi feito.) [Lucas e Uisleandro];Um software funcional com um exemplo de gerenciamento de transacao. [Barbara, Lucas, Vagner, Roberval e Uisleandro];Mapeamento Objeto-Relacional (prova de conceito). [Barbara, Lucas, Vagner, Roberval e Uisleandro]; Foi usado esse codigo para a extracao das informacoes que serao apresentadas na aplicacao android.A aplicacao ira fazer uma solicitacao ao servidor web PHP, que respondera por meio do JSON, o resultado e a apresentacao da lista dos itens carregados no celular.________________________________________________________________________________> LaudoActivity.javapackage com.rober.clinica_laudo;import java.io.IOException;import java.util.ArrayList;import java.util.HashMap;import java.util.Iterator;import java.util.List;import org.apache.http.NameValuePair;import org.apache.http.client.ClientProtocolException;import org.apache.http.client.HttpClient;import org.apache.http.client.ResponseHandler;import org.apache.http.client.entity.UrlEncodedFormEntity;import org.apache.http.client.methods.HttpPost;import org.apache.http.impl.client.BasicResponseHandler;import org.apache.http.impl.client.DefaultHttpClient;import org.apache.http.message.BasicNameValuePair;import org.apache.http.params.BasicHttpParams;import org.apache.http.params.HttpConnectionParams;import org.apache.http.params.HttpParams;import org.json.JSONArray;import org.json.JSONObject;import com.rober.clinica_laudo.R;import android.R.string;import android.annotation.SuppressLint;import android.app.ListActivity;import android.content.Context;import android.content.Intent;import android.database.Cursor;import android.os.AsyncTask;import android.os.Bundle;import android.util.Log;import android.view.LayoutInflater;import android.view.View;import android.view.ViewGroup;import android.widget.BaseAdapter;import android.widget.Button;import android.widget.ListAdapter;import android.widget.ListView;import android.widget.SimpleCursorAdapter;import android.widget.TextView;import android.widget.Toast;public class LaudoActivity extends ListActivity { //ListAdapter adapter; LaudoAdapter adapter; DBAdapter datasource; Button btNovoContacto; Button btBuscarServer; TextView textRober; private List<Laudo> laudoList = new ArrayList<Laudo>(); ListView listView; // comunicacao server private static final int TIMEOUT_MILLISEC = 0; @Override public void onCreate(Bundle savedInstanceState) { super.onCreate(savedInstanceState); setContentView(R.layout.main); listView = (ListView) findViewById(R.id.linearLayout1); datasource = new DBAdapter(this); datasource.open(); Cursor cursor = datasource.getLaudos(); for (int i = 0; i < cursor.getCount(); i++) { cursor.moveToPosition(i); Laudo laudo = new Laudo(cursor.getLong(0), cursor.getLong(1), cursor.getString(2), cursor.getString(3), cursor.getString(4), cursor.getString(5), cursor.getString(6)); laudoList.add(laudo); } setListAdapter(new LaudoAdapter(this, laudoList)); datasource.close(); btBuscarServer = (Button) findViewById(R.id.btBuscarServer); btBuscarServer.setOnClickListener(new View.OnClickListener() { public void onClick(View v) { // TODO Auto-generated method stub String max_cod = ""; datasource.open(); Cursor cursor = datasource.getMaxLaudo(); for (int i = 0; i < cursor.getCount(); i++) { cursor.moveToPosition(i); Log.i("MAX", "max - " + cursor.getString(0)); if (cursor.getString(0) != null) { max_cod = cursor.getString(0); } else { max_cod = "0"; } } datasource.close(); HttpAsyncTask asyncTask = new HttpAsyncTask(max_cod); asyncTask.execute(); // asyncTask.cancel(true); } }); } @Override protected void onResume() { // TODO Auto-generated method stub super.onResume(); } @Override protected void onListItemClick(ListView l, View v, int position, long id) { } private class HttpAsyncTask extends AsyncTask<String, Integer, ArrayList> { String max_cod; public HttpAsyncTask(String max_cod)