Difference between revisions of "Augi Liebster (Work Log)"
Adliebster (talk | contribs) |
Adliebster (talk | contribs) |
||
| Line 9: | Line 9: | ||
[[Augi Liebster]] [[Work Logs]] | [[Augi Liebster]] [[Work Logs]] | ||
| + | |||
| + | 2018-06-16: Pulled data from SDC. Successfully pulled USPortCo1980-Present, CompanyLongDescription, USVCFirms1980-Present, USVCFunds1980-Present, and VCFunds1980-Present. Had some trouble figuring out which rpt files to use but messaged Ed and he clarified. | ||
2018-06-25: Started to pull data from SDC. Did a few practice runs and then started to pull real data. Today I pulled USVCPortCo1980-Present and USCompanyLongDescription. I am having some trouble formatting both of them and need to sort out foreign countries from the data. Once I get down the formatting I will pull down the other datasets as well. | 2018-06-25: Started to pull data from SDC. Did a few practice runs and then started to pull real data. Today I pulled USVCPortCo1980-Present and USCompanyLongDescription. I am having some trouble formatting both of them and need to sort out foreign countries from the data. Once I get down the formatting I will pull down the other datasets as well. | ||
Revision as of 11:28, 27 June 2018
| {{{name}}} | |
| Staff Information | |
|---|---|
| Status | Active |
| McNairCenterⓂ | |
Summer 2018
2018-06-16: Pulled data from SDC. Successfully pulled USPortCo1980-Present, CompanyLongDescription, USVCFirms1980-Present, USVCFunds1980-Present, and VCFunds1980-Present. Had some trouble figuring out which rpt files to use but messaged Ed and he clarified.
2018-06-25: Started to pull data from SDC. Did a few practice runs and then started to pull real data. Today I pulled USVCPortCo1980-Present and USCompanyLongDescription. I am having some trouble formatting both of them and need to sort out foreign countries from the data. Once I get down the formatting I will pull down the other datasets as well.
2018-06-22: Read all relevant pages to my project. Understand the process behind the building and have identified the master tables that will have to be built. Mapped out multiple trees to represent the stacks of tables created in the process of making the master tables. Need help understanding the SDC Platinum interface and how to pull data from there so that I can start to construct the database. Would like to meet with Ed to discuss his vision for redesigning the database.
2018-06-21: Continued to read through and understand the VCDatabase Rebuild wiki page. Found a number of logical and mathematical errors and have quickly realized that in the process of building the db I will have to rewrite the wiki.
2018-06-20: Began to read the VCDatabase Rebuild wiki page. Found page to be decently good at describing the process of building the db, but the process seems flawed. Confused about certain things where numbers seem to not add up or illogical statements are made. So far I have observed this in roundname duplicate check (not present), IPO distinct table (where there seem to be 10 entries missing) and maskey announcedates (where the use of min seems illogical). Potentially I am misunderstanding due to new exposure to SQL.
2018-06-19: Set up work stations on the balcony. Ordered extra cables needed to set up monitors with keyboard, a mouse, and my laptop. Get our projects; I will be redesigning the VC Database. Heard about other people's projects and other interns were assigned their projects as well.
2018-06-18: Met all of the interns, Ed, and Anne. Was introduced to the database, learned basic SQL commands, and set up a wiki page. Also logged onto the RDP for the first time. Starting to learn the infrastructure.
