Database

Data Mining Within E-Commerce {0}

By Gary C.

In e-commerce, data mining is critically essential in order to compete with the rapidly growing competition amongst retailers. E-commerce is the exchange of data within the online world in order to garner business transactions. There are patterns and trends within shoppers that are analyzed and broken down in order to determine strategies to identify a multitude of situations, such as from what customers may like based on a previously purchased product all the way to why customers tend to avoid a certain product. The amount of raw data that is transmitted through data mining is astounding and requires a tremendous amount of research in order to determine the most of every possible likely scenario.

read more...

DeepSQL: The Next Generation of Database Optimization {Comments Off on DeepSQL: The Next Generation of Database Optimization}

By Andy C.

Due to the explosive growth of Big Data in this world, SQL, the programming language for interacting and modifying databases, was also required to evolve in order to keep up. With such large amounts of data, servers needed to be expanded in order to accommodate all of the data. However, more servers would also mean more time to process data. A platform that can hold and process all of the data efficiently was needed. With databases being increasingly larger and increasingly more necessary for operations within a company, many companies needed to look for alternative solutions to handle the database for higher efficiency. Many different platforms to store and process data with different versions of SQL were developed, and a recent development in 2015 was the invention of DeepSQL by Deep Information Sciences. DeepSQL is a storage engine that uses MySQL, which transforms a MySQL database into a database that continually tunes itself for maximum optimization.

read more...

A Career in Databases {18}

So the quarter is coming to an end and you loved the class. I mean who wouldn’t? The practical uses of databases are endless and the need for people to manage them will only grow. The careers within CIS are among the top 5 growing jobs in the U.S. and this blog will tell you why. As mentioned in many other presentations about 80- 90 percent of data has been created within the last 2 years and database admins are the ones who are responsible for managing and turning that data into useful information. Throughout this post I will discuss how to become an admin, discuss salary, work environment, and its job outlook.

read more...

Inventory Management Systems {14}

When running a business, proper inventory management is essential to ensuring financial success. Inventory management may be defined as the overseeing and controlling of the ordering, storage and use of components that a company will use in the production of the items it will sell as well as the overseeing and controlling of quantities of finished products for sale. Smart planning and controlling of inventories in order to meet the competitive priorities of the organization falls in line with inventory management because a business’s inventory is one of it’s major assets. Until items are sold, sitting inventory equates to an investment that has not returned a profit yet; additionally, it may be incurring costs for storage, tracking, and security. Mismanaging inventory includes both shortages and surpluses; both are important challenges to tackle. How does a company properly manage inventory to make the most out of sales? Is it possible to extract other vital information through inventory management? Some companies today excel at performing both of those tasks.

read more...

Data Mining and its Use in Everyday Life {14}

Every day 2.5 quintillion bytes of data are created and 90 percent of the data in the world today were produced within the past two years. Because the amount of data is growing and at such a large rate, the challenges of handling this data with the intention to use and to apply it using tools such as data mining has become more and more complex, and has caused a constant need to scale up to the large volume of data that must be interpreted. With this large influx of new data and information comes many new opportunities to use and to apply data mining. This most often seems to apply in a business sense, used in order to “improve customer service, better target marketing campaigns, identify high-risk clients, and improve production processes” or in other words to make money, such as when Walmart learned that people have a tendency to buy more Pop Tarts when there was a hurricane warning in the affected area and instructed store managers to place Pop Tarts near the entrance during hurricane season in order to boost sales. Other companies such as Facebook and Twitter make use of this data by selling it to other companies who then apply data mining better market their products by finding new customers  or by  better targeting their products to existing ones. However, data mining isn’t only useful to businesses. It can also affect different aspects of a person’s everyday life.

read more...

Database Breach {10}

Database Breaches: Target

As technology grows at an ever faster rate, people scramble to keep up with the new changes. New systems are released; new patches, new servers, and more and more new technologies are being developed such as the cloud. Computer infrastructures such as the Google’s data bases or Sony’s Playstation Network have the challenge to maintain which is very hard on a large scale and expensive to keep up to date. With the quickly changing environment of technology, it is only becoming more difficult to stay up to date as time progresses into the future of new unknown technology advances.

read more...

Improving Life Through Databases {11}

We have discussed as a class the many uses of databases in regards to business purposes, but databases are useful on a personal level as well. In fact, there are many people that utilize databases every day without even realizing it. According to Levent Orman, “Database application systems are designed to collect, store, retrieve, process, and present large quantities of information.” While this definitely applies to business applications, it can also be applied for personal usage as well. We deal with “large quantities of information” all the time, so why not use databases to organize it all and help us improve ourselves? This idea is the principal behind many of today’s technology and applications that we take for granted every day.

read more...

NoSQL cloud technology as an option? {3}

As relational databases such as SQL and MySQL have been the standard model for storing, retrieving, and managing data throughout the IT industry for the past decades, relational databases finds itself losing its significance primarily due to fixed schema requirements and the inability to scale (Arora & Aggarwal, 2013). Three prominent trends occurring in the computer industry are Big Users, Big Data, and Cloud Computing. Relational databases finds itself struggling to keep up with these current trends. This is where NoSQL cloud technology can provide a solution to these problems.

read more...

Using Database Technology to Fight Terrorism {9}

We all remember September 11th. We remember where we were, what we were doing, and most importantly what happened. After the events of that day, America subsequently went into war with Afghanistan and Iraq in order to catch the perpetrator, Osama bin Laden, the leader of the Al-Qaeda at the time. After 12 years of looking, he had finally been caught, and America had seen some justice finally done. The elements that went into finding this man were obviously lots of manpower, in the form of soldiers, intelligence workers, sources, and the list goes on. One of the elements were technology, more specifically, databases.

read more...

PostgreSQL is a way! {2}

What is PostgreSQL?

Companies are always looking for database system to take care of complex data infrastructure in order to solve specific business needs, lower the cost of operations, and reduce the deployment time. Some case studies show PostgreQL is one of useful tools. PosgresQL is an open source object-relational database system (DBMS). In term of source relational database system, it is a relation database with an object-oriented database model which supports objects, classes and inheritance. PostgresQL runs major operating systems such as Linux, UNIX(Mac OSX, Solaris as well as Windows. It also supports for foreign keys, joins, triggers and stored procedures with multiple languages.

read more...