Databases and Data Warehouses

Combating California’s Drought: Big Data {Comments Off on Combating California’s Drought: Big Data}

By Arturo D.

Given the recent spurts of rain and snow across California, its easy to forget that we are still in fact suffering from one of the worst droughts in almost 100 years. Recent winter wet seasons in the past few years have been the driest on record since 1895 and experts estimate that it will take a ridiculous amount of precipitation in order for our reservoirs and lakes to reach their normal levels (Thibodeau, 2014). The big difference-maker and new weapon against droughts that didn’t exist decades ago is improving technology in the form of smart sensors for monitoring water usage and the collection of water data to create better usage reports, discover leaks in physical infrastructures and understand what regions are affected by prolonged droughts the most in order to create better conservation goals.


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.


In-memory Database {Comments Off on In-memory Database}

By Aaron C.

The explosion of data and the rise of big data leads to a tremendous need for large-capacity and efficient database management systems. The ability to handle large amounts of data, whether used for analytical or transactional processes, with speedy performance is essential. Traditionally, disk-based mechanisms would store their data onto a disk that is separate from the main memory. To access the data, the computer will need to read from the disk of which would create an I/O bottleneck. The advent of newer technology helps to eliminate the I/O bottleneck and increase data retrieval speed through the use of in-memory mechanisms.


Cloud Data Warehouses {Comments Off on Cloud Data Warehouses}

By Daniel A.

Data warehouses are quickly being prioritized as one of the forms for data which compromises of data marts, quality of data, and a great amount of information the user needs. There are many benefits to data warehousing and of course, there are many issues that come with data warehousing. The greatest benefit of data warehousing is the use for analysis of information and decision-making purposes.


CRM(Customer Relationship Management) {9}

The Customer relationship management (CRM) is about the management of the clientele, their records and their relation and to use this data to further develop the customer relation policies and management decisions. Basically the CRM is the integration of people, technology and the business process in the quest to protect the existing clientele and provide opportunities to further enhance the circle of customer’s satisfaction. According to the company Arvato a leader in CRM, “develops and operates customer clubs, customer loyalty programs, and individualized bonus programs for end customers and business partners, as well as carrying out special promotions and other personalized incentive arrangements.” So in the quote above the company states that without their CRM they would not be able to achieve customer clubs and loyalty program. CRM is the reason why such things as flyer miles and credit card points exist. The CRM is the catalyst that provides useful help about the customer and the business dimensions that is defined by the customer reviews and satisfactions. This useful information provides highly useful insight about the customer and their behaviors. This in turn helps the marketers establish their target audience and such.


Data Warehouse {2}

Data Warehouse

Data warehousing has been evolving since 2008 to analytical architecture that includes data marts, ETL, near line storage, exploration warehouses.

The SQL Server has also evolved since started with small amounts of data on a personal computer with basic functions until now that serves mid-size and large amounts of data for warehousing and it is one of the preferred technology platform for advanced data warehouse.


Mongo DB (No SQL database for web) {6}

Today’s highly social and interactive web has created a market for a database management system with the ability to offer fast real time access over the Internet while managing massive data sets that are growing by the minute in volume and complexity. MongoDB fills this need. As I will explain later in this blog, MongoDB is not the perfect solution for every project, but for certain tasks that are within it’s niche, it is the best solution.


How to become an Oracle DBA {3}

Last week I read and wrote about an article describing what a DBA’s job consists of, and the question arose of how a person might go about becoming a DBA. This week I read the article “How to become an Oracle DBA” by Burleson Consulting. The author starts off by listing the very generous salaries of DBA’s, which often start at around $100k/year and can reach up to $250k/year. While this is appealing, that salary doesn’t come easy. The author talks about the complex and specialized set of skills which are required. The main 3 points he brings up are outstanding communication, business degree, and of course DBA skills. The author also suggests taking courses such as Operations Research and getting Oracle certifications(however he later states in a comment on the article that certifications don’t mean much anymore).


Other People’s data {4}

In this peer reviewed journal, the author discusses about how every company bases some of it’s decisions on external data sources. There are so many data sources from publicly available web services, to sales data to government census data. There’s so much external data and the many ways to get it, it has to be treated differently than internal data. In order to accommodate every user’s data in a timely manner, there has to be a trade-off, where there are three, flexibility, quality and cost when it comes to data integration.


Oracle’s new Finance Data Warehouse {Comments Off on Oracle’s new Finance Data Warehouse}

Oracle begun offering a data warehouse for financial service industry. Oracle claimed that this data warehouse would be more geared towards the needs of the financial environment. This warehouse is specialized for financial organizations by making it easier to store financial data, generate reports, manage metadata and carry out any other financial data needs. Oracle developed this data warehouse for 15 years using a financial services data model so it can be used for analysis, testing, reporting and possible risks.