Hello all,
I have been following *PMA* for a long time.I saw the GSOC project
idea *Structure
Tools* in the wiki page. I found the project very interesting. As I have
worked in many projects in Database ( Both implementation and Application)
, I would like to contribute in this project. The following is the
detailed description of what I have got until now after my research.
1- *Normalization* :
- Going to the basics of Normalization there are two things needed
before we can apply normalization on a relational database. 1- Database
Schema 2- Functional Dependencies. *I wanted to ask this thing - We
would take the functional dependencies from the user only ? For example if
the user selects some table for normalization then after that we have to
take the FD from the user only ? *
- If we have got the functional dependencies ans set of attributes , we
can do the following things to change to the 3NF: *1)* we can first get
the closure of the given set of attributes with respect to given functional
dependencies. *2) *Then we will remove the implied extraneous attributes
and redundant dependencies. *3) *After that we can determine the full
and partial dependencies . Then we can apply the inference rules of
Normalization to convert the database schema to 2NF then to 3NF.
- The above algorithm can be implemented with algorithmic efficiency.
2- *Central List of Columns *
- I didn't get the meaning of this : *The phpMyAdmin configuration
storage would be the place to maintain this central list (probably per
database). *Please help me out in understanding this.
- If there is any need of grouping the columns name with very similar
name like *product_id and product* , we can use many string algorithms
like Levenshtein distance<http://en.wikipedia.org/wiki/Levenshtein_distance>
and Longest Common
Substring<http://en.wikipedia.org/wiki/Longest_common_substring_problem>
.
Please comment on my views :).
I am very much interested in the project. Please guide me further.
Eagerly waiting for your comments
Deven Bhooshan
devenbhooshan
Hi All,
I have tried implementing the Feature Request #1418 , I have modified the
inmportCsv plugin to use string for column_Seperated_With parameter as
MySql support string for the same. Working fine me, Here is the commit.
https://github.com/smita786/phpmyadmin/commit/843e5680865d68c4120ea667a6f45…
Please review if it'll work, waiting for your feedback!
Thanks and Regards
- Smita Kumari
hii..
I was going through bug list on source forge and I found this reported
javascript error
.
I believe with my javascript knowledge, I can solve this issue. Also, i
feel this can a nice small step to this new world giving me a steady start
required.
plzz show me the path towards my next step. How to approach.
--
Thanks & Regards
Aayush
2nd Year Undergraduate Student
Department of Mining Engineering
Indian School of Mines, Dhanbad
Mobile No: (+91)9162648465
hi..
as a user of phpmyadmin, I have very much faced this problem.
so as a developer I would definitely like to work on this and improve this.
plzz can you guide me how to start as i am a newbie..
--
Thanks & Regards
Aayush
2nd Year Undergraduate Student
Department of Mining Engineering
Indian School of Mines, Dhanbad
Mobile No: (+91)9162648465
When i chnage the type of a field from VARCHAR (all equal to "0") to
DOUBLE in a tabel with a character _ into nthe field name.
#1064 - You have an error in your SQL syntax; check the manual that
corresponds to your MySQL server version for the right syntax to use
near ') NOT NULL' at line 1
Please correct it, and put a big button to send the bugs.
Thankyou.