Impact of Big Data, Data Warehouse, and Internet of Things on Insurance Companies.

It is witnessed that over the past few years, the Internet of Things (IoT), have increasingly changed the models of business in a plethora of different ways, affecting many sectors and industries in the world. Currently, it is witnessed that the insurance companies are also largely getting affected as the rate-making procedures and business models largely driven by IoT have induced a new paradigm shift in the sector. For instance, now the primary drivers are real-time scoring and telematic approaches such as:

  • Auto insurance Telematics: the telemetry data can be utilized for claim reduction incentives, optimized tariffs, and measuring the insurance premiums for the risk of damage to the person or individual. The ‘Pay-how-you-drive’ tariffs is a great example.
  • Health insurance Telematics: Life-style and data related to health is utilized for the measuring of plans related to health care.

It is important to note that storing the raw data produced with the contract data and structured party is not always a useful thing to do. It is more useful and effective to consider Hadoop which is a more appropriate option available. Furthermore, many consider this to be a cost-effective avenue as well. On the contrary, it is also witnessed that these large data structures are not still accustomed to handling and processing the intricate and complex relational data structures with efficacy. Hence, we can say that it is more likely that large data structures such as Hadoop and others such as Oracle which is a relational data store, would be used simultaneously in parallel by the IT sector of the Insurance Corporations.

However, it is important that we first built a strong connection between these data systems. Firstly, the data can be a combination taken from the data warehouse at the analytical data marts level, which can include the linking of streaming data to a contract number or a customer from the data warehouse. But, assuming that the IT department of an insurance corporation processes the IoT data, we can say that a scenario can be structured in which the analytics results of the big data are generated or handed over by an external service provider to the insurance corporation. In any situation, the overall problem will be to connect the analytical results with the information in the data warehouse.

Hence, we are now witnessing that many insurance corporations are starting to develop an innovative and new system of automotive tariffs. In simple words, the corporations are now rewarding the defensive driving by giving off favorable premiums. All of this is done through IoT, which is through the analyzation from a telematics box which can be installed in the vehicle and sends anonymous info on the behavior of driving by the driver.

Oracle 11g Step by Step Installation

If you are installing on Non-Network Computer than it is recommended to disable your wireless connectionInstall Loop back adapter using the following steps.

  • Initiate the run window by pressing the Windows + R button. The following screen will appear.

  • Type the following command on this window and press enter

  • The following window will appear, asking to add the new hardware

  • Click the Next button and select the option as mentioned in the following diagram

  • Click the Next button and select the Network Adapters from the list as mentioned in the following picture and click next

  • In the next window select Microsoft from the Manufacturer List on the left and select Microsoft KM-TEST Loopback Adapter from the Network Adapter List on the right and press Next

  • Click next to start installation and click the finish to complete it.

  • Now open networking and sharing center and assign the IP to the newly installed network adapter

  • Right Click on this adapter and select the properties, the following window will appear

  • Uncheck IPv6 then select IPV4 and click the properties button and select Use the following IP address and assign the IP address as shown

  • Press the Ok button and then press the close button

  • Now unzip the oracle database 11g 64 bit setup files. Unzip the files in the same folder.
  • Run the setup.exe file as administrator, select yes if it display following warning.

  • Uncheck the “I wish to receive security updates via My Oracle Support” and click Next as shown below

  • The following warning will appear, click yes and continue

  • Select “Create and Configure a Database” and click Next

  • Select Desktop class and click Next

  • Set the password on the next screen and click Next

  • Click the finish button on the following screen

  • The setup will start as shown in the following diagram

  • Check both public and private networks and click the Allow access button

  • The Database Configuration Assistant will start automatically as shown

  • The following window will appear, click the Password Management button as shown

  • Uncheck the scott account and set the New and Confirm password

  • The installation is successfully completed:) Click the Close button.

Upload Image on Oracle Forms and Saved into Database through Webutill

Prerequisite: Successful configuration of webutil.

Here is a guide for webutil configuration.

Steps:

  • Open Oracle forms builder 11g Create a new form,a new block & a canvas.
  • Attach webutil.pll on Navigator—> Attached Libraries in Forms.
  • Click file—>open—>C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.olb click webutil.olb file and it will create some entries in object library (in navigator)
  • Click on object libraries there u have webuitl, right click on webutil chose option object library.
  • There you have 2 webutil objects.
  • Drag webutil object to object group (in navigator window) subclass it.

 

  • Run form in case of error try this: In webutil block there is block level trigger when_custom_item_event edit it by replacing null in its code;

