Question

Most healthcare focused departments utilize technology for data collection, storage, analysis, and reporting of information. For this assignment, select a healthcare organization or hospital department and

• Describe the organization or hospital department.
• Identify types of information collected, including format and approximate volume.
• Compare and contrast three data storage or databases used by the department.
• Identify and describe at least three communication technologies (for example a VPN) and how they are used in your selected organization or department.
• Identify and describe three internet technologies (for example, intranet) and explain how they are used in your organization or department.
• Identify and summarize a minimum of four Joint Commission standards related to health information technology relevant to a health information management department or another hospital department. To access The Joint Commission Standards Manual follow the steps below:

From the homepage of the Ashford University library, click on Find Articles & More in the purple bar near the top of the page. Next, take the following steps:

• Click on Databases by Subject
• Click on Health & Medicine
• Click on Joint Commission E-dition for the Standards manual.
• Identify and advocate information operability between two hospital departments relative to patient information.
• Assess how the organization or department corrects department data utilized by other departments.

Answer 1

A health department or health ministry is a part of government which focuses on issues related to the general health of the citizenry. Health department can also refer to a university health department.

• I choose Dental offices as my example.

● The room or rooms in which the dentist and dental staff provide care. Offices include all rooms in the dentist's office suite.

■ Services that are provided by dental offices :

1. Complete exams, x-rays, and dental cleanings.

2. Fillings, root canals, and extractions.

3. Cosmetic dentistry, such as whitening, porcelain and composite veneers

4. Implants - placement and restoration.

5. Crowns, bridges, full and partial dentures.

6. Orthodontics.

7. Oral appliances for control of sleep apnea.

● Health care department involves a diverse set of private and public data collection systems, including health surveys, administrative enrollment and billing records, and medical records, used by various entities, including hospitals, CHCs, Physicians, and health plans.

■ A database is an organized collection of related information. It is an organized collection, because in a database, all data is described and associated with other data. ♡ Popular examples of relational databases are ;

1. Microsoft Access

2. MySQL

3. Oracle

● Comparison between MS Access and mySQL

1. MS Access works only on windows whereas MySQL works on almost all platforms.

2. Performance in MySQL is way better than MS Access.

3. MS Access is limited to security in terms of username/password on the database. Where as MySQL is much more secured and we can configured it with SSL support.

4. MS Access does not support Partitioning feature whereas MySQL has composite, Range Partitioning support.

● Comparison between MS Access and Oracle

1. Oracle is a database server, Access is a database engine. One is stand alone , the other is in process.

2. Oracle is hard to learn and keep running. Access does not scale with large data.

3. Oracle can handle large data with ease. Access is simple to use for personal use.