Every application in the real world needs to interact with databases. Java Database Connectivity (JDBC) is the Application Programming Interface (API) used to build Java applications that can interact with relational databases. There are many relational databases such as Oracle, My SQL, DB2, Java DB, Dbase, Sybase, Ingress, Informix, FoxPro and so on. The researcher will be able to use the four types of JDBC drivers to interact with any kind of database in the world.
In this iteration, the researcher also learns Structured Query Language (SQL) which is the underlying language used long with JDBC API to get things done in backend (a term used to refer database).
Plan
The aim of this iteration is to improve me knowledge in JDBC which is essential to work with real time applications. JDBC is the API used to interact with relational databases. JDBC API is available in the form of java.sql and javax.sql packages. The former is known as core package while the latter is known as extension package. The JDBC material collected in the first iteration is used in this iteration. The topics to be learnt in this iteration include database concepts, creating a database, SQL, JDBC API such as Connection interface, DriverManager class, Statement interface, PreparedStatement interface and ResultSet interface. These topics are required to build applications that can connect and interact with relational databases. More applications in the real world need the knowledge of JDBC. The time allotted to learn this subject is 10 working days. This is for two weeks. I spend around 9 hour’s time on each day from Monday to Friday.
I learn prerequisites to JDBC such as database concepts and SQL first. Then I focus on the JDBC API to develop JDBC applications...
... middle of paper ...
...ove my knowledge. Action research helped me to track progress and gain knowledge in a systematic fashion.
In this iteration everything went well as per planning. I could spend 9 hours on each day. My learning continued for 10 working days. On every day I spent the allotted time and learned subject as planned. I also took the help of a known person to get my doubts clarified. Nevertheless, there are many observations I made with respect to improvements. First one is related to time. I could improve the usage of time. Second, I could gain more insights by studying topics based on their priority. Third, I could improve my learning with even different favorable timings. With the knowledge gained I can able to develop applications using JDBC and also perform different operations which can be used to execute SQL commands. I also got knowledge of data centric applications.
In the past number of years data has grown exponentially. This growth in data has created problems that and a race to better monitor, monetize, and organize it. Oracle is in the forefront of helping companies from different industries better handle this growing concern with data. Oracle provides analytical platforms and an architectural platform to provide solutions to companies. Furthermore, Oracle has provided software such as Oracle Business Intelligence Suite and Oracle Exalytics that have been instrumental in organizing and analyzing the phenomenon known as Big Data.
Oracle ThinkQuest. Oracle Education Foundation, 04 Jun 2010. Web.
“applied research aims to solve practical problems, although it uses the same characteristic as basic research” (Neutens, 2014). Overall presence of research is to increase one’s general knowledge on different subjects. While gaining knowledge through research, it is also conducted to benefit others depending on the specific topic of research.
Oracle's relational databases represent a new and exciting database technology and philosophy on campus. As the Oracle development projects continue to impact on University applications, more and more users will realize the power and capabilities of relational database technology.
In 1977, Larry Ellison, Bob Miner, and Ed Oates founded System Development Laboratories. After being inspired by a research paper written in 1970 by an IBM researcher titled “A Relational Model of Data for Large Shared Data Banks” they decided to build a new type of database called a relational database system. The original project on the relational database system was for the government (Central Intelligence Agency) and was dubbed ‘Oracle.’ They thought this would be appropriate because the meaning of Oracle is source of wisdom.
Schon (1983) identified “reflection on action” and “reflection in action”. In reflection on action, professionals consciously scrutinise their past practice to gain insight and improve future practice.
I can analyze the evidence collected from my research to include how inventions have solved problems.
DBA deals with all of this by finding user needs, set the database, and test the system. DBA should enable editing any system he or she created. At the same time DBA should ensure the security of the data and guarantee data integrity and backup. Moreover, DBAs should know the database management systems (DBMS) that include the knowledge of Oracle, IBM DB2, and Microsoft SQL server (“Database Administrator,” 2010). Oracle is one of the most important platforms that DBA must know and have experience with. According to Kanaracus “The database experience we look for most of the time is Oracle”, says Tom Hart, executive vice president of the operations and technology group at Veritude. “SQL Server is more of a nice-to-have"
[7] Elmasri & Navathe. Fundamentals of database systems, 4th edition. Addison-Wesley, Redwood City, CA. 2004.
I have my coding skills about C++, Java, HTML, CSS, JavaScript, and PHP. This means that I can analysis the problem to write and develop a code for generating a work. The next is my knowledge. I learned Object Oriented Programming, Algorithm and Database Management System course, so this can help me to apply my knowledge with the work about algorithm and using SQL.
...oherent research practice functions to collect and communicate information about the world, a scenario enabled by key concepts of ontology and epistemology.
Through diploma years I learnt, fundamentals of object oriented programming, web page designing, relational databases and understand the scope of information processing. I worked on a chat server project in which we developed a communication tool for isolated networks where existing web communication technologies, such as Jabber, MSN Messenger, Yahoo Messenger, etc, would not be feasible. We used the incremental model. Initially the project was developed in C#, later, to understand the implementation differences between Java and C#, we developed the project in Java. This project widened my understanding in programming languages, as well as strengthened my object oriented concepts. We studied the Client-Server interaction using sockets, Swing, Messag...
The database application design can be improved in a number of ways as described below:
Schools whose faculties cannot agree on a single research focus can still use action research as a tool to help transform themselves into a learning organization. They accomplish this in the same manner as do the physicians at the medical center. It is common practice in a quality medical center for physicians to engage in independent, even idiosyncratic, research agendas. However, it is also common for medical researchers to share the findings obtained from their research with colleagues (even those engaged in other specialties).
The Database Management System (DBMS) is software that enables the users to define, create, maintain and control the access to the database. It is a software that interact with the user’s applications programs and it database. Meanwhile, information retrieval system is a system that involved the activity that the systems obtain the information. The obtaining information action need the information from it resources.