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
Since you can store your data in excel file already, it means you are dealing with structured data which makes your problem even simpler. You may use the following guide:
1. Database: I recomend the use of MySQL to store your data and use Structure Query Language (SQL) to save and retreive data from it. MySQL can work with Linux & Windows servers. Also, it’s very light and open source.
...and since you want to make you system accessible online, then you need the following to make a complete system:
2. Serverside language: you may choose php, python or pearl etc. Any of this programming languages will help your web pages communicate with the server and your developed database.
3. Client-side: If your target is just the basic view, just use basic HTML or XHTML to design your page. Here, you may need to add some few things such as javascript, css etc. to get an advance user viewing experience (which you may not need at this stage).
To make your application accessible online after development, you need to communicate with a hosting company to subscribe and also get your own domain if at all you need to have your’s.
Hope this helps, good luck.
- Badges
- Science topic