Research Paper (undergraduate) from the year 2015 in the subject Computer Science - Commercial Information Technology, grade: 1,0, University of Applied Sciences Ansbach, course: Wissentschaftliches Arbeiten, language: English, abstract: Nowadays, people produce large amounts of data with talking via smartphones, reading e-mails or using platforms to find the appropriate partner. Conventional technologies no longer cope with the increasing amount of data and come to their limits. Therefore new technologies of Big Data are required for data processing to overcome the data flood. At the beginning, this paper clarifies what Big Data is, the technologies of Big Data, how Big Data differs from Business Intelligence and a distinction is made between Data Warehouse and Business Intelligence. Furthermore, the theory of the Big Data technology in-memory analytics is explained and an implementation of this technology called SAP HANA is consulted and reviewed. In conclusion, the potential of in-memory analytics will be classified.
Studienarbeit aus dem Jahr 2016 im Fachbereich Informatik - Wirtschaftsinformatik, Note: 1,7, Duale Hochschule Baden-Württemberg, Ravensburg, früher: Berufsakademie Ravensburg (Wirtschaftsinformatik), Veranstaltung: Integrationsseminar zu ausgewählten Themen der WI, Sprache: Deutsch, Abstract: Mit dieser Arbeit soll untersucht werden, ob die In-Memory Technologie die beiden Welten verknüpfen kann. Im ersten Schritt wird die In-Memory Technologie kurz vorgestellt und es werden die Begrifflichkeiten Online Transactional Processing (OLTP) und Online Analytical Processing (OLAP) erläutert. Anschließend wird untersucht, ob eine reine OLAP-basierte Datenbank die transaktionalen Funktionalitäten abdecken kann und ob diese eine rein reihenbasierte Speicherung ersetzen kann. Nach dieser Untersuchung wird die hybride Struktur beleuchtet, ob sie die OLTP-basierten Datenbanken ablösen kann. Anschließend wird eine Bewertung dieser Möglichkeiten durchgeführt und ein Fazit gezogen.
Masterarbeit aus dem Jahr 2016 im Fachbereich Informatik - Wirtschaftsinformatik, Note: 1,3, Friedrich-Schiller-Universität Jena, Sprache: Deutsch, Abstract: Wachsende Datenströme und die damit verbundene Herausforderung einer effizienten Verwaltung deuten darauf hin, dass auch Datenbankmanagementsysteme (DBMS) vor einer Revolution stehen. Tape is Dead, Disk is Tape, Flash is Disk, RAM Locality is King. So beschrieb Gray, Informatiker und Wissenschaftler bei Microsoft Research, die zunehmende Verschiebung der Speicherhierarchie. Haben traditionelle DBMS noch Sekundärspeicher unter entweder zeilen- oder spaltenorientierter Datenorganisation verwendet, gebrauchen In-Memory Datenbanken (IMDB) Hauptspeicher und eine primär spaltenorientierte Datenorganisation. Damit soll es in Echtzeit möglich sein zum einen große Datenmengen auswerten und zum anderen die Informationen zum Zeitpunkt des Entstehens verarbeiten zu können. Verhinderte in den Achtziger Jahren die starke Unzuverlässigkeit des Hauptspeichers und das hohe Preisniveau die Etablierung von IMDB, so ist es heute möglich den Einsatz in Datenbanken ökonomisch zu legitimieren.
Pro SQL Server Administration brings SQL Server administration into the modern era with strong coverage of hybrid cloud environments, In-Memory OLTP, and installation on Server Core. This comprehensive guide to SQL Server Administration for todays DBA helps you to administer the new and key areas of SQL Server, including Columnstore indexes and the In-Memory OLTP feature set introduced in 2014. You will also be guided through the administration of traditional areas of SQL Server, including how to secure your instance, monitor and maintain your instance, and to use features such as AlwaysOn to make your instance highly available. Also covered is the use of SQL Server features to scale out read-only workloads. Pro SQL Server Administration is an all-new book taking up-to-date and modern approach that youll want and need to further your career as a SQL Server database administrator. Extensive coverage of hybrid cloud environments involving Azure SQL Database Detailed discussions on all new, key features, including AlwaysOn and in-memory support Comprehensive coverage of key skills, such as monitoring, maintenance and indexing Peter Carter is a SQL Server expert with over a decade of experience in developing, administering, and architecting SQL Server platforms and data-tier applications. Peter was awarded an MCC by Microsoft in 2011, to sit alongside his array of MCTS, MCITP, MCSA and MCSE certifications in SQL Server from version 2005, onward. His passion for SQL Server shows through in everything he does, and his goal is that his passion for the technology will inspire others.
Queries not running fast enough? Wondering about the in-memory database features in 2014? Tired of phone calls from frustrated users? Grant Fritchey’s book SQL Server Query Performance Tuning is the answer to your SQL Server query performance problems. The book is revised to cover the very latest in performance optimization features and techniques, especially including the newly-added, in-memory database features formerly known under the code name Project Hekaton. This book provides the tools you need to approach your queries with performance in mind. SQL Server Query Performance Tuning leads you through understanding the causes of poor performance, how to identify them, and how to fix them. You’ll learn to be proactive in establishing performance baselines using tools like Performance Monitor and Extended Events. You’ll learn to recognize bottlenecks and defuse them before the phone rings. You’ll learn some quick solutions too, but emphasis is on designing for performance and getting it right, and upon heading off trouble before it occurs. Delight your users. Silence that ringing phone. Put the principles and lessons from SQL Server Query Performance Tuning into practice today. Covers the in-memory features from Project Hekaton Helps establish performance baselines and monitor against them Guides in troubleshooting and eliminating of bottlenecks that frustrate users Sajal Dam holds a masters of technology degree in computer science from the Indian Institute of Science, Bangalore, and has been working with Microsoft technologies for over 12 years. He has developed an extensive background in designing database applications and managing software development. Sajal also possesses significant experience in troubleshooting and optimizing the performance of Microsoft-based applications, from front-end web pages to back-end databases. While working at Microsoft, Sajal helped many Fortune 500 companies design scalable database solutions and maximize the performance of their database environments. As an IT strategist at Dell, Sajal manages Dells vast database infrastructure by optimizing not only the databases, but also the database management processes, tools, and use of best practices. He also works closely with the application development teams and vendors, including Microsoft, in analyzing and resolving performance bottlenecks.
Charakteristika dieses Buches: - Begriffsdefinitionen - Umgang mit multidimensionalen Kennzahlen im Strategischen Management, in Planung & Controlling und im Kundenbeziehungsmanagement - Business Performance Management - Analytisches Berichtswesen - Szenarios - Produktplanung - Kampagnenmanagement - Information Supply Chain - Data Warehouse und OLAP - Multidimensionale Datenmodelle - Hierarchien - Data Cleansing - Extrahieren, Laden und Transformieren - Entwicklung Analytischer Systeme am Beispiel der Microsoft Services - In-Memory am Beispiel SAP-HANA - Zahlreiche Fallbeispiele
Solve your C programming problems with practical and informative recipes. This book covers various aspects of C programming including the fundamentals of C, operators and expressions, control statements, recursion, and user-defined functions. Each chapter contains a series of recipes that you can easily reference to quickly find the answers you are looking for. C Recipes also contains recipes and solutions for problems in memory management, arrays, standard input and output, structures and unions, pointers, self-referential structures, data files, pre-processor directives, and library functions. What You Will Learn Master operators and expressions Write user-defined functions Work with structures and unions Use pointers Define self referential structures Leverage library functions Who This Book Is For Those with some experience in C programming. Shirish Chavan is a writer, a teacher, a software consultant, a scientist, and an orator. He did M.Sc. in Theoretical Physics from Shivaji University, Kolhapur in 1982. He has been teaching Physics and Computer Science in various colleges since past thirty years. As an orator he has delivered hundreds of speeches on various subjects. As a scientist, he is having one discovery and two inventions to his credit. As a writer his eight books are published by reputed publishers and three of them were bestsellers in India for a limited period.
Programming in GW-BASIC provides a reference guide on GW-Basic along with a range of extra commands and functions. The book discusses starting a program, program planning and the essentials of GW-Basic, including the most commonly used commands; how data is stored in memory; how a program fits together; and the use of the keyboard and screen in editing. The text also describes graphics and color and the string-handling functions. The principles and concepts of program structures, such as the Paintbox program and chaining, and the use of the Turtle graphics, such as Logo and DRAW, are also considered. The book covers two of the key techniques for handling data in quantity (sorting into order and searching for specific items), statistical analysis, and display program. The text then tackles PEEK and POKE, which examine sections of memory and serve as alternative to PRINT for creating screen displays, and advanced graphics, which enables one to analyze the screen, develop first a double-size print utility, then a sprite designer and some movement routines. The selection is useful to computer programmers and students taking computer courses.
Im Buch beschreiben Dr. Heinz Kabutz und Sven Ruppert die Realisierung einer ganzen Palette von verschiedenen Proxies und liefern den Lesern zahlreiche Anregungen, wo und wie solche Proxies verwendet werden können. Darüber hinaus demonstrieren die Autoren, wie man durch das In-Memory-Kompilieren von dynamisch generiertem Quelltext die Vorteile eines Dynamic Proxy mit den Vorteilen von statisch kompilierten Proxies kombinieren kann, um ebenso performanten wie wartbaren Code zu erzeugen. Ferner besprechen die Java-Experten die Verbindung von Dynamic Proxies mit CDI und gehen der Frage nach, wie man mit der Methode equals bei Proxies umgehen sollte. Zum optimalen Verständnis sollten die Leser grundlegendes Wissen über Entwurfsmuster und spezielles Wissen über die strukturellen Muster Proxy, Object Adapter, Composite und Decorator mitbringen. Dr. Heinz Kabutz schreibt den Java Specialists Newsletter, der heutzutage in 134 Ländern der Welt gelesen wird, was selbst McDonalds nicht schafft. Seine besonderen Interessen sind fortgeschrittenes Java, Concurrency, Performanz und Kochen. Sven Ruppert arbeitet als Principal IT Consultant bei der codecentric AG am Standort München, spricht seit 1996 Java und arbeitet seitdem in nationalen und internationalen Projekten. In seiner Freizeit entwickelt er an seinem Projekt www.rapidpm.org und hält Vorträge bei JUGs.
Learn effective and scalable database design techniques in a SQL Server 2016 and higher environment. This book is revised to cover in-memory online transaction processing, temporal data storage, row-level security, durability enhancements, and other design-related features that are new or changed in SQL Server 2016. Designing an effective and scalable database using SQL Server is a task requiring skills that have been around for forty years coupled with technology that is constantly changing. Pro SQL Server Relational Database Design and Implementation covers everything from design logic that business users will understand, all the way to the physical implementation of design in a SQL Server database. Grounded in best practices and a solid understanding of the underlying theory, Louis Davidson shows how to get it right in SQL Server database design and lay a solid groundwork for the future use of valuable business data. The pace of change in relational database management systems has been tremendous these past few years. Whereas in the past it was enough to think about optimizing data residing on spinning hard drives, today one also must consider solid-state storage as well as data that are constantly held in memory and never written to disk at all except as a backup. Furthermore, there is a trend toward hybrid cloud and on-premise database configurations as well a move toward preconfigured appliances. Pro SQL Server Relational Database Design and Implementation guides in the understanding of these massive changes and in their application toward sound database design. Gives a solid foundation in best practices and relational theory Covers the latest implementation features in SQL Server 2016 Helps you master in-memory OLTP and use it effectively Takes you from conceptual design to an effective, physical implementation What You Will Learn Develop conceptual models of client data using interviews and client documentation Recognize and apply common database design patterns Normalize data models to enhance scalability and the long term use of valuable data Translate conceptual models into high-performing SQL Server databases Secure and protect data integrity as part of meeting regulatory requirements Create effective indexing to speed query performance Who This Book Is For Programmers and database administrators of all types who want to use SQL Server to store data. The book is especially useful to those wanting to learn the very latest design features in SQL Server 2016, features that include an improved approach to in-memory OLTP, durability enhancements, temporal data support, and more. Chapters on fundamental concepts, the language of database modeling, SQL implementation, and of course, the normalization process, lay a solid groundwork for readers who are just entering the field of database design. More advanced chapters serve the seasoned veteran by tackling the very latest in physical implementation features that SQL Server has to offer. The book has been carefully revised to cover all the design-related features that are new in SQL Server 2016. Louis Davidson has been in the IT industry for more than 15 years as a corporate database developer and architect. He has spent the majority of his career working with Microsoft SQL Server, beginning from the early days of version 1.0. He has a bachelor s degree from the University of Tennessee at Chattanooga in computer science, with a minor in mathematics. Louis is the data architect for Compass Technology in Chesapeake, Virginia, leading database development on their suite of nonprofit oriented CRM products, built on the Microsoft CRM platform and SQL Server technologies. Jessica Moss is a well-known architect, speaker, author, and Microsoft Most Valuable Professional of SQL Server business intelligence. Jessica has created numerous data warehousing solutions for companies in the retail, Internet, health services, finance, and energy industries, and has authored technical content for multiple magazines, websites, and the book Microsoft SQL Server 2008 Integration Services: Problem-Design-Solution. Jessica enjoys working with the central Virginia community and speaks regularly at user groups, code camps, and conferences. You can read more on her website.