Search
Search Results
-
Indexes and Statistics
Recent versions of SQL Server support many different types of index that are used to enhance query performance. These include traditional clustered...
-
Infrastructure for MLOps
This chapter is about infrastructure. You might think of buildings and roads when you hear the word infrastructure, but in MLOps, infrastructure...
-
In-memory database acceleration on FPGAs: a survey
While FPGAs have seen prior use in database systems, in recent years interest in using FPGA to accelerate databases has declined in both industry and...
-
Modern Data Warehouses
In the last decade, numerous technology updates have happened in the area of data warehousing. In addition, customer expectations increase with each...
-
Data Warehouse Systems Design and Implementation
With this textbook, Vaisman and Zimányi deliver excellent coverage of data warehousing and business intelligence technologies ranging from the most...
-
Real-Time Analytics: Benefits, Limitations, and Tradeoffs
AbstractReal-time analytics is a relatively new branch of analytics. A common definition of real-time analytics is that it consists in analyzing data...
-
Foresight plus: serverless spatio-temporal traffic forecasting
Building a real-time spatio-temporal forecasting system is a challenging problem with many practical applications such as traffic and road network...
-
Big Data in Smart Ecosystems: Trends, Challenges and Future Prospectus
Technology is transmuting the world. The rapid use of mobile devices and explosion of social media has given rise to the storm that is engulfing the...
-
S3QLRDF: distributed SPARQL query processing using Apache Spark—a comparative performance study
The proliferation of semantic data in the form of Resource Description Framework (RDF) triples demands an efficient, scalable, and distributed...
-
The Query Optimizer
Query optimizers reduce the cost of queries while retaining the original intended functionality. Furthermore, query optimization seeks to reduce the...
-
Balanced parallel triangle enumeration with an adaptive algorithm
Triangle enumeration is a foundation brick for solving harder graph problems related to social networks, the Internet and transportation, to name a...
-
A fundamental approach to discover closed periodic-frequent patterns in very large temporal databases
Periodic frequent-pattern mining (PFPM) is a vital knowledge discovery technique that identifies periodically occurring patterns in a temporal...
-
Solution Architecture
In this chapter, we define the solution architecture for embedding artificial intelligence into ERP software. The previously discussed ERP product...
-
Solve Challenging Problems with Arcane SQL Features
It’s time to discuss the most advanced Oracle features, the features that solve problems most developers think are impossible to solve in a database.
-
Using Pregel to Create Knowledge Graphs Subsets Described by Non-recursive Shape Expressions
Knowledge Graphs have been successfully adopted in recent years, existing general-purpose ones, like Wikidata, as well as domain-specific ones, like...
-
Implementing the Comparison-Based External Sort
In the age of big data, sorting is an indispensable operation for DBMSes and similar systems. Having data sorted can help produce query plans with...
-
Revisiting Approximate Query Processing and Bootstrap Error Estimation on GPU
Sampling-based Approximate Query Processing (AQP) is one of the promising approaches for timely and cost-effective analytics over big data. There are...
-
Advanced Database Techniques and Optimization
In the previous chapter, we explored the exciting realm of advanced frontend development with Laravel, empowering us to create modern and interactive...
-
Revisiting Data Compression in Column-Stores
Data compression is widely used in contemporary column-oriented DBMSes to lower space usage and to speed up query processing. Pioneering systems have...
-
Big Data Database for Business
Key-value databases, one of the most common NoSQL (Not only SQL), are essentially shared sorted arrays or distributed hash tables. The hash table is...