Hello everyone
I am working on the plankton diversity of freshwater. Other than the research articles, we can make monograph. Recently I knew about database management system (DBMS) and I can make database using my excel data and photograph but i do not how to make database management system? is anybody know about DBMS and how to make online to get everybody access. please share your knowledge.
I do not get what you exactly want. If you have a database already built in excel or access you can make it online by using HTML database. May this link will be helping you
https://www.w3schools.com/html/html_forms.asp
https://www.w3schools.com/html/html_tables.asp
You usually don't make a DBMS, you USE them.
The need for using a DBMS for your problem is a bit ambiguous.
In your case if your dataset is not BIG, then you do not even a data base management system. You can use softwares such as Microsoft Access (or its many equivalents) to store and retrieve your data.
I recommend you serach about several systems based on NoSQL databases, such as: graphs databases, value-key store, document store, and other technology oriented to improve the performance when the data are increased.
nowadays, the main goal of DBMS are create solutions for big data problem where it uses and combine the possibilities of five V's of Big data: velocity, volumen, varieity, veracity and visivility.
Get in contact with me so that we discus what you want. I can guide you
Data from excel can be imported to the selected DBMS and then made available to other users - depending on the number of users in the two, three or multi-tier architecture.
If your photo files exceed 2MB, it is not recommended to store them in the database. One of the older solutions is to keep only the path to the file in the database. However, the application must ensure that access to these files is managed.
In this case, if the files are a lot and are large in size, you can consider selected NoSQL database systems. However, solutions well-established on the market for many years, ie MS SQL Server or ORACLE have also come out against new challenges. They are adaptated for storing and managing unstructured data.
Both ORACLE and SQL Server allow you to hold binary files outside the database, but the SQL server itself manages these data as if it were stored in a database.
SQL Server provides for this purpose the FILESTREAM type in association with FILETABLE, and ORACLE type BFILE. I think that these are solutions worth considering.
See also the statements of mine and other people on a similar topic https://www.researchgate.net/post/Can_anyone_recommend_me_a_local_database_software_for_managing_faunistic_data
- Badges
- Science topic