BEGIN

NULL;

END;

  • Create table in database:

CREATE TABLE LOBS_TABLE

(

BLOB_ID     NUMBER,

IMAGE_BLOB  BLOB

)

  • Create form by using wizard add these 2 DataBase items on form.

 

  • Code behind upload button:

declare

vfilename varchar2(3000);

begin

vfilename := client_get_file_name(‘c:\’, file_filter => ‘ image files (*.jpg)|*.jpg|’);

read_image_file(vfilename, ‘jpg’,’lobs_table.IMAGE_BLOB’);

write_image_file(vfilename,’jpg’,’lobs_table.IMAGE_BLOB’,maximize_compression,ORIGINAL_DEPTH);

—   commit_form;

end; http://domycoursework.hatenablog.com/

Webutil Configuration steps for Oracle Fusion Middleware Forms 11g R2

There are some additional steps you will need to accomplish in order to make confugration work properly.

  • Download Jacob Package 1.14.3 for (11.1.2.0).
  • URL: https://sourceforge.net/projects/jacob-project/files/jacob-project/1.14.3/jacob-1.14.3.zip/download
  • Now Place the Jacob.jar  into /Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/java Directory
  • Place Jacob-1.14.3-x64.dll into/weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win64
  • Place Jacob-1.14.3-x86.dll into/weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/webutil/win32

Follow the steps mentioned below to create Webutil user in Database:

Step 1:

  • Login from SYS

Step 2:

  • CREATE USER Webutil IDENTIFIED BY Webutil

Step 3:

  • Grant connect, resource to Webutil

Step 4:

  • Connect Webutil/Webutil

Step 5:

  • Runsql  from C:/Weblogic/weblogic_10.3/Middleware/Oracle_FRHome1/forms/ run create_webutil_db.sql

Step 6:

  • Create public synonym webutil_db for webutil.webutil_db;

Step 7:

  • Connect sys as sysdba

Step 8:

  • Grant execute on webutil_db to public;

Step 9:

  •  Edit formweb.cfg:
  • Path: C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\formweb.cfg (edit formweb.cfg)

Archive= frmall.jar, frmwebutil.jar

  • (Edit the webutil section)

 

[Webutil]

WebUtilArchive=frmwebutil.jar, jacob.jar

Archive=frmall.jar, frmwebutil.jar, jacob.jar

WebUtilLogging=on

WebUtilLoggingDetail=normal

WebUtilErrorMode=Alert

WebUtilDispatchMonitorInterval=5

WebUtilTrustInternal=true

WebUtilMaxTransferSize=16384

baseHTML=webutilbase.htm

baseHTMLjpi=webutiljpi.htm

archive=frmall.jar

lookAndFeel=oracle

Step 10:

  • Edit webutil.cfg file:
  • Path: C:\Oracle\Middleware\Oracle_FRHome1\forms\templates\config\webutil.cfg (webutil.cfg change the following entries)

transfer.database.enabled=TRUE
transfer.appsrv.enabled=TRUE

Step 11:

  • Edit default.env file:
  • Path: C:\Oracle\Middleware\user_projects\domains\ClassicDomain\config\fmwconfig\servers\AdminServer\applications\formsapp_11.1.2\config\default.env (default.env change the following entries)
  • In FORMS_PATH add these path:

FORMS_PATH=C:\Oracle\Middleware\asinst_1\FormsComponent\forms;

C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil

  • In CLASS_PATH add these path:

CLASSPATH=C:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmwebutil.jar;

C:\Oracle\Middleware\Oracle_FRHome1\forms\java\frmall.jar;

C:\DevSuiteHome_1\forms\java\jacob.jar

  • In WEBUTIL_CONFIG add these path:

WEBUTIL_CONFIG=C:\Oracle\Middleware\asinst_1\config\FormsComponent\forms\server\webutil.cfg

  • At the end add path:

FORMS=C:\Oracle\Middleware\Oracle_FRHome1\forms

Step 12:

Regenerate the webutil.pll using following command:

frmcmp module=C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.pll userid=webutil/webutil module_type=library compile_all=yes;

Step 13:

Now:

  • Open Oracle forms builder 11g Create a new form,a new block & a canvas.
  • Attach webutil.pll on Navigator—> Attached Libraries in Forms.
  • Click file—>open—>C:\Oracle\Middleware\Oracle_FRHome1\forms\webutil.olb click webutil.olb file and it will create some entries in object library (in navigator)
  • Click on object libraries there u have webuitl, right click on webutil chose option object library.
  • There you have two webutil objects.
  • Drag webutil object to object group (in navigator window) subclass it.

The Very 1st Impression On Golden Tiger

Database Migration from SQL Server to Oracle using SQL Developer

  • First, Create user ”Migration” for migration repositery where sqldeveloper manages metadata for migration. Grant privileges to Migration user.

Create user Migration identified by migration

Default tablespace users

temporary tablespace temp;

grant all privileges to migration;

  • Right click on connection tab to Create new connection:

1

  • Now create a database connection repository for migration user. Enter migration user name and password. Set SID of your oracle database and test your connection. On successful status click on connect.

2

  • To create the repository right click on Repository connection, and select Migration Repository menu then click Associate Migration Repository.

3

4

  • Expand the database and select Third Party JDBC Drivers. And click on Add Entry.

5

  • Select .jar file located in jTDS folder. click OK.

6

  • Now create a connection for SQL Server database using SQL Developer.
  • Give connection name as SQL_Server.
  • Checked Use Windows Authentication check box.
  • Through Retrieve database you can select sql server database which want to migrate.
  • Test and Connect.

7

In case of Error: SSO Failed: Native SSPI library not loaded. Try this:

  • Open the JTDS 1.3.0 folder.
  • The ntlmauth.dll you will find inside the x86/SSO folder
  • The JtdsXA.dll you will find inside the x86/XA folder
  • Put the ntlmauth.ddl and JtdsXA.dll inside de Sql Developer/sqldeveloper/bin
  • Copy the jtds-1.2.4.jar to Sql Developer/sqldeveloper/lib
  • Copy ntlmauth.dll in java bin folder

Now create user in oracle db in which you want to migarate sql server database

  • Create user test identified by test;
  • Create database connection for test user.

8

Finally you can start migration.

  • Open sql developer.
  • Click Tools>Migration>Migrate

9

  • Migration Wizard will appear on your screen. Click Next

10

  • Select Migration_repository database connection.

11

  • Give a name for migration project and select a directory to write output.

12

  • Now select third party database connection SQL Server which you want to migrate. In case of online migration Migration wizard will perform all operations. If you select offline migration then Migration Wizard will generate all DDL scripts.

14

  • Select SQL Server database which we want to migrate.

15

  • Conversion window will appear. Which will convert source data types according to oracle model.

16

  • Select SQL objects to translate.

17

  • Choose targeted Database.

23

  • Select the source and target database.

19

  • Summery window will show you the migration detail. In case of any change go back and correct it.

21

  • Click Finish.
  • Migration process will start.

22

  • On successful migration message your sql server database is migrated to oracle.

Copying tables to Oracle:

  • Right click the table located in third party database and click Copy To Oracle
  • Select target database connection and click Apply button. If you checked Include Data check box then it will create table structure and move data.
  • Finaly, Copy to Oracle database is finished.

 

Installing Oracle 10g on Windows

 

Step by step installation guide for Oracle 10g, covering a typical installation scenario.

  • Login to your computer as an administrative user to be authorized to install, create and run database.
  • First, verify your system and software compatibility and then run the oracle universal installer setup.exe.
  • The oracle universal installation starts.

   2

  • Select basic installation to install oracle 10g database, For basic installation,you should specify the following:
  • Oracle Home Location: Enter the directory in which you want to install the Oracle Database 10g software.
  • Installation Type: Select Enterprise Edition.
  • Create Starter Database: Check the checkbox to create a database during installation.
  • Global database name: Use default name orcl and type your password.

1

  • Installer now verifies whether the system meets all the requirements for installing and configuring the software and resolves any reported errors before continuing. When all of the checks are successfully completed, click Next.3
  • A summary screen will appear. Click Install to start the installation.

4

  • The installation window will appear to show the installation progress.                      5
  • If you are creating a database then the Database Configuration Assistant starts automatically.

6

7

  • After the creation of the database, you can unlock the users, you want to use by clicking on Password Management or you can do it later.
  • Click Ok.

8

  • Click Exit

.9

Testing your Installation:

You use Enterprise Manager to perform common database administrator task

To test your installation completed successfully, do the following:

  • Enter following URL: http://<hostname>:1158/em
  • Login as sys user. Enter sys as the User Name and the password you specified at the time of installation and Login.

 10

  • The Licensing window. Scroll to the bottom and click I agree.
  • 11If, the Database Control Home Page appears the your Installation was successful.12

betala med ecoPayz på casinon