PHP Classes

Develop data dictionary: I need to develop data dictionary from a sample data in .CSV

Recommend this page to a friend!
  All requests RSS feed  >  Develop data dictionary  >  Request new recommendation  >  A request is featured when there is no good recommended package on the site when it is posted. Featured requests  >  No recommendations No recommendations  

Develop data dictionary

Edit

Picture of Hillina by Hillina - 8 years ago (2015-05-12)

I need to develop data dictionary from a sample data in .CSV

This request is clear and relevant.
This request is not clear or is not relevant.

+3

The sample data is in .CSV format. From this .csv file format I need to develop a data dictionary which can be used for future development tasks.

  • 5 Clarification requests
  • 5. Picture of Dave Smith by Dave Smith - 8 years ago (2015-05-13) Reply

    First, let me say it is good to see others taking an active role in recommendation section.

    The request seemed to be asking for a way to read the csv data which they would use to develop a data dictionary. After looking at it again, I think you all may be right that they also want the class to determine the data dictionary from the sample data. Hopefully we will hear back from the requester to know for sure.

    I wasn't able to find any class here that does what they need, however just using standards we should be able to work out something that does the job in a limited way.

    Each csv file would be the table, the first line of the csv should be the column headers, so we could use that to determine the db columns. Each subsequent line are the data rows, so we could use them to determine the types. The types would be limited to varchar, text, float and int. There would have to be some column naming conventions in place to actually get any relations between tables defined. Not sure what else could be done beyond that.

    • 6. Picture of Hillina by Hillina - 8 years ago (2015-05-13) in reply to comment 5 by Dave Smith Comment

      I have seen what you all commented and requested Thanks a lot

      I am working on input validation for my thesis. I believe the first step in input validation is the data dictionary. The data base is a NoSQL database. As a sample I just taken a CSV file of 500 records.

      After finishing up with the input validation I will analyze the performance difference and finalize the paper.

    • 7. Picture of Dave Smith by Dave Smith - 8 years ago (2015-05-13) in reply to comment 6 by Hillina Comment

      So you need something to validate the sample records against an already existing data dictionary?

      If so, then that means you need a way to input the data definitions into the class, the class then reads the rows from the csv and does the comparison and finally returns a report.

    • 8. Picture of Hillina by Hillina - 8 years ago (2015-05-13) in reply to comment 7 by Dave Smith Comment

      My adviser is telling me to generate a new data dictionary which can be used in the future as a template

    • 9. Picture of Dave Smith by Dave Smith - 8 years ago (2015-05-13) in reply to comment 8 by Hillina Comment

      My only experience is with rdms and I don't even know what a data dictionary for a non-tabular database would look like. I wasn't able to find anything on here that generates a data dictionary from a noSQL database, so I will have to pass this request off to anyone with more knowledge on the subject that myself... any takers? Best of luck on your thesis.

  • 3. Picture of Samuel Adeshina by Samuel Adeshina - 8 years ago (2015-05-12) Reply

    Yes! I agree with Andreas and Gerry. We need to know the kind of data you are going to be working with and how they'll be stored in the csv file in order to recommend the best class that would get the job done (even if that means writing one)

    • 4. Picture of Samuel Adeshina by Samuel Adeshina - 8 years ago (2015-05-12) Reply

      Yes! I agree with Andreas and Gerry. We need to know the kind of data you are going to be working with and how they'll be stored in the csv file in order to recommend the best class that would get the job done (even if that means writing one)

      • 2. Picture of Andreas Mueller by Andreas Mueller - 8 years ago (2015-05-12) Reply

        yes, the request ist not clear for me either (not native english, sorry).

        • 1. Picture of Gerry Danen by Gerry Danen - 8 years ago (2015-05-12) Reply

          What kind of data is in the CSV file and what do you expect your data dictionary to look like?

          Ask clarification

          2 Recommendations

          CSV Handler: Retrieve or change information stored in CSV files

          This recommendation solves the problem.
          This recommendation does not solve the problem.

          0

          Picture of Dave Smith by Dave Smith Reputation 6845 - 8 years ago (2015-05-12) Comment

          This is the top rated csv manager, most users seem quite pleased with it. Looks like there are some bug fixes you may need to apply, instructions for that are in the support forum of the class.


          Ternary Search Tree: Insert and search text using ternary search trees

          This recommendation solves the problem.
          This recommendation does not solve the problem.

          0

          Picture of Chi H. by Chi H. package author package author Reputation 95 - 8 years ago (2015-05-12) Comment

          It uses a trie data structure.

          • 1 Comment
          • 1. Picture of Dave Smith by Dave Smith - 8 years ago (2015-05-13) Reply

            I think your class would be great if they where wanting a dictionary, however they are wanting a data dictionary which defines the layout of a database, so I am just not sure how this class provides that.


          Recommend package
          : 
          :