Database Design and Development

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...

Big Data in Legal Profession {Comments Off on Big Data in Legal Profession}

By Sophia C.

Because of the fast growth of information, Big Data became more powerful and has been utilized by businesses, government, healthcare system, social media and technology to research in order to achieve desired outcomes. For instance, government benefited from Big Data in election campaigns, cost and time reduction, while healthcare system adopted Big Data analytics to “predict epidemics, cure disease, improve quality of life and avoid preventable deaths” (Marr, 2015). More than that, Big Data also supports decision-making and shapes the way people learn and teach nowadays. “Educational researcher can now track student achievement in online courses, where monitoring the progress of masses of students in real time can make research more conclusive” (Metz, 2015). Like other fields, legal system creates “ever-increasing amount of data,” and legal professionals realized that “witness statement, court logs and judge’s summaries [would] be hidden facts and insight that could help win legal arguments” (Marr, 2016). Therefore, they apply Big Data analytics into legal profession with a hope to seek for an improvement in justice system. read more...

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. read more...

Data Mining Improves Product Development {Comments Off on Data Mining Improves Product Development}

By Michael C.

Data mining has demonstrated its value in business settings. Data mining is a collective term that describes different analysis techniques, used to scan large amounts of data (Lee, 2013). Data mining techniques that are related to association, allow businesses, such as retailers to cross sell products more efficiently. By finding relationships that we would normally miss or not see at all, data analysis has been used to improve marketing techniques. These same missed connections or relationships, improve product development. Using data mining, companies improve their product development process, by finding what their current products lack. Just like it does in other aspects of the business, data mining and analysis help improve decision-making. By using data mining to identify what a product a lacking, companies could develop products more effectively. read more...

Database Security {Comments Off on Database Security}

By Henry B.

As the world evolves and technology grows, it is essential for businesses to rely on the use of the web and databases to store their company’s personal information. However, a new threat is growing each year as companies are getting hacked and personal information is leaked. The extra technical time a company spends on making sure that their web servers and databases are secure outweighs the major consequences that can result from not having a properly secured database. Implementing ways of securing a company’s database can help maintain the company’s reputation and keep the continuous flow of operations ensuring long-term survival and profits over time. read more...

Databases in Action: A K-12 Education Environment {Comments Off on Databases in Action: A K-12 Education Environment}

By Hector A.

In today’s modern world, databases are essential to effectively store and organize data among businesses and corporations. It is important to note that there is a growing need for database information systems in a certain non-profit/government environment. K12 education is a vital component of our nation’s education system. Before any student can transition into higher education, they must complete K12 in order to be well prepared for the challenges ahead in a university environment. Approximately 33 million students are enrolled in a grade school environment (US Census, 2010). Each student is typically tracked for attendance, grading, or disciplinary matters and stored in a permanent record. Teachers and administrators constantly access and update such data on a daily basis. However, school districts across the nation continuously search for better ways to store, track, and input data for these students using a variety of different ways. It is not surprising to note why school districts across the nation have begun switching from traditional pencil-paper-folder record keeping methods over to modern database systems to better efficiently track and update constantly changing data. read more...

GitHub {14}

by Jason Y
GitHub can be easily labeled as a distributed version control system, but GitHub is so much more than that. GitHub is a powerful collaboration and code management tool for open source and private projects. GitHub allows multiple people to work in friction-less development environments. People are able to work together on projects in organizations and communicate between each other with ease. With GitHub people are able to browse multiple repositories, create and manage different branches, and save changes both locally and on public servers. GitHub also leaves a paper trail so people it becomes easier to see who made what kind of changes to source codes. read more...

A Career in Databases {18}

by Kyle Y
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}

by Edmund V
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...

DuckDuckGo: Search Anonymously, Find Instantly. {19}

by Justin U
DuckDuckGo is a startup is a search engine startup that is rivaling that of Google.  The creator, Gabriel Weinberg, didn’t originally want to create a search engine.  It was more a culmination of failed ideas combined to create this alternative way to find information on the web.  By combining these ideas he has created a unique search experience that helps you find instant answers, private searches, along with your usual link-by-link results. read more...