7,612
edits
Changes
Jump to navigation
Jump to search
'''2/16/2017''' - Talked over project with Ed, began reading existing wiki pages related to patent data and databases '''2/21/2017''' - Brushed up on SQL, Entity - Relationship model of designing databases* In the documentation, I want to briefly explain what the entity-relationship model is before including the diagram so that readers have a little bit of background* Found a tool for creating a visual representation called ERDPlus.com - create a standalone instead of an account, can downloadLearning commands from Patent Data - SQL Steps* copy command is PostgreSQL that copies a SQL table to a text file** DELIMITER set what will separate columns in text file** HEADER specifies that there will be a header in the text file with the names of the columns* Definitely need to include more detail about what these do in the documentation* insert into command inserts a new entry into the table '''2/23/2017''' - Read great database design article, dug through some more wiki articles, started reviewing Perl* What client do we use to interact with the current patent database?* Will need to determine all the fields that need to be included in the database before finishing the design and ER diagram, will need Ed's input[[Category:Work Log]]
Shelby Bice (Research Plan) (view source)
Revision as of 17:17, 21 March 2017
, 17:17, 21 March 2017no edit summary
* SQL commands that were used to fill database with explanation of what they do
* Clear instructions on where to find scripts in bulk drive and an explanation of what each script does
* Visual representation of example table entries that isn't just copied and pasted from a CSV file
'''Project Pages:'''
[[Shelby Bice (Redesigning Patent Database)]]
== Log ==